[kde-freebsd] Akonadi problem

[Daniel O'Connor]

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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 188 bytes
Desc: This is a digitally signed message part.
Url : http://mail.kde.org/pipermail/kde-freebsd/attachments/20090825/4d3c4518/attachment.sig