Thread

I am running the latest EE 2.3.1 codebase

and using this code.  user 961 maybe or may not have people marked ignore but i imagine thats irrelevant

{exp:member:ignore_list member_id="961"}
{ignore_screen_name}   
{/exp:member:ignore_list}

I GET THIS ERROR

Error Number: 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 'g.site_id = '1' AND m.member_id IN ('')' at line 4

SELECT m.member_id, m.group_id, m.username, m.screen_name, m.email, m.ip_address, m.location, m.total_entries, m.total_comments, m.private_messages, m.total_forum_topics, m.total_forum_posts AS total_forum_replies, m.total_forum_topics + m.total_forum_posts AS total_forum_posts, g.group_title AS group_description FROM exp_members AS m, exp_member_groups AS g WHERE g.group_id = m.group_id g.site_id = '1' AND m.member_id IN ('')

Filename: modules/member/mod.member.php

Line Number: 3012

??? anybody?

Hi, Tony. I get the same error, even if I use member_id=“1” or leave that out altogether. Do you have anyone in the ignore list? In this particular site I don’t.

both have the problem

i mean with or without people in the ignore list

Hi Tony,

I was able to reproduce your problem as well, so I filed a bug report on your behalf. I’d suggest commenting on that bug report so you’ll be notified when it’s updated.

Thanks for bringing this to our attention! Is there anything else I can do to help?

Hi.  I did not search out the bug.  I just ran the code example in you documentation.

I did however search out this

You will get a MySQL query syntax error number 1064 when you incorrectly use a reserved word in your query such as “when” or “order”.

Each version of MYSQL reserves different words.

Hi, Tony -

That bug report didn’t exist before your post; Kevin just submitted it.  Thank you for the additional feedback!

Did you have any remaining questions?