Errors suddenly after files restored

[Sanguinarius]

Hi, Zthe server my domain is on went bad and they changed over to a new one and restored everything from a backup. Now, when I went to delete a (test) order, I get:

 

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 s.orders_status_id = '20' and ot.class = 'ot_total' order by o.orders_id DESC limit -20, 20

 

[TEP STOP]

 

I have no idea what this means or why I'm suddenly getting it. My store WAS operating before this. (*wonders what other surprises lay in store for her*) Somebody please help me? I'm using osc2 ms2.

[mtechama]

Hi, Zthe server my domain is on went bad and they changed over to a new one and restored everything from a backup. Now, when I went to delete a (test) order, I get:

I have no idea what this means or why I'm suddenly getting it. My store WAS operating before this. (*wonders what other surprises lay in store for her*) Somebody please help me? I'm using osc2 ms2.

 

 

Sounds like you have an SQL issue.

[Sanguinarius]

ok. How do I fix it?

[mtechama]

did everything work great before the server went bad?

[sugiartha]

Open your file admin/includes/classes/split_page_results.php and find this code:

 

$sql_query .= " limit " . $offset . ", " . $max_rows_per_page;

 

right before that code, insert :

 

if($offset < 0) $offset = 0;

[satish]

This will happen with Mysql 5 so apply all the patches released on oscommerce.

 

Satish

[Sanguinarius]

I opened that file and searched for

 

$sql_query .= " limit " . $offset . ", " . $max_rows_per_page;

 

and it was not found. What do I do now?

 

**edit**

 

However, I DID find the code:

 

$this->sql_query .= " limit " . $offset . ", " . $this->number_of_rows_per_page;

 

-----

 

Where do I find the patches?

[Sanguinarius]

Oops, I wasn't looking in the right file..teach me to do this with people over, distracting me! FOund the code, added the line of code and it's working now. Thanks muchly!

 

 

-----

 

Where do I find the patches? Do I still need them?

[satish]

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

 

Is always recommended to add those patches.

 

Satish

[user99999999]

sorry error