Table 'xf_permission_combination' doesn't exist

[hultberg]

Hey, my forum www.buildnorge.no dosen't work right now because of this error:

Failed to get controller response and reroute to error handler (EWRporta_ControllerPublic_Portal::action)
An exception occurred: Mysqli prepare error: Table 'buildnorge.xf_permission_combination' doesn't exist in /home/4/b/buildnorge/www/library/Zend/Db/Statement/Mysqli.php on line 77

1. Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
2. Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
3. Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
4. Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 825
5. Zend_Db_Adapter_Abstract->fetchOne() in XenForo/Model/User.php at line 815
6. XenForo_Model_User->setPermissionsOnVisitorArray() in XenForo/Model/User.php at line 790
7. XenForo_Model_User->getVisitingGuestUser() in XenForo/Visitor.php at line 395
8. XenForo_Visitor::setup() in XenForo/Session.php at line 204
9. XenForo_Session::startPublicSession() in XenForo/Controller.php at line 286
10. XenForo_Controller->_setupSession() in XenForo/Controller.php at line 298
11. XenForo_Controller->preDispatch() in XenForo/FrontController.php at line 309
12. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 132
13. XenForo_FrontController->run() in /home/4/b/buildnorge/www/index.php at line 13

Im very new to xenforo because the old manager of the forum has quit so please helt me a little here, what to do?

 

[Paul B]

It's a xenporta error it appears.

Have you been editing the database at all or made any changes recently?

 

[hultberg]

It's a xenporta error it appears.

Have you been editing the database at all or made any changes recently?

No, the database has not been edited after what I know. But conserning this error someone has been editing. Password is changed just for security.

 

[ThunderBird2]

hultberg, can you go to your admin.php to uncheck the box- Set as Index Controller, it will show up as your homepage.

 

[hultberg]

hultberg, can you go to your admin.php to uncheck the box- Set as Index Controller, it will show up as your homepage.

If you see at http://www.buildnorge.no/admin.php I can't access it..

 

[Paul B]

When did the problem start?

What was the last thing which was changed just prior?

 

[hultberg]

Just recently I added a new rank and changed that ranks permissions. The most recent thing I can remember berfore this error came.

 

[Paul B]

If the table is really missing then you will need to restore from a backup.

Log in to phpMyAdmin and check whether there are any other tables missing.

 

[hultberg]

If the table is really missing then you will need to restore from a backup.

Log in to phpMyAdmin and check whether there are any other tables missing.

I can't see any other, and the table is not there at all. Where can I find "backup?" I have not been managing the forum before as said before.

 

[Paul B]

It's going to be extremely difficult, if not impossible to rebuild the table if you don't have a backup.

You will need to contact the host or previous owner.

 

[ThunderBird2]

Interesting, just get rid of all files and re-store XenForo folders on your FTP, make sure it is working properly before uploading Porta, which itself complicated and annoying bugs.

 

[Paul B]

That won't help at all.
The xf_permission_combination table is a core table.

 

[hultberg]

There is no other way of rebuilding there mysql tables? Or is there somewhere I can lookup in the code when installing for the queries?

 

[Paul B]

The permission table is populated automatically based on users, user groups and permissions as you define them and the data is stored in blob format.

You need to get hold of a backup and determine how and when the table was deleted.

 

[TPerry]

There is no other way of rebuilding there mysql tables? Or is there somewhere I can lookup in the code when installing for the queries?

Rule #1 - regularly back up your database.
Rule #2 - refer to rule #1.
I run on a VPS and this is what I use now http://xenforo.com/community/resources/sypex-dumper-backup-and-restore-your-database.1102/
Before that I just used phpMyAdmin.
I'm in the process of setting up a cron job to just use mysqldump to automate the process and rsync with another server I have.