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.

Hi blawrimore,

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

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