PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; in Custom Breadcrumbs Identifiers [#2146455]

Problem/Motivation

Trying to test the Special identifier <menu-parent-trail> I faced the following 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 menu_links menu_links WHERE (mlid IN ('4467'))' at line 1: SELECT FROM {menu_links} menu_links WHERE (mlid IN (:db_condition_placeholder_0)) ; Array ( [:db_condition_placeholder_0] => 4467 ) em custom_breadcrumbs_identifiers_cb_identifier_values() (linha 173 de [...]/custom_breadcrumbs/custom_breadcrumbs_identifiers/custom_breadcrumbs_identifiers.module).

Proposed resolution

Fix the missing part of the db_select() syntax.

Comment	File	Size	Author
#3	custom_breadcrumbs_identifiers-menu_parent_trail_alter.patch	5.3 KB	keboca
#3
#1	custom_breadcrumbs-syntax_error_in_custom_breadcrumbs_identifiers-2146455-1.patch	1.96 KB	revagomes
#1

Support from Acquia helps fund testing for Drupal Acquia logo

Comments

Comment #1

revagomes CreditAttribution: revagomes commented 29 November 2013 at 05:16

Status:

Active

» Needs review

File	Size
custom_breadcrumbs-syntax_error_in_custom_breadcrumbs_identifiers-2146455-1.patch	1.96 KB

Here goes the patch to fix this issue.

Comment #2

TwoD

Swedish

Sweden

CreditAttribution: TwoD commented 22 September 2014 at 16:33

Status:

Needs review

» Reviewed & tested by the community

Yep, this works perfectly!

Comment #3

keboca CreditAttribution: keboca commented 30 April 2015 at 16:51

File	Size
custom_breadcrumbs_identifiers-menu_parent_trail_alter.patch	5.3 KB

Hi @revagomes, it looks great.@yalfaque and I had same issue long time ago, however we need to solved on another way, in order to finish some requirements.