Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

1064 - SQL Syntax Erros


Guest

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 :)

 

Jay

Link to comment
Share on other sites

First problem

 

http://www.oscommerce.com/forums/index.php?showtopic=144095

 

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.

 

catalog/includes/configure.php

catalog/admin/includes/configure.php

 

define('STORE_SESSIONS', 'mysql');

 

HTH

Tom

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...