Jump to content

Christopher Wright

Members
  • Content count

    5
  • Joined

  • Last visited

  1. Christopher Wright

    Child Attributes for Osc 2.3.1

    Ah, just found the problem myself in catalog/child_attributes.php, line 23 for me. $oa_options_query = tep_db_query("select pov.products_options_values_id, pov.products_options_values_name, oa.products_id, oa.options_values_price, oa.price_prefix from " . TABLE_CHILD_ATTRIBUTES . " oa, " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov where where oa.products_id='" . (int)$prod_id . "' and oa.options_id = '" . (int)$poid . "' and oa.options_value_id='" . (int)$povid . "' and oa.child_options_id = '" . (int)$oa_options_name['products_options_id'] . "' and oa.child_value_id = pov.products_options_values_id and pov.language_id = '" . (int)$languages_id . "'"); Has 'where' declared twice, simple remove one of the 'where's. :)
  2. Christopher Wright

    Child Attributes for Osc 2.3.1

    Hello, I installed this add-on using your installation guide (Beyond Compare is awesome!), however after I try and use it (example: selecting a product from a drop-down menu thats linked to another product) I'm generated this error: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where oa.products_id='59' and oa.options_id = '2' and oa.options_value_id='9' an' at line 1 select pov.products_options_values_id, pov.products_options_values_name, oa.products_id, oa.options_values_price, oa.price_prefix from child_attributes oa, products_options_values pov where where oa.products_id='59' and oa.options_id = '2' and oa.options_value_id='9' and oa.child_options_id = '1' and oa.child_value_id = pov.products_options_values_id and pov.language_id = '1' [TEP STOP] Any idea how to fix this? This add-on would be amazing for my site! Chris
×