Jump to content

error (1050): table 'core_contact_verify' already exists after upgrade

PanSevence

By PanSevence

  • Status: Not a bug

After completing the upgrade process on my forum, I encountered the following error:

Error (1050) Table 'core_contact_verify' already exists: createTable [{"name":"core_contact_verify","columns":{"email_address":{"name":"email_address","type":"VARCHAR","length":255,"decimals":null,"values":null,"allow_null":false,"default":"","comment":"","unsigned":false,"auto_increment":false},"verify_key":{"name":"verify_key","type":"VARCHAR","length":255,"decimals":null,"values":null,"allow_null":false,"default":"","comment":"","unsigned":false,"auto_increment":false},"verify_time":{"name":"verify_time","type":"BIGINT","length":null,"decimals":null,"values":null,"allow_null":false,"default":0,"comment":"","unsigned":false,"auto_increment":false},"contact_data":{"name":"contact_data","type":"MEDIUMTEXT","length":0,"decimals":null,"values":[],"allow_null":false,"default":null,"comment":"","unsigned":false,"auto_increment":false}},"indexes":{"PRIMARY":{"type":"primary","name":"PRIMARY","columns":["email_address"],"length":[250]}},"engine":"InnoDB"}]  

#0 system/Application/Application.php(1770): IPS\Log::log()  

#1 applications/core/sources/Setup/Upgrade.php(565): IPS\Application->installDatabaseUpdates()  

#2 applications/core/sources/Setup/Upgrade.php(369): IPS\core\Setup\Upgrade->step1()  

#3 applications/core/modules/setup/upgrade/upgrade.php(60): IPS\core\Setup\Upgrade->process()  

#4 system/Helpers/MultipleRedirect/MultipleRedirect.php(104): IPS\core\modules\setup\upgrade\upgrade->IPS\core\modules\setup\upgrade\{closure}()  

#5 applications/core/modules/setup/upgrade/upgrade.php(90): IPS\Helpers\MultipleRedirect->__construct()  

#6 system/Dispatcher/Controller.php(139): IPS\core\modules\setup\upgrade\upgrade->manage()  

#7 system/Dispatcher/Setup.php(261): IPS\Dispatcher\Controller->execute()  

#8 admin/upgrade/index.php(38): IPS\Dispatcher\Setup->run()  

#9 {main}

    • User Feedback

    Recommended Comments

    Marc Grand Master

    Marc

    Invision Community Team

    Please could you provide more infrormation? Where is it you are seeing the error, and what version did you upgrade from?

    Esther E. Experienced

    Esther E.

    Invision Community Team

    You can safely ignore those kinds of errors, assuming you're seeing them in the system log.

    This is a result of us putting changes into both v4 and v5 - we needed to maintain the database structure (among other things) and we split v5 off of v4 a loooooooong time ago.

    PanSevence Rising Star

    PanSevence

    Clients

    I see errors in the system log after updating from version 4.7.19 to v5 beta 12.

    So, can I ignore these errors?

    Esther E. Experienced

    Esther E.

    Invision Community Team

    Yes.

    Esther E. Experienced

    Esther E.

    Invision Community Team

    Changed Status to Not a bug