Hello! You are looking at an archived forum discussion from the old mahara.org website. You cannot reply to this topic, but if you wish to discuss it, you can sign up to mahara.org and ask about this in the new forums.
Submitted by jonkonrad on Wed, 11/12/2008 - 11:51.

When installing mahara for the first time it stops with the following error:
"Could not execute command: CREATE TABLE mhartefact_cron ( plugin VARCHAR(255) NOT NULL, callfunction VARCHAR(255) NOT NULL, nextrun DATETIME DEFAULT NULL, minute VARCHAR(25) NOT NULL DEFAULT '*', hour VARCHAR(25) NOT NULL DEFAULT '*', day VARCHAR(25) NOT NULL DEFAULT '*', month VARCHAR(25) NOT NULL DEFAULT '*', dayofweek VARCHAR(25) NOT NULL DEFAULT '*', CONSTRAINT PRIMARY KEY (plugin, callfunction), CONSTRAINT mhartecron_plu_fk FOREIGN KEY (plugin) REFERENCES mhartefact_installed (name) )TYPE=innodb"

This is strange since it does find my database in MySQL and creates 5 tables before this crash.

I am running this in Windows which I know is not supported. Still, it get's so far, I'm curious why it does not finish up. I'm using WAMP and have Apache 2.x, PHP 5.2.x, and MySQL 5.x

I know my WAMP set up works since I have regular pages loading as well as Moodle, and ELGG working.

Any thoughts?

‹ Stoping Kids from changing there password Urgent Help Needed....Plssss ›

I believe that is caused by

Submitted by nigel on Wed, 11/12/2008 - 22:47.

I believe that is caused by using a utf8 collation. We actually do want people to use a utf8 collation, but mahara doesn't currently install using it on mysql. There are a few bugs filed on the tracker, which we'll hopefully be looking into for 1.1.

For now, you could use a latin collation, though this means you can't use multiple languages on your site.

Yes ... That's it. Now working great on WAMP

Submitted by jonkonrad on Sat, 11/15/2008 - 13:44.

Thank you for that tip. I created a new database using latin1_general_ci as the character set and it installed without a problem.

Again, thank you