Support

Hi, can you make any suggestions about what might be wrong in this hosting environment which is Crazy Domains, because when I click on the Migrate button after manually updating to Akeeba 8.1.0Pro I receive a 1064 Application error...

RuntimeException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 3 SQL=UPDATE `kqdoq_ak_stats` SET `filesexist` = 0 WHERE `id` IN ()

(see attached image).

Current MariaDB version is 10.5.22-MariaDB (see attachment).

I've done this process on about 50 other client sites on my own VPS's and not had any issues, so it must be this client's hosting environment.

I've also attached the current PHP extensions enabled, are there any missing which you need enabled, or any other clues why this error is being thrown?

Thanks

Nicola

Thanks Nicholas.

I updated to 8.1.1 via the Akeeba dashboard, and then the Migration button still appeared, so I clicked the Migration button again and the migration then completed successfully, without the application error appearing. 

This is probably what you meant, but I thought I'd explain my process incase anyone else has the same issue, they can read what worked for me, rather than creating another support ticket.

Regards

Nicola