Please let me know what I need to do:
I upgraded from 1.3.9d to 1.3.9h, and am getting this error:
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 'select c.customers_id, c.customers_lastname, c.customers_firstname, c.customers_' at line 1
in:
[select count(select c.customers_id, c.customers_lastname, c.customers_firstname, c.customers_email_address, c.customers_group_pricing, a.entry_country_id, a.entry_company, ci.customers_info_date_of_last_logon, ci.customers_info_date_account_created , c.customers_telephone, a.entry_company, a.entry_street_address, a.entry_city, a.entry_postcode, c.customers_authorization, c.customers_referral, cgc.amount from zen_customers c left join zen_customers_info ci on c.customers_id= ci.customers_info_id left join zen_address_book a on c.customers_id = a.customers_id and c.customers_default_address_id = a.address_book_id left join zen_coupon_gv_customer cgc on c.customers_id = cgc.customer_id order by ci.customers_info_date_account_created DESC) as total ]
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.
:
Database Host: localhost (127.0.0.1)Server OS: Linux 2.6.18-194.17.4.el5 Database: MySQL 5.0.92-communityServer Date: 05/03/2011 20:01:34 Database Date: 05/03/2011 20:01:34 Server Up Time: 20:01:34 up 175 days, 11:03, 0 users, load average: 1.35, 1.09, 0.95HTTP Server: ApachePHP Version: 5.2.11 (Zend: 2.2.0) PHP Memory Limit: 32MPHP Safe Mode: OffPHP File Uploads: On Max Size: 2MPOST Max Size: 8MDatabase Data Size: 2,309 kBDatabase Index Size: 494 kB
Zen Cart 1.3.9h
Database Patch Level: 1.3.9c
v1.3.9c [2010-07-02 20:16:54] (Version Update 1.3.8->1.3.9c)
v1.3.9c [2010-06-08 09:45:56] (Version Update 1.3.8->1.3.9c)
v1.3.8 [2009-02-02 00:28:54] (Version Update 1.3.7->1.3.8)
v1.3.7 [2009-02-02 00:26:57] (Version Update 1.3.6->1.3.7)
v1.3.6 [2009-02-02 00:26:42] (Version Update 1.3.5->1.3.6)
v1.3.5 [2009-02-02 00:26:23] (Version Update 1.3.0.2->1.3.5)
v1.3.0.2 [2009-02-02 00:25:33] (Version Update 1.3.0.1->1.3.0.2)
v1.3.0.1 [2009-02-02 00:16:44] (Version Update 1.3.0->1.3.0.1)
v1.3.0 [2009-02-02 00:15:37] (Version Update 1.2.7->1.3.0)
v1.2.7 [2006-03-08 13:06:10] (Fresh Installation)
Bookmarks