New Zenner
- Join Date:
- Jul 2012
- Posts:
- 1
- Plugin Contributions:
- 0
1064 database error after installing newsletter subscribe module
I m using v139h version , just now i tried to install newsletter subscribe module
when i click Admin-> Customers->Customers
it shows that
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 '-0, MAX_DISPLAY_SEARCH_RESULTS_CUSTOMER' at line 1
in:
[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 customers c left join customers_info ci on c.customers_id= ci.customers_info_id left join address_book a on c.customers_id = a.customers_id and c.customers_default_address_id = a.address_book_id left join coupon_gv_customer cgc on c.customers_id = cgc.customer_id order by ci.customers_info_date_account_created DESC limit -0, MAX_DISPLAY_SEARCH_RESULTS_CUSTOMER]
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.
does anyone know what i have done wrong? have searched previous post for hours but have no clue.:frusty:
