Problem with upgrade


New member
i've upgraded to version 1

the previous install was empty (eg. i'd installed it but never done anything with it)

however now in admin.php if i click users i get an error:

where myDB = my database name

Server Error

Mysqli prepare error: Table 'myDB.xf_ip_match' doesn't exist
Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 825
Zend_Db_Adapter_Abstract->fetchOne() in XenForo/Model/Banning.php at line 134
XenForo_Model_Banning->countBannedIps() in XenForo/ControllerAdmin/User.php at line 70
XenForo_ControllerAdmin_User->actionIndex() in XenForo/FrontController.php at line 310
XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 132
XenForo_FrontController->run() in /var/www/html/london/ at line 13


XenForo moderator
Staff member
Hmmm, this error seems to be saying the xf_ip_match table doesn't exist.

What version did you upgrade from?

Is there any data or content in your installation?
It might be easier to just purge the database completely (drop the tables) and reinstall.

Edit: Just seen your latest post after I submitted.


New member
no data or content, i just played around with the colours.

so you mean drop the tables directly on the dbserver - and do a clean install?


XenForo moderator
Staff member
If there's nothing in the DB then that would be my approach.

You will need to remove the internal_data/install-lock.php file though.

Or you can download the full package, wipe your server and DB, upload the full package and start from scratch.