Error when moving threads after upgrade to 1.2.7 (Moderation.php)

[GFN]

Your not overwriting your inc/class_moderation.php properly - Delete it and reupload it. Make SURE you have it downloaded from the site and MAKE SURE you are putting it in the correct folder

Hi, I have tried that numerous times on the 2 forums that are having the problem but still the same error

I have searched for more updated info about this problem on this forum but can't seem to find anything new - any suggestions

MySQL is version 4

PS> After re-freshing the page after the error, the thread and post counts for the folder haven't changed but the threads have been moved

[Ryan Gordon]

Try it from the changed-files package. I wonder if somehow that file on the site didn't get completely updated

[hemi]

1.2.7 worked for me when I moved a thread this time. I didn;t get the previous error anyhow. So I assume the file was changed?

[GFN]

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 (653) AND s.uid=u.uid AND (u.usergroup IN (1,5) OR CONCAT(',',u.additionalgroups,',') LIKE ',1,' OR CONCAT(',',u.additionalgroups,',') LIKE ',5,')

Hi, I tried the file from both packs and I am still getting an error. I also tried changing the permissions of the file to a higher level but it didnt work

[Ryan Gordon]

What MySQL version are you using?

[GFN]

MySQL is version 4

4.0.27-standard

[GFN]

Any other suggestions?

[judel]

Do you have the trash can mod installed? I am getting this error when I tried to delete a thread inline moderation. It went away when I deactivated the mod.

And I'm quite surprised how often this error is coming up...is it all due to plugins or mysql? Does anyone know yet???

[Ryan Gordon]

The syntax is correct in 4.0 and up, I'm not sure what's going on.

[judel]

That's what I was wondering, since my mysql is over 4.0.