Edit data error

12 years 5 months ago #611 by
Edit data error was created by
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




Please Log in to join the conversation.

12 years 1 month ago #667 by
Replied by on topic Re:Edit data error
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

Please Log in to join the conversation.

Moderators: Dirkjoest