Gossamer Forum
Home : Products : Gossamer Mail : Discussion :

v 2.0.6 error in consistancy.pl - DBD::mysql::st execute failed: Unknown column 'users.user'...

Quote Reply
v 2.0.6 error in consistancy.pl - DBD::mysql::st execute failed: Unknown column 'users.user'...
I just upgraded to v 2.0.6 from v 2.0.2 and all seemed to go just fine. Site seems to operate correctly.. however, when I do a consistancy check/repair I end up with the following error Shocked at the end...


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 'users.user' in 'on clause' at /home/b/y/byteme/www/email/admin/GT/SQL/Driver/MYSQL.pm line 113.


This field does not exist, and if I rememebr correctly from the upgrade it said something about 'user' being renamed to 'email'. Might be wrong there.

Any info would be greatly appreciated.

Thanks! Sly

...I'm only doing what my Rice Crispies told me to.
Quote Reply
Re: [gtjr] v 2.0.6 error in consistancy.pl - DBD::mysql::st execute failed: Unknown column 'users.user'... In reply to
Hi,

Hmm, it looks like upgrade did not complete. Did you see:

Gossamer Mail has been successfully upgraded from 2.0.5 to 2.0.6.

at the end? Drop an email to support-gmail@gossamer-threads.com with ssh/telnet info and we can fix this up for you.

Cheers,

Alex
--
Gossamer Threads Inc.