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
<[EMAIL PROTECTED]> 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
> [email protected]
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev
>
>
>
_______________________________________________
mythtv-dev mailing list
[email protected]
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev
