Skip to Content
It is currently March 5th, 2021, 2:41 am

All times are UTC - 6 hours [ DST ]




Post new topic Reply to topic  [ 43 posts ]  Go to page Previous  1, 2, 3  Next
Author Message
PostPosted: November 18th, 2012, 12:49 pm 
Offline
SVS Member
SVS Member

Joined: October 15th, 2003, 11:59 pm
Posts: 4743
Location: Los Angeles - A Little West Of Nashville
VBR files can display the time incorrectly.

_________________
- DJ Dee
- Spacial Volunteer Support (SVS)
- Custom PAL services: www.palscripts.com
- http://www.AlternativeHD.com
- http://www.lahotcountry.com


Top
 Profile  
Reply with quote  
PostPosted: November 21st, 2012, 7:11 am 
Offline
Experienced User
Experienced User

Joined: September 12th, 2011, 10:05 pm
Posts: 304
I never use Variable Bitrate. I'm on SAM 4.9.7. The issue happens on both my Main and backup machine, for the same files.

A link to the file can be found here (sorry it's the whole set)...

http://soundcloud.com/square_eyes-promo ... by-zero-vi

_________________
Square Eyes


Top
 Profile  
Reply with quote  
PostPosted: November 21st, 2012, 7:34 am 
Offline
SVS Member
SVS Member

Joined: December 6th, 2004, 9:00 am
Posts: 8156
Location: Cologne (Germany)
Just d/led the mp3 from soundcloud and can confirm the problem.
Once loaded to the deck it displays time elapsed and time remaining just fine, but in the Playlist window the track is listed as -0:00
I can't tell why it's happening though, sorry.

BTW: I've listened half through your set and like it so far. Must see if I can manage to listen live next saturday morning.

_________________
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: November 28th, 2012, 10:21 am 
Offline
Experienced User
Experienced User

Joined: September 12th, 2011, 10:05 pm
Posts: 304
Ha ha. Thanks man.

At least I'm not crazy.

I wonder if changing over to mysql from firebird would clean this up. I also have problems with some files never showing as a result of my rotation rules. (tried all suggestions so let's not talk about that here).

If you guys think I might have a chance of clearing these issues up I might tackle the old problematic mysql install again.

FYI the show is on Saturday 7-9pm GMT (Moved to London). Would be great to have you stop by.

_________________
Square Eyes


Top
 Profile  
Reply with quote  
PostPosted: November 28th, 2012, 12:06 pm 
Offline
SVS Member
SVS Member

Joined: December 6th, 2004, 9:00 am
Posts: 8156
Location: Cologne (Germany)
I'm on MySQL and this is the first file I've got these problems with.
Maybe you should send in a bug report to spacial's helpdesk and see whether they are willing to check and fix this.

OT:
Quote:
FYI the show is on Saturday 7-9pm GMT (Moved to London). Would be great to have you stop by.

That makes it a lot easier. 8-10pm sounds much more like the time to listen to music. (OK granted, I'm listening to music at work as well, but that's a different kind of music then)

_________________
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: February 16th, 2013, 6:44 pm 
Offline
New User
New User

Joined: February 27th, 2010, 9:08 pm
Posts: 11
Recently I found in myself a similar problem.
It occurs, when track duration too big (for example at me this effect occurs when duration exceeds 2 hours. YES! In my radio there are such long tracks! ) . That is interesting, information on duration of a track is correctly displayed in SAM Broadcast in Desk.
I assume that it occurs it when SAM Broadcaster works at the 32-bit platform. Probably, in any place of the program the variable of duration of a track (duration) possibly has the integer type, instead of int64 which is responsible for transfer to a duration parameter database. In the 32-bit environment value will go beyond max_int, and instead of correct value of duration, in a database there will be a value "-1".

P.S.
- SAM Broadcaster 2013.1 work on MS Windows 2003 Server 32-bit.
- MySQL DataBase Server work on Linux 64-bit.

P.P.S. Sorry for my bad English.


Top
 Profile  
Reply with quote  
PostPosted: February 16th, 2013, 7:31 pm 
Offline
SVS Member
SVS Member

Joined: December 6th, 2004, 9:00 am
Posts: 8156
Location: Cologne (Germany)
MySQL SIGNED INTEGER goes from -2147483648 to 2147483647.
duration is specified in milliseconds.
=> The duration field can store a track duration of up to:
  • 2147483647/1000 = 2147483 seconds
  • 2147483647/1000/60 = 35791394 minutes
  • 2147483647/1000/60/60 = 596523 hours
  • 2147483647/1000/60/60/24 = 24.86 days

Same is true for all 32 bit Integer fields in programming languages.
If you have an unsigned integer, simply double the numbers.
What I meant to say is: Your assumption shows quite a lot of technical understanding, but is easily disproved by the facts.

_________________
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: February 16th, 2013, 8:18 pm 
Offline
New User
New User

Joined: February 27th, 2010, 9:08 pm
Posts: 11
Nevertheless, if the SAM Broadcaster works under control of 32-bit OS (as Windows 2003 Server), in a database I see value "-1".

Yes, it not MySQL problem because moreover my MySQL works under 64 Linux and if I do INSERT by hands in the Linux console that of this mistake I I don't see.

duration Int(11)
int(11) will take 4 bytes of space.
And the max number is 999999999(10) or any no between -999999999(10+'-') will take 4 bytes.

i.e. the 10 digits and a - sign.


Code:
mysql> INSERT INTO songlist (duration,...) VALUES(123456789,...);
mysql> SELECT duration FROM songlist WHERE ...;

duration is 123456789!
123456789/1000/60/60 ~ 34 hours

I noticed that the problem arises, when duration about more than 7200000...

Distortion of data at record in the field of duration of too great value happens somewhere in SAM Broadcaster.


I think that it so.
Well you judge. I have only two things:
1 . SAM broadcaster on MS Windows 2003 Server 32-bit
2 . MySQL on Linux 64-bit.

If I add very long track through SAM Broadcaster that I receive "-1" in a database.
If I too (in milliseconds) add the value in the Linux console that the mistake isn't present.

Why - I don't know. Probably that somewhere in SAM Broadcaster there is an error of transformation of types.

At any stage the number becomes negative (-).

Update: Probably the mistake arises when duration value is transferred from SAM Broadcaster to libmysql.dll


Top
 Profile  
Reply with quote  
PostPosted: February 16th, 2013, 9:26 pm 
Offline
SVS Member
SVS Member

Joined: December 6th, 2004, 9:00 am
Posts: 8156
Location: Cologne (Germany)
I see where your problem is, I just pointed out that it is not related to your duration being too big for a signed 32 bit integer.#
The only thing you can do about this is report the issue to Spacial's Helpdesk.

_________________
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: March 5th, 2013, 5:59 am 
Offline
Experienced User
Experienced User

Joined: September 12th, 2011, 10:05 pm
Posts: 304
I can confirm, all 4 tracks that this happens to me for are over 115 minutes long.

_________________
Square Eyes


Top
 Profile  
Reply with quote  
PostPosted: April 15th, 2013, 5:21 pm 
Offline
Senior User
Senior User

Joined: March 11th, 2003, 9:20 am
Posts: 111
Location: Charlotte NC
Clearly it's the software causing the issue.
Hope someone can figure this one out.
I'm quite upset, as this is starting to happen here.
I'v done all advised, even repaired tables to no avail.... Now if I try to add any files, it says -0.00. They play just fine on the machine, so I know it's not the files themselves. They've been playing well in SAM before.
1 reboot and now this issue.

_________________
-- JE
.::.(())::. Urban Hitz Radio™ USA .::.(())::. The People' Choice for Hip-Hop & R&B!
Listen to Urban Hitz RadioGET A Local or TOLL-FREE Request Line NOW...Only $2 Monthly – Request Line: (855) 588-6767 *SAM:Licensed 2016.3*


Top
 Profile  
Reply with quote  
PostPosted: August 10th, 2013, 4:12 am 
Offline
Experienced User
Experienced User

Joined: September 12th, 2011, 10:05 pm
Posts: 304
As mentioned above INT(11) should be able to accommodate longer sets.

For example: A song 113:25 in duration would be 1:53:25 * 1000 * 24 * 60 * 60 = 6805000

While SAM adds -1 or -0:00 to the database, you can manually add 6805000 and the correct time shows in the song info from then on. Although I'm not sure if this will break things down the line, or how it might affect PHP web pages.

I might do some testing and and look at a PAL script to search for, and fix these entries. It might require some external extraction, say via python, if the true track time can't be programatically attained.

_________________
Square Eyes


Top
 Profile  
Reply with quote  
PostPosted: August 10th, 2013, 8:12 am 
Offline
SVS Member
SVS Member

Joined: December 6th, 2004, 9:00 am
Posts: 8156
Location: Cologne (Germany)
square_eyes wrote:
As mentioned above INT(11) should be able to accommodate longer sets.

This is about data storage and not about displaying or otherwise handling these figures.
Here's an overview of the data types in Delphi (the programming language SAM is written in):
http://www.delphibasics.co.uk/Article.asp?Name=Numbers

_________________
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: August 10th, 2013, 8:26 am 
Offline
Experienced User
Experienced User

Joined: September 12th, 2011, 10:05 pm
Posts: 304
I don't fully understand the correlation. But in the interest of finding a workaround... My manual update propagated to SAM. I guess my question then, without having more context to any 'data storage' issue... is there any point exploring an automated 'correction' to the song lengths in the database?

_________________
Square Eyes


Top
 Profile  
Reply with quote  
PostPosted: August 10th, 2013, 8:34 am 
Offline
SVS Member
SVS Member

Joined: May 8th, 2004, 9:00 am
Posts: 10526
Location: Denver, CO
square_eyes wrote:
I don't fully understand the correlation. But in the interest of finding a workaround... My manual update propagated to SAM. I guess my question then, without having more context to any 'data storage' issue... is there any point exploring an automated 'correction' to the song lengths in the database?

AS long as SAM calculates the correct duration while in the player, which would affect triggering the song change on the website, I can't see why it would make a difference unless you are constantly staring at the queue and it "bugs" you, all other functions appear to continue normally correct? Personally I have never encountered this issue however, my SAM is on a remote VPS so it's an "out of sight" kind of thing for me.

_________________
- Rob Oyler, SVS
Image


Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 43 posts ]  Go to page Previous  1, 2, 3  Next

All times are UTC - 6 hours [ DST ]


Who is online

Users browsing this forum: No registered users and 38 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