That is VERY strange the #__jevents_icsfile table has 2 keys/indexes defined during table creation a 12 digit integer and a 3 digit integer.

If you enable Joomla debug mode and try again - does it give you the full database query it was trying to call?

Note I am on J3.10.12 and PHP 8.0 should it have any bearing on the matter

I turned on DEBUG option in the Joomla Global Config section... is this what you meant?

The failure report is the same but I now have a Joomla Debug Console at the bottom of the screen, there is A LOT of detail here in 4 main expandable sections: SESSION, PROFILE INFO, MEMORY USAGE, DATABASE QUERIES

What do you want? If I expand DATABASE QUERIES it reports 72 Queries Logged... but first it reports in red/pink
7 duplicate found!
2 duplicates: #3 #71
2 duplicates: #4 #72
3 duplicates: #15 #67 #70
Then a lot of details...

What are you after?

Regards

I was hoping it would give a more detailed error message

If you go to the download page and expand the 'archived versions' at https://www.jevents.net/download-area/jevents/441-download-jevents you can download and install version 3.6.74 - are you able to install this? If you can then you should be able to run the upgrade from that

Thanks.

Unfortunately 3.6.74 did not install and failed with the following errors - slightly different in that the 'key too long' message seems to have gone.

Warning
Table 'peakep_liveshop1.jml_jevents_icsfile' doesn't exist
Package Install: There was an error installing an extension: com_jevents.zip

Error
Error installing package

Same details in the debig panel as far as I can see...

If I expand DATABASE QUERIES it reports 72 Queries Logged... but first it reports in red/pink
7 duplicate found!
2 duplicates: #3 #71
2 duplicates: #4 #72
3 duplicates: #15 #67 #70
Then a lot of details regarding the call stack I presume (72 of them. as before..)

Steve

Debug mod isn't giving us any extra information unfortunately so you may as well turn if off

Is this the first time you have installed JEvents on this server?

Are you using MySQL/MariaDB as your database?

Can you look at the database in phpMyAdmin (or similar) - can you see some of the JEvents tables? They will will start with jevents_ of jev_ ?

Hi

There are many database starting jml_ as that's the prefix I chose in the config setup, but there are none starting jevents_ or jev_ or any jml_jev etc.

No, I have never installed JEvents on this server before.

Copied these from the Database settings via PHPAdmin...

Server type: MySQL
Server version: 5.6.51-log - MySQL Community Server (GPL)
Protocol version: 10
User: steveday@77.68.64.37
Server charset: cp1252 West European (latin1)


Apache
Database client version: libmysql - mysqlnd 8.0.30
PHP extension: mysqli Documentation curl Documentation mbstring Documentation
PHP version: 8.0.30

Joomla Global Config reports:
Database Type: MySQLi

Thanks

Sorry if this is a stupid question but your database user does have permission to create tables??

Are you able to install other extensions?

#__jevents_icsfile isn't the first table to be created during installation so there should have been an other error or tables such as #__jevents_vevent should exist in your database

I've installed numerous extensions over the years since I built the site and installed some updates recently too.
Recently upgraded from J3.9.25 -> J3.10.12
I see no reason why my access permissions would have changed...?

I have just created a table aaa_test with 4 cols, seemed to be fine as far as I could see, dropped it fine too.

Is it possible for me to take a temporary copy of your site to run through a php debugger locally?