Your browser was unable to load all of the resources. They may have been blocked by your firewall, proxy or browser configuration.
Press Ctrl+F5 or Ctrl+Shift+R to have your browser try again.

Initialisation SQL Table #61

#1

I m a new User of RompR, and i try to install on a Debian 9 , with Apache2 and MariaDB.
It seems there is an issue in Table creation.
I have the following Logs.
Could someone help me ?
Regards.

MYSQL : Running old version of MariaDB, will have to use old style update query
WARN :GENERIC_SQL : Command Failed : CREATE TABLE IF NOT EXISTS Tracktable(TTindex INT UNSIGNED NOT NULL AUTO_INCREMENT UNIQUE, PRIMARY KEY(TTindex), Title VARCHAR(255), Albumindex INT UNSIGNED, TrackNo SMALLINT UNSIGNED, Duration INT UNSIGNED, Artistindex INT UNSIGNED, Disc TINYINT(3) UNSIGNED, Uri VARCHAR(2000), LastModified CHAR(32), Hidden TINYINT(1) UNSIGNED DEFAULT 0, DateAdded TIMESTAMP DEFAULT CURRENT_TIMESTAMP, isSearchResult TINYINT(1) UNSIGNED DEFAULT 0, justAdded TINYINT(1) UNSIGNED DEFAULT 1, Sourceindex INT UNSIGNED DEFAULT NULL, LinkChecked TINYINT(1) UNSIGNED DEFAULT 0, isAudiobook TINYINT(1) UNSIGNED DEFAULT 0, usedInPlaylist TINYINT(1) UNSIGNED DEFAULT 0, Genreindex INT UNSIGNED DEFAULT 0, TYear YEAR, UNIQUE INDEX(Albumindex, Artistindex, TrackNo, Disc, Title)) ENGINE=InnoDB
ERROR : MYSQL ERROR : : 1071 : Specified key was too long; max key length is 767 bytes

  • replies 1
  • views 1.1K
  • likes 0
croi2991 · Author
#2

I Made a change to pass this step,
in the file init_database_class.php, i replace Title VARCHAR(255) by Title VARCHAR(190)