Hi Andy!
Thanks for your help...here you go:
A fatal error has occured:
Can't call method "rows" on an undefined value at /srv/www/xxxxx/cgi-bin/admin/Links/Category.pm line 486.
Please enable debugging in setup for more details.
Stack Trace
======================================
Links (1617): Links::environment called at /srv/www/xxxxx/cgi-bin/admin/Links.pm line 431 with no arguments.
Links (1617): Links::fatal called at /srv/www/xxxxx/cgi-bin/admin/Links/Category.pm line 486 with arguments
(Can't call method "rows" on an undefined value at /srv/www/xxxxx/cgi-bin/admin/Links/Category.pm line 486.
).
Links (1617): Links::Category::set_new called at /srv/www/xxxxx/cgi-bin/admin/Links/Link.pm line 190 with arguments
(Links::Category=HASH(0x86fd3a0), ARRAY(0x84648e8)).
Links (1617): Links::Link::_plg_delete called at /srv/www/xxxxx/cgi-bin/admin/Links/Link.pm line 135 with arguments
(Links::Link=HASH(0x846631c), HASH(0x8539594)).
Links (1617): Links::Link::__ANON__ called at /srv/www/xxxxx/cgi-bin/admin/GT/Plugins.pm line 108 with arguments
(HASH(0x8539594)).
Links (1617): GT::Plugins::dispatch called at /srv/www/xxxxx/cgi-bin/admin/Links/Link.pm line 135 with arguments
(GT::Plugins, /srv/www/xxxxx/cgi-bin/admin/Plugins, delete_link, CODE(0x8647e7c), HASH(0x8539594)).
Links (1617): Links::Link::delete called at /srv/www/xxxxx/cgi-bin/admin/Links/Tools.pm line 1026 with arguments
(Links::Link=HASH(0x846631c), HASH(0x8539594)).
Links (1617): Links::Tools::_delete_record called at /srv/www/xxxxx/cgi-bin/admin/Links/Tools.pm line 864 with arguments
(Links::Link=HASH(0x846631c), 1060082).
Links (1617): Links::Tools::_validate called at /srv/www/xxxxx/cgi-bin/admin/Links/Tools.pm line 434 with arguments
(Links::Link=HASH(0x846631c)).
Links (1617): Links::Tools::validate_links called at GT::Template::_call_func line 764 with no arguments.
Links (1617): GT::Template::_call_func called at /srv/www/xxxxx/cgi-bin/admin/templates/admin/compiled/tools_validate.html.compiled line 23 with arguments
(GT::Template=HASH(0x8304028), Links::Tools::validate_links).
Links (1617): GT::Template::parsed_template called at /srv/www/xxxxx/cgi-bin/admin/GT/Template.pm line 600 with arguments
(GT::Template=HASH(0x8304028)).
Links (1617): GT::Template::_parse called at /srv/www/xxxxx/cgi-bin/admin/GT/Template.pm line 97 with arguments
(GT::Template=HASH(0x8304028), tools_validate.html, HASH(0x8301360)).
Links (1617): GT::Template::parse called at /srv/www/xxxxx/cgi-bin/admin/Links.pm line 251 with arguments
(GT::Template, tools_validate.html, ARRAY(0x8301300), HASH(0x8301360)).
Links (1617): Links::admin_page called at /srv/www/xxxxx/cgi-bin/admin/admin.cgi line 50 with no arguments.
Links (1617): main::main called at /srv/www/xxxxx/cgi-bin/admin/admin.cgi line 24 with no arguments.
System Information
======================================
Perl Version: 5.008
Links SQL Version: 2.1.2
DBI.pm Version: 1.40
Persistant Env: mod_perl (0) SpeedyCGI (0)
GT::SQL::error = Failed to execute query: '
SELECT MAX(Add_Date)
FROM lsql_CatLinks, lsql_Category, lsql_Links
WHERE lsql_CatLinks.LinkID = lsql_Links.ID AND lsql_CatLinks.CategoryID = lsql_Category.ID AND (lsql_Links.isNew = 'Yes' AND lsql_CatLinks.CategoryID IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,....,270522,271028))
GROUP BY Add_Date
' Reason: MySQL server has gone away
@INC =
/srv/www/xxxxx/cgi-bin/admin
/usr/lib/perl5/5.8.0/i586-linux-thread-multi
/usr/lib/perl5/5.8.0
/usr/lib/perl5/site_perl/5.8.0/i586-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.0
/usr/lib/perl5/site_perl
.
CGI INPUT
======================================
1-Add_Date => 2004-02-25
1-CatLinks.CategoryID =>
1-Contact_Email => s
1-Contact_Name =>
1-Date_Checked => 0000-00-00 00:00:00
1-Description => Hotel welcomes its visitors at the entrance to the High Tatras national park in the altitude of 800 m. Hotel offers special facilities for families with children for relax and for company meetings.
1-Hits => 0
1-ID => 1060082
1-LinkOwner => admin
1-Mod_Date => 2004-02-25
1-Rating => 0.00
1-Status => 0
1-Timestmp => 20040225183927
1-Title => Hotel Lesna, Stara Lesna, High Tatras
1-URL =>
1-Votes => 0
1-isChanged => No
1-isNew => Yes
1-isPopular => No
1-isValidated => No
1-screenshot =>
2-Add_Date => 2004-02-25
2-CatLinks.CategoryID => Destinations/Europe/Slovakia/Localities/Martin
2-Contact_Email =>
2-Contact_Name =>
2-Date_Checked => 0000-00-00 00:00:00
2-Description =>
The new and modern urban hotel offers comfortable accommodation in fully equipped rooms, quality service in the restaurant, coffee-bar, night-club with music and in the garden restaurant.
2-Hits => 0
2-ID => 1060083
2-LinkOwner => admin
2-Mod_Date => 2004-02-25
2-Rating => 0.00
2-Status => 0
2-Timestmp => 20040225184110
2-Title => Hotel Luna
2-URL =>
2-Votes => 0
2-isChanged => No
2-isNew => Yes
2-isPopular => No
2-isValidated => No
2-screenshot =>
3-Add_Date => 2004-02-25
3-CatLinks.CategoryID => Destinations/Europe/Slovakia/Localities/High Tatras
3-Contact_Email =>
3-Contact_Name =>
3-Date_Checked => 0000-00-00 00:00:00
3-Description => The Meander hotel has recently been completely reconstructed. It is situated in the wonderful foothill area of the High Tatras in the village Tatranska Strba.
3-Hits => 0
3-ID => 1060084
3-LinkOwner => admin
3-Mod_Date => 2004-02-25
3-Rating => 0.00
3-Status => 0
3-Timestmp => 20040225184351
3-Title => Hotel Meander, Tatranska Strba, High Tatras
3-URL => h
3-Votes => 0
3-isChanged => No
3-isNew => Yes
3-isPopular => No
3-isValidated => No
3-screenshot =>
4-Add_Date => 2004-02-25
4-CatLinks.CategoryID => Destinations/Europe/Slovakia/Localities/Spisska Nova Ves
4-Contact_Email =>
4-Contact_Name =>
4-Date_Checked => 0000-00-00 00:00:00
4-Description => During a visit of the city with its surroundings you are warmly welcome to Hotel Metropol. Hotel is known to supply with suitable accommodation all kind of clients - turists as well as the clients reqiuring the top quality. Nearly located Slovak Paradise is inviting you to have a walk across the virgin nature.
4-Hits => 0
4-ID => 1060086
4-LinkOwner => admin
4-Mod_Date => 2004-02-25
4-Rating => 0.00
4-Status => 0
4-Timestmp => 20040225184706
4-Title => Hotel Metropol
4-URL =>
4-Votes => 0
4-isChanged => No
4-isNew => Yes
4-isPopular => No
4-isValidated => No
4-screenshot =>
5-Add_Date => 2004-02-25
5-CatLinks.CategoryID => Destinations/Europe/Slovakia/Localities
5-Contact_Email =>
5-Contact_Name =>
5-Date_Checked => 0000-00-00 00:00:00
5-Description => Hotel Mýto offers collective and individual stayings, schoolings, seminars, lectures, receptions and others different social events. Natural and artifical snoxing in Mýto pod Ďumbierom, Čertovica and Tále grand you best conditions for skiing during the whole winter season.
5-Hits => 0
5-ID => 1060087
5-LinkOwner => admin
5-Mod_Date => 2004-02-25
5-Rating => 0.00
5-Status => 0
5-Timestmp => 20040225201745
5-Title => Hotel Myto, Myto pod Dumbierom
5-URL =>
5-Votes => 0
5-isChanged => No
5-isNew => Yes
5-isPopular => No
5-isValidated => No
5-screenshot =>
do => page
page => tools_validate.html
reason-1060082 => Your link:
that was submitted on 2004-02-25 has been rejected
for one of the following reasons:
1. Unsuitable content.
2. Duplicate URL.
If you have any questions, please don't hesitate to ask.
reason-1060083 => Your link:
http://www.
that was submitted on 2004-02-25 has been rejected
for one of the following reasons:
1. Unsuitable content.
2. Duplicate URL.
If you have any questions, please don't hesitate to ask.
reason-1060084 => Your link:
http://www.h that was submitted on 2004-02-25 has been rejected
for one of the following reasons:
1. Unsuitable content.
2. Duplicate URL.
If you have any questions, please don't hesitate to ask.
reason-1060086 => Your link:
http://www.h that was submitted on 2004-02-25 has been rejected
for one of the following reasons:
1. Unsuitable content.
2. Duplicate URL.
If you have any questions, please don't hesitate to ask.
reason-1060087 => Your link:
http://www.h that was submitted on 2004-02-25 has been rejected
for one of the following reasons:
1. Unsuitable content.
2. Duplicate URL.
If you have any questions, please don't hesitate to ask.
validate-1060082 => delete
CGI Cookies
======================================
editor_cols => 55
editor_rows => 15
ENVIRONMENT
======================================
AUTH_TYPE => Basic
CONTENT_LENGTH => 5618
CONTENT_TYPE => application/x-www-form-urlencoded
DOCUMENT_ROOT => /srv/www/xxxxx/public_html
GATEWAY_INTERFACE => CGI/1.1
GT_TMPDIR => /srv/www/xxxxx/cgi-bin/admin/tmp
HTTP_ACCEPT => image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/x-shockwave-flash, */*
HTTP_ACCEPT_ENCODING => gzip, deflate
HTTP_ACCEPT_LANGUAGE => de
HTTP_CACHE_CONTROL => no-cache
HTTP_CONNECTION => Keep-Alive
HTTP_COOKIE => editor_cols=55; editor_rows=15
HTTP_HOST =>
www.xxxxx.xxx HTTP_REFERER =>
HTTP_USER_AGENT => Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; i-NavFourF; Feedreader)
PATH => /bin:/usr/bin:/sbin:/usr/sbin:/usr/local/bin
QUERY_STRING =>
REMOTE_ADDR => 217.81.73.249
REMOTE_PORT => 65154
REMOTE_USER =>
REQUEST_METHOD => POST
REQUEST_URI => /cgi-bin/admin/admin.cgi
SCRIPT_FILENAME => /srv/www/xxxxx/cgi-bin/admin/admin.cgi
SCRIPT_NAME => /cgi-bin/admin/admin.cgi
SERVER_ADDR => 213.
SERVER_ADMIN =>
SERVER_NAME =>
SERVER_PORT => 80
SERVER_PROTOCOL => HTTP/1.1
SERVER_SIGNATURE => Apache/1.3.26 Server at
www.xxx.xxx Port 80
SERVER_SOFTWARE => Apache/1.3.26 (Linux/SuSE) mod_python/2.7.8 Python/2.2.1 PHP/4.2.2 mod_perl/1.27
UNIQUE_ID =>
While getting this info I noticed I currenty have 271028 categories. ;-)
Well...I guess I really should do some serious cleaning up there soon...but the number of categories should not cause the problem !?
GT is saying that LinksSQL can easily handle several million records....so it should be able to handle this size
of database.