Posted by dmurray on July 25, 2009 at 3:15am
Jump to:
| Project: | Storage API |
| Version: | 6.x-1.x-dev |
| Component: | Code |
| Category: | task |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | active |
Issue Summary
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
#1
PostgreSQL isn't supported yet - only MySQL.
#2
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!