Skip to content
New issue

Have a question about this project? # for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “#”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? # to your account

Upload to pre-defined "misc" media folder fails #43

Closed
DBJRdev opened this issue Dec 6, 2018 · 1 comment
Closed

Upload to pre-defined "misc" media folder fails #43

DBJRdev opened this issue Dec 6, 2018 · 1 comment
Labels
bug Something isn't working dbjr-approved

Comments

@DBJRdev
Copy link
Member

DBJRdev commented Dec 6, 2018

A fresh install of v4.11.1 on PHP 7.2 - the upload of a file to the pre-defined "misc" folder throws an error 500.

(If I understand the application.log correctly, the SQL insert wants a consultation id, but doesn't get any?)

2018-12-06T15:59:32+01:00 CRIT (2): PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '))' at line 1 in .../vendor/zendframework/zendframework1/library/Zend/Db/Statement/Pdo.php:228
Stack trace:
#0 .../vendor/zendframework/zendframework1/library/Zend/Db/Statement/Pdo.php(228): PDOStatement->execute(Array)
#1 .../vendor/zendframework/zendframework1/library/Zend/Db/Statement.php(303): Zend_Db_Statement_Pdo->_execute(Array)
#2 .../vendor/zendframework/zendframework1/library/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#3 .../vendor/zendframework/zendframework1/library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT cnslt....', Array)
#4 .../vendor/zendframework/zendframework1/library/Zend/Db/Table/Abstract.php(1577): Zend_Db_Adapter_Pdo_Abstract->query(Object(Zend_Db_Table_Select))
#5 .../vendor/zendframework/zendframework1/library/Zend/Db/Table/Abstract.php(1392): Zend_Db_Table_Abstract->_fetch(Object(Zend_Db_Table_Select))
#6 .../application/modules/admin/forms/Media/Upload.php(32): Zend_Db_Table_Abstract->fetchAll(Object(Zend_Db_Table_Select))
#7 .../vendor/zendframework/zendframework1/library/Zend/Form.php(239): Admin_Form_Media_Upload->init()
#8 .../library/Dbjr/Form.php(28): Zend_Form->__construct(NULL)
#9 .../application/modules/admin/controllers/MediaController.php(302): Dbjr_Form->__construct()
#10 .../vendor/zendframework/zendframework1/library/Zend/Controller/Action.php(516): Admin_MediaController->uploadAction()
#11 .../vendor/zendframework/zendframework1/library/Zend/Controller/Dispatcher/Standard.php(308): Zend_Controller_Action->dispatch('uploadAction')
#12 .../vendor/zendframework/zendframework1/library/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch(Object(Zend_Controller_Request_Http), Object(Zend_Controller_Response_Http))
#13 .../vendor/zendframework/zendframework1/library/Zend/Application/Bootstrap/Bootstrap.php(105): Zend_Controller_Front->dispatch()
#14 .../vendor/zendframework/zendframework1/library/Zend/Application.php(384): Zend_Application_Bootstrap_Bootstrap->run()
#15 .../www/index.php(31): Zend_Application->run()
#16 {main}

Next Zend_Db_Statement_Exception: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '))' at line 1, query was: SELECT cnslt.kid, cnslt.titl FROM cnslt WHERE (proj LIKE '%xx%') AND (kid IN ()) in .../vendor/zendframework/zendframework1/library/Zend/Db/Statement/Pdo.php:235
Stack trace:
#0 .../vendor/zendframework/zendframework1/library/Zend/Db/Statement.php(303): Zend_Db_Statement_Pdo->_execute(Array)
#1 .../vendor/zendframework/zendframework1/library/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#2 .../vendor/zendframework/zendframework1/library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT cnslt....', Array)
#3 .../vendor/zendframework/zendframework1/library/Zend/Db/Table/Abstract.php(1577): Zend_Db_Adapter_Pdo_Abstract->query(Object(Zend_Db_Table_Select))
#4 .../vendor/zendframework/zendframework1/library/Zend/Db/Table/Abstract.php(1392): Zend_Db_Table_Abstract->_fetch(Object(Zend_Db_Table_Select))
#5 .../application/modules/admin/forms/Media/Upload.php(32): Zend_Db_Table_Abstract->fetchAll(Object(Zend_Db_Table_Select))
#6 .../vendor/zendframework/zendframework1/library/Zend/Form.php(239): Admin_Form_Media_Upload->init()
#7 .../library/Dbjr/Form.php(28): Zend_Form->__construct(NULL)
#8 .../application/modules/admin/controllers/MediaController.php(302): Dbjr_Form->__construct()
#9 .../vendor/zendframework/zendframework1/library/Zend/Controller/Action.php(516): Admin_MediaController->uploadAction()
#10 .../vendor/zendframework/zendframework1/library/Zend/Controller/Dispatcher/Standard.php(308): Zend_Controller_Action->dispatch('uploadAction')
#11 .../vendor/zendframework/zendframework1/library/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch(Object(Zend_Controller_Request_Http), Object(Zend_Controller_Response_Http))
#12 .../vendor/zendframework/zendframework1/library/Zend/Application/Bootstrap/Bootstrap.php(105): Zend_Controller_Front->dispatch()
#13 .../vendor/zendframework/zendframework1/library/Zend/Application.php(384): Zend_Application_Bootstrap_Bootstrap->run()
#14 .../www/index.php(31): Zend_Application->run()
#15 {main}

@DBJRdev DBJRdev added bug Something isn't working dbjr-approved labels Dec 6, 2018
@mbohal mbohal assigned mbohal and unassigned mbohal Oct 18, 2019
@mbohal
Copy link
Contributor

mbohal commented Oct 28, 2019

Duplicate of #42

@mbohal mbohal closed this as completed Oct 28, 2019
@mbohal mbohal marked this as a duplicate of #42 Oct 28, 2019
# for free to join this conversation on GitHub. Already have an account? # to comment
Labels
bug Something isn't working dbjr-approved
Projects
None yet
Development

No branches or pull requests

2 participants