Warenkorbproblem seit letztem Update: 1525 Incorrect DATETIME value: ''

  • Posts: 17
  • Thank you received: 1
2 years 8 months ago #334994

-- url of the page with the problem -- : www.screenix.eu/
-- HikaShop version -- : HikaShop Business: 4.4.3
-- Joomla version -- : 3.9.28
-- PHP version -- : 7.4.3
-- Error-message(debug-mod must be tuned on) -- : 1525 Incorrect DATETIME value: ''

Hallo,
Seit dem neuesten Update funktioniert unser Warenkorb nicht mehr. Sowohl im Backend als auch im Frontend erscheint sobald man auf den Warenkorb klickt folgende Fehlermeldung: 1525 Incorrect DATETIME value: ''

Im Backend kann ich in alle anderen Bereiche wie Bestellungen, Kunden, Produkte .... Problemlos öffnen, ändern und speichern. Nur sobald ich auf den Warenkorb gehe kommt diese Fehlermeldung.
Im Frontend ebenfalls das gleiche.

Hat jemand eine Idee woran das liegen kann?

Attachments:

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

  • Posts: 81539
  • Thank you received: 13069
  • MODERATOR
2 years 8 months ago #334996

Hi,

DATETIME is a format of column in MySQL:
dev.mysql.com/doc/refman/8.0/en/datetime.html
So this error likely comes from a wrong MySQL query or something that has been wrongly changed in the database.
HikaShop doesn't use the DATETIME format. Neither in its tables nor in its MySQL queries.
All the dates in the database are stored by HikaShop using the TIMESTAMP format instead.

What this all means is that the error likely doesn't come from something in HikaShop but by something else which integrates with HikaShop, like a custom plugin or a third party plugin.

Please activate the "error reporting" and "debug system" options of the Joomla configuration and generate the error again. You should get an error message with more information, like the line number and the file path where the error happens and a callstack debug. This will help us understand what's going on.

The following user(s) said Thank You: romana

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

  • Posts: 17
  • Thank you received: 1
2 years 8 months ago #335002

Hi,
i turned on debug mode and error reporting - see attechment.

Attachments:

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

  • Posts: 17
  • Thank you received: 1
2 years 8 months ago #335005

Hi,
I deactivet step by step the third party plugins and found the problem. The error was caused by an old plugin - it wasn't in use but activated, i deactivated an uninstalled it, and now it seems that evereything works fine.

Thanks for your Help!

Romana

The following user(s) said Thank You: nicolas

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

Time to create page: 0.060 seconds
Powered by Kunena Forum