If you have 1064 in admin.

[Wendy James]

I noticed a bunch of posts about 1064 so I thought I would put this up here even though the answer has been posted before, there have been so many posts about it that the answer seems to have been burried pages back.

 

Open

admin/includes/classes/split_page_result.php in admin/includes/classes

 

Look for

	  $offset = ($max_rows_per_page * ($current_page_number - 1));
  $sql_query .= " limit " . $offset . ", " . $max_rows_per_page;

 

and change it to

	 $offset = ($max_rows_per_page * ($current_page_number - 1));
 if ($offset < 0) {$offset = 0;}
 $sql_query .= " limit " . $offset . ", " . $max_rows_per_page;

 

That solves the issue of the 1064 if it is the limit -20, 20

Not sure if there is other #s involved in the error.

 

Hope that helps all the people posting about 1064 lately :)

[buffeevamprslyr]

THANK YOU!

[trimorphous]

I had a -7 7 limit in several places after moving the shop to a different server, this fix worked on all of them, the problem occured when the database was exported, any items that had no entries generated a 1064 error.

 

Thanks

[cerion]

Thankyou so much