Database Error, Help!

Can ANYONE help me to id this problem?

Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/djkk1/public_html/NewBusinessFriends.com/inc/classes/BxDolDb.php on line 431

Fatal error: Call to a member function getParam() on a non-object in /home/djkk1/public_html/NewBusinessFriends.com/inc/db.inc.php on line 83

I installed another script on my server last night in it own location having nothing to do with my D7 folder or database...but I got this message when i try to access my D7 site " NewBusinessFriends.com", my host told me to check with Boonex so they could pin point the issue??? so where do I start??? any help is appreciated...Thanks

Best regards,

Ryan

??????? ANYONE???

have the same problem on a webspace...

how long has this been a problem for you?

Ryan

you start out seeing what the argument is that's invalid.  You'll find it in your inc/classes/BxDolDb.php file on line 431.  Look for the entire section of code, starting with { and ending with } and also inc/db.inc.php line 83.  Same thing. 

Give us those snippets of code and we can probably figure it out.  Also, is there anything else to this error that is coming up or is this the FULL error report.  I don't see a debug on this.

The D7 script can't connect to your Mysql database.  Make sure these settings in inc/header.inc.php are correct.


$db['host']                = 'localhost';
$db['sock']                = '';
$db['port']                = '';
$db['user']                = 'database_username';
$db['passwd']              = 'database_password';
$db['db']                  = 'database_name';

ok, going to keep the snippets......

The php errors are secondary.  You need to fix this error first.

house, i checked the inc/header.inc.php and it all looks perfect....?

Please check this post, I think we speak about the same problem and here is Line 83!

http://www.boonex.com/unity/forums/topic/Fatal-error-Call-to-a-member-function-getParam.htm

Fatal error: Call to a member function getParam() on a non-object in C:\wamp\www\xxxxx\inc\db.inc.php on line 83

that line is this function :

82    function getParam( $param_name, $use_cache = true ) {
83    return $GLOBALS['MySQL']->getParam($param_name, $use_cache);
84    }

Thanks for helping

MAS69

you are installing on localhost why don't you check the requirements first
http://www.boonex.com/trac/dolphin/wiki/DolTech
also make sure it supports

short_open_tag

all the requirement are check a and configed like you listed....my sites been up for weeks then, I installed RPS and BEATZ last night and that when all this happens...of course i didn't touch my D7 folder or database??? whats going on here??

now that's weird if you didn't edit any d7 files or db

no just added RBS and Beatz in there own folders to test, and just made a db for them both and entered that db info into the installer setup screens...and i guess somehow ended up screwing the communacation between my D7 site...go figure??? now what???

this might not help a lot but did you try to re-upload the file

inc/classes/BxDolDb.php

I was the one that posted that.  localhost just means that the DB is on the same server as the website, whether it's in your kitchen, or in a data center somewhere.

no let me try now....fingers are crossed!

Does it match the name of your Dolphin DB, your Dolphin DB user name, and your Dolphin DB user name password?  For some reason, I doubt it. 

NOPE!!! re-uploaded bxdoldb.php and still the same shhhhhhh.....stuff! wow this just sucks man....

i'm double checking now......

triple checked...and they are exact to what you have listed and the info is still correct...meaning nothing has been changed as of the problem starting last night???

Houston if you wanna take a look, i'll give you my info...I'm going crazy over here...everything likes good!?

come on guys, just like "short circuit" i need more..."INPUT"

Ryan

If you PM me your cpanel login, I'll take a quick look.... won't make any promises though.

Line 83 of DB.INC points to the Cache.

Line 83 function getParam( $param_name, $use_cache = true ) {
    return $GLOBALS['MySQL']->getParam($param_name, $use_cache);
}

Verify/chmod permissions to 755 or 777 for  /cache and /cache_public  and see if that corrects the issue.

Syde

Congrats, I see it's back up, what was the issue?

Your site seems to have magically fixed itself.

BACK UP!!! just got off the phone with arvixe support and they said while installing scripts and databases lastnight....i used the same username and password as i have assigned to my D7 newbusinessfriends.com site and thats what started this mess. I really honestly don't know if thats the trust or not but as long as i'm back up. so I wanna give a BIG THANKS to everyone who tried to hook me up!!!! THANK YOU GUYS!!!!

Error

Database connect failed

Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/churdle/public_html/furriesxtreme/inc/classes/BxDolDb.php on line 431

