Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Recommended Posts

Posted

I am trying to use Linda's Attribute Sorter v4.0 but it asks to add a field to my database. Can anybody help set up a sql query I can run from PhpMyAdmin to import the fields so I don't have to add it manually. I am not good with SQL. Thanks

 

Jason

Posted

I believe what you are needing is ...

 

ALTER TABLE products_attributes ADD products_options_sort_order int(11) NOT NULL Default "0" AFTER price_prefix;

 

Just go into phpMyAdmin ...

Go to the products_attributes table ...

Paste in that line ...

Hit Go ...

 

Rumor has it ... it should add the field for you ... I am pretty sure ... I think ... I mean it should ... heck ... what have you got to lose? :shock:

 

It should insert the field just fine for you using that. :D

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...