slashcode-development

[Slashcode-development] Re: cvs devel branch

[Jesse H. <je...@op...>]

so i spent a little time today hacking with the latest cvs in the main
(devel) branch. one of the sites i've been playing with is one i keep
updating with each cvs update, just as a learning exercise. currently
however i've come across a little error that i'm stuck on and coulse use
some pointers.

it occurs when i try to run the task adminmail.pl

slashd.log gives me:


Sun Mar 17 03:04:21 2002 runtask adminmail.pl begin
Sun Mar 17 03:04:21 2002 runtask Send Admin Mail Begin
DBD::mysql::st execute failed: Can't open file: 'accesslog.MYD'. (errno:
145) at /usr/local/lib/perl/5.6.1/Slash/DB/Utility.pm line 277.
Error in
library:Slash::Stats:/usr/local/share/perl/5.6.1/Slash/Stats.pm:161:SELECT
count(*) FROM accesslog WHERE to_days(now()) - to_days(ts)=1
Which was called
by:main:/usr/local/slash/site/neksis.com/tasks/adminmail.pl:32:SELECT
count(*) FROM accesslog WHERE to_days(now()) - to_days(ts)=1
DBD::mysql::st execute failed: Can't open file: 'accesslog.MYD'. (errno:
145) at /usr/local/lib/perl/5.6.1/Slash/DB/Utility.pm line 255.
Error in
library:Slash::Stats:/usr/local/share/perl/5.6.1/Slash/Stats.pm:164:SELECT
count(*)    FROM accesslog   WHERE to_days(now()) - to_days(ts)=1 GROUP BY
host_addr
Which was called
by:main:/usr/local/slash/site/neksis.com/tasks/adminmail.pl:32:SELECT
count(*)    FROM accesslog   WHERE to_days(now()) - to_days(ts)=1 GROUP BY
host_addr
Can't call method "rows" on an undefined value at
/usr/local/share/perl/5.6.1/Slash/Stats.pm line 166.

any hints? or tips?

jesse


 10:01pm  up 53 days, 15:05,  7 users,  load average: 0.07, 0.02, 0.00

Re: [Slashcode-development] Re: cvs devel branch

[Kevin T. <kt...@do...>]

The last time I had something like that was when Mysql databases got
corrupted! You can confirm if this is the case by going into a Mysql shell
and try running some simple SQL queries on those tables. If they fail, you
will need to fix that

Kevin
----- Original Message -----
From: "Jesse Hirsh" <je...@op...>
To: <sla...@li...>
Sent: Sunday, March 17, 2002 3:01 AM
Subject: [Slashcode-development] Re: cvs devel branch


>
> so i spent a little time today hacking with the latest cvs in the main
> (devel) branch. one of the sites i've been playing with is one i keep
> updating with each cvs update, just as a learning exercise. currently
> however i've come across a little error that i'm stuck on and coulse use
> some pointers.
>
> it occurs when i try to run the task adminmail.pl
>
> slashd.log gives me:
>
>
> Sun Mar 17 03:04:21 2002 runtask adminmail.pl begin
> Sun Mar 17 03:04:21 2002 runtask Send Admin Mail Begin
> DBD::mysql::st execute failed: Can't open file: 'accesslog.MYD'. (errno:
> 145) at /usr/local/lib/perl/5.6.1/Slash/DB/Utility.pm line 277.
> Error in
> library:Slash::Stats:/usr/local/share/perl/5.6.1/Slash/Stats.pm:161:SELECT
> count(*) FROM accesslog WHERE to_days(now()) - to_days(ts)=1
> Which was called
> by:main:/usr/local/slash/site/neksis.com/tasks/adminmail.pl:32:SELECT
> count(*) FROM accesslog WHERE to_days(now()) - to_days(ts)=1
> DBD::mysql::st execute failed: Can't open file: 'accesslog.MYD'. (errno:
> 145) at /usr/local/lib/perl/5.6.1/Slash/DB/Utility.pm line 255.
> Error in
> library:Slash::Stats:/usr/local/share/perl/5.6.1/Slash/Stats.pm:164:SELECT
> count(*)    FROM accesslog   WHERE to_days(now()) - to_days(ts)=1 GROUP BY
> host_addr
> Which was called
> by:main:/usr/local/slash/site/neksis.com/tasks/adminmail.pl:32:SELECT
> count(*)    FROM accesslog   WHERE to_days(now()) - to_days(ts)=1 GROUP BY
> host_addr
> Can't call method "rows" on an undefined value at
> /usr/local/share/perl/5.6.1/Slash/Stats.pm line 166.
>
> any hints? or tips?
>
> jesse
>
>
>  10:01pm  up 53 days, 15:05,  7 users,  load average: 0.07, 0.02, 0.00
>
>
> _______________________________________________
> Slashcode-development mailing list
> Sla...@li...
> https://lists.sourceforge.net/lists/listinfo/slashcode-development
>

Re: [Slashcode-development] Re: cvs devel branch

[Jesse H. <je...@op...>]

hey kevin, thanks, that was indeed the problem. i dropped the accesslog
table, recreated it, and everything's fine now...

i guess another option would have been to use myisamchk?

jesse

  6:22am  up 53 days, 23:25,  6 users,  load average: 0.21, 0.23, 0.16


On Sun, 17 Mar 2002, Kevin Tam wrote:

> The last time I had something like that was when Mysql databases got
> corrupted! You can confirm if this is the case by going into a Mysql shell
> and try running some simple SQL queries on those tables. If they fail, you
> will need to fix that
>
> Kevin
> >
> >  10:01pm  up 53 days, 15:05,  7 users,  load average: 0.07, 0.02, 0.00