?
avatar leslieongit
leslieongit
21 Sep 2016

Steps to reproduce the issue

Edit a page via SP Page Builder > Duplicate the tabs into two >Work simultaneously > Visit site >Error

Expected result

Load index page for website, as usual

Actual result

1064 MySQL error

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 (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2016-09-21 09:30:1' at line 3 SQL=SELECT m.id, m.title, m.module, m.position, m.ordering, m.content, m.showtitle, m.params FROM #__modules AS m WHERE m.published = 1 AND m.id = AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2016-09-21 09:30:18') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2016-09-21 09:30:18') AND m.access IN (1,1) AND m.client_id = 0

System information (as much as possible)

Red Hat Enterprise Linux Platform
Dual Quad Core Intel® Xeon® processors
32 GB RAM
Dual SAS Drive (for the operating system)
RAID Mirroring (for the operating system)
Dual Power Supplies
Quad Gigabit Network Adapters

Additional comments

avatar leslieongit leslieongit - open - 21 Sep 2016
avatar zero-24
zero-24 - comment - 21 Sep 2016

Can you confirm this issue without using SP Page Builder? If not it is a SP Page Builder issue as they don't use the DB Nulldate via the API

avatar leslieongit
leslieongit - comment - 21 Sep 2016

Yes, i disabled the SP Builder (Plugin, Component and Module) and loaded the website in a Chrome incognito, but the same error still being desplayed

avatar zero-24
zero-24 - comment - 21 Sep 2016

How can you reproduce that error on the core 3.6.2 without 3party extensions?

avatar leslieongit
leslieongit - comment - 21 Sep 2016

I'm sorry, cleared my browser cache, and error disappeared. Will chick with Helix Framework page for their support.

avatar brianteeman brianteeman - close - 21 Sep 2016
avatar brianteeman
brianteeman - comment - 21 Sep 2016

Closed as not a Joomla issue

avatar brianteeman brianteeman - change - 21 Sep 2016
Status New Closed
Closed_Date 0000-00-00 00:00:00 2016-09-21 11:52:28
Closed_By brianteeman
avatar brianteeman brianteeman - close - 21 Sep 2016
avatar brianteeman brianteeman - change - 22 Sep 2016
Labels Added: ?

Add a Comment

Login with GitHub to post a comment