New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
SQL error on creating folders when using PostgreSQL database #508
Comments
Thanks for the report @chris968, we'll look into it. |
My current workaround is to disable the "folders" plugin:
|
Hi @chris968 , it could be that during the migration from MySQL to Postgres, some folders got their
|
@pabloelcolombiano of course I can run both commands but we have no folders in our setup:
|
operator does not exist: character = uuid so the folders.id might still be of character type and not of the postgres uuid type @pabloelcolombiano |
Platform info:
-- Operating system: CentOS 7 and official docker image
-- PHP: 7.4 and 8.2
-- Web server: nginx
-- Database server: PostgreSQL 15
How to reproduce:
Create a folder through the web GUI or launching
cake passbolt cleanup
command.The web GUI throw an error 500 but the application log show the following entry:
The
cake passbolt cleanup
command show another error message related to the folders table:We reproduce the issue on two distinct setups, the database have been migrated from a working MySQL one.
The text was updated successfully, but these errors were encountered: