MySQL TMP tables - already exists

  • V-Box testing environment - i-MSCP 1.1.1 migration to i-MSCP 1.3.1
    i-MSCP 1.1.1
    Build: 20140216


    setup fails because of roundcube TMP tables error ...

    Code
    1. [ERROR] main::setupUpdateDatabase: [ERROR] Database update 237 failed: SQLSTATE[42S01]: Base table or view already exists: 1050 Table '`ispcp`.`domain_traffic_tmp2`' already exists
    2. autoinstaller::Functions::install: An error occurred while performing installation steps


    also if I drop these tmp table/s and re-run setup it has been re-created ..

  • @fulltilt


    The ispcp.domain_traffic_tmp2 is not a Roundcube table. This is an temporary table created by the i-MSCP database updater to remove duplicate entries... I don't really know what you do with your server but it seem that you play wrong...


    Could you give me an access to the server, then I could fix your setup.

    badge.php?id=1239063037&bid=2518&key=1747635596&format=png&z=547451206