Any news on this? I still can't see my combined stats without using the Test link you provided, and I need to load that one twice to see them.

I'm sorry, no solution. I can't reproduce it and I can't find anything wrong in the code.

Just did a search for your name, and it found your combined account without problems (or reloading).

At the time you posted this, I checked, and indeed I could get my combined stats. This persisted for a few hours.

Now, they're missing again. Could one of the project updates be knocking them out sporadically?

Also, this happens on both my home and work machines, so it's not something specific to one PC. Also, it happens with both Firefox and IE.

I have the same problem after the updates

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/boincstats/site/stats/boinc_user_graph.php on line 18

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/boincstats/site/stats/boinc_user_graph.php on line 25

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/boincstats/site/stats/boinc_user_graph.php on line 26

User CPID doesn't exist in BOINC combined stats or doesn't have any credit.


After a refresh it works fine.

Same here, when I click my forum sig (in other fora):

After a refresh everythings fine (FF on Linux).

Edit:
After an initial refresh it worked the second time on first try. Even stranger for me.

I'm wondering now if it's due to the sheer number of projects. Sanger and I both seem to have 20+ projects. This would mean our Combined Stats would be in near constant flux, since one of the projects it probably updating all the time, right?

Hi,

what does that mean?

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/boincstats/site/stats/boinc_user_graph.php on line 18

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/boincstats/site/stats/boinc_user_graph.php on line 25

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/boincstats/site/stats/boinc_user_graph.php on line 26




User CPID doesn't exist in BOINC combined stats or doesn't have any credit.

Should make any difference. My best guess is that you just happen to look at your stats whenever the BOINC combined database is updated.

This is not an update in that the table is updated with new data. The table is already updated on the database server, and after that loaded on the webserver. But, just before it is loading it, it clears out the database.
The should be locks in place that would prevent the errors you all see, so that's a thing to check.

The combined DB is a seperate DB from the individual projects, so having 20 (or more) of them won't make any difference.

On occasion I have also seen a search that missed a project or the combined account, but this was always during an update.

I might believe that I was "just happening" to hit during the update, but it's 99% of the time since May. Now, we're getting other people reporting the same problem.

That MySQL error must mean something. Any chance you're not seeing it because you've got permissions when you run the query that the web server doesn't? Googling for that error gives some cases where its a connectivity issue. Others where they suggest enclosing the field and table names in single quotes, etc. Seems like it's a generic error message that indicates a problem, but isn't very good at telling you where it really is.

I'll keep searching for an error/bug here.

About the permissions: the server doesn't give me special permissions. I just browse to the site with FF or IE, just like you. It would be kind of foolish to do such a thing, I would never be able to solve problems.

I get it even from here now (I just don't click my sig that often, so I hevn't noticed before probably). The erroneous lines are changing:


And it works the second time I click on the sig.

And the menu and shoutbox are all ok?

AFAIR yes, unfortunately I cannot repeat it yet, as after a single fault, everything's fine for the rest of the session. I don't know how long it will last, as I don't shut my puter or internet down, only FF, but a short exit and restart of FF didn't help getting it (the error) back.

That may be because I changed some small things. The fact that the rest of the site is correct gave me some ideas.

I run every project officially listed on BOINCstats and more that aren't.

I have never seen the problem people are talking about when looking at my stats

I see the error on my team stats page (but not my user stats page, although I rarely check that) the first time the page is requested each "stats day". Subsequent requests are fine for the rest of that "stats day", regardless of where I make the requests from. In this case, a "stats day" seems to start somewhere around 1900-2000 GMT which seems quite close to when the main stats are updated? The first request after that time gives me an error, even if that first request happens the following morning. Later requests during the day are fine, until the stats update comes up again.

Bump. Any news?

Willy is on holiday at the moment so probally no news as yet

Not really. Just did a search on your name and it worked fine (included combined results).

I have seen a project or combined missing on my searches as well on some occasions, but these were all related to me searching while the stats were updated. SQL should lock the query until the update is finished, but it releases the lock for a split second somewhere in the middle. I guess that’s were the problem comes from.

No resolution yet.

Hi there everyone,

My username/users/exact match for dick has not had Boinc Combined since BAM started. Any other user name I try does show Boinc Combined, including grenadier. Searching for dick without exact match does show Boinc Combined. The mysql_fetch_array error shows up only on the rare occasion, as you would expect.
I didn't really worry about this because I can access my boinc combined stats from the BOINC Cross Project IDentifier link on my project stats pages.

I have tried this on several computers with the same result.
I hope this helps.


wouldn't you guess it... I just checked my user stats page and Boinc Combined is showing.
"It wont work untill you tell someone"
Regards, Dick

I think he's on to something here Willy. If I search for other users, their BOINC Combined stats show up on my search results no problem. It's only mine that are missing 99% of the time. Also, this did start about the time BAM started up. Coincidence?

Yep. Totaly unrelated. Stats update does not work differently than before BAM!.

What about the first half of it?Where we only see the problem for our own stats? That might explain why you never have seen the problem when you do a search on me. For example, I did a search on Saenger, and got his BOINC Combined numbers, but searching for myself (Grenadier) still doesn't get me a Combined stats block.

When I do a search for myself I'm almost always getting my combined stats