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

[POS]

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?

 

[twisted1919]

The error you get is connected and explained in this thread: https://forum.mailwizz.com/threads/error-updating-what-to-do.1467/
Basically, you should run the upgrade from command line, not from web interface and then from command line because the web interface times out and you get issues like the above.

 

[POS]

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