HTML Logo by World Wide Web Consortium (www.w3.org). Click to learn more about our commitment to accessibility and standards.

Moving forward with Composr

ocPortal has been relaunched as Composr CMS, which is now in beta. ocPortal 9 will be superseded by Composr 10.

Head over to compo.sr for our new site, and to our migration roadmap. Existing ocPortal member accounts have been mirrored.


Search feature only partially working.

Login / Search

 [ Join | More ]
 Add topic 
Posted
Rating:
#106252 (In Topic #20727)
Avatar

Well-settled

Greetings!

On my recently installed v9.0.16, the Search feature only returns results on pages or entries that have keyword-tags appended. Otherwise, nothing from any module gets returned.

Please can anyone advise me?

Thanks to all reading.
Back to the top
 
Posted
Rating:
#106254
Avatar

Please provide a precise reproducible test case.

For example, you have a news entry with title "this is an ordinary test" and an advanced search under news for "ordinary" doesn't find any results.


Become a fan of ocPortal on Facebook or add me as a friend. Add me on on Twitter.
Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about ocPortal whenever you see the opportunity.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying ocPortal on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Back to the top
 
Posted
Rating:
#106256
Avatar

Well-settled

Hi Chris and thanks!

Chris Graham said

Please provide a precise reproducible test case.

For example, you have a news entry with title "this is an ordinary test" and an advanced search under news for "ordinary" doesn't find any results.


Yes, that would be an example. Also, say, searching for my username, or for a catalogue category or entry, or for the content of a Comcode page, in all instances whether a single word or a full title. Apart from tagged pages, the failure is  reproducible universally

Back to the top
 
Posted
Rating:
#106257
Avatar

Anything weird about this hosting? Could MySQL have had fulltext search crippled, e.g. by setting the minimum word length to something very long?

Does a boolean search work?


Become a fan of ocPortal on Facebook or add me as a friend. Add me on on Twitter.
Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about ocPortal whenever you see the opportunity.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying ocPortal on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Back to the top
 
Posted
Rating:
#106260
Avatar

Well-settled

There's never been any such problem in relation to my original v.9.0.9 installation, which sits in a sibling directory to the new 9.0.16 under the same domain. The the two installations now have identical .htacess (duplicated from recommended.htaccess) and php.ini files. (They didn't until just now, but having copied the 9.0.9 pair to the 9.0.16 directory, there's no change in this behaviour)

No, boolean searches don't work, and neither do advanced searches.

Are there any other files governing MySQL settings I could compare?
Back to the top
 
Posted
Rating:
#106261
Avatar

Well-settled

Hi Chris,
Further to the preceding post from me, I just tried an advanced search of my Links catalogue using just a single word in the title, with the main detailed search set to "Search only titles", and got the following error:

Unfortunately a query has failed [SELECT ((SELECT COUNT(*) FROM (SELECT 1 FROM oc_catalogue_entries r JOIN oc_catalogue_efv_short_trans f0 ON (f0.ce_id=r.id AND f0.cf_id=14) JOIN oc_catalogue_efv_short f1 ON (f1.ce_id=r.id AND f1.cf_id=15) JOIN oc_catalogue_efv_long_trans f2 ON (f2.ce_id=r.id AND f2.cf_id=16) JOIN oc_catalogue_efv_long f3 ON (f3.ce_id=r.id AND f3.cf_id=43) WHERE (r.cc_id=3) AND r.ce_add_date>1417909111 AND MATCH (t1.text_original) AGAINST ('orbitofrontal' IN BOOLEAN MODE) AND (f3.cv_value LIKE 'Choose keyword(s)' OR f3.cv_value LIKE '%\nChoose keyword(s)' OR f3.cv_value LIKE 'Choose keyword(s)\n%' OR f3.cv_value LIKE '%\nChoose keyword(s)\n%') AND r.c_name='links' LIMIT 1000) counter)) LIMIT 1] [Unknown column 't1.text_original' in 'where clause'] (version: 9.0.16, PHP version: 5.3.29, URL: /research/data/iframe.php?page=search&type=results&id=catalogue_entries&specific=1&catalogue_name=links&zone=site&content=&only_titles=1&author=&days=60&sort=relevance&direction=DESC&option_14=orbitofrontal&option_15=&option_16=&option_43=Choose+keyword%28s%29&search_under=3)


 

