I changed form_store.install to support PostgreSQL, it would be nice to have this in the next release.

Comments

heine’s picture

Thank you. I want this in the next release. I'll review as soon as time permits.

suzanne.aldrich’s picture

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:  

heine’s picture

StatusFileSize
new1.02 KB

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.

suzanne.aldrich’s picture

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!

pounard’s picture

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 :)

pounard’s picture

StatusFileSize
new2.68 KB

Shame on me, I posted the wrong file.

Here is the good one, after some fixes :)

pounard’s picture

Status: Needs review » Closed (won't fix)

Too old post, and it pollutes my issues list.

pounard’s picture

Status: Closed (won't fix) » Active

Sorry, wrong window!