1064 - You have an error in your SQL syntax
- trogladyte
- Topic Author
- Offline
- Platinum Member
-
4 years 1 month ago #60187
by trogladyte
A good landing is one you can walk away from.
A great landing is one where you can reuse the aircraft!
1064 - You have an error in your SQL syntax was created 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.
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.
4 years 1 month ago #60188
by ced1870
Joomlack Webmaster and Developer
Replied by ced1870 on topic 1064 - You have an error in your SQL syntax
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
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.
- trogladyte
- Topic Author
- Offline
- Platinum Member
-
4 years 1 month ago #60190
by trogladyte
A good landing is one you can walk away from.
A great landing is one where you can reuse the aircraft!
Replied by trogladyte on topic 1064 - You have an error in your SQL syntax
Only seeing any issues on the frontend and only that particular menu item/article.
www.ckdev.info/ncpmiles
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.
4 years 1 month ago #60191
by ced1870
Joomlack Webmaster and Developer
Replied by ced1870 on topic 1064 - You have an error in your SQL syntax
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 ?

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.
- trogladyte
- Topic Author
- Offline
- Platinum Member
-
4 years 1 month ago - 4 years 1 month ago #60199
by trogladyte
A good landing is one you can walk away from.
A great landing is one where you can reuse the aircraft!
Replied by trogladyte on topic 1064 - You have an error in your SQL syntax
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.
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.
4 years 1 month ago #60200
by ced1870
so the sql error is fixed on your side ?
Joomlack Webmaster and Developer
Replied by ced1870 on topic 1064 - You have an error in your SQL syntax
this feature has been removed this since long, you must use the articles to do thatbe able to add a menu item direct to a PB article
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