Re: [Fofredux-devel] mysqlcheck error and 'last update' time

[Kevin <ke...@dr...>]

Miles Beck wrote:

>Does anyone know why when I run mysqlcheck it says it cannot find two
>files? I checked and the files are there. Below is the output from
>mysqlcheck.
>
>mysqlcheck fofredux
>fofredux.fr_categories                             OK
>fofredux.fr_feeds                                  OK
>fofredux.fr_items                                  OK
>fofredux.px_feeds
>error    : Can't find file: './fofredux/px_feeds.frm' (errno: 13)
>fofredux.px_items
>error    : Can't find file: './fofredux/px_items.frm' (errno: 13)
>
>imageconnector:/var/lib/mysql/fofredux# ls
>fr_categories.frm  fr_feeds.frm  fr_items.frm  px_feeds.frm  px_items.frm
>fr_categories.MYD  fr_feeds.MYD  fr_items.MYD  px_feeds.MYD  px_items.MYD
>fr_categories.MYI  fr_feeds.MYI  fr_items.MYI  px_feeds.MYI  px_items.MYI
>
>  
>
Could it be you don't have permissions?  What does the "ls -la" output 
look like?

Is the table accessable through the database?  (show tables like 'px_', 
select * from px_feeds, etc)

>Also I noticed that the last update time for when feeds were updates
>shows as 'never'. Does anyone know how to fix this so the update time
>is populated again?
>  
>
Check to see if the cache directory is writable.  This happens when the 
cached file for a feed is missing.

-Kevin