You have an error in your SQL syntax on Joomla

Avatar
  • updated
  • Answered

Hello!


Briefly, I want to include a sub-category for one of our website www.foodnewslatam.com.


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


What I did under the Admin of BiotecLatam.com :


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!

Avatar
anonymous
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