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

Comments

ccourtne’s picture

ccourtne commented

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.

idcm’s picture

idcm commented

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

idcm’s picture

idcm commented

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

idcm’s picture

idcm commented

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