V2.0 Database MySQL doesnt work any more

[amet]

Not sure what that means....

iOS and tvOS has logging ability

[baerwurzl]

23:42:16 T:6143995904 DEBUG: Initialize, updating databases...
23:42:16 T:6143995904 NOTICE: Running database version ViewModes6
23:42:16 T:6143995904 NOTICE: Running database version Textures13
23:42:16 T:6143995904 WARNING: Unable to query optimizer_switch: 'mrmcmusic56' (1)
23:42:16 T:6143995904 NOTICE: Running database version mrmcmusic56
23:42:16 T:6143995904 WARNING: Unable to query optimizer_switch: 'mrmcvideo99' (1)
23:42:16 T:6143995904 NOTICE: Attempting to update the database mrmcvideo99 from version 93 to 99
23:42:16 T:6143995904 DEBUG: Mysql Start transaction
23:42:16 T:6143995904 DEBUG: Mysql execute: ALTER TABLE movie ADD userrating integer
23:42:16 T:6143995904 ERROR: SQL: [mrmcvideo99] Undefined MySQL error: Code (1060)
Query: ALTER TABLE movie ADD userrating integer
23:42:16 T:6143995904 ERROR: Exception updating database mrmcvideo99 from version 93 to 99
23:42:16 T:6143995904 ERROR: Error updating database mrmcvideo99 from version 93 to 99
23:42:16 T:6143995904 DEBUG: Mysql rollback transaction

Full log see last Reply

[amet]

Look at line 842, looks like you already have darabase version 99 which has been corrupt somehow.

Kill application and drop "mrmcvideo99" database and start MrMC again, be patient(and log it in case it fails again) might take some time.

Depending on your setup, you need to find out how to delete the *99 database

[baerwurzl]

Look at line 842, looks like you already have darabase version 99 which has been corrupt somehow.

Kill application and drop "mrmcvideo99" database and start MrMC again, be patient(and log it in case it fails again) might take some time.

Depending on your setup, you need to find out how to delete the *99 database

Thank you so muich for your help. Deleting the database and enable mysql worked. i have to reorganize it a little bit again, but it works for the future...

[bagges]

Using mysql OB Qnap. No problem after Update to 2.0.


Sent from my iPhone using Tapatalk