Joomla 3.4 and error 1064

**GK User** Wed Feb 25, 2015 1:46 pm Reply with quote Report this post

Hello, after renaming My[icon-pencil][br]Cozy[br]Blog to Il[icon-pencil][br]Mio[br]Blog I just got a 1064 Error:

Code: Select all: 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 'DESC LIMIT 0,12' at line 21 SQL=SELECT content.id AS iid FROM xzaew_content AS content WHERE content.state = 1 AND content.access IN (1,1) AND ( content.publish_up = '0000-00-00 00:00:00' OR content.publish_up <= '2015-02-25 13:32:41' ) AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2015-02-25 13:32:41' ) ORDER BY content. DESC LIMIT 0,12; It appears the page you were looking for doesn't exist. Sorry about that.

I can't even figure out what's the problem, 'cause I didn't change a thing but the title itself.
(Joomla! v. 3.4)

**GK User** Wed Feb 25, 2015 3:36 pm Reply with quote Report this post

Hello,

Please upgrade your News Show Pro GK5 module to the latest version: v.1.8.0.6: https://www.gavick.com/upd/mod_news_pro_gk5_J!3.zip

**GK User** Wed Feb 25, 2015 4:52 pm Reply with quote Report this post

I gk-icon-heart You

Thanks a lot, it works like a charm

**GK User** Sat Feb 28, 2015 1:31 pm Reply with quote Report this post

I'm using the Joomla Template John. I've just made an update from 3.6.6 to 3.4. Now my website ac22.trpeter.com shows the following:

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 'DESC LIMIT 0,31' at line 21 SQL=SELECT content.id AS id FROM dj10m_k2_items AS content WHERE content.published = 1 AND content.trash = 0 AND content.access IN (1,1) AND ( content.publish_up = '0000-00-00 00:00:00' OR content.publish_up <= '2015-02-28 12:24:53' ) AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2015-02-28 12:24:53' ) AND ( content.catid = 44 ) ORDER BY content. DESC LIMIT 0,31;

I need to know how to fix this. I've already uploaded GK5 1.8.0.6. and cleared my browsing data on Google Chrome Browser. I still have the same 1064 Error. Please advise.

**GK User** Sat Feb 28, 2015 1:53 pm Reply with quote Report this post

Cool. 10 minutes after uploading the GK 5 vers. 1.8.0.6. everything is OK again. I can see my website again. Thanks for the information.