Back to the top
 
Posted
Rating:
#106266
Avatar

Well-settled

Hi Chris,
My guess is that query terms manually entered into the "Search for" fields are just not being passed as parameters. If a catalogue entry or page includes the tag "neuron" for example, then if I click the "neuron" tag on the outputted page, the query works and a result is returned. However, if I enter "neuron" manually, no result is returned. 

Does that suggest anything, perhaps?
Back to the top
 
Posted
Rating:
#106267
Avatar

Community saint

RichT said

Greetings!

On my recently installed v9.0.16, the Search feature only returns results on pages or entries that have keyword-tags appended. Otherwise, nothing from any module gets returned.

Please can anyone advise me?

Thanks to all reading.
Do you have a public facing URL?

Back to the top
 
Posted
Rating:
#106270
Avatar

I reproduced this last night, will look properly later.


Become a fan of ocPortal on Facebook or add me as a friend. Add me on on Twitter.
Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about ocPortal whenever you see the opportunity.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying ocPortal on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Back to the top
 
Posted
Rating:
#106305
Avatar

Well-settled

Thanks, Chris.
Back to the top
 
Posted
Rating:
#106405
Avatar

I am looking at this. My repro case from before turned out to be a minor random bug related to advanced news search, so I have not reproduced yet.

I reproduced your explicit error above though.

I noticed "Choose keyword(s)" in it. Can you explain that, do you know where this string comes from? It's non-standard but somehow within your query.


Become a fan of ocPortal on Facebook or add me as a friend. Add me on on Twitter.
Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about ocPortal whenever you see the opportunity.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying ocPortal on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Back to the top
 
Posted
Rating:
#106406
Avatar

This fixes everything I could find wrong:
0001799: Search errors - ocPortal feature tracker

But I doubt it solves your core issue.

Before running a search, try putting &keep_show_query=1 into the URL. It will output debug information to us that could provide some clues.


Become a fan of ocPortal on Facebook or add me as a friend. Add me on on Twitter.
Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about ocPortal whenever you see the opportunity.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying ocPortal on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Back to the top
 
Posted
Rating:
#106419
Avatar

Well-settled

Hi Chris,

Many thanks for getting back onto this! I installed the fixed files - but unfortunately to no avail as you guessed.

The "choose Keyword(s) string was within a catalogue custom field containing a multi-selectable drop-down list. That custom field has now been removed, but again with no effect.

Appending the URL extension yields no information.

I just now ran a search for the word "collections" with "Search only titles" ticked, and got the following error message:

