News:

Bored?  Looking to kill some time?  Want to chat with other SMF users?  Join us in IRC chat or Discord

Main Menu

Column 'id_member' in where clause is ambiguous

Started by ryan_dwight, July 27, 2014, 05:12:44 PM

Previous topic - Next topic

ryan_dwight

I got this error
Quote
Apply Filter: Only show the error messages of this URL
http://www.myforum.com/index.php?http://www.myforum.com/mobiquo/mobiquo.php
Apply Filter: Only show the errors with the same message
Database Error: Column 'id_member' in where clause is ambiguous
Apply Filter: Only show the errors from this file
File: /home/ptcb/public_html/Sources/Subs-Members.php
Line: 1310

Quote1291:/* Hide blacklisted members from view? */
1292:if ((!empty($modSettings['spamBlocker_hideMembers']) ? $modSettings['spamBlocker_hideMembers'] : 2) == 2)
1293:$where .= ' AND sb.id_member IS NULL';
1294:
1295:$request = $smcFunc['db_query']('', '
1296:SELECT
1297:mem.id_member, mem.member_name, mem.real_name, mem.email_address, mem.icq, mem.aim, mem.yim, mem.msn, mem.member_ip, mem.member_ip2, mem.last_login,
1298:mem.posts, mem.is_activated, mem.date_registered, mem.id_group, mem.additional_groups, mg.group_name
1299:FROM {db_prefix}members AS mem
1300:LEFT JOIN {db_prefix}membergroups AS mg ON (mg.id_group = mem.id_group)
1301:LEFT JOIN {db_prefix}spamblocker_blacklist AS sb ON (sb.id_member = mem.id_member)
1302:WHERE ' . $where . '
1303:ORDER BY {raw:sort}
1304:LIMIT {int:start}, {int:per_page}',
1305:array_merge($where_params, array(
1306:'sort' => $sort,
1307:'start' => $start,
1308:'per_page' => $items_per_page,
1309:))
==>1310:);
1311:
1312:$members = array();
1313:while ($row = $smcFunc['db_fetch_assoc']($request))
1314:$members[] = $row;
1315:$smcFunc['db_free_result']($request);

any idea what is wrong?

Thank you

Kindred

That is an issue with the tapatalk mod. You will have to follow up with them on their site, since we do not support it here...
Слaва
Украинi

Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."

Advertisement: