Setting Up mAirListDB With MySQL On a NAS

English General
41

A big thank you, Torben, all running and works like a charm!

42

Run the clone again.
This is the message: [FireDAC][Phys][MySQL] Got a packet bigger than 'max_allowed_packet’bytes

43

Done it again but now whit out saving playlist and then it runs till the end :smiley:
And I don’t need old playlist’s so it’s fine by me.

So also a Big thanks Torben and Tondose

2 Likes
44

Hi Henk, Hi Torben, also untick Icons to make the Clone work. @Torben See Bugreport earlier Today.

Cheers Wilbert

1 Like
45

My nas (Synology) runs on 6.2 yesterday I got an email that support ends 24 Oktober. You should upgrade to 7 but 7 don’t support maria bd 5. So I need to upgrade to Maria db 10 before I upgrade to version 7. On the Synology website it looks quite simple export the database in maria db 5 and Import it in 10. Are there additional staps in mairlist to make or is it that simple?

46

Schermafbeelding 2023-12-21 194437

Try to clone the database , get tis message . anny smart way to remove the items

47

Apparently some leftover data from deleted items. Should not happen, but SQLite is not so strict about foreign keys.

You can repair it like this in the SQL Console (DB App About menu):

DELETE FROM item_attributes WHERE item NOT IN (SELECT idx FROM items);

(Remember to keep a backup when fiddling around!)

3 Likes