You have an error in your SQL syntax on Joomla

  • updated
  • Answered


Briefly, I want to include a sub-category for one of our website

Since I do not know how to proceed I ran some tests from the admin of another of our website is NOT online yet!

What I did under the Admin of :

I went to Content > Categories and I changed the name of ID 22 (this ID was unpublished and should remain unpublished).

So, to see what would happen, for ID 22 I changed the name "Cereales / Panadería" to "Cereales / Panadería / Colores".

I saved this change just to see what it would do.

And later, I put the original name back "Cereales / Panadería" but now when I go to Content > Articles it generates SQL error syntax 1064.

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 '' at line 1 SQL=SELECT title FROM e5pxb_categories WHERE id =

Please help. Our technical guys cannot fix it!

Hello Jcguieysse,

So you currently have the category set to "Cereales / Panadería" correct? Quick question whey do you have a / in there? If you want a category to be a child of another then that is easy to setup. Have you tried changing that category name to something else to see if it works after that?

Best Regards,
TJ Edens