Ok, I got the following error when trying to move a thread (though the thread did move):
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 (1632) AND s.uid=u.uid AND (u.usergroup IN (1,5,7,12,2) OR CONCAT(',',u.additionalgroups,',') LIKE ',1,' OR CONCAT(',',u.additionalgroups,',') LIKE ',5,' OR CONCAT(',',u.additionalgroups,',') LIKE ',7,' OR CONCAT(',',u.additionalgroups,',') LIKE ',12,' OR CONCAT(',',u.additionalgroups,',') LIKE ',2,')
MySql is over 4, so I followed Tiki's advice to delete the inc/class_moderation.php and upload a new one from the changed files zip. I then tried to move the thread again. Did fine without an error, but when I tried to move it again, I get the same exact error! This time I know it's not the trash can, since I don't have that active on my site! Has anyone figured this one out yet?
edit: and I've tried modifying the file with both Tiki's and Crakter's fix and it keeps going from a 1066 to 1064 back to 1066 error!
edit again: well, not knowing what else to do, I went with Crakter's mysql 3 fix that Tiki has in his #26 post above...now I don't get the error anymore??? Again, I'd like to point out that mysql version is 4.0.27...
