Unknown column 'val_function' in 'field list

[earmsby]

I'm at the final step o an upgrade I'm doing for a client. Finished all the testing in the 1.5.6 version shop and ready to refresh data and change directory names so the upgraded version will become the live version. I was at the step of putting both shops into DOWN FOR MAINTENANCE. But I can't seem to change any values in the Website Maintenance admin on the 1.5.6 shop. I get an error of:

WARNING: An Error occurred, please refresh the page and try again.If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

And in the logs, the error I see is:

[09-Feb-2019 11:17:27 America/New_York] Request URI: /store_upgrade/MY_ADMIN/configuration.php?gID=20&cID=446&action=save, IP address: 71.87.210.6
#1 trigger_error() called at [/PATH/store_upgrade/includes/classes/db/mysql/query_factory.php:171]
#2 queryFactory->show_error() called at [/PATH/store_upgrade/includes/classes/db/mysql/query_factory.php:143]
#3 queryFactory->set_error() called at [/PATH/store_upgrade/includes/classes/db/mysql/query_factory.php:270]
#4 queryFactory->Execute() called at [/PATH/store_upgrade/MY_ADMIN/configuration.php:26]
--> PHP Fatal error: 1054:Unknown column 'val_function' in 'field list' :: SELECT val_function FROM zc_configuration WHERE configuration_id = '446' ==> (as called by) /PATH/store_upgrade/MY_ADMIN/configuration.php on line 26 <== in /PATH/store_upgrade/includes/classes/db/mysql/query_factory.php on line 171.

Not sure how to solve this. Any suggestions where to look?

[earmsby]

Just an update, it actually seems as though I can not change any configuration values. I haven't tried everything of course, but the several things I tried to update all under configuration, all failed with similar errors.

[earmsby]

Digging a bit further, I compared the configuration table between my "upgraded" database and the clean 1.5.6 table and I can see that the clean 1.5.6 table has a field named val_function but the supposedly upgraded one does not. Can I assume that the table didn't actually get upgraded when I did the database upgrade? Is there a way to force this or something I can do to fix whatever prevented it upgrading in the first place?

I thought I was on the home stretch to finishing this upgrade but now I'm a bit stumped.

[mc12345678]

Perhaps more than just the one field was affected; however, I would suggest grabbing the zc_install directory from the github repo: https://github.com/zencart/zencart/tree/v156 where it has an update to address a date/datetime issue that tends to get in the way of updating table records. Then run the zc_install upgrade again. Before attempt to log into the admin, check the logs directory for problems related to the database upgrade and seek to address them.

[earmsby]

Thanks for that tip. I'm doing that now and will see what errors come up in the logs directory.

[earmsby]

Woohoo! Re-running zc_install using the newer version you posted did the trick. I did check the log files and all the errors seem to have to do with duplicate columns in other tables. I'm guessing/assuming that these errors were all because the database upgrade was trying to change the tables that had already been successfully upgraded the first time I ran the upgrade.

[mc12345678]

Woohoo! Re-running zc_install using the newer version you posted did the trick. I did check the log files and all the errors seem to have to do with duplicate columns in other tables. I'm guessing/assuming that these errors were all because the database upgrade was trying to change the tables that had already been successfully upgraded the first time I ran the upgrade.

The duplicate issues would most likely yes be because of re-running the zc_install, but also because there are some operations in the recent install scripts that have been there for several versions to make sure that the new version works as expected.

Good, glad that helped get there without having to redo too much. DrB, Wilt, Ajeh and the rest of that team do it again. :)