,,,, Posted August 6, 2008 Share Posted August 6, 2008 (edited) Howdy, i spent the last 2 days with installing contribution # 2202 (Products Extra Fields) and i'm fed up! I read numerous threads about manifold problems with this contribution; that doesn't surprise me at all, because reading the installing instructions with it's mixture of "add before, add after, add directly before, add directly after, replace, ..." is only possible directly after you have a wash. Secondary i can't find a section mentioned in the installing instruction included in version 2_0j from user 'wdepot' on 13 Jun 2008: $from_str = "from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m using(manufacturers_id), " . TABLE_PRODUCTS_DESCRIPTION . " pd left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_CATEGORIES . " c, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c"; This section should be found in advanced_search_result.php, but i only find this: $from_str = "from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m using(manufacturers_id) left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id"; And of course after installing Product Extra Fields my advanced search crashes with error 1066 (Not unique table/alias: 'pd'). Somebody wrote that removing the following line will help to fix this error: $from_str .= ", " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_CATEGORIES . " c, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c"; He is right, now i get not error 1066, but error 1054 (Unknown column 'p.products_id' in 'on clause') and i don't know why?!? I'm using PHP5/MySQL5. Perhaps i am too stupid for this contribution, but i'm not alone! Please tell me WHAT version YOU installed successfully on PHP5/MySQL5/osC2.2rc2a and how you worked around the difference between the installing instruction 2_0j and the osCommerce version 2.2rc2a in advanced_search_result.php...thanks a lot! ,,,, Edited August 6, 2008 by ,,,, Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.