Gossamer Forum
Home : Products : Gossamer Forum : Discussion :

User log in error

Quote Reply
User log in error
Code:
A fatal error has occurred:

GT::Session::SQL (3172): Failed to execute query: 'INSERT INTO gforum_Session (session_user_id,session_date,session_id,session_data) VALUES (?,?,?,?)' Reason: [Microsoft][ODBC SQL Server Driver]String data, right truncation (SQL-22001)(DBD: st_execute/SQLExecute err=-1) at d:/66.34.125.120/forums/admin/GForum/Authenticate.pm line 505.

Please enable debugging in setup for more details.

Stack Trace

======================================

GForum (3172): GT::Base::error called at d:/66.34.125.120/forums/admin/GT/Session/SQL.pm line 208 with arguments

(GT::Session::SQL=HASH(0x1cb4cdc), Failed to execute query: 'INSERT INTO gforum_Session (session_user_id,session_date,session_id,session_data) VALUES (?,?,?,?)' Reason: [Microsoft][ODBC SQL Server Driver]String data, right truncation (SQL-22001)(DBD: st_execute/SQLExecute err=-1)).

GForum (3172): GT::Session::SQL::save called at d:/66.34.125.120/forums/admin/GForum/Authenticate.pm line 505 with arguments

(GT::Session::SQL=HASH(0x1cb4cdc)).

GForum (3172): GForum::Authenticate::auth_create_session called at d:/66.34.125.120/forums/admin/GT/Plugins.pm line 102 with no arguments.

GForum (3172): GT::Plugins::dispatch called at d:/66.34.125.120/forums/admin/GForum/Authenticate.pm line 36 with arguments

(GT::Plugins, d:/66.34.125.120/forums/admin/Plugins/GForum, auth_create_session, CODE(0x1b1ee78)).

GForum (3172): GForum::Authenticate::auth called at d:/66.34.125.120/forums/admin/GForum.pm line 517 with arguments

(create_session).

GForum (3172): GForum::authenticate called at d:\66.34.125.120\forums\gforum.cgi line 52 with no arguments.

GForum (3172): main::main called at d:\66.34.125.120\forums\gforum.cgi line 21 with no arguments.



System Information

======================================

Perl Version: v5.6.1

Gossamer Forum Version: 1.1.1

GForum.pm version: 1.103

GT::SQL Version: 1.091

GT::Template Version: 2.060

DBI.pm Version: 1.14

@INC =

d:/66.34.125.120/forums/admin

C:/Perl/lib

C:/Perl/site/lib

.

GT::SQL::error = Failed to execute query: 'INSERT INTO gforum_Session (session_user_id,session_date,session_id,session_data) VALUES (?,?,?,?)' Reason: [Microsoft][ODBC SQL Server Driver]String data, right truncation (SQL-22001)(DBD: st_execute/SQLExecute err=-1)

CGI INPUT

======================================

dont_use_cookies => 1

login_password => edited out

login_username => edited out

url => http://www.heavybombers.com/forums/gforum.cgi?login_attempt=1&



ENVIRONMENT

======================================

ALLUSERSPROFILE => C:\Documents and Settings\All Users.WINNT

COMMONPROGRAMFILES => C:\Program Files\Common Files

COMPUTERNAME => TERRA

COMSPEC => C:\WINNT\system32\cmd.exe

CONTENT_LENGTH => 155

CONTENT_TYPE => application/x-www-form-urlencoded

GATEWAY_INTERFACE => CGI/1.1

GT_TMPDIR => d:/66.34.125.120/forums/admin/tmp

HTTPS => off

