Import SQL Error

[Extreme360]

I get this error when trying to import the SQL from my local machine to the web server.

Code Select Expand

SQL query:

CREATE TABLE `smf_log_packages` (
id_install int( 10 ) NOT NULL AUTO_INCREMENT ,
filename tinytext NOT NULL default '',
package_id tinytext NOT NULL default '',
name tinytext NOT NULL default '',
version tinytext NOT NULL default '',
id_member_installed mediumint( 8 ) NOT NULL default '',
member_installed tinytext NOT NULL default '',
time_installed int( 10 ) NOT NULL default 0,
id_member_removed mediumint( 8 ) NOT NULL default 0,
member_removed tinytext NOT NULL default '',
time_removed int( 10 ) NOT NULL default 0,
install_state tinyint( 3 ) NOT NULL default 1,
failed_steps text NOT NULL default '',
themes_installed tinytext NOT NULL default '',
db_changes text NOT NULL default '',
PRIMARY KEY ( id_install ) ,
KEY filename( filename( 15 ) )
) TYPE = MYISAM

MySQL said: Documentation
#1067 - Invalid default value for 'id_member_installed'

[winrules]

How did you create that? Was it a database backup that was created from the SMF admin panel or was it from phpMyAdmin?

[Extreme360]

Admin panel, I tried from phpmyadmin and it gave me a different error.

[Rumbaar]

Try changing the line too:

Code Select Expand

id_member_installed mediumint( 8 ) NOT NULL default '0',