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

POS

New Member
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?
 

POS

New Member
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

:)
 
Top