Trying to upload an image to a taxonomy term image field I added, as I select it, I get the ajax spinner icon for a second an then it vanishes and then nothing.

When I save the page I get a 'website unexpected error, white screen'.

Here are the report messages that show.

Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') AS expression FROM drup_ tfr INNER JOIN drup_ tr ON tfr. = tr. AND tr. = 0 INN' at line 1: SELECT tfr.tid AS tid, MAX(tfr.) AS expression FROM {} tfr INNER JOIN {} tr ON tfr. = tr. AND tr. = 0 INNER JOIN (SELECT t.tid AS tid, t.langcode AS langcode, MAX(t.) AS expression FROM {} t WHERE t. = :db_condition_placeholder_0 GROUP BY t.tid, t.langcode) mr ON tfr. = mr. AND tfr.langcode = mr.langcode GROUP BY tfr.tid; Array ( [:db_condition_placeholder_0] => 1 ) in Drupal\taxonomy\TermStorage->getTermIdsWithPendingRevisions() (line 404 of /home/feafccef/public_html/live/outdoorfood.club/core/modules/taxonomy/src/TermStorage.php).

Notice: Undefined index: value in Drupal\taxonomy\TermStorage->getTermIdsWithPendingRevisions() (line 384 of /home/feafccef/public_html/live/outdoorfood.club/core/modules/taxonomy/src/TermStorage.php) #0 /home/feafccef/public_html/live/outdoorfood.club/core/includes/bootstrap.inc(587): _drupal_error_handler_real(8, 'Undefined index...', '/home/feafccef/...', 384, Array) #1 /home/feafccef/public_html/live/outdoorfood.club/core/modules/taxonomy/src/TermStorage.php(384): _drupal_error_handler(8, 'Undefined index...', '/home/feafccef/...', 384, Array) #2 /home/feafccef/public_html/live/outdoorfood.club/core/modules/taxonomy/src/Plugin/Validation/Constraint/TaxonomyTermHierarchyConstraintValidator.php(56): Drupal\taxonomy\TermStorage->getTermIdsWithPendingRevisions() #3 /home/feafccef/public_html/live/outdoorfood.club/core/lib/Drupal/Core/TypedData/Validation/RecursiveContextualValidator.php(191): Drupal\taxonomy\Plugin\Validation\Constraint\TaxonomyTermHierarchyConstraintValidator->validate(Object(Drupal\taxonomy\Entity\Term), Object(Drupal\taxonomy\Plugin\Validation\Constraint\TaxonomyTermHierarchyConstraint)) #4 /home/feafccef/public_html/live/outdoorfood.club/core/lib/Drupal/Core/TypedData/Validation/RecursiveContextualValidator.php(146): Drupal\Core\TypedData\Validation\RecursiveContextualValidator->validateConstraints(Object(Drupal\taxonomy\Entity\Term), '0000000053fd7f6...', Array) #5 /home/feafccef/public_html/live/outdoorfood.club/core/lib/Drupal/Core/TypedData/Validation/RecursiveContextualValidator.php(99): Drupal\Core\TypedData\Validation\RecursiveContextualValidator->validateNode(Object(Drupal\Core\Entity\Plugin\DataType\EntityAdapter), Array, true) #6 /home/feafccef/public_html/live/outdoorfood.club/core/lib/Drupal/Core/TypedData/Validation/RecursiveValidator.php(90): Drupal\Core\TypedData\Validation\RecursiveContextualValidator->validate(Object(Drupal\Core\Entity\Plugin\DataType\EntityAdapter), NULL, NULL) #7 /home/feafccef/public_html/live/outdoorfood.club/core/lib/Drupal/Core/TypedData/TypedData.php(131): Drupal\Core\TypedData\Validation\RecursiveValidator->validate(Object(Drupal\Core\Entity\Plugin\DataType\EntityAdapter)) #8 /home/feafccef/public_html/live/outdoorfood.club/core/lib/Drupal/Core/Entity/ContentEntityBase.php(489): Drupal\Core\TypedData\TypedData->validate() #9 /home/feafccef/public_html/live/outdoorfood.club/core/lib/Drupal/Core/Entity/ContentEntityForm.php(192): Drupal\Core\Entity\ContentEntityBase->validate() #10 /home/feafccef/public_html/live/outdoorfood.club/core/modules/taxonomy/src/TermForm.php(102): Drupal\Core\Entity\ContentEntityForm->validateForm(Array, Object(Drupal\Core\Form\FormState)) #11 [internal function]: Drupal\taxonomy\TermForm->validateForm(Array, Object(Drupal\Core\Form\FormState)) #12 /home/feafccef/public_html/live/outdoorfood.club/core/lib/Drupal/Core/Form/FormValidator.php(82): call_user_func_array(Array, Array) #13 /home/feafccef/public_html/live/outdoorfood.club/core/lib/Drupal/Core/Form/FormValidator.php(275): Drupal\Core\Form\FormValidator->executeValidateHandlers(Array, Object(Drupal\Core\Form\FormState)) #14 /home/feafccef/public_html/live/outdoorfood.club/core/lib/Drupal/Core/Form/FormValidator.php(118): Drupal\Core\Form\FormValidator->doValidateForm(Array, Object(Drupal\Core\Form\FormState), 'taxonomy_term_f...') #15 /home/feafccef/public_html/live/outdoorfood.club/core/lib/Drupal/Core/Form/FormBuilder.php(576): Drupal\Core\Form\FormValidator->validateForm('taxonomy_term_f...', Array, Object(Drupal\Core\Form\FormState)) #16 /home/feafccef/public_html/live/outdoorfood.club/core/lib/Drupal/Core/Form/FormBuilder.php(319): Drupal\Core\Form\FormBuilder->processForm('taxonomy_term_f...', Array, Object(Drupal\Core\Form\FormState)) #17 /home/feafccef/public_html/live/outdoorfood.club/core/lib/Drupal/Core/Controller/FormController.php(93): Drupal\Core\Form\FormBuilder->buildForm('taxonomy_term_f...', Object(Drupal\Core\Form\FormState)) #18 [internal function]: Drupal\Core\Controller\FormController->getContentResult(Object(Symfony\Component\HttpFoundation\Request), Object(Drupal\Core\Routing\RouteMatch)) #19 /home/feafccef/public_html/live/outdoorfood.club/core/lib/Drupal/Core/EventSubscriber/EarlyRenderingControllerWrapperSubscriber.php(123): call_user_func_array(Array, Array) #20 /home/feafccef/public_html/live/outdoorfood.club/core/lib/Drupal/Core/Render/Renderer.php(582): Drupal\Core\EventSubscriber\EarlyRenderingControllerWrapperSubscriber->Drupal\Core\EventSubscriber\{closure}() #21 /home/feafccef/public_html/live/outdoorfood.club/core/lib/Drupal/Core/EventSubscriber/EarlyRenderingControllerWrapperSubscriber.php(124): Drupal\Core\Render\Renderer->executeInRenderContext(Object(Drupal\Core\Render\RenderContext), Object(Closure)) #22 /home/feafccef/public_html/live/outdoorfood.club/core/lib/Drupal/Core/EventSubscriber/EarlyRenderingControllerWrapperSubscriber.php(97): Drupal\Core\EventSubscriber\EarlyRenderingControllerWrapperSubscriber->wrapControllerExecutionInRenderContext(Array, Array) #23 /home/feafccef/public_html/live/outdoorfood.club/vendor/symfony/http-kernel/HttpKernel.php(151): Drupal\Core\EventSubscriber\EarlyRenderingControllerWrapperSubscriber->Drupal\Core\EventSubscriber\{closure}() #24 /home/feafccef/public_html/live/outdoorfood.club/vendor/symfony/http-kernel/HttpKernel.php(68): Symfony\Component\HttpKernel\HttpKernel->handleRaw(Object(Symfony\Component\HttpFoundation\Request), 1) #25 /home/feafccef/public_html/live/outdoorfood.club/core/lib/Drupal/Core/StackMiddleware/Session.php(57): Symfony\Component\HttpKernel\HttpKernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #26 /home/feafccef/public_html/live/outdoorfood.club/core/lib/Drupal/Core/StackMiddleware/KernelPreHandle.php(47): Drupal\Core\StackMiddleware\Session->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #27 /home/feafccef/public_html/live/outdoorfood.club/core/modules/page_cache/src/StackMiddleware/PageCache.php(106): Drupal\Core\StackMiddleware\KernelPreHandle->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #28 /home/feafccef/public_html/live/outdoorfood.club/core/modules/page_cache/src/StackMiddleware/PageCache.php(85): Drupal\page_cache\StackMiddleware\PageCache->pass(Object(Symfony\Component\HttpFoundation\Request), 1, true) #29 /home/feafccef/public_html/live/outdoorfood.club/core/lib/Drupal/Core/StackMiddleware/ReverseProxyMiddleware.php(47): Drupal\page_cache\StackMiddleware\PageCache->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #30 /home/feafccef/public_html/live/outdoorfood.club/core/lib/Drupal/Core/StackMiddleware/NegotiationMiddleware.php(52): Drupal\Core\StackMiddleware\ReverseProxyMiddleware->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #31 /home/feafccef/public_html/live/outdoorfood.club/vendor/stack/builder/src/Stack/StackedHttpKernel.php(23): Drupal\Core\StackMiddleware\NegotiationMiddleware->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #32 /home/feafccef/public_html/live/outdoorfood.club/core/lib/Drupal/Core/DrupalKernel.php(693): Stack\StackedHttpKernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #33 /home/feafccef/public_html/live/outdoorfood.club/index.php(19): Drupal\Core\DrupalKernel->handle(Object(Symfony\Component\HttpFoundation\Request)) #34 {main}.

