linkback problem

today for the very first time, I clicked on moderate linkbacks in the admincp, to only find, that I have hundreds of thousands that I have never done anything with.

My dedicated server can not handle the loading of that page, it is crazy, I cant believe the page is not split up into separate pages.

So this is the error I get after about 10 minutes

Code:

Database error in vBulletin 3.6.8:

Invalid SQL:
SELECT tb.*,t.forumid FROM vb3_linkback tb
LEFT JOIN vb3_thread t on tb.t_threadid=t.threadid
WHERE t_id='0';

MySQL Error  : MySQL server has gone away
Error Number : 2006

I am still confused as what to do with those linkbacks (can only I see them) are they meant to be validated? which ones do you keep, which ones do you normally delete?

Well I cant do anything with them currently, because the page will never load with the amount I have currently.

What can I do?

Hello Matt,

you can remove linkbacks directly from db table with SQL query, the following one will remove all non-approved linkbacks:

Code:

DELETE FROM linkback WHERE t_approved = 0

An error occurred while attempting to execute your query. The following information was returned.
error number: 1146
error desc: Table '******_*****.linkback' doesn't exist


I tried this after

Code:

DELETE FROM vb3_linkback WHERE t_approved = 0

that gave me

Code:

An error occurred while attempting to execute your query. The following information was returned. 
error number: 1054 
error desc: Unknown column 't_approved' in 'where clause'

Sorry, it should be t_approve instead of t_approved.

Okay got it to work now.

now for the second part:

I am still confused as what to do with those linkbacks (can only I see them) are they meant to be validated? which ones do you keep, which ones do you normally delete?

I read the linkback documentations and that didnt really help me understand which ones to delete etc.

Hello Matt ,

If the incoming refback , pingback or trackback is related to your topic and the originated site is not a spam site then i advise you to approve it. Otherwise you shall delete them.

What about if it is a competitor site? would you keep it or delete it?

That will be a thought choice because a competitor site will be 100% related to the content and that will value both of the threads however you also supply a link to your competitive site. I believe it is a decision the webmaster shall decide. It never happened to me so i personally cannot advise anything on this matter but frankly i would keep it because i turst my boards on page seo