• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

XF 1.5 Switched to a new server and get the following SERVER ERROR

Donny

Active member
#1
Server Error
Mysqli statement execute error : Field 'ip_id' doesn't have a default value

  1. Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 297
  2. Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479
  3. Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 574
  4. Zend_Db_Adapter_Abstract->insert() in XenForo/Model/Ip.php at line 49
  5. XenForo_Model_Ip->logIp() in XenForo/Model/Ip.php at line 63
  6. XenForo_Model_Ip::log() in XenForo/Session.php at line 369
  7. XenForo_Session::getPublicSession() in XenForo/ControllerAdmin/Login.php at line 7
  8. XenForo_ControllerAdmin_Login->actionForm() in XenForo/FrontController.php at line 351
  9. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
  10. XenForo_FrontController->run() in /var/www/vhosts/domain.co.uk/httpdocs/admin.php at line 13
Anybody know what this might entail?
I seem to be able to run a fresh install in a folder, but not get an existing forum running.
 
Last edited:

Brogan

XenForo moderator
Staff member
#2
How did you do the dump and restore of the DB?

Typically, if it was working previously and isn't now, then it would suggest issues related to that.
In most cases, it is caused by using phpMyAdmin to do the dump and restore, rather than SSH.
 

Brogan

XenForo moderator
Staff member
#4
The other possibility is it is caused by an add-on adding a field without a default value and that add-on is disabled.
Did you disable any add-ons as part of the move?
 

Donny

Active member
#5
Didn't specifically disable any no. But there were some I had disabled a month or so ago. Should I have removed them fully or something beforehand?
 

Donny

Active member
#6
I have one forum nearly working fully.
When viewing a thread i have Mysqli statement execute error : Field 'thread_read_id' doesn't have a default value.

I've disabled add-ons via config and it's still pushing out the same error. I can login admin but not much works without throwing a similar error.

: Field 'deferred_id' doesn't have a default value

Seems various fields have no default value.
 

Brogan

XenForo moderator
Staff member
#7
I can only assume something has gone wrong during the dump and restore, if all you did was switch servers.

You may need to do it again.
 

Mike

XenForo developer
Staff member
#8
Almost certainly a dump issue. Specifically, it looks like it has dropped the auto_increment setting from a bunch of tables.

I don't know what settings you're using on the dump, but I'd check to make sure there are no "compatibility" options selected.
 

Donny

Active member
#9
Thanks lads. I'm relaying this to the server management guy. Who's as frustrated as myself it seems, but perhaps just isn't an XF guru.