Comments

effortDee created an issue. See original summary.

cilefen’s picture

cilefen commented
Related issues: +#3053001: Unable to update from 8.6.13 to 8.7: "SQLSTATE[42000]: Syntax error or access violation"

This looks similar to this existing issue.

shreyal999’s picture

shreyal999 commented
Assigned: Unassigned » shreyal999
Status: Active » Needs review

Verified the issue, when creating a new field for image and uploading image is working as expected for me. Can you verify it again if the issue persist for you.

shreyal999’s picture

shreyal999 commented
Assigned: shreyal999 » Unassigned
effortdee’s picture

effortdee commented

Shreyal999 I can't access individual terms or the taxonomy vocab overview now so I can't replicate this.

https://www.drupal.org/project/drupal/issues/3062873

shreyal999’s picture

shreyal999 commented

Hey effortDee, since the issue is not reproducible, this issue can be closed.

mukun’s picture

mukun commented

currently my drupal version is 8.7.1
I ran the updates, and when I saw the log I saw above error and when I try to list out the taxonomy term there is error.
then I did change in taxonomy/src/TermStorage.php core module, In that file there is function getTermIdsWithPendingRevisions and I commented return $query->execute()->fetchAllKeyed(1, 0); the return value of that function and return empty array at the beginning.
After this change list of taxonomy is showing.
Is that ok to change the return?

