[prev in list] [next in list] [prev in thread] [next in thread] 

List:       kde-bugs-dist
Subject:    [Bug 95351] New: database doesn't function with sqlite,
From:       christian linzatti <christian.linzatti () gmx ! at>
Date:       2004-12-17 18:11:22
Message-ID: 20041217191120.95351.christian.linzatti () gmx ! at
[Download RAW message or body]

------- You are receiving this mail because: -------
You are on the CC list for the bug, or are watching someone who is.
        
http://bugs.kde.org/show_bug.cgi?id=95351        
           Summary: database doesn't function with sqlite, scan doesn't
                    function, xine, 1.2CVS
           Product: amarok
           Version: unspecified
          Platform: Gentoo Packages
        OS/Version: Linux
            Status: UNCONFIRMED
          Severity: crash
          Priority: NOR
         Component: general
        AssignedTo: amarok-bugs-dist lists sourceforge net
        ReportedBy: christian.linzatti gmx at


Version:            (using KDE KDE 3.3.2)
Installed from:    Gentoo Packages
Compiler:          gcc 3.4 
OS:                Linux

Hello

I was trying to use mysql. But this was to unstable. Amarok have been crashed a lot. \
So I installed amarok new without mysql support. I would like to use sqlite again, \
because it was stable. But I can't scan my collection. I get this error messages: I \
have delete "$ .kde/share/apps/amarok/" and ".kde/share/config/amarokrc". The \
collection_scan.log is empty. I am using Xine and the new 1.2 CVS Version



amarok: ERROR: on query: SELECT dir, changedate FROM directories;
QObject::connect: No such signal KTextEdit::changed(const QString&)
QObject::connect:  (sender name:   'kcfg_OsdText')
QObject::connect:  (receiver name: 'osdpreview')
QWidget::setMinimumSize: The smallest allowed size is (0,0)
amarok: [PluginManager] Plugin trader constraint: [X-KDE-amaroK-framework-version] == \
                3 and [X-KDE-amaroK-plugintype] == 'engine' and [X-KDE-amaroK-rank] > \
                0
amarok: ERROR: [QStringList CollectionDB::query(const QString&, DbConnection*)] \
                sqlite_step error.
amarok: ERROR: database schema has changed
amarok: ERROR: on query: DROP TABLE tags;
amarok: ERROR: [QStringList CollectionDB::query(const QString&, DbConnection*)] \
                sqlite_step error.
amarok: ERROR: database schema has changed
amarok: ERROR: on query: DROP TABLE artist;
amarok: ERROR: [QStringList CollectionDB::query(const QString&, DbConnection*)] \
                sqlite_step error.
amarok: ERROR: database schema has changed
amarok: ERROR: on query: DROP TABLE genre;
amarok: ERROR: [QStringList CollectionDB::query(const QString&, DbConnection*)] \
                [CollectionDB] sqlite3_compile error:
amarok: ERROR: no such table: directories
amarok: ERROR: on query: DROP TABLE directories;
amarok: ERROR: [QStringList CollectionDB::query(const QString&, DbConnection*)] \
                [CollectionDB] sqlite3_compile error:
amarok: ERROR: table tags already exists
amarok: ERROR: on query: CREATE  TABLE tags (url VARCHAR(255),dir \
VARCHAR(255),createdate INTEGER,album INTEGER,artist INTEGER,genre INTEGER,title \
VARCHAR(255),year INTEGER,comment VARCHAR(255),track NUMERIC(4),bitrate \
INTEGER,length INTEGER,samplerate INTEGER,sampler BOOL );


[prev in list] [next in list] [prev in thread] [next in thread]