/usr/share/vdr-xxv/contrib/update-xxv benutzt die Datei upgrade-xxv-db.sql
Darin werden die Tabellen erzeugt:
create table
...
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
Und genau darüber stolpert mein MySQL-Server 4.0.24 mit der folgenden Fehlermeldung:
update-xxv
----------
Info: Checking Server
Info: Checking Database
Info: Retrieving current version
Info: current database version: 0
Info: new database version: 2
Info: Starting update...
Info: Saving Data
Info: Updating Database
ERROR 1064 at line 21: 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 'DEFAULT CHARSET=latin1' at line 19
ERROR 1064 at line 46: 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 'DEFAULT CHARSET=latin1' at line 18
ERROR 1064 at line 70: 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 'DEFAULT CHARSET=latin1 COMMENT='0.35'' at line 14
ERROR 1064 at line 90: 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 'DEFAULT CHARSET=latin1' at line 15
ERROR 1064 at line 111: 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 'DEFAULT CHARSET=latin1' at line 4
ERROR 1064 at line 121: 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 'DEFAULT CHARSET=latin1' at line 14
ERROR 1064 at line 141: 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 'CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
PRIMARY KEY (
ERROR 1064 at line 160: 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 'CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
PRIMARY KEY (
ERROR 1064 at line 185: 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 'DEFAULT CHARSET=latin1' at line 8
ERROR 1064 at line 199: 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 'DEFAULT CHARSET=latin1' at line 3
ERROR 1064 at line 208: 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 'DEFAULT CHARSET=latin1 COMMENT='V0.30'' at line 4
Info: Restoring Data
ERROR 1146 at line 1: Table 'xxv.AUTOTIMER' doesn't exist
Error: Can't load table 'AUTOTIMER'
Viele Grüße,
Manfred