Sort Order Install

[cboyd213]

Trying to install Sort Order found here (http://www.oscommerce.com/community/contributions,2541)

Using osCommerce 2.2

phpMyAdmin

 

----------------------------------------------------------------------------------------------------------------------------------------

 

Having trouble with the following step:

 

ALTER TABLE products ADD products_sort_order INT( 4 ) DEFAULT '0' NOT NULL;

 

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('', 'PRODUCT_LIST_SORT_ORDER', '6', '', '0', '', now());

 

----------------------------------------------------------------------------------------------------------------------------------------

 

I think I added the table "products_sort_order" correctly

but I don't know where in phpmyadmin to go and insert the configuration above

Can someone help me with this?

Thank You

[cboyd213]

Error Message on Categories / Products page:

 

1054 - Unknown column 'p.products_sort_order' in 'field list'

 

select p.products_id, pd.products_name, p.products_quantity, p.products_image, p.products_price, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status, p.products_sort_order from products p, products_description pd, products_to_categories p2c where p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = '0' order by p.products_sort_order, pd.products_name

 

[TEP STOP]

[cboyd213]

Help please?