Unfortunately a query has failed [(SELECT r.*,r.id AS id,r.cc_id AS r_cc_id,b.cv_value AS b_cv_value FROM oc_catalogue_fields f LEFT JOIN oc_catalogue_entries r ON (r.c_name=f.c_name) LEFT JOIN oc_catalogue_efv_short_trans a ON (r.id=a.ce_id AND f.id=a.cf_id) LEFT JOIN oc_catalogue_efv_long_trans b ON (r.id=b.ce_id AND f.id=b.cf_id) LEFT JOIN oc_catalogue_efv_long d ON (r.id=d.ce_id AND f.id=d.cf_id) LEFT JOIN oc_catalogue_efv_short c ON (r.id=c.ce_id AND f.id=c.cf_id) JOIN oc_translate t0 ON t0.id=a.cv_value AND t0.language='EN' WHERE MATCH (t0.text_original) AGAINST ('collections') AND r.ce_add_date>1419636625 AND r.c_name NOT LIKE '\_%' ORDER BY t1.text_original DESC LIMIT 10) UNION (SELECT r.*,r.id AS id,r.cc_id AS r_cc_id,b.cv_value AS b_cv_value FROM oc_catalogue_fields f LEFT JOIN oc_catalogue_entries r ON (r.c_name=f.c_name) LEFT JOIN oc_catalogue_efv_short_trans a ON (r.id=a.ce_id AND f.id=a.cf_id) LEFT JOIN oc_catalogue_efv_long_trans b ON (r.id=b.ce_id AND f.id=b.cf_id) LEFT JOIN oc_catalogue_efv_long d ON (r.id=d.ce_id AND f.id=d.cf_id) LEFT JOIN oc_catalogue_efv_short c ON (r.id=c.ce_id AND f.id=c.cf_id) WHERE MATCH (c.cv_value) AGAINST ('collections') AND (c.cv_value IS NOT NULL) AND r.ce_add_date>1419636625 AND r.c_name NOT LIKE '\_%' ORDER BY t1.text_original DESC GROUP BY r.id LIMIT 10) ORDER BY t1.text_original DESC LIMIT 10] [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GROUP BY r.id LIMIT 10) ORDER BY t1.text_original DESC LIMIT 10' at line 1] (version: 9.0.16, PHP version: 5.3.29, URL: /research/data/iframe.php?page=search&type=results&zone=site&content=collections&only_titles=1&author=&days=45&sort=title&direction=D


The error message I included in an earlier post was similarly generated with the "Search only titles" ticked. When it is unticked, no error is ever returned.

I'm afraid that correcting the SQL syntax here is quite beyond my know-how. Does my present info give you further clues? 

Back to the top
 
Posted
Rating:
#106420
Avatar

If there's no "?" in the URL already, try appending ?keep_show_query=1


Become a fan of ocPortal on Facebook or add me as a friend. Add me on on Twitter.
Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about ocPortal whenever you see the opportunity.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying ocPortal on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Back to the top
 
Posted
Rating:
#106427
Avatar

Well-settled

Hi again!

The URL already has ? in it, so I can only apply the & prefix.
Having started the query from the main_search block, The URL that gets returned with the results page reads:
https://.../research/site/index.php?page=search&type=results&content=collections&all_defaults=1&author=&days=-1
&sort=relevance&direction=DESC&only_titles=0&only_search_meta=0
&boolean_search=0&conjunctive_operator=AND

regardless of whether the &keep_show_query=1 is appended.
Back to the top
 
Posted
Rating:
#106428
Avatar

Are you logged in as an admin? It needs that, as it is theoretically going to give out privileged info.


Become a fan of ocPortal on Facebook or add me as a friend. Add me on on Twitter.
Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about ocPortal whenever you see the opportunity.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying ocPortal on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Back to the top
 
Posted
Rating:
#106429
Avatar

Oh and maybe search block doesn't carry it through, I don't know. Try adding it to end results URL.


Become a fan of ocPortal on Facebook or add me as a friend. Add me on on Twitter.
Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about ocPortal whenever you see the opportunity.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying ocPortal on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Back to the top
 
Posted
Rating:
#106431
Avatar

Well-settled

Yes, am logged in at administrator level.

The URL extension has no effect even if it's appended to the results screen page.

Was wondering - are you able to reproduce the returned error if you do a query with "Search only titles" ticked?


Last edit: by RichT
Back to the top
 
Posted
Rating:
#106436
Avatar

Just gathering data at moment, will test again soonish.

Might be best if I look on your site, as I'm not sure what's going on, so you could consider opening a free bug report ticket with access details.


Become a fan of ocPortal on Facebook or add me as a friend. Add me on on Twitter.
Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about ocPortal whenever you see the opportunity.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying ocPortal on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Back to the top
 
Posted
Rating:
#106477
Avatar

Should all be fixed now :). Was issue with our mysqli db driver (your other site probably uses the mysql one).


Become a fan of ocPortal on Facebook or add me as a friend. Add me on on Twitter.
Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about ocPortal whenever you see the opportunity.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying ocPortal on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Back to the top
 
1 guests and 0 members have just viewed this: None
Control functions:

Quick reply   Expand