Deprecated: Joomla\Input\Input implements the Serializable interface, which is deprecated. Implement __serialize() and __unserialize() instead (or in addition, if support for old PHP versions is necessary) in /homepages/13/d380392445/htdocs/Jlive/libraries/vendor/joomla/input/src/Input.php on line 41

Deprecated: Return type of Joomla\Input\Input::count() should either be compatible with Countable::count(): int, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /homepages/13/d380392445/htdocs/Jlive/libraries/vendor/joomla/input/src/Input.php on line 170
Error when enabling Search-Rialto - Macrotone Forum

Unknown Error 8192: KunenaControllerApplicationDisplay implements the Serializable interface, which is deprecated. Implement __serialize() and __unserialize() instead (or in addition, if support for old PHP versions is necessary) in libraries/kunena/controller/application/display.php on line 21


Unknown Error 8192: Automatic conversion of false to array is deprecated in libraries/kunena/route/route.php on line 437


Unknown Error 8192: ComponentKunenaControllerWidgetAnnouncementDisplay implements the Serializable interface, which is deprecated. Implement __serialize() and __unserialize() instead (or in addition, if support for old PHP versions is necessary) in components/com_kunena/controller/widget/announcement/display.php on line 18


Unknown Error 8192: ComponentKunenaControllerTopicItemDisplay implements the Serializable interface, which is deprecated. Implement __serialize() and __unserialize() instead (or in addition, if support for old PHP versions is necessary) in components/com_kunena/controller/topic/item/display.php on line 25


Unknown Error 8192: Automatic conversion of false to array is deprecated in libraries/kunena/forum/category/category.php on line 415


Deprecated: DateTime::__construct(): Passing null to parameter #1 ($datetime) of type string is deprecated in /homepages/13/d380392445/htdocs/Jlive/libraries/src/Date/Date.php on line 112

Unknown Error 8192: Automatic conversion of false to array is deprecated in libraries/kunena/bbcode/bbcode.php on line 107

Error when enabling Search-Rialto


Unknown Error 8192: ComponentKunenaControllerTopicItemActionsDisplay implements the Serializable interface, which is deprecated. Implement __serialize() and __unserialize() instead (or in addition, if support for old PHP versions is necessary) in components/com_kunena/controller/topic/item/actions/display.php on line 23


Unknown Error 8192: ComponentKunenaControllerTopicPollDisplay implements the Serializable interface, which is deprecated. Implement __serialize() and __unserialize() instead (or in addition, if support for old PHP versions is necessary) in components/com_kunena/controller/topic/poll/display.php on line 21


Unknown Error 8192: ComponentKunenaControllerTopicItemMessageDisplay implements the Serializable interface, which is deprecated. Implement __serialize() and __unserialize() instead (or in addition, if support for old PHP versions is necessary) in components/com_kunena/controller/topic/item/message/display.php on line 23

9 years 10 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

Unknown Error 8192: ComponentKunenaControllerMessageItemActionsDisplay implements the Serializable interface, which is deprecated. Implement __serialize() and __unserialize() instead (or in addition, if support for old PHP versions is necessary) in components/com_kunena/controller/message/item/actions/display.php on line 25

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


Unknown Error 8192: strlen(): Passing null to parameter #1 ($string) of type string is deprecated in libraries/kunena/external/nbbc/src/BBCode.php on line 2115


Unknown Error 8192: strlen(): Passing null to parameter #1 ($string) of type string is deprecated in libraries/kunena/external/nbbc/src/BBCode.php on line 2115


Unknown Error 8192: strlen(): Passing null to parameter #1 ($string) of type string is deprecated in libraries/kunena/external/nbbc/src/BBCode.php on line 2022


Unknown Error 8192: strlen(): Passing null to parameter #1 ($string) of type string is deprecated in libraries/kunena/external/nbbc/src/BBCode.php on line 2070


Unknown Error 8192: strlen(): Passing null to parameter #1 ($string) of type string is deprecated in libraries/kunena/external/nbbc/src/BBCode.php on line 2115


Unknown Error 8192: strlen(): Passing null to parameter #1 ($string) of type string is deprecated in libraries/kunena/external/nbbc/src/BBCode.php on line 2022


Unknown Error 8192: strlen(): Passing null to parameter #1 ($string) of type string is deprecated in libraries/kunena/external/nbbc/src/BBCode.php on line 2022


Unknown Error 8192: strlen(): Passing null to parameter #1 ($string) of type string is deprecated in libraries/kunena/external/nbbc/src/BBCode.php on line 2115


Unknown Error 8192: strlen(): Passing null to parameter #1 ($string) of type string is deprecated in libraries/kunena/external/nbbc/src/BBCode.php on line 2115


Unknown Error 8192: strlen(): Passing null to parameter #1 ($string) of type string is deprecated in libraries/kunena/external/nbbc/src/BBCode.php on line 2022


Unknown Error 8192: strlen(): Passing null to parameter #1 ($string) of type string is deprecated in libraries/kunena/external/nbbc/src/BBCode.php on line 2070


Unknown Error 8192: strlen(): Passing null to parameter #1 ($string) of type string is deprecated in libraries/kunena/external/nbbc/src/BBCode.php on line 2115


Unknown Error 8192: strlen(): Passing null to parameter #1 ($string) of type string is deprecated in libraries/kunena/external/nbbc/src/BBCode.php on line 2115


Unknown Error 8192: strlen(): Passing null to parameter #1 ($string) of type string is deprecated in libraries/kunena/external/nbbc/src/BBCode.php on line 2022


Unknown Error 8192: strlen(): Passing null to parameter #1 ($string) of type string is deprecated in libraries/kunena/external/nbbc/src/BBCode.php on line 2070

9 years 10 months ago - 9 years 10 months ago #2 by chrisc

Unknown Error 8192: preg_match(): Passing null to parameter #2 ($subject) of type string is deprecated in libraries/kunena/external/nbbc/src/BBCode.php on line 2263


Unknown Error 8192: preg_match(): Passing null to parameter #2 ($subject) of type string is deprecated in libraries/kunena/external/nbbc/src/BBCode.php on line 2263


Unknown Error 8192: preg_match(): Passing null to parameter #2 ($subject) of type string is deprecated in libraries/kunena/external/nbbc/src/BBCode.php on line 2263


Unknown Error 8192: preg_match(): Passing null to parameter #2 ($subject) of type string is deprecated in libraries/kunena/external/nbbc/src/BBCode.php on line 2263


Unknown Error 8192: preg_match(): Passing null to parameter #2 ($subject) of type string is deprecated in libraries/kunena/external/nbbc/src/BBCode.php on line 2263


Unknown Error 8192: preg_match(): Passing null to parameter #2 ($subject) of type string is deprecated in libraries/kunena/external/nbbc/src/BBCode.php on line 2263


Unknown Error 8192: preg_match(): Passing null to parameter #2 ($subject) of type string is deprecated in libraries/kunena/external/nbbc/src/BBCode.php on line 2263


Unknown Error 8192: preg_match(): Passing null to parameter #2 ($subject) of type string is deprecated in libraries/kunena/external/nbbc/src/BBCode.php on line 2263


Unknown Error 8192: preg_match(): Passing null to parameter #2 ($subject) of type string is deprecated in libraries/kunena/external/nbbc/src/BBCode.php on line 2263


Unknown Error 8192: preg_match(): Passing null to parameter #2 ($subject) of type string is deprecated in libraries/kunena/external/nbbc/src/BBCode.php on line 2263

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.

9 years 10 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.

9 years 10 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.148 seconds
Go To Top

Joomla! Debug Console

Session

Profile Information

Memory Usage

Database Queries