Winamp & Shoutcast Forums

Winamp & Shoutcast Forums (http://forums.winamp.com/index.php)

- General Discussions (http://forums.winamp.com/forumdisplay.php?f=1)

- - mySQL error (http://forums.winamp.com/showthread.php?t=215005)

If know mySQL you probably know how to create a table. However, I get an error when installing Easymod to my database, and the error is:

PHP Code:


		
			
SQL-query: 



CREATE TABLE phpbb_easymod(

mod_id mediumint( 8 ) NOT NULL DEFAULT '0' AUTO_INCREMENT ,

mod_title varchar( 50 ) NULL DEFAULT '',

mod_file varchar( 255 ) NULL DEFAULT '',

mod_version varchar( 15 ) NULL DEFAULT '',

mod_author_handle varchar( 25 ) NULL DEFAULT '',

mod_author_email varchar( 100 ) NULL DEFAULT '',

mod_author_name varchar( 100 ) NULL DEFAULT '',

mod_author_url varchar( 100 ) NULL DEFAULT '',

mod_description text NULL DEFAULT '',

mod_process_date int( 11 ) NULL DEFAULT '0',

mod_phpBB_version varchar( 15 ) NULL DEFAULT '',

mod_processed_themes varchar( 200 ) NULL DEFAULT '',

mod_processed_langs varchar( 200 ) NULL DEFAULT '',

mod_files_edited mediumint( 8 ) NULL DEFAULT '0',

mod_tables_added mediumint( 8 ) NULL DEFAULT '0',

mod_tables_altered mediumint( 8 ) NULL DEFAULT '0',

mod_rows_inserted mediumint( 8 ) NULL DEFAULT '0',

PRIMARY KEY ( mod_id ) 

) 



MySQL said:  

#1067 - Invalid default value for 'mod_id'

Can anyone see an error here?

Try changing the default value of mod id to 1.

replace

PHP Code:


		
			
mod_id mediumint( 8 ) NOT NULL DEFAULT '0' AUTO_INCREMENT ,

with

PHP Code:


		
			
mod_id mediumint(8) NOT NULL auto_increment,

the fact that you declare mod_id as the primary key means that you can't give it a default value....

Ah yes thats true i remember now. It has to be unique, no duplicates.

Okay :) I've already deleted that key, and it worked, but thanks for the effort :) Sure was what you said :)

It's a struggle always being right, but somehow I manage...

:p

Just preparing for making something huge :)

http://www.aocore.com/forums/

This is no forum (or at least it have no forums) so it's not available for posting ;) But at least I managed to install EasyMod into it :) If you're really bored, you can play with my cookies in my signature instead :p