this just came in on the Boinc Dev mail list:

this had me waste another Saturday!

I guess there are two fields added to host that aren't in the schema (but
are in boinc_db.h) -- two doubles for cpu_efficiency &
duration_correction_factor

I put them in the right place using "alter table..." but one odd caveat is
that the boinc_db.C isn't very forgiving for NULL values in the tables, so
my trickles kept falling over and the cgi was exiting early etc.

a more "null-friendly" way to do things in boinc_db.C (which I did for the
host table entries) follows, as I believe atof is falling over on the
NULL entry for atof or strcpy2, not quite sure which but things work now
using the following):

DB_HOST::db_parse(MYSQL_ROW &r) {
...
...
cpu_efficiency = r[i] ? atof(r[i]) : 0.0f;
i++;
duration_correction_factor = r[i] ? atof(r[i]) : 0.0f;
i++;
...
strcpy2(host_cpid, r[i] ? r[i] : "");
i++;
...
...
}


--
Carl Christensen http://www.climateprediction.net
Oxford University Dept. of Atmospheric, Oceanic, and Planetary Physics
Oxford OX1 3PU Office: +44 (0)1865 272 342
United Kingdom Mobile: +44 (0)7791 591 955

Don't know who Carl is, but thought you might


tony

---

A bit of a mess really, but sometimes things have to get worse before they can get better.

CPDN really is having more than their share of problems the past few months and make the problems over here at S@H look minor in comparison. Hopefully things won't get too much worse before they get better or they'll really start to lose a noticable amount of participants in the project.

---

To truly explore, one must keep an open mind...

Even though the news at the CPDN & BOINC Synergy sites state that CPDN is "up and running"... there is a problem connecting, thru the website and thru the BOINC CC. After receiving this message: Warning: main(../project/project.inc): failed to open stream: No such file or directory in /websites/boinc/projects/cpdnboinc/html/inc/util.inc on line 4

Fatal error: main(): Failed opening required '../project/project.inc' (include_path='.:/usr/local/lib/php') in /websites/boinc/projects/cpdnboinc/html/inc/util.inc on line 4

Chris ("crandles") wrote: I cannot get any of the BOINC pages (climateapps2.oucs.ox.ac.uk/...) to display anything other than error messages at present.

It is unfortunate that Tolu has been off ill this week. I am sure Carl has made some progress with sorting out some issues with the database and optimising it for speed and efficiency. It appears something has gone wrong just after Carl left on Friday night which is unfortunate timing I can only say I hope it is just some minor issue which will be fixed on Monday if not before.

The team have done much better this last week in keeping us informed, despite that last news item saying servers are up being somewhat at odds with the real position.

A bit of a mess really, but sometimes things have to get worse before they can get better.

Sorry about this, I think we have to be patient again for a few more days.

Chris

I hope that this helps,

James