MySQL statement prepare error [1054]

Linda

Well-known member
Registered
Joined
Oct 22, 2021
Messages
110
Points
38

Reputation:

I get this error message.
Does anyone have a hint?
PHP:
XF\Db\Exception: MySQL statement prepare error [1054]: Unknown column 'andrew_forced' in 'field list' 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 41
XF\Db\Mysqli\Statement->prepare() in src\XF\Db\Mysqli\Statement.php at line 56
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 1516
XF\Mvc\Entity\Entity->_saveToSource() in src\XF\Mvc\Entity\Entity.php at line 1248
XF\Mvc\Entity\Entity->save() in src\XF\Service\User\Ignore.php at line 35
XF\Service\User\Ignore->ignore() in src\XF\Pub\Controller\Member.php at line 609
XF\Pub\Controller\Member->actionIgnore() 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 2353
XF\App->run() in src\XF.php at line 524
XF::runApp() in index.php at line 20
 

sucre13

Moderator
Staff member
Moderator
Collaborate
Registered
Joined
Jan 19, 2019
Messages
844
Points
153

Reputation:

What did you install before you got that error?
 

Linda

Well-known member
Registered
Joined
Oct 22, 2021
Messages
110
Points
38

Reputation:

I have switched to a VPS.
I was able to import the database without any error message.
Finally I uploaded the installation to the server, all data was uploaded completely.

The forum is also running without any problems. I find the message strange.
 

Linda

Well-known member
Registered
Joined
Oct 22, 2021
Messages
110
Points
38

Reputation:

The error is fixed.
I deactivated all plugins and imported everything again. Restarted VPS and gradually re-enabled the plugins.

The "Moderator Panel 1.6.0" caused the error. There was an update 1.6.2 available. I have installed it. Now it works again.
 
Top