search

GemsTracker / gemstracker-library

GEneric Medical Survey Tracker, main library
http://gemstracker.org
BSD 3-Clause "New" or "Revised" License
6 stars 2 forks source link

Token overview by period creates an error #706

Closed roelfaber closed 2 years ago

roelfaber commented 2 years ago

Starting Overview - By Period generates a fatal error.

roelfaber commented 2 years ago

Might be due to an old server installation (PHP 5.6) and/or our custom layer. Fatal error: Uncaught exception 'Zend_Db_Statement_Mysqli_Exception' with message 'Mysqli statement execute error : Subquery returns more than 1 row' in /data/www/lib/191p2/vendor/shardj/zf1-future/library/Zend/Db/Statement/Mysqli.php:214

roelfaber commented 2 years ago

Complete error message: Fatal error: Uncaught exception 'Zend_Db_Statement_Mysqli_Exception' with message 'Mysqli statement execute error : Subquery returns more than 1 row' in /data/www/lib/191p2/vendor/shardj/zf1-future/library/Zend/Db/Statement/Mysqli.php:214 Stack trace: #0 /data/www/lib/191p2/vendor/shardj/zf1-future/library/Zend/Db/Statement.php(303): Zend_Db_Statement_Mysqli->_execute(Array) #1 /data/www/lib/191p2/vendor/shardj/zf1-future/library/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array) #2 /data/www/lib/191p2/vendor/shardj/zf1-future/library/Zend/Db/Select.php(711): Zend_Db_Adapter_Abstract->query(Object(Zend_Db_Select)) #3 /data/www/lib/191p2/vendor/magnafacta/mutil/src/MUtil/Db/Iterator/SelectIterator.php(95): Zend_Db_Select->query() #4 /data/www/lib/191p2/vendor/magnafacta/mutil/src/MUtil/Db/Iterator/SelectIterator.php(160): MUtil_Db_Iterator_SelectIterator->_initStatement() #5 [internal function]: MUtil_Db_Iterator_SelectIterator->rewind() #6 /data/www/lib/191p2/vendor/magnafacta/mutil/src/MUtil/Model/Model in /data/www/lib/191p2/vendor/shardj/zf1-future/library/Zend/Db/Statement/Mysqli.php on line 214

mddejong commented 2 years ago

This happens with an empty installation, so either the code does not take this situation into account or it is mysql version error.

mddejong commented 2 years ago

This error is caused by there not being any allowed organisations and this renders the select queries unreadable.

mddejong commented 2 years ago

Ho Roel,

Voor zover ik gezien heb, heb ik alles gefixed, m.u.v. de DossierExport PDF generatie. Ik heb in dat issue (https://github.com/GemsTracker/gemstracker-library/issues/708) wel wat toelichting gezet met mogelijke oorzaak en oplossingen.

De nieuwe release is deze geworden: https://github.com/GemsTracker/gemstracker-library/releases/tag/1.9.1-p5

Met vriendelijke groet,

Matijs de Jong

M +31 (0)6 21 543221

T +31 (0)10 8910902

Skype: matijsdejong

Teams: @. @.>

Zoom: @. @.>

From: roelfaber @.> Sent: dinsdag 5 april 2022 15:40 To: GemsTracker/gemstracker-library @.> Cc: Subscribed @.***> Subject: Re: [GemsTracker/gemstracker-library] Token overview by period creates an error (Issue #706)

Complete error message: Fatal error: Uncaught exception 'Zend_Db_Statement_Mysqli_Exception' with message 'Mysqli statement execute error : Subquery returns more than 1 row' in /data/www/lib/191p2/vendor/shardj/zf1-future/library/Zend/Db/Statement/Mysqli.php:214 Stack trace: #0 /data/www/lib/191p2/vendor/shardj/zf1-future/library/Zend/Db/Statement.php(303): Zend_Db_Statement_Mysqli->_execute(Array) #1 https://github.com/GemsTracker/gemstracker-library/issues/1 /data/www/lib/191p2/vendor/shardj/zf1-future/library/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array) #2 https://github.com/GemsTracker/gemstracker-library/issues/2 /data/www/lib/191p2/vendor/shardj/zf1-future/library/Zend/Db/Select.php(711): Zend_Db_Adapter_Abstract->query(Object(Zend_Db_Select)) #3 https://github.com/GemsTracker/gemstracker-library/issues/3 /data/www/lib/191p2/vendor/magnafacta/mutil/src/MUtil/Db/Iterator/SelectIterator.php(95): Zend_Db_Select->query() #4 https://github.com/GemsTracker/gemstracker-library/issues/4 /data/www/lib/191p2/vendor/magnafacta/mutil/src/MUtil/Db/Iterator/SelectIterator.php(160): MUtil_Db_Iterator_SelectIterator->_initStatement() #5 https://github.com/GemsTracker/gemstracker-library/issues/5 [internal function]: MUtil_Db_Iterator_SelectIterator->rewind() #6 https://github.com/GemsTracker/gemstracker-library/issues/6 /data/www/lib/191p2/vendor/magnafacta/mutil/src/MUtil/Model/Model in /data/www/lib/191p2/vendor/shardj/zf1-future/library/Zend/Db/Statement/Mysqli.php on line 214

— Reply to this email directly, view it on GitHub https://github.com/GemsTracker/gemstracker-library/issues/706#issuecomment-1088716929 , or unsubscribe https://github.com/notifications/unsubscribe-auth/ADIGRPQQ5SR47ABVWUCFIPLVDQ7BXANCNFSM5R3B6AEQ . You are receiving this because you are subscribed to this thread. https://github.com/notifications/beacon/ADIGRPUJLOB45YAUDESDZ2TVDQ7BXA5CNFSM5R3B6AE2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOIDSIBAI.gif Message ID: @.***>

mddejong commented 2 years ago

This problem was caused because the use of an older MYUtil library. Fixed it so it is no longer a problem.