Strange Error when viewing videos ....

OK I have installed 3 new totally separate sites with own DB's ....

When viewing videos I get an error at random times above my 'view video' pages ... this happens across all 3 of my newest sites:-

Database access error. Description: Duplicate entry '20-f1efd59ab298614012ef43d830a316f4' for key 'PRIMARY'

I have searched the databases and found nothing like ^^

All 3 sites are latest dolphin version

Going to need a bit more info.

- Is this a embedded video or one from your local PC?

- What is the rest of that database error? What table is this duplicate supposed to be located in?

- You say it's random meaning at times, you can view the error with no problem?

- Are these bare-bone sites or are they customized?

Database access error. Description: Duplicate entry '20-f1efd59ab298614012ef43d830a316f4' for key 'PRIMARY'

 from what I see they are uploaded videos from PC

the error is not giving any tables ... this part confusing me!

this error shows right at very top of site!

the only way sites are customized is with template ... 2 sites have same template and other site has different one.

the error is not always there ... happens at different random times across 3 sites when viewing videos ..

this is one of the errors in full happening right up top of one of my sites on 'view video' page at random times .... as you see it's not giving details of any tables ?! :-

Database access error. Description: Duplicate entry '19-cb0c287180ff7665e12089c8828de809' for key 'PRIMARY'

Warning: Cannot modify header information - headers already sent by (output started at /home/*****/public_html/flash/modules/global/inc/db.inc.php:68) in /home/******/public_html/inc/design.inc.php on line 101

'Normally' that means there is some whitespace located in one of the php files.

First trying clearing your cache and see if that helps. The line numbers you pasted refer to the template so try changing the template to UNI and see if the problem persists. If you have caching enabled, be sure to clear it once you changed the template.

 I don't see how this would be issue with templates ... I have many sites and this is only happening with my 3 latest sites ... I have noticed SQL errors in phpadmin area when working on them (trying to import backups)... I dont know if its related to issues I am seeing:-

Error
There is a chance that you may have found a bug in the SQL parser. Please examine your query closely, and check that the quotes are correct and not mis-matched. Other possible failure causes may be that you are uploading a file with binary outside of a quoted text area. You can also try your query on the MySQL command line interface. The MySQL server error output below, if there is any, may also help you in diagnosing the problem. If you still have problems or if the parser fails where the command line interface succeeds, please reduce your SQL query input to the single query that causes problems, and submit a bug report with the data chunk in the CUT section below:
----BEGIN CUT----
eNo1zUsKwjAYBGChu/8Uc4AYkmopZBdKqEJeJrWCW3FRKNkJentTwVkOHzMmpZAUBomhhTVeQaKF
lJSnWjdE7pMvVqHjkvdi/1hXuuaEkBn0aPzEMJsKb0uBC/eztbpSQdFphSMXvKN4ipthIW8rBy57
2KW83mS1HxWehX4H1Oz++QIVfCEC
----END CUT----
----BEGIN RAW----

ERROR: C1 C2 LEN: 1 2 11
STR:

MySQL: 5.1.70-cll
USR OS, AGENT, VER: Win MOZILLA 5.0
PMA: 4.0.5
PHP VER,OS: 5.3.17 Linux
LANG: en
SQL:


----END RAW----

SQL query:



MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

the above ^^^ happened when trying to import backups to the three new sites ...

FYI clearing caches on sites is not helping with issue .. the errors return at random times again after caches are cleared ..

is there a way I can hide the error from public until I work out a fix ?

display_errors is off  in php but people can still see 'Database access error. Description: Duplicate entry '20-f1efd59ab298614012ef43d830a316f4' for key 'PRIMARY'

'

BUMPING THIS ...!!

I can try to get back in to help but not sure how good it will be..

I searched all boonex files and only found 5 to even have the word 'Primary' anywhere in the code. But taking a look at this without being at your website, something about this error struck me..

It's the word 'key'. This is normally referred whendealing with languages. These may be some stupid questions but here it goes:

- You said "from what I see they are uploaded videos from PC". So I take it you are not the one uploading them?

- Do you only get this error when viewing a 'specific' video or does it randomly happen with all videos on your site?

- Have you tried embedding a YouTube video to see if the message appears on that screen as well?

- Are you absolutely positive that you do not have more than 1 video on your site that has the same exact name and/or description?

search your whole database for "19-cb0c287180ff7665e12089c8828de809" from phpmyadmin and post found table name and maybe a screenshot too.

 I have searched all 3 databases and there is nothing like this or tables with it ...

 there are certainly no double videos at sites ...

I myself have uploaded the videos currently.

I have noticed it more with certain videos across the 3 separate sites however this could be due to me checking the ones I have noticed over and over.

I have not noticed it with YouTube videos etc.

I also need to add that on the three separate sites it is NOT the same video causing issues ... the sites all have different videos and the parts '20-f1efd59ab298614012ef43d830a316f4' are different for each video I have noticed the errors with ...

do you have same users for all 3 databases of the three sites?

EDIT: Oh and better yet just try restarting mysql server

The fact that it's happening across 3 sites with 3 separate database makes me think that is either:

- The videos themselves since it doesnt seem to happen with YouTube (as of yet)

- Some type of installation issue such as:

• A one click installer that did not properly upload files (corrupt or not in binary) 
• Permission related issues (files, folders, etc.)

