Gossamer Forum: Products: Gossamer Links: Development, Plugins and Globals: What does this error mean?

Mar 1, 2004, 10:25 AM

scorpioncapital

User (150 posts)

Mar 1, 2004, 10:25 AM

Post #1 of 5

Shortcut

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?

Mar 1, 2004, 10:59 AM

Andy

Veteran / Moderator (18441 posts)

Mar 1, 2004, 10:59 AM

Post #2 of 5

Shortcut

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

Mar 1, 2004, 12:21 PM

scorpioncapital

User (150 posts)

Mar 1, 2004, 12:21 PM

Post #3 of 5

Shortcut

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...

Mar 1, 2004, 1:48 PM

Andy

Veteran / Moderator (18441 posts)

Mar 1, 2004, 1:48 PM

Post #4 of 5

Shortcut

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

Mar 1, 2004, 6:42 PM

pugdog

Veteran / Moderator (6956 posts)

Mar 1, 2004, 6:42 PM

Post #5 of 5

Shortcut

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.