Forums / General Questions / 1054 Unknown column 'specials_date_available

1054 Unknown column 'specials_date_available

Locked

Views: 991

Results 1 to 3 of 3
This thread is locked. New replies are disabled.
20 Dec 2007, 8:03 AM
#1
webskipper avatar

webskipper

Totally Zenned

Join Date:
Nov 2007
Location:
USA
Posts:
876
Plugin Contributions:
2

1054 Unknown column 'specials_date_available

I get this when trying to access the Admin site:

1054 Unknown column 'specials_date_available' in 'where clause'
in:
[select specials_id, products_id from specials where status = '0' and (((specials_date_available <= now() and specials_date_available != '0001-01-01') and (expires_date >= now())) or ((specials_date_available <= now() and specials_date_available != '0001-01-01') and (expires_date = '0001-01-01')) or (specials_date_available = '0001-01-01' and expires_date >= now())) ]
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...

When accessing the store:

Fatal error: Call to a member function on a non-object in /home/american/public_html/z-shoppe/includes/classes/currencies.php on line 31

Still on MySql 4 something and Zen 3.8.1

Are they related?

Cheers!
v2.2.1

27 Dec 2007, 12:58 AM
#2
webskipper avatar

webskipper

Totally Zenned

Join Date:
Nov 2007
Location:
USA
Posts:
876
Plugin Contributions:
2

Re: 1054 Unknown column 'specials_date_available

Used ZC_Install to correct issue.

Restored site from archive.

Restored DB from archive.

Cheers!
v2.2.1

27 Dec 2007, 1:51 AM
#3
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: 1054 Unknown column 'specials_date_available

Thanks for the update on how you were able to fix the issues on your site! :smile:

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!