Drupal with Commecrce is frshly installed.
Nothing entered yet.
When I try to create a new product, I receive the database 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 ')' at line 2: SELECT fci.bundle AS bundle, nt.name AS name FROM {field_config_instance} fci INNER JOIN {node_type} nt ON nt.type = fci.bundle WHERE (); Array ( ) in _commerce_pdm_get_product_display_types() (Zeile 539 von /var/www/vhosts/dibidi.de/httpdocs/sites/all/modules/commerce_product

Please help me!

http://www.drupalcenter.de/node/38613

Comments

pcambra’s picture

pcambra
he/him
Primary language Spanish
commented
Status: Active » Fixed

I'd say that this could be due commerce_product_display_manager as the function throwing the error is from that module: _commerce_pdm_get_product_display_types()

Please see #1176966-19: Syntax error ... SELECT n.nid AS nid, n.title AS title FROM {node} n WHERE () ORDER BY n.title ASC as seems a patch that fixes this one

rszrama’s picture

rszrama commented
Project: Commerce Core » Commerce (Product Display Manager)
Version: 7.x-1.0-rc3 » 7.x-1.x-dev
Component: Product » Code
Status: Fixed » Active

Yeah, let's go ahead and move this over.

ronald54’s picture

ronald54 commented

Does this mean, I only have to install the latest dev of display manager?

After I cannot create product groups, I suppose it is the same issue?

ressa’s picture

ressa
he/him
commented

I just tried the dev version (2013-Jan-14) after getting the error reported December 1, 2011, using the official release from july 2011, and it works fine. Perhaps it's time to release it as the Recommended release?

netsensei’s picture

netsensei commented
Status: Active » Fixed

Just installed a fresh commerce 1.4 and enabled the core modules + the 7.x-1.x-dev of PDM. I've created a new product with and without a new product display node: no problems here.

Fixed in dev.

ressa’s picture

ressa
he/him
commented

Sorry, I wasn't expressing myself very clearly at all. I was getting the error using the Recommended release.

The dev version works fine.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.