1064 error after upgrade from 2.5 to 3.3
By cc-blog on Thursday, 20 November 2014
Posted in Technical Issues
Likes 0
Views 803
Votes 0
Upgraded to the latest Easyblog as I'm migrating to 3.3.6. I now get this error trying to access blog:

Error: 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 'AS `a` LEFT JOIN AS b ON a.`id` = b.`category_id` AND b.`published` = '1' AND b' at line 1 SQL=SELECT a.`id`, a.`title`, a.`parent_id`, a.`alias`, a.`avatar`, COUNT(b.`id`) AS `cnt` , '1' AS level FROM AS `a` LEFT JOIN AS b ON a.`id` = b.`category_id` AND b.`published` = '1' AND b.`private` = '0' AND ( b.`language`='en-GB' OR b.`language`='' OR b.`language`='*' ) WHERE a.`published` = 1 AND a.`parent_id`='0' GROUP BY a.`id` HAVING (COUNT(b.`id`) > 0) ORDER BY `cnt` desc

Please advise.
Hello,

I'm sorry but can you give access to this IP address: 175.142.146.47 . However, what I meant by module is the Module from Extension>Module Manager: http://screen.stackideas.com/2014-11-21_1025.png . Did you has assigned any Easyblog module on that page?
Nik Faris
·
Friday, 21 November 2014 10:26
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello,

Can you provide us your backend and FTP so we can check on this. This is my IP: 110.159.183.94.
Nik Faris
·
Thursday, 20 November 2014 10:18
·
0 Likes
·
0 Votes
·
0 Comments
·
Unfortunately there is no FTP. It is an Amazon Linux AMI so anything you need you will have to let me know. However I've whitelisted your IP and you can log into mycamcloud.com/administrator/?ccadmin
cc-blog
·
Thursday, 20 November 2014 22:35
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello,

I'm sorry but I can't access you site because I am at home currently (different IP address). However, where did you get this error? Is there any Easyblog module on that page? If so, you might want to update your modules by downloading the latest from here: http://stackideas.com/downloads/modules . Please give it a try. Also, here is my IP address: 175.139.37.37
Nik Faris
·
Thursday, 20 November 2014 23:33
·
0 Likes
·
0 Votes
·
0 Comments
·
I've opened up that IP as well. Not sure what you mean by module. We use a hidden menu item that points to Frontpage Blog Layout. You can see the issue at mycamcloud.com/blog
cc-blog
·
Friday, 21 November 2014 06:48
·
0 Likes
·
0 Votes
·
0 Comments
·
Added your IP. No, we don't have any Easyblog module.
cc-blog
·
Friday, 21 November 2014 11:11
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello,

May I know your administrator URL? Because I've tried with this URL: http://www.mycamcloud.com/administrator/ but it redirect me to the homepage.
Nik Faris
·
Friday, 21 November 2014 12:07
·
0 Likes
·
0 Votes
·
0 Comments
·
It was an out-of-date module (categories module). All good now. Thanks.
cc-blog
·
Friday, 21 November 2014 20:44
·
0 Likes
·
0 Votes
·
0 Comments
·
Thanks for updating, glad that your issues are resolved now
Mark
·
Saturday, 22 November 2014 01:47
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post