ATTRIBUTES COPIER V 0.6 ERROR - HELP PLEASE

[PiGGiEE]

Everything works perfect but I'm getting this error when I try to hit the edit button under OPTION VALUES. The delete button there works fine... just not the edit button... when I hit the edit button it gives me this error:

 

1054 - Unknown column 'sort_order' in 'field list'

select products_options_values_name, sort_order from products_options_values where products_options_values_id = '1' and language_id = '1'

[TEP STOP]

 

Does anyone who know php know a fix for this? I'm clueless :blink:

 

Thanks in advance! Any assistance would be greatly appreciated!

[PiGGiEE]

Oops :( Sorry for the double post... it crashed on me and told me to redo it... Gahhhh sorry...

 

If anyone can help me out with this that would be awesome. Thank you!

[PiGGiEE]

Ok so far I know that this is what's causing the error message:

 

$value_name = tep_db_query("select products_options_values_name, sort_order from " . TABLE_PRODUCTS_OPTIONS_VALUES . " where products_options_values_id = '" . (int)$values_values['products_options_values_id'] . "' and language_id = '" . (int)$languages[$i]['id'] . "'");

 

The original version is:

 

$value_name = tep_db_query("select products_options_values_name from " . TABLE_PRODUCTS_OPTIONS_VALUES . " where products_options_values_id = '" . (int)$values_values['products_options_values_id'] . "' and language_id = '" . (int)$languages[$i]['id'] . "'");

 

I dunno what needs to be done though to correct it :( The above is causing it not to sort by sort number... and giving the error message above...

 

Anyone have any ideas? Any PHP pros here? Please help... any assistance would be greatly appreciated!

[PiGGiEE]

Gahhh!! I dunno :( I double checked triple checked everything and yes the field "sort_order" has been added to MYSQL.... I've uninstalled the whole contribution and reinstalled it... uninstalled the whole oscommerce cart and reinstalled it... and it still doesn't work...