-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi Sebastián,
What version of mysql/mariadb are you using? There may have been a change in behavior we need to adjust for. Thanks, Josh On Wednesday, May 20, 2020 10:24:15 AM EDT M. Sebastián Tobar wrote: > Hello, > I've a fresh VCL install and I've managed to add a "Lab Machine image". > Unfortunately, I can't make a reservation on this image. Following this > guide: > https://cwiki.apache.org/confluence/pages/viewpage.action?pageId=47385093 I > get this error: > > dojo.addClass('admingrpnote', 'hidden');Expression #1 of ORDER BY clause is > not in SELECT list, references column 'vcl.c.RAM' which is not in SELECT > list; this is incompatible with DISTINCT > SELECT DISTINCT c.id, c.currentimageid, c.imagerevisionid FROM state s, > image i LEFT JOIN OS o ON (o.id = i.OSid) LEFT JOIN OSinstalltype oi ON ( > oi.name = o.installtype) LEFT JOIN provisioningOSinstalltype poi ON > (poi.OSinstalltypeid = oi.id) LEFT JOIN computer c ON (poi.provisioningid = > c.provisioningid) LEFT JOIN semaphore se ON (c.id = se.computerid) WHERE > i.id = 8 AND c.scheduleid IN (1) AND c.platformid = 1 AND c.stateid = s.id > AND s.name NOT IN > ('maintenance','vmhostinuse','hpc','failed','timeout','inuse') AND c.RAM >= > i.minram AND c.procnumber >= i.minprocnumber AND c.procspeed >= > i.minprocspeed AND c.network >= i.minnetwork AND c.deleted = 0 AND (c.type > != 'virtualmachine' OR c.vmhostid IS NOT NULL) AND c.id IN ('1') AND c.id > IN (1,1) AND c.id NOT IN (0) AND (se.expires IS NULL OR se.expires < NOW()) > ORDER BY RAM, (c.procspeed * c.procnumber), network > ERROR(129): Failed to execute query 5 in isAvailable > > Backtrace: > =-=-=-=-=-=-=-=-=-=-=-= > Call#:1 => index.php:AJupdateWaitTime() (line#:99) > Call#:2 => requests.php:isAvailable() (line#:1989) > Call#:3 => utils.php:doQuery() (line#:4987) > ... > > Any help will be appreciated > -- > M. Sebastián Tobar - -- - ------------------------------- Josh Thompson VCL Developer North Carolina State University my GPG/PGP key can be found on pool.sks-keyservers.net All electronic mail messages in connection with State business which are sent to or received by this account are subject to the NC Public Records Law and may be disclosed to third parties. -----BEGIN PGP SIGNATURE----- iF0EARECAB0WIQRMIdRtWXideTZDK31X8tBw1209AwUCXsVFSQAKCRBX8tBw1209 Ay2DAJ9ksjGZyBpV5vGFYF2AGUkqFa316wCdEALmJAPFWshsyAY5OoNtM6Jwb8s= =Lz59 -----END PGP SIGNATURE-----
