Need help upgrade from 1.3.7 to 1.3.8

I tried to upgrade from 1.3.7 to 1.3.8, but after I click the "Update Database Now", the progress bar was moving slowing but it did not respond. I've waited for over 30 minites now and there is still no response. Is this a common problem and is there anyway that I can upgrade the database directly from PHPMyAdmin? Thanks

Did you try starting over?

I've tried new installation, it worked fine. I have quite a few mods (SEO, Timezone offset, esay populate etc.) Will those interupt the upgrade?

Those should not break the upgrade.

But that's one reason for doing a test upgrade on a test copy of your site ... just to be sure!

How can I solve this problem? Is there anyway I can apply the database patch using PHPMyAdmin? Thanks

When you say it hangs on you, what do you see?
Is the page completely blank or do you see some information/progress details?

It stays at the upgrade database page, did not go any further.

lennypeng:

It stays at the upgrade database page, did not go any further.

I don't follow you.
Are you saying that when you click the submit button to start the upgrade, the button does nothing?
Or what exactly is happening?

After i click the upgrade buttom, the progress bar at the bottom of the browser turned green but nothing happened on the page, it stayed at the upgrade page.

Hi DrByte, can you tell me what might went wrong? Or is there anyway to upgrade directly in PHPmyAdmin? Cheers

I've attached a screenshot, it just stayed on this page forever.

Can you open your /cache folder and zip and post the zcInstall log files?

Thanks, here is the zip file

lennypeng:

Or is there anyway to upgrade directly in PHPmyAdmin?If you want to sort out every possible error manually, sure, go ahead. The 137-to-138 sql script is in the sql folder in the zc_install directory.
You won't have any of the safeties that the installer provides. If it blows up, restore from backup.

Thanks for your advice. Have you found out what might went wrong given the log file? Cheers

The log file hasn't supplied anything obvious.
Unfortunately I cannot duplicate the problems you're experiencing, so I cannot "fix" anything to be sure it doesn't happen again. :(

I was having this exact error! That is, submitting the db 1.3.7 to 1.3.8 upgrade form and having it hang until I quit the browser.

Running the 'mysql_upgrade_zencart_137_to_138.php' update script line by line through my MySQL client (MySQL server version 5.0.45-community-nt), I found that line 62, which reads...

INSERT INTO query_builder (query_category, query_name, query_description , query_string) VALUES ('email,newsletters', 'Customers who have never completed a purchase', 'For sending newsletter to all customers who registered but have never completed a purchase', 'SELECT DISTINCT c.customers_email_address as customers_email_address, c.customers_lastname as customers_lastname, c.customers_firstname as customers_firstname FROM TABLE_CUSTOMERS c LEFT JOIN TABLE_ORDERS o ON c.customers_id=o.customers_id WHERE o.date_purchased IS NULL');

...was causing the script to hang every time.

I commented out that line and the upgrade script was able to complete successfully. I then added the query_builder record manually through my MySQL client.

Hope this helps any that are having a similar issue!

I had the same problem as dim.star. and his solution worked.

The query_builder insert fails with the error:

#1364 - Field 'query_keys_list' doesn't have a default value