How can i delete the duplicate post ?
Duplicate post ...!!!
Collapse
X
-
Sorry, I don't understand. You are having problems with duplicate posts (if so, when are they happening) or you are having a problem opening old threads with more than 2000 posts, and if so, what sort of problem?
Please don't PM or VM me for support - I only help out in the threads.
vBulletin Manual & vBulletin 4.0 Code Documentation (API)
Want help modifying your vbulletin forum? Head on over to vbulletin.org
If I post CSS and you don't know where it goes, throw it into the additional.css template.
W3Schools <- awesome site for html/css help -
How many posts are you trying to remove or move at a time? Try doing less and see if you still have this problem.
Please don't PM or VM me for support - I only help out in the threads.
vBulletin Manual & vBulletin 4.0 Code Documentation (API)
Want help modifying your vbulletin forum? Head on over to vbulletin.org
If I post CSS and you don't know where it goes, throw it into the additional.css template.
W3Schools <- awesome site for html/css helpComment
-
Create a new style with no parent:
- Styles & Templates > Style Manager > Add New Style
- Parent Style: No Parent Style
- Title: Default vBulletin
- Allow User Selection: Yes
- Save
Then browse the site using that totally default vbulletin style and try to move/remove a post, do you still have the same problem?
If it is still happening - Try disabling your modifications/plugins and see if you still have this problem.
Note: To temporarily disable the plugin system, edit config.php and add this line right under <?php
PHP Code:define('DISABLE_HOOKS', true);
Please don't PM or VM me for support - I only help out in the threads.
vBulletin Manual & vBulletin 4.0 Code Documentation (API)
Want help modifying your vbulletin forum? Head on over to vbulletin.org
If I post CSS and you don't know where it goes, throw it into the additional.css template.
W3Schools <- awesome site for html/css helpComment
-
I did this ...
Code: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
When i delete ....
Code:[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
-
I did this ...
Code: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
[ATTACH=CONFIG]43258[/ATTACH]
When i delete ....
Code:[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]
[ATTACH=CONFIG]43259[/ATTACH]
How can i delete duplicate posts .... ?Comment
-
I do not know what the query would be for deleting duplicate posts. You may want to post in the PHP & HTML Questions forum or over on vbulletin.org for help with this.
Please don't PM or VM me for support - I only help out in the threads.
vBulletin Manual & vBulletin 4.0 Code Documentation (API)
Want help modifying your vbulletin forum? Head on over to vbulletin.org
If I post CSS and you don't know where it goes, throw it into the additional.css template.
W3Schools <- awesome site for html/css helpComment
Related Topics
Collapse
-
by videntityHi,
I want to delete posts from a specific user in my VB5 forum. These posts will be threads or replies to existing threads.
Option -1 - I can del the user from AdminCP but all its posts will...-
Channel: Support Issues & Questions
-
Comment