Drupal 6.13
Mimedetect 6.x-1.2
Storage API 6.x-1.x-dev

When enabling Filesystem / Drupal these errors are shown:

    * warning: pg_query() [function.pg-query]: Query failed: ERROR: syntax error at or near "SET" LINE 3: SET service_id = 'fs_drupal' ^ in /var/vwww/video.eagleseye.ca/html/includes/database.pgsql.inc on line 139.
    * user warning: query: INSERT INTO storage_service SET service_id = 'fs_drupal' in /var/vwww/video.eagleseye.ca/html/sites/all/modules/storage_api/storage_api.module on line 401.

Filesystem / Drupal shows as active but when tring to create a container this error is received:

    * warning: pg_query() [function.pg-query]: Query failed: ERROR: syntax error at or near "SET" LINE 3: SET name = 'Local storage', ^ in /var/vwww/video.eagleseye.ca/html/includes/database.pgsql.inc on line 139.
    * user warning: query: INSERT INTO storage_container SET name = 'Local storage', service_id = 'fs_drupal', serving = 0, settings = 'a:1:{s:4:"path";s:19:"sites/default/files";}' in /var/vwww/video.eagleseye.ca/html/sites/all/modules/storage_api/containers.admin.inc on line 235.
    * warning: pg_query() [function.pg-query]: Query failed: ERROR: currval of sequence "storage_container_container_id_seq" is not yet defined in this session in /var/vwww/video.eagleseye.ca/html/includes/database.pgsql.inc on line 139.
    * user warning: query: SELECT CURRVAL('storage_container_container_id_seq') in /var/vwww/video.eagleseye.ca/html/includes/database.pgsql.inc on line 232.

Any help would be appreciated.

Comments

jbrown’s picture

jbrown commented
Title: Storage API fails to be initialized » PostgreSQL support
Category: bug » task
Priority: Critical » Normal

PostgreSQL isn't supported yet - only MySQL.

spelcheck’s picture

spelcheck commented

any word on progress? I'd like to put some time into this one.. what are the major stumbling blocks that need to be resolved to support pgsql? Worst case, is there someone out there that would accept sponsorship on adding support? Thanks!

perignon’s picture

perignon commented
Status: Active » Closed (won't fix)

I am a new co-maintainer for Storage_API. Drupal 6 is coming toward end of life as soon as D8 is released which should be by the end of 2014. Due to that, I am going to be closing all 6.x issues as it's a hurdle too far to overcome with the amount of issues in the queue against this module.