Gossamer Forum
Home : Products : Gossamer Links : Discussions :

BUG::Category Browser

Quote Reply
BUG::Category Browser
Category Browser:
Home
Animation (0)
Architecture (0)
Art_History (0)
Bodyart (0)
Celebrities (0)
Classical_Studies (0)
Comics (0)
Crafts (0)
Design (0)

There are 213961 links for you to choose from!

I imported a part of the data base of the DMOZ, the Arts Category but in page.cgi it shows the categories as if they were empty (0) and in browse also, what he can be? plugin does not have none installed.


-=-=-=-=-=-=-=-=-=-
For a better world.Cool
Janio Le
-=-=-=-=-=-=-=-=-=-
Quote Reply
Re: BUG::Category Browser In reply to
Janio:

I think this is not so much a bug as just information not there (yet!). Run rebuild tables, and that should update each category with the correct number of links!

good luck!

dave

Quote Reply
Re: BUG::Category Browser In reply to
Updating New Flags ...
A fatal error has occured:Can't call method "fetchrow_array" on an undefined value at (eval 7) line 38.

=\=\=\=\=\=\=\

The Links recognizes all the imported data as New? nph-build.cgi passed 1 hour almost generating the New Page, until stopping due to memory.

In Reply To:
213961 New Links:

Thursday, January 25 2001 (213961)
-=-=-=-=-=-=-=-=-=-
For a better world.Cool
Janio Le
-=-=-=-=-=-=-=-=-=-
Quote Reply
Re: BUG::Category Browser In reply to
Building HTML Pages: Repairing tables.
Building HTML Pages: Repairing tables.

Links SQL is now ensuring that your category counts are correct.



Started at Fri Jan 26 12:14:07 2001.

Resetting category stats ...
Updating Root Category: Music ... ok (73787)
Updating Root Category: Television ... ok (11471)
Updating Root Category: Animation ... ok (14347)
Updating Root Category: Bodyart ... ok (310)
Updating Root Category: Comics ... ok (4214)
Updating Root Category: Movies ... ok (17371)
Updating Root Category: Photography ... ok (8305)
Updating Root Category: Design ... ok (2528)
Updating Root Category: Radio ... ok (2585)
Updating Root Category: Digital ... ok (271)
Updating Root Category: Graphic_Design ... ok (343)
Updating Root Category: Humanities ... ok (240)
Updating Root Category: Visual_Arts ... ok (9362)
Updating Root Category: Architecture ... ok (2142)
Updating Root Category: Celebrities ... ok (16705)
Updating Root Category: Illustration ... ok (1188)
Updating Root Category: Literature ... ok (24307)
Updating Root Category: Regional ... ok (0)
Updating Root Category: Crafts ... ok (5020)
Updating Root Category: Video ... ok (203)
Updating Root Category: Performing_Arts ... ok (10229)
Updating Root Category: Genres ... ok (401)
Updating Root Category: Education ... ok (1128)
Updating Root Category: Magazines_and_E-zines ... ok (251)
Updating Root Category: Online_Writing ... ok (2953)
Updating Root Category: Periods_and_Movements ... ok (2)
Updating Root Category: Writers_Resources ... ok (2112)
Updating Root Category: Internet_Directories_and_Portals ... ok (261)
Updating Root Category: Art_History ... ok (1352)
Updating Root Category: Classical_Studies ... ok (315)
Updating Root Category: Entertainment ... ok (258)
Done (274.00 s)

Resetting hits and rates ...
Done (0.00 s)

