I have a problem with openning the old threads (more than 2000 posts).
How can i delete the duplicate post ?
How can i delete the duplicate post ?
vBulletin 3 is end of life and will not be receiving future development. Warning: vBulletin 3.8.11 is not compatible with PHP 7.2.0 or higher.
Welcome to the vBulletin support forums! In our community forums you can receive professional support and assistance with any issues you might have with your vBulletin Products.
Useful Links for Guests:
If you are having problems posting in the relevant areas for your software, please see this topic.
define('DISABLE_HOOKS', true);
SELECT bad_rows. * FROM post AS bad_rows INNER JOIN ( SELECT threadid, dateline, username, userid, MIN( postid ) AS min_postid FROM post GROUP BY threadid, dateline, userid HAVING count( * ) >1 ) AS good_rows ON good_rows.threadid = bad_rows.threadid AND good_rows.dateline = bad_rows.dateline AND good_rows.userid = bad_rows.userid AND good_rows.min_postid <> bad_rows.postid
[B]Error[/B] [LEFT][B]SQL query:[/B] DELETE FROM `xxx_aaa`.`post` WHERE `bad_rows`.`postid` =384 [B]MySQL said: [/B] [FONT=Simplified Arabic Fixed]#1054 - Unknown column 'bad_rows.postid' in 'where clause'[/FONT][/LEFT]
SELECT bad_rows. * FROM post AS bad_rows INNER JOIN ( SELECT threadid, dateline, username, userid, MIN( postid ) AS min_postid FROM post GROUP BY threadid, dateline, userid HAVING count( * ) >1 ) AS good_rows ON good_rows.threadid = bad_rows.threadid AND good_rows.dateline = bad_rows.dateline AND good_rows.userid = bad_rows.userid AND good_rows.min_postid <> bad_rows.postid
[B]Error[/B] [LEFT][B]SQL query:[/B] DELETE FROM `xxx_aaa`.`post` WHERE `bad_rows`.`postid` =384 [B]MySQL said: [/B] [FONT=Simplified Arabic Fixed]#1054 - Unknown column 'bad_rows.postid' in 'where clause'[/FONT][/LEFT]
Comment