1. Qubic
  2. Monday, 28 September 2015
hi

i have edited the page builder and now getting the following error on the qubic template when i go to the home page

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 ') AND `a`.`access` IN (1,1,2,3,6) ORDER BY `a`.`created` DESC LIMIT 0, 6' at line 4 SQL=SELECT a.*,`b`.`alias` AS `category_alias`,`b`.`title` AS `category` FROM `z8zlb_content` AS `a` LEFT JOIN `z8zlb_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,2,3,6) ORDER BY `a`.`created` DESC LIMIT 0, 6

thanks
Responses (7)
Hi there,

Please restore your site from it's well working backup version or, if you don't have a backup copy of your web-site, try reinstalling SP Page Builder over its existing installation. See how it goes.

Regards,

Alex
  1. more than a month ago
  2. Qubic
  3. # 1
this is ridiculous, its happened again after redoing the whole site again

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 ') AND `a`.`access` IN (1,1,2,3,6) ORDER BY `a`.`created` DESC LIMIT 0, 6' at line 4 SQL=SELECT a.*,`b`.`alias` AS `category_alias`,`b`.`title` AS `category` FROM `z8zlb_content` AS `a` LEFT JOIN `z8zlb_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,2,3,6) ORDER BY `a`.`created` DESC LIMIT 0, 6
  1. more than a month ago
  2. Qubic
  3. # 2
Hi there,

I am not sure what you exactly done under SP Page Builder but your SQL error doesn't seem to be SP PB related, - it rather has something to do with your com_content, Joomla core content component.

Feel free to PM me your site URL and its Joomla super user credentials to have a look around. Don't forget to include reference to this thread in your PM.

Regards,

Alex
  1. more than a month ago
  2. Qubic
  3. # 3
Hi Craig,

I can not get in, neither into your back-, nor into your front-end, with the super user details you PMed me. Please check it out.

Regards,

Alex
  1. more than a month ago
  2. Qubic
  3. # 4
ah whoops, try now
  1. more than a month ago
  2. Qubic
  3. # 5
Hi Craig,

I am in now, thanks.

I was not able to reproduce your error: created a new page ("Alex Testing";) on your site and was able to slightly edit and save it with no issues whatsoever.

Regards,

Alex
  1. more than a month ago
  2. Qubic
  3. # 6
hi

yeah as i said, i have already done that but its the "home" page that has that error

also, i am unable to chance the font colour in the slider module, it doesnt seem to work when i add a different colour

thanks
Craig
  1. more than a month ago
  2. Qubic
  3. # 7


There are no replies made for this post yet.
Be one of the first to reply to this post!


This forum is archived

This forum has been archived. Please use JoomShaper official support system.