JCB 3.2.0-beta5 Help Documents search throws SQL error #1069

New Issue

Open

opened 2024-03-10 18:37:23 +00:00 by fdinkler · 0 comments

fdinkler commented

2024-03-10 18:37:23 +00:00

Member

Steps to reproduce the issue

Install pkg-component-builder-v3.2.0-beta5.zip
Click Help Documents icon (.../administrator/index.php?option=com_componentbuilder&view=help_documents)
Enter "global privacy plugin" in search box, click search
throws 500 SQL error
Back-click in browser throws same errors
Another back-click shows JCB Dashboard
Clicking again on Help Documents icon throws 500 error
Repeated in both Ubuntu and Windows installs

Expected result

Search results

Actual result

500 error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIKE '%global privacy plugin %' OR a.site_view LIKE '%global privacy plugin %' O' at line 3 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIKE '%global privacy plugin %' OR a.site_view LIKE '%global privacy plugin %' O' at line 3

System information (as much as possible)

OS Name & Version: Win11 Wamp Server 3.3.3 64-bit
MySql Version: 8.0.36
Apache Version: Apache 2.4.58
PHP Version: 8.1.26
Joomla Version: 3.10.28
JCB Version: 3.2.0-beta5
Browser: Firefox

Additional comments

Error repeated on alt platform

OS Name & Version: Ubuntu 22.04.4
MySql Version: 8.1.27
Apache Version: Apache 2.4.58
PHP Version: 8.1.27

### Steps to reproduce the issue Install pkg-component-builder-v3.2.0-beta5.zip Click Help Documents icon (.../administrator/index.php?option=com_componentbuilder&view=help_documents) Enter "global privacy plugin" in search box, click search throws 500 SQL error Back-click in browser throws same errors Another back-click shows JCB Dashboard Clicking again on Help Documents icon throws 500 error Repeated in both Ubuntu and Windows installs ### Expected result Search results ### Actual result 500 error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIKE '%global privacy plugin %' OR a.site_view LIKE '%global privacy plugin %' O' at line 3 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIKE '%global privacy plugin %' OR a.site_view LIKE '%global privacy plugin %' O' at line 3 ### System information (as much as possible) - OS Name & Version: Win11 Wamp Server 3.3.3 64-bit - MySql Version: 8.0.36 - Apache Version: Apache 2.4.58 - PHP Version: 8.1.26 - Joomla Version: 3.10.28 - JCB Version: 3.2.0-beta5 - Browser: Firefox ### Additional comments Error repeated on alt platform - OS Name & Version: Ubuntu 22.04.4 - MySql Version: 8.1.27 - Apache Version: Apache 2.4.58 - PHP Version: 8.1.27