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

XF 1.2 1.2.3 - Installation Server Error

Discussion in 'Installation, Upgrade, and Import Support' started by Disciple of Nagash, Nov 8, 2013.

  1. Disciple of Nagash

    Disciple of Nagash Active Member

    Hi,

    When attempting to install a new copy of XF on an empty database I get the following error:

    Server Error
    Mysqli statement execute error : Table 'xf_moderation_queue' already exists

    1. Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 317
    2. Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479
    3. Zend_Db_Adapter_Abstract->query() in XenForo/Install/Model/Install.php at line 182
    4. XenForo_Install_Model_Install->createApplicationTables() in XenForo/Install/Controller/Install.php at line 206
    5. XenForo_Install_Controller_Install->actionStep2() in XenForo/FrontController.php at line 337
    6. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
    7. XenForo_FrontController->run() in /home/demovamp/public_html/install/index.php at line 18
    The only tables present are the ones the installer created itself, so I am not sure why I am getting this error?

    Cheers

    DoN
     
  2. Chris D

    Chris D XenForo Developer Staff Member

    Invariably that error can only be thrown if the table does actually exist.

    To be sure, I would delete that database and recreate a new one.

    Then let us know if the problem persists.

    Also: Be sure that you have configured your config.php file during installation to point to the correct server and database. If you've copied files across from another installation on the same server, it may be trying to use that database than the blank one.

    Easiest way to be sure is to delete the config.php file and let it be created during install and double check all the MySQL database and credentials are correct.
     
  3. Disciple of Nagash

    Disciple of Nagash Active Member

    Thanks for the info @Chris Deeming

    I carried out the following steps:

    • Deleted config.php
    • Deleted database
    • Created new database
    • Started installation - put in new database details
    • Begin installation - OK
    • Create Tables - returned the following error:
    Server Error
    Mysqli statement execute error : Table 'xf_content_type_field' already exists

    1. Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 317
    2. Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479
    3. Zend_Db_Adapter_Abstract->query() in XenForo/Install/Model/Install.php at line 182
    4. XenForo_Install_Model_Install->createApplicationTables() in XenForo/Install/Controller/Install.php at line 206
    5. XenForo_Install_Controller_Install->actionStep2() in XenForo/FrontController.php at line 337
    6. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
    7. XenForo_FrontController->run() in /home/demovamp/public_html/install/index.php at line 18
    The database was definitely new and empty - it can't be accessing any other database because they have different user access, plus do not have any XF tables.
     
  4. Mike

    Mike XenForo Developer Staff Member

    Does it return that immediately or does the page appear to refresh first?
     
    Chris D likes this.
  5. Disciple of Nagash

    Disciple of Nagash Active Member

    It appears to refresh for about 2-3 seconds and then returns that error.
     
  6. Mike

    Mike XenForo Developer Staff Member

    Can you submit a ticket with FTP details (and URL) so I can look into it?

    1.2.3 has a new system to help the installation complete on slower servers. I have used it without issue before but I'm wondering if there's an issue with it on your server.
     
    Liam W and Chris D like this.
  7. Disciple of Nagash

    Disciple of Nagash Active Member

    @Mike I've created the ticket as per request - sorry for the delay.
     

Share This Page