Failed to upgrade from 2.9.13 to 3.0.0 with Postgresql 9.1 and PHP 7.3
Few points :
1/ $DB['port'] was not required on database.php previous version, maybe it would be better to add a note on Upgrading documentation to inform users to add this parameter on database.php file
2/ On setup/update.php (lines 572,608,623 to 631,663) few ALTER TABLE and CREATE TABLE with INT(11) or INT(1) which are not compliant with Postgresql, should be replace by INTEGER or SMALLINT
3/On setup/update.php line 648 $perm->renameRight('delete_user', 'delete_user'); should be replace by $perm->renameRight('deluser', 'delete_user');
Cheers,
Ben
Failed to upgrade from 2.9.13 to 3.0.0 with Postgresql 9.1 and PHP 7.3
Moderator: Thorsten
Re: Failed to upgrade from 2.9.13 to 3.0.0 with Postgresql 9.1 and PHP 7.3
Hi,
thanks a lot for your bug report.
bye
Thorsten
thanks a lot for your bug report.
The database port is just optional, where did you ran into an issue?1/ $DB['port'] was not required on database.php previous version, maybe it would be better to add a note on Upgrading documentation to inform users to add this parameter on database.php file
thanks, fixed for 3.0.12/ On setup/update.php (lines 572,608,623 to 631,663) few ALTER TABLE and CREATE TABLE with INT(11) or INT(1) which are not compliant with Postgresql, should be replace by INTEGER or SMALLINT
also fixed for 3.0.13/On setup/update.php line 648 $perm->renameRight('delete_user', 'delete_user'); should be replace by $perm->renameRight('deluser', 'delete_user');
bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
amazon.de Wishlist
Re: Failed to upgrade from 2.9.13 to 3.0.0 with Postgresql 9.1 and PHP 7.3
Hi,
Not sure if the upgrade failed due to the missing 'port' in database.php or only due to wrong sql for Postgres in update.php.
I will check with version 3.0.1
Thanks for your great job !
Ben
Not sure if the upgrade failed due to the missing 'port' in database.php or only due to wrong sql for Postgres in update.php.
I will check with version 3.0.1
Thanks for your great job !
Ben
Re: Failed to upgrade from 2.9.13 to 3.0.0 with Postgresql 9.1 and PHP 7.3
Hi,
I'm creating an additional PostgreSQL development environment for checking these issues for the 3.0.1 release.
bye
Thorsten
I'm creating an additional PostgreSQL development environment for checking these issues for the 3.0.1 release.
bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
amazon.de Wishlist