[Cdash] How to use 'add_last_sql_error()' calls to find what's wrong

[Julien Jomier]

Fabrice,

There was a bug in 1.4.1 with the Build model. It's fixed in the 1.4 branch:

   svn co https://www.kitware.com:8443/svn/CDash/Release-1-4 CDash

We are going to release the 1.4.2 patch next week. It doesn't involve 
any database modifications so should be very easy to upgrade.

Thanks again for the report, let us know if you find any issues,
Julien

Fabrice wrote:
> Re,
> 
> I was testing the email preference subscription "Email me when *my 
> checkins* are breaking the dashboard" by doing Experimental builds that 
> are not supposed to send emails, so let's forget about the empty query 
> result.
> Emails sendings when breaking dashboard work now.
> But i had to add a line in the file cdash/sendemail.php to get 
> GetNumberOfErrors() function to work:
> 
>     @@ -92,6 +92,7 @@
>        // Build errors and warnings
>        $Build = new Build();
>        $Build->Id = $buildid;
>     +  $Build->BuildId = $buildid;   
>        $errors['build_errors'] = $Build->GetNumberOfErrors();
>        $errors['build_warnings'] = $Build->GetNumberOfWarnings();
> 
> 
> Am i missing something?
> 
> 2009/5/5 Julien Jomier <julien.jomier at kitware.com 
> <mailto:julien.jomier at kitware.com>>
> 
>     Hi Fabrice,
> 
>     The 'add_last_sql_error' function only prints out in the log if the
>     SQL query returns an error. Could you check if the updatefile table
>     as an author for the given buildid?
> 
>     You can use add_log('text','function') to write directly into the logs.
> 
>     Julien
> 
>     Fabrice wrote:
> 
>         Hello all,
> 
>         My CDash version is 1.4.1.
>         I'm trying to find why i don't receive any emails when my
>         checkins are breaking the dashboard.
>         I have added some log statements in the source code and i think
>         i've targeted the problem in 'function lookup_emails_to_send()' :
> 
>            $authors = pdo_query("SELECT author FROM updatefile WHERE
>            buildid=".qnum($buildid));
>            add_last_sql_error("sendmail");
> 
> 
>         The result of the query is empty in my case.
> 
>         I can't help to notice the add_last_sql_error("sendmail") call
>         just after the query. I don't know what it's for as nothing
>         appear in the cdash.log file.
>         Is there some other log file containing all the mysql queries
>         that have failed?
> 
>         Thanks for your help
> 
> 
>         ------------------------------------------------------------------------
> 
>         _______________________________________________
>         Cdash mailing list
>         Cdash at public.kitware.com <mailto:Cdash at public.kitware.com>
>         http://public.kitware.com/cgi-bin/mailman/listinfo/cdash
> 
>