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

Priority:Normal» Major

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 ?

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

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.

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)

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

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.