[mythtv-users] Getting mythfilldatabase error

[Darren]

On Friday 23 February 2007 09:17, Sreeram Kumar wrote:
> Hi,
>   My mythfilldatabase doesnt run automatically. when I
> checked the log I am seeing the following error. I am
> able to run it manually though. Also, I see the
> videosource as a table in the database when i do
> select tables; I have a cron job "01 10 * * * sleep
> $(expr $RANDOM \% 14400) && mythfilldatabase >
> /var/log/mythtv/mythfilldatabase.log 2>&1
> "
>
> Thanks,
> Sreeram
>
> 2007-01-27 22:14:54.256 Using runtime prefix = /usr
> 2007-01-27 22:14:54.274 New DB connection, total: 1
> 2007-01-27 22:14:54.280 Connected to database
> 'mythconverg' at host: localhost
> 2007-01-27 22:14:54.284 DB Error (loading channel
> sources):
> Query was:
> SELECT
> sourceid,name,xmltvgrabber,userid,password,lineupid
> FROM videosource  ORDER BY sourceid;
> Driver error was [2/1146]:
> QMYSQL3: Unable to execute query
> Database error was:

This error can happen with the wrong file permissions, regardless of mysql 
permissions.
> Table 'mythconverg.videosource' doesn't exist
>
change file permissions of /var/lib/mysql/mythconverg/ and files to owner 
mysql, group mysql  and 660 or 666