This is a discussion on 1064 - error in your SQL syntax admin customer search within the osCMax v1.7 Discussion forums, part of the osCMax v1.7 Forums category; I was searching my customers in my old cart osCommerce in my current OSCMax 1.7 shopping cart and I ...
| |||||||
| Register | FAQ | Members List | Calendar | Mark Forums Read |
|
#1
| |||
| |||
| I was searching my customers in my old cart osCommerce in my current OSCMax 1.7 shopping cart and I received 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 '-10, 10' at line 1 select c.customers_id, c.customers_lastname, c.customers_firstname, c.customers_email_address, a.entry_country_id from customers c left join address_book a on c.customers_id = a.customers_id and c.customers_default_address_id = a.address_book_id where c.customers_lastname like '%robeds%' or c.customers_firstname like '%robeds%' or c.customers_email_address like '%robeds%' order by c.customers_lastname, c.customers_firstname limit -10, 10 [TEP STOP] I checked the bug reports but there was nothing that referenced the customer search in admin section. Any ideas?? Thanks, Jacob webmaster@stock-information.com |
| Thread Tools | |
| |
| ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Admin Report syntax Error | judoka | osCMax v1.7 Discussion | 2 | 05-15-2005 10:04 AM |
| 1064 - You have an error in your SQL syntax. | jamie74 | osCommerce 2.2 Modification Help | 0 | 10-20-2004 11:45 AM |
| Please help!!! Error in admin tool with Customer info | Rosina | osCommerce 2.2 Installation Help | 2 | 09-22-2004 03:22 PM |
| 1064 - You have an error in your SQL syntax. | j0ly | osCommerce 2.2 Installation Help | 1 | 08-24-2004 03:13 PM |
| 1064 - You have an error in your SQL syntax | Anonymous | osCMax v1.7 Installation | 3 | 05-10-2004 10:48 AM |