Recent Topics

1 Jul 06, 2006 12:08    

when i create the database from the install instructions i get the following.

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', '989aaf64d695550a41c819956eb3d090', 'admin', 'EMAIL REMOVED', 'IP REMOVED', 'localhost', 10, 'en-EU', '2006-07-06 11:12:09', 1)

So it fails all the time :( What do i need to do.

2 Jul 19, 2006 16:22

Hi,

I got the same issue and I could make it work after doing the following hack,

1. Backup _functions_create.php in install directory
2. Open _functions_create.php and change the following,

$query = "CREATE TABLE $tableusers (
ID int(10) unsigned NOT NULL auto_increment,
user_login varchar(20) NOT NULL,
user_pass CHAR(32) NOT NULL,
user_firstname varchar(50) NOT NULL,
user_lastname varchar(50) NOT NULL,
user_nickname varchar(50) NOT NULL,
user_icq int(10) unsigned DEFAULT '0' NOT NULL,
user_email varchar(100) NOT NULL,
user_url varchar(100) NOT NULL,
user_ip varchar(15) NOT NULL,
user_domain varchar(200) NOT NULL,
user_browser varchar(200) NOT NULL,
dateYMDhour datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
user_level int unsigned DEFAULT 0 NOT NULL,
user_aim varchar(50) NOT NULL,
user_msn varchar(100) NOT NULL,
user_yim varchar(50) NOT NULL,
user_locale varchar(20) DEFAULT 'en-EU' NOT NULL,
user_idmode varchar(20) NOT NULL DEFAULT 'login',
user_notify tinyint(1) NOT NULL default 1,
user_grp_ID int(4) NOT NULL default 1,
PRIMARY KEY user_ID (ID),
UNIQUE user_login (user_login),
KEY user_grp_ID (user_grp_ID)
)";

With the following...

$query = "CREATE TABLE $tableusers (
ID int(10) unsigned NOT NULL auto_increment,
user_login varchar(20) NOT NULL,
user_pass CHAR(32) NOT NULL,
user_firstname varchar(50),
user_lastname varchar(50),
user_nickname varchar(50) NOT NULL,
user_icq int(10) unsigned DEFAULT '0' NOT NULL,
user_email varchar(100) NOT NULL,
user_url varchar(100),
user_ip varchar(15) NOT NULL,
user_domain varchar(200) NOT NULL,
user_browser varchar(200),
dateYMDhour datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
user_level int unsigned DEFAULT 0 NOT NULL,
user_aim varchar(50),
user_msn varchar(100),
user_yim varchar(50),
user_locale varchar(20) DEFAULT 'en-EU' NOT NULL,
user_idmode varchar(20) NOT NULL DEFAULT 'login',
user_notify tinyint(1) NOT NULL default 1,
user_grp_ID int(4) NOT NULL default 1,
PRIMARY KEY user_ID (ID),
UNIQUE user_login (user_login),
KEY user_grp_ID (user_grp_ID)
)";

And then rerun the installation.

Basically I have removed the 'NOT NULL' constraint on many columns so that default user rows could be inserted during installation.

Not sure why the create table code originally was like that.

Cheers,
Amit.

3 Jul 19, 2006 23:15

About which b2evo are you talking? Looks like some 0.9.x version, right?

In 1.8 all MySQL strict mode issues should be fixed.


Form is loading...