From time to time, we will have hundreds or thousands of links that were rejected but are still resided in the DB. people can't resubmit their links again due to duplicated links.
I have a site that has about 10K links but at least 50% of them were links which have been rejected, as I want to upgrade to 4.0.29 I have to trim down the size of DB.
So, is there a way or SQL commands we can use to remove those links completely?
It doesn't make any difference whatsoever to an upgrade... you could have ten or maybe a hundred times more links and it wouldn't hinder an upgrade. It gets slow on a forum with hundreds of thousands of long posts, but links take much less DB space so they process quicker.
To hard-delete deleted items, DELETE FROM wsnlinks_links WHERE deleted=1;
0/5
1
2
3
4
5
This thread is closed, so you cannot post a reply.
Comments on Delete all rejected submissions at once
Forum Regular
Usergroup: Customer
Joined: May 14, 2006
Total Topics: 41
Total Comments: 103
I am on 3.4.2.
From time to time, we will have hundreds or thousands of links that were rejected but are still resided in the DB. people can't resubmit their links again due to duplicated links.
I have a site that has about 10K links but at least 50% of them were links which have been rejected, as I want to upgrade to 4.0.29 I have to trim down the size of DB.
So, is there a way or SQL commands we can use to remove those links completely?
Thanks!
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
people can't resubmit their links again due to duplicated links.
That would be a bug, but I don't accept bug reports from ancient versions other than 3.4.7, since it'd be pointless.
Forum Regular
Usergroup: Customer
Joined: May 14, 2006
Total Topics: 41
Total Comments: 103
I don't care people can't submit their sites again, what I want is to remove all those rejected links from the DB.
I have 12,179 links in total. I want to get the smooth upgrade.
Will the following code work on removing all rejected links? or will the following command affect other data on other tables?
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
It doesn't make any difference whatsoever to an upgrade... you could have ten or maybe a hundred times more links and it wouldn't hinder an upgrade. It gets slow on a forum with hundreds of thousands of long posts, but links take much less DB space so they process quicker.
To hard-delete deleted items,
DELETE FROM wsnlinks_links WHERE deleted=1;