cruiser01 wrote on Tuesday, August 02, 2005:
When I pull up a patient and go to the document
tab, select a category, browse and select upload I get an error
"query failed: SHOW COLUMNS FROM documents, error:Table ‘openemr1.documents’ doesn’t exist "
The image did make it to the document folder. This is on a Mandrake 10.1 system.
sunsetsystems wrote on Tuesday, August 02, 2005:
Looks like the challenge is to figure out why your "documents" table is missing. It seems to have been in the database.sql script since release 2.6.1.
– Rod <rod at sunsetsystems dot com>
cruiser01 wrote on Tuesday, August 02, 2005:
When I open up the database.sql the code to create a document table is not there. What is the correct procedure to put the code into the file . I tried
to add the code to the file and creating another database , but that did work.
cruiser01 wrote on Tuesday, August 02, 2005:
On the last reply I meant to say " it did not work"
andres_paglayan wrote on Tuesday, August 02, 2005:
few questions,
is your database openemr1 or openemr?
are you using mysql <4.1?
I had a problem when loading tables from the last CVS.
the database.sql file has some comments withing the body of an insert statement, giving explanation about option meanings,
some versions of mysql will take it valid some not, depending also in the mysql settings,
you’ll notice a
– # this is for such thing
– @ this is for such other thing
kind of coment
try manualy reloading the database.sql after removing those coments, or find a way to make those comments valid within mysql insert statement
andres_paglayan wrote on Tuesday, August 02, 2005:
line 26402
at sql/database.sql