Support Forums

Support Offline : Mon - Fri / 10am - 6pm (GMT +6)

Your Time: Our Time:

SQL syntax error 1064 with pagebuilder

Featured Lock Resolved
Hi there.
I'm having some issues with the pagebuilder / Joomla module.
When i try to show another news module with pagebuilder i get SQL syntax 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 ') AND `a`.`access` IN (1,1) ORDER BY `a`.`created` DESC LIMIT 0, 2' at line 4 SQL=SELECT a.*,`b`.`alias` AS `category_alias`,`b`.`title` AS `category` FROM `rlrfk_content` AS `a` LEFT JOIN `rlrfk_categories` AS `b` ON (`a`.`catid` = `b`.`id`) WHERE `b`.`extension` = 'com_content' AND `a`.`state` = '1' AND `a`.`catid` IN () AND `a`.`access` IN (1,1) ORDER BY `a`.`created` DESC LIMIT 0, 2</code></pre>



I can get the module to work if i just show it in an article
http://rl-rfk.dk/index.php/organisation/vedtaegter : position footer-1

i tried with JA newspro module and JA Side news module.


Can you help me out, i dont know what to do ?

7 Answers

Hjalte

More than a month ago #Permalink
I just realized this has nothing to do with the module,
i tried another copy on http://redder.hls-it.dk/
i removed one row from page builder home page and got the error right away.

the error seems be in the page , i made some new pages with no error.

Hjalte

More than a month ago #Permalink
you can see the error here
http://rl-rfk.dk/

Hjalte

More than a month ago #Permalink
you can see the error here
http://rl-rfk.dk/

Hjalte

More than a month ago #Permalink
I just realized this has nothing to do with the module,
i tried another copy on http://redder.hls-it.dk/
i removed one row from page builder home page and got the error right away.

Hjalte

More than a month ago #Permalink
I just realized this has nothing to do with the module,
i tried another copy on http://redder.hls-it.dk/
i removed one row from page builder home page and got the error right away.

the error seems be in the page , i made some new pages with no error.

Hjalte

More than a month ago #Permalink
I just realized this has nothing to do with the module,
i tried another copy on http://redder.hls-it.dk/
i removed one row from page builder home page and got the error right away.

the error seems be in the page , i made some new pages with no error.


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Leaderboard (30 days)

Sifat

Sifat

Total Accepted Answers: 137
Paul Frankowski

Paul Frankowski

Total Accepted Answers: 123
Toufiq

Toufiq

Total Accepted Answers: 64
Pavel

Pavel

Total Accepted Answers: 5
W

woonydanny

Total Accepted Answers: 2

100+

Templates

200,000+

Community Users

Newsletter

Don’t miss any updates of our new templates and extensions and all the astonishing offers we bring for you.
We never spam

Joomla! ® name is used under a limited license from Open Source Matters in the United States and other countries. JoomShaper.com is not affiliated with or endorsed by Open Source Matters or the Joomla! Project.

Connect Us