[Jim O]

I added

sql-mode="TRADITIONAL" to my my.cnf and restarted MySQL server and tried again. I got the following errors:

Step 3: MySQL error reported: [CREATE TABLE IF NOT EXISTS pp_users (userid int(25) NOT NULL auto_increment, usergroupid int(5) NOT NULL default '0', username varchar(30) NOT NULL default '', realname varchar(80) default NULL, password varchar(50) NOT NULL default '', email varchar(75) NOT NULL default '', homepage varchar(100) default NULL, icq varchar(50) default NULL, aim varchar(30) default NULL, yahoo varchar(30) default NULL, joindate int(25) NOT NULL default '0', posts int(20) NOT NULL default '0', birthday date NOT NULL default '0000-00-00', ipaddress varchar(18) default NULL, location varchar(100) default NULL, interests MEDIUMTEXT NULL DEFAULT NULL, occupation varchar(250) default NULL, bio MEDIUMTEXT NULL DEFAULT NULL, site VARCHAR(30) default NULL, offset SMALLINT(2) DEFAULT '0' NOT NULL, lastphoto INT( 12 ) NOT NULL DEFAULT '0', lastdate INT( 15 ) NOT NULL DEFAULT '0', views int(10) NOT NULL default '0', cellphone VARCHAR(255) DEFAULT NULL, title varchar(30) default NULL, signature varchar(250) default NULL, avatar varchar(120) default NULL, mature tinyint(1) NOT NULL default '1', invites int(6) NOT NULL default '0', accepts int(6) NOT NULL default '0', laston int(15) NOT NULL default '0', paypal VARCHAR(75) NOT NULL DEFAULT '', PRIMARY KEY (userid)) ENGINE=MyISAM]
Result: Invalid default value for 'birthday'
Database: mydb

Step 3: MySQL error reported: [INSERT INTO pp_currency VALUES (23,'Netherlands Antilles, Guilders/Florins','ANG','ƒ', '2')]
Result: Data too long for column 'name' at row 1
Database: mydb