[kde-freebsd] Akonadi/mysqld problems

[Mel Flynn]

On 14-6-2012 1:03, Alberto Villa wrote:
> On Thu, Jun 14, 2012 at 12:10 AM, Mel Flynn <rflynn at acsalaska.net> wrote:
>> Collections I think. Yep:
> 
> How can it be empty? It contains references to all Akonadi collections:
> http://wstaw.org/m/2012/06/14/plasma-desktopWa1410.png
> 
>> That :0 looks bogus too.
> 
> Why do you think that?
mysql> select * from collectiontable where (queryLanguage = ( :0 ));
ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
syntax to use near ':0 ))' at line 1

I have 5 rows in there now, 4 of them created by me starting up Kmail
once. The first row is this:
mysql> select * from collectiontable LIMIT 1\G
*************************** 1. row ***************************
                      id: 1
                remoteId: NULL
          remoteRevision: NULL
                    name: Search
                parentId: NULL
              resourceId: 1
              subscribed: 1
      cachePolicyInherit: 1
cachePolicyCheckInterval: -1
 cachePolicyCacheTimeout: -1
 cachePolicySyncOnDemand: 0
   cachePolicyLocalParts: NULL
             queryString: NULL
           queryLanguage: NULL
1 row in set (0.00 sec)

Also, all queryLanguage fields are NULL, so I don't understand the WHERE
clause. Do you have one where it is not null?

-- 
Mel