Hi, All;
MythTV is a greate project! Thanks for all the people contributing to it.I have just downloaded the mythtv from cvs and compiled succesefully. I use the mysql database. When I start the mythfrontend, it reports:
>2005-02-01 10:42:31.482 Upgrading to schema version 1014 >DB Error (Performing database upgrade): >Query was: >ALTER TABLE record CHANGE rank recpriority INT(10) DEFAULT '0' NOT NULL; >Driver error was [2/1054]: >QMYSQL3: Unable to execute query >Database error was: >Unknown column 'rank' in 'record' If I start mythfilldatabase, it reports>
>DB Error (loading channel sources):
>Query was:
>SELECT sourceid,name,xmltvgrabber,userid,password,lineupid FROM videosource ORDER BY sourceid;
>Driver error was [2/1054]:
>QMYSQL3: Unable to execute query
>Database error was:
>Unknown column 'password' in 'field list'
So I grep all the sql files, there is no corresponding field in the sql.
it doesn't create channel table, and lost some fields in relative tables as indicated
above.
where can I find the correct sql clause to create proper mysql database.
Thanks for your kind instructions Best Regards.
Sun Zongjun
_______________________________________________ mythtv-users mailing list [email protected] http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
