1064 - You have an error in your SQL syntax

1064 - You have an error in your SQL syntax was created by trogladyte

Posted 3 years 1 month ago #60187
2nd weird one today.

I have a Joomla article turned PB article. Added a row with regular text block. Added a 2nd row with an accordion. Made a bunch of PB pages containing just YouTube videos. Used the {pagebuilderck 1} shortcode to add those pages to the accordion.

Added a regular Joomla single article menu item to point to the article I first made. When trying to access this I get the error:

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1

I am using MariaDB 10.3.

I made a regular Joomla article and added {pagebuilderck 1} and linked a menu item to it - no problem. It's just having a problem when I embed the shortcode in the accordion. If I remove the accordion row the page displays correctly.

A good landing is one you can walk away from.
A great landing is one where you can reuse the aircraft!

Please Log in or Create an account to join the conversation.

Replied by ced1870 on topic 1064 - You have an error in your SQL syntax

Posted 3 years 1 month ago #60188
Hi
does the error occur in the admin or front side ?
if I'm right, it only breaks in the frontend , do you confirm ?
CEd

Joomlack Webmaster and Developer

by ced1870

Please Log in or Create an account to join the conversation.

Replied by trogladyte on topic 1064 - You have an error in your SQL syntax

Posted 3 years 1 month ago #60190
Only seeing any issues on the frontend and only that particular menu item/article.

www.ckdev.info/ncpmiles

A good landing is one you can walk away from.
A great landing is one where you can reuse the aircraft!

Please Log in or Create an account to join the conversation.

Replied by ced1870 on topic 1064 - You have an error in your SQL syntax

Posted 3 years 1 month ago #60191
can you please confirm that the page builder ck page ID 1 exists ? just to be sure ;)
if you are loading other pages within this article, does it work .
can you preview this page ID 1 in frontend if not into an article ?

Joomlack Webmaster and Developer

by ced1870

Please Log in or Create an account to join the conversation.

Replied by trogladyte on topic 1064 - You have an error in your SQL syntax

Posted 3 years 1 month ago #60199
Yes, PB 1 and 2 exist and I've displayed them by adding the shortcode to a PB article w/o accordions. On that note, I thought we used to be able to add a menu item direct to a PB article. Do I remember that wrong, or was that feature removed?

FYI, this issue exists on the same site as the other issue I'm having (the buttons one) so you will have the login already via email.

A good landing is one you can walk away from.
A great landing is one where you can reuse the aircraft!

Last Edit:3 years 1 month ago by trogladyte
Last edit: 3 years 1 month ago by trogladyte.

Please Log in or Create an account to join the conversation.

Replied by ced1870 on topic 1064 - You have an error in your SQL syntax

Posted 3 years 1 month ago #60200

be able to add a menu item direct to a PB article

this feature has been removed this since long, you must use the articles to do that

so the sql error is fixed on your side ?

Joomlack Webmaster and Developer

by ced1870

Please Log in or Create an account to join the conversation.

Time to create page: 0.719 seconds

Fast and powerful creation, customizable and responsive.

Read More

We have 970 guests and no members online