I started to manual update my sites to Akeeba 8.1.0
On some sites I have an issue. The reason are, as far as I seen, old site entries in the ak_stats table. To explain, for my Wordpress developing sites, I use a Site template where Akeeba is already installed. It seems that websites I created years ago have Akeeba stats from the devolping site in the table and this makes problems.
When entering the Akeeba Backend after manuall copy the files to wp-content/plugins/akkebabackupwp an information appears (see attached screenshot).
When clicking on "More information and Migration" an error appears:
## 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 `wpvmp_ak_stats` SET `filesexist` = 0 WHERE `id` IN ()
In the server log I see:
.974499 [NOTICE] [26071] [T0] [77.24.123.77:56802-H3:86D3BF-496#APVH_architekturbuero-kunert.com:443] [STDERR] PHP Warning: file_exists(): open_basedir restriction in effect. File(/var/www/vhosts/preyer.info/site-kunert.preyer.info-20190924-181228cest.jpa) is not within the allowed path(s): (/var/www/vhosts/architekturbuero-kunert.com/:/tmp/) in /var/www/vhosts/architekturbuero-kunert.com/httpdocs/wp-content/plugins/akeebabackupwp/helpers/Solo/Model/Migreight.php on line 133\n
/var/www/vhosts/preyer.info/site-kunert.preyer.info-20190924-181228cest.jpa is an entry where the site was in developing state.
I tried to resolve this with deleting these entries in the database. But the message box in Akeeba still appears.