Enabling Userpoints causes profile pages to break. Uncertain as to why beyond the query itself looks like it is broken based on the error message:

Error message

PDOException: SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for integer: "" LINE 1: SELECT * from userpoints_txn WHERE txn_id = '' ^: SELECT * from {userpoints_txn} WHERE txn_id = :txn; Array ( [:txn] => ) in userpoints_transaction_load() (line 1852 of x/sites/all/modules/userpoints/userpoints.module).
The website encountered an unexpected error. Please try again later.

This is an error result from PostgreSQL, not MySQL, keeping that in mind, it looks like it's failing to retrieve anything in the :txn resultset, worse, making the resultset a blank string '' when it's expecting an integer.

Comments

chi’s picture

Status: Active » Closed (duplicate)