Error messages and Upload Issues
| Project: | Web File Manager |
| Version: | 6.x-2.11 |
| Component: | Miscellaneous |
| Category: | support request |
| Priority: | normal |
| Assigned: | luckyday13 |
| Status: | active |
Jump to:
Been using Web FM for awhile and it has been really terrific. Curious thing happened this week on our live site that has me stumped:
- One of my regular users reported a problem uploading a file. After looking into it, I was able to repeat the problem, where the file name uploads, but the file size is zero.
- Realizing I was one update behind, I thought I would try to update Web FM from 6.10 to 6.11. Unfortunately, I have no improvement. Still can't upload or attach files.
- Example of error I receive from Web FM during failed upload is below:
"user warning: Unknown column 'cid' in 'field list' query: INSERT INTO webfm_attach (nid, fid, weight, cid) VALUES (1396, 2541, 0, 0) in /home/admin/public_html/ap/sites/all/modules/webfm/webfm.module on line 2949."
- Not sure if this is related, but when I run a cron now, I get this error also:
"warning: is_dir() [function.is-dir]: open_basedir restriction in effect. File(/tmp/mysql.sock) is not within the allowed path(s): (/home/admin:/usr/lib/php:/usr/local/lib/php:/tmp) in /home/admin/public_html/ap/includes/file.inc on line 898."
- People were successfully uploading as of yesterday morning and definitely all last week. I have not made any module or configuration changes for three weeks. Only other thing I can think of is a about a month ago, we had our service provider do some server hardening / security review for us. I can't imagine changes are just catching up to us now, but I put it out there for consideration.
Thanks for the assistance in advance.
Rob
#1
cid should not be unknown - that field was added in the 6.x-2.10-rc3 release last December. Did you not run update.php?
#2
Hi Rob,
Thanks for the reply. I have run update.php a couple of times to make sure. I am pretty confident I have never missed running update.php during any upgrade in the past either. I wish I could point to some work or change that might be the cause. We have a dedicated server that we manage, so really, it is unlikely anything changed in the past week in terms of host or db.
While I have a lot of files / directories (thousands) stored within my Web FM directory, I don't have that many attachments (less than a dozen) I need to preserve. This may be a bit drastic, but would the following step be recommended:
- Save files stored in Web FM elsewhere temporarily;
- Completely uninstall Web FM modules and tables;
- Reinstall fresh Web FM;
- Move files back into Web FM file location via FTP and then add click the 'recursive add files to db' button.
Thanks for the help. Kind of stumped as what else I should do / check.
Rob B
#3
Ok, so I have tried the reinstall route. Web FM is back in business and seems to be happy. I can upload now and attach files, so I guess something along the way of various upgrades got cranky with some configuration that I have.
Problem I am now having is doing a batch move of my files using an FTP client back into the newly created Web FM file structure I have created.
When I go to move a file or folder from one location on my server into the new Web FM structure using my FTP client, I get this:
Status: Renaming '/public_html/ap/files/webfiles_backup/userguide.pdf' to '/public_html/ap/files/WEBFMFILES/Resource/userguide.pdf'
Command: RNFR userguide_aquaprojects.pdf
Response: 350 RNFR accepted - file exists, ready for destination
Command: RNTO /public_html/ap/files/WEBFMFILES/Resource/userguide.pdf
Response: 550 Rename/move failure: Permission denied
I can't change permissions (CHMOD) and I get a similar error if I use my Server Control Panel File Manager.
If anyone has any thoughts, I would love to hear them as there are expectations to have this back online by morning.
Thanks,
rob
#4
Probably obvious for most, but in case anyone runs into similar issues, I thought I would provide what has worked for me. It seems if you let Web FM create the directories for you (versus creating them yourself in FTP for example), determines whether or not Drupal will let you modify the permissions. In my case, I found the following link helpful, using the script at the bottom to help clean-up my file directory mess that had resulted from my uninstall/install of webfm noted above.
http://drupal.org/node/34028
#5
Thanks for the heads-up on that issue. Oddly enough I wasn't aware of this Apache roadblock. When I've recreated directories I was probably logged in as root so didn't have any permissions issues.