Error updating - What to do?

[Osjtya]

@twisted1919, I'm receiving error while updating the application:

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 '#sql-7433_23f5b' (errno: 121)​

 

[Vpul Shah]

Hi,

You can login to mysql and type

mysql> SHOW INNODB STATUS\G

You will have all the output and you should have a better idea of what the error is.

 

[Osjtya]

@Vpul Shah, Thanks for replying. Where I've to enter this command? SSH?

@twisted1919, I'm waiting for your reply.

 

[Osjtya]

@twisted1919, I'm waiting for your reply.

 

[Osjtya]

@twisted1919, Hope you are well and heathy? I'm waiting for your reply.

 

[twisted1919]

Well, my hunch is that you tried to upgrade the app from the web interface, then it failed because the database was too big, then you tried maybe command line update and then you got this particular error?

Eitherway, restore your backup and try to upgrade from command line directly.
If you follow the upgrade steps, there's no reason why the upgrade will break.

 

[Osjtya]

@twisted1919, Thanks genius! Yes you're right, below are the steps we followed:

1. Uploaded "Update" folder contents
2. Tried to run the update command through web interface
3. Then tried to run through SSH same error

Guess what? We don't have the SQL backup file

What to do?

 

[twisted1919]

@AC AFD - Well, there are still some hopes
Check your database and see if you have a table named customer_message(might be mw_customer_message).
If you have it open /apps/common/data/update-sql/1.3.5.9.sql and remove everything till line 74 so that the file will only contain:

ALTER TABLE `bounce_server` ADD KEY `status` (`status`);
ALTER TABLE `list_subscriber` ADD KEY `email` (`email`);
ALTER TABLE `campaign_bounce_log` ADD KEY `proc_bt` (`processed`,`bounce_type`);
ALTER TABLE `campaign_delivery_log` ADD KEY `proc_status` (`processed`,`status`);
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`);

Save the file and run the upgrade process from command line again.

If you don't have that table above, you'll have to simply run by hand each query from the update file (/apps/common/data/update-sql/1.3.5.9.sql ).
I'd suggest doing it from command line too.

 

[twisted1919]

@AC AFD - And do yourself a good and get yourself the backup extension

 

[Osjtya]

@twisted1919, Thanks for the suggestion. From where I can buy Backup Extension? If it's created by you then I can go ahead and purchase. Also do you know any themes which are compatible with MailWizz?

I'll try to go through your suggestion.

 

[twisted1919]

@AC AFD - You can get the backup manager extension from here and yeah, it's written by me
Related to themes, you pretty much have to use any html theme but have to then transform it into a mailwizz theme, which is rather a complex process that requires PHP knowledge.

 

[Osjtya]

@twisted1919 - Again new error:

Updating to version 1.3.5.9 failed with: CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'status'​

 

[twisted1919]

Believe it or not, this is good

The file now contains:

ALTER TABLE `bounce_server` ADD KEY `status` (`status`);
ALTER TABLE `list_subscriber` ADD KEY `email` (`email`);
ALTER TABLE `campaign_bounce_log` ADD KEY `proc_bt` (`processed`,`bounce_type`);
ALTER TABLE `campaign_delivery_log` ADD KEY `proc_status` (`processed`,`status`);
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`);

And the app complaints about the status column, which means we can safely remove the first row of the file so that we can have:

ALTER TABLE `list_subscriber` ADD KEY `email` (`email`);
ALTER TABLE `campaign_bounce_log` ADD KEY `proc_bt` (`processed`,`bounce_type`);
ALTER TABLE `campaign_delivery_log` ADD KEY `proc_status` (`processed`,`status`);
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`);

If later it complains again, try removing a row and run the command again, and so on till it does not complain anymore.

 

[Osjtya]

@twisted1919 Thanks Problem Solved!