Project:Web File Manager
Version:6.x-2.10-rc2
Component:Code
Category:bug report
Priority:normal
Assigned:Unassigned
Status:closed (fixed)

Issue Summary

with Error:

warning: pg_query() [function.pg-query]: Query failed: ERROR: null value in column "fdesc" violates not-null constraint in /var/.../.../.../.../.../drupal/includes/database.pgsql.inc on line 138.
user warning: query: INSERT INTO webfm_file (fpath, uid, fsize, fcreatedate, perm, fmime) VALUES ('sites/default/files/Root/Guest/webfm_file.txt', 1, 8752, 1225351949, 6, 'text/plain') in /var/.../.../.../.../.../drupal/sites/all/modules/webfm/webfm.module on line 2538.
Could not insert sites/.../.../.../.../webfm_file.txt into the database
Insertion into database fail

Conditions:
Drupal 6.6
DB: PostgreSQL database 8.2.6
PHP 5.2.6RC1-pl1-gentoo
PHP memory limit 312M
Web server Apache

The problem only occurs with 6.x-2.10-rc2. Version 6.x-2.9-alpha2 works well !
behaviour does not change whether an upgrade 2.9-alpha2 -> 2.10-rc2 is done or a complete deinstall of 2.9-alpha2 and fresh install of 2.10-rc2 is done.
A simple downgrage (switch webfm directory) to 2.9-alpha2 "resolves" the problem.

Thanks

Comments

#1

Please try replacing line 62 of the rc2 version of webfm.install with the following:

'fdesc' => array('type' => 'text', 'size' => 'normal', 'not null' => TRUE, 'default' => ''),

#2

Status:active» closed (fixed)

Thank you, that did it. After deinstallation of 2.9 and reinstallation of 2.10 it worked.
regards