1064 error with GK Bluap Theme

I've installed GK Bluap Theme on website, and when I enable a News Show Pro GK5 module, appear an 1064 error.

CMS: Joomla 3.40

Code: Select all

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 'ASC LIMIT 0,12' at line 21 SQL=SELECT content.id AS iid   FROM xxx_content AS content WHERE content.state = 1 AND ( content.publish_up = '0000-00-00 00:00:00' OR content.publish_up <= '2015-02-26 06:11:19' ) AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2015-02-26 06:11:19' ) AND ( content.catid = 2 ) ORDER BY content. ASC LIMIT 0,12;

I can't find solution.

I have a similar 1064 sql syntax error using NSP GK5 (V1.8.0.6) on a non-Gavick template. Possibly a conflict with Joomla 3.4.0 as I upgraded Joomla from 3.3.6 to 3.4.0 today.

NSP was working on J3.4.0 for many hours until I edited one element of the NSP module (number of characters in the title) and saved the module again. Nothing else changed in the NSP config at all. Error apparently caused by the "Save" process.

Error first occurred using NSP GK5 V1.8.0.3 so I updated the module to current V1.8.0.6. Error still occurs.

I realise that the 1064 error is generally due to no/incorrect data source but I have checked that and the data source is OK (K2 Category). In any event, this is a syntax error, rather than a config error. Here is the error below.

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,18' AT LINE 21 SQL=SELECT CONTENT.ID AS ID FROM IGT0Y_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-26 06:24:01' ) AND ( CONTENT.PUBLISH_DOWN = '0000-00-00 00:00:00' OR CONTENT.PUBLISH_DOWN >= '2015-02-26 06:24:01' ) AND ( CONTENT.CATID = 7 ) ORDER BY CONTENT. DESC LIMIT 0,18;

I tried with Joomla 3.3.6 and with NSP GK5 v.1.8.0.6... and nothing.

Appears the famous 1064 error.

Cyberek moderator says "you will find that in 90% of situations this is the case"...

I think that my case is into other 10%

@trekantmedia - please provide me an URL of your website - you forgot about it in your PM message.

@trekantmedia - I've just resaved the module and it is working fine now.

@trekantmedia - I've just resaved the module and it is working fine now.

Thank you !!!!!

What was the problem???

I'm curious to know.

Most probably your browser cache.

Hi,

I downloaded and installed the Quickstart for Music State for Joomla 3 (now on v3.4) and a couple of things are preventing me from using it - they all seem to be related to NewsProGK5.

A. I made a simple change (changed the K2 Category it was to read from) to one of the NPGK5 modules (Best Albums Grid Module I) assigned to the Best Albums Grid and (upon save) it forced the system to throw a 1064 error. So I changed it back to the original setting, but it still threw the error. So I had to unpublish it. Which did restore the page... but left the error message saying I had not module assigned to that gird position.

B. So I tried creating a new NPGK5 module and assigning it to that Grid. Same 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,1' at line 21 SQL=SELECT content.id AS id FROM g3ao4_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-26 14:56:09' ) AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2015-02-26 14:56:09' ) AND ( content.catid = 28 ) ORDER BY content. DESC LIMIT 0,1;

C. So then I tried creating a new Grid position and called it grid[7] - that position showed up as being empty in the page - but it is not listed in the available positions for me to assign anything to when I try that in Module Manager.

C. So I then created a whole new Grid (PATgrid) - which DOES show up... but when I go to assign a module to any of its 3 position (i.e. PATgrid[1] )- these positions do not appear in the list of available positions and thus shows on the front end as:

Error: Specified module position doesn't exist or is blank!

Any help you can give me would be most appreciated.

P

Hi,

I downloaded and installed the Quickstart for Music State for Joomla 3 (now on v3.4) and a couple of things are preventing me from using it - they all seem to be related to NewsProGK5.

Try to install -downgrade- to v.1.4.2: https://www.gavick.com/updates?task=upd ... 43&catid=6

I have the same issue and it is related to News Show Pro GK5 module after I updated Joomla V3.4.
When I unpublished News Show Pro GK5 module and the website is fine but it showed the error message when I publish the module.
The error message is

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 dxc1s_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-03-09 00:00:35' ) AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2015-03-09 00:00:35' ) ORDER BY content. DESC LIMIT 0,12;

Please help!

This is my website: http://www.woosha-design.com/main/

I have the same problem with GK Steakhouse... After the upgrade to 3.4.0 it keeps working, until you change something and save a News Show Pro module. Then you get the error.

For 100% new version of the module (1.8.0.6) is working properly under Joomla! 3.4, but you have to properly refresh your browser cache - I've checked and fixed the issues for so many users and there was no other problems - but you have to follow my instructions where proper clearing of the browser cache after installing an update for the module is the most crucial part before resaving the module settings.

Same problem for me, any solution?

This worked. Joomla didn't show the update to 1.8.0.6, so I was using the wrong version.
First update, than clear browser cache, than resave the module.
Thanks dziudek!

@lantech - as it was described many times:

1) Install NSP GK5 v.1.8.0.6 (latest version)
2) Clear the browser cache
3) Resave the module settings.

I had this issue and I just created a new News Module and set it the same way it was before. Now I have a new issue...

Please visit www.LPEX.org and you will see that under Featured Speakers I have 2 types of images one circles and 2 a smaller ovals. The goal is to have them all look like http://www.lpex.org/speakers.

How do I change the type of image we want?

Thanks!

@bigl - sorry but I don't understand your issue - for me both images on the mentioned subpages are looking in the same way.