Gossamer Forum
Home : Products : Gossamer Mail : Discussion :

Problem at users login

Quote Reply
Problem at users login
Hi,

Any time the users try to log in they get this error:

DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /home/gm/cgi-bin/webmail2/adminmig/GT/SQL/Driver.pm line 564.


any suggestion?
Quote Reply
Re: [migues] Problem at users login In reply to
Hi,

Can you turn on debug and post the whole error (mainly what GT::SQL::error or DBI::errstr says).

Cheers,

Alex
--
Gossamer Threads Inc.
Quote Reply
Re: [Alex] Problem at users login In reply to
A fatal error has occured:
DBD::mysql::st execute failed: Incorrect key file for table: 'bacanmail_session'. Try to repair it at /home/bacanmig/cgi-bin/webmail2/adminmig/GT/SQL/Driver/MYSQL.pm line 113.



Stack Trace
======================================
GMail (22295): GT::SQL::Driver::MYSQL::sth::execute called at (eval 5) line 20 with arguments
(GT::SQL::Driver::MYSQL::sth=HASH(0x8435fc4)).
GMail (22295): GT::SQL::Table::do_query called at (eval 10) line 112 with arguments
(GT::SQL::Table=HASH(0x8435f34), DELETE FROM bacanmail_session WHERE ( session_date < '1012850070' )).
GMail (22295): GT::SQL::Table::delete called at /home/bacanmig/cgi-bin/webmail2/adminmig/GT/SQL/Table.pm line 109 with arguments
(GT::SQL::Table=HASH(0x8435f34), GT::SQL::Condition=HASH(0x8417314)).
GMail (22295): GT::SQL::Table::AUTOLOAD called at /home/bacanmig/cgi-bin/webmail2/adminmig/GT/Session/SQL.pm line 264 with arguments
(GT::SQL::Table=HASH(0x8435f34), GT::SQL::Condition=HASH(0x8417314)).
GMail (22295): GT::Session::SQL::cleanup called at /home/bacanmig/cgi-bin/webmail2/adminmig/GMail/Auth.pm line 147 with arguments
(GT::Session::SQL=HASH(0x844ea0c)).
GMail (22295): GMail::Auth::create_session called at /home/bacanmig/cgi-bin/webmail2/adminmig/GMail/Auth.pm line 60 with arguments
(GMail::Auth, dimitry@bacan.com).
GMail (22295): GMail::Auth::__ANON__ called at /home/bacanmig/cgi-bin/webmail2/adminmig/GT/Plugins.pm line 84 with arguments
(dimitry@bacan.com).
GMail (22295): GT::Plugins::dispatch called at /home/bacanmig/cgi-bin/webmail2/adminmig/GMail/Auth.pm line 60 with arguments
(GT::Plugins=HASH(0x80cd7f4), GMail::Auth::create_session, CODE(0x829d200), dimitry@bacan.com).
GMail (22295): GMail::Auth::authenticate called at login.cgi line 50 with arguments
(GMail::Auth).
GMail (22295): main::__ANON__ called at /home/bacanmig/cgi-bin/webmail2/adminmig/GT/Plugins.pm line 84 with no arguments.
GMail (22295): GT::Plugins::dispatch called at login.cgi line 50 with arguments
(GT::Plugins=HASH(0x80cd7f4), GMail::Auth::authenticate, CODE(0x828c9d0)).
GMail (22295): main::main called at /home/bacanmig/cgi-bin/webmail2/adminmig/GT/Plugins.pm line 84 with no arguments.
GMail (22295): GT::Plugins::dispatch called at login.cgi line 28 with arguments
(GT::Plugins=HASH(0x80cd7f4), login::main, CODE(0x8274520)).


System Information
======================================
Perl Version: 5.00503
Gossamer Mail Version: 2.0.5-Upgrade
DBI.pm Version: 1.13
MIME::Base64 Version: 2.11
Digest::MD5 Version: 2.09
Persistant Env: mod_perl (0) SpeedyCGI (0)
DBI::errstr = Incorrect key file for table: 'bacanmail_session'. Try to repair it@INC =
/home/bacanmig/cgi-bin/webmail2/adminmig
/usr/lib/perl5/5.00503/i386-linux
/usr/lib/perl5/5.00503
/usr/lib/perl5/site_perl/5.005/i386-linux
/usr/lib/perl5/site_perl/5.005
.

CURRENT USER
======================================
dgraph_userid => 1101
domain =>
options_compose_compose_wrap => ON
options_compose_format => text
options_compose_forward_html => <font color=blue> &nbsp; </font><br> <BLOCKQUOTE style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px"> <FONT face=Tahoma size=2>-----Original Message-----<BR> <DIV style="background-color:lightgrey" align=left> <B>From:</B> <%from%></DIV> <B>Sent:</B> <%date%><BR> <B>To:</B> <%to%><BR> <B>Subject:</B> <%subject%><BR><BR> </font> <%message%> </blockquote>
options_compose_forward_subject => Fw: <%formatted_subject%>
options_compose_forward_text => Forwarded By: <%email%> on <%current_date%> --------------------------------------------------------------- <%message%>
options_compose_line_prefix => >
options_compose_reply_html => <font color=blue> &nbsp; </font><br> <BLOCKQUOTE style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px"> <FONT face=Tahoma size=2>-----Original Message-----<BR> <DIV style="background-color:lightgrey" align=left> <B>From:</B> <%from%></DIV> <B>Sent:</B> <%date%><BR> <B>To:</B> <%to%><BR> <B>Subject:</B> <%subject%><BR><BR> </font> <%message%> </blockquote>
options_compose_reply_subject => Re: <%formatted_subject%>
options_compose_reply_text => On <%sent_date%> <%from%> was overheard saying: --------------------------------------------------- <%quoted_message%>
options_update_folders => 1
options_version => 2.0.0
user => dimitry@bacan.com
userid => 1101
username => dimitry
users_default_template => bacan
users_join_time => 987831391
users_last_login => 1012864416
users_max_pop => 2
users_percent_used => 4.7
users_space_allowed => 2.86 MB
users_space_left => 2.73 MB
users_space_used => 137.57 KB
users_status => Validated

CGI INPUT
======================================
cookie => Yes
domain =>
image.x => 29
image.y => 26
password =>
t =>
username => dimitry


CGI Cookies
======================================
bacan => 64.86.65.66.66451010361319185
Quote Reply
Re: [migues] Problem at users login In reply to
You need to repair your SQL tables. See:

http://www.mysql.com/.../E/REPAIR_TABLE.html

Cheers,

Alex
--
Gossamer Threads Inc.
Quote Reply
Re: [Alex] Problem at users login In reply to
I got this message.



| mailserver.bacanmail_address | repair | error | The handler for the table d
oesn't support check/repair |



Can you help me?