I do not manage to start the Spider 2.5.3. Can someone help me?
When starting spider.pl i have this arror displayed:
Can't call method "fetchrow_arrayref" on an undefined value at ../../GT/Robot.pm line 318.
If I turn in debug mode this is displayed:
[kjetilpa@adawen Spider]$ perl spider.pl
Checking for another instance of the spider
Starting Spider
Spider Daemonized
GT::Config (13936): Loading '/www/docs/www.divephoto.com/cgi-bin/lsql/admin/defs/database.def' with options: inheritance => '0', local => '0', cache => '1', create_ok => '1', empty => '0', chmod => '438', strict => '0', debug => '1', compile_subs => '' at ../../GT/Config.pm line 145.
GT::Config (13936): Not loading '/www/docs/www.divephoto.com/cgi-bin/lsql/admin/defs/database.def' from cache at ../../GT/Config.pm line 163.
GT::Config (13936): Adding '/www/docs/www.divephoto.com/cgi-bin/lsql/admin/defs/database.def' to the regular cache at ../../GT/Config.pm line 177.
[kjetilpa@adawen Spider]$ GT::Config (13936): Loading '/www/docs/www.divephoto.com/cgi-bin/lsql/admin/defs/glinks_Spider_Queue.def' with options: inheritance => '0', local => '0', cache => '1', create_ok => '0', empty => '0', chmod => '438', strict => '0', debug => '1', compile_subs => '' at ../../GT/Config.pm line 145.
GT::Config (13936): Not loading '/www/docs/www.divephoto.com/cgi-bin/lsql/admin/defs/glinks_Spider_Queue.def' from cache at ../../GT/Config.pm line 163.
GT::Config (13936): Adding '/www/docs/www.divephoto.com/cgi-bin/lsql/admin/defs/glinks_Spider_Queue.def' to the regular cache at ../../GT/Config.pm line 177.
GT::SQL::Driver::MYSQL::sth (13936): Executing query: SELECT COUNT(*) FROM glinks_Spider_Queue from GT::Robot::requests at ../../GT/Robot.pm line 154
GT::Config (13936): Loading '/www/docs/www.divephoto.com/cgi-bin/lsql/admin/defs/glinks_Spider_Links.def' with options: inheritance => '0', local => '0', cache => '1', create_ok => '0', empty => '0', chmod => '438', strict => '0', debug => '1', compile_subs => '' at ../../GT/Config.pm line 145.
GT::Config (13936): Not loading '/www/docs/www.divephoto.com/cgi-bin/lsql/admin/defs/glinks_Spider_Links.def' from cache at ../../GT/Config.pm line 163.
GT::Config (13936): Adding '/www/docs/www.divephoto.com/cgi-bin/lsql/admin/defs/glinks_Spider_Links.def' to the regular cache at ../../GT/Config.pm line 177.
GT::Config (13936): Loading '/www/docs/www.divephoto.com/cgi-bin/lsql/admin/defs/glinks_Spider_Hosts.def' with options: inheritance => '0', local => '0', cache => '1', create_ok => '0', empty => '0', chmod => '438', strict => '0', debug => '1', compile_subs => '' at ../../GT/Config.pm line 145.
GT::Config (13936): Not loading '/www/docs/www.divephoto.com/cgi-bin/lsql/admin/defs/glinks_Spider_Hosts.def' from cache at ../../GT/Config.pm line 163.
GT::Config (13936): Adding '/www/docs/www.divephoto.com/cgi-bin/lsql/admin/defs/glinks_Spider_Hosts.def' to the regular cache at ../../GT/Config.pm line 177.
GT::Config (13936): Loading '/www/docs/www.divephoto.com/cgi-bin/lsql/admin/defs/glinks_Spider_Rejected.def' with options: inheritance => '0', local => '0', cache => '1', create_ok => '0', empty => '0', chmod => '438', strict => '0', debug => '1', compile_subs => '' at ../../GT/Config.pm line 145.
GT::Config (13936): Not loading '/www/docs/www.divephoto.com/cgi-bin/lsql/admin/defs/glinks_Spider_Rejected.def' from cache at ../../GT/Config.pm line 163.
GT::Config (13936): Adding '/www/docs/www.divephoto.com/cgi-bin/lsql/admin/defs/glinks_Spider_Rejected.def' to the regular cache at ../../GT/Config.pm line 177.
GT::SQL::Driver::MYSQL::sth (13936): Executing query: SELECT COUNT(*) FROM glinks_Spider_Links from GT::Robot::status at ../../GT/Robot.pm line 175
GT::SQL::Driver::MYSQL::sth (13936): Executing query: SELECT COUNT(*) FROM glinks_Spider_Queue from GT::Robot::status at ../../GT/Robot.pm line 176
GT::SQL::Driver::MYSQL::sth (13936): Executing query: SELECT COUNT(*) FROM glinks_Spider_Hosts from GT::Robot::status at ../../GT/Robot.pm line 177
GT::SQL::Driver::MYSQL::sth (13936): Executing query: SELECT COUNT(*) FROM glinks_Spider_Rejected from GT::Robot::status at ../../GT/Robot.pm line 178
GT::SQL::Driver::MYSQL::sth (13936): Executing query: SELECT MIN(glinks_Spider_Queue.ID) FROM glinks_Spider_Hosts,glinks_Spider_Queue WHERE glinks_Spider_Queue.Host = glinks_Spider_Hosts.ID AND (glinks_Spider_Hosts.Last_Hit_Tic + glinks_Spider_Hosts.Hits_Interval < 1138197198 AND glinks_Spider_Hosts.Status = 6 AND glinks_Spider_Hosts.Banned = 'No') GROUP BY glinks_Spider_Hosts.ID LIMIT 10 from GT::Robot::get_spiderable_urls at ../../GT/Robot.pm line 283
GT::SQL::Driver::MYSQL::sth (13936): Executing query: SELECT * FROM glinks_Spider_Queue WHERE (ID = IN(20,22,25,27,30)) from GT::Robot::start_downloads at ../../GT/Robot.pm line 317
GT::SQL::Table (13936): Failed to execute query: 'SELECT * FROM glinks_Spider_Queue WHERE (ID = IN(20,22,25,27,30))': You have an error in your SQL syntax near 'IN(20,22,25,27,30))' at line 1 at ../../GT/SQL/Driver/sth.pm line 101.
Content-type: text/html
<p><font face='Tahoma,Arial,Helvetica' size=2>A fatal error has occured:</font></p><blockquote><pre>Can't call method "fetchrow_arrayref" on an undefined value at ../../GT/Robot.pm line 318.
</pre></blockquote><p><font face='Tahoma,Arial,Helvetica' size=2>Please enable debugging in setup for more details.</font></p>
<pre><b>Stack Trace</b>
======================================
Links (13936): Links::environment called at ../../Links.pm line 704 with no arguments.
Links (13936): Links::fatal called at ../../GT/Robot.pm line 318 with arguments
(Can't call method "fetchrow_arrayref" on an undefined value at ../../GT/Robot.pm line 318.
).
Links (13936): GT::Robot::start_downloads called at ../../GT/Robot.pm line 133 with arguments
(GT::Robot=HASH(0x8503e74), 20, 22, 25, 27, 30).
Links (13936): GT::Robot::do_iteration called at spider.pl line 171 with arguments
(GT::Robot=HASH(0x8503e74)).
Links (13936): main::_main_loop called at spider.pl line 63 with no arguments.
..........................
Kjetil Palmquist
www.svanger.com
When starting spider.pl i have this arror displayed:
Can't call method "fetchrow_arrayref" on an undefined value at ../../GT/Robot.pm line 318.
If I turn in debug mode this is displayed:
[kjetilpa@adawen Spider]$ perl spider.pl
Checking for another instance of the spider
Starting Spider
Spider Daemonized
GT::Config (13936): Loading '/www/docs/www.divephoto.com/cgi-bin/lsql/admin/defs/database.def' with options: inheritance => '0', local => '0', cache => '1', create_ok => '1', empty => '0', chmod => '438', strict => '0', debug => '1', compile_subs => '' at ../../GT/Config.pm line 145.
GT::Config (13936): Not loading '/www/docs/www.divephoto.com/cgi-bin/lsql/admin/defs/database.def' from cache at ../../GT/Config.pm line 163.
GT::Config (13936): Adding '/www/docs/www.divephoto.com/cgi-bin/lsql/admin/defs/database.def' to the regular cache at ../../GT/Config.pm line 177.
[kjetilpa@adawen Spider]$ GT::Config (13936): Loading '/www/docs/www.divephoto.com/cgi-bin/lsql/admin/defs/glinks_Spider_Queue.def' with options: inheritance => '0', local => '0', cache => '1', create_ok => '0', empty => '0', chmod => '438', strict => '0', debug => '1', compile_subs => '' at ../../GT/Config.pm line 145.
GT::Config (13936): Not loading '/www/docs/www.divephoto.com/cgi-bin/lsql/admin/defs/glinks_Spider_Queue.def' from cache at ../../GT/Config.pm line 163.
GT::Config (13936): Adding '/www/docs/www.divephoto.com/cgi-bin/lsql/admin/defs/glinks_Spider_Queue.def' to the regular cache at ../../GT/Config.pm line 177.
GT::SQL::Driver::MYSQL::sth (13936): Executing query: SELECT COUNT(*) FROM glinks_Spider_Queue from GT::Robot::requests at ../../GT/Robot.pm line 154
GT::Config (13936): Loading '/www/docs/www.divephoto.com/cgi-bin/lsql/admin/defs/glinks_Spider_Links.def' with options: inheritance => '0', local => '0', cache => '1', create_ok => '0', empty => '0', chmod => '438', strict => '0', debug => '1', compile_subs => '' at ../../GT/Config.pm line 145.
GT::Config (13936): Not loading '/www/docs/www.divephoto.com/cgi-bin/lsql/admin/defs/glinks_Spider_Links.def' from cache at ../../GT/Config.pm line 163.
GT::Config (13936): Adding '/www/docs/www.divephoto.com/cgi-bin/lsql/admin/defs/glinks_Spider_Links.def' to the regular cache at ../../GT/Config.pm line 177.
GT::Config (13936): Loading '/www/docs/www.divephoto.com/cgi-bin/lsql/admin/defs/glinks_Spider_Hosts.def' with options: inheritance => '0', local => '0', cache => '1', create_ok => '0', empty => '0', chmod => '438', strict => '0', debug => '1', compile_subs => '' at ../../GT/Config.pm line 145.
GT::Config (13936): Not loading '/www/docs/www.divephoto.com/cgi-bin/lsql/admin/defs/glinks_Spider_Hosts.def' from cache at ../../GT/Config.pm line 163.
GT::Config (13936): Adding '/www/docs/www.divephoto.com/cgi-bin/lsql/admin/defs/glinks_Spider_Hosts.def' to the regular cache at ../../GT/Config.pm line 177.
GT::Config (13936): Loading '/www/docs/www.divephoto.com/cgi-bin/lsql/admin/defs/glinks_Spider_Rejected.def' with options: inheritance => '0', local => '0', cache => '1', create_ok => '0', empty => '0', chmod => '438', strict => '0', debug => '1', compile_subs => '' at ../../GT/Config.pm line 145.
GT::Config (13936): Not loading '/www/docs/www.divephoto.com/cgi-bin/lsql/admin/defs/glinks_Spider_Rejected.def' from cache at ../../GT/Config.pm line 163.
GT::Config (13936): Adding '/www/docs/www.divephoto.com/cgi-bin/lsql/admin/defs/glinks_Spider_Rejected.def' to the regular cache at ../../GT/Config.pm line 177.
GT::SQL::Driver::MYSQL::sth (13936): Executing query: SELECT COUNT(*) FROM glinks_Spider_Links from GT::Robot::status at ../../GT/Robot.pm line 175
GT::SQL::Driver::MYSQL::sth (13936): Executing query: SELECT COUNT(*) FROM glinks_Spider_Queue from GT::Robot::status at ../../GT/Robot.pm line 176
GT::SQL::Driver::MYSQL::sth (13936): Executing query: SELECT COUNT(*) FROM glinks_Spider_Hosts from GT::Robot::status at ../../GT/Robot.pm line 177
GT::SQL::Driver::MYSQL::sth (13936): Executing query: SELECT COUNT(*) FROM glinks_Spider_Rejected from GT::Robot::status at ../../GT/Robot.pm line 178
GT::SQL::Driver::MYSQL::sth (13936): Executing query: SELECT MIN(glinks_Spider_Queue.ID) FROM glinks_Spider_Hosts,glinks_Spider_Queue WHERE glinks_Spider_Queue.Host = glinks_Spider_Hosts.ID AND (glinks_Spider_Hosts.Last_Hit_Tic + glinks_Spider_Hosts.Hits_Interval < 1138197198 AND glinks_Spider_Hosts.Status = 6 AND glinks_Spider_Hosts.Banned = 'No') GROUP BY glinks_Spider_Hosts.ID LIMIT 10 from GT::Robot::get_spiderable_urls at ../../GT/Robot.pm line 283
GT::SQL::Driver::MYSQL::sth (13936): Executing query: SELECT * FROM glinks_Spider_Queue WHERE (ID = IN(20,22,25,27,30)) from GT::Robot::start_downloads at ../../GT/Robot.pm line 317
GT::SQL::Table (13936): Failed to execute query: 'SELECT * FROM glinks_Spider_Queue WHERE (ID = IN(20,22,25,27,30))': You have an error in your SQL syntax near 'IN(20,22,25,27,30))' at line 1 at ../../GT/SQL/Driver/sth.pm line 101.
Content-type: text/html
<p><font face='Tahoma,Arial,Helvetica' size=2>A fatal error has occured:</font></p><blockquote><pre>Can't call method "fetchrow_arrayref" on an undefined value at ../../GT/Robot.pm line 318.
</pre></blockquote><p><font face='Tahoma,Arial,Helvetica' size=2>Please enable debugging in setup for more details.</font></p>
<pre><b>Stack Trace</b>
======================================
Links (13936): Links::environment called at ../../Links.pm line 704 with no arguments.
Links (13936): Links::fatal called at ../../GT/Robot.pm line 318 with arguments
(Can't call method "fetchrow_arrayref" on an undefined value at ../../GT/Robot.pm line 318.
).
Links (13936): GT::Robot::start_downloads called at ../../GT/Robot.pm line 133 with arguments
(GT::Robot=HASH(0x8503e74), 20, 22, 25, 27, 30).
Links (13936): GT::Robot::do_iteration called at spider.pl line 171 with arguments
(GT::Robot=HASH(0x8503e74)).
Links (13936): main::_main_loop called at spider.pl line 63 with no arguments.
..........................
Kjetil Palmquist
www.svanger.com