Error when enabling Search-Rialto

8 years 4 months ago #1 by Fisker
Hi Again at Macrotone.

Sorry I'm back, but I have an Issue when enabling the Plugin: Search-Rialto.

When doing a FrontEnd Searh I get the folowing error:

1054 - Unknown column 'e.text' in 'field list' SQL=SELECT e.id, e.headline AS title, e.text AS text, e.date_created AS created,c.name AS section, e.id AS entryid, e.alias AS entryalias, c.id AS categoryid, c.alias AS categoryalias, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug, CASE WHEN CHAR_LENGTH(e.alias) THEN CONCAT_WS(':', e.id, e.alias) ELSE e.id END as slug, '2' AS browsernav FROM XXXX_rialto_entries e, XXXX_rialto_categories c WHERE ((`headline` LIKE '%test%' OR `description` LIKE '%test%')) AND e.category_id = c.id AND e.published = 1 ORDER BY `created` DESC

I took a look in the Rialto_entries table, but can't find any field named text.

Hope You can give me an Advice

Thank You in Advance

Please Log in or Create an account to join the conversation.

8 years 4 months ago - 8 years 4 months ago #2 by chrisc
Yep it looks like a bug.

Since you are comfortable changing code (from previous posts).
In the file plugins/search/rialto/rialto.php

Change line 105/106 from:
$query = 'SELECT e.id, e.headline AS title, e.text AS text, e.date_created AS created,'
            . 'c.name AS section, '

To
$query = 'SELECT e.id, e.headline AS title, e.description AS text, e.date_created AS created,'
            . 'c.title AS section, '

Change line 116 from
. ' AND e.published = 1'

To
. ' AND e.state = 1'

Change line 68 (typo as well) from
$conditions = $db->quoteName('headline') . " LIKE $text" . " OR " . $db->quoteName('desscription') . " LIKE $text";

To
$conditions = $db->quoteName('headline') . " LIKE $text" . " OR " . $db->quoteName('e.description') . " LIKE $text";

Change line 78 from
$wordConditions[] = $db->quoteName('headline') . " LIKE $word"  . " OR " . $db->quoteName('description') . " LIKE $word";

To
$wordConditions[] = $db->quoteName('headline') . " LIKE $word"  . " OR " . $db->quoteName('e.description') . " LIKE $word";
Change line 123 from
$sqlitemid = "SELECT id FROM ".$db->quoteName( '#__menu')." WHERE link LIKE '%com_rialto%' AND parent = '0' AND published = '1'";
To
$sqlitemid = "SELECT id FROM ".$db->quoteName( '#__menu')." WHERE link LIKE '%com_rialto%' AND parent_id = '0' AND published = '1'";


That should be it. Obviously using search for Rialto entries is not very common, otherwise I think this would have shown before. I think I must have changed the column names after creating the search and somehow testing missed the changes. Will be part of the 1.2.0 release.

Regards

If you are using our extensions please leave a review at the JED: IP Mapping | Issue Tracker | JAudit | Password Control
The following user(s) said Thank You: Fisker

Please Log in or Create an account to join the conversation.

8 years 4 months ago #3 by Fisker
Yyahoo, thank You very much, Works like a charm.
The following user(s) said Thank You: chrisc

Please Log in or Create an account to join the conversation.

8 years 4 months ago #4 by chrisc
You are welcome. Thank you for reporting it.

Regards

If you are using our extensions please leave a review at the JED: IP Mapping | Issue Tracker | JAudit | Password Control

Please Log in or Create an account to join the conversation.

Time to create page: 0.189 seconds
Go To Top

Joomla! Debug Console

Session

Profile Information

Memory Usage

Database Queries