Trouble updating database

[NWCE]

Hi,

Today I have upgraded to v.1.5.4 from v.1.5.3 and have uploaded all of the changed files, reinstalled Paypal module, and put old database info into new database.

I changed both includes/config and admin/includes/config to point to new database and when running the zc_install I get through the first screen, agree to the terms, and then I get a white screen.

I even downloaded another fresh copy of v.1.5.4 from Source Forge just in the event that there was some corruption...but still the same problem.

Has anyone else had this? Also is there a way to disable the warning message on my site "Your Database appears to need patching....." so that it does not frighten off customers??

Thanks,

Jeff

[NWCE]

Here is the info from the logs to show where the problem of my white screen is occurring??

12-Mar-2015 14:50:33 America/Los_Angeles] PHP Fatal error: Call to a member function MoveNext() on a non-object in public_html/shop/zc_install/includes/classes/class.installer_version_manager.php on line 243

I hope that this helps,

P.S. I found the line in english.php to remove the header on my site warning that the database needs to be patched.

Jeff

[mc12345678]

Here is the info from the logs to show where the problem of my white screen is occurring??


I hope that this helps,

P.S. I found the line in english.php to remove the header on my site warning that the database needs to be patched.

Jeff

Might help, but there is certainly more information that would help as well. This helpful information would be the other pieces of information identified in the posting tips that can be seen by scrolling up after selecting the reply button.

It would also be beneficial to look through the posts about Zc 1.5.4 at: http://www.zen-cart.com/showthread.p...s)-with-v1-5-4

[DrByte]

is there a way to disable the warning message on my site "Your Database appears to need patching....." so that it does not frighten off customers??

The way you wrote that suggests that you didn't do a "test upgrade" in a temporary separate copy of your site, to iron out any glitches before applying the upgrade to your live site.

The upgrade docs recommend "testing" your upgrade in order to prevent symptoms which might "frighten off customers":
- http://www.zen-cart.com/entry.php?3-...d-of-upgrading
- http://www.zen-cart.com/content.php?...-zen-cart-site
- http://www.zen-cart.com/docs/

Here is the info from the logs to show where the problem of my white screen is occurring??

12-Mar-2015 14:50:33 America/Los_Angeles] PHP Fatal error: Call to a member function MoveNext() on a non-object in public_html/shop/zc_install/includes/classes/class.installer_version_manager.php on line 243

In the strictest sense, if line 243 is failing, then 240 and 238 should have failed too. It also could suggest that perhaps your 'products' table is missing (or, since you said you imported it into a new database, then perhaps it didn't import correctly, in which case you really shouldn't have your site 'live' until you fix it).

As usual, without your URL it's hard to offer detailed help.
Try adding &debug=ON to the end of your URL when on the zc_install "database upgrade" page, and see what status info it dumps onto the screen for analysis.

[NWCE]

Thank you all for your replies.

I will try turning on Debug mode as your suggested when running the zc_install to see what info comes up to help in diagnosing this problem.

Thanks again,
Jeff

[NWCE]

Hi Dr.Byte,

Thank you for your reply. Yes, in checking the databases in MySQL I see that my new database has only 162 tables and not the right Mb of info versus my 250 tables in my v.1.5.3.

I use the import function in MyPhPAdmin in Cpanel to transfer this old database into new, but in trying several times to import into 1.5.4 database it still gives me the same result. My database is quite large so I am wondering if it is timing out or corrupting when uploading (even though I do not receive any error messages when doing this).

Is there an easier way to import my database using the Database Backup MySQL plugin that I have installed on my current 1.5.3. When I change my config files to point to the new database and then try to access admin area before running zc_install to update the database I get the 0071 error.

Would it be best to create another new database for v.1.5.4 than the one I have as it doesn't have all of the tables, and I wouldn't get the 0071 error?

Sorry for what may seem like and elementary question, but I appreciate the help!

Kind regards,
Jeff

[RodG]

Thank you for your reply. Yes, in checking the databases in MySQL I see that my new database has only 162 tables and not the right Mb of info versus my 250 tables in my v.1.5.3.

Although the number of tables you have may be correct, it seems a little high to me. A 'typical' ZenCart installation only has ~110 tables.

I use the import function in MyPhPAdmin in Cpanel to transfer this old database into new, but in trying several times to import into 1.5.4 database it still gives me the same result. My database is quite large so I am wondering if it is timing out or corrupting when uploading (even though I do not receive any error messages when doing this).

It is *possible* for either of this things to be occurring, but it is quite unusual that if this is the case you aren't seeing any error messages.

Is there an easier way to import my database using the Database Backup MySQL plugin that I have installed on my current 1.5.3.

Sorry, but I can't comment about this plugin. I've only ever used the phpmyadmin export/import method.

I will suggest that when you do the export (with phpmyadmin) that you select the option to compress the file, as this tends to take care of any timeout issues (the resulting files are up to 10times smaller). Also, if the files are compressed you'll avoid the possibility of any corruption with the import (unless the compressed file itself get corrupted, and if this does happen you'll be notified of the problem after the upload, but before any 'import' actually starts.

Would it be best to create another new database for v.1.5.4 than the one I have as it doesn't have all of the tables

Another of the phpmyadmin export options is "Add Drop Table". If you enable this, then when the import is taking place any pre-existing tables will be dropped and recreated prior to the actual data being imported, which effectively gives you a 'clean' database (in practical terms, this is almost the same as creating a new database).

I'm not sure if any of this helps or not.

Cheers
RodG

[NWCE]

Hi Rod,

Thanks for your reply and help. I actually export a zipped database from the Backup MySQl plug in I have installed in Zen cart. As for the number of tables, I got this number from MyPHP Admin, when I look at my v.1.5.3 database and scroll to the very bottom, it shows 250 tables. I am not sure why this would be such a vast difference from the 110 that you suggested.

Thanks again for your help,

Jeff

[kobra]

Also is there a way to disable the warning message on my site "Your Database appears to need patching.....

Yes by allowing zc_install to patch your database up to the current level

Run zc_install and select "upgrade Database only"

[kobra]

P.S. I found the line in english.php to remove the header on my site warning that the database needs to be patched

This has not fixed the issue at all