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

hiddenfellon created an issue. See original summary.

hiddenfellon’s picture

Priority: Normal » Critical
Rajab Natshah’s picture

Priority: Critical » Normal

Thank 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

hiddenfellon’s picture

I am running php 7.2. I dont understand the custom menu links are revisionable. What do I need to do here?

Rajab Natshah’s picture

Custom menu links are revisionable
https://www.drupal.org/node/3039034

stefan.korn’s picture

I suppose update.php (or drush updb) was maybe not run succesfully. Check whether you have pending updates.

Rajab Natshah’s picture

Rajab Natshah’s picture

Status: Active » Fixed
Rajab Natshah’s picture

Status: Fixed » Closed (fixed)