[horde] No horde_imap_client_message table!

[Michael J Rubinsky]

Quoting Federico Giannici <giannici at neomedia.it>:

> I just installed the latest version of Horde/IMP and I cannot get  
> rid of two problems with the DBs.
>
> One seems related to the limit to 1000 bytes (about 333 UTF-8 chars)  
> of MySQL indexes (I'm using MariaDB 10.0.23).
>
> But what I cannot really understand is the second one: there is no  
> "horde_imap_client_message" table!
>
> I executed lots of times the "horde-db-migrate" script, even deleted  
> all tables and created them again, but always with this result:
>
> [  INFO  ] Migrating DB up.
> [  INFO  ] Current imp schema version: 3
> [  INFO  ] Ending imp schema version: 3
> [  INFO  ] Current ingo schema version: 7
> [  INFO  ] Ending ingo schema version: 7
> [  INFO  ] Current turba schema version: 11
> [  INFO  ] Ending turba schema version: 11
> [  INFO  ] Current content schema version: 2
> [  INFO  ] Ending content schema version: 2
> [  INFO  ] Current Horde_ActiveSync schema version: 22
> [  INFO  ] Ending Horde_ActiveSync schema version: 22
> [  INFO  ] Current Horde_Alarm schema version: 2
> [  INFO  ] Ending Horde_Alarm schema version: 2
> [  INFO  ] Current Horde_Auth schema version: 1
> [  INFO  ] Ending Horde_Auth schema version: 1
> [  INFO  ] Current Horde_Cache schema version: 2
> [  INFO  ] Ending Horde_Cache schema version: 2
> [  INFO  ] Current Horde_Core schema version: 1
> [  INFO  ] Ending Horde_Core schema version: 1
> [  INFO  ] Current Horde_Dav schema version: 1
> Migrating to HordeDavRemoveUniqueIndex (2)
> == 2 HordeDavRemoveUniqueIndex: migrating  
> =====================================
> -- removeIndex('horde_dav_objects', 'id_external')
>    -> 0.0202s
> -- addIndex('horde_dav_objects', 'id_external')
>    -> 0.0028s
> -- addIndex('horde_dav_objects', array(0 => 'id_external', 1 =>  
> 'id_collection'), array('unique' => true))
> QUERY FAILED: Specified key was too long; max key length is 1000 bytes
>
> CREATE UNIQUE INDEX  
> `index_horde_dav_objects_on_id_external_and_id_collection` ON  
> `horde_dav_objects` (`id_external`, `id_collection`)
> [  INFO  ] Current Horde_Group schema version: 3
> [  INFO  ] Ending Horde_Group schema version: 3
> [  INFO  ] Current Horde_History schema version: 6
> [  INFO  ] Ending Horde_History schema version: 6
> [  INFO  ] Current Horde_Imap_Client schema version: 1

^^^ This shows your current schema version is 1, so you either didn't  
use migrations to remove the tables or when you manually removed the  
tables yourself your didn't remove the schema version tables.

Migrate the imap client table down, then back up:

horde-db-migrate horde_imap_client down
horde-db-migrate horde_imap_client up



> Migrating to HordeImapClientChangeColumnName (2)
> == 2 HordeImapClientChangeColumnName: migrating  
> ===============================
> -- columns('horde_imap_client_data')
>    -> 0.0250s
> -- columns('horde_imap_client_message')
> QUERY FAILED: Table 'horde3.horde_imap_client_message' doesn't exist
>
> SHOW FIELDS FROM `horde_imap_client_message`
> [  INFO  ] Current Horde_Lock schema version: 3
> [  INFO  ] Ending Horde_Lock schema version: 3
> [  INFO  ] Current Horde_Perms schema version: 3
> [  INFO  ] Ending Horde_Perms schema version: 3
> [  INFO  ] Current Horde_Prefs schema version: 3
> [  INFO  ] Ending Horde_Prefs schema version: 3
> [  INFO  ] Current Horde_Queue schema version: 1
> [  INFO  ] Ending Horde_Queue schema version: 1
> [  INFO  ] Current Horde_SessionHandler schema version: 2
> [  INFO  ] Ending Horde_SessionHandler schema version: 2
> [  INFO  ] Current Horde_Token schema version: 1
> [  INFO  ] Ending Horde_Token schema version: 1
> [  INFO  ] Current Horde_Vfs schema version: 4
> [  INFO  ] Ending Horde_Vfs schema version: 4
>
>
> What am I missing?
>
> If anything, can anybody send my the "horde_imap_client_message"  
> table structure?
>
> Thanks.
> -- 
> Horde mailing list
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: horde-unsubscribe at lists.horde.org



-- 
mike
The Horde Project
http://www.horde.org
https://www.facebook.com/hordeproject
https://www.twitter.com/hordeproject
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 5751 bytes
Desc: S/MIME Signature
URL: <https://lists.horde.org/archives/horde/attachments/20160528/1c214cf8/attachment.bin>