J-BusinessDirectory - PdoDriver.php Line: 498 Illegal argument to a regular expression

Support Forum

 
 

 

Hi!

I got a lot of reports now updated and wonder if anyone have tips how to solve this annoying issue though I got a lot of emails as soon people browsing visting the listings in the site..

see blow report.  Any tips appreciated..

-------------- report ----------------------------------

A PHP Exception occurred on your site. Here you can find the stack trace:

Exception Type: Joomla\Database\Exception\ExecutionFailureException
File: /var/www//libraries/vendor/joomla/database/src/Pdo/PdoDriver.php
Line: 498
Message: HY, 3685, Illegal argument to a regular expression.

#0 /var/www//libraries/vendor/joomla/database/src/DatabaseDriver.php(1375): Joomla\Database\Pdo\PdoDriver->execute()
#1 /var/www//administrator/components/com_jbusinessdirectory/tables/offer.php(754): Joomla\Database\DatabaseDriver->loadObjectList()
#2 /var/www//components/com_jbusinessdirectory/models/offers.php(447): JTableOffer->getOffersByCategories()
#3 /var/www//libraries/src/MVC/View/AbstractView.php(146): JBusinessDirectoryModelOffers->getItems()
#4 /var/www//components/com_jbusinessdirectory/views/offers/view.html.php(40): Joomla\CMS\MVC\View\AbstractView->get()
#5 /var/www//libraries/src/MVC/Controller/BaseController.php(639): JBusinessDirectoryViewOffers->display()
#6 /var/www//components/com_jbusinessdirectory/controller.php(23): Joomla\CMS\MVC\Controller\BaseController->display()
#7 /var/www//libraries/src/MVC/Controller/BaseController.php(672): JBusinessDirectoryController->display()
#8 /var/www//components/com_jbusinessdirectory/jbusinessdirectory.php(86): Joomla\CMS\MVC\Controller\BaseController->execute()
#9 /var/www//libraries/src/Dispatcher/LegacyComponentDispatcher.php(71): require_once('...')
#10 /var/www//libraries/src/Dispatcher/LegacyComponentDispatcher.php(73): Joomla\CMS\Dispatcher\LegacyComponentDispatcher::Joomla\CMS\Dispatcher\{closure}()
#11 /var/www//libraries/src/Component/ComponentHelper.php(355): Joomla\CMS\Dispatcher\LegacyComponentDispatcher->dispatch()
#12 /var/www//libraries/src/Application/SiteApplication.php(200): Joomla\CMS\Component\ComponentHelper::renderComponent()
#13 /var/www//libraries/src/Application/SiteApplication.php(241): Joomla\CMS\Application\SiteApplication->dispatch()
#14 /var/www//libraries/src/Application/CMSApplication.php(294): Joomla\CMS\Application\SiteApplication->doExecute()
#15 /var/www//includes/app.php(61): Joomla\CMS\Application\CMSApplication->execute()
#16 /var/www//index.php(32): require_once('...')
#17 {main}

Request information
GET variables

Array
(
)

POST variables

Array
(
)

COOKIE variables

Array
(
)

REQUEST variables

Array
(
)

SERVER variables

Array
(
[REDIRECT_JCH_GZIP_ENABLED] => yes
[REDIRECT_JCH_GZIP] => .gz
[REDIRECT_JCH_SCHEME] => https
[REDIRECT_HTTP_AUTHORIZATION] =>
[REDIRECT_HTTPS] => on
[REDIRECT_SSL_TLS_SNI] =>
[REDIRECT_STATUS] => 200
[JCH_GZIP_ENABLED] => yes
[JCH_GZIP] => .gz
[JCH_SCHEME] => https
[HTTPS] => on
[SSL_TLS_SNI] =>
[HTTP_ACCEPT] => text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
[HTTP_ACCEPT_ENCODING] => gzip,identity
[HTTP_HOST] =>
[HTTP_USER_AGENT] => Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_5) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.1.1 Safari/605.1.15 (Applebot/0.1; +http://www.apple.com/go/applebot)
[PATH] => /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
[SERVER_SIGNATURE] =>
[SERVER_SOFTWARE] => Apache/2.4.52 (Ubuntu)
[SERVER_NAME] =>
[SERVER_ADDR] =>
[SERVER_PORT] => 443
[REMOTE_ADDR] =>
[DOCUMENT_ROOT] => /var/www/
[REQUEST_SCHEME] => https
[CONTEXT_PREFIX] =>
[CONTEXT_DOCUMENT_ROOT] => /var/www/
[SERVER_ADMIN] => webmaster@
[SCRIPT_FILENAME] => /var/www//index.php
[REMOTE_PORT] =>
[REDIRECT_URL] =>
[GATEWAY_INTERFACE] => CGI/1.1
[SERVER_PROTOCOL] => HTTP/1.1
[REQUEST_METHOD] => GET
[QUERY_STRING] =>
[REQUEST_URI] =>
[SCRIPT_NAME] => /index.php
[PHP_SELF] => /index.php
[REQUEST_TIME_FLOAT] => 1670225375.6221
[REQUEST_TIME] => 1670225375
)

2 replies

I have the same errors. 

Also, I think the update broke the Faceted Search option again. I was getting SQL errors on category pages again.

Tested new version?

 
 
 

3 Item(s)

Show per page