[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