1064 You have an error in your SQL syntax - Joomla
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!
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!
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