when i run the installer i keep ketting this: Code: Warning! The following errors must be rectified before continuing! Please go back and try again! CREATE TABLE ibf_usershops_shops ( u_id int(9) NOT NULL auto_increment, shopname varchar(255) NOT NULL default '', ownerid int(9) NOT NULL default '0', amount_stock int(9) NOT NULL default '0', size int(9) NOT NULL default '0', size_times int(9) NOT NULL default '0', welcomedesc text NOT NULL, PRIMARY KEY (u_id,u_id) ) TYPE=MyISAM AUTO_INCREMENT=1; Duplicate column name 'u_id' anyone knows how to fix this???
It looks as though your trying to install IBstore. The reason you are getting that error is because you've already ran the installer and the required mySQL tables have been created.
You need a fresh database if your installing IPB, it looks as if your installing on a used database that has the store mod in it.
The error you are getting should mean that the database edits have been done, and you just need to edit the required php files in the instructions.
Nope. The error should be something along the lines of : Table already exists... If it is already done. This error means the SQL is trying to create two columns with the same name or something like that.
Soory, but I have to add : The SQL seems to be trying to make u_id primary key twice. CREATE TABLE ibf_usershops_shops ( u_id int(9) NOT NULL auto_increment, shopname varchar(255) NOT NULL default '', ownerid int(9) NOT NULL default '0', amount_stock int(9) NOT NULL default '0', size int(9) NOT NULL default '0', size_times int(9) NOT NULL default '0', welcomedesc text NOT NULL, PRIMARY KEY (u_id,u_id) ) TYPE=MyISAM AUTO_INCREMENT=1; SHOULD BE CREATE TABLE ibf_usershops_shops ( u_id int(9) NOT NULL auto_increment, shopname varchar(255) NOT NULL default '', ownerid int(9) NOT NULL default '0', amount_stock int(9) NOT NULL default '0', size int(9) NOT NULL default '0', size_times int(9) NOT NULL default '0', welcomedesc text NOT NULL, PRIMARY KEY (u_id) ) TYPE=MyISAM AUTO_INCREMENT=1;