Fatal error: Call to a member function getParam() on a non-object in /home/churdle/public_html/furriesxtreme/inc/db.inc.php on line 83

----------------------------------------------------------------------

I'm getting this too! Yesterday anything we clicked on, this (above) was all that showed up.. Arvixe recently moved my network from shared hosting to a dedicated server, so I wasn't sure if the install went bad or something, or if it was something else...

So I sent a ticket last night and paniced lol. Today however, most of the issue is gone, we still get the error once every few clicks or so, but after a refresh, the error is gone.. The helpful team at Arvixe said all they did was add the domain to the list in the RMS mod and that seemed to do the trick. Tho, like I said, I still get it, so I thought I'd do a search here to see if anyone else had the issue.. I sent another ticket into Arvixe too..

Mine was working fine before this too, so I hope mine goes away magically as well! lol :)

possible solution? http://www.boonex.com/unity/forums/?action=goto&search=1#topic/DB-error-in-my-site.htm

Actually, I have the exact issue as Shymatsi...my perfectly working D7 site was migrated to another server yesterday and been getting database errors very sporatically all day, and finally my site went down just now with error "Fatal error: Call to a member function getParam() on a non-object in /home/ethiomys/public_html/inc/db.inc.php on line 83"

My host (HFW) is claiming to have the scripts checked by Boonex and nothing they can do from their end....so pls post any solution if there is one to try. I will post mine if I resolve it too.

Thx

Perhaps we need an instruction set for migrating.. cause while I expect Arvixe to know how to do their job, it's hard for them I'm sure if there isn't any documentation from BoonEx on the issue :/ As it's BoonEx's software..

If there is, can someone point me to it? I can't find it..

I'm still getting this issue with almost every other click. :(

I'm curious.... How many members do you have on your site?

Now I got this today when trying to go on look at my Database settings in PHP MyAdmin

-------------

phpMyAdmin - Error

#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)

-------------

Is there anything I can do about that, or is that Arvixe's side?

looking up the two lines:

-----------------

Line 431 reads:

$sMailBody .= "Mysql error: " . mysql_error($this->link) . "<br /><br /> ";

--- and Line 83 reads:

return $GLOBALS['MySQL']->getParam($param_name, $use_cache);

So far just 720

