1.3.7.1 - 1.3.8 Database Upgrade Hangs... (using IIS)

[Alex Clarke]

I've tried to upgrade two Zen Cart installations (both from 1.3.7.1 to 1.3.8) and each have failed when performing the Database Upgrade.

The web browser just freezes/hangs at around 50% (after clicking on the Database Upgrade button). No errors are reported.

If I close or try to refresh the page I cannot access zc_install/index.php (via the web browser) again until I manually delete the previously created sessions file.

Both upgrades have been attempted on IIS (version 5 I believe).

Has anyone else experienced this issues?

[Alex Clarke]

This error is displayed in my error log (if I leave the browser for around 30 minutes while it attempts to perform the database upgrade).

2007-12-04 20:15:47 ::1%0 49690 ::1%0 80 HTTP/1.1 POST /mywebsite/zc_install/index.php?main_page=database_upgrade - 1 Connection_Abandoned_By_ReqQueue DefaultAppPool

My setup is: IIS7, PHP 5.2.4 and MySQL 5.0.45

I'm just about to upgrade to the latest version of PHP to see if this helps.

[Alex Clarke]

A quick update...

The new version of PHP I installed did not help the situation.

I have examined the upgrade_exceptions table within my database and noticed that the following data has appeared.

-- 
-- Dumping data for table `zen_upgrade_exceptions`
-- 
INSERT INTO `zen_upgrade_exceptions` (`upgrade_exception_id`, `sql_file`, `reason`, `errordate`, `sqlstatement`) VALUES 
(4, 'sql/mysql_upgrade_zencart_137_to_138.sql', 'Cannot insert configuration_key "SHOW_SHOPPING_CART_COMBINED" because it already exists', '2007-12-04 20:33:42', 'INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES (''Show Notice of Combining Shopping Cart on Login'', ''SHOW_SHOPPING_CART_COMBINED'', ''1'', ''When a customer logs in and has a previously stored shopping cart, the products are combined with the existing shopping cart.<br /><br />Do you wish to display a Notice to the customer?<br /><br />0= OFF, do not display a notice<br />1= Yes show notice and go to shopping cart<br />2= Yes show notice, but do not go to shopping cart'', ''9'', ''35'', ''zen_cfg_select_option(array(\\''0\\'', \\''1\\'', \\''2\\''), '', now());'),
(5, 'sql/mysql_upgrade_zencart_137_to_138.sql', 'Cannot insert configuration_key "ORDER_COMMENTS_INVOICE" because it already exists', '2007-12-04 20:33:42', 'INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES (''Display Order Comments on Admin Invoice'', ''ORDER_COMMENTS_INVOICE'', ''1'', ''Do you want to display the Order Comments on the Admin Invoice?<br />0= OFF<br />1= First Comment by Customer only<br />2= All Comments for the Order'', 7, 25, now(), NULL, ''zen_cfg_select_option(array(''''0'''', ''''1'''', ''''2''''), '');'),
(6, 'sql/mysql_upgrade_zencart_137_to_138.sql', 'Cannot insert configuration_key "ORDER_COMMENTS_PACKING_SLIP" because it already exists', '2007-12-04 20:33:42', 'INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES (''Display Order Comments on Admin Packing Slip'', ''ORDER_COMMENTS_PACKING_SLIP'', ''1'', ''Do you want to display the Order Comments on the Admin Packing Slip?<br />0= OFF<br />1= First Comment by Customer only<br />2= All Comments for the Order'', 7, 26, now(), NULL, ''zen_cfg_select_option(array(''''0'''', ''''1'''', ''''2''''), '');');

It appears that all of the other database changes (from 1.3.7.1 to 1.3.8) are completed (if I try to run zc_install again it tells me that version 1.3.8 is installed). However, I'm a little concerned that the database upgrade is still hanging.

Problem Solved!

After turning off the MySQL 'strict mode' everything worked. I'll test this method again (on a live server) and see what happens. If I run into any further issues I'll post back.

For now, it works. :)