Andy,
OK. It was working for a bit but now I'm getting this when I click on any link in the directory (the jump.cgi ones) and/or click on the Dynamic view link in the Admin panel.
Mark
A fatal error has occured: GT::Session::SQL (6234): Failed to execute query: 'SELECT * FROM links2Sessions WHERE (session_id = ? AND session_date > ?)' Reason: Unknown column 'session_id' in 'where clause' at /home/ohiobiz/linkssql2/admin/Links/Authenticate.pm line 142.
Please enable debugging in setup for more details.Stack Trace ====================================== Links (6234): Links::environment called at /home/ohiobiz/linkssql2/admin/Links.pm line 524 with no arguments. Links (6234): Links::fatal called at GT::Base::error line 381 with arguments (GT::Session::SQL (6234): Failed to execute query: 'SELECT * FROM links2Sessions WHERE (session_id = ? AND session_date > ?)' Reason: Unknown column 'session_id' in 'where clause' at /home/ohiobiz/linkssql2/admin/Links/Authenticate.pm line 142. ). Links (6234): GT::Base::error called at /home/ohiobiz/linkssql2/admin/GT/Session/SQL.pm line 138 with arguments (GT::Session::SQL=HASH(0x81f0aec), Failed to execute query: 'SELECT * FROM links2Sessions WHERE (session_id = ? AND session_date > ?)' Reason: Unknown column 'session_id' in 'where clause'). Links (6234): GT::Session::SQL::load called at /home/ohiobiz/linkssql2/admin/GT/Session/SQL.pm line 91 with arguments (GT::Session::SQL=HASH(0x81f0aec), cabea68fd7d48ce19f8a552c96194158). Links (6234): GT::Session::SQL::new called at /home/ohiobiz/linkssql2/admin/Links/Authenticate.pm line 142 with arguments (GT::Session::SQL, HASH(0x828b924)). Links (6234): Links::Authenticate::auth_valid_session called at /home/ohiobiz/linkssql2/admin/GT/Plugins.pm line 92 with arguments ([undef]). Links (6234): GT::Plugins::dispatch called at /home/ohiobiz/linkssql2/admin/Links/Authenticate.pm line 34 with arguments (GT::Plugins, /home/ohiobiz/linkssql2/admin/Plugins, auth_valid_session, *Links::Authenticate::auth_valid_session, [undef]). Links (6234): Links::Authenticate::auth called at /home/ohiobiz/linkssql2/admin/Links.pm line 176 with arguments (valid_session). Links (6234): Links::init_user called at /home/www/pages/ohiobiz/linkssql2/jump.cgi line 23 with no arguments.
System Information ====================================== Perl Version: 5.00503 Links SQL Version: 2.2.0 DBI.pm Version: 1.19 Running under mod_perl: No Running under SpeedyCGI: No GT::SQL::error = Failed to execute query: 'SELECT * FROM links2Sessions WHERE (session_id = ? AND session_date > ?)' Reason: Unknown column 'session_id' in 'where clause' DBI::errstr = Unknown column 'session_id' in 'where clause' @INC = /home/ohiobiz/linkssql2/admin /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 .
CGI INPUT ====================================== ID => 2500
CGI Cookies ====================================== s => cabea68fd7d48ce19f8a552c96194158
ENVIRONMENT ====================================== DOCUMENT_ROOT => /home/www/pages/ohiobiz/ GATEWAY_INTERFACE => CGI/1.1 GT_TMPDIR => /home/ohiobiz/linkssql2/admin/tmp HTTP_ACCEPT => */* HTTP_ACCEPT_LANGUAGE => en-us HTTP_COOKIE => s=cabea68fd7d48ce19f8a552c96194158 HTTP_HOST => www.ohiobiz.com HTTP_USER_AGENT => Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; YPC 3.0.3; .NET CLR 1.1.4322) HTTP________ => ~~~~:~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ HTTP___________ => ~~~~~~~~~~ ORACLE_HOME => "/oracle/product/8_1_7"= PATH => /usr/sbin:/sbin:/usr/sbin:/sbin:/sbin:/bin:/usr/sbin:/usr/bin:/oracle/product/8.1.7/bin QUERY_STRING => ID=2500 REMOTE_ADDR => 65.43.216.97 REMOTE_PORT => 4677 REQUEST_METHOD => GET REQUEST_URI => /linkssql2/jump.cgi?ID=2500 SCRIPT_FILENAME => /home/www/pages/ohiobiz/linkssql2/jump.cgi SCRIPT_NAME => /linkssql2/jump.cgi SERVER_ADDR => 63.150.26.74 SERVER_ADMIN => root@fatima.cmd-epubs.com SERVER_NAME => www.ohiobiz.com SERVER_PORT => 80 SERVER_PROTOCOL => HTTP/1.0 SERVER_SIGNATURE => Apache/1.3.27 Server at www.ohiobiz.com Port 80 SERVER_SOFTWARE => Apache/1.3.27 (Unix) PHP/4.3.1 mod_ssl/2.8.14 OpenSSL/0.9.6g