I've got a bookmark that uses querystrings to specify my username, and exact match. So, for example:

http://www.boincstats.com/search/result.ph...enadier&exact=y

Since yesterday, this bookmark does not return the BOINC combined stats for my username. I only get the project stats. But, if I search using the site's search form, I get all the stats.

Any ideas?

There is a at the top. So there must be something broken.

I've seen that SQL error, but it's been sporadic. Sometimes I get it, sometimes not. The BOINC combined stats are missing regardless.

Still getting the SQL error on this.

problem is, I can't reproduce it. Line 64 is a line without DB access, so that's not a good starting point for debugging.

I deleted the cache for your search result, clicked on the search-link above and I get no SQL error but I do get your combined stats. A possible explanation would be that you happen to search during a table update, but that would mean you have a very good timing.

It's been consistent all week that I have not gotten the combined stats. I doubt I've just happened to hit an update every time, especially since it was so rare that that happened before. It also doesn't explain how Son Goku got the same MySQL error when following my link.

One way I did find to get them is to use the search form on the site, instead of my search URL. I needed to turn off exact match for that to work though, which allows someone else's results to show (similar name). Turning off exact match on the URL does not work either though.

URL, with exact - no combined stats
URL, without exact match - no combined stats
Form, with exact - no combined stats
Form, without exact - YES to combined stats

I'm trying to figure out what other info I can give to help you track this down. Any of this help?

BTW, I usually use Firefox, but tried IE with the same results.

Any news on this? I'm still getting this same error sporadically.

Now I'm getting a similar error, but on a different line number:

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

I investigated this today, made a special debug version of the search page, and then I saw it. You are using an old version of the search URL. The URL has been changed over two months ago and the F.A.Q. was updated.

The correct URL for your search is:
http://www.boincstats.com/search/result.php?name=grenadier
This does an exact search on the username 'Grenadier'.

I tried that, actually. Still not getting BOINC Combined stats, and occasionally (but not always) getting the MySQL error.

I'm sorry, but I am unable to reproduce the error.

I used a version of the search page without caching (that's the only difference from the visible script) and it finds you just fine in the combined stats.

I hit the reload button over 50 times (lost count) and I got no MySQL errors.

I made some small changed to the script, there were some points that could be improved, but these improvements only prevent errors on wrong search URL's.

Would the version I'm running be cached, such that the bad URL and it's results might show up a few times till the cahce cleared? I just reloaded from the newer URL form (30 minutes plus after the last load) and Combined stats are back now. Hopefully, that resolves it all.

Sorry for the confusion with the URL. I was wondering if it had changed somewhere along the line, which is why I included it in the first post in the first place.

Crap...they still seem to be coming and going. No SQL error right now, but no combined stats either.

Just got the MySQL error from above (line 70), even with the new form of the search URL.

Please use this search page for a while. It shows the sql query that errors out. If you get the error again, please copy the query to this thread.

1st Attempt: got my BAM ID, and a hash, and nothing else.

2nd attempt: Got the ID, the hash, and this query and error message:

SQL-query: SELECT * FROM boinc_user WHERE name = 'grenadier' LIMIT 0,10

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/boincstats/site/testing/search/result.php on line 73

Hope that helps.

-Dave

On later runs, everything works, including the Combined Stats. Actually, the Combined Stats are currently showing on my old shortcut too. Maybe this was tied to the disk space issue that locked us out of the forums?

The disk space problem was a thing of today and has never happened before (and I sure hope is never does again).

Still getting the error on the 'normal' link. The test URL seems to work more often, but I did get the MySQL error there this morning too. Are there differences between the code, or is it just the debugging code?

The only difference is that the test URL doesn't cache the result and displays a query

This is working for me pretty consistently on the SECOND page load with the test URL. The first time I load it for the session, I get the same MySQL error.

But what is the query? It's at the top of the main screen.

Already posted it earlier in this thread. It's:

SQL-query: SELECT * FROM boinc_user WHERE name = 'grenadier' LIMIT 0,10

I tried Googling for more info on the error message, but pretty much every hit suggest checking the error condition on mysql_fetch_array.

Some suggested that it's either a bad query (bad table name, for example), or a corrupt index in one of the tables. The table name thing seems unlikely, since the query does work on refresh.

-Dave

Output on the test page changed. Now I get:



The first line is different. (There used to be a hash there.) Still working on this, or was this a test for someone/something else?