MantisBT - CDash |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0007050 | CDash | | public | 2008-05-19 10:56 | 2008-05-27 18:58 |
|
| Reporter | F Wheeler | |
| Assigned To | Julien Jomier | |
| Priority | normal | Severity | minor | Reproducibility | always |
| Status | closed | Resolution | fixed | |
| Platform | | OS | | OS Version | |
| Product Version | 1.2 | |
| Target Version | | Fixed in Version | 1.0 | |
|
| Summary | 0007050: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource |
| Description | I get the following warnings at the top of the dashboard page (http://myhost.com/cdash/index.php?project=GEVXL [^]) from a new installation of CDash:
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /usr/home/wheeler/cdash/CDash/index.php on line 496
... the warning is repeated for lines 502, 530, 543, 556, 572
It looks like I get a set of the above 6 identical warnings for each build on the dashboard, though so far I've only seen the dashboard with 0, 1, and now 2 builds total.
This may have something to do with this warning I get on the main CDash page (http://host.com/cdash/index.php [^]). But I don't see anything on the Administration panel that might upgrade the database structure.
" The current database schema doesn't match the version of CDash you are running, upgrade your database structure in the Administration panel of CDash."
Here is some version information:
CDash from the svn trunk, revision 953
FreeBSD 6.2-RELEASE-p9
apache-2.2.3
mysql-server-5.1.22
php5-5.2.5
php5-mysql-5.2.6
libxslt-1.1.22_1
php5-xsl-5.2.6
gd-2.0.33_4,1
php5-gd-5.2.6
curl-7.18.0
php5-curl-5.2.6
Thanks,
Fred Wheeler
|
| Steps To Reproduce | |
| Additional Information | This is how I created the database ...
mysql -u root
create database cdash;
show databases;
GRANT ALL ON cdash.* TO cdash@localhost IDENTIFIED BY "********";
quit;
Changes made to config.php
// Login for MySQL database access
-$CDASH_DB_LOGIN = 'root';
+$CDASH_DB_LOGIN = 'cdash';
// Password for MySQL database access
-$CDASH_DB_PASS = '';
+$CDASH_DB_PASS = '********';
// Default from email
-$CDASH_EMAILADMIN = 'admin@cdash.org';
-$CDASH_EMAIL_FROM = 'admin@cdash.org';
-$CDASH_EMAIL_REPLY = 'noreply@cdash.org';
+$CDASH_EMAILADMIN = 'wheeler@research.ge.com';
+$CDASH_EMAIL_FROM = 'wheeler@research.ge.com';
+$CDASH_EMAIL_REPLY = 'wheeler@research.ge.com';
// Name of the server running CDash.
|
| Tags | No tags attached. |
| Relationships | |
| Attached Files | |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2008-05-19 10:56 | F Wheeler | New Issue | |
| 2008-05-19 11:01 | Julien Jomier | Status | new => assigned |
| 2008-05-19 11:01 | Julien Jomier | Assigned To | => Julien Jomier |
| 2008-05-19 11:04 | Julien Jomier | Note Added: 0011994 | |
| 2008-05-19 11:14 | F Wheeler | Note Added: 0011995 | |
| 2008-05-19 11:20 | Julien Jomier | Note Added: 0011996 | |
| 2008-05-19 12:19 | F Wheeler | Note Added: 0012001 | |
| 2008-05-19 14:27 | F Wheeler | Note Added: 0012002 | |
| 2008-05-19 14:42 | F Wheeler | Note Added: 0012004 | |
| 2008-05-19 15:21 | Julien Jomier | Note Added: 0012007 | |
| 2008-05-19 15:25 | Julien Jomier | Note Added: 0012008 | |
| 2008-05-19 15:28 | F Wheeler | Note Added: 0012009 | |
| 2008-05-19 15:48 | F Wheeler | Note Added: 0012010 | |
| 2008-05-19 16:29 | Julien Jomier | Note Added: 0012012 | |
| 2008-05-27 18:58 | Julien Jomier | Status | assigned => closed |
| 2008-05-27 18:58 | Julien Jomier | Note Added: 0012133 | |
| 2008-05-27 18:58 | Julien Jomier | Resolution | open => fixed |
| 2008-05-27 18:58 | Julien Jomier | Fixed in Version | => 1.0 |
|
Notes |
|
|
(0011994)
|
|
Julien Jomier
|
|
2008-05-19 11:04
|
|
|
We are experimenting with new features. The SVN might not be stable. Could you try a SVN update (as of now) and a fresh install? Thanks for the report. |
|
|
|
(0011995)
|
|
F Wheeler
|
|
2008-05-19 11:14
|
|
I did an svn update and got this:
% svn update
U sql/cdash.sql
U backwardCompatibilityTools.php
Updated to revision 955.
I doubt this is needed, but for good measure I also restarted Apache:
apachectl restart
The problem persists. No change.
You asked me to do a "fresh install". What does this mean? Should I wipe the existing cdash database in mysql, and restart from there?
I'd also be perfectly happy reverting my cdash to release 1.0 if you think that makes more sense at this time.
Thanks,
Fred Wheeler |
|
|
|
(0011996)
|
|
Julien Jomier
|
|
2008-05-19 11:20
|
|
Was it a CDash upgrade? or a fresh install? if this is a CDash upgrade then you should login as admin, and go to "backward compatibility tools" and click on "Upgrade CDash".
However, if you can wait a little bit (end of the day) before doing so, I need to test to make sure the new features are working as expected. |
|
|
|
(0012001)
|
|
F Wheeler
|
|
2008-05-19 12:19
|
|
I did a fresh install of CDash this morning and created a project in CDash for "GEVXL". Later, I did a svn update.
It's not clear to me what clicking "Upgrade CDash" would do. I'm not sure whether that would just svn update, look for a newer release, or something else, so I never clicked it. |
|
|
|
(0012002)
|
|
F Wheeler
|
|
2008-05-19 14:27
|
|
I just tried clicking "Upgrade CDash" --- I just couldn't wait. The upgrade seemed to go smoothly, printing this:
Upgrading tables:
Applying 0.8 patches:
Applying 1.0 patches:
Applying 1.2 patches:
CDash Upgrade Successful.
Now, on the main project dashboard page (http://myhost.com/cdash/index.php?project=GEVXL [^]) I get the warning below repeated 3 times, apparently once for each build (there are only 3 continuous builds) currently reported on the dashboard. So this is a 6-to1 reduction in the number of warnings.
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /usr/home/wheeler/cdash/CDash/index.php on line 449
This is a new line number (449) that did not appear in the original 6 warnings I saw (in original bug report).
Fred Wheeler |
|
|
|
(0012004)
|
|
F Wheeler
|
|
2008-05-19 14:42
|
|
|
I should add that for the previous note CDash is at revision 956 (the very latest in trunk). |
|
|
|
(0012007)
|
|
Julien Jomier
|
|
2008-05-19 15:21
|
|
|
Could you try a SVN update and see if that fixes the problem? Thanks for the report BTW! |
|
|
|
(0012008)
|
|
Julien Jomier
|
|
2008-05-19 15:25
|
|
|
Forgot to say that it's related with a new feature (compression of the notes) so you might find some other errors. I hope to have them fixed today. Thanks. |
|
|
|
(0012009)
|
|
F Wheeler
|
|
2008-05-19 15:28
|
|
I just did a svn up to revision 957. And it works! Problem solved. Thanks.
(I do notice some "notes" icon links missing.)
Let me know if using the trunk version is a bad idea. Being able to svn up to revisions that correspond to releases is appealing. That's likely what I will try to do in the future. |
|
|
|
(0012010)
|
|
F Wheeler
|
|
2008-05-19 15:48
|
|
FYI, when I click on a note icon to get to a notes page I now get this warning, and I don't see the notes:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /usr/home/wheeler/cdash/CDash/viewNotes.php on line 81 |
|
|
|
(0012012)
|
|
Julien Jomier
|
|
2008-05-19 16:29
|
|
|
I'm going to fix this soon (hopefully today or tomorrow). Usually updating to SVN is not a bad idea but this feature took much longer than I expected. I'll let you know when it's fixed. Thanks! |
|
|
|
(0012133)
|
|
Julien Jomier
|
|
2008-05-27 18:58
|
|
|