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: 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.
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.
-
- 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.
Please rename in the template directory file error.php to __error.php and then please paste the SQL error.
-
- 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;
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;
-
- 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.
-
- Administrator
- GK User
- Fri May 29, 2015 6:17 am
- Reply with quote
- Report this post
OK, it works. Thank you
-
- Fresh Boarder
5 posts
• Page 1 of 1