- Posts: 3
- Thank you received: 0
Mysql and Incorrect datetime value errors when trying to edit a category
- Karen
- Topic Author
- Offline
- New Member
We are currently experiencing errors with freshly installed edocman.
The error happens when we are trying to edit existing categories.
When we click on the category save button we get this error message. Please see the first-cat-error.png attachment
."Save failed with the following 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 'groups FROM llp_edocman_levels WHERE data_type = 0 and item_id = 1' at line 1"
After, when clicking the Save button the second time we get different error. Please see the second-cat-error.png attachment.
"Save failed with the following error: Incorrect datetime value: '' for column 'created_time' at row 1"
Any ideas why is this happening?
Here is the setup
PHP Built On Windows NT LGB01-LLP-P01 10.0 build 20348 (Windows Server 2022) AMD64
Database Type mysql
Database Version 8.0.32
Database Collation utf8mb4_unicode_ci
Database Connection Collation utf8mb4_0900_ai_ci
Database Connection Encryption TLSv1.3 (TLS_AES_256_GCM_SHA384)
Database Server Supports Connection Encryption Yes
PHP Version 8.2.2
Web Server Microsoft-IIS/10.0
WebServer to PHP Interface cgi-fcgi
Joomla! Version Joomla! 4.2.7 Stable [ Uaminifu ] 31-January-2023 15:00 GMT
User Agent Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36 Edg/109.0.1518.78
Kind regards
Karen
Please Log in or Create an account to join the conversation.
- Mr. Dam
- Offline
- Administrator
- Posts: 12818
- Thank you received: 1659
Please submit ticket on category: Edocman and provide your site url with super admin account. I will check the issue for you
Thanks
Dam
Please Log in or Create an account to join the conversation.
Support
Documentation
Information
The Joomla! name and logo is used under a limited license granted by Open Source Matters the trademark holder in the United States and other countries.