All questions about EDocman extension

Mysql and Incorrect datetime value errors when trying to edit a category

More
1 year 10 months ago - 1 year 9 months ago #156391 by Karen
Hello Mr Dam,

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
  • Last edit: 1 year 9 months ago by Karen.

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

    More
    1 year 10 months ago #156413 by Mr. Dam
    Hi Karen,
    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.

    Moderators: Mr. Dam