XF 2.2 XF\Db\Exception: MySQL query error [1048]: Column 'ip_id' cannot be null in src/XF/Db/AbstractStatement.php at line 230

gavpeds

Active member
Any ideas? I just downloaded my database and changed some old URLs which had beta.mydomain.com to remove the beta. as the content does not exist there anymore it exists on the main domain.

Anyway re uploading the DB has thrown this error

Code:
XF\Db\Exception: MySQL query error [1048]: Column 'ip_id' cannot be null in src/XF/Db/AbstractStatement.php at line 230
XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 198
XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 79
XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 220
XF\Db\AbstractAdapter->insert() in src/XF/Mvc/Entity/Entity.php at line 1514
XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1246
XF\Mvc\Entity\Entity->save() in src/XF/Repository/Ip.php at line 31
XF\Repository\Ip->logIp() in src/XF/ControllerPlugin/Login.php at line 201
XF\ControllerPlugin\Login->completeLogin() in src/XF/Pub/Controller/Login.php at line 115
XF\Pub\Controller\Login->actionLogin() in src/XF/Mvc/Dispatcher.php at line 352
XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2351
XF\App->run() in src/XF.php at line 517
XF::runApp() in index.php at line 20
 

briansol

Well-known member
Not the answer to your question, but dl/upload your db to make a change is a horrible/scary practice.

Learn to use update/replace statements to make text changes.
 
Top