search

ryansuitposungkono / openjs-grid

Automatically exported from code.google.com/p/openjs-grid
0 stars 0 forks source link

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax. #49

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?
1. loaded database and connect and got this error.

2. string(94) " SELECT `orders`.``,orders.id FROM `orders` ORDER BY LIMIT 0, " 
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,' at line 8
3.
Miss value like id after: ORDER BY LIMIT 0 should be -> ORDER id BY LIMIT 0

What is the expected output? What do you see instead?
?

What version of the product are you using? On what operating system?
1.8

Please provide any additional information below.

Original issue reported on code.google.com by westdh...@gmail.com on 3 Dec 2011 at 7:20

GoogleCodeExporter commented 9 years ago 
[deleted comment]
GoogleCodeExporter commented 9 years ago 
in your grid declaration do you have valid 'order_by:' argument?

$(function() {
    $(".grid.master").loadGrid({
        order_by:"id"
});

where 'id' - is the actual column in the called table?

besides, LIMIT 0 will only return table description.
LIMIT ) and comma after that would only tell me that you didn't setup 
nRowsShowing: argument in grid declaration..
or more likely it's set to 0?

Original comment by ginger...@gmail.com on 7 Dec 2011 at 5:42