Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Problem with Search in new release

Quote Reply
Problem with Search in new release
Hi:

I upgraded to the new version... and while the normal (that is "query=XXX") seems ok, when I search other fields in this manner:
http://www.bcdb.com/...Go Fly a Kit&d=1

I get errors...

dave

Quote Reply
Re: Problem with Search in new release In reply to
Actually, I lied.... even a regular (query) search returns errors.... I get this:

Can't use string ("2") as a HASH ref while "strict refs" in use at search.cgi line 49, chunk 410.

dave

Quote Reply
Re: Problem with Search in new release In reply to
Hi,

Did you run the alter table commands through SQL monitor?

Cheers,

Alex

--
Gossamer Threads Inc.
Quote Reply
Re: Problem with Search in new release In reply to
Yes, I did....

I will double check all have the new fields...

dave

Quote Reply
Re: Problem with Search in new release In reply to
Oops, I stand corrected, this is the SearchLogger causing this problem. It will get updated today, in the meantime uninstall it and it will work fine.

Cheers,

Alex

--
Gossamer Threads Inc.
Quote Reply
Re: Problem with Search in new release In reply to
Alex:

Whew! I was swaeting. Also, just so you know, I checked, all the new field changes are there (as best as I can determine. ) Also, when I re-index search, I get timed out, so I use regular search... any difference?

Also, anything you can suggest I do to get search index to run faster, better or anything?

dave

Quote Reply
Re: Problem with Search in new release In reply to
Alex:

OK, uninstalled the plug-in, regular (query) search is fine, but the detailed search on fields returns error:

Can't call method "fetchrow_hashref" on an undefined value at search.cgi line 126, chunk 410.


dave

Quote Reply
Re: Problem with Search in new release In reply to
Can you turn on debugging and tell me what GT::SQL::error says? It works fine for me (using your data dump I got a week or two back).

Cheers,

Alex

--
Gossamer Threads Inc.
Quote Reply
Re: Problem with Search in new release In reply to
Alex:

(As I hold my head down in shame....)

The error is:

GT::SQL::error = Failed to execute query: 'SELECT * FROM new_Links WHERE (isValidated = 'Yes' AND Title LIKE '%Go Fly a Kit%')
ORDER BY Header ASC
LIMIT 0, 25' Reason: Unknown column 'Header' in 'order clause'


THUS, I know how to fix it...

sorry!

dave

Quote Reply
Re: Problem with Search in new release In reply to
Wait.... No, I do NOT know why....

the instructions for order state:

The default sort orders for search results. These must relate to columns in your Links or Category tables.

Well, Header should sort, should sort, shouldn't it?

dave

Quote Reply
Re: Problem with Search in new release In reply to
I changed the build_sort_order_search_cat to score, and all worked.... I set it to Title and it worked... but Header caused it to crash...

dave

Quote Reply
Re: Problem with Search in new release In reply to
Yes, hold your head high, this is my fault. =) I've fixed up the search, it was keeping your category sort order on your Links table.

Cheers,

Alex

--
Gossamer Threads Inc.
Quote Reply
Re: Problem with Search in new release In reply to
Alex:

Well, you did say you wanted us to go at it! Glad you caught it!

dave