When you do an export to SQL from the Music database, then the output can't be imported within SQL since there are all duplicate fileds in there. Could you change this in the language file, so that every field (also if not used) is unique.
Below a dump of my music.sql file:
Code: Select all
DROP TABLE IF EXISTS music;
CREATE TABLE music (NUM INT NOT NULL, CHECKED TEXT, MEDIA TEXT, MEDIATYPE TEXT, SOURCE TEXT, DATEADD DATE, BORROWER TEXT, RATING FLOAT, ORIGINALTITLE TEXT, TRANSLATEDTITLE TEXT, FORMATTEDTITLE TEXT, DIRECTOR TEXT, DIRECTOR TEXT, DIRECTOR TEXT, CATEGORY TEXT, YEAR INT, LENGTH INT, ACTORS TEXT, URL TEXT, DIRECTOR TEXT, COMMENTS TEXT, DIRECTOR TEXT, VIDEOBITRATE INT, AUDIOFORMAT TEXT, AUDIOBITRATE INT, DIRECTOR TEXT, DIRECTOR TEXT, DIRECTOR TEXT, DIRECTOR TEXT, DIRECTOR TEXT, DIRECTOR TEXT, PICTURENAME TEXT, PRIMARY KEY (NUM));
INSERT INTO music (NUM, CHECKED, MEDIA, MEDIATYPE, SOURCE, DATEADD, BORROWER, RATING, ORIGINALTITLE, TRANSLATEDTITLE, FORMATTEDTITLE, DIRECTOR, DIRECTOR, DIRECTOR, CATEGORY, YEAR, LENGTH, ACTORS, URL, DIRECTOR, COMMENTS, DIRECTOR, VIDEOBITRATE, AUDIOFORMAT, AUDIOBITRATE, DIRECTOR, DIRECTOR, DIRECTOR, DIRECTOR, DIRECTOR, DIRECTOR, PICTURENAME) VALUES ('1', 'True', 'Dire Straits - Alchemy: Dire Straits Live', 'CD', '', '2007-08-28', '', '6.0', 'Alchemy: Dire Straits Live', 'Dire Straits', 'Alchemy: Dire Straits Live (Dire Straits)', 'Warner Bros.', 'Warner Bros.', 'Warner Bros.', 'Rock', '1984', '94', '', 'http://www.allmusic.com/cg/amg.dll?p=amg&sql=10:difoxqr5ldfe', 'Warner Bros.', 'Review by William Ruhlmann\nThere is an interesting contrast on this 94-minute double-disc live album (recorded at London''s Hammersmith Odeon in July 1983) between the music, much of which is slow and moody, with Mark Knopfler''s muttered vocals and large helpings of his fingerpicking on what sounds like an amplified Spanish guitar, and the audience response. The arena-size crowd cheers wildly, and claps and sings along when given half a chance, as though each song were an up-tempo rocker. When they do have a song of even medium speed, such as "Sultans of Swing" or "Solid Rock," they are in ecstasy. That Dire Straits'' introspective music loses much of its detail in a live setting matters less than that it gains presence and a sense of anticipation. Alan Clark''s keyboards help to fill out the sound and give Knopfler''s spare melodies a certain majesty, but Dire Straits remains an overgrown bar band with a Bob Dylan fixation, and that''s exactly how the crowd likes it. (The CD version of the album contains one extra track, "Expresso Love," which adds a needed change of pace to the otherwise slow-moving first disc).', 'Warner Bros.', '1', 'Achat', '', 'Warner Bros.', 'Warner Bros.', 'Warner Bros.', 'Warner Bros.', 'Warner Bros.', 'Warner Bros.', 'music_1.jpg');
INSERT INTO music (NUM, CHECKED, MEDIA, MEDIATYPE, SOURCE, DATEADD, BORROWER, RATING, ORIGINALTITLE, TRANSLATEDTITLE, FORMATTEDTITLE, DIRECTOR, DIRECTOR, DIRECTOR, CATEGORY, YEAR, LENGTH, ACTORS, URL, DIRECTOR, COMMENTS, DIRECTOR, VIDEOBITRATE, AUDIOFORMAT, AUDIOBITRATE, DIRECTOR, DIRECTOR, DIRECTOR, DIRECTOR, DIRECTOR, DIRECTOR, PICTURENAME) VALUES ('2', 'True', 'Marillion - Season''s End', 'JewelCase', 'England', '2007-09-04', '', '9.0', 'Season''s End', 'Marillion', 'Season''s End (Marillion)', 'Never', 'Never', 'Never', 'Rock', '1989', '99', '', 'http://www.allmusic.com/cg/amg.dll?p=amg&sql=10:g9frxqq5ld0e', 'Never', 'Review by Jeri Montesano\nAfter Fish''s departure, Marillion teetered on the brink of collapse: The frontman''s distinct voice and poetic prose made him the defining member of the band. One can only imagine how record executives held their collective breath as Steve Hogarth was brought in to take the reins. His first outing with band, 1989''s Season''s End, removed all doubts about the band''s future. Hogarth''s unique, expressive voice fit Marillion perfectly; on the full-throttle rock assault of "The Uninvited Guest" or the emotional "After You," Hogarth''s singularity is unmistakable. The heartfelt "Easter," with its imaginative electric-acoustic arrangement, is another showcase for Hogarth''s talents. Marillion''s ability to write music whose ideals live and breathe in the listener continues on Seasons End, particularly on the inspiring "Holloway Girl," which dissects the injustice of incarcerating mentally ill female inmates (at England''s Holloway Prison) instead of placing them in appropriate psychiatric facilities. The beautiful "Easter" is the band''s plea for peace in Ireland, while "The King of Sunset Town" has its lyrical roots in the massacre at Tiananmen Square. Hogarth''s flexible range and beautiful phrasing shine on the entire album. In 1999 Marillion released a remastered version of Seasons End, including a bonus disc of outtakes and alternate versions as well as the previously unreleased "The Bell in the Sea" and "The Release." Both are strong tracks and are welcome additions to the Marillion catalog. While 1995''s Afraid of Sunlight is the peak of Marillion''s growing, impressive body of work, Season''s End shouldn''t be missed either.', 'Never', '1', 'Achat', '', 'Never', 'Never', 'Never', 'Never', 'Never', 'Never', 'music_2.jpg');
INSERT INTO music (NUM, CHECKED, MEDIA, MEDIATYPE, SOURCE, DATEADD, BORROWER, RATING, ORIGINALTITLE, TRANSLATEDTITLE, FORMATTEDTITLE, DIRECTOR, DIRECTOR, DIRECTOR, CATEGORY, YEAR, LENGTH, ACTORS, URL, DIRECTOR, COMMENTS, DIRECTOR, VIDEOBITRATE, AUDIOFORMAT, AUDIOBITRATE, DIRECTOR, DIRECTOR, DIRECTOR, DIRECTOR, DIRECTOR, DIRECTOR, PICTURENAME) VALUES ('3', 'True', 'Marillion - Brave', 'CD', 'England', '2007-09-04', '', '6.0', 'Brave', 'Marillion', 'Brave (Marillion)', 'IRS', 'IRS', 'IRS', 'Rock', '1994', '71', '', 'http://www.allmusic.com/cg/amg.dll?p=amg&sql=10:gjfrxqqgldse', 'IRS', 'Review by Dale Jensen\nRebounding from the inconsistent Holidays in Eden, Marillion retreated to the studio for 15 months to write and record the concept album Brave. Telling the story of an abused girl wandering on Severn Bridge, the album is a solid mix of symphonic tracks with a pronounced rock edge. A band known for trilogies, the final set of "The Great Escape," "The Last of You," and "Falling From the Moon" form one of the most dynamic showcases for vocalist Steve Hogarth and guitarist Steve Rothery. Brave remains the most complex Marillion release to date, with layers and layers of sound. A full-length movie of Brave, directed by Richard Stanley, was released in Europe in conjunction with the album.', 'IRS', '1', 'Achat', '', 'IRS', 'IRS', 'IRS', 'IRS', 'IRS', 'IRS', 'music_3.gif');
