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

Problem with upgrade

Discussion in 'Installation, Upgrade, and Import Support' started by mungo, Mar 22, 2011.

  1. mungo

    mungo 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/lovelondon.com/discuss/admin.php at line 13
  2. mungo

    mungo New Member

    ps. i upgraded from 1.00 Beta 5
  3. Brogan

    Brogan 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.
  4. mungo

    mungo 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?
  5. Brogan

    Brogan 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.
  6. mungo

    mungo New Member

    thanks i removed:


    did a reinstall and all is well
  7. Brogan

    Brogan XenForo Moderator Staff Member

    Glad to hear it :)

Share This Page