Nach update von 4.0 auf 4.3 startet zarafa Server nicht mehr

Topfgucker · 23. Aug 2014

Hallo,

nach dem update der DSM auf 4.3 bekommt der zarafa-Server einfach keinen Zugriff auf die Datenbank mehr. Im Log findet sich:

Rich (BBCode):

Sat Aug 23 17:26:56 2014: SQL [00000001] Failed: 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 'END' at line 20, Query Size: 1713, Query: "CREATE PROCEDURE GetProps(IN hid integer, IN mode integer)
BEGIN
  DECLARE bestbody INT;
  IF mode = 1 THEN
         call GetBestBody(hid, bestbody);
  END IF;
  SELECT 0, tag, properties.type, val_ulong, val_string, val_binary, val_double, val_longint, val_hi, val_lo, 0, names.nameid, names.namestring, names.guid
    FROM properties LEFT JOIN names ON (properties.tag-0x8501)=names.id WHERE hierarchyid=hid AND (tag <= 0x8500 OR names.id IS NOT NULL) AND (tag NOT IN (0x1009, 0x1013) OR mode = 0 OR (mode = 1 AND tag = bestbody) )
  UNION
  SELECT count(*), tag, mvproperties.type,
          group_concat(length(mvproperties.val_ulong),':', mvproperties.val_ulong ORDER BY mvproperties.orderid SEPARATOR ''),
          group_concat(length(mvproperties.val_string),':', mvproperties.val_string ORDER BY mvproperties.orderid SEPARATOR ''),
          group_concat(length(mvproperties.val_binary),':', mvproperties.val_binary ORDER BY mvproperties.orderid SEPARATOR ''),
          group_concat(length(mvproperties.val_double),':', mvproperties.val_double ORDER BY mvproperties.orderid SEPARATOR ''),
          group_concat(length(mvproperties.val_longint),':', mvproperties.val_longint ORDER BY mvproperties.orderid SEPARATOR ''),
          group_concat(length(mvproperties.val_hi),':', mvproperties.val_hi ORDER BY mvproperties.orderid SEPARATOR ''),
          group_concat(length(mvproperties.val_lo),':', mvproperties.val_lo ORDER BY mvproperties.orderid SEPARATOR ''),
          0, names.nameid, names.namestring, names.guid
    FROM mvproperties LEFT JOIN names ON (mvproperties.tag-0x8501)=names.id WHERE hierarchyid=hid AND (tag <= 0x8500 OR names.id IS NOT NULL) GROUP BY tag, mvproperties.type;
END;
"
Sat Aug 23 17:26:56 2014: zarafa-server is unable to create stored procedures, error 1064

Damit startet zarafa natürlich nicht und ich bin ziemlich aufgeschmissen. Bitte, helft mir und rettet mir das Wochenende...