You are not logged in.
Hi everyone,
I'm currently trying to install MythTV and I followed the HowTo on the wiki, but I don't have much success.
When running "mythtv-setup" I can select my country and my language, but when I press the "Save" button, the application crashes and I got tons of error messages in my terminal. I cannot paste it all, but here is an extract:
Database error was:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ':CONTEXT, :ACTION, :DESCRIPTION, :KEYLIST, :HOSTNAME )' at line 1At the very end it says:
2011-03-05 15:05:45.428 Error preparing query: SELECT data FROM settings WHERE value = :KEY AND hostname IS NULL
2011-03-05 15:05:45.428 Driver error was [2/1146]:
QMYSQL3: Unable to prepare statement
Database error was:
Table 'mythconverg.settings' doesn't exist
SpeicherzugriffsfehlerSo I got an segmentation fault ("Speicherzugriffsfehler") at the end.
I've set up MySQL as described in the wiki. It is running and I was able to create the database and that stuff, I didn't get any error messages there. Why isn't MythTV able to handle it?
I got MySQL 5.5.9 with MythTV 0.24 on kernel 2.6.37 (i686).
Any help is appreciated!
best regards
Webmaniac2
Offline
I am having the same problem. Have you made any progress?
Offline
Made some progress by using mythconverg database from ubuntu.
On working ubuntu mythbackend:
mysqldump -u mythtv -p --extended-insert --no-create-db --add-drop-table --databases mythconverg >mythdatabase.bak
Copy mythdatabase.bak to Arch Linux.
On arch linux with empty mythconverg database (after running "mysql -u root -p < mc.sql"),
mysql -u mythtv -p mythconverg < mythdatabase.bak
Then mythtv-setup works!
Offline
Same problem here. I'm re-building a Myth server from scratch. Myth from community didn't work and aur/myththemes-0.24-fixes-svn didn't work, either.
I was able to get it to start by going back to a two year old database.
Offline
I think there is a problem when using mysql 5.5 for the database, I have encontered some other software with this incompatability. try using an older version of mysql
A temporary file is just a pipe with an attitude and a will to live.
Offline
I had the same exact problem as the op. I didn't try too hard to get the conversion to work since I thought it would be just as easy to do a new install. Haaaaa !!!
I wound up downloading older versions of myth and mysql from http://schlunix.org/archlinux/ and installed those without any real problems. I'm blacklisting mythtv, myththemes and mysql in pacman.conf until I feel like trying the conversion again.
I know thats the whimpy way out, but I'm not even a real TV fan.
Live Free or Die !
Offline