Updating to version 1.3.5.9 failed with: CDbCommand failed to execute the SQL statement

Discussion in 'General discussions' started by POS, Feb 5, 2016.

  1. POS

    POS New Member

    Joined:
    Apr 22, 2015
    Messages:
    11
    Likes Received:
    3
    S.E:
    Expired
    L.T:
    Regular
    L.C:
    1
    I have tested both with using SSH and using web interface to update. Not at the same time, but with a reset in between (uploading the backup files. )

    The whole error message is:
    Updating to version 1.3.5.9 failed with: CDbCommand failed to execute the SQL statement: SQLSTATE[HY000]: General error: 1005 Can't create table './blabla/#sql-4ec_2eb25.frm' (errno: 121)

    This when upgrading from 1.3.5.8 to 1.3.6.0

    Is the database server version too old?
    (Debian 5.0 server)

    Or how can I go about upgrading?
     
  2. twisted1919

    twisted1919 Administrator Staff Member

    Joined:
    Dec 27, 2014
    Messages:
    10,477
    Likes Received:
    2,443
  3. POS

    POS New Member

    Joined:
    Apr 22, 2015
    Messages:
    11
    Likes Received:
    3
    S.E:
    Expired
    L.T:
    Regular
    L.C:
    1
    I got the same error via SSH shell.

    But I followed the instructions in https://forum.mailwizz.com/threads/error-updating-what-to-do.1467/#post-8433

    And in the SSH Terminal I got this after editing the sql-file to only this:
    ALTER TABLE `campaign_delivery_log` ADD KEY `cid_status`(`campaign_id`, `status`);
    ALTER TABLE `campaign_delivery_log` ADD KEY `cid_date_added`(`campaign_id`, `date_added`);



    Updating to version 1.3.5.9.
    Updated to version 1.3.5.9 successfully.
    Updating to version 1.3.6.0.
    Updated to version 1.3.6.0 successfully.
    Congratulations, your application has been successfully updated to version 1.3.6

    :)
     
    twisted1919 likes this.

Share This Page