MyBB Community Forums

Hi, I can get to the part of the installation where it installs the theme then it just quits.

Server Specs:
Apache Webserver
Php (current version)
phpmyadmin (current version)
MySql (5.0)

When it wants to install the theme it gives me this message, any ideas why this would be happening?

mySQL error: 1364
Field 'css' doesn't have a default value
Query: INSERT INTO mybb_themes (tid,name,pid) VALUES (NULL,'MyBB Master Style','0')

There are some problems with MyBB and MySQL5, but these incompatibilities should be worked out in MyBB 1.0.

You can try patching it by doing this:
Open install/index.php.
Find:

	$db->query("INSERT INTO ".TABLE_PREFIX."themes (tid,name,pid) VALUES (NULL,'MyBB Master Style','0')");
	$db->query("INSERT INTO ".TABLE_PREFIX."themes (tid,name,pid,def) VALUES (NULL,'MyBB Default','1','1')");
	$db->query("INSERT INTO ".TABLE_PREFIX."templatesets (sid,title) VALUES (NULL,'Default Templates');");

Replace with:

	$db->query("INSERT INTO ".TABLE_PREFIX."themes (name,pid,css,cssbits,themebits,extracss) VALUES ('MyBB Master Style','0','','','','')");
	$db->query("INSERT INTO ".TABLE_PREFIX."themes (name,pid,def,css,cssbits,themebits,extracss) VALUES ('MyBB Default','1','1','','','','')");
	$db->query("INSERT INTO ".TABLE_PREFIX."templatesets (title) VALUES ('Default Templates');");

But there will most likely be more problems that you will encounter because of MySQL 5. Your best bet would be wait until 1.0 is released when MySQL 5 is fully supported.

Thanks for the information. Ill have to try this.