Error messages when creating a new event

For some reason it looks as though the auto-increment primary ID for one of your tables is incorrect.

In PhpMyAdmin can you check the following database query

SELECT AUTO_INCREMENT , (SELECT MAX(ev_id) FROM j33jq.onjqe_jevents_vevent) FROM  INFORMATION_SCHEMA.TABLES

WHERE TABLE_SCHEMA = 'j33jq'

AND TABLE_NAME = 'onjqe_jevents_vevent'

SELECT AUTO_INCREMENT , (SELECT MAX(rp_id) FROM j33jq.onjqe_jevents_repetition) FROM  INFORMATION_SCHEMA.TABLES

WHERE TABLE_SCHEMA = 'j33jq'

AND TABLE_NAME = 'onjqe_jevents_repetition'

SELECT AUTO_INCREMENT , (SELECT MAX(rr_id) FROM j33jq.onjqe_jevents_rrule) FROM  INFORMATION_SCHEMA.TABLES

WHERE TABLE_SCHEMA = 'j33jq'

AND TABLE_NAME = 'onjqe_jevents_rrule'

SELECT AUTO_INCREMENT , (SELECT MAX(evdet_id) FROM j33jq.onjqe_jevents_vevdetail) FROM  INFORMATION_SCHEMA.TABLES

WHERE TABLE_SCHEMA = 'j33jq'

AND TABLE_NAME = 'onjqe_jevents_vevdetail'

replace j33jq with your database name and onjqe_ with your joomla table prefix.

In each case the auto_increment value should be higher or equal to the max id field value.

These are the queries and the results:


Query:
SELECT AUTO_INCREMENT , (SELECT MAX(ev_id) FROM 129_joomla.j25_jevents_vevent) FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = '129_joomla'
AND TABLE_NAME = 'j25_jevents_vevent'

Result:
AUTO_INCREMENT (SELECT MAX(ev_id) FROM 129_joomla.j25_jevents_vevent)
252 251


Query:
SELECT AUTO_INCREMENT , (SELECT MAX(rp_id) FROM 129_joomla.j25_jevents_repetition) FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = '129_joomla'
AND TABLE_NAME = 'j25_jevents_repetition'

Result:
AUTO_INCREMENT (SELECT MAX(rp_id) FROM 129_joomla.j25_jevents_repetition)
435 434


Query:
SELECT AUTO_INCREMENT , (SELECT MAX(rr_id) FROM 129_joomla.j25_jevents_rrule) FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = '129_joomla'
AND TABLE_NAME = 'j25_jevents_rrule'

Result:
AUTO_INCREMENT (SELECT MAX(rr_id) FROM 129_joomla.j25_jevents_rrule)
252 251


Query:
SELECT AUTO_INCREMENT , (SELECT MAX(evdet_id) FROM 129_joomla.j25_jevents_vevdetail) FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = '129_joomla'
AND TABLE_NAME = 'j25_jevents_vevdetail'

Result
AUTO_INCREMENT (SELECT MAX(evdet_id) FROM 129_joomla.j25_jevents_vevdetail)
253 252

these all look ok,

Try enabling Joomla debug mode which will give you more detail about the error and try creating/editing the event again

Hi together,

in my case is the table #__jevents_repetition not equal i have value on

SELECT AUTO_INCREMENT , (SELECT MAX(rp_id) FROM ###.###_jevents_repetition) FROM  INFORMATION_SCHEMA.TABLES

WHERE TABLE_SCHEMA = '###'

AND TABLE_NAME = '###_jevents_repetition'

201 228

can anybody help me to fix the auto_increment value

See https://www.mysqltutorial.org/mysql-reset-auto-increment and

ALTER TABLE table_name AUTO_INCREMENT = value;

Set the auto_increment value to 229 in your case

i have set the next correct auto_increment value in the operations tab in phpmyadmin for this specific table

I hope that resolved your issue?