[Cdash] cdash 1.4.2 fails to install on postgresql 8.3

[Julien Jomier]

Hi John,

Thanks for the report, apparently this one was still not fixed in the 
SVN head. If you can, would you mind checkout CDash from SVN head and 
give it a try (I just committed a fix)?
Fixing this error in 1.4.2 is possible but if you can beta test CDash 
1.6 (to be release early January) that would be great. The SVN head 
should be fairly stable from a fresh install.

Let me know if that's too much trouble,
Julien

John Calixto wrote:
> Hi Julien,
> 
> Thanks for the quick turnaround.  I managed to get cdash installed with your install.php.  However, I have an issue with the code coverage module - I'll describe it and maybe you can tell me if it's related to pgsql db initialization.
> 
> Repro Steps
> -----------
> 1. Click on a Coverage Percentage link for a test run
> 2. Click on a source code file link to view the line-by-line coverage
> 3. For the postgresql-backed cdash instance, observe that instead of the annotated source code, you see something like:
> 
>     Resource id #19
> 
> FWIW, I have a cdash instance pointed at a temporary MySQL server for comparison.  I installed cdash using your latest install.php, add an identical project using the UI, and ran the same ``make Experimental`` from my build (just pointed at the new cdash instance), and I got the expected result - a source file with the coverage annotations on the left.
> 
> Thanks for any insight you may have on this one,
> John
> 
> -----Original Message-----
> From: Julien Jomier [mailto:julien.jomier at kitware.com]
> Sent: Wednesday, December 23, 2009 12:00 PM
> To: John Calixto
> Cc: cdash at public.kitware.com
> Subject: Re: [Cdash] cdash 1.4.2 fails to install on postgresql 8.3
> 
> Hi John,
> 
> There was a bug in the install script for PostGreSQL. I have attached a new install.php file that you should replace and rerun the install script (drop the database before).
> 
> Let me know if that works,
> Julien
> 
> John Calixto wrote:
>> Hello folks,
>>
>> I'm trying to install CDash with a postgresql 8.3.8 backend, install.php fails with:
>>
>>     ERROR: cannot insert multiple commands into a prepared statement
>>
>> I'm not sure which query failed.  When I inspect the db using psql, I see many tables, but I see an empty ``user`` table and an empty ``version`` table.
>>
>> Can somebody help direct my investigation of this issue?
>>
>> Thanks,
>>
>> John
>>
>> This message contains information which is confidential and privileged.  Unless you are the addressee (or authorized to receive for the addressee), you may not use, copy or disclose to anyone the message or any information contained in the message. If you have received the message in error, please advise the sender by reply e-mail and delete the message.
>> _______________________________________________
>> Cdash mailing list
>> Cdash at public.kitware.com
>> http://public.kitware.com/cgi-bin/mailman/listinfo/cdash
>>
> 
> This message contains information which is confidential and privileged.  Unless you are the addressee (or authorized to receive for the addressee), you may not use, copy or disclose to anyone the message or any information contained in the message. If you have received the message in error, please advise the sender by reply e-mail and delete the message.
>