Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Build error

Quote Reply
Build error

I just upgraded to Links SQL 2.0.4 from 2.0.2 and am having some trouble. I imported the database with no problems, but when I try to build the pages, I get the following error:

Building What's Cool Index ...
A fatal error has occured:
Can't call method "fetchrow_hashref" without a package or object reference at (eval 22) line 49.

I enabled "debugging" to try and figure out what happened. Here is some of the report:

System Information
Perl Version: 5.00404
Links SQL Version: 2.0.4
DBI.pm Version: 1.07
Persistant Env: mod_perl (0) SpeedyCGI (0)
GT::SQL::error = Failed to execute query: 'SELECT * FROM Links WHERE ( isValidated = 'Yes' AND isPopular = 'Yes' )
LIMIT 0, 25' Reason: You have an error in your SQL syntax near 'DESC
LIMIT 0, 25' at line 2

Anyone know the source of this error? I'm not a programmer and would appreciate any help.


Quote Reply
Re: Build error In reply to
I had the same problem and fixed it this way.

Go into your setup and Build Options.

For build_sort_order_cool whatever you have in there change to the following:-

Hits DESC,Rating

Don't ask my why, but I had something different in there when I upgraded and it caused me the exact same error. Once I changed it to this the problem went away.

Good luck with it.



http://www.AffiliatesDirectory.com - Affiliate Programs Directory
Quote Reply
Re: Build error In reply to
Thanks! Worked like a charm :-)