1054 Unknown column 'characteristic_values_on_listing' in 'where clause'

  • Posts: 1028
  • Thank you received: 11
  • Hikashop Business
7 months 3 weeks ago #355322

-- HikaShop version -- : 4.4.0
-- Joomla version -- : 3.10.12

Hello!

I tried to install the latest version and i get this error!

Thank you

Attachments:

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

  • Posts: 81677
  • Thank you received: 13102
  • MODERATOR
7 months 3 weeks ago #355330

Hi,

On which pages do you get these errors ?
And could you try again after activating the debug setting of the Joomla configuration in order to get the full error message ?

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

  • Posts: 1028
  • Thank you received: 11
  • Hikashop Business
7 months 3 weeks ago #355335 

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 /home/karadimo/public_html/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 /home/karadimo/public_html/libraries/vendor/joomla/input/src/Input.php on line 170

Deprecated: Joomla\CMS\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 /home/karadimo/public_html/libraries/src/Input/Input.php on line 31

Deprecated: Joomla\CMS\Input\Cookie implements the Serializable interface, which is deprecated. Implement __serialize() and __unserialize() instead (or in addition, if support for old PHP versions is necessary) in /home/karadimo/public_html/libraries/src/Input/Cookie.php on line 21

Deprecated: str_replace(): Passing null to parameter #3 ($subject) of type array|string is deprecated in /home/karadimo/public_html/libraries/src/Uri/Uri.php on line 141

Deprecated: Optional parameter $labelValue declared before required parameter $container is implicitly treated as a required parameter in /home/karadimo/public_html/components/com_fabrik/models/element.php on line 3650

Deprecated: Optional parameter $normal declared before required parameter $container is implicitly treated as a required parameter in /home/karadimo/public_html/components/com_fabrik/models/element.php on line 3650

Deprecated: trim(): Passing null to parameter #1 ($string) of type string is deprecated in /home/karadimo/public_html/plugins/system/cachecleaner/src/Cache.php on line 203

Deprecated: Return type of Joomla\Event\AbstractEvent::offsetExists($name) should either be compatible with ArrayAccess::offsetExists(mixed $offset): bool, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /home/karadimo/public_html/libraries/vendor/joomla/event/src/AbstractEvent.php on line 181

Deprecated: Return type of Joomla\Event\AbstractEvent::offsetGet($name) should either be compatible with ArrayAccess::offsetGet(mixed $offset): mixed, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /home/karadimo/public_html/libraries/vendor/joomla/event/src/AbstractEvent.php on line 195

Deprecated: Return type of Joomla\Event\AbstractEvent::count() should either be compatible with Countable::count(): int, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /home/karadimo/public_html/libraries/vendor/joomla/event/src/AbstractEvent.php on line 141

Deprecated: Return type of Joomla\Event\Event::offsetSet($name, $value) should either be compatible with ArrayAccess::offsetSet(mixed $offset, mixed $value): void, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /home/karadimo/public_html/libraries/vendor/joomla/event/src/Event.php on line 119

Deprecated: Return type of Joomla\Event\Event::offsetUnset($name) should either be compatible with ArrayAccess::offsetUnset(mixed $offset): void, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /home/karadimo/public_html/libraries/vendor/joomla/event/src/Event.php on line 138

Deprecated: Joomla\Event\Event implements the Serializable interface, which is deprecated. Implement __serialize() and __unserialize() instead (or in addition, if support for old PHP versions is necessary) in /home/karadimo/public_html/libraries/vendor/joomla/event/src/Event.php on line 18

It shows this with error reporting and now i cannot access the administrator at all.

Thank you

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

  • Posts: 81677
  • Thank you received: 13102
  • MODERATOR
7 months 3 weeks ago #355338

Hi,

These are just deprecated messages, not errors.
These indicates that your version of PHP is too recent for your version of Joomla.
They don't give information on the initial issues you reported in your first message.
If you can't access your website because of these deprecated messages, edit your configuration.php file via FTP or your file manager and search for "error_reporting" change its value to 'none' and it should then work again.

The following user(s) said Thank You: verzevoul

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

  • Posts: 1028
  • Thank you received: 11
  • Hikashop Business
7 months 3 weeks ago #355341

Hi,

Yes i fixed the administrator issue now i have backend access again.
But Hikashop pages still don't work. I cannot access anything besides the configuration of Hikashop.
I could send you credentials to check it out if you could.

Thank you

Attachments:

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

  • Posts: 81677
  • Thank you received: 13102
  • MODERATOR
7 months 3 weeks ago #355342

Hi,

A backend access won't help. I need the full error message.
Open two tabs on your browser:
- one with the page with the error
- one with the Joomla configuration page
Then, activate the "debug" setting in the Joomla configuration page, and on the page with the error, refresh it.
Note that it's the "debug" setting you need to activate, not the "error reporting" one.
That way, you'll get the full error message.
Then, you can turn off the debug by editing the Joomla configuration.php file.

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

  • Posts: 1028
  • Thank you received: 11
  • Hikashop Business
7 months 3 weeks ago #355354

Hi,

Okay here is the debug result.

Thank you!

Attachments:

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

  • Posts: 81677
  • Thank you received: 13102
  • MODERATOR
7 months 3 weeks ago #355360

Hi,

This indicates that you're missing the column characteristic_values_on_listing in the table hikashop_characteristic
That column is normally added automatically by the installer during the update process from a version of HikaShop before the 4.5.2 to the 4.5.2 or newer.
Click on the "check database" button of the HikaShop configuration page, and it should fix that automatically.

The following user(s) said Thank You: verzevoul

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

Time to create page: 0.077 seconds
Powered by Kunena Forum