1064 - You have an error in your SQL syntax

More
4 years 1 month ago #60187 by trogladyte
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.

More
4 years 1 month ago #60188 by ced1870
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

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

More
4 years 1 month ago #60190 by trogladyte
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.

More
4 years 1 month ago #60191 by ced1870
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

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

More
4 years 1 month ago - 4 years 1 month ago #60199 by trogladyte
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: 4 years 1 month ago by trogladyte.

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

More
4 years 1 month ago #60200 by ced1870

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

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

Time to create page: 0.212 seconds

Fast and powerful creation, customizable and responsive.

Read More

We have 1351 guests and no members online