jooDatabase Forum
Welcome Guest   [Register]  [Login]
 Subject :Re:Edit data error.. 2012-03-21 23:55:51 
AntonioGraca
Joined: 2012-03-21 10:07:12
Posts: 1
Location

Hello

I have a identical problem.

Erro : 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 ';) GROUP BY a.ID ORDER BY a.`entidade` ASC LIMIT 0, 10' at line 1 SQL=SELECT a.* FROM jos_100clientes AS a WHERE (SELECT * FROM jos_100clientes;) GROUP BY a.ID ORDER BY a.`entidade` ASC LIMIT 0, 10

how you to fix the error?

version sql 5.1.61-log

António Graça

IP Logged
 Subject :Edit data error.. 2011-11-21 01:48:19 
Smoothash2o
Joined: 2011-11-21 00:33:07
Posts: 1
Location

When i click on the edit data icon for my database i get this error

 

500 - An error has occurred.

DB function failed with error number 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 'PRIMARY DESC LIMIT 0, 20' at line 1 SQL=SELECT * FROM jos_Recon AS c ORDER BY PRIMARY DESC LIMIT 0, 20

can ay one please help me

I am running

joodatabase 1.7 with the search plugin 1.6

joolma1.5

mysql 5.1

 



IP Logged
Page # 


Powered by ccBoard