<div dir="ltr"><div class="gmail_extra"><div class="gmail_quote">On Wed, Jul 26, 2017 at 6:01 PM, François Bertel <span dir="ltr"><<a href="mailto:fbopensource@gmail.com" target="_blank">fbopensource@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div><div><div>Hi Zack,<br><br>The output is empty:<br><br>$ sudo -u mypostgresuser psql cdash mypostgresuser<br>cdash=# \conninfo<br>You are connected to database "cdash" as user "mypostgresuser" via socket in "/var/run/postgresql" at port "5432".<br>cdash=# SELECT buildin FROM buildupdate<br><br></div><div>I also tried build2update instead buildupdate (is it a typo?) but this gives the same empty line.<br></div><div><br></div>Note that the section in github that you are pointing at is the master branch. I compared it with the Release-2-2-2 tag: I don't see much difference besides styling/formatting with some extra whitespaces added to master, notably at the pdo_query() line.<br><br></div>master:<br><span class="m_-4197685853151710814gmail-pl-s1"><span class="m_-4197685853151710814gmail-pl-s"><span class="m_-4197685853151710814gmail-pl-pds"></span><span class="m_-4197685853151710814gmail-pl-s1"><span class="m_-4197685853151710814gmail-pl-k"></span><span class="m_-4197685853151710814gmail-pl-k"></span><span class="m_-4197685853151710814gmail-pl-s"></span></span><span class="m_-4197685853151710814gmail-pl-pds"></span></span><span class="m_-4197685853151710814gmail-pl-k"></span><span class="m_-4197685853151710814gmail-pl-smi"></span><span class="m_-4197685853151710814gmail-pl-s"><span class="m_-4197685853151710814gmail-pl-pds"></span><span class="m_-4197685853151710814gmail-pl-pds"></span></span><span class="m_-4197685853151710814gmail-pl-k"></span><span class="m_-4197685853151710814gmail-pl-s"><span class="m_-4197685853151710814gmail-pl-pds"></span><span class="m_-4197685853151710814gmail-pl-pds"></span></span><span class="m_-4197685853151710814gmail-pl-k"></span><span class="m_-4197685853151710814gmail-pl-smi"></span><span class="m_-4197685853151710814gmail-pl-s"><span class="m_-4197685853151710814gmail-pl-pds"></span><span class="m_-4197685853151710814gmail-pl-pds"></span></span><span class="m_-4197685853151710814gmail-pl-k"></span><span class="m_-4197685853151710814gmail-pl-s"><span class="m_-4197685853151710814gmail-pl-pds"></span></span></span></div><span class="m_-4197685853151710814gmail-pl-s1">pdo_query(<span class="m_-4197685853151710814gmail-pl-s"><span class="m_-4197685853151710814gmail-pl-pds">"</span><span class="m_-4197685853151710814gmail-pl-s1"><span class="m_-4197685853151710814gmail-pl-k">INSERT INTO</span> build2update (buildid,updateid) <span class="m_-4197685853151710814gmail-pl-k">VALUES</span> (<span class="m_-4197685853151710814gmail-pl-s">'</span></span><span class="m_-4197685853151710814gmail-pl-pds">"</span></span> <span class="m_-4197685853151710814gmail-pl-k">.</span> <span class="m_-4197685853151710814gmail-pl-smi">$query_array</span>[<span class="m_-4197685853151710814gmail-pl-s"><span class="m_-4197685853151710814gmail-pl-pds">'</span>buildid<span class="m_-4197685853151710814gmail-pl-pds">'</span></span>] <span class="m_-4197685853151710814gmail-pl-k">.</span> <span class="m_-4197685853151710814gmail-pl-s"><span class="m_-4197685853151710814gmail-pl-pds">"</span>','<span class="m_-4197685853151710814gmail-pl-pds">"</span></span> <span class="m_-4197685853151710814gmail-pl-k">.</span> <span class="m_-4197685853151710814gmail-pl-smi">$query_array</span>[<span class="m_-4197685853151710814gmail-pl-s"><span class="m_-4197685853151710814gmail-pl-pds">'</span>buildid<span class="m_-4197685853151710814gmail-pl-pds">'</span></span>] <span class="m_-4197685853151710814gmail-pl-k">.</span> <span class="m_-4197685853151710814gmail-pl-s"><span class="m_-4197685853151710814gmail-pl-pds">"</span>')<span class="m_-4197685853151710814gmail-pl-pds">"</span></span>);</span><br>Release-2-2-2:<br><div><div><div>pdo_query("INSERT INTO build2update (buildid,updateid) VALUES ('".$query_array['buildid']."'<wbr>,'".$query_array['buildid']."'<wbr>)");<br></div></div></div></div></blockquote><div><br></div><div>Great, sounds like that section worked then.  The idea behind this upgrade step was to remove the "buildid" column from the "buildupdate" table and store this info in "build2update" instead.</div><div><br></div><div>Still, I'm not sure why the upgrade step errored out for you.  Maybe try clicking the "Upgrade CDash" button again to see if this behavior repeats itself?</div></div></div></div>