Bug: Uploading .doc

[sdm]

When I upload a Word-document everything goes fine, but when I open this document out of Knowledgeroot, I get a blank Wordfile.

This bug is in 0.9.6c and in 0.9.7rc1

BTW The new look is great!

[admin]

Hello,

can you try that in the demo on
http://knowledgeroot-dev.linuxdelta.de ?

Which database do you use? Mysql or Postgresql and which versions? Also which php-version?

Frank

[sdm]

I'm using MySQL under WAMP 5 (so PHP5 and MySQL 5).

It works fine in http://knowledgeroot-dev.linuxdelta.de.

So what settings do I have to use for my configuration?

[admin]

Hi,

i will check that!

Can you take a look to the database if the coloum with the filecontent is filled or if its empty?

Frank

[sdm]

It's filled.

[admin]

Hello,

i have tried something out. I have installed WAMP5 on a WinXP System. I only made a standard installation. I havent changed anything.

In firefox all works fine. The only problem i found is in ie with a doc document. I click on the file in knowledgeroot and he ask me if i want to open or save the file. If i want to open the file he cannot open the file. But if i save the file he can. Sorry but i dont know why the ie is doing that.

Or do you have the problem in another browser?

regards,
Frank

[sdm]

With a great help of Frank, there is a solution for this problem.

If you execute the next query in your database (for instance in phpMyadmin), you can solve this problem:

ALTER TABLE files MODIFY file LONGBLOB NOT NULL;

Please note: already uploaded files won't be changed by this update, so you have to upload the files again after this update. Then everything works great!

This fix is tested on 0.9.6c and 0.9.7RC1 on php4&5 and mysql4&5.