MediaSignage support forum

community support => Report bugs and errors => Topic started by: bsergon on May 22, 2015, 01:38:59 AM

Title: Error duplicate entry for primary SQL key showing up in Signage player
Post by: bsergon on May 22, 2015, 01:38:59 AM

Hi,

we are using your solution, the Signage Studio Pro for preparation of the content and then the Signage player for displaying the content. Mostly the solution is working without any problem.

In Signage Studio Pro we are using one Timeline and five channels and in each of these channels we are using the HTML component option and we are displaying the content of one URL/internet page. Time to time (mostly is working very well) happens, that on refresh/sync, one of channels (also randomly, not always the same channel) don`t display the content of the URL, but an error, which contains a text like this:"Duplicate entry ... for key Primary SQL=insert into".

Please, can you explain why this error is showing up? What we are doing wrong? Is maybe there some option, setting, that we have to set/change?

Thank you very much in advance for the answer and help.

BR, Borut

Title: Re: Error duplicate entry for primary SQL key showing up in Signage player
Post by: admin on May 22, 2015, 08:20:08 AM

is this error coming from the HTML component? can you post an image?

Title: Re: Error duplicate entry for primary SQL key showing up in Signage player
Post by: bsergon on May 23, 2015, 02:07:47 AM

Yes, the error is coming from the HTML component. I will try to do take a printscreen when the error shows up. Is this a known bug, how we can avoid it?

Title: Re: Error duplicate entry for primary SQL key showing up in Signage player
Post by: admin on May 23, 2015, 06:55:34 AM

never seen that error...
are you on Windows Player?

Title: Re: Error duplicate entry for primary SQL key showing up in Signage player
Post by: bsergon on May 23, 2015, 01:03:14 PM

No, this error is showing up only on Android player.

Title: Re: Error duplicate entry for primary SQL key showing up in Signage player
Post by: bsergon on May 25, 2015, 04:02:02 AM

This is the screenshot of the error: to-interni-marketing.com/index.php?option=com_content&view=article&id=8

Title: Re: Error duplicate entry for primary SQL key showing up in Signage player
Post by: admin on May 25, 2015, 05:17:36 PM

sorry but can u post the whole screen? we need to see the alert windows as well

Title: Re: Error duplicate entry for primary SQL key showing up in Signage player
Post by: bsergon on May 25, 2015, 10:17:54 PM

This is it. This is the screen (the whole screen) that the user see on the screen. There is no additional error or alert window. Instend of the content, the error is displayed. BR, Borut

Title: Re: Error duplicate entry for primary SQL key showing up in Signage player
Post by: admin on May 26, 2015, 10:48:44 AM

I believe this is coming from the web site... if you try a diff domain it goes away?

Title: Re: Error duplicate entry for primary SQL key showing up in Signage player
Post by: bsergon on May 27, 2015, 01:45:34 AM

No, the problem is not coming from the web site. The web site is working and the content on the web site (if you opne the URL in the web browser) is working just fine. Also the preview in teh Signage Studio is always working fine and is showing the content. The problem is showing only in the Signage Player.