[kde-freebsd] Akonadi problem

[Daniel O'Connor]

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
-------------- 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/078a0756/attachment.sig