kagemomiji / airsonic-advanced

airsonic-advanced
GNU General Public License v3.0
144 stars 13 forks source link

#321 add remove duplication of name in genre #322

Closed kagemomiji closed 7 months ago

kagemomiji commented 7 months ago

Fix #321

masterwishx commented 7 months ago

still have error, log in https://github.com/kagemomiji/airsonic-advanced/issues/321

kagemomiji commented 7 months ago

@masterwishx Thank you for your feedback.

Since the Liquibase file has been updated, you cannot use the new image as is. Please follow the steps below to apply the new image. I used adminer to edit data in the database.

  1. Stop Airsonic Advanced while keeping the database running.
  2. Delete data from the DATABASECHANGELOG table in the database where the FILENAME field is liquibase/11.1/remove-genre-name-duplication.xml. (please see the following image)
  3. Pull the new docker image from pr-322 and start Airsonic Advanced.

image

masterwishx commented 7 months ago

i removed in Adminer as you told but still have error:

image

masterwishx commented 7 months ago

image

kagemomiji commented 7 months ago

@masterwishx Could you show me your query result of SELECT * FROM 'DATABASECHANGELOG' WHERE 'FILENAME' = 'liquibase/11.1/remove-genre-name-duplication.xml'.

masterwishx commented 7 months ago

@masterwishx Could you show me your query result of SELECT * FROM 'DATABASECHANGELOG' WHERE 'FILENAME' = 'liquibase/11.1/remove-genre-name-duplication.xml'.

Do you still need it? The result was : deleted 4 units, when made query again after first it was not founded. But after pr-322 it again avaliable I think

kagemomiji commented 7 months ago

@masterwishx Yes. I need those results to know their md5sum and exectype.

masterwishx commented 7 months ago

now im using privieos version image

masterwishx commented 7 months ago

image

masterwishx commented 7 months ago

Using edge-11.1.3-SNAPSHOT.20231108102506 for now

kagemomiji commented 7 months ago

@masterwishx It seems from your logs that you have restarted using the docker image from the commit e6cab2f prior to the modification. Please execute docker pull ghcr.io/kagemomiji/airsonic-advanced:pr-322 to pull the latest image. After that, edit the database as I commented at here and then restart Airsonic.

masterwishx commented 7 months ago

Yes , it working Fine Now