Error 1064 after updating NSP GK5 configuration

Amazing blog Joomla template for personal website with extensive features, additional typography and nice showcase of featured posts.
Rate this topic: Evaluations: 1, 1.00 on the average.Evaluations: 1, 1.00 on the average.Evaluations: 1, 1.00 on the average.Evaluations: 1, 1.00 on the average.Evaluations: 1, 1.00 on the average.Evaluations: 1, 1.00 on the average.1.00 out of 6 based on 1 vote(s)
GK User
Wed May 27, 2015 6:18 pm
Reply with quote
Report this post
Hi,

I use a module NSP GK5 to publish a blog here:
http://www.lara-mazzarino.fr/index.php/blog

I have ten pages with 3 items on each page. As I was publishing a 31th item, I changed "Amount of pages with art" (from article layout) from 10 to 20. I got an error 1064. I updated GK5 to V1.8.3 but trouble remained. I set back to 10 but no result. My website worked for months perfectly before the modification. Would you help me, please.
User avatar
Fresh Boarder

GK User
Wed May 27, 2015 7:54 pm
Reply with quote
Report this post
Hello,

Please rename in the template directory file error.php to __error.php and then please paste the SQL error.
User avatar
Administrator

GK User
Thu May 28, 2015 3:56 pm
Reply with quote
Report this post
I did it. This is the error message (I replace table prefix by ddddd):

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,39' at line 21 SQL=SELECT content.id AS id FROM ddddd_k2_items AS content WHERE content.published = 1 AND content.trash = 0 AND content.access IN (1,1,5) AND ( content.publish_up = '0000-00-00 00:00:00' OR content.publish_up <= '2015-05-28 10:47:29' ) AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2015-05-28 10:47:29' ) AND ( content.catid = 12 ) ORDER BY content. DESC LIMIT 0,39;
User avatar
Fresh Boarder

GK User
Thu May 28, 2015 4:23 pm
Reply with quote
Report this post
Please refresh your browser cache and then please resave your NSP GK5 module instances - if it won't help - please use a different browser and please again resave all NSP GK5 instances.
User avatar
Administrator

GK User
Fri May 29, 2015 6:17 am
Reply with quote
Report this post
OK, it works. Thank you ;)
User avatar
Fresh Boarder


cron
Remember me
Register New Account
If you are old Gavick user, click HERE for steps to retrieve your account.