Hi, I just instaled the module and when I call theme function

theme('shrinktheweb_image', array('url' => $url));
I get this error message:

PDOException: SQLSTATE[25P02]: In failed sql transaction: 7 ERROR: current transaction is aborted, commands ignored until end of transaction block: SELECT 1 AS expression FROM {shrinktheweb_log} shrinktheweb_log WHERE ( (id IS NULL ) ) FOR UPDATE; Array ( ) w _shrinktheweb_get_response() (line 139 in shrinktheweb.module).

Comments

geobaev’s picture

geobaev commented
Assigned: Unassigned » geobaev
Status: Active » Postponed (maintainer needs more info)

Are you using PostgreSQL as a database server? The module is not tested to work with PostgreSQL.

peem83’s picture

peem83 commented

Yes I do.

puravida’s picture

puravida commented

Hello peem83,

While the latest v6.x-1.1 & v7.x-1.3 releases have still not been tested with PostgreSQL, the module has been overhauled quite a bit. I suppose that geobaev would know better than I, if our updates would affect this type of issue, but it might be worth updating and giving it another try.

devdokimov’s picture

devdokimov commented
Issue summary: View changes

The problem is with the row names of the shrinktheweb_log table. It's not possible to use 'xmax' and 'full' as the row names in PostgreSQL.

devdokimov’s picture

devdokimov commented
Assigned: geobaev » devdokimov

  • devdokimov committed d31bcce on 7.x-1.x 
    Issue #1772534: Add stw_ prefix to names of the rows  od the log table...
devdokimov’s picture

devdokimov commented
Version: 7.x-1.2 » 7.x-1.x-dev
Status: Postponed (maintainer needs more info) » Closed (fixed)