Hi,

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' )
ORDER BY Hits DESC DESC
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.

Jack

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.

Regards,


Clint

--------------------------
http://www.AffiliatesDirectory.com - Affiliate Programs Directory

Thanks! Worked like a charm :-)

Jack