MYSQL problem with tasks

[fabrice]

Hi,

When i try to create a new task, i get an sql error :

Problème SQL. (TSK-0005, -1347613986-10999)
 
Date: Tue Jan 31 2012 09:35:48 GMT+0100 (CET)
Host: http://myhost.com
Version: 6.20.1 Rev0 (UI), 6.20.1-Rev0 (Server)
Browser: Mozilla/5.0 (Ubuntu; X11; Linux x86_64; rv:9.0.1) Gecko/20100101 Firefox/9.0.1
 
Module: tasks, View: tasks/split, Folder: 27, Default folders: contacts=26tasks=27infostore=28calendar=25, Landing page: portal,
Tree: New, Expert: Yes, Language: fr_FR
 
Loaded modules: calendar, com.openexchange.extras, com.openexchange.publish, com.openexchange.secret.recovery,
com.openexchange.subscribe, com.openexchange.user.passwordchange, com.openexchange.user.personaldata,
com.openexchange.wizard, contacts, folder, infostore, interfaces, mail, mailaccount, messaging, olox20, portal,
tasks, uwaWidgets

in the logs i can see this :

TSK-0005 Category=8 Message=SQL Problem. exceptionID=-1347613986-11013
	at com.openexchange.groupware.tasks.Tools.convert(Tools.java:309)
	at com.openexchange.groupware.tasks.TasksSQLImpl.insertTaskObject(TasksSQLImpl.java:217)
	at com.openexchange.ajax.request.TaskRequest.actionNew(TaskRequest.java:188)
	at com.openexchange.ajax.request.TaskRequest.action(TaskRequest.java:155)
	at com.openexchange.ajax.Tasks.doPut(Tasks.java:145)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:730)
	at com.openexchange.ajax.AJAXServlet.service(AJAXServlet.java:428)
	at com.openexchange.ajax.SessionServlet.service(SessionServlet.java:258)
	at com.openexchange.ajax.PermissionServlet.service(PermissionServlet.java:82)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
	at com.openexchange.ajp13.coyote.AjpProcessor.process(AjpProcessor.java:822)
	at com.openexchange.ajp13.coyote.sockethandler.CoyoteTask.call(CoyoteTask.java:184)
	at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269)
	at java.util.concurrent.FutureTask.run(FutureTask.java:123)
	at com.openexchange.threadpool.internal.CustomThreadPoolExecutor$Worker.runTask(CustomThreadPoolExecutor.java:751)
	at com.openexchange.threadpool.internal.CustomThreadPoolExecutor$Worker.run(CustomThreadPoolExecutor.java:777)
	at java.lang.Thread.run(Thread.java:595)
Caused by: TSK-0005 Category=8 Message=SQL Problem. exceptionID=-1347613986-11012
	at com.openexchange.groupware.tasks.RdbTaskStorage.insertTask(RdbTaskStorage.java:383)
	at com.openexchange.groupware.tasks.TaskLogic.insertTask(TaskLogic.java:739)
	at com.openexchange.groupware.tasks.TasksSQLImpl.insertTaskObject(TasksSQLImpl.java:215)
	... 15 more
Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'uid' in 'field list'
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1049)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3609)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3541)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2002)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2163)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2624)
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2127)
	at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1362)
	at com.openexchange.database.internal.wrapping.PreparedStatementWrapper.execute(PreparedStatementWrapper.java:99)
	at com.openexchange.groupware.tasks.RdbTaskStorage.insertTask(RdbTaskStorage.java:379)
	... 17 more

any idea ?

Fabrice