linagora / linshare

LinShare
https://www.linshare.org/
GNU Affero General Public License v3.0
449 stars 84 forks source link

migration issue from 5.0.4 to 5.1.0 #271

Closed matdemb closed 1 year ago

matdemb commented 1 year ago

Hello, I tryied to migrate from 5.0.4/5.0.5 to 5.1.0 and I obtain a SQL error executing the migration script as indicated in the documentation (permission denied to create extension "uuid-ossp"). My problem is that the "CREATE EXTENSION IF NOT EXISTS "uuid-ossp";" executed with postgres user didn't change the execution script error, I still have it. If I disable the line in the script, I have an other error: psql:linshare-core-sql/postgresql/Migration_5.0.0_to_5.1.0.sql:338: ERREUR: la fonction uuid_generate_v4() n'existe pas LIGNE 1 : ...) VALUES ((SELECT nextVal('hibernate_sequence')), uuid_gener...

Did I miss something?

Kind regards,

matdemb commented 1 year ago

I found the problem, the "CREATE" command needs to be executed in the linshare database.