[SOLVED] mythtv and mysql5

Rikai · Last edited by Rikai on Mon Oct 24, 2005 8:37 am; edited 1 time in total

I'm sure this was a horrible idea at some level, but anyway:

For whatever reason, I elected to take my perfectly working myth box and emerge -avuD world. More or less. Anyway, I ended up with mythtv-0.18.1-r2 and mysql-5.0.13_rc (while trying to install mysql 4.1 amusingly enough). I needed to clean up myth anyway, so I deleted all my old recorded shows, and cleaned up everything else database-y I could find.

Anyway, it took a little while, but I finally got it to the point where mythtv-setup finally worked right, and mythbackend would launch successfully. I was able to get the card and such set up, and retrieved channel listings successfully. So, I went to do a mythfilldatabase. It gets a listing, and then I get this error about a million times:

marduk · Retired Dev Joined: 20 Sep 2002 Posts: 78

Oh, I encountered the same issue when I upgraded recently to 5.... :-(

MySQL 5 introduces the REPEAT keyword and unfortunately MythTV uses a column called "repeat".

What I did was edit datadirect.cpp from MythTV and change all the SQL code that uses

Rikai · Posted: Mon Oct 24, 2005 7:50 am Post subject: thanks

A-yep, that did it. Thanks alot

feld · Guru Joined: 29 Aug 2004 Posts: 593 Location: USA

i have this problem -- can anyone explain that solution better? how do i exit that source file and then have portage compile from it?

thx

-Feld
_________________
< bmg505> I think the first line in reiserfsck is

if (random(65535)< 65500) { hose(partition); for (i=0;i<100000000;i++) print_crap(); }

Xamindar · Posted: Wed Nov 16, 2005 7:25 am Post subject:

mattfite · n00b Joined: 21 Nov 2005 Posts: 6

fserafin · Posted: Wed Nov 23, 2005 4:15 am Post subject: thanks for the fix

thanks this fix worked great i wish they would update it in portage

Ian · Posted: Fri Dec 02, 2005 3:24 pm Post subject:

I get issues with the file from your ftp server.

Tons of errors from things not liking other things, I'm not really sure where it's stemming from. I kind of wish the MythTV upstream developers made more smaller releases than the occasional huge one every now and then. Has anyone filed a bug report with upstream developers?

mattfite · n00b Joined: 21 Nov 2005 Posts: 6

Ian · Posted: Sat Dec 03, 2005 6:12 am Post subject:

Sorry about the vaugeness, had to run off to go look at an apartment so I have a place to live next year... :p

Did a bit more research, looks like it's having issues with compiling against Qt4. Kind of a pain that the MythTV package hasn't been updated to compile against Qt3, or even better yet patched upstream to work. I kinda wish I could help development, but I don't have the time to jump into a project like that (yay college!).

Ian · Posted: Sat Dec 03, 2005 2:31 pm Post subject:

Ok, finally got around to getting this going, looks like it's working so far. Thanks for the help!

Xamindar · Posted: Sun Dec 04, 2005 8:57 pm Post subject:

Ok this fix DOES work but I am having another problem now and it might be related.

I haven't done much testing but it seems that every time mythfilldatabase is run my mythfrontend loses connection with mythbackend. I have mythfilldatabase run at 6 every morning and then when I try to use mythtv nothing works. Simply closing mythfrontend and reopening it fixes the problem and everything works again.

Anyone else have this problem?

mattfite · n00b Joined: 21 Nov 2005 Posts: 6

oracleofmist · Apprentice Joined: 19 Jun 2004 Posts: 235

i am also having the issue originally posted and followed the solution provided however still get the error

fserafin · Posted: Sun Jan 15, 2006 11:28 pm Post subject:

check out my post here might help you out. https://forums.gentoo.org/viewtopic-t-419085-highlight-.html

MrMEEE · n00b Joined: 08 Dec 2005 Posts: 57

I solved this problem.. I think..

I just installed as normal, and then afterwards:

# mysql -u root -p

# mysql> use mythconverg;
# mysql> flush tables;
# mysql> quit;

And everything worked