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]

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

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]

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.

XF 2.1 - Replace text directly from database

Hi , Any usefull query to change some text from threads directly from database (via phpmyadmin) ? eg. change textABC to ABC123 . I know that exists an addon (find and replace) but i dont understand it at all . Thanks.

xenforo.com

 

[Paul B]

^ That.

The error you have posted is almost certainly due to a corrupt/incomplete dump or restore.