General error: 1366 Incorrect string value: '\x882b\xEA\\x84...' for column 'value' at row 1"
Closed this issue · 5 comments
Metis77 commented
Context
Contao version: 4.13.12
Bundle version: 1.7
PHP version: 8.1
Description
General error: 1366 Incorrect string value: '\x882b\xEA\x84...' for column 'value' at row 1"
[2022-11-04T21:06:26.533036+00:00] request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\DriverException: "An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1366 Incorrect string value: '\x882b\xEA\\x84...' for column 'value' at row 1" at .../vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php line 117 {"exception":"[object] (Doctrine\\DBAL\\Exception\\DriverException(code: 1366): An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1366 Incorrect string value: '\\x882b\\xEA\\\\x84...' for column 'value' at row 1 at .../vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:117)\n[previous exception] [object] (Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 1366): SQLSTATE[HY000]: General error: 1366 Incorrect string value: '\\x882b\\xEA\\\\x84...' for column 'value' at row 1 at...vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28)\n[previous exception] [object] (PDOException(code: HY000): SQLSTATE[HY000]: General error: 1366 Incorrect string value: '\\x882b\\xEA\\\\x84...' for column 'value' at row 1 at.../vendor/doctrine/dbal/src/Driver/PDO/Statement.php:134)"} []
koertho commented
Hi, a litte more information would be usefull. Where does the error occur? The complete stack trace?
Metis77 commented
Hi, the issue above was triggered in the frontend after submitting a form.
Now with contao dev mode, other issues come up earlier:
Backen on goning into the form, before even seeing the file upload form element.
Stack Trace:
ErrorException:
Warning: Undefined array key ""
at vendor/heimrichhannot/contao-multifileupload-bundle/src/Backend/MultiFileUpload.php:183
at HeimrichHannot\MultiFileUploadBundle\Backend\MultiFileUpload->generateMarkup()
(vendor/contao/core-bundle/src/Resources/contao/widgets/Upload.php:75)
at Contao\Upload->generate()
(templates/form_multifileupload.html5:5)
at include('/Users/Metis/Sites/nature-concepts.de/templates/form_multifileupload.html5')
(vendor/contao/core-bundle/src/Resources/contao/library/Contao/TemplateInheritance.php:108)
at Contao\Widget->inherit()
(vendor/contao/core-bundle/src/Resources/contao/library/Contao/Widget.php:607)
at Contao\Widget->parse()
(vendor/contao/core-bundle/src/Resources/contao/dca/tl_form_field.php:690)
at tl_form_field->listFormFields(array('id' => 200, 'pid' => 3, 'sorting' => 1728, 'tstamp' => 1667807522, 'invisible' => '', 'type' => 'multifileupload', 'name' => 'Bewerbungsunterlagen', 'label' => 'Bewerbungsunterlagen (optional)', 'text' => null, 'html' => null, 'options' => null, 'mandatory' => '', 'rgxp' => '', 'placeholder' => '', 'minlength' => 0, 'maxlength' => 0, 'size' => 'a:2:{i:0;i:4;i:1;i:40;}', 'multiple' => '', 'mSize' => 0, 'extensions' => 'jpg,jpeg,gif,png,pdf,doc,docx,xls,xlsx,ppt,pptx', 'storeFile' => '', 'uploadFolder' => '.�V�\\k��ܮ����a', 'useHomeDir' => '', 'doNotOverwrite' => '', 'class' => '', 'value' => '', 'accesskey' => '', 'tabindex' => 0, 'fSize' => 0, 'customTpl' => '', 'slabel' => '', 'imageSubmit' => '', 'singleSRC' => null, 'rsce_data' => null, 'leadStore' => '', 'maxHeight' => 0, 'maxWidth' => 0, 'uploadButtonLabel' => '', 'addToDbafs' => '', 'concurrent' => '', 'chunkSize' => '2000000', 'chunking' => '', 'maxConnections' => 3, 'step' => '', 'maxval' => '', 'minval' => '', 'maxImageHeight' => 0, 'maxImageWidth' => 0, 'errorMsg' => '', 'customRgxp' => '', 'mf_maxFileSize' => 0, 'mf_maxFiles' => 0, 'required' => ''))
(vendor/contao/core-bundle/src/Resources/contao/drivers/DC_Table.php:4653)
at Contao\DC_Table->parentView()
(vendor/contao/core-bundle/src/Resources/contao/drivers/DC_Table.php:306)
at Contao\DC_Table->showAll()
(vendor/contao/core-bundle/src/Resources/contao/classes/Backend.php:667)
at Contao\Backend->getBackendModule('form', null)
(vendor/contao/core-bundle/src/Resources/contao/controllers/BackendMain.php:168)
at Contao\BackendMain->run()
(vendor/contao/core-bundle/src/Controller/BackendController.php:49)
at Contao\CoreBundle\Controller\BackendController->mainAction()
(vendor/symfony/http-kernel/HttpKernel.php:163)
at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1)
(vendor/symfony/http-kernel/HttpKernel.php:75)
at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, true)
(vendor/symfony/http-kernel/Kernel.php:202)
at Symfony\Component\HttpKernel\Kernel->handle(object(Request))
(public/index.php:44)
An in the Frontend, just when navigating to a page, that contains this form:
Stack Trace:
Error:
Call to a member function hasErrors() on null
at vendor/heimrichhannot/contao-multifileupload-bundle/src/Resources/contao/templates/forms/form_multifileupload_dropzone.html5:39
at include()
(vendor/contao/core-bundle/src/Resources/contao/library/Contao/TemplateInheritance.php:108)
at Contao\Widget->inherit()
(vendor/contao/core-bundle/src/Resources/contao/library/Contao/Widget.php:607)
at Contao\Widget->parse()
(vendor/contao/core-bundle/src/Resources/contao/forms/Form.php:248)
at Contao\Form->compile()
(vendor/contao/core-bundle/src/Resources/contao/classes/Hybrid.php:230)
at Contao\Hybrid->generate()
(vendor/contao/core-bundle/src/Resources/contao/forms/Form.php:90)
at Contao\Form->generate()
(vendor/contao/core-bundle/src/Resources/contao/library/Contao/Controller.php:615)
at Contao\Controller::getContentElement(object(ContentModel), 'main')
(vendor/contao/core-bundle/src/Resources/contao/modules/ModuleArticle.php:197)
at Contao\ModuleArticle->compile()
(vendor/contao/core-bundle/src/Resources/contao/modules/Module.php:214)
at Contao\Module->generate()
(vendor/contao/core-bundle/src/Resources/contao/modules/ModuleArticle.php:70)
at Contao\ModuleArticle->generate(false)
(vendor/contao/core-bundle/src/Resources/contao/library/Contao/Controller.php:543)
at Contao\Controller::getArticle(object(ArticleModel), false, false, 'main')
(vendor/contao/core-bundle/src/Resources/contao/library/Contao/Controller.php:385)
at Contao\Controller::getFrontendModule('0', 'main')
(vendor/contao/core-bundle/src/Resources/contao/pages/PageRegular.php:190)
at Contao\PageRegular->prepare(object(PageModel))
(vendor/contao/core-bundle/src/Resources/contao/pages/PageRegular.php:60)
at Contao\PageRegular->getResponse(object(PageModel), true)
(vendor/contao/core-bundle/src/Resources/contao/controllers/FrontendIndex.php:320)
at Contao\FrontendIndex->renderPage(object(PageModel))
(vendor/symfony/http-kernel/HttpKernel.php:163)
at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1)
(vendor/symfony/http-kernel/HttpKernel.php:75)
at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, true)
(vendor/symfony/http-kernel/Kernel.php:202)
at Symfony\Component\HttpKernel\Kernel->handle(object(Request))
(public/index.php:44)
No clue whats going on there.
Hopefully its not just a silly mistake on my side.
Metis77 commented
Also and maybe realted, the backend is visually brocken:
