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

Hi McKillo,

even with this problem, I do not know where the place in the database is (see screenshots) to exchange the table entry with your transmitted file. Can you describe the passage to me exactly? The bracket in the file name, which was created after unpacking, I have to delete, right?

In your phpMyAdmin, scroll down to locate the cpj7c_jem_config table, then click 'Leeren' (Empty). Next, open the SQL tab, paste the content from the SQL file I shared earlier, and execute it (the name table must be the same, cpj7c_jem_config). This will populate the table with the default configuration values.

I get an error message after inserting the entry?

You have deleted the cpi7c_jem_config table, but the intended action was to empty it, not delete it.

To fix this, recreate the table using:

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 the INSERT from the sql file.

That didn't work either?

Delete the first line "SELECT...."