SQL Error when i try to display a group in front-end
By Alberto Provenzi on Tuesday, 10 March 2015
Posted in Technical Issues
Replies 8
Likes 0
Views 478
Votes 0
Hi, I have a problem, I just start using Groups feature of Easysocial but i have an sql error when i try to display my group in frontend...
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 '' at line 1 SQL=SELECT title, alias, description FROM tmwfs_social_clusters_categories WHERE type = 'event' AND id =

ID=nothing!

I also tried to disable the events globally, and in the group category options but nothing change.. any suggestions?

Thanks
Hello Alberto Provenzi.

I change error reporting in your backend to maximum and created a group at your site. after i refresh your site, i can't access your site and your backend. Did you block our ip? If yes, Can you put our public ip in the white list.
Izzan Akmal
·
Tuesday, 10 March 2015 19:03
·
0 Likes
·
0 Votes
·
0 Comments
·
No, nothing changed.. now i see a blank page, back and fronted too.. i don't know why.. maybe too many errors? i don't think... i try to manually set error reporting to a lower level in my db now
Alberto Provenzi
·
Tuesday, 10 March 2015 19:08
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello Alberto Provenzi.

Can you provide us with FTP access so we can check on the issue directly?
Izzan Akmal
·
Tuesday, 10 March 2015 19:12
·
0 Likes
·
0 Votes
·
0 Comments
·
now i disabled error reporting.. maybe server can't handle the request.. but it's strange, i don't have a cheap hosting..
Alberto Provenzi
·
Tuesday, 10 March 2015 19:13
·
0 Likes
·
0 Votes
·
0 Comments
·
ftp password attached here
Alberto Provenzi
·
Tuesday, 10 March 2015 19:15
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello Alberto Provenzi,

Sorry for late reply to this,

I've checked in your site, I noticed some of the script file is missing, can I have permission to help you update your Easysocial again?

if you have do any customization, please backup first.
Arlex Wong
·
Tuesday, 10 March 2015 23:11
·
0 Likes
·
0 Votes
·
0 Comments
·
i have only a small customisation, the numbers of albums displayed.. i'll fix it by myself.. if you want perform the upgrade again
Alberto Provenzi
·
Tuesday, 10 March 2015 23:24
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello Alberto Provenzi,

After debugging long time ago, it seems like that was your MijoSEF extension causing this issues.

I've temporary disable this, it should work fine now.

Can you consult with your MijoSEF developer regarding this?

NOTE: Now your MijoSEF configuration enable setting is set to NO, but i dono why it still appeared YES.
Arlex Wong
·
Wednesday, 11 March 2015 00:22
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post