Skip to Content
It is currently March 8th, 2021, 8:21 am

All times are UTC - 6 hours [ DST ]




Post new topic Reply to topic  [ 4 posts ] 
Author Message
PostPosted: August 29th, 2020, 4:43 pm 
Offline
Senior User
Senior User

Joined: May 31st, 2007, 4:13 pm
Posts: 199
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


Top
 Profile  
Reply with quote  
PostPosted: August 30th, 2020, 7:44 am 
Offline
SVS Member
SVS Member

Joined: May 8th, 2004, 9:00 am
Posts: 10527
Location: Denver, CO
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
Image


Top
 Profile  
Reply with quote  
PostPosted: August 30th, 2020, 9:47 am 
Offline
SVS Member
SVS Member

Joined: December 6th, 2004, 9:00 am
Posts: 8156
Location: Cologne (Germany)
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


Top
 Profile  
Reply with quote  
PostPosted: September 25th, 2020, 3:43 am 
Offline
New User
New User

Joined: August 16th, 2020, 6:00 pm
Posts: 1
Mastacheata wrote:
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.

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


Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 4 posts ] 

All times are UTC - 6 hours [ DST ]


Who is online

Users browsing this forum: Bing [Bot] and 31 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB® Forum Software © phpBB Group