UltraPics help

[Guest]

hey yall, I'm installing the table for the sql file for UltraPics, and I cant seem to get something right... heres the stuff that needs to be in it and I've put in it

 

CREATE TABLE `contributions` (

`information_id` TINYINT( 3 ) UNSIGNED NOT NULL AUTO_INCREMENT ,

`visible` ENUM( '1', '0' ) DEFAULT '1' NOT NULL ,

`v_order` TINYINT( 3 ) UNSIGNED DEFAULT '0' NOT NULL ,

`info_title` VARCHAR( 255 ) NOT NULL ,

`description` TEXT NOT NULL ,

`languages_id` INT( 11 ) DEFAULT '0' NOT NULL

) TYPE = MYISAM COMMENT = ' PRIMARY KEY (information_id,languages_id)'

 

and here is my ERROR:

 

#1075 - Incorrect table definition; There can only be one auto column and it must be defined as a key

 

what does this mean and how do I fix it?? THanks - Jon

[Guest]

okay just kidding I fixed that. HOWEVER, when installing the sql file for the whole thing, it says this:

 

MySQL said: Documentation

#1146 - Table 'proschoi_img.configuration_group' doesn't exist

 

how do I fix this??

[Guest]

Fixed (in case someone else needs this)

 

CREATE TABLE `contributions` (
?`information_id` tinyint(3) unsigned NOT NULL auto_increment,
?`visible` enum('1','0') NOT NULL default '1',
?`v_order` tinyint(3) unsigned NOT NULL default '0',
?`info_title` varchar(255) NOT NULL default '',
?`description` text NOT NULL,
?`languages_id` int(11) NOT NULL default '0',
?PRIMARY KEY ?(`information_id`,`languages_id`)
) TYPE=MyISAM;

[Guest]

wow sorry I'm a retard... I tried to make an entire new SQL database... all I needed to do was upload that data to my exsisting OSCommerce database! lol wow