Changes between Version 31 and Version 32 of howto/ZarafaMigrateConnectux


Ignore:
Timestamp:
06/09/11 22:34:30 (13 years ago)
Author:
Edwin Eefting
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • howto/ZarafaMigrateConnectux

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