If you are on a shared server, or, as in many hosting situations even when you have your own server, you are on a shared database server, it might well be another website that is bringing that shared database server down.
Anyway, we'll see what your provider comes up with. >I haven't changed any php except small changes to LocalSettings.php last >week, but it was nothing related to this. > >My traffic hat not spiked recently but I do have my host looking at the >issue. Thanks for the tips. > >Anything else on the issue would be appreciated. > > > >On Thu, Feb 12, 2009 at 11:43 AM, Manfred Kooistra ><[email protected]>wrote: > >> Line 826 (in my code) is this: >> >> $s = $dbr->selectRow( 'user', '*', array( 'user_id' => $this->mId ), >> __METHOD__ ); >> >> it appears to be related to a mySQL query. Usually the error you get in >> PHP means that some variable, that you try to work with, has not been >> set or is FALSE, e.g. $dbr. >> >> Reading about the connection error you get in phpMyAdmin, I'd guess that >> PHP encounters the same, when it tries to connect to your database and >> fill the variable. So I'd begin looking at your DB, _if_ you are sure >> that you have not changed anything in your PHP code! >> >> I don't know much about Apache and stuff, but I had a big problem once >> when due to a listing in some very popular web catalogue I suddenly >> recieved thousands of hits a day (compared to maybe 100 the day before). >> The increase in traffic was so intense that it brought my DB down. I >> solved the problem with making all pages static. This was possible on >> that website, simply by having a cronjob execute once each night and >> build all pages from the database. But that website was not a wiki, with >> user contribution. Anyway ... >> >> ... try and find out about the performance of your database. I don't >> know how, I had someone look at the logs and interpret them for me, and >> he installed a small script that recorded what happened on the database >> server etc., so maybe start with calling your provider and ask them >> about _their_ server and tell them that you see performance problems. >> >> Hope all this bla bla helps you! >> >> ~ Manfred >> >> >> >> >Hey all, >> > >> >About one every 5 page views mediawiki throws this error: >> > >> >Fatal error: Call to a member function selectRow() on a non-object in >> >User.php on line 826 >> > >> >I have not recently upgraded. I have been on version 1.13.3 since it was >> >released. The site was working fine until this morning and rebooting mySQL >> >didn't help. I also get a connection error every couple of loads if I >> click >> >through my databases in phpmyadmin. Does anyone know what could be wrong? >> I >> >have shell access. >> > >> >Thanks >> >_______________________________________________ >> >MediaWiki-l mailing list >> >[email protected] >> >https://lists.wikimedia.org/mailman/listinfo/mediawiki-l >> >> >> >> _______________________________________________ >> MediaWiki-l mailing list >> [email protected] >> https://lists.wikimedia.org/mailman/listinfo/mediawiki-l >> >_______________________________________________ >MediaWiki-l mailing list >[email protected] >https://lists.wikimedia.org/mailman/listinfo/mediawiki-l _______________________________________________ MediaWiki-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
