PLease Help

[dafadil]

I'm new at all this jazz...and I have recieved an error in my Customer orders. I've been told I need to restructure my join/query to use positive values. I don't have the first clue how to do this. Somehow I currently have a "-" sign in my limit clause ("DESC limit -20, 20"). Can someone explain to me what I am can to do to fix this???? Keep in mind, I don't even know what or where my limit clause is... :blush:

 

~Diana

[Guest]

Line 67 in catalog/includes/classes/split_page_results.php must be changed from:

 

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

 

 

to:

 

 

$this->sql_query .= " limit " . max($offset, 0) . ", " . $this->number_of_rows_per_page;

 

 

Line 38 in catalog/admin/includes/classes/split_page_results.php must be changed from:

 

 

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

 

 

 

to:

 

 

$sql_query .= " limit " . max($offset, 0) . ", " . $max_rows_per_page;

 

 

 

 

You also need to upgrade your store to the latest security/bug fix version :)

 

 

 

Sonia