1054 Unknown column 'user_custom_title' in 'field list'

Discussion on a SQL Parser for EasyMOD
Locked
pic
Registered User
Posts: 22
Joined: Thu Dec 21, 2006 10:13 pm

1054 Unknown column 'user_custom_title' in 'field list'

Post by pic »

Could not insert data into users table

DEBUG MODE

SQL Error : 1054 Unknown column 'user_custom_title' in 'field list'

INSERT INTO phpbb_users (user_id, username, user_regdate, user_password, user_email, user_icq, user_website, user_occ, user_from, user_interests, user_custom_title, user_sig, user_sig_bbcode_uid, user_avatar, user_avatar_type, user_viewemail, user_aim, user_yim, user_msnm, user_attachsig, user_allowsmile, user_autospell, user_allowhtml, user_allowbbcode, user_allow_viewonline, user_notify, user_notify_pm, user_popup_pm, user_timezone, user_dateformat, user_show_quickreply, user_quickreply_mode, user_open_quickreply,user_lang, user_style, user_level, user_allow_pm, user_active, user_actkey) VALUES (3, 'Mod', 1166738687, '3d801aa532c1cec3ee82d87a99fdf63f', '[email protected]', '', '', '', '', '', '','', '', '', 0, 0, '', '', '', 1, 1, 1, 0, 1, 1, 0, 1, 1, 0, 'D M d, Y g:i a', 1, 1, 1,'english', 1, 0, 1, 1, '')

Line : 652
File : usercp_register.php

What should I do to fix this? It appeared when I tried registering a user for a test on a mod.

Nightrider
Registered User
Posts: 7219
Joined: Tue Nov 16, 2004 8:54 pm
Location: Florida, US
Contact:

Re: 1054 Unknown column 'user_custom_title' in 'field list'

Post by Nightrider »

In the MOD Authors notes, you will see this:
Author Notes: Please see the accompanying README_FIRST.txt for VERY important information.

Then if you read the README_FIRST.txt file, you would see this:
3. Place the included title_install.php into your root phpBB directory, and then run it. This will make the necessary database alterations. When it has completed, make sure it didn't report any errors, and then delete the file. WARNING: FAILURE TO DELETE THIS FILE MAY PUT YOUR FORUM, SITE, AND SERVER AT A POTENTIAL SECURITY RISK.

So upload the title_install.php file to your phpBB folder and run it from your browser. The path could look something like this in your browser:

Code: Select all

http://yourdomain.com/phpBB2/title_install.php
Then delete the title_install.php file from your phpBB forum folder...

Image

pic
Registered User
Posts: 22
Joined: Thu Dec 21, 2006 10:13 pm

Re: 1054 Unknown column 'user_custom_title' in 'field list'

Post by pic »

I think it happened because I installed a custom title mod, then removed it. How can I fix it?

http://www.phpbb.com/phpBB/viewtopic.php?t=128153

This is the custom title mod ^^

Nightrider
Registered User
Posts: 7219
Joined: Tue Nov 16, 2004 8:54 pm
Location: Florida, US
Contact:

Re: 1054 Unknown column 'user_custom_title' in 'field list'

Post by Nightrider »

Did you read my message above? I told you how to resolve this problem in my previous message...

Image

Locked