Print Page - Import SQL Error

Title: Import SQL Error
Post by: Extreme360 on March 20, 2008, 06:49:17 PM

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

 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'

Title: Re: Import SQL Error
Post by: winrules on March 20, 2008, 07:45:04 PM

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

Title: Re: Import SQL Error
Post by: Extreme360 on March 20, 2008, 08:16:53 PM

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

Title: Re: Import SQL Error
Post by: Rumbaar on March 28, 2008, 08:35:24 PM

Try changing the line too:

Code Select

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

Simple Machines Community Forum

SMF Support => SMF 2.0.x Support => Topic started by: Extreme360 on March 20, 2008, 06:49:17 PM