PostgreSQL-Support for Form store
jandd - June 7, 2007 - 06:29
| Project: | Form store |
| Version: | 5.x-1.0 |
| Component: | Code |
| Category: | feature request |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | needs review |
Description
I changed form_store.install to support PostgreSQL, it would be nice to have this in the next release.
| Attachment | Size |
|---|---|
| form_store_pgsql.patch | 1.23 KB |
#1
Thank you. I want this in the next release. I'll review as soon as time permits.
#2
I got this error when running the patch:
patch < form_store_pgsql.patch(Stripping trailing CRs from patch.)
patching file form_store.install
patch unexpectedly ends in middle of line
patch: **** malformed patch at line 36:
#3
Rerolled the patch to remove the failing hunk, correct the patch header and to make the line endings LF.
I have not been able to test because I still did not manage to get pgsql working again.
#4
Thanks for the re-roll. I patched without errors, and it looks like the module sorta installed correctly as I can now see /admin/settings/form-store, but now I'm getting this error when I go to edit a form:
warning: pg_query() [function.pg-query]: Query failed: ERROR: syntax error at or near "f" at character 25 in /var/www/aigeanta.net/includes/database.pgsql.inc on line 125.user warning: query: UPDATE form_store_forms f SET f.description = 'register a user account' WHERE f.fid = 2 in /var/www/aigeanta.net/includes/database.pgsql.inc on line 144.
I am trying to get form_store to work with captcha and textimage on postgresql...wish me luck!
#5
I made a quick patch myself (did not saw this feature request).
You juste have to cd site/all/modules
wget /form_store-5.x-1.0-pgsql.patch
patch -p0 < form_store-5.x-1.0-pgsql.patch
I did not put a postgres SERIAL but I used db_next_id() function :)
#6
Shame on me, I posted the wrong file.
Here is the good one, after some fixes :)