Updating New Flags ...
A fatal error has occured:Can't call method "fetchrow_array" on an undefined value at (eval 7) line 38.
Please enable debugging in setup for more details.
Stack Trace
======================================
Links (3649): Links::environment called at /home/httpd/cgi-bin/admin/Links.pm line 450 with no arguments.Links (3649): Links::fatal called at /home/httpd/cgi-bin/admin/GT/Base.pm line 271 with arguments (Can't call method "fetchrow_array" on an undefined value at (eval 7) line 38.
).Links (3649): GT::Base::error_handler called at (eval 7) line 38 with arguments (Can't call method "fetchrow_array" on an undefined value at (eval 7) line 38.
).Links (3649): Links::Build::build_new_flags called at /home/httpd/cgi-bin/admin/GT/Plugins.pm line 76 with arguments (HASH(0x8497258)).Links (3649): GT::Plugins::dispatch called at /home/httpd/cgi-bin/admin/Links/Build.pm line 43 with arguments (GT::Plugins, /home/httpd/cgi-bin/admin/Plugins, build_new_flags, *Links::Build::build_new_flags, HASH(0x8497258)).Links (3649): Links::Build::build called at /home/httpd/cgi-bin/admin/nph-build.cgi line 590 with arguments (new_flags, HASH(0x8497258)).Links (3649): main::_build_new_flags called at /home/httpd/cgi-bin/admin/nph-build.cgi line 237 with arguments (HASH(0x8497258)).Links (3649): main::build_repair called at /home/httpd/cgi-bin/admin/nph-build.cgi line 40 with no arguments.Links (3649): main::main called at /home/httpd/cgi-bin/admin/nph-build.cgi line 28 with no arguments.

System Information
======================================
Perl Version: 5.00503
Links SQL Version: 2.0.0-rc1
DBI.pm Version: 1.14
GT::SQL::error = Failed to execute query: ' SELECT CatLinks.CategoryID, Links.Add_Date FROM CatLinks, Links WHERE CatLinks.LinkID = Links.ID AND (Links.isNew = 'Yes') ORDER BY Add_Date ASC' Reason: The table 'SQLa823c0_0' is full
@INC =
/home/httpd/cgi-bin/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
======================================
do => repair


CGI Cookies
======================================


ENVIRONMENT
======================================
AUTH_TYPE => Basic
DOCUMENT_ROOT => /home/httpd/html
GATEWAY_INTERFACE => CGI/1.1
HTTP_ACCEPT => application/vnd.ms-excel, application/msword, application/vnd.ms-powerpoint, image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/x-comet, */*
HTTP_ACCEPT_ENCODING => gzip, deflate
HTTP_ACCEPT_LANGUAGE => pt-br
HTTP_CONNECTION => Keep-Alive
HTTP_HOST => search.babaloo.com.br
HTTP_REFERER => http://search.babaloo.com.br/cgi-bin/admin/admin.cgi?do=page&page=db_nav.html
HTTP_USER_AGENT => Mozilla/4.0 (compatible; MSIE 5.0; Windows 98)
PATH => /sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/bin
QUERY_STRING => do=repair
REMOTE_ADDR => 192.168.1.10
REMOTE_PORT => 2318
REMOTE_USER => janio
REQUEST_METHOD => GET
REQUEST_URI => /cgi-bin/admin/nph-build.cgi?do=repair
SCRIPT_FILENAME => /home/httpd/cgi-bin/admin/nph-build.cgi
SCRIPT_NAME => /cgi-bin/admin/nph-build.cgi
SERVER_ADDR => 192.168.1.17
SERVER_ADMIN => janio@wbr.com.br
SERVER_NAME => search.babaloo.com.br
SERVER_PORT => 80
SERVER_PROTOCOL => HTTP/1.1
SERVER_SIGNATURE => Apache/1.3.9 Server at search.babaloo.com.br Port 80

SERVER_SOFTWARE => Apache/1.3.9 (Unix) (Conectiva/Linux) mod_ssl/2.4.2 OpenSSL/0.9.4 mod_perl/1.21 PHP/3.0.12


-=-=-=-=-=-=-=-=-=-
For a better world.Cool
Janio Le
-=-=-=-=-=-=-=-=-=-
Quote Reply
Re: BUG::Category Browser In reply to
Hi,

Did you see:

In Reply To:
--rdf-add-date="2001-01-05"
(This option can only be used with `--import RDF' and is required)
This sets the date that new link links should have their `Add_Date' and
`Mod_Date' fields set to. This should be in the format `YYYY-MM-DD'.
NOTE: You should NOT set this to a very recent date as all links would
then show up as "New" links.
Try running in the SQL monitory:

UPDATE Links SET Add_Date = '2000-01-01', Mod_Date = '2000-01-01';

which will change the add and modify dates of all links so that they aren't considered New.

Cheers,

Alex

--
Gossamer Threads Inc.