[SOLVED] Error: Incorrect DATE value: '23:45: 30'

An error message appears again.

n your MySQL database, the table cpi7c_jem_config is missing because it was deleted. The intended action was to empty (truncate) the table, not to delete it.

Now, you must create first this table to fix this, in your myphpadmin, go the sql tab, and run this code:

CREATE TABLE `cpi7c_jem_config` (
`keyname` varchar(100) NOT NULL,
`value` text DEFAULT NULL,
`access` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'rfu'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

After that, run the INSERT to populate the default settings:

INSERT INTO `cpi7c_jem_config` (`keyname`, `value`, `access`) VALUES
('oldevent', '2', 0),
('minus', '1', 0),
('showtime', '1', 0),
('showtitle', '1', 0),
('showlocate', '1', 0),
('showcity', '1', 0),
('tablewidth', '', 0),
('datewidth', '20%', 0),
...

Copy this complete INSERT statement from the SQL file inside the zip file.

@aray I see that JEM is working on your site again!
Is it all right?

No, that problem is not solved yet - I had not deleted in the SQL database but inserted your code and thus came the second error message.

I would like to ask my provider tomorrow if he can fix the problem with your information. I don't know what else to do.

Check the Joomla table prefix, must be other, review please the name of table.

I understand that the initial error occurred: Incorrect DATE value.
Does this error appear in the frontend, the backend, or both?

You can also include the /administrator/components/com_jem/models/forms/event.xml file in your reply.
That space in the time format is the issue.

The error with the time specification is now fixed by the new SQL table entry.

Thank you for your support