Collabtive Installation Error

March 19, 2010 6:42 PM

Why is my installation of Collabtive 0.6.2 not connecting to the MySQL databases on my web server? I've uploaded the software and set up a MySQL database, but when I run the install module I keep getting an "Error: Tables could not be created" message.

I'm trying to install Collabtive (http://collabtive.o-dyn.de) on my Dreamhost account and keep running into a wall. Shot in the dark, but has anybody been able to install it and what were the conditions? I have the One-Click Installation option and can set up MySQL databases on my account. I've had no problem with installing several other open source CMS programs on this account and connecting them with the MySQL databases.

Shot in the dark, but has anybody installed/run this software and what were the conditions? I've found only one query about this error message on their forums and unfortunately it's in German. The instructions seem pretty straight forward - all that's required is setting the permissions on two directories and a file, which I've done.

posted by gov_moonbeam to technology (3 answers total)

Have you set up a user in MySQL? Does that user have permission to create the tables?
posted by tmcw at 7:22 PM on March 19, 2010

This is an indirect answer, so feel free to disregard it:

Collabtive looks very pretty and very cleverly laid out. I note, though, that its version number is 0.62, and the forum suggests a wide very variety of bugs still in place. You might want to look into

http://www.projectpier.org/

It's also free and open-source; it's not nearly as pretty, but it does seem to be fairly stable.
posted by darth_tedious at 7:23 PM on March 19, 2010

"Error: Tables could not be created" suggests that Collabtive is able to connect to MySQL and and authenticate, but the MySQL user you're is not authorized to create tables in the database you're connecting to.

Are you sure you're connecting to the correct database (the one you gave a name to when you used Dreamhost's web form for creating databases)?
posted by dws at 9:35 PM on March 19, 2010