Page 1 of 1
PHP and MySQL version suggested.
Posted: 2024-06-25 10:38
by A Bindi
Hello,
for reasons of obsolescence we have to create from scratch a new webserver for our AppGini applications, so I would know what versions of PHP and MySQL we have to install to work properly the applications created with version 5.97 of AppGini and, eventually later, if is needed to upgrade something in case we wanted to move to version 24.12.
ALex.
Re: PHP and MySQL version suggested.
Posted: 2024-06-28 18:09
by onoehring
Hi A Bindi,
I suggest you download a latest package of Xampp or similar that contains the latest versions of php and mysql/mariadb and simply try.
For testing I am (also) using UniformServer (
https://www.uniformserver.com ) where you can switch very easy between different versions.
You should also check this forum thread (
https://forums.appgini.com/phpbb/viewto ... f=2&t=4877 ) to see experiences (and problems) other note concerning (php) versions.
Olaf
Re: PHP and MySQL version suggested.
Posted: 2024-07-11 11:02
by A Bindi
Thank you for suggestion Olaf !
ALex.
Re: PHP and MySQL version suggested.
Posted: 2025-04-20 23:56
by sacgtdev
Thinking of moving to MySQL 8.4 as 8.0 will be deprecated in April 2026.
Wonder whether there is any incompatibilities issues with Appgini 25.10 ?
https://dev.mysql.com/doc/refman/8.4/en ... l-removals
Re: PHP and MySQL version suggested.
Posted: 2025-04-26 09:32
by a.gneady
According to the what's new page for MySQL8.4, I don't think there should be any issues with upgrading from 8.0 to 8.4. I'll be testing this in the upcoming days to confirm and make any necessary fixes though. The only issue that I think might affect some projects could be:
AUTO_INCREMENT and floating-point columns. The use of the AUTO_INCREMENT modifier with FLOAT and DOUBLE columns in CREATE TABLE and ALTER TABLE statements was deprecated in MySQL 8.0; support for it is removed altogether in MySQL 8.4, where it raises ER_WRONG_FIELD_SPEC (Incorrect column specifier for column).
Before upgrading to MySQL 8.4 from a previous series, you must fix any table that contains a FLOAT or DOUBLE column with AUTO_INCREMENT so that the table no longer uses either of these. Otherwise, the upgrade fails.
Re: PHP and MySQL version suggested.
Posted: 2025-04-26 10:48
by a.gneady
After some quick testing, 2 points to take care of:
- Use PHP 7.4 or above. Older versions won't work with MySQL 8.4. I'd highly recommend using PHP 8.2 or above.
- You might need to change the MySQL user configuration to use
caching_sha2_password plugin rather than mysql_native_password. I'll create a blog post explaining the details of this step by step, but a quick Google search should get you started.
Re: PHP and MySQL version suggested.
Posted: 2025-05-13 02:40
by lramirez
Hi... I have my own server and I migrated the applications from Windows Server to Linux Ubuntu Server, with PHP 8.3 and everything is working perfectly... even the plugin
https://forums.appgini.com/phpbb/viewto ... f=4&t=3308 