[horde] Creating horde_prefs manually...
Michael Robinson
plug_1 at robinson-west.com
Thu Jan 15 05:13:56 UTC 2015
I shouldn't have to do this, but I gave it a shot.
mysql> SELECT * FROM horde_prefs;
+-----------------+----------------------+----------+------------+
| pref_name | pref_value | pref_uid | pref_scope |
+-----------------+----------------------+----------+------------+
| identities | a:1:{i:0;a:4:{s:2:"i | admin | horde |
| upgrade_tasks | a:3:{s:5:"horde";s:5 | admin | horde |
| last_logintasks | a:2:{s:5:"horde";i:1 | admin | horde |
| last_login | a:2:{s:4:"host";s:25 | admin | horde |
| upgrade_tasks | a:3:{s:5:"horde";s:5 | michael | horde |
| last_login | a:2:{s:4:"host";s:25 | michael | horde |
| last_logintasks | a:2:{s:5:"horde";i:1 | michael | horde |
| identities | a:1:{i:0;a:4:{s:2:"i | michael | horde |
| upgrade_tasks | a:3:{s:5:"horde";s:5 | mom | horde |
| last_login | a:2:{s:4:"host";s:25 | mom | horde |
| last_logintasks | a:2:{s:5:"horde";i:1 | mom | horde |
| identities | a:0:{} | mom | horde |
+-----------------+----------------------+----------+------------+
12 rows in set (0.00 sec)
mysql>
I read error messages from horde about table columns not existing and
created them using an educated guess on field type. I guessed that each
column should be a varchar(20), but that is probably wrong. Horde is
still failing to read the preferences back when I log back in. Uge!
Clearly horde has saved preferences, but it isn't reading them back.
I'm also concerned that I should never have had to create this table
manually. Now that I know more about the table format, I could try
creating the table in postgresql and avoid having to use two databases.
More information about the horde
mailing list