On Tue, 25 Aug 2009, Daniel O'Connor wrote: > 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?
Ah, seems that for some reason ports picked 4.1 to install, I checked and the default is supposed to be 5.0 and the problem doesn't occur when I use that. So, false alarm :) -- 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
