Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Recommended Posts

Posted

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.

Posted (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 by steve_s
Posted

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 !

Posted

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';

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.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...