PDOException: SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for integer: "types" LINE 5: WHERE (base.product_id IN ('types')) ^: SELECT revision.revision_id AS revision_id, revision.sku AS sku, revision.title AS title, revision.revision_uid AS revision_uid, revision.status AS status, revision.log AS log, revision.revision_timestamp AS revision_timestamp, revision.data AS data, base.product_id AS product_id, base.type AS type, base.language AS language, base.uid AS uid, base.created AS created, base.changed AS changed FROM {commerce_product} base INNER JOIN {commerce_product_revision} revision ON revision.revision_id = base.revision_id WHERE (base.product_id IN (:db_condition_placeholder_0)) ; Array ( [:db_condition_placeholder_0] => types ) in DrupalDefaultEntityController->load() (line 196 of /usr/local/www/d7commerce/includes/entity.inc).

Running on a postgresql 9.2 backend.

When I choose Site Settings | Modules, I get the above error

Comments

DarcyB’s picture

Priority: Normal » Major
jsacksick’s picture

Status: Active » Postponed (maintainer needs more info)

Hi, I'm not able to help you with the current description of the issue, it's most probably due to a module that you added on top of Commerce Kickstart, which modules did you add ? Was this happening with the default set up ?

bojanz’s picture

The key point is "Running on a postgresql 9.2 backend."
Maybe module_filter has a postgres incompatibility.
Try disabling it.

ccoppen’s picture

Look at the Product UI module under Commerce. I'm having the same issue, but with a non-Kickstart installation. I've tracked it down to Commerce_product_ui, but have not found the offending line.

frankpeng’s picture

PDOException: SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for integer: "types" LINE 5: WHERE (base.product_id IN ('types')) ^: SELECT revision.revision_id AS revision_id, revision.sku AS sku, revision.title AS title, revision.revision_uid AS revision_uid, revision.status AS status, revision.log AS log, revision.revision_timestamp AS revision_timestamp, revision.data AS data, base.product_id AS product_id, base.type AS type, base.language AS language, base.uid AS uid, base.created AS created, base.changed AS changed FROM {commerce_product} base INNER JOIN {commerce_product_revision} revision ON revision.revision_id = base.revision_id WHERE (base.product_id IN (:db_condition_placeholder_0)) ; Array ( [:db_condition_placeholder_0] => types ) in DrupalDefaultEntityController->load() (line 191 of /usr/local/www/mywebsite/includes/entity.inc

I got the same error.
FreeBSD 9.2. Postgresql 9.2
drupal 7.23
Install profile Commerce Kickstart (commerce_kickstart-7.x-2.9)

nithinkolekar’s picture

Same here with clean install of v 7.x-2.9/PostgreSql 9.0.1. Error occurred when trying to access /admin/modules page.

nithinkolekar’s picture

This issue can be fixed(temporarily) with a patch at
https://drupal.org/node/1003788#comment-6110312.

But be careful as that thread is still active for finding right solution.

lsolesen’s picture

lsolesen’s picture

Status: Postponed (maintainer needs more info) » Closed (cannot reproduce)

Closed for inactivity.

Dave Cohen’s picture

Status: Closed (cannot reproduce) » Closed (duplicate)

It's easily reproduced. Just install commerce kickstart to a postgres db.

I had to apply the patch mentioned in #7.