Tags no working

  • Posts: 50
  • Thank you received: 1
1 week 2 days ago #372055

-- url of the page with the problem -- : www.paradepot.ch/e-shop/xc-tracer-maxx-3
-- Error-message(debug-mod must be tuned on) -- : 1054 Unknown column 'Array' in 'where clause'

If I click on a tag then get 1054 Unknown column 'Array' in 'where clause'

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

  • Posts: 85712
  • Thank you received: 14048
  • MODERATOR
1 week 2 days ago #372059

Hi,

Can you activate the debug system and error reporting settings of the Joomla configuration page and try again ? You should get more information about the error which will allow us to tell you what to do.

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

  • Posts: 50
  • Thank you received: 1
2 days 22 hours ago #372152

1054 Unknown column 'Array' in 'where clause'

Call Stack

# Function Location
1 () JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php:138
2 mysqli->prepare() JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php:138
3 Joomla\Database\Mysqli\MysqliStatement->__construct() JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:972
4 Joomla\Database\Mysqli\MysqliDriver->prepareStatement() JROOT/libraries/vendor/joomla/database/src/DatabaseDriver.php:1753
5 Joomla\Database\DatabaseDriver->setQuery() JROOT/libraries/src/Table/Table.php:831
6 Joomla\CMS\Table\Table->load() JROOT/administrator/components/com_nicepage/tables/sections.php:35
7 PagesTableSections->load() JROOT/administrator/components/com_nicepage/library/src/Plugins/SystemPlugin.php:203
8 NP\Plugins\SystemPlugin->onAfterRender() JROOT/libraries/vendor/joomla/event/src/Dispatcher.php:454
9 Joomla\Event\Dispatcher->dispatch() JROOT/libraries/vendor/joomla/application/src/AbstractApplication.php:99
10 Joomla\Application\AbstractApplication->dispatchEvent() JROOT/libraries/src/Application/CMSApplication.php:1142
11 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:585
12 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:325
13 Joomla\CMS\Application\CMSApplication->execute() JROOT/includes/app.php:58
14 require_once() JROOT/index.php:51

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

  • Posts: 85712
  • Thank you received: 14048
  • MODERATOR
2 days 19 hours ago #372155

Hi,

The error comes from the Nicepage component, not from HikaShop. Your stack trace shows it is thrown in com_nicepage/tables/sections.php (PagesTableSections->load) during the onAfterRender event.

Here is what happens. HikaShop displays the product tags using Joomla's own tag system and Joomla's standard tag layout, so each tag is a normal Joomla tag link (option=com_tags&view=tag&id[0]=...). On those tag pages Joomla passes the tag id as an array, which is its normal behaviour. The Nicepage system plugin reads that id expecting a single value and puts it directly into a database query, so the array becomes the text "Array" and you get "Unknown column 'Array' in the where clause".

You can confirm this in two ways:

1. Disable the Nicepage system plugin and click the tag again. It will work.
2. Click a tag anywhere outside HikaShop (for example on a normal Joomla article tag). You will get the same error, which shows it is not related to HikaShop.

The fix needs to be done on the Nicepage side (their plugin should handle the array id used by Joomla tag pages), so we would suggest reporting it to Nicepage, or keeping the Nicepage system plugin from running on the tag pages.

The following user(s) said Thank You: publiduty

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

Time to create page: 0.062 seconds
Powered by Kunena Forum