I get an error when I try to update my menu at "admin/structure/menu/manage/main" I thought this was maybe a core problem but when I updated from 8.5.x to 8.6.12 the issue remained. I checked my error logs and this is the error I am seeing.
[07-Jul-2019 13:33:36 America/Los_Angeles] Uncaught PHP Exception 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 MySQL server version for the right syntax to use near ') AS expression
FROM
mlfr
INNER JOIN mlr ON mlfr. = mlr. AND mlr. = 0
INNER JO' at line 1: SELECT mlfr.id AS id, MAX(mlfr.) AS expression
FROM
{} mlfr
INNER JOIN {} mlr ON mlfr. = mlr. AND mlr. = 0
INNER JOIN (SELECT t.id AS id, t.langcode AS langcode, MAX(t.) AS expression
FROM
{} t
WHERE t. = :db_condition_placeholder_0
GROUP BY t.id, t.langcode) mr ON mlfr. = mr. AND mlfr.langcode = mr.langcode
GROUP BY mlfr.id; Array
(
[:db_condition_placeholder_0] => 1
)
" at /docroot/core/lib/Drupal/Core/Database/Connection.php line 692
Comments
Comment #2
hiddenfellon CreditAttribution: hiddenfellon commentedComment #3
Rajab Natshah CreditAttribution: Rajab Natshah at Vardot for Vardot commentedThank you for reporting,
Have you had a look at the Drupal core 8.7.0 release notes?
https://www.drupal.org/project/drupal/releases/8.7.0
Custom menu links are revisionable
Comment #4
hiddenfellon CreditAttribution: hiddenfellon commentedI am running php 7.2. I dont understand the custom menu links are revisionable. What do I need to do here?
Comment #5
Rajab Natshah CreditAttribution: Rajab Natshah at Vardot for Vardot commentedCustom menu links are revisionable
https://www.drupal.org/node/3039034
Comment #6
stefan.kornI suppose update.php (or drush updb) was maybe not run succesfully. Check whether you have pending updates.
Comment #7
Rajab Natshah CreditAttribution: Rajab Natshah at Vardot for Vardot commentedComment #8
Rajab Natshah CreditAttribution: Rajab Natshah at Vardot for Vardot commentedComment #9
Rajab Natshah CreditAttribution: Rajab Natshah at Vardot for Vardot commented