Can't Display List of Members

15 years 4 months ago #7580 by blawrimore
Can't Display List of Members was created by blawrimore
I have read the forums extensively about creating a member list which is visible. I seem to have the list ID right but am getting this error 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 \')\' at line 1 SQL=SELECT count(u.id) FROM jos_users u, jos_comprofiler ue WHERE u.id=ue.id AND u.block !=1 AND ue.approved=1 AND ue.banned!=1 AND ue.confirmed=1 AND u.gid IN ()

Any suggestions would be greatly appreciated.

President, Lawrimore Inc., lciweb.com
Administrator, Small Business Success Network, sbsn.org

Please Log in to join the conversation.

15 years 4 months ago #7642 by CorpWebHost
Replied by CorpWebHost on topic Re:Can't Display List of Members
Hi blawrimore,

What is the name of the list that you are using? Does it contain any special characters?

Please Log in to join the conversation.

15 years 4 months ago #7647 by blawrimore
Replied by blawrimore on topic Re:Can't Display List of Members
It is the CB List (user list). This is the CB Forum so I thought that was understood. I would appreciate any advice re: what the error message is suggesting.
Thanks

President, Lawrimore Inc., lciweb.com
Administrator, Small Business Success Network, sbsn.org

Please Log in to join the conversation.

Moderators: beatnantkrileon
Time to create page: 0.388 seconds

Facebook Twitter LinkedIn