running 1.3.0 MySQL Database errors

[Noella]

Something Strange just happened. When I view my pages, this appears on the top.

Warning: Variable passed to each() is not an array or object in /home/kookoot/
public_html/store/includes/classes/db/mysql/query_factory.php on line 112

And this appears in the body

1064 You have an error in your SQL syntax; check the manual that corresponds to your
MySQL server version for the right syntax to use near 'EXPECTED_PRODUCTS_SORT 
limit MAX_DISPLAY_UPCOMING_PRODUCT' at line 6 in:

[select p.products_id, pd.products_name, products_date_available as date_expected 
from products p, products_description pd where to_days(products_date_available) > 
to_days(now()) and p.products_id = pd.products_id and pd.language_id = '1' order by 
EXPECTED_PRODUCTS_FIELD EXPECTED_PRODUCTS_SORT limit 
MAX_DISPLAY_UPCOMING_PRODUCTS]

I have not done anything. I didn't even upgrade or anything. It just appeared by itself. Nothing seems to be wrong with the server and the Database is intact. I'm so confused. I don't know what's wrong or how to fix it.

[Ajeh]

Looks like your database configuration is missing those settings ...

NOTE: the current release is Zen Cart v1.3.5

You say you are running v1.3.0 ... When and Where did you get it? that is a very old version and many updates have been made since then ...

If you have not really done anything with your site, then I would suggest you use Zen Cart v1.3.5 ... or consider upgrading it if you have already started using it ...

[Noella]

I upgraded sometime this earlier this year.

If i do a fresh install of 1.3.5 and import my database, would it still be messed up?

[Ajeh]

Make a test directory /new_shop

Make a test database

Load a backup copy of your Live Site into the test database ...

Load your existing site to /new_shop ...

Load all the files for Zen Cart v1.3.5 ...

Edit the 2 configure.php files:
/includes/configure.php
/admin/includes/configure.php

Change the paths to reflect the /new_shop and the database, username and password to reflect the new database ...

Run the /new_shop/zc_install

Test the upgrade process on /new_shop and you should test everything from:

Create several test account
Add to cart
checkout for your shipping modules
checkout for your payment modules

Complete several test orders ...

Make sure all is happy in My Account and Admin ... Customers ... Orders ...

If all is perfect ... set Live site Down for maintenance ...

Drop all tables from /new_shop database and load fresh copy of Live Site database after it was set Down for Maintenance ...

Run /new_shop/zc_install again ...

Test all again ...

If all is perfect ...

Edit the 2 configure.php files:
/new_shop/includes/configure.php
/new_shop/admin/includes/configure.php

To reflect the Live Shop directory path ...

Do NOT change the database ... you will be now using the new database you made with v1.3.5 ...

Rename the Live Site /old_shop or move to /old_shop directory ...

Rename /new_shop to Live Shop directory or to the root depending on where you have it ...

Check and test everything ...

If all is good ... take new Live shop off of Down for Maintenance ... and you are good to go ...

NOTE: it is a good idea during testing of /new_shop to remove/install Payment, Shipping and Order Total Modules *AFTER* you have written down old settings ... and reinstall and configure ...

Many changes have been made and you want to assure all is right in the world ...

[Noella]

All is not well.

Previous Zen Cart Installation Found
However, the version level of your database cannot be determined, usually resulting from wrong table prefixes, or other database settings mismatches.

[Noella]

nevermind. after much toil. I finally got it to recognize the database version.