MySQL Error - Anyone troubleshoot this?
Posted by: KPHudson (---.hfc.comcastbusiness.net)
Date: March 07, 2010 11:54PM

Trying to import a database, but get this error:

Error
SQL query:

CREATE TABLE table_logins ( logins_key int(9) unsigned NOT NULL auto_increment, logins_username varchar(100) NOT NULL, logins_password varchar(100) NOT NULL, logins_name varchar(255) NOT NULL, logins_address varchar(255) NOT NULL, logins_city varchar(255) NOT NULL, fk_states int(3) unsigned NOT NULL, logins_zip varchar(25) NOT NULL, fk_countries char(3) NOT NULL, logins_phone varchar(25) NOT NULL, logins_email varchar(255) NOT NULL, logins_type tinyint(1) unsigned NOT NULL, logins_active tinyint(1) unsigned DEFAULT '1' NOT NULL, logins_date timestamp DEFAULT 'CURRENT_TIMESTAMP' NOT NULL, logins_last0 timestamp DEFAULT '0000-00-00 00:00:00' NOT NULL, logins_last1 timestamp DEFAULT '0000-00-00 00:00:00' NOT NULL, logins_last_ip0 varchar(255) NOT NULL, logins_last_ip1 varchar(255) NOT NULL, logins_enable_view tinyint(1) unsigned DEFAULT '2' NOT NULL, logins_enable_group tinyint(1) unsigned NOT NULL, logi[...]

MySQL said:

#1067 - Invalid default value for 'logins_date'

Any thoughts here?? This is all greek to me

Options: ReplyQuote


Sorry, only registered users may post in this forum.