Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Links SQL not Build HTML pages

Quote Reply
Links SQL not Build HTML pages
Hi,
I finisced to introduce last catagory on the directory and then I want rebuild all but a problem appears on my monitor

-------------
Started at Wed Mar 5 14:22:40 2003.

Creating backup file ...
Done (1.00 s)

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

Updating New Flags ...
Done (0.00 s)

Updating Changed Flags ...
Done (0.00 s)

Updating Cool Flags ...
A fatal error has occured:Can't call method "fetchrow_array" on an undefined value at Links::Build::build_cool_flags line 24.
Please enable debugging in setup for more details.
-------------------

Is impossibile find a solution?

thanks a lot for your patient

Salvatore
Quote Reply
Re: [salvatore] Links SQL not Build HTML pages In reply to
Please go into Setup > Misc. Options, and set 'Debug' to 1. Then try a rebuild again, and show us the error code. The code you posted could mean anything Wink

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [Andy] Links SQL not Build HTML pages In reply to
ok,
Can You read the follow code? Can you take a look?
Thanks

Started at Wed Mar 5 14:35:39 2003.

Creating backup file ...
Done (1.00 s)

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

Updating New Flags ...
Done (0.00 s)

Updating Changed Flags ...
Done (0.00 s)

Updating Cool Flags ...
A fatal error has occured:Can't call method "fetchrow_array" on an undefined value at Links::Build::build_cool_flags line 24.
Please enable debugging in setup for more details.
Stack Trace
======================================
Links (1459325): Links::environment called at c:/PROGRA~1/APACHE~1/APACHE/CGI-BIN/admin/Links.pm line 430 with no arguments.
Links (1459325): Links::fatal called at Links::Build::build_cool_flags line 24 with arguments
(Can't call method "fetchrow_array" on an undefined value at Links::Build::build_cool_flags line 24.
).
Links (1459325): Links::Build::build_cool_flags called at c:/PROGRA~1/APACHE~1/APACHE/CGI-BIN/admin/GT/Plugins.pm line 108 with arguments
(HASH(0x1d7b854)).
Links (1459325): GT::Plugins::dispatch called at c:/PROGRA~1/APACHE~1/APACHE/CGI-BIN/admin/Links/Build.pm line 30 with arguments
(GT::Plugins, C:/Programmi/Apache Group/Apache/cgi-bin/admin/Plugins, build_cool_flags, *Links::Build::build_cool_flags, HASH(0x1d7b854)).
Links (1459325): Links::Build::build called at c:\PROGRA~1\APACHE~1\APACHE\CGI-BIN\ADMIN\NPH-BU~1.CGI line 676 with arguments
(cool_flags, HASH(0x1d7b854)).
Links (1459325): main::_build_cool_flags called at c:\PROGRA~1\APACHE~1\APACHE\CGI-BIN\ADMIN\NPH-BU~1.CGI line 73 with no arguments.
Links (1459325): main::build_all called at c:\PROGRA~1\APACHE~1\APACHE\CGI-BIN\ADMIN\NPH-BU~1.CGI line 43 with no arguments.
Links (1459325): main::main called at c:\PROGRA~1\APACHE~1\APACHE\CGI-BIN\ADMIN\NPH-BU~1.CGI line 30 with no arguments.


System Information
======================================
Perl Version: 5.006001
Links SQL Version: 2.1.1
DBI.pm Version: 1.14
Persistant Env: mod_perl (0) SpeedyCGI (0)
GT::SQL::error = Failed to execute query: 'SELECT ID,Hits,isPopular FROM lsql_Links WHERE ( isValidated = ? AND Hits >= ? )
ORDER BY Hits DESC
LIMIT 1' Reason: Got error 127 from table handler
@INC =
c:/PROGRA~1/APACHE~1/APACHE/CGI-BIN/admin
C:/Perl/lib
C:/Perl/site/lib
.

CGI INPUT
======================================
do => all


thanks again

Salvatore
Quote Reply
Re: [salvatore] Links SQL not Build HTML pages In reply to
Looks like your database is corrupt. Please see this post by Alex;

http://www.gossamer-threads.com/...i?post=183373#183373

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [Andy] Links SQL not Build HTML pages In reply to
Thanks...:)

You are great!

cheers,

Salvatore