By Vlassis on Tuesday, 20 October 2015
Posted in Technical Issues
Replies 3
Likes 0
Views 0.9K
Votes 0
Hello,
Please try to login at back end with the username given at Details.

I am receiving:

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 'AND state = 1' at line 1 SQL=SELECT target_id FROM wmpx9_social_friends WHERE actor_id= AND state = 1


I checked that issue at an old post here and I see that if I disable the T3 People Suggest module, it works OK.

But at your solution http://stackideas.com/forums/1064-sql-syntax-error you made a file modification.

So is it EasySocial issue or TechJoomla ?

Thanks!
Hello Vaggelis,

I've checked the forum post : http://stackideas.com/forums/1064-sql-syntax-error , the file that was attached there is actually for other issue. As you can see the accepted answer for that thread is:
It seems like it is coming from this module: mod_people_suggest . I have temporarily disable this module, and your site is working correctly. Can you please consult this issue with the developers/support team of this module. Please do update us back on this issue.


You might want to consult with the author of that module about this error.
·
Tuesday, 20 October 2015 16:48
·
0 Likes
·
0 Votes
·
0 Comments
·
Yes!

I updated it and it is working perfect :-)

Very thank you
·
Tuesday, 20 October 2015 19:13
·
0 Likes
·
0 Votes
·
0 Comments
·
You are most welcome, Vaggelis.
·
Tuesday, 20 October 2015 19:28
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post