Do you see this error while using other browsers?

 No, I have different users ... why would this make difference anyway as sites and DB's are totally separate?

 I do not use one-click installers ..

All files and folders permissions are correct from what I can see.

I have seen this error using Chrome and FireFox ..

If your site is not an adult site, you can shoot me the URL. I am currently at work and do not think my corporate network would like me visiting any places like that

btw did you restarted your mysql server?

 all done ... thanks!

 you may need to reload video page a few times to see it happen ... BUT the error is certainly there and happening!

Yes, I have just done it ...

hummm I have loaded video page about 20 times and don't see the error now ...  I will keep testing and update thread!

You said to go to the site, load a video page completely, refresh it (couple of times maybe) and you will see the error.

I know I asked for your other sites that are having problems but let me go ahead and tell you what I have seen so far:

- You 'main' domain was blocked by my network but I was able to get to the video page in question (go figure).

- I watched it a couple of times (thank God is was animated) 

- Refreshed the page 20+ times and I got..................nothing..... no errors or nothing...

- I decided to use my phone and noticed that you have a 'responsive' template installed. So here is the kicker:

At my work, we still use IE 8.0. In your responsive template, the IE8 settings are commented out like this:

<!--[if lte IE 8]>
<!--[if IE 8]>
 

I do not get that error when using IE 8 OR when using my phone while the template is in 'responsive' mode no matter how many times I try to reload it.. It works perfect each time..

So back to the original statement. If you are using responsive templates on each one of these sites, that would be the first place I would start looking. View your sites using your mobile phone or even IE 8 (iff possible) and you will see that everything works great.

EDIT: But then again, maybe that  database reset cleared out some junk. See if its still happening on the other 2 sites too.

OMG scary 

and restarting the database reset your processlist table in information_schema database which was the cause of the issue i think.

this site I shown you is responsive ... the other 2x sites are not!

I don't seem to be getting the error the past 30+ reloads but I will keep testing! I don't want audience seeing errors like this!

Yeah, that video is pretty WTF huh! Crazy story right there and within 4 hours of me putting it online we had almost 16,000 viewers ...

Here are some screenshots of error to show this issue does exist, one is the site you looked and one of the others I mentioned about:-

Can you explain this a little better please ?  I am trying to understand and note for future reference ..

How would processlist table in the Databases possibly cause the errors I was getting ?

 I don't know why it happened but i can guess something to do with same user spawning lots of processes.

damn it ... I just saw the errors again :/

how can I stop users seeing the error please ? Display_errors is off  in php but people can still see part of the errors ...

Could it be a issue with viewing videos when there is a high amount of traffic looking at them at any one time ... currently I have 90+ viewers per minute (due to sharing video/s across my networks) looking at particular video/s and I am seeing the error regularly on the videos receiving the traffic ?!

Maybe there a bug here ..

Something is not right and this don't make sense .. Oddly the other 2 sites I talked about also got the errors when high numbers of people was viewing particular videos at any one time.

Thats because display errors is to shut off php errors. This is a mysql error.

Try this.

Edit flash/modules/global/inc/db.inc.php

Look for this at about line 28

$this->bPrintLog = true;

Change to this.

$this->bPrintLog = false;


EDIT: Oh, and you will need to comment out the echo at line 90

This..

echo 'Database access error.';

To this.

//echo 'Database access error.';

 thanks a lot I will give it a try now ...

I edited the post. Read it again. Another edit to make.

Of course this just shuts off the error display. It does not solve the problem which i have no clue why it is happening.

That error would indicate something is being written to the database. The thing is, nothing should be written when just viewing videos. So i am guessing it may be related to the video comments if you have a comments block on the page.

do we know if high traffic on particular videos at anyone time could possibly cause the issue I have been getting with these error codes ?

Deano ... even though I followed instructions and commented out the part you said at line 90 ... I am still seeing 'database access error' at random times ?

is there somewhere else controlling this also or something else that needs doing?

I am wondering if the 'related videos' block is the issue?! 

I know the block has never worked on any of my sites and I just realized the block is active on 'view video' page ...

 that might be a good way to start, remove blocks one by one and see if errors remains.

 
There are 3 lines in that file.

So try commenting out all 3 of them. Lines 68, 79 and 90


As i said, i have no clue what is causing it.

I certainly have the problem when more than 20 people are looking at same video at anyone time ... I am starting to think it's that 'related videos' block as it's useless and would indeed be calling on the DB right ?

I bet this is what is causing the errors when there is active traffic ... and therefor everyone would have this issue if they try and use the block on active video page!

Josh, I have been able to duplicate this error over and over constantly, not sure why or how so it seems to be a bug.

• Database access error. Description: Duplicate entry '2-1febbf7dd2b9591bc11164994ff29dbb' for key 'PRIMARY'

I get the error when I create a third column on the view video page, moving the comments block to the left reproduces this error.

Moving the comments block back to the center and the error will not happen, ever. Not sure if this is what your getting but it is what is happening on my site.

Follow up, this is a template problem for me, using UNI, or other third party template does not cause this error.

This is quite interesting.

Would you try this and let me know what happens?

Go to inc/classes/BxDolDb.php around line 66 and change

$this->link = @mysql_pconnect($full_host, $this->user, $this->password);

To this

$this->link = @mysql_connect($full_host, $this->user, $this->password);

removing the "p". Simple enough.

 ok now its weird

 Yes, this is only with a "responsive" template I need to add.