DekiWiki attachments not inserted into database (Win32)

[matt.titchener]

After a successful installation, and configuration I've noticed that the attachment feature does not work properly. Here is what I have noticed:

1. If attach a file to a wiki page, the file will upload (i.e. there are no errors) but when I go to see the attachment on the page it's not there.

2. If I check in the server's filesystem to see if the attached file was uploaded, I can see that it HAS been uploaded no problem.

3. If I check to see if the database has been updated accordingly I see that the entry for the attachment is missing (as if the INSERT statement failed).

4. If I check the MySQL logs to see if the INSERT statement for the attachment fired, I can see that it HAS fired, the primary key has incremented, but the entry is not there!

5. If I manually submit the INSERT query (through MySQL) the attachement displays in the Wiki!

It's almost as if MySQL has a bug, as if a transaction is failing (for whatever reason) but not being fully rolled back. For the life of me I can't see what is so 'special' about this particular INSERT statement that would cause it to fail. Maybe the attachment table has some odd permissions? Just need to figure this one out...

Any ideas?

--matt

[wikiwurm]

why 2 postings?

http://www.opengarden.org/dekiwiki/c...database_win32

[matt.titchener]

Why not? It's free. My problem skirts both installation and configuration, so my post does too.

I'm super-curious as to the solution, it's been an issue for a couple months now.

[DincerKavraal]

Have you opened debug level logging in related page (page firing INSERT for attachment) of Deki?

Point is that we are unaware of what MySQL returned for reply to INSERT command.

[matt.titchener]

DincerKavraal could you explain a little more what you mean by this? I haven't entered any debug modes for either MySQL or Apache/PHP/DekiWiki.

thanks for your reply!

matt

[matt.titchener]

Turns out the configuration I had didn't like the db-engine for the attachments table. It was set-up (from installation, so I assume the open-garden people picked the engine) as InnoDB, however, on changing the engine to MyISAM (using the MySQL administrator tools) attachments display just fine (as the data can now be inserted into the table properly).

matt

[PeteE]

matt - I'm so glad you figured that out! The DekiWiki code doesn't actually specify a storage engine (and at MindTouch we use MyISAM for all our DB's).

I'm guessing your mysql configuration on windows used InnoDB as the default storage engine.

Thanks for posting your findings!