Gossamer Forum
(Advanced Search)
for
Home : Products : Gossamer Links : Discussions :

Search on field ...

Jun 23, 2002, 6:03 PM
Payooo
User (424 posts)
Jun 23, 2002, 6:03 PM
Post #1 of 7
Views: 1856
Shortcut
Quote Reply
Search on field ...
I am trying to search/display all links with "isHot" field = Yes and than I get the following error:



.../cgi-bin/search.cgi?isHot=Yes


A fatal error has occured:

Can't call method "fetchall_hashref" on an undefined value at /home/xxx/public_html/cgi-bin/admin/Links/User/Search.pm line 147.

Please enable debugging in setup for more details.





What am I doing wrong?

Thanks for help!
Jun 24, 2002, 1:33 AM
Andy
Veteran / Moderator (18441 posts)
Andy's avatar
Jun 24, 2002, 1:33 AM
Post #2 of 7
Views: 1803
Shortcut
Quote Reply
Re: [Payooo] Search on field ... In reply to
isHot...isn't it isPop? Links could be getting confused cos you are asking it to search for a non-existant field Tongue

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!
Jun 24, 2002, 2:12 AM
Payooo
User (424 posts)
Jun 24, 2002, 2:12 AM
Post #3 of 7
Views: 1807
Shortcut
Quote Reply
Re: [Andy] Search on field ... In reply to
It exist, that's my custom field. Wink

My problem is even bigger - I can't search/display default fields like Title, Description. ID ...

Everything works great with:

.../cgi-bin/search.cgi?query=something&isHot=Yes

but with:

.../cgi-bin/search.cgi?isHot=Yes

Nope! Problem!Unsure
Jun 24, 2002, 2:18 AM
Andy
Veteran / Moderator (18441 posts)
Andy's avatar
Jun 24, 2002, 2:18 AM
Post #4 of 7
Views: 1791
Shortcut
Quote Reply
Re: [Payooo] Search on field ... In reply to
Have you tried a 'repair tables' and 'rebuild search' ?

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!
Jun 24, 2002, 2:19 AM
Payooo
User (424 posts)
Jun 24, 2002, 2:19 AM
Post #5 of 7
Views: 1796
Shortcut
Quote Reply
Re: [Andy] Search on field ... In reply to
Yes.
Jun 24, 2002, 2:25 AM
Andy
Veteran / Moderator (18441 posts)
Andy's avatar
Jun 24, 2002, 2:25 AM
Post #6 of 7
Views: 1808
Shortcut
Quote Reply
Re: [Payooo] Search on field ... In reply to
MMM...weird. It is almost like your SQL database settings are wrong. Is it doing build all etc ok? Try emabling debugging in setup, and then doing a search again...then post what it says. It could be one of many things...but the most likely is that your admin have deleted your database/its become corrupt/they changed your login details...

I'm off to college now..so someone else will have to take over this thread Tongue

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!
Jun 24, 2002, 12:14 PM
Payooo
User (424 posts)
Jun 24, 2002, 12:14 PM
Post #7 of 7
Views: 1773
Shortcut
Quote Reply
Re: [Andy] Search on field ... In reply to
I found the solution (I can't believe Wink)

In Setup: Search Options > build_sort_order_search

field you can't sort search results by some field and also leave "score"

In my case "isHot,Title,score" ... Try without "score" - "isHot,Title"

Maybe it's my fault ...

Thanks Andy Smile