2007-09-04, 01:46 PM
- MyBB Version - 1.2.9
- PHP version - 4.3.11
- MySQL version - MySQL 3.23.58
- Browser - IE7
- Language (forum) - Dutch
I get a SQL error when moving discussions in my forum. What can it be?
First I enter the topic and then goto the moderation bar.
I select the option to move it and leave a link for 1 day (or more days, tried more values) like the picture.
When confirming it I got the following SQL error (i think in hte moderation.php since that one was in my adres bar):
MySQL error: 1064
You have an error in your SQL syntax near 's FROM (mybb_favorites s, mybb_users u) WHERE s.type='s' AND s.tid IN (145) AND ' at line 1
Query: DELETE s FROM (mybb_favorites s, mybb_users u) WHERE s.type='s' AND s.tid IN (145) AND s.uid=u.uid AND (u.usergroup IN (5,1) OR CONCAT(',',u.additionalgroups,',') LIKE ',5,' OR CONCAT(',',u.additionalgroups,',') LIKE ',1,')
The same thing happens when I'm in the display where I see all the discussions in the forum. I mark 1 discussion, and chose to move it via the moderationbar. I select the new location, and then the SQL error appears again.
MySQL error: 1064
You have an error in your SQL syntax near 's FROM (mybb_favorites s, mybb_users u) WHERE s.type='s' AND s.tid IN (147) AND ' at line 1
Query: DELETE s FROM (mybb_favorites s, mybb_users u) WHERE s.type='s' AND s.tid IN (147) AND s.uid=u.uid AND (u.usergroup IN (1,5,1,5,7) OR CONCAT(',',u.additionalgroups,',') LIKE ',1,' OR CONCAT(',',u.additionalgroups,',') LIKE ',5,' OR CONCAT(',',u.additionalgroups,',') LIKE ',1,' OR CONCAT(',',u.additionalgroups,',') LIKE ',5,' OR CONCAT(',',u.additionalgroups,',') LIKE ',7,')
The funny thing is that the disccussion is moved, and a link is on the old location. The SQL error is there for a reason, but I don't know what it is.
Help?