Need HELP!!!

Version: 8.7.x-dev » 8.8.x-dev

Drupal 8.7.9 was released on November 6 and is the final full bugfix release for the Drupal 8.7.x series. Drupal 8.7.x will not receive any further development aside from security fixes. Sites should prepare to update to 8.8.0 on December 4, 2019. (Drupal 8.8.0-beta1 is available for testing.)

Bug reports should be targeted against the 8.8.x-dev branch from now on, and new development or disruptive changes should be targeted against the 8.9.x-dev branch. For more information see the Drupal 8 and 9 minor version schedule and the Allowed changes during the Drupal 8 and 9 release cycles.

Version: 8.8.x-dev » 8.9.x-dev

Drupal 8.8.7 was released on June 3, 2020 and is the final full bugfix release for the Drupal 8.8.x series. Drupal 8.8.x will not receive any further development aside from security fixes. Sites should prepare to update to Drupal 8.9.0 or Drupal 9.0.0 for ongoing support.

Bug reports should be targeted against the 8.9.x-dev branch from now on, and new development or disruptive changes should be targeted against the 9.1.x-dev branch. For more information see the Drupal 8 and 9 minor version schedule and the Allowed changes during the Drupal 8 and 9 release cycles.

Version: 8.9.x-dev » 9.2.x-dev

Drupal 8 is end-of-life as of November 17, 2021. There will not be further changes made to Drupal 8. Bugfixes are now made to the 9.3.x and higher branches only. For more information see the Drupal core minor version schedule and the Allowed changes during the Drupal core release cycle.

Version: 9.2.x-dev » 9.3.x-dev
lendude’s picture

lendude
Primary language Dutch
Location Amsterdam
commented
Status: Needs review » Closed (cannot reproduce)

This issue and the opened related issues that @cilefen pointed out have all not had feedback about steps to reproduce.

Closing this for now. If you find any way to reproduce this issue on a clean Drupal install please feel free to re-open this issue.