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.
1054 Unknown column 'user_custom_title' in 'field list'
-
- 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'
In the MOD Authors notes, you will see this:
Then if you read the README_FIRST.txt file, you would see this:
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:
Then delete the title_install.php file from your phpBB forum folder...
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
Re: 1054 Unknown column 'user_custom_title' in 'field list'
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 ^^
http://www.phpbb.com/phpBB/viewtopic.php?t=128153
This is the custom title mod ^^
-
- 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'
Did you read my message above? I told you how to resolve this problem in my previous message...