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
Comment #1
DarcyB CreditAttribution: DarcyB commentedComment #2
jsacksick CreditAttribution: jsacksick commentedHi, 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 ?
Comment #3
bojanz CreditAttribution: bojanz commentedThe key point is "Running on a postgresql 9.2 backend."
Maybe module_filter has a postgres incompatibility.
Try disabling it.
Comment #4
ccoppen CreditAttribution: ccoppen commentedLook 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.
Comment #5
frankpeng CreditAttribution: frankpeng commentedPDOException: 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)
Comment #6
nithinkolekar CreditAttribution: nithinkolekar commentedSame here with clean install of v 7.x-2.9/PostgreSql 9.0.1. Error occurred when trying to access /admin/modules page.
Comment #7
nithinkolekar CreditAttribution: nithinkolekar commentedThis 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.
Comment #8
lsolesen CreditAttribution: lsolesen commentedReformatting link #1003788: PostgreSQL: PDOException:Invalid text representation when attempting to load an entity with a string or non-scalar ID
Comment #9
lsolesen CreditAttribution: lsolesen commentedClosed for inactivity.
Comment #10
Dave Cohen CreditAttribution: Dave Cohen commentedIt's easily reproduced. Just install commerce kickstart to a postgres db.
I had to apply the patch mentioned in #7.