sam 2020.5 / mysql

Hopefully someone can assist me.

Issue when adding new tracks. I cannot add any tracks to folders for some reason. they get added to sam and I can see them if I search but they are not in the folder I added them to.

Even viewer shows an error: unhandled exception (duplicate entry 65535 for key PRIMARY)


Many thanks

_________________
www.RockRadio1.Com

Sounds like a corrupted database. Re-index the pointers and see if that helps. viewtopic.php?f=20&t=28106&p=138973#p138973

_________________
- Rob Oyler, SVS

The 65.535 is a bit strange, because that's exactly the largest unsigned 16 bit integer number (2^16 - 1), but I can't see where 16 bit integers would be used in SAM.
Delphi definitely uses 32bit integers and MySQL is set up to use signed 32 bit integers for all ID columns (which is strange, because there's no need for ID numbers to get negative, but shouldn't have any reasonable effect on the ID counter as you can still store 2.147.483.647 (2^(32-1) - 1) tracks before it flips over or stops working.

So yeah, this is most likely an index problem and can be repaired using the common database repair steps in the forum post linked by DJ Cassio.

_________________
Benedikt Bauer - SVS (Spacial Volunteer Support)

Shop for readymade PAL scripts by countrywesterndj - Or get a custom script made by me (or others)

My Project:
Send "Now Playing" from SAM to Twitter and/or Facebook | Sourcecode

Thank you, I had the same problem with the corrupted database but I didn't know the reason, your answer helped me in the right direction to solve the issue I had.

_________________
cutfullprice