[mythtv-users] Upgrade from .19 to .20

[Michael T. Dean]

On 11/24/2006 02:05 AM, Mark Hetherington wrote:
> On Friday 24 November 2006 10:01, Ricky Junk wrote:
>   
>> I cannot run version 20 after upgrade from version 19.  When I run
>> mythsetup, I get the following:
>>     
...
>> 2006-11-23 16:53:02.525 Upgrading to schema version 1124
>> 2006-11-23 16:53:02.527 DB Error (Performing database upgrade):
>> Query was: ALTER TABLE cardinput ADD COLUMN radioservices TINYINT(1)
>> DEFAULT 1;
>> Error was: Driver error was [2/1005]:
>> QMYSQL3: Unable to execute query
>> Database error was:
>> Can't create table '#sql-e94_1e' (errno: 13)
>>     
> To me that looks like a permissions issue on the database.....

agreed

>  Although I 
> don't why it would be creating a table "#sql-e94_le"..... Is it definitely 
> connecting as the correct user?
>   

GRANT CREATE TEMPORARY TABLES ON mythconverg.* TO mythtv at localhost 
IDENTIFIED BY "mythtv";

perhaps?  (Above copied straight out of database/mc.sql .)

Mike