ryansuitposungkono / openjs-grid

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

I am getting this error. ->You have an error in your SQL syntax; #47

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago
I am getting this message just after I have connected to the database. --

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

What steps will reproduce the problem?
1. I am running phpMyAdmin
2. I have imported: sampleSql.sql
3. I have connected to the database and can view the content of the imported 
sampleSql file in the order table using phpMyAdmin. and i can issue simple sql 
statements using the phpMyAdmin like 'select * from orders'  

But it fails just after connecting to the database from ajax.php. 

What is the expected output? 
?
What do you see instead?
-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

What version of the product are you using? 
OPENJS Grid 1.8 ?
On what operating system?
Mac OSX lion
the import file sampleSql.sql is: MySQL 5.1.44

Please provide any additional information below.
How can I correct this error.???

Original issue reported on code.google.com by westdh...@gmail.com on 25 Nov 2011 at 10:21

GoogleCodeExporter commented 9 years ago
Close this issues got it working finally.

Original comment by westdh...@gmail.com on 26 Nov 2011 at 9:10