CA: "Unknown table engine 'InnoDB' - Request halted."

Linux howto's, compile information, information on whatever we learned on working with linux, MACOs and - of course - Products of the big evil....
Post Reply
User avatar
peter_b
Chatterbox
Posts: 370
Joined: Tue Nov 12, 2013 2:05 am

CA: "Unknown table engine 'InnoDB' - Request halted."

Post by peter_b »

[PROBLEM]
After tweaking around on my Debian server, the CollectiveAccess Providence (v1.4) installation suddenly didn't work, and presented only this error message:
Error 250: Invalid SQL statement
Unknown table engine 'InnoDB' (in Db->mysql->execute())
Request halted.

[SOLUTION]
Make sure your /tmp directory is read/writeable by anyone. I've got the "/tmp" for a virtual machine mounted externally from an ext4 partition. Therefore the trouble.
In order to fix the permissions and make them permanent, mount your /tmp partition manually once.
Then change the permissions:

Code: Select all

$ sudo chmod 1777 /tmp
That should do the trick.

NOTE: fstab mount options like "umask/dmask/fmask" are only necessary to filesystems that store their permissions differently (e.g. ntfs, smbfs, etc).
Using them on ext*-filesystems will even cause the mount to fail with the following error message:
mount: wrong fs type, bad option, bad superblock on /dev/sdb1,
missing codepage or helper program, or other error
In some cases useful info is found in syslog - try
dmesg | tail or so
Post Reply