1064 error when opening members page !
By HMED on Thursday, 06 November 2014
Posted in General Issues
Replies 7
Likes 0
Views 444
Votes 0
Hello, i am receiving an 1064 error when i clic on Online Users or Recent Users pages :

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 a.* from `dr78k_social_fields_data` as a inner join `dr78k_social_fields` as b on a.`field_id` = b.`id` where a.`type` = 'user' and a.`uid` IN ()

any idea please ?
Hi,

I've identified the issue and this will be fixed in the next version.
Jason Rey
·
Thursday, 06 November 2014 11:18
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello Jan,

Is it possible for you to provide us with the back end and FTP access to your site to check on this issue?
Mark
·
Thursday, 06 November 2014 01:07
·
0 Likes
·
0 Votes
·
0 Comments
·
just added the site info
HMED
·
Thursday, 06 November 2014 01:13
·
0 Likes
·
0 Votes
·
0 Comments
·
thank's !
HMED
·
Thursday, 06 November 2014 18:21
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi,

You're welcome.
Jason Rey
·
Thursday, 06 November 2014 18:25
·
0 Likes
·
0 Votes
·
0 Comments
·
hello, just updated to the .12 version, the issue is resolved thank you !

one question, its normal that i dont see any members in the list ?

please visite the direct link.
HMED
·
Friday, 07 November 2014 01:22
·
0 Likes
·
0 Votes
·
0 Comments
·
Thanks for updating, glad that your issues are resolved now Is there any users registered under this profile type? If there is, it should display a list of users for this profile type.
Mark
·
Friday, 07 November 2014 01:42
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post