Hi, I just tried KDE4.3 but I ran into a problem with akonadi. I tries to run an SQL query to create a table but the mysql that is installed doesn't like it. The query is..
CREATE TABLE CollectionTable (id BIGINT NOT NULL PRIMARY KEY AUTO_INCREMENT, remoteId TEXT , name VARCHAR(255) BINARY character set utf8 collate utf8_bin NOT NULL, parentId BIGINT DEFAULT 0 REFERENCES Collection(id), resourceId BIGINT NOT NULL REFERENCES Resource(id), subscribed BOOL NOT NULL DEFAULT true, cachePolicyInherit BOOL NOT NULL DEFAULT true, cachePolicyCheckInterval INTEGER NOT NULL DEFAULT -1, cachePolicyCacheTimeout INTEGER NOT NULL DEFAULT -1, cachePolicySyncOnDemand BOOL NOT NULL DEFAULT false, cachePolicyLocalParts TEXT ); If I remove the 'character set utf8 collate utf8_bin' and run it by hand then it works (and akonadi starts because the table now exists). I am not sure what the real solution is - different mysql version perhaps? -- Daniel O'Connor software and network engineer for Genesis Software - http://www.gsoft.com.au "The nice thing about standards is that there are so many of them to choose from." -- Andrew Tanenbaum GPG Fingerprint - 5596 B766 97C0 0E94 4347 295E E593 DC20 7B3F CE8C
signature.asc
Description: This is a digitally signed message part.
_______________________________________________ kde-freebsd mailing list kde-freebsd@kde.org https://mail.kde.org/mailman/listinfo/kde-freebsd See also http://freebsd.kde.org/ for latest information
