| Summary: | collectiondb cannot insert items contain non-latin chars | ||
|---|---|---|---|
| Product: | [Applications] amarok | Reporter: | LuRan <hephooey_dev> |
| Component: | general | Assignee: | Amarok Bugs <amarok-bugs-null> |
| Status: | RESOLVED DUPLICATE | ||
| Severity: | normal | ||
| Priority: | NOR | ||
| Version First Reported In: | unspecified | ||
| Target Milestone: | --- | ||
| Platform: | Compiled Sources | ||
| OS: | Linux | ||
| Latest Commit: | Version Fixed/Implemented In: | ||
| Sentry Crash Report: | |||
Version: svn snapshot (using KDE Devel) Installed from: Compiled sources Compiler: gcc 4.1.0 snapshot OS: Linux Just svn updated yesterday, after rebuild the collection, all the songs have non-latin chars in their tags or path is lost. and amarok gives error messages like this: amarok: [CollectionDB] [ERROR!] [virtual int SqliteConnection::insert(const QString&, const QString&)] sqlite3_compile error: amarok: [CollectionDB] [ERROR!] unrecognized token: "'� amarok: [CollectionDB] [ERROR!] on insert: INSERT INTO tags_temp ( url, dir, createdate, modifydate, album, artist, genre, year, title, composer, comment, track, discnumber, sampler, length, bitrate, samplerate, filesize, filetype ) VALUES ('/home/hooey/video/anison/Drama CD 空の境界「俯瞰風景」/18_ソラヲコエテ.mp3','/home/hooey/video/anison/Drama CD 空の境界「俯瞰風景」',1136095463,1136095463,87,17,3,'8','ソラヲコエテENDING THEME', 18 , 0 , 0,125,128,44100,2005120,1) Before the update I was using a snapshot fetched in a week before which works fine. So the bug must be introduced in the last week, probably the sqlite update?