2007-10-03, 03:10 PM
MySQL error: 1066
Not unique table/alias: 's'
Query: DELETE s FROM (mybb_favorites s, mybb_users u) WHERE s.type='s' AND s.tid IN (177) AND s.uid=u.uid AND (u.usergroup IN (3,6,3,6) OR CONCAT(',',u.additionalgroups,',') LIKE ',3,' OR CONCAT(',',u.additionalgroups,',') LIKE ',6,' OR CONCAT(',',u.additionalgroups,',') LIKE ',3,' OR CONCAT(',',u.additionalgroups,',') LIKE ',6,')
The threads still move, but not before I receive the above^^ error.
Not unique table/alias: 's'
Query: DELETE s FROM (mybb_favorites s, mybb_users u) WHERE s.type='s' AND s.tid IN (177) AND s.uid=u.uid AND (u.usergroup IN (3,6,3,6) OR CONCAT(',',u.additionalgroups,',') LIKE ',3,' OR CONCAT(',',u.additionalgroups,',') LIKE ',6,' OR CONCAT(',',u.additionalgroups,',') LIKE ',3,' OR CONCAT(',',u.additionalgroups,',') LIKE ',6,')
The threads still move, but not before I receive the above^^ error.