Gossamer Forum
Home : Products : Gossamer Mail : Discussion :

[BUG 2.0.2 Upgrade] Unknown column 'validate_id

Quote Reply
[BUG 2.0.2 Upgrade] Unknown column 'validate_id
Hello!

The following link has given problems:

http://www.troubles.com/admin/admin.cgi?db=users;db=dgraph;do=validate_search_results

Error: DBD::mysql::st execute failed: Unknown column 'validate_id' in 'where clause' at /usr/www/user/admin/GT/SQL/Driver/MYSQL.pm line 68.

Stack Trace
======================================
GMail (30352): GT::SQL::Driver::MYSQL::sth::execute called at (eval 10) line 80 with arguments
(GT::SQL::Driver::MYSQL::sth=HASH(0x86cef78)).
GMail (30352): GT::SQL::Relation::select called at /usr/www/user/admin/GT/SQL/Relation.pm line 68 with arguments
(GMail::SQL::Relation=HASH(0x8627b24), left_join, HASH(0x864b354)).
GMail (30352): GT::SQL::Relation::AUTOLOAD called at (eval 5) line 13 with arguments
(GMail::SQL::Relation=HASH(0x8627b24), left_join, HASH(0x864b354)).
GMail (30352): GT::SQL::Admin::validate_search_results called at /usr/www/user/admin/GT/SQL/Admin.pm line 176 with arguments
(GMail::SQL::Admin=HASH(0x85cc610)).
GMail (30352): GT::SQL::Admin::AUTOLOAD called at /usr/www/user/admin/GT/SQL/Admin.pm line 81 with arguments
(GMail::SQL::Admin=HASH(0x85cc610)).
GMail (30352): GT::SQL::Admin::process called at /usr/www/user/admin/admin.cgi line 169 with arguments
(GMail::SQL::Admin=HASH(0x85cc610), db, GMail::Fake=SCALAR(0x8209db0), cgi, GT::CGI=HASH(0x813079c), record, Users, footer, CODE(0x83c02b8)).
GMail (30352): main::db_interface called at /usr/www/user/admin/admin.cgi line 141 with arguments
([undef]).
GMail (30352): main::main called at /usr/www/user/admin/admin.cgi line 32 with no arguments.

Upgrade went without problems. It was a fresh install of 2.0.1 and with a backup option.

Quote Reply
Re: [BUG 2.0.2 Upgrade] Unknown column 'validate_id In reply to
Hi,

The Validate quick link does not work, you need to click on Users->Validate.

Cheers,

Alex

--
Gossamer Threads Inc.
Quote Reply
Re: [BUG 2.0.2 Upgrade] Unknown column 'validate_id In reply to
 
In case anyone was wondering, you can get the validate quick link to work again simply by recreating it with a different URL attached:

admin.cgi?db=users&db=validate&do=validate_search_results

It seems to be working fine for me now.

Cheers,
R.


Quote Reply
Re: [BUG 2.0.2 Upgrade] Unknown column 'validate_id In reply to
Hello!

To be more precise earlier in the link was db=dgraph and with the new upgrade db=validate!

The only problem was that the update did not go through the personal quicklink and correct and insert the change for logical reasons.

Thats the only change in the Quick link (and ofcourse related internals)