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
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

Postby wads24 » 30 Mar 2017, 16:22

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

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

Postby Sniper_E » 25 May 2017, 04:15

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

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

Postby Sniper_E » 25 May 2017, 22:40

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!


Return to “Modders MOD support”

Who is online

Users browsing this forum: CommonCrawl [Bot] and 8 guests