XenForo Issues after database restore

[nathanw]

After restoring the XF database, I'm having a two issues I haven't been able to solve:

1. Server error
   Code:
   
   XF\Db\InvalidQueryException: Template public:approval_item_user error: MySQL statement prepare error [1176]: Key 'user_id_log_date' doesn't exist in table 'xf_ip' src/XF/Db/AbstractStatement.php:230
   In table xf_ip, the column user_id_log_date exists, but it is set as INT(11) with a default value of null. Can someone please confirm how this column should be configured?
2. The...

Read more

Continue reading...