Gossamer Forum
Home : Products : Gossamer Links : Development, Plugins and Globals :

What does this error mean?

Quote Reply
What does this error mean?
Does anybody know what this explosive death means :)

Code:

Links (22617): Links::environment called at /home/eurogirls/cgi-bin/admin/Links.pm line 425 with no arguments.
Links (22617): Links::fatal called at /usr/lib/perl5/5.8.0/CGI/Carp.pm line 301 with arguments
([Mon Mar 1 13:11:17 2004] update_days2.cgi: Error: Failed to execute query: '
[Mon Mar 1 13:11:17 2004] update_days2.cgi: SELECT *
[Mon Mar 1 13:11:17 2004] update_days2.cgi: FROM lsql_CatLinks, lsql_Links
[Mon Mar 1 13:11:17 2004] update_days2.cgi: WHERE lsql_CatLinks.LinkID = lsql_Links.ID AND (( lsql_CatLinks.CategoryID = '23' ) AND ( lsql_Links.isValidated = 'Yes' ))
[Mon Mar 1 13:11:17 2004] update_days2.cgi: ORDER BY Live_Date DESC LIMIT 3
[Mon Mar 1 13:11:17 2004] update_days2.cgi: ' Reason: Got error 127 from table handler . ID: at update_days2.cgi line 182. at /usr/lib/perl5/5.8.0/CGI/Carp.pm line 301.
).
Links (22617): CGI::Carp::realdie called at /usr/lib/perl5/5.8.0/CGI/Carp.pm line 379 with arguments
([Mon Mar 1 13:11:17 2004] update_days2.cgi: Error: Failed to execute query: '
[Mon Mar 1 13:11:17 2004] update_days2.cgi: SELECT *
[Mon Mar 1 13:11:17 2004] update_days2.cgi: FROM lsql_CatLinks, lsql_Links
[Mon Mar 1 13:11:17 2004] update_days2.cgi: WHERE lsql_CatLinks.LinkID = lsql_Links.ID AND (( lsql_CatLinks.CategoryID = '23' ) AND ( lsql_Links.isValidated = 'Yes' ))
[Mon Mar 1 13:11:17 2004] update_days2.cgi: ORDER BY Live_Date DESC LIMIT 3
[Mon Mar 1 13:11:17 2004] update_days2.cgi: ' Reason: Got error 127 from table handler . ID: at update_days2.cgi line 182.).
Links (22617): CGI::Carp::die called at update_days2.cgi line 182 with arguments
(Error: Failed to execute query: '
SELECT *
FROM lsql_CatLinks, lsql_Links
WHERE lsql_CatLinks.LinkID = lsql_Links.ID AND (( lsql_CatLinks.CategoryID = '23' ) AND ( lsql_Links.isValidated = 'Yes' ))
ORDER BY Live_Date DESC LIMIT 3
' Reason: Got error 127 from table handler . ID: ).


Is it a database problem or some corruption?
Quote Reply
Re: [scorpioncapital] What does this error mean? In reply to
Quote:
Reason: Got error 127 from table handler . ID: at update_days2.cgi line 182. at /usr/lib/perl5/5.8.0/CGI/Carp.pm line 301.

Looks like a database problem. Sometimes you can fix this by going into MySQL, and typing;

REPAIR TABLE lsql_Links;
REPAIR TABLE lsql_Category;
REPAIR TABLE lsql_CatLinks;

If that doesn't work, you may wanna give myisamchk a go. That fixes most problems (unless its severe database damage).

Hope that helps.

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [Andy] What does this error mean? In reply to
Indeed that was the problem. Is this a common behaviour of LSQL? If so I guess one can crontab the repair tables once every month or soemthing...
Quote Reply
Re: [scorpioncapital] What does this error mean? In reply to
I wouldn't recommend running it that often. Only really run it as often as is needed. Keeping 'mysqldump' backups of your database is also a good idea.

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [Andy] What does this error mean? In reply to
Actually, unless it's changed in the current versions, MySQL suggested running the ISAM/Repair tables code fairly often, with different flags to maintain code, keep indexes packed, and find little problems before they became big ones.

Check the MySQL site for what they suggest now.

Because of the nature of the beast, keeping tabs on the index files, especially, is not a bad idea.


PUGDOG´┐Ż Enterprises, Inc.

The best way to contact me is to NOT use Email.
Please leave a PM here.