HTTP_ACCEPT => image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/vnd.ms-powerpoint, application/vnd.ms-excel, application/msword, */*

HTTP_ACCEPT_ENCODING => gzip, deflate

HTTP_ACCEPT_LANGUAGE => en-us

HTTP_CACHE_CONTROL => no-cache

HTTP_CONNECTION => Keep-Alive

HTTP_CONTENT_LENGTH => 155

HTTP_CONTENT_TYPE => application/x-www-form-urlencoded

HTTP_HOST => www.heavybombers.com

HTTP_REFERER => http://www.heavybombers.com/forums/gforum.cgi

HTTP_USER_AGENT => Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; Q312461)

INSTANCE_ID => 81

LOCAL_ADDR => 66.34.125.120

NUMBER_OF_PROCESSORS => 2

OS => Windows_NT

OS2LIBPATH => C:\WINNT\system32\os2\dll;

PATH => C:\Perl\bin\;E:\Perl\bin\;C:\WINNT\system32;C:\WINNT;C:\WINNT\System32\Wbem

PATHEXT => .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH

PATH_INFO => /forums/gforum.cgi

PATH_TRANSLATED => d:\66.34.125.120\forums\gforum.cgi

PROCESSOR_ARCHITECTURE => x86

PROCESSOR_IDENTIFIER => x86 Family \',\'72\',\'1010355727\',\'76\',\'1010355727\',\'100\',\'1010355727\',\'77\',\'1010355727\',\'101\',\'1010355727\',\'78\',\'1010355727\',\'102\',\'1010355727\',\'79\',\'1010355727\',\'103\',\'1010355727\',\'104\',\'1010355727\',\'105\',\'1010355727\',\'106\',\'1010355727\',\'107\',\'1010355727\',\'108\',\'1010355727\',\'109\',\'1010355727\',\'80\',\'1010355727\',\'81\',\'1010524107\',\'82\',\'1010355727\',\'83\',\'1010355727\',\'84\',\'1010355727\',\'85\',\'1010355727\',\'86\',\'1010782567\',\'110\',\'1010355727\',\'87\',\'1010355727\',\'111\',\'1010355727\',\'88\',\'1010355727\',\'112\',\'1010355727\',\'89\',\'1010355727\',\'113\',\'1010355727\',\'114\',\'1010355727\',\'115\',\'1010355727\',\'116\',\'1010355727\',\'117\',\'1010355727\',\'118\',\'1010355727\',\'119\',\'1010355727\',\'10\',\'1010355727\',\'11\',\'1010378597\',\'12\',\'1010355727\',\'13\',\'1010355727\',\'14\',\'1010355727\',\'15\',\'1010355727\',\'16\',\'1010355727\',\'17\',\'1010355727\',\'18\',\'1010355727\',\'19\',\'1010355727\',\'90\',\'1010355727\',\'91\',\'1010355727\',\'92\',\'1010355727\',\'93\',\'1010355727\',\'94\',\'1010355727\',\'95\',\'1010355727\',\'96\',\'1010355727\',\'120\',\'1010355727\',\'97\',\'1010355727\',\'121\',\'1010355727\',\'98\',\'1010355727\',\'122\',\'1010355727\',\'99\',\'1010378544\',\'123\',\'1010355727\',\'124\',\'1010355727\',\'125\',\'1010355727\',\'126\',\'1010355727\',\'127\',\'1010355727\',\'128\',\'1010355727\',\'129\',\'1010355727\',\'20\',\'1010607443\',\'21\',\'1010360282\',\'24\',\'1010355727\',\'25\',\'1010355727\',\'26\',\'1010355727\',\'27\',\'1010355727\',\'28\',\'1010355727\',\'29\',\'1010355727\',\'130\',\'1010355727\',\'131\',\'1010355727\',\'132\',\'1010355727\',\'133\',\'1010355727\',\'134\',\'1010355727\',\'135\',\'1010355727\',\'136\',\'1010355727\',\'137\',\'1010355727\',\'138\',\'1010355727\',\'139\',\'1011040154\',\'30\',\'1010355727\',\'31\',\'1010355727\',\'32\',\'1010355727\',\'33\',\'1010355727\',\'34\',\'1010355727\',\'35\',\'1010355727\',\'36\',\'1010355727\'},\'roots\',{\'90\',{\'6527\',\'1011278165\'},\'76\',{\'7260\',\'1011278165\'},\'93\',{\'7220\',\'1011278165\',\'7261\',\'1011278165\'},\'78\',{\'7271\',\'1011278165\',\'6251\',\'1011278165\'},\'79\',{\'7276\',\'1011278165\'},\'99\',{\'5263\',\'1011278165\'},\'140\',{\'5427\',\'1011278165\'},\'124\',{\'7231\',\'1011278165\'},\'141\',{\'6677\',\'1011278165\'},\'125\',{\'7262\',\'1011278165\'},\'142\',{\'7273\',\'1011278165\',\'6746\',\'1011278165\'},\'144\',{\'7266\',\'1011278165\'},\'20\',{\'7207\',\'1011278165\'},\'21\',{\'7208\',\'1011278165\',\'7235\',\'1011278165\',\'7204\',\'1011278165\',\'7198\',\'1011278165\'},\'24\',{\'7192\',\'1011278165\',\'7218\',\'1011278165\'},\'25\',{\'4172\',\'1011278165\'},\'26\',{\'7230\',\'1011278165\'},\'27\',{\'7229\',\'1011278165\'},\'60\',{\'4893\',\'1011278165\'},\'29\',{\'7200\',\'1011278165\',\'7228\',\'1011278165\'},\'61\',{\'7213\',\'1011278165\'},\'62\',{\'7233\',\'1011278165\'},\'65\',{\'7215\',\'1011278165\'},\'81\',{\'7151\',\'1011278165\',\'6068\',\'1011278165\'},\'68\',{\'7206\',\'1011278165\'},\'86\',{\'7212\',\'1011278165\'},\'112\',{\'7226\',\'1011278165\'},\'89\',{\'7163\',\'1011278165\'},\'116\',{\'7216\',\'1011278165\'},\'2\',{\'6956\',\'1011278165\'},\'10\',{\'7280\',\'1011278165\'},\'11\',{\'7201\',\'1011278165\',\'7186\',\'1011278165\',\'7277\',\'1011278165\'},\'5\',{\'6056\',\'1011278165\'},\'12\',{\'7281\',\'1011278165\'},\'30\',{\'7221\',\'1011278165\'},\'8\',{\'6954\',\'1011278165\'},\'14\',{\'7278\',\'1011278165\'},\'32\',{\'7224\',\'1011278165\'},\'34\',{\'7225\',\'1011278165\'}}};

') from GT::Session::SQL::save at d:/66.34.125.120/forums/admin/GT/Session/SQL.pm line 208

GT::SQL::Table (3172): Failed to execute query: 'INSERT INTO gforum_Session (session_user_id,session_date,session_id,session_data) VALUES (?,?,?,?)' Reason: [Microsoft][ODBC SQL Server Driver]String data, right truncation (SQL-22001)(DBD: st_execute/SQLExecute err=-1) at d:/66.34.125.120/forums/admin/GT/Session/SQL.pm line 208.

GT::Session::SQL (3172): Failed to execute query: 'INSERT INTO gforum_Session (session_user_id,session_date,session_id,session_data) VALUES (?,?,?,?)' Reason: [Microsoft][ODBC SQL Server Driver]String data, right truncation (SQL-22001)(DBD: st_execute/SQLExecute err=-1) at d:/66.34.125.120/forums/admin/GForum/Authenticate.pm line 505.

6 Model 8 Stepping 6, GenuineIntel

PROCESSOR_LEVEL => 6

PROCESSOR_REVISION => 0806

PROGRAMFILES => C:\Program Files

REMOTE_ADDR => 65.65.182.110

REMOTE_HOST => 65.65.182.110

REQUEST_METHOD => POST

SCRIPT_NAME => /forums/gforum.cgi

SERVER_NAME => www.heavybombers.com

SERVER_PORT => 80

SERVER_PORT_SECURE => 0

SERVER_PROTOCOL => HTTP/1.1

SERVER_SOFTWARE => Microsoft-IIS/5.0

SYSTEMDRIVE => C:

SYSTEMROOT => C:\WINNT

TEMP => C:\WINNT\TEMP

TMP => C:\WINNT\TEMP

USERPROFILE => C:\Documents and Settings\webmaster.TERRA0

WINDIR => C:\WINNT



This is an error one particular user is generating upon login. I can replicate it trying to log in as him.

Help?
Quote Reply
Re: [heavybombers] User log in error In reply to
Does this help?

http://www.uwi.com/support/devfaq.htm#1.1
Quote Reply
Re: [RedRum] User log in error In reply to
...well, the specific user ID is a first & last name consisting of 9 total characters , and the password is 7 alpha numeric characters. From my reading of this para there's nothing in that id/pass that would match this description.

[/url]1.1 - What does a Link ODBC Gateway error of "String data, right truncation" mean?

This error is generated by the ODBC driver and suggests that you are trying to populate a table column which has a set maximum character limit with data that exceeds this limit. To avoid this problem, we suggest setting up your table's columns so that they have exactly the same data types as the formats of your form's fields (including size limitations).
Quote Reply
Re: [heavybombers] User log in error In reply to
Anybody from Gossamer have a comment on this error?
Quote Reply
Re: [heavybombers] User log in error In reply to
Hi,

I'll get Jason to look at this, basically it means the session information was too large to store in the sessions table and MS SQL had to truncate it. I'll see why that was.

A logout/login should fix it temporarily.

Cheers,

Alex
--
Gossamer Threads Inc.