Re: [Mediawiki-l] Re(2): mySQL issue?

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 <manfred.kooistra(a)gmx.de>wrote;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

> >released. The site was working fine until this morning and rebooting

> >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

_______________________________________________ MediaWiki-l mailing list MediaWiki-l(a)lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l