HELP - Error in SQL syntax message?

[Gemini05]

I have just installed SPPC into a new OsCommerce store and am getting the following 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 'limit 0, 20' at line 1

 

limit 0, 20

 

[TEP STOP]

 

I have searched the support thread for a solution, and have found similar issues but not a solution to this one. Any ideas on how to fix this?

 

The only other mod that I have installed is Purchase without Account, not sure if it could be a conflict with that.

[♥geoffreywalton]

There is a patch for a -20,20 problem if you follow the links in my signature block. Migh be able to apply same type of solution to your problem

[satish]

Modify / replace Your split page class.

 

Satish

[Jan Zonjee]

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 'limit 0, 20' at line 1

 

limit 0, 20

If this is the whole error message then there is something very, very wrong with a piece of code because limit 0,20 is not a query.

 

Anyway, this is the same message you posted in the SPPC thread and you still haven't figured out that only a psychic can help you here with a post like that.

 

You don't mention on what page this happens, you don't even tell is if this in the admin or on the catalog side. Bottom line: we don't have the information to even tell you where to start looking for the problem. You need to give more information.

[Gemini05]

If this is the whole error message then there is something very, very wrong with a piece of code because limit 0,20 is not a query.

 

Anyway, this is the same message you posted in the SPPC thread and you still haven't figured out that only a psychic can help you here with a post like that.

 

You don't mention on what page this happens, you don't even tell is if this in the admin or on the catalog side. Bottom line: we don't have the information to even tell you where to start looking for the problem. You need to give more information.

 

 

The error message is in the admin section on the orders.php page, and that is the full error message.

Edited September 3, 2008 by Gemini05

[Jan Zonjee]

The error message is in the admin section on the orders.php page, and that is the full error message.

Then the problem is probably in this part close to the bottom of the file:

	} else {
  $orders_query_raw = "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, cg.customers_group_name from " . TABLE_ORDERS . " o left join " . TABLE_ORDERS_TOTAL . " ot on (o.orders_id = ot.orders_id) left join " . TABLE_CUSTOMERS . " c on c.customers_id = o.customers_id left join " . TABLE_CUSTOMERS_GROUPS . " cg using(customers_group_id), " . TABLE_ORDERS_STATUS . " s where o.orders_status = s.orders_status_id and s.language_id = '" . (int)$languages_id . "' and ot.class = 'ot_total' order by o.orders_id DESC";
  // EOF Separate Pricing Per Customer
}
$orders_split = new splitPageResults($HTTP_GET_VARS['page'], MAX_DISPLAY_SEARCH_RESULTS, $orders_query_raw, $orders_query_numrows);
$orders_query = tep_db_query($orders_query_raw);

Did you change that for PWA or the lines above that?