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

Welcome, Guest

(1 viewing) (1) Guest

Reply Topic

New Topic

Page:
1

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

[SOLVED] Search (as well as list) produces no results 3 months, 2 weeks 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: 3 months, 2 weeks ago by tsm. Reason: Solved

Reply Quote

Re: Search (as well as list) produces no results 3 months, 2 weeks ago #2

nithinp89 ( Moderator ) OFFLINE Moderator 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 Reply Quote

Re: Search (as well as list) produces no results 3 months, 2 weeks 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...
	Reply Quote

Re: Search (as well as list) produces no results 3 months, 2 weeks 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...
	Reply Quote

Reply Topic

New Topic

Page:
1

SEBLOD

SEBLOD 2.x

Search Types / Lists

Moderators: unleash.it, junite, dan1dyoung, SimonDowdles, nithinp89, seblod_ru

Time to create page: 0.16 seconds