I need Help - By Scoopers

Dear Mates,

anybody here would like to help me. I am having problem in my site. Please check this. What should i do?

<br />

<b>Warning</b>:  mysql_query(): supplied argument is not a valid MySQL-Link resource in <b>/home/escooper/public_html/flash/modules/global/inc/db.inc.php</b> on line <b>48</b><br /> <br />

<b>Warning</b>:  mysql_query(): supplied argument is not a valid MySQL-Link resource in <b>/home/escooper/public_html/flash/modules/global/inc/db.inc.php</b> on line <b>49</b><br /> <br />

<b>Warning</b>:  mysql_query(): supplied argument is not a valid MySQL-Link resource in <b>/home/escooper/public_html/flash/modules/global/inc/db.inc.php</b> on line <b>50</b><br /> <br />

<b>Warning</b>:  mysql_query(): supplied argument is not a valid MySQL-Link resource in <b>/home/escooper/public_html/flash/modules/global/inc/db.inc.php</b> on line <b>51</b><br /> Database access error.<br />

<b>Warning</b>:  mysql_error(): supplied argument is not a valid MySQL-Link resource in <b>/home/escooper/public_html/flash/modules/global/inc/db.inc.php</b> on line <b>71</b><br />

Description: Database access error.<br />

<b>Warning</b>:  mysql_error(): supplied argument is not a valid MySQL-Link resource in <b>/home/escooper/public_html/flash/modules/global/inc/db.inc.php</b> on line <b>71</b><br />

Description: Database access error.<br />

<b>Warning</b>:  mysql_error(): supplied argument is not a valid MySQL-Link resource in <b>/home/escooper/public_html/flash/modules/global/inc/db.inc.php</b> on line <b>71</b><br />

Description: <br />

<b>Warning</b>:  mysql_num_rows(): supplied argument is not a valid MySQL result resource in <b>/home/escooper/public_html/flash/modules/video_comments/inc/classes/BxDolCronVideoComments.php</b> on line <b>67</b><br />

I do not know the flash app in Dolphin very well, so I do not know why this error is showing up.

But if your site is live, and since this is only a warning error, you can disable the php errors while you are waiting for a fix.

Open your php.ini and find display_errors

Switch that Off.

hey friend,

Thank you v ery much for opinion..

about our project  i will pocus first to my site problem then ill contact you after this.

God Bless

Check your db connect settings in inc/header.inc.php

I just discovered this same string of errors and can't figure out what the issue is. What exactly should I be looking for in db connect settings in inc/header.inc.php? I don't see anything in there that relates to these database errors.

Looking at the files called in this I can see the following:

48    mysql_query("SET NAMES 'utf8'", $this->rLink);
49    mysql_query("SET @@local.wait_timeout=9000;", $this->rLink);
50    mysql_query("SET @@local.interactive_timeout=9000;", $this->rLink);
51    mysql_query("SET @@local.connect_timeout=9000;", $this->rLink);

and:

71        if($this->bPrintLog === true) echo " Description: " . mysql_error($this->rLink);

and:

//remove all tokens older than 10 minutes
getResult("DELETE FROM `" . $sDbPrefix . "Tokens` WHERE `Date`<'" . ($iCurrentTime - 600). "'");

getResult("UPDATE `" . $sDbPrefix . "Files` SET `Date`='" . $iCurrentTime . "', `Status`='" . VC_STATUS_FAILED . "' WHERE `Status`='" . VC_STATUS_PROCESSING . "' AND `Date`<'" . ($iCurrentTime - $iFailedTimeout) . "'");
$rResult = getResult("SELECT * FROM `" . $sDbPrefix . "Files` WHERE `Status`='" . VC_STATUS_PENDING . "' ORDER BY `ID` LIMIT " . $iFilesCount);
67        for($i=0; $i<mysql_num_rows($rResult); $i++)

Looking at these files it totally looks to me like there is some sort of timeout error happening, which is probably a server issue. While all of my settings are set to Dolphin specifications, I've been having several server *blips* where my site just seems to stop for a moment. I've contacted arvixe to look at this already.

But I'm not even sure that the server IS the issue. Can anyone offer any insight on what this is?

And in addition - I have a whole long list of cron errors - can anyone tell me where a novice dolphinite can decipher these? I've never encountered the number of errors that dolphin is throwing, and I don't know how to decode them properly in order to fix them.

Did you check whether the mysql server is okay?

When I check the database, everything returns "Ok".

I'm getting the exact same errors ... any1 figure this out yet?

bump. looking for the fix to this too...

 ace:

if you are seeing this same set of errors, where it states :

Description: Database access error.<br /> then you need to submit a ticket to your service provider and see what they have to say. 

 there is truly one controlling file for the database connection, and that is /inc/header.inc.php

if the files are uploaded correctly, and/or if there was no interruption when using an auto-installer, then all filers should be in place. the flash apps, call the header.inc.php file for its connection, and there is nothing that we typically need to change or set on those specific modules. 

so if you are getting --> Description: Database access error.<br />

then you have a database connection issue, and would need to address this with your service provider. 

you can also enable DB debug, and get a full output on the database error, but from what it says, --> Description: Database access error.<br /> that means its not connecting for one reason or another, and i dont think, (though stranger things have happened) that this is directly related to dolphin or the flash apps. 

 Has anyone resolved this? I've been getting this too....

I contacted my Host, and this was their response:

"Hi,

We have verified your support query and found that the error is related with the code specified in cron.php file.

We are not familar with the code specified in that fiile. Kindly contact your code developer with the desciption of the error in order to resolve the issue."

Thanks