Recent Topics
  1. b2evolution CMS Support Forums
  2. b2evolution Support
  3. General Support
  4. MySQL Error during installation of 0.9.1

MySQL Error during installation of 0.9.1

1 Feb 16, 2006 23:28    

At (what I think) the end of the installation I get this error. With no further options and b2evolution doesn't work....

Does anybody know a solution?


Creating default users...
MySQL error!

Field 'user_firstname' doesn't have a default value(Errno=1364)

Your query:


INSERT INTO evo_users (user_login, user_pass, user_nickname, user_email, user_ip, user_domain, user_level, user_locale, dateYMDhour, user_grp_ID) VALUES ('admin', 'c57adc5dd67f0961ed10f024e09058b8', 'admin', 'rinospamlj@dutilh.com', '127.0.0.1', 'localhost', 10, 'nl-NL', '2006-02-16 23:24:01', 1)

Back to top

2 Feb 17, 2006 03:36

This is because of MySQL strict/transitional mode.

This will be supported with Phoenix-beta.

You could try adding /conf/hacks.php with the following contents:


<?php
$DB->query( 'SET sql_mode = ""' );
?>

Back to top

3 Feb 18, 2006 14:00

I added as you suggested. It doesn't work. I have Mysql and PHP running on localhost with apache. I think there's something really wrong with the conf of PHP MySQL or Apache..

Back to top

4 Feb 20, 2006 08:05

I have completely lost my photoblog and very unhappy about it. after trying to fix it for so long since i upgraded, i've now lost my patience.

*mad*

Back to top

5 Feb 24, 2006 02:51

dutilh, your problem is 99% related to MySQL 5 / strict mode. Try googling about how to disable it on your platform.

nazzina, I don't get your point. Did you have similar issues?

Back to top

6 Feb 26, 2006 08:23

blueyed, just like to confirm that I had the same issue and it was resolved by disabling Strict mode on MySQL 5.

I'm running a test server on my XP laptop using PHP5, MySQL 5 and Apache 2.0.53

There may be an easier way to change the mode, however I just removed and re-installed the MySQL instance, this time disabling the Strict Mode tick box.

Cheers.

Back to top


Form is loading...