Fatal error: 1054:Unknown column 'gzpost' in 'field list'

[dellaenterprises]

After fighting to get zc_install to run when setting the two configure.php files to use the 1.3.7 database I instead installed with a new database, which worked fine. Now I've changed the two configure.php files to reference the 1.3.7 database. The zen site starts but now when viewing the site after changing the configure.php to reference the 1.3.7 database, but has the message "Your database appears to need patching to a higher level", but all products from the original site now appear.

Rerunning zc_install to try and upgrade the database still fails on the third screen with the warning
WARNING: An Error occurred, please refresh the page and try again.
Looking at the debug .log file I see the following:

[20-Jan-2013 14:16:14 UTC] PHP Fatal error: 1054:Unknown column 'gzpost' in 'field list' ::
insert into admin_activity_log (access_date, admin_id, page_accessed, page_parameters, ip_address, gzpost, flagged, attention)
values (now(), '0', 'alert_page.php ', '', '174.29.142.4', '', '0', '')
in /home/edward/public_html/bbr1.5.1/includes/classes/db/mysql/query_factory.php on line 120

Is there some way to get zc_install to run enough to get to the "upgrade database" screen.

Note: the 1.3.7 database still works fine with the 1.3.7 zen site, but due to PHP updates by my webserver, I need to upgrade to 1.5.1 zen cart (as I cannot get into the admin site on the 1.3.7 anymore).

Thanks for any suggestions,
Ted

[DrByte]

viewing the site after changing the configure.php to reference the 1.3.7 database, but has the message "Your database appears to need patching to a higher level",

That's because you pointed it to a database that hasn't been upgraded yet. So, now that you've pointed it to the original database (in both configure.php files), you need to run zc_install and choose database-upgrade.

PHP Fatal error: 1054:Unknown column 'gzpost' in 'field list'

That's caused when you login to the admin without having first upgraded the database to the latest version. See above.

[dellaenterprises]

That's because you pointed it to a database that hasn't been upgraded yet. So, now that you've pointed it to the original database (in both configure.php files), you need to run zc_install and choose database-upgrade.

That's caused when you login to the admin without having first upgraded the database to the latest version. See above.

Therein lies my problem, I cannot get to that third screen in zc_install that shows the "upgrade database" button because of problems 1.5.1 install has in dealing with the 1.3.7 database. I seem to be in a Catch 22. I need to upgrade the database in 1.5.1 zc_install, but until the database is upgraded, I can't get to that zc_install screen.

I'm stuck.

Frustrated,
Ted

[DrByte]

Edit your /zc_install/includes/installer_params.php file
and change the following:

  define('STRICT_ERROR_REPORTING', FALSE);

to this:

  define('STRICT_ERROR_REPORTING', TRUE);

Then you should be able to see the error messages, either on-screen or in the logs folder.
If not, share the URL.

[dellaenterprises]

I get the following error when setting STRICT_ERROR_REPORTING to true:

1034 Incorrect key file for table 'customers'; try to repair it
in:
[show fields from customers]

Fatal error: 1034:Incorrect key file for table 'customers'; try to repair it :: show fields from customers in /home/edward/public_html/bbr1.5.1/includes/classes/db/mysql/query_factory.php on line 120


I do have a "repair" button on my webserver SQL application, but I have tried a repair for this database, the SQL app seems happy with the database.

[DrByte]

Your "customers" table is damaged. Well, part of its indexes are anyway.
Running a repair on that specific table would be the first thing to do. phpMyAdmin lets you do that by first selecting your store's database from the left column, then in the center column choose your customers table. Then choose the Operations tab, and Repair Table.

Optionally you could drop and restore the table from your backup.

[dellaenterprises]

Thanks Dr. Byte. That was the problem. Examining the table with phpMyAdmin shows the "customers" table to be "in use" and the repair unfortunately returns "Incorrect key file for table 'customers' try to repair (duh). and then Error, Corrupt. So it looks like that is it for the customers. I'll see if I can transfer just the products and at least save some re-entry time for the upgrade to 1.5.1. I appreciate your help.

Ted

[DrByte]

Do you not make regular backups of your database?

[dellaenterprises]

I'm afraid not. Sales at my store were pretty small over the past few years and I never got around to it. Lesson learned. Do you have any idea where on a site the databases are stored as I have periodically copied the entire zen cart directory to disk?
Thanks for all the help.

Ted

[DrByte]

Strictly speaking, the database is stored in the MySQL database engine, which is not stored in files that are part of your "account". You access the database by using tools designed to import/export/transact with the database engine, such as phpMyAdmin.

Related FAQ: http://www.zen-cart.com/content.php?...atabase-backup