Changes between Version 31 and Version 32 of howto/ZarafaMigrateConnectux

Timestamp:

06/09/11 22:34:30 (13 years ago)

Author:

Edwin Eefting

Comment:

--

howto/ZarafaMigrateConnectux

@@ -176 +176 @@
 SYN-3: Waiting for conversion to finish...
 }}}
+
+Blijkbaar verwacht zarafa een index die niet bestaat, handmatige de query aanpassen lost het probleem op. (soms moet dit met meerdere indexen)
+{{{
+
+[Syn-3] root@linux.ours.local ~# mysql -p`cat /etc/my.passwd` zarafa
+Welcome to the MySQL monitor.  Commands end with ; or \g.
+Your MySQL connection id is 66
+Server version: 5.0.91 Source distribution
+
+Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
+
+mysql> ALTER TABLE outgoingqueue DROP PRIMARY KEY, ADD PRIMARY KEY (`hierarchy_id`,`flags`,`store_id`);
+ERROR 1091 (42000): Can't DROP 'PRIMARY'; check that column/key exists
+mysql> ALTER TABLE outgoingqueue ADD PRIMARY KEY (`hierarchy_id`,`flags`,`store_id`);
+Query OK, 0 rows affected (0.09 sec)
+Records: 0  Duplicates: 0  Warnings: 0
+
+mysql> ALTER TABLE outgoingqueue DROP PRIMARY KEY, ADD PRIMARY KEY (`hierarchy_id`,`flags`,`store_id`);
+Query OK, 0 rows affected (0.05 sec)
+Records: 0  Duplicates: 0  Warnings: 0
+
+mysql> 
+}}}