debf Posted June 13, 2009 Posted June 13, 2009 Hi. Just a little problem with this contribution and not sure what to do. I tried to upload the attribute_sort.sql to my db and this is the message that I got --------------------------------------------------------------------------------- #1060 - Duplicate column name 'attribute_sort' # Attribue Sort SQL ALTER TABLE products_attributes ADD COLUMN attribute_sort INT UNSIGNED NOT NULL DEFAULT '0' ----------------------------------------------- The contribution hasn't uploaded and since I am a dummy when it comes to anything like this can someone please point me in the right direction as to what needs to be done to get it imported? I need this sorting contribution desperately !!!! In plain english please as I am fumbling my way through all of this. Thanks in advance. Quote
steve_s Posted June 13, 2009 Posted June 13, 2009 (edited) Hi. Just a little problem with this contribution and not sure what to do. I tried to upload the attribute_sort.sql to my db and this is the message that I got --------------------------------------------------------------------------------- #1060 - Duplicate column name 'attribute_sort' # Attribue Sort SQL ALTER TABLE products_attributes ADD COLUMN attribute_sort INT UNSIGNED NOT NULL DEFAULT '0' ----------------------------------------------- The contribution hasn't uploaded and since I am a dummy when it comes to anything like this can someone please point me in the right direction as to what needs to be done to get it imported? I need this sorting contribution desperately !!!! In plain english please as I am fumbling my way through all of this. Thanks in advance. The column your trying to add is already there simply remove that line and run rest of sql if any, then move on to rest of contribution. Edited June 13, 2009 by steve_s Quote
debf Posted June 14, 2009 Author Posted June 14, 2009 Thanks. Now how do I find that line to remove it in my db? Since I uploaded this I am now having huge problems with my admin and can't create any catalog attributes. I can delete them only. When I try to any new ones I keep getting this message ------------------- 1136 - Column count doesn't match value count at row 1 insert into products_attributes values (null, '93', '2', '120', '0', '+') [TEP STOP] ------------------ Just to make matters worse, I backed up the db before trying to install the sort contribution and for some reason I can't import it back. I am currently on to my service provider about that. Sorry about this but as you can tell, I don't really understand the workings of all this - just muddling through it. I seem to have a new column in the admin panel "define main page" but when I click on it I get a not found message. I am tempted to delete the whole store and start again but I was 3/4 way through configuring it ! Quote
debf Posted June 14, 2009 Author Posted June 14, 2009 OK, if I try to delete that this is what I get:- #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 'INT UNSIGNED NOT NULL DEFAULT '0'' at line 1 Can you please tell me what I should change in the below line ALTER TABLE products_attributes ADD COLUMN attribute_sort INT UNSIGNED NOT NULL DEFAULT '0'; Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.