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
Comment #1
chi commentedClosing as duplicate of: #1281468: PostgreSQL error when userpoints_transaction_load() is called with an empty argument