When running SWFUpload on PGSQL it appears to work properly until you save your node to which files were added. Then I receive the following error:


# warning: pg_query() [function.pg-query]: Query failed: ERROR: syntax error at or near "FROM" LINE 1: SHOW COLUMNS FROM upload ^ in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\d6_v2\includes\database.pgsql.inc on line 139.
# user warning: query: SHOW COLUMNS FROM upload in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\d6_v2\sites\all\modules\swfupload\swfupload.module on line 176.
# warning: pg_query() [function.pg-query]: Query failed: ERROR: syntax error at or near "FROM" LINE 1: SHOW COLUMNS FROM files ^ in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\d6_v2\includes\database.pgsql.inc on line 139.
# user warning: query: SHOW COLUMNS FROM files in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\d6_v2\sites\all\modules\swfupload\swfupload.module on line 180.
# warning: in_array() [function.in-array]: Wrong datatype for second argument in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\d6_v2\sites\all\modules\swfupload\swfupload.module on line 202.

When tested in the database the query returns an error. An alternate selection technique can be found here:
http://www.postgresql.org/docs/8.0/interactive/tutorial-accessdb.html (SHOW COLUMNS FROM table (\d table) = SELECT column_name FROM information_schema.columns WHERE table_name ='table';)

When the code is altered to reflect this on line 176 and 180 the error disappears. However another problem arises . .
after adding files to a node and pressing "save" the screen goes white. When returning to content page (by altering url manually) the files are attached. Also the files are added to the database table - obviously.

Hope this helps. It would have been great to use this module. We were planing to use it in conjunction with image_upload to resolve a slew of issues. Unfortunately we have to implement another solution since we need one right away but I hope this information will help you in developing your module. It will be a great addition to Drupal when some of the bugs are worked out.

Cheers,

V

Comments

skilip’s picture

Status: Active » Closed (fixed)

Version 6.2 doesn't do any db stuff anymore since it's a CCK widget