sql query error.. heeelp!

[robster2]

Hi all

 

Im trying to run this sql query:

ALTER TABLE `products` ADD `products_purchase` `products_purchase` TINYINT(1) NOT NULL DEFAULT '1' ;

 

from an older contribution "Product Purchase Option" http://addons.oscommere.com/info/3865

 

and Im getting this error:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`products_purchase` TINYINT(1) NOT NULL DEFAULT '1'' at line 1

 

My version is MySQL 5.1.49 and I'm not very familiar with databases..any suggestions????

 

Thanks in advance

Rob

[♥geoffreywalton]

This might work better

 

[quote name='robster2' date='16 October 2010 - 04:03 PM' timestamp='1287241433'

ALTER TABLE `products` ADD `products_purchase` TINYINT(1) NOT NULL DEFAULT '1' ;

 

G

[robster2]

Works like a dream..

 

Thanks alot

 

Rob

[♥geoffreywalton]

Thought it might.

 

See the info below if you want to find out more about MySql

 

G

[MrPhil]

Clearly a bug in the installation instructions (duplicated field name). Please email/contact the author and have them update it.