Hello.

I am running the latest stable drupal 5 and get the following when I try to upload a file with WebFM. I have verfied that the field perm is indeed missing...

* user warning: Unknown column 'perm' in 'field list' query: INSERT INTO webfm_file (uid, fpath, fname, fsize, fcreatedate, perm, dl_cnt, fmime, fdesc) VALUES (1, 'files/shared-files/edc.txt', 'edc.txt', 821, 1199581597, 14, 0, 'text/plain', '') in /home/anadaru2/public_html/drupal/includes/database.mysql.inc on line 172.
* Could not insert files/shared-files/edc.txt into the database
* Insertion into database fail

----
Any thoughts?
Thanks.

Comments

robmilne’s picture

robmilne commented

Did you run update.php after upgrading? There has been a schema change.

Erelyes’s picture

Erelyes commented

It wasn't an upgrade - this is my first roll out of all this, drupal included. Will it hose me if I run it?

robmilne’s picture

robmilne commented

You put the fear of God in me there. I did a fresh install and indeed I got the same sorry result but after a couple of tries I realised that you have to explicitly select update #1 for webfm. Run update.php and make sure that you select the 'Select versions' link to find the webfm select box. This is the first time I've changed the schema since the module's initial release.

Erelyes’s picture

Erelyes commented

Rock! That's it!

Man, this thing is freaking sweet. Thanks!

robmilne’s picture

robmilne commented
Status: Active » Closed (fixed)
boufaha’s picture

boufaha commented

i have the same error...and dont understand this part of your suggestion: "...make sure that you select the 'Select versions' link to find the webfm select box." How do i do that?

Thanks,

robmilne’s picture

robmilne commented

By running update.php.

You can do it from the address bar (http://yoursite/update.php)

markj’s picture

markj commented

Just had the same problem, and I can confirm that selecting update 1 eliminates the problem. Thanks for such a bitchin module.

boufaha’s picture

boufaha commented

Hey...thanks for the quick reply

I have run the update.php and i still get the same error

* user warning: Unknown column 'perm' in 'field list' query: INSERT INTO webfm_file (uid, fpath, fname, fsize, fcreatedate, perm, dl_cnt, fmime, fdesc) VALUES (1, 'files/fildeling/test.pdf', 'test.pdf', 4129574, 1199964777, 0, 0, 'application/pdf', '') in /mounted-storage/home74a/sub009/sc42373-EHQX/www/cms/includes/database.mysql.inc on line 172.
* Could not insert files/fildeling/test.pdf into the database
* Insertion into database fail

I have also reinstallet the module, with the same result...any ideas?

lilkinoko’s picture

lilkinoko commented

I also have the same error when I tried to upload a file. However, when I try to run update 1, it gives me the error "An HTTP error 501 occured. update.php?op=do_update" "The update process was aborted prematurely while running update #1 in webfm.module"
Help please?
Thanks!

edit: ah, got it to work. I had to use IE instead of firefox to update. Thanks