Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

1064 - SQL Syntax Erros


Recommended Posts

Hi all,


Befor i start im so glad to be a part of a growing and large community with such a high level of support.


I go to my admin panel and click reviews, orders, ect and keep 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 '-20, 20' at line 1


select o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from orders o left join orders_total ot on (o.orders_id = ot.orders_id), orders_status s where o.orders_status = s.orders_status_id and s.language_id = '1' and ot.class = 'ot_total' order by o.orders_id DESC limit -20, 20




Im very confused and really bugged up to why this is happeneing. I want everything running perfect befor i start my online shop, thats why im so eager to get this sorted.


I dont know much about SQL and PHP, i have enough knowledge to be able to edit and compile basic files easily enough.

Another problem..................................

WARNING!! The session directory does not exist : /tmp.


Im using my host's server, and dont know what the root directory is or where to place the /tmp folder.


Thanx in advanced and thanx for reading :)



Link to comment
Share on other sites

First problem




Second problem


The directory that is defined via your osc admin panel in sessions needs to be somewhere in your web space and fully read/writable or "chmod 777".


Or you can store sessions in your database by changing the TWO configure.php files at the bottom of each file.





define('STORE_SESSIONS', 'mysql');




Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...