Notice

This old forum is now only available for consultation/read. User accounts on this old website are blocked.
Please create a new account on seblod.com and use the new forum http://www.seblod.com/community/forums.
Apologies for this perturbation and thank you for your understanding!
Welcome, Guest
Username Password: Remember me

[SOLVED] Search (as well as list) produces no results
(1 viewing) (1) Guest
  • Page:
  • 1

TOPIC: [SOLVED] Search (as well as list) produces no results

[SOLVED] Search (as well as list) produces no results 1 year, 8 months ago #1

  • tsm
  • ( User )
  • OFFLINE
  • Junior Boarder
  • Posts: 23
Hi folks,

I have an issue concerning search...
I have followed James Morell's Screencasts:


and


... to the letter but cannot seem to get results for my searches. Either those are with text fields or the multiselect field that are in that screencast.


If I create a menu item for an article, the article is displayed, no problem here.

But if I create a search or a list menu item, there are no results found.

BTW if I do a Joomla search (Finder), the Article is found.

Here's the SQL that debug prints out:


 
SELECT
t0.id AS pid,
t0.pk AS pk,
t0.pkb AS pkb,
t1.*, t2.*,
t0.cck AS cck,
t0.storage_location AS storage_location,
tt.id AS cck_type_id,
t2.published = 1 AS t2published,
t2.access IN (1,1) AS t2access
,t0.cck AS t0cck
FROM `evu19_cck_core` AS t0 LEFT JOIN `evu19_content` AS t1 ON
t1.id = t0.pk LEFT JOIN `evu19_categories` AS t2 ON
t2.id = t0.pk LEFT JOIN evu19_cck_core_types AS tt ON
tt.name = t0.cck
WHERE
t2.published = 1
AND
t2.access IN (1,1)
AND
t0.cck = "category"
AND
t1.title LIKE "%FRANK%"
GROUP BY t0.pk
ORDER BY t2.title ASC
 


I ran that through phpmyadmin and, as expected, it produced no result.

It gave me a result when I removed this part:

 
t2.published = 1
AND
t2.access IN (1,1)
AND
t0.cck = "category"
AND
 


So I guess that either there is something wrong with the query or my Joomla installation is corrupted.

However, the Joomla installation is part of a project that I started a few days ago, so it's fresh.

Joomla: 2.5.9

Seblod: 2.3.9.2

Thanks for any ideas and help

Frank
Last Edit: 1 year, 8 months ago by tsm. Reason: Solved

Re: Search (as well as list) produces no results 1 year, 8 months ago #2

  • nithinp89
  • ( User )
  • OFFLINE
  • Platinum Boarder
  • Posts: 1140
Hello,

Check your CCK filed used in search form. The values should be the same as your content type name.

t0.cck = "category"
Best Regards
Nithin Prathapan

5 Things to Start with SEBLOD
1. Documentation 2. Videos 3. Getting Started & FAQ 4. Tips & Tricks 5. SEBLOD Forum

Re: Search (as well as list) produces no results 1 year, 8 months ago #3

  • tsm
  • ( User )
  • OFFLINE
  • Junior Boarder
  • Posts: 23
Hi,
thanks for your input.

Out of curiosity I installed a totally fresh Joomla 2.5.9 and it works there. I am trying to find out what's wrong. Will post here...

Re: Search (as well as list) produces no results 1 year, 8 months ago #4

  • tsm
  • ( User )
  • OFFLINE
  • Junior Boarder
  • Posts: 23
So, Nithin, thanks for your help!! You nailed it!
It was the cck field that was strangely pointing to the wrong category.
I really don't know how I set this up.. Strange...
  • Page:
  • 1
Time to create page: 0.18 seconds