3100 other users are waiting till all the bugs are worked out before they move over.. :(

Just got off the phone with Arvixe.  They took a look at my server and saw that the site was hitting XML.php and member_menu_queries.php hundreds of times each, bogging my site down and using up all of my Dedicated server's resources!

After renaming these two files, my site is now lightening fast and so far so good, no more DB connection failed errors..

Anyone have any clues about this? Anyone know what member_menu_queries.php does? I see now that the XML.php file is for the Ray modules, as none of the Ray products work right now while it's renamed.

here are the notes from tonight's call with Arvixe that I had:

------------------------------------------

Posted On: 28 Jan 2010 10:04 PM

Greetings,

Your XML.php file was being hammered.

I went into your server and renamed XML.php to xml.php.baks to bring the load down on the server. Here are the stats before I renamed the file:

top - 21:49:28 up 4 days, 23:28, 1 user, load average: 20.24, 18.81, 19.74

Tasks: 313 total, 10 running, 302 sleeping, 1 stopped, 0 zombie

Cpu(s): 0.0%us, 19.7%sy, 79.4%ni, 0.0%id, 0.0%wa, 0.2%hi, 0.7%si, 0.0%st

Mem: 2075256k total, 1643272k used, 431984k free, 56396k buffers

Swap: 4128664k total, 80k used, 4128584k free, 835772k cached

16526 12440 churdle 508 19 4 40644 24m 6444 R 12.9 1.2 0:00 /usr/bin/php /home/churdle/public_html/furriesxtreme/profile.php

25948 25924 mysql 101 31 6 163m 40m 5112 R 4.1 2.0 154:16 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/churdle2.ded

16480 15594 churdle 508 20 4 31908 15m 6356 R 2.3 0.7 0:00 /usr/bin/php /home/churdle/public_html/furriesxtreme/flash/XML.php

16529 12438 churdle 508 23 4 26372 11m 5840 S 2.3 0.6 0:00 /usr/bin/php /home/churdle/public_html/furriesxtreme/flash/XML.php

16536 12279 churdle 508 21 4 26372 11m 5832 S 2.3 0.6 0:00 /usr/bin/php /home/churdle/public_html/furriesxtreme/flash/XML.php

16537 8417 churdle 508 21 4 26372 11m 5832 S 2.3 0.6 0:00 /usr/bin/php /home/churdle/public_html/furriesxtreme/flash/XML.php

16552 4591 churdle 508 21 4 26372 11m 5860 S 2.3 0.6 0:00 /usr/bin/php /home/churdle/public_html/furriesxtreme/flash/XML.php

16561 14103 churdle 508 21 4 26372 11m 5832 S 2.3 0.6 0:00 /usr/bin/php /home/churdle/public_html/furriesxtreme/flash/XML.php

16562 6484 churdle 508 21 4 26372 11m 5832 S 2.3 0.6 0:00 /usr/bin/php /home/churdle/public_html/furriesxtreme/flash/XML.php

16563 15609 churdle 508 22 4 26372 11m 5836 S 2.3 0.6 0:00 /usr/bin/php /home/churdle/public_html/furriesxtreme/flash/XML.php

16564 11229 churdle 508 23 4 26372 11m 5832 S 2.3 0.6 0:00 /usr/bin/php /home/churdle/public_html/furriesxtreme/modules/index.php

16568 3625 churdle 508 23 4 26372 11m 5836 S 2.3 0.6 0:00 /usr/bin/php /home/churdle/public_html/furriesxtreme/flash/XML.php

16572 14081 churdle 508 23 4 26372 11m 5836 S 2.3 0.6 0:00 /usr/bin/php /home/churdle/public_html/furriesxtreme/flash/XML.php

16587 12212 churdle 508 21 4 26372 11m 5860 S 2.3 0.6 0:00 /usr/bin/php /home/churdle/public_html/furriesxtreme/flash/XML.php

16588 379 churdle 508 23 4 26372 11m 5860 S 2.3 0.6 0:00 /usr/bin/php /home/churdle/public_html/furriesxtreme/flash/XML.php

16589 3698 churdle 508 21 4 26372 11m 5856 S 2.3 0.6 0:00 /usr/bin/php /home/churdle/public_html/furriesxtreme/flash/XML.php

16590 13968 churdle 508 23 4 26372 11m 5852 S 2.3 0.6 0:00 /usr/bin/php /home/churdle/public_html/furriesxtreme/member_menu_queries.php

16591 1277 churdle 508 21 4 26372 11m 5836 S 2.3 0.6 0:00 /usr/bin/php /home/churdle/public_html/furriesxtreme/flash/XML.php

16593 13829 churdle 508 23 4 26372 11m 5836 S 2.3 0.6 0:00 /usr/bin/php /home/churdle/public_html/furriesxtreme/flash/XML.php

16594 9832 churdle 508 29 4 26372 11m 5836 S 2.3 0.6 0:00 /usr/bin/php /home/churdle/public_html/furriesxtreme/flash/XML.php

16595 32438 churdle 508 21 4 26372 11m 5860 S 2.3 0.6 0:00 /usr/bin/php /home/churdle/public_html/furriesxtreme/flash/XML.php

16596 15913 churdle 508 22 4 26372 11m 5840 S 2.3 0.6 0:00 /usr/bin/php /home/churdle/public_html/furriesxtreme/flash/XML.php

16604 13833 churdle 508 21 4 26372 11m 5864 S 2.3 0.6 0:00 /usr/bin/php /home/churdle/public_html/furriesxtreme/flash/XML.php

16605 11210 churdle 508 21 4 26372 11m 5836 S 2.3 0.6 0:00 /usr/bin/php /home/churdle/public_html/furriesxtreme/flash/XML.php

16606 22764 churdle 508 21 4 26372 11m 5836 S 2.3 0.6 0:00 /usr/bin/php /home/churdle/public_html/furriesxtreme/flash/XML.php

16608 15568 churdle 508 23 4 26372 11m 5836 S 2.3 0.6 0:00 /usr/bin/php /home/churdle/public_html/furriesxtreme/flash/XML.php

16610 15610 churdle 508 23 4 26372 11m 5836 S 2.3 0.6 0:00 /usr/bin/php /home/churdle/public_html/furriesxtreme/flash/XML.php

16535 1871 churdle 508 24 4 26372 11m 5856 S 1.8 0.6 0:00 /usr/bin/php /home/churdle/public_html/furriesxtreme/flash/XML.php

16560 5452 churdle 508 20 4 26372 11m 5836 S 1.8 0.6 0:00 /usr/bin/php /home/churdle/public_html/furriesxtreme/flash/XML.php

16565 26488 churdle 508 23 4 26372 11m 5860 S 1.8 0.6 0:00 /usr/bin/php /home/churdle/public_html/furriesxtreme/flash/XML.php

16566 3168 churdle 508 23 4 26372 11m 5860 S 1.8 0.6 0:00 /usr/bin/php /home/churdle/public_html/furriesxtreme/flash/XML.php

16567 15643 churdle 508 21 4 26372 11m 5836 S 1.8 0.6 0:00 /usr/bin/php /home/churdle/public_html/furriesxtreme/flash/XML.php

After renaming this file, your MySQL issues went away and you was once again able to access PHPMyAdmin.

Shymati, I'm glad you pin-ponited the issue it being in the script rather than the host. I myself couldn't still resolve my random DB errors that I receive similar to this:

Database error in

Query:

SELECT `id`, `title`, `vendor`, `version`, `update_url`, `path`, `uri`, `class_prefix`, `db_prefix`, `date` FROM `sys_modules` WHERE `uri`='simple_messenger' LIMIT 1

Mysql error: MySQL server has gone away

Found error in the file '/home/ethiomys/public_html/inc/classes/BxDolModuleDb.php' at line 46.
Called 'fromMemory' function with erroneous argument #2.

My host cecked and double checked but still blame the script, and I tried all Boonex solutions but I'm still stuck too. So, I'm going to try renaming files and see how that goes before my site goes down again. Thanks again for posting your solution.

Yeah, my site now runs amazingly now that the Ray files aren't being accessed! But my members can't post videos, can't chat or use the boards! :(

I need the Ray XML file fixed soon! BoonEx, please help!

Hey,

Quick question as I just got this problem yesterday..

I only have the problem when at the site on Safari but IE 8 loads the site no problem.  So my problem actually seems to ocurr because of the browser I'm using??? Safari???

How many people are on safari/macs that have this problem, any IE users having this problem?  If all safari/macs which version??

Just curious as I only get it when I check the site with Safari...

Ok, I'm totally confused now...

Logged onto my site with safari this morning and it loaded with no problems at all... Where is the logic...

A day and a half of DB error and then evrything back to normal but only when viewing the site with safari????

Site is back up on safari, but sure would be good to find out why this happens only with safari, well, at least only on safari for me.

ANSWER TO Fatal error: Call to a member function getParam() on a non-object in /inc/db.inc.php on line 83

This is old but It seemed to be the only place that kept showing up when I searched the error. but here is the answer:

Based on the fact that the majority of content added to your dolphin site is sql based i found this answer

you need root access to the main etc folder before home/user/public_html but if u do and u have access to "my.cnf" so etc/my.cnf then edit that folder and increase your "max_connections ="

mine was 500 so i doubled it to 1000. now my site only has 700 members and im on a vps server so we'll see how it goes. so far it completly sped up my sites slugishness and haven't had any errors or non connections or even time-outs

http://smoke-out-family.com

 ya this did help however xml.php still crashes my vps. aparently not one person has been answered to by boonex on if its ever gonna get fixed however they have announced they are scrapping D7 but still releasing 7.07 even disabling AVChat desktop and messenger didnt do a thing. /usr/bin/php along with flash/xml.php is  the issue and it doesn't look like its gonna get fixed. so does this mean that we get free updates to d8 with all the mods for d7 working??...u can dream. I will neway I just put tons of money into switching to dolphin.

OK, I have been having this issue for a few days. Dunno what changed, if anything.

Thanks to everyone for suggestions upthread.

I tried the various remedies but Smokeout was on the right track -at least messing with the my.cnf file gave a solution.

I run a dedicated server and have upgraded twice since 2008 and guess what we NEVER changed?

Yepperz!

Although the RAM has increased fourfold the settings were for a much less well specced server.

I had to add the 'max connections' parameter, it was not present, but that on its own did not do the trick. I upped everything else along the way.

If there are any mySQL mavens out here reading I'd be happy to pay somebody to have a look at my database setup and maybe do some optimisation work.

The stuff I did was the result of 5 minutes with Google and I can see an error log that is YAAAAAAAAY long so there is more to do.