Skip to content
New issue

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

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

Already on GitHub? Sign in 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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working dbjr-approved
Projects
None yet
Development

No branches or pull requests

2 participants