Contact Admin Extension - SQL ERROR [ mysqli ] - Column 'user_ip' cannot be null

Support for mods released by phpbbmodders.net found at either https://github.com/phpbbmodders/ or the MODDB at http://www.phpbb.com
Forum rules
Please only request support for mods released by phpbbmodders.net found at either https://github.com/phpbbmodders/ or the MODDB at http://www.phpbb.com
Post Reply
User avatar
wads24
New member
New member
Posts: 2
Joined: 25 Mar 2009, 02:31

Contact Admin Extension - SQL ERROR [ mysqli ] - Column 'user_ip' cannot be null

Post by wads24 »

I got this extension from: https://www.phpbb.com/customise/db/mod/ ... istration/

When someone is not logged into the forum they get this error when submitting form. If they are logged in, then the form works.
General Error
SQL ERROR [ mysqli ]

Column 'user_ip' cannot be null [1048]

An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.


RMcGirr83 said that is was a left over column from an older version, and told me to go under the phpbb_posts table, and drop the user_ip column. I couldn't find that column under the posts table though. I did find a "user_ip" under phpbb_users table. Should I drop that column "user_ip" in the phpbb_users table? Any other suggestions?

Has anyone else had this issue? Thanks for any help in advance?
User avatar
Sniper_E
MOD Team
MOD Team
Posts: 591
Joined: 13 Jun 2011, 16:53
Location: Shreveport, LA
Contact:

Re: Contact Admin Extension - SQL ERROR [ mysqli ] - Column 'user_ip' cannot be null

Post by Sniper_E »

Do not drop the "user_ip" under phpbb_users table.
Rich can help you with dropping the correct user_ip column for that extention.
No is NEVER an Option and NEVER is the only Option when it comes to Giving Up!
User avatar
Sniper_E
MOD Team
MOD Team
Posts: 591
Joined: 13 Jun 2011, 16:53
Location: Shreveport, LA
Contact:

Re: Contact Admin Extension - SQL ERROR [ mysqli ] - Column 'user_ip' cannot be null

Post by Sniper_E »

wads24 wrote:I got this extension from: https://www.phpbb.com/customise/db/mod/ ... istration/
Just looked back at this... Man that is a phpbb 3.0 extension.
3.1 and 3.2 have come out since then. lol don't be messing with that old stuff :D
No is NEVER an Option and NEVER is the only Option when it comes to Giving Up!
Post Reply