View Issue Details [ Jump to Notes ] [ Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0007050CDashpublic2008-05-19 10:562008-05-27 18:58
ReporterF Wheeler 
Assigned ToJulien Jomier 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOSOS Version
Product Version1.2 
Target VersionFixed in Version1.0 
Summary0007050: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource
DescriptionI 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
Additional InformationThis 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.

TagsNo tags attached.
Attached Files

 Relationships

  Notes
(0011994)
Julien Jomier (manager)
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 (reporter)
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 (manager)
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 (reporter)
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 (reporter)
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 (reporter)
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 (manager)
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 (manager)
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 (reporter)
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 (reporter)
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 (manager)
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 (manager)
2008-05-27 18:58

 Should be fixed now.

 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

Copyright © 2000 - 2018 MantisBT Team