[mythtv] mythfilldatabase error with current cvs

[Neil Rubin]

The problem seems to be caused by newer versions of MySQL, which have
a new  privilege for creating temporary tables, something which
mythfilldatabase does.

To fix, log in to your mysql database:

      mysql -u root -p

And fix the permissions:

      use mythconverg
      update db set Create_tmp_table_priv="Y" where db="mythconverg";

Neil

On Wed, 23 Feb 2005 18:03:14 -0800, Jeremy Hanmer
<jeremy at hq.newdream.net> wrote:
> Just updated to current CVS from a week-old copy and got the following
> error while running mythfilldatabase:
> 
> DB Error (Inserting into programgenres table):
> Query was:
> INSERT IGNORE INTO programgenres (chanid, starttime, relevance, genre)
> SELECT chanid, starttime, relevance, class FROM dd_v_program, dd_genre
> WHERE (dd_v_program.programid = dd_genre.programid);
> Driver error was [2/1146]:
> QMYSQL3: Unable to execute query
> Database error was:
> Table 'mythconverg.dd_v_program' doesn't exist
> 
> 
> _______________________________________________
> mythtv-dev mailing list
> mythtv-dev at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev
> 
> 
>