[imp] pref_uid differs from mysql queries
Barry Flanagan
barryf-imp@digiserve.ie
Fri, 16 Nov 2001 17:39:31 +0000
On Friday 16 November 2001 17:25, you wrote:
> Im trying to make the lastest CVS of IMP, Turba and Horde to work, and im
> having some difficulties. I noticed that my preferences are not updated
> anymore. I checked the MySQL logs and noticed that it tries to get the
> wrong pref_uid. In the MySQL DB, my pref_uid is 'ftrudeau', not
> 'ftrudeau@cam.org'.
>
>
> 42063 Query update horde_prefs set pref_value = 1005931068 where
> pref_uid = 'ftrudeau@cam.org' and pref_name = 'last_login' and pref_scope =
> 'imp'
>
>
> I can I fix this ?
>
I think this is down to a change in the way imp/horde uses the $realm
variable set in imp/config/server.php for the IMAP or POP server you have set
up. It now tacks on '@$realm' to the pref_uid
You have two choices:
1. EDit servers.php and set $realm = ''
2. run the query UPDATE horde_prefs SET pref_uid = 'ftrudeau@cam.org' WHERE
pref_uid = 'ftrudeau' - or a similar query to update all pref_uids
Hope this helps.
-Barry Flanagan