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

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?

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.

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. :)