Announcement

Collapse
No announcement yet.

MYSQL problem with tasks

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • MYSQL problem with tasks

    Hi,

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

    Code:
    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 :
    Code:
    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
Working...
X