Hello,

After update from 7.x-2.0-alpha3 to 7.x-2.0-beta1 version I have this error :

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 'FROM drup7_menu_links menu_links WHERE (link_path IN ('node/1', 'node/1'))' at line 1: SELECT FROM {menu_links} menu_links WHERE (link_path IN (:db_condition_placeholder_0, :db_condition_placeholder_1)) ; Array ( [:db_condition_placeholder_0] => node/1 [:db_condition_placeholder_1] => node/1 ) dans custom_breadcrumbs_identifiers_cb_identifier_values() (ligne 139 dans /var/www/cigalsace/private/drupal/sites/all/modules/custom_breadcrumbs/custom_breadcrumbs_identifiers/custom_breadcrumbs_identifiers.module).

Drupal version : 7.31

CommentFileSizeAuthor
#2 custom_breadcrumbs-2336605-2.patch1.57 KBTwoD
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

Benoit63’s picture

Benoit63 CreditAttribution: Benoit63 commented

Hello,

I had the same issue. In my case, it was a custom breadcrumb setting located at admin/structure/custom_breadcrumbs. An old setting based on 'node' breadcrumb type for my book contents caused the issue.
The special identifier menu-parent-trail didn't work for me in the path setting. I did an other way by deleting the entire setting and now i have the wished breadcrumb thanks to 'menu structure' settings located in admin/config/user-interface/custom-breadcrumbs.

Hope this will help.

TwoD’s picture

TwoD
Primary language Swedish
Location Sweden
CreditAttribution: TwoD at Websystem commented
Status: Active » Needs review
FileSize
custom_breadcrumbs-2336605-2.patch1.57 KB

The issue is a missing list of fields in some queries (SELECT FROM ...).