Jump to content
Sign in to follow this  
ElaineEnriquezBloch

Product Tabs issues with SQL

Recommended Posts

i have been using oscmax but i couldn't find the answers from their forums regarding installing product tabs addons.

 

i have followed all installation process except that SQL gave me an error. the sql installed was:

 

ALTER TABLE `products_description` ADD `products_spec` TEXT DEFAULT NULL AFTER `products_description`;

ALTER TABLE `products_description` ADD `products_musthave` TEXT DEFAULT NULL AFTER `products_description`;

ALTER TABLE `products_description` ADD `products_extraimage` TEXT DEFAULT NULL AFTER `products_description`;

ALTER TABLE `products_description` ADD `products_manual` TEXT DEFAULT NULL AFTER `products_description`;

ALTER TABLE `products_description` ADD `products_extra1` TEXT DEFAULT NULL AFTER `products_description`;

ALTER TABLE `products_description` ADD `products_moreinfo` TEXT DEFAULT NULL AFTER `products_description`;

 

 

It gave me an error that says:

 

Error

SQL query:

 

ALTER TABLE `products_description` ADD `products_spec` TEXT DEFAULT NULL AFTER `products_description` ;

 

 

MySQL said:

 

#1060 - Duplicate column name 'products_spec'

 

what does this mean?

 

thanks for the help.

Share this post


Link to post
Share on other sites

i have been using oscmax but i couldn't find the answers from their forums regarding installing product tabs addons.

 

i have followed all installation process except that SQL gave me an error. the sql installed was:

 

ALTER TABLE `products_description` ADD `products_spec` TEXT DEFAULT NULL AFTER `products_description`;

ALTER TABLE `products_description` ADD `products_musthave` TEXT DEFAULT NULL AFTER `products_description`;

ALTER TABLE `products_description` ADD `products_extraimage` TEXT DEFAULT NULL AFTER `products_description`;

ALTER TABLE `products_description` ADD `products_manual` TEXT DEFAULT NULL AFTER `products_description`;

ALTER TABLE `products_description` ADD `products_extra1` TEXT DEFAULT NULL AFTER `products_description`;

ALTER TABLE `products_description` ADD `products_moreinfo` TEXT DEFAULT NULL AFTER `products_description`;

 

 

It gave me an error that says:

 

Error

SQL query:

 

ALTER TABLE `products_description` ADD `products_spec` TEXT DEFAULT NULL AFTER `products_description` ;

 

 

MySQL said:

 

#1060 - Duplicate column name 'products_spec'

 

what does this mean?

 

thanks for the help.

 

It means that you already have a column with the name 'products_spec' in the database

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×