SQL problem
By kabran jonathan on Friday, 03 October 2014
Posted in Technical Issues
Replies 5
Likes 0
Views 430
Votes 0
Hello StackIdeas,

When i log in i get this message:
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 K54RZ_SOCIAL_FRIENDS WHERE ACTOR_ID= AND STATE = 1

Some help please
Hello,

This issue is caused by your module "People Suggest". After disabling the module, the error is no longer there. As this module is not created by us, it's best that you contact the author of the module.
Mark
·
Saturday, 04 October 2014 13:15
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello kabran jonathan,

Sorry for late reply to this,
May i know which version you using now?
Also can you provide us with your Joomla backend and FTP access so we can check on this? Please advise.
Arlex Wong
·
Saturday, 04 October 2014 01:32
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello,
i am using Easysocial 1.3.4 on joomla 3.3 with PhP5.4

thanks
kabran jonathan
·
Saturday, 04 October 2014 02:15
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello kabran jonathan,

I have tried to reproduce this SQL error in your site after user logged in, but it seems like after I logged in successfully, this error didn't show out, check my video link here : http://screencast.com/t/kK9uYZ3G
Am i missing some of the step? Please advise.
Arlex Wong
·
Saturday, 04 October 2014 02:58
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello
It is not for all user but for the user that i give the credentials

thanks
kabran jonathan
·
Saturday, 04 October 2014 03:21
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post