rachael_web86 Posted October 26, 2009 Posted October 26, 2009 Hi guys, just wondering if anyone could help me as to what this error means on my product_info page; 1054 - Unknown column 'pa.attribute_sort' in 'order clause' Many thanks in advance !!
FIMBLE Posted October 26, 2009 Posted October 26, 2009 HiIt looks like you have added an attributes sort order contribution and not fully installed it, perhaps an SQL update missed off? Nic Sometimes you're the dog and sometimes the lamp post [/url] My Contributions
rachael_web86 Posted October 26, 2009 Author Posted October 26, 2009 HiIt looks like you have added an attributes sort order contribution and not fully installed it, perhaps an SQL update missed off? Nic Hi Nic, I had installed the attribute copier&sorter, but I didn't install it correcly, so i decided to uninstall it, but it kept giving me errors... so i tried installing it again lol, and when i run the sql file in php my admin I now get this error: ALTER TABLE products_attributes ADD products_options_sort_order int( 6 ) NOT NULL default '0' AFTER price_prefix Any ideas? Many thanks!
FIMBLE Posted October 26, 2009 Posted October 26, 2009 Hi Nic, I had installed the attribute copier&sorter, but I didn't install it correcly, so i decided to uninstall it, but it kept giving me errors... so i tried installing it again lol, and when i run the sql file in php my admin I now get this error: ALTER TABLE products_attributes ADD products_options_sort_order int( 6 ) NOT NULL default '0' AFTER price_prefix Any ideas? Many thanks! Did you also remove the bit of code in your product_info.php too? It is this that is causing your original error, the sql part did you also remove remove when you uninstalled the addon? Nic Sometimes you're the dog and sometimes the lamp post [/url] My Contributions
rachael_web86 Posted October 26, 2009 Author Posted October 26, 2009 I've added back in all the code to all the pages that the attribute sorter/copier told me to, now my product_info page is perfecr again =) But my oscommerce admin is displaying (in product attributes bit); 1054 - Unknown column 'attribute_sort' in 'field list' select attribute_sort from products_attributes where products_attributes_id = '171' [TEP STOP] Which I presume has something to do with the msql file, but when I try to execute this file I get the following error on phpmyadmin; ALTER TABLE products_attributes ADD products_options_sort_order int( 6 ) NOT NULL default '0' AFTER price_prefix Don't know what is going on?!
rachael_web86 Posted October 26, 2009 Author Posted October 26, 2009 Managed to fix it Nic, couldn't tell u wot I done lol, but whatever it was worked =) thanks for ur help!!
FIMBLE Posted October 26, 2009 Posted October 26, 2009 I dont think i did anything it was all you! So well done you Nic Sometimes you're the dog and sometimes the lamp post [/url] My Contributions
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.