user error: Table '[dabasename].file' doesn't exist
| Project: | Attachment |
| Version: | 4.6.x-1.x-dev |
| Component: | Code |
| Category: | bug report |
| Priority: | critical |
| Assigned: | Unassigned |
| Status: | active |
Jump to:
I am not sure this is really a "user error"
I followed the directions. The database has the table. I got positive feedback that config went okay after I set write permissions to private. It appeared that it would work.
I attempted to create a page with an attachment and bang! I got nine errors at the top of my page that all read something like this. They all focus on line 66.
user error: Table '[databasename].file' doesn't exist
query: SELECT directory, count(1) filecount FROM file WHERE private = '' GROUP BY directory ORDER BY directory ASC in /home/idcmi/idcminnovations.net/html/includes/database.mysql.inc on line 66.
I don't know if this helps but the grey box that shows the attachment shows the following:
contentstructures.doc
http://idcminnovations.net/files/active//
kinda weird wrap issue? does that provide a clue?
I am a newbie to drupal and am using a shared service. Also, I am not a coder so ... whatever I did wrong or whatever the fix might be, please provide easy to following directions. okay?
thanks
idcm
#1
Did you install the filemanager module database tables as well? You need to run the filemanager.mysql or filemanager.pgsql (if your using postgres). Be aware that by default drupal includes a table called 'files' with an s which is not the right table.
#2
I was sure that I did do this. I saw "files" but wasn't sure it was created by filemanager. So, I tried to upload the filemanager mysql again and got "already exists"
Are you tell me that there are two tables with the same name?
idcm
#3
Another observation about "files"
It seems to be used by the disknode module. I see my attempts to use it with documents located in the Files directory and documents located in files/resources
BTW, disknode is working fine
idcm
#4
I found the problem. During my original attempt to create the file table, a table called FILE for some reason. It is case sensitive apparently. I deleted FILE and redid the process. It looks like it will work ...
BUT
I tried to upload a file that was already in the files dir. Forgot it was there. Anyway, got the error message:
File copy failed. File already exists.
Error saving upload to filestore.
So, it appears you can't "attach" the same file to multiple nodes. I uploaded that file to files dir via ftp for another node. Now I want that same file on a node that lists several files. I Some of my files cover multiple topics and I want them linked on multiple nodes. Is there a way around this?
please advise
idcm