Upgrade for test
Go to maintenance
Click button
Database error in vBulletin 4.2.2:
Invalid SQL:
DELETE FROM radioforum_dbtech_usertag_mention AS mention
WHERE mention.postid IN(
SELECT mention_sub.postid FROM radioforum_dbtech_usertag_mention AS mention_sub
LEFT JOIN radioforum_post AS post ON(post.postid = mention_sub.postid)
WHERE mention_sub.type = 'post'
AND post.postid IS NULL
);
MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AS mention
WHERE mention.postid IN(
SELECT mention_sub.postid FROM testvb42' at line 1
Error Number : 1064
MySQL 5.1.72
Go to maintenance
Click button
Database error in vBulletin 4.2.2:
Invalid SQL:
DELETE FROM radioforum_dbtech_usertag_mention AS mention
WHERE mention.postid IN(
SELECT mention_sub.postid FROM radioforum_dbtech_usertag_mention AS mention_sub
LEFT JOIN radioforum_post AS post ON(post.postid = mention_sub.postid)
WHERE mention_sub.type = 'post'
AND post.postid IS NULL
);
MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AS mention
WHERE mention.postid IN(
SELECT mention_sub.postid FROM testvb42' at line 1
Error Number : 1064
MySQL 5.1.72
