[imp] problems with latest CVS IMP

[Michael Geier, CDM Systems Admin]

Thanks for the reply...however if you look at the error, it isn't trying to
update the prefs table, but the users table.  I have looked at the table,
and I know why the query isn't working, I just don't know why it is trying
to update that table.

I have both tables (horde_users [auth.sql], horde_prefs [prefs.sql])
installed.  I just recently (with this download) allowed preferences (don't
know why I missed them last install)


  string(469) "update horde_users set pref_value =
'a:1:{i:0;a:9:{s:2:\"id\";s:16:\"Default
Identity\";s:8:\"fullname\";s:0:\"\";s:9:\"from_addr\";s:0:\"\";s:12:\"reply
to_addr\";s:0:\"\";s:9:\"signature\";s:0:\"\";s:9:\"sig_first\";i:0;s:10:\"s
ig_dashes\";i:0;s:14:\"save_sent-mail\";N;s:16:\"sent_mail_folder\";s:9:\"se
nt-mail\";}}' where pref_uid = '[ snip user ]' and pref_name = 'identities'
and pref_scope = 'horde' [nativecode=Unknown column 'pref_uid' in 'where
clause']"

-----Original Message-----
From: Jan Schneider [mailto:jan@horde.org]
Sent: Monday, November 26, 2001 9:33 AM
To: imp@lists.horde.org
Subject: Re: [imp] problems with latest CVS IMP


Zitat von "Michael Geier, CDM Systems Admin" <mgeier@cdmsports.com>:

> Was running IMP 3.0RC1 for awhile just fine.
>
> Installed RC2 (and HORDE RC2) and now receive the following error when
> attempting login to IMP, after completing HORDE login:
>
> IMP Maintenance Operations - Confirmation
>
> Warning! IMP is ready to perform the maintenance operations checked
> below.
> Check the box for any operation(s) you want to perform at this time.
>
> A fatal error has occurred
> object(db_error)(10) {

> and pref_scope = 'horde' [nativecode=Unknown column 'pref_uid' in
> 'where
> clause']"

> Did the database change format?  I couldn't find the normal sql files

No, they haven't been changed recently.

> under
> imp/scripts/db.

You find the prefs sql script under horde/scripts/db.

Jan.