Thank you for this useful extension.

Just one detail the queries are not compatible with MySql setting sql_mode=only_full_group_by.

The simplest fix seems to be:

In file \src\plugin\searchblogplugin.php:

Change line 207 from : $query->groupBy('a.title', 'a.content', 'a.excerpt');
to : $query->groupBy('a.title', 'a.content', 'a.excerpt','a.id');
Change Line 311 from: $query->groupBy('post_id','content');
to: $query->groupBy('post_id','content','pk_blog_comment.id');

In file \src\plugin\searchpageplugin.php:
Change Line 209 from: $query->groupBy('a.title, a.content');
to: $query->groupBy('a.title, a.content,a.id,c.id');

Add sitelinks search json-ld on head of pagekit

I am getting the following error:

Fatal error: Call to undefined function Friendlyit\Search\Plugin\mysql_escape_string() in ...packages\friendlyit\search\src\Plugin\SearchPagePlugin.php on line 111

The error seems to be related to the allegedly depreciated mysql_escape_string(). Not that great with PHP so not entirely sure how to fix it myself. Waiting on your update.

System Information

PHP Version 5.6.15
Apache/2.4.17 (Win32) OpenSSL/1.0.2d PHP/5.6.15

The time is wrong in the search statistics, how to modify it, maybe it is the problem of my time zone and your time zone.

I see that you have some languages configured, mine among them, but I don't see any option to change language in the widget options. How can I do that?

No settings choices will hide or change the title on the search/results page. Overriding the view by commenting out <?= ($params['title'])?> at line 5 in a theme's copy of placeholder.php - and then replacing it with a suitable text string was a quick but dirty solution.

Pagekit - v.1.0.13
Web Server - LiteSpeed
PHP - 5.6.32
DB - sqlite v.3.8.5
search ext. - v.0.1.6

Hey neicv,

I have a OS X, with El Captain. I'm getting an error of array to string conversion... am I doing something wrong?

Thx

Hi, thanks for your extension.
How can I overwrite your search results view into my template?

Thanks in advance

When running a search we get this error:

Whoops, looks like something went wrong.

1/1
ContextErrorException in SiteController.php line 155:
Runtime Notice: Only variables should be passed by reference
in SiteController.php line 155
at ErrorHandler->handleError('2048', 'Only variables should be passed by reference', '/var/www/graphene.staging.iit.it/app/public/packages/friendlyit/search/src/Controller/SiteController.php', '155', array('squery' => array('searchphrase' => 'all', 'searchword' => 'help'), 'error' => null, 'rows' => null, 'results' => null, 'ordering' => null, 'total' => '0', 'params' => array('limit_search_result' => '50', 'result_per_page' => '10', 'data_creation' => true, 'use_areas_search' => true, 'markdown_enabled' => true, 'show_pages_counter' => true, 'show_posted_in' => true, 'title' => 'Search Title', 'show_title' => true), 'searchphrase' => 'all', 'areas' => null, 'searchword' => 'help')) in SiteController.php line 155
at SiteController->indexAction()
at call_user_func_array(array(object(SiteController), 'indexAction'), array()) in ControllerListener.php line 60
at ControllerListener->executeController(object(ControllerEvent), object(Request))
at call_user_func_array(array(object(ControllerListener), 'executeController'), array(object(ControllerEvent), object(Request))) in EventDispatcher.php line 123
at EventDispatcher->trigger(object(ControllerEvent), array(object(Request))) in HttpKernel.php line 148
at HttpKernel->handleController() in HttpKernel.php line 77
at HttpKernel->handle(object(Request)) in Application.php line 67
at Application->run() in app.php line 24
at require_once('/var/www/graphene.staging.iit.it/app/public/app/system/app.php') in index.php line 40

FatalThrowableError in EXSearchHelper.php line 517:
Fatal error: Call to undefined function Friendlyit\Search\Helpers\ereg_replace()
in EXSearchHelper.php line 517
at EXSearchHelper::strip_data('welcome') in SearchPagePlugin.php line 108
at SearchPagePlugin->onContentSearch(object(SearchEvent))
at call_user_func_array(array(object(SearchPagePlugin), 'onContentSearch'), array(object(SearchEvent))) in EventDispatcher.php line 123
at EventDispatcher->trigger(object(SearchEvent), array(object(SearchEvent))) in EventTrait.php line 57
at Application::trigger(object(SearchEvent)) in SiteController.php line 709
at SiteController->getData() in SiteController.php line 308
at SiteController->indexAction()
at call_user_func_array(array(object(SiteController), 'indexAction'), array()) in ControllerListener.php line 60
at ControllerListener->executeController(object(ControllerEvent), object(Request))
at call_user_func_array(array(object(ControllerListener), 'executeController'), array(object(ControllerEvent), object(Request))) in EventDispatcher.php line 123
at EventDispatcher->trigger(object(ControllerEvent), array(object(ControllerEvent), object(Request))) in HttpKernel.php line 148
at HttpKernel->handleController() in HttpKernel.php line 77
at HttpKernel->handle(object(Request)) in Application.php line 67
at Application->run() in app.php line 24
at require_once('/srv/users/serverpilot/apps/aiims-usa2/public/app/system/app.php') in index.php line 40

Hi! Thanks for your plugin! I think it will be so cool if there is an search API for other plugins.

Is it possible to align the text in the search box from right to left aligned in any way or is it a bug I've found? HTML class does not work for me. I've tried something like uk-search-field text-align="left" etc. I've also tried to edit the CSS file to extend the search input-field but even this way doens't work for me.

What am I doing wrong? Is it maybe a problem of the Avion theme?

The url of the Search Results Dropdown (in widget) generate a bad link, the site folder is repeated

Admin settings allows for a user selected html/css class, but it won't show in the rendered page when a new class is added there and saved.

Overriding the view with the theme's copies of widget-search.php - it can be customized to add something manually, but it seems there's no code already there to insert the added class name. I haven't needed to try doing the same with placeholder.php, but I don't see any code intended to add a class name there either.

Am I missing something somewhere that needs another setting value toggled, or am I looking in the wrong place?

On a fresh install of pagekit I am getting:

An exception occurred while executing 'SELECT * FROM pk_docs_system_page a INNER JOIN pk_docs_system_node c ON (c.type LIKE ? AND c.data LIKE CONCAT ('%"defaults":{"id":', cast(a.id as char),'%')) WHERE ((c.status = ?) AND ((a.title LIKE ? OR a.content LIKE ?))) AND ((roles IS NULL) OR (roles REGEXP '(^|,)(2|3)($|,)')) GROUP BY a.title, a.content ORDER BY a.id DESC LIMIT 50 OFFSET 0' with params ["%page%", "1", "%css%", "%css%"]:

SQLSTATE[HY000]: General error: 1 no such function: CONCAT

When trying to search, the above search term was css.

Many thanks