Version:            (using KDE 4.4.0)
OS:                Linux
Installed from:    Archlinux Packages

[pirata@myhost ~]$ akonadictl start
Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
Starting Akonadi Server...                                                                            
Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
   done.                                                                                               [akonadiserver] search paths:  ("/opt/opencascade/bin", "/bin", "/usr/bin", "/sbin", "/usr/sbin", "/opt/kde/bin", "/usr/bin/perlbin/site", "/usr/bin/perlbin/vendor", "/usr/bin/perlbin/core", "/opt/qt/bin", "/usr/sbin", "/usr/local/sbin", "/usr/local/libexec", "/usr/libexec", "/opt/mysql/libexec", "/opt/local/lib/mysql5/bin")                                    
[akonadiserver] Database "akonadi" opened using driver "QMYSQL"                                                                
[akonadiserver] DbInitializer::run()                                                                                           
[akonadiserver] checking table  "SchemaVersionTable"                                                                           
[akonadiserver] checking table  "ResourceTable"                                                                                
[akonadiserver] checking table  "CollectionTable"                                                                              
[akonadiserver] checking table  "MimeTypeTable"                                                                                
[akonadiserver] checking table  "PimItemTable"                                                                                 
[akonadiserver] "CREATE TABLE PimItemTable (id BIGINT NOT NULL PRIMARY KEY AUTO_INCREMENT, rev INTEGER NOT NULL DEFAULT 0, remoteId TEXT , collectionId BIGINT  REFERENCES CollectionTable(id) ON DELETE CASCADE ON UPDATE CASCADE, mimeTypeId BIGINT  REFERENCES MimeTypeTable(id) ON DELETE CASCADE ON UPDATE CASCADE, datetime TIMESTAMP DEFAULT CURRENT_TIMESTAMP, atime TIMESTAMP , dirty BOOL , size BIGINT NOT NULL DEFAULT 0);"                                                                                     
[akonadiserver] "Unable to create entire table.                                                                                
[akonadiserver] Query error: 'Invalid default value for 'atime' QMYSQL: Unable to execute query'"                              
[akonadiserver] Unable to initialize database.                                                                                 
[akonadiserver] "[                                                                                                             
[akonadiserver] 0: akonadiserver(_Z11akBacktracev+0x39) [0x40b1c9]                                                             
[akonadiserver] 1: akonadiserver() [0x40b712]                                                                                  
[akonadiserver] 2: /lib/libc.so.6(+0x320b0) [0x7f89ed99a0b0]                                                                   
[akonadiserver] 3: /lib/libc.so.6(gsignal+0x35) [0x7f89ed99a035]                                                               
[akonadiserver] 4: /lib/libc.so.6(abort+0x180) [0x7f89ed99b460]                                                                
[akonadiserver] 5: /usr/lib/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x6f) [0x7f89eeb4631f]                           
[akonadiserver] 6: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0xa8) [0x40c758]                                          
[akonadiserver] 7: /usr/lib/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0x78) [0x7f89eebd5e38]                                     
[akonadiserver] 8: /usr/lib/libQtCore.so.4(+0x10b5d9) [0x7f89eebe65d9]                                                         
[akonadiserver] 9: /usr/lib/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x39) [0x7f89eebe77d9]                                         
[akonadiserver] 10: akonadiserver(_ZN6QDebugD1Ev+0x4e) [0x4067ce]                                                              
[akonadiserver] 11: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServerC1EP7QObject+0x5f7) [0x7f89eefb4347]             
[akonadiserver] 12: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer8instanceEv+0x4a) [0x7f89eefb50ba]               
[akonadiserver] 13: akonadiserver(main+0x3ac) [0x405dec]                                                                       
[akonadiserver] 14: /lib/libc.so.6(__libc_start_main+0xfd) [0x7f89ed986b6d]                                                    
[akonadiserver] 15: akonadiserver() [0x405949]                                                                                 
[akonadiserver] ]                                                                                                              
[akonadiserver] "                                                                                                              
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)  


I think The critical Part is
"
[akonadiserver] "CREATE TABLE PimItemTable (id BIGINT NOT NULL PRIMARY KEY AUTO_INCREMENT, rev INTEGER NOT NULL DEFAULT 0, remoteId TEXT , collectionId BIGINT  REFERENCES CollectionTable(id) ON DELETE CASCADE ON UPDATE CASCADE, mimeTypeId BIGINT  REFERENCES MimeTypeTable(id) ON DELETE CASCADE ON UPDATE CASCADE, datetime TIMESTAMP DEFAULT CURRENT_TIMESTAMP, atime TIMESTAMP , dirty BOOL , size BIGINT NOT NULL DEFAULT 0);"                                                                                     
[akonadiserver] "Unable to create entire table.                                                                                
[akonadiserver] Query error: 'Invalid default value for 'atime' QMYSQL: Unable to execute query'"
"