Hi. I'm hoping you can give me some help.

I just moved my mySQL GossamerThreads to a new server.

Now I'm getting the error below. I'm clueless as to why this would happen and I hope you guys have seen this before.

Am I missing a Perl module?

Is there someplace in the script that must have an IP address versus a domain?


Thank! April


A fatal error has occured:

Can't call method "fetchrow_hashref" on an undefined value at /home/indylink/www/cgi-bin/admin/Links/Tools.pm line 449.

Please enable debugging in setup for more details.Stack Trace ====================================== Links (8457): Links::environment called at /home/indylink/www/cgi-bin/admin/Links.pm line 418 with no arguments. Links (8457): Links::fatal called at /home/indylink/www/cgi-bin/admin/Links/Tools.pm line 449 with arguments (Can't call method "fetchrow_hashref" on an undefined value at /home/indylink/www/cgi-bin/admin/Links/Tools.pm line 449. ). Links (8457): Links::Tools::validate_links called at /home/indylink/www/cgi-bin/admin/GT/Template.pm line 688 with no arguments. Links (8457): GT::Template::_call_func called at /home/indylink/public_html/cgi-bin/admin/templates/admin/compiled/tools_validate.html.compiled line 20 with arguments (GT::Template=HASH(0x8296048), Links::Tools::validate_links). Links (8457): GT::Template::__ANON__ called at /home/indylink/www/cgi-bin/admin/GT/Template.pm line 539 with arguments (GT::Template=HASH(0x8296048)). Links (8457): GT::Template::_parse called at /home/indylink/www/cgi-bin/admin/GT/Template.pm line 89 with arguments (GT::Template=HASH(0x8296048), tools_validate.html, HASH(0x82978dc)). Links (8457): GT::Template::parse called at /home/indylink/www/cgi-bin/admin/Links.pm line 250 with arguments (GT::Template, tools_validate.html, ARRAY(0x82979fc), HASH(0x82978dc)). Links (8457): Links::admin_page called at admin.cgi line 50 with no arguments. Links (8457): main::main called at admin.cgi line 24 with no arguments. System Information ====================================== Perl Version: 5.008001 Links SQL Version: 2.1.0 DBI.pm Version: 1.42 Persistant Env: mod_perl (0) SpeedyCGI (0) GT::SQL::error = Failed to execute query: 'SELECT COUNT(*) FROM links_Links WHERE ( ( isValidated = ? ) ) ' Reason: Table 'indylink_indy.links_Links' doesn't exist @INC = /home/indylink/www/cgi-bin/admin /usr/lib/perl5/5.8.1/i686-linux /usr/lib/perl5/5.8.1 /usr/lib/perl5/site_perl/5.8.1/i686-linux /usr/lib/perl5/site_perl/5.8.1 /usr/lib/perl5/site_perl/5.6.1 /usr/lib/perl5/site_perl . CGI INPUT ====================================== do => page page => tools_validate.html CGI Cookies ====================================== i1 => 47:268:17:1084225879:1074|46:289:19:1084225842:926|15:186:19:1084225855:1002|23:138:11:1084225842:1065|||||||||||||||||||||||||||||||| ENVIRONMENT ====================================== AUTH_TYPE => Basic DOCUMENT_ROOT => /home/indylink/public_html GATEWAY_INTERFACE => CGI/1.1 GT_TMPDIR => /home/indylink/public_html/cgi-bin/admin/tmp HTTP_ACCEPT => image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/x-shockwave-flash, application/vnd.ms-excel, application/vnd.ms-powerpoint, application/msword, */* HTTP_ACCEPT_ENCODING => gzip, deflate HTTP_ACCEPT_LANGUAGE => en-us HTTP_CONNECTION => Keep-Alive HTTP_COOKIE => i1=47:268:17:1084225879:1074|46:289:19:1084225842:926|15:186:19:1084225855:1002|23:138:11:1084225842:1065|||||||||||||||||||||||||||||||| HTTP_HOST => www.indylinks.com HTTP_REFERER => http://www.indylinks.com/cgi-bin/admin/admin.cgi?page=home_left.html HTTP_USER_AGENT => Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET CLR 1.0.3705) PATH => /usr/local/bin:/usr/bin:/bin QUERY_STRING => do=page&page=tools_validate.html REMOTE_ADDR => 12.203.223.252 REMOTE_PORT => 3207 REMOTE_USER => indylink REQUEST_METHOD => GET REQUEST_URI => /cgi-bin/admin/admin.cgi?do=page&page=tools_validate.html SCRIPT_FILENAME => /home/indylink/public_html/cgi-bin/admin/admin.cgi SCRIPT_NAME => /cgi-bin/admin/admin.cgi SERVER_ADDR => 66.225.241.64 SERVER_ADMIN => webmaster@indylinks.com SERVER_NAME => www.indylinks.com SERVER_PORT => 80 SERVER_PROTOCOL => HTTP/1.1 SERVER_SOFTWARE => Apache/1.3.31 (Unix) mod_auth_passthrough/1.8 mod_log_bytes/1.2 mod_bwlimited/1.4 PHP/4.3.3 FrontPage/5.0.2.2634 mod_ssl/2.8.17 OpenSSL/0.9.6b
A. Lougheed
IndyLinks.com
webmaster@indylinks.com

It seems your tables haven't been transferred over.

>>
Reason: Table 'indylink_indy.links_Links' doesn't exist
<<

Jarrod. Thanks so much for your help.

You were exactly right. Soon as I had the HOST manually copy the MySQL files - it worked like a charm.

It would have taken me days to think to check the db.

Best regards, April

P.S. Now if I could just get AdCycle to work. :)
A. Lougheed
IndyLinks.com
webmaster@indylinks.com