Gossamer Forum
Home : Products : Gossamer Links : Discussions :

issues with LinkSQL 3.1.0

Quote Reply
issues with LinkSQL 3.1.0
Hi, I just got this issue after I upgrade to 3.1.0 few days back....
I had cron job setup & running from last 2 years now...
Cron /home/xxxxxx/public_html/search/admin/nph-verify.cgi --check-from 15

I get email results from it...
after upgrade I got something like this...


Checking 2009 links...

Wed Feb 15 03:00:02 2006 New child started
Wed Feb 15 03:00:02 2006 New child started
Wed Feb 15 03:00:02 2006 New child started
Wed Feb 15 03:00:02 2006 New child started
Wed Feb 15 03:00:02 2006 New child started
Wed Feb 15 03:00:02 2006 New child started
Wed Feb 15 03:00:02 2006 New child started
Wed Feb 15 03:00:02 2006 New child started
Wed Feb 15 03:00:03 2006 New child started
Wed Feb 15 03:00:03 2006 New child started
Finished launching children

451 http://www.xxx.com Success (200). Message: OK 200
180 http://www.yyy.com Success (200). Message: OK 200
741 http://www.zzz.com Success (200). Message: OK 200
....
about 200 links....
then...
820 http://www.ssss.com/ Request Failed (-4) Message: Could not
connect
Error fetching link (821): Failed to execute query: 'SELECT ID,URL FROM
lsql_Links WHERE ID = ?': MySQL server has gone away at
/home/xxxx/public_html/search/admin/Links/Tools.pm line 343.
Error fetching link (822): Failed to execute query: 'SELECT ID,URL FROM
lsql_Links WHERE ID = ?': MySQL server has gone away at
/home/xxxx/public_html/search/admin/Links/Tools.pm line 343.
Error fetching link (823): Failed to execute query: 'SELECT ID,URL FROM
lsql_Links WHERE ID = ?': MySQL server has gone away at
/home/xxx/public_html/search/admin/Links/Tools.pm line 343.
Error fetching link (824): Failed to execute query: 'SELECT ID,URL FROM
lsql_Links WHERE ID = ?': MySQL server has gone away at
/home/xxx/public_html/search/admin/Links/Tools.pm line 343.
Error fetching link (826): Failed to execute query: 'SELECT ID,URL FROM
lsql_Links WHERE ID = ?': MySQL server has gone away at
/home/xxx/public_html/search/admin/Links/Tools.pm line 343.
Error fetching link (828): Failed to execute query: 'SELECT ID,URL FROM
lsql_Links WHERE ID = ?': MySQL server has gone away at
/home/xxx/public_html/search/admin/Links/Tools.pm line 343.
nph-verify.cgi: error adding to Verify table (811): Failed to execute
query: 'INSERT INTO lsql_Verify (Status,Date_Checked,LinkID) VALUES
(?,?,?)': MySQL server has gone away at
/home/xxx/public_html/search/admin/nph-verify.cgi line 459.
nph-verify.cgi: error updating status (811): Failed to execute query:
'UPDATE lsql_Links SET Date_Checked = ? , Status = ? , Timestmp = NOW()
WHERE ID = ?': MySQL server has gone away at
/home/xxx/public_html/search/admin/nph-verify.cgi line 465.
nph-verify.cgi: error adding to Verify table (820): Failed to execute
query: 'INSERT INTO lsql_Verify (Status,Date_Checked,LinkID) VALUES
(?,?,?)': MySQL server has gone away at
/home/xxx/public_html/search/admin/nph-verify.cgi line 459.
nph-verify.cgi: error updating status (820): Failed to execute query:
'UPDATE lsql_Links SET Date_Checked = ? , Status = ? , Timestmp = NOW()
WHERE ID = ?': MySQL server has gone away at

(***** This goes on for several hunderd pages of error *****)

Total Run Time: 239 second(s)
Total Links checked: 253 [instead of 2009 that was mentioned above]
Total Links Bad: 27
Total Links Good: 226



what went wrong with new version?Frown
Subject Author Views Date
Thread issues with LinkSQL 3.1.0 jasy007 7097 Feb 16, 2006, 2:58 PM
Thread Re: [jasy007] issues with LinkSQL 3.1.0
brewt 6986 Feb 16, 2006, 3:10 PM
Thread Re: [brewt] issues with LinkSQL 3.1.0
jasy007 6948 Feb 17, 2006, 10:17 AM
Post Re: [jasy007] issues with LinkSQL 3.1.0
jasy007 6937 Feb 17, 2006, 10:27 AM
Thread Re: [jasy007] issues with LinkSQL 3.1.0
brewt 6938 Feb 17, 2006, 12:11 PM
Thread Re: [brewt] issues with LinkSQL 3.1.0
jasy007 6926 Feb 17, 2006, 12:30 PM
Thread Re: [jasy007] issues with LinkSQL 3.1.0
jasy007 6854 Mar 10, 2006, 10:36 AM
Thread Re: [jasy007] issues with LinkSQL 3.1.0
jasy007 6865 Mar 11, 2006, 11:18 AM
Post Re: [jasy007] issues with LinkSQL 3.1.0
brewt 6859 Mar 13, 2006, 1:58 PM
Post Re: [jasy007] issues with LinkSQL 3.1.0
KevM 6681 Nov 27, 2006, 4:51 AM