Gossamer Forum
Home : Products : Gossamer Mail : Discussion :

problems after upgrading ??

Quote Reply
problems after upgrading ??
hi there,

i have upgraded last week gm to 2.1.1, just today i found out that following error appears after deleting a user as example, the errormessage appears as following:
Error: DBD::mysql::st execute failed: Unknown column 'webmail_users.users_check_pop' in 'field list' at /www/webmail/admin/GT/SQL/Driver/MYSQL.pm line 117

and second after running consistency.pl

0 messages were in the database but not on disk
validate table inconsistancies: 0
msgtrack table inconsistancies: 0
msgs table inconsistancies: 0
msgs_threads table inconsistancies: 0
msgdata table inconsistancies: 0
msgsearch table inconsistancies: 0
msgs_remote table inconsistancies: 0
pop_accounts table inconsistancies: 0
sigs table inconsistancies: 0
address table inconsistancies: 0
filter table inconsistancies: 0
users => dgraph table inconsistancies: 0
dgraph => users table inconsistancies: 0
DBD::mysql::st execute failed: Unknown column 'webmail_users.user' in 'on clause' at /www/webmail/admin/GT/SQL/Driver/MYSQL.pm line 117.

the strange thing is that i got no errors after upgrading. i found out some articles where that problem was discussed already but it have nothing to do with session_user -> session_userid - i guess so..

any help would be greatly appreciated

thanks

chris
Quote Reply
Re: [steger] problems after upgrading ?? In reply to
Hi,

The column 'users_check_pop' comes from the POP Server plugin. Did you recreate the SQL tables? If so, then you'll need to reinstall the POP Server plugin so that it adds that field back in.

Cheers,

Alex
--
Gossamer Threads Inc.
Quote Reply
Re: [Alex] problems after upgrading ?? In reply to
 
how stupid i am :()
the strange thing is, after upgrading i have already reinstalled the gpopd.....

however it works!

thanks alex!