Brandi Lee Posted March 8, 2006 Share Posted March 8, 2006 Hi I really need some help. I have Improve Product Attribute installed allowing me to edit product attributes from the product add/edit screen. It worked perfectly. Now the attribute box does not populate and the view source is showing an 1109 error. Any Ideas?? Here is the code from categories.php: <?php $options = tep_db_query("select products_options_name, products_options_id from " . TABLE_PRODUCTS_OPTIONS . " where language_id = '" . $languages_id . "' order by products_options_name"); while($options_values = tep_db_fetch_array($options)) { echo "\n" . '<tr><td class=main valign=top>' . $options_values['products_options_name'] . '</td>' . "\n"; echo '<td class="main">' . tep_draw_separator('pixel_trans.gif', '24', '15') . ' ' . "\n"; echo '<select multiple name="attributes[]" size=5 style="width: 136;">'; $suboptions = tep_db_query("SELECT DISTINCT POV.products_options_values_id, POV.products_options_values_name FROM products_options_values POV, products_options_values_to_products_options POVtoPO WHERE language_id = '" . $languages_id . "' AND POVtoPO.products_options_id = '" . $options_values['products_options_id'] . "' AND POVtoPO.products_options_values_id = POV.products_options_values_id ORDER BY POV.POV.products_options_values_id"); while($suboptions_values = tep_db_fetch_array($suboptions)) { $prodoptions = tep_db_query("SELECT * FROM products_attributes WHERE products_id = '" . $pID . "' AND options_id = '" . $options_values['products_options_id'] . "' AND options_values_id = '" . $suboptions_values['products_options_values_id'] . "'" ); if ($prodoptions_values = tep_db_fetch_array($prodoptions)) { $checked = ' SELECTED'; } else { $checked = ''; } echo "\n" . "<option value=\"" . $options_values['products_options_id'] . "_" . $suboptions_values['products_options_values_id'] . "\"" . $checked . ">" . $suboptions_values['products_options_values_name'] . "</option>"; // Changed by SP echo "\n" . "<option value=\"" . $options_values['products_options_id'] . "_" . $suboptions_values['products_options_values_id'] . "_" . $prodoptions_values['options_values_price'] . "_" . $prodoptions_values['price_prefix'] . "\"" . $checked . ">" . $suboptions_values['products_options_values_name'] . "</option>"; } echo "\n" . '</select></td></tr>'; echo "\n" . ' <tr>'; echo "\n" . ' <td colspan=2>' . tep_draw_separator('pixel_trans.gif', '1', '10') . '</td>'; echo "\n" . ' </tr>'; } ?> Here is the error I am getting from view source: <select multiple name="attributes[]" size=5 style="width: 136;"><font color="#000000"><b>1109 - Unknown table 'POV.POV' in order clause<br><br>SELECT DISTINCT POV.products_options_values_id, POV.products_options_values_name FROM products_options_values POV, products_options_values_to_products_options POVtoPO WHERE language_id = '1' AND POVtoPO.products_options_id = '1' AND POVtoPO.products_options_values_id = POV.products_options_values_id ORDER BY POV.POV.products_options_values_id<br><br><small><font color="#ff0000">[TEP STOP]</font></small><br><br></b></font> Thanks in advance! Quote Link to comment Share on other sites More sharing options...
kgt Posted March 8, 2006 Share Posted March 8, 2006 $suboptions = tep_db_query("SELECT DISTINCT POV.products_options_values_id, POV.products_options_values_name FROM products_options_values POV, products_options_values_to_products_options POVtoPO WHERE language_id = '" . $languages_id . "' AND POVtoPO.products_options_id = '" . $options_values['products_options_id'] . "' AND POVtoPO.products_options_values_id = POV.products_options_values_id ORDER BY POV.POV.products_options_values_id"); should be $suboptions = tep_db_query("SELECT DISTINCT POV.products_options_values_id, POV.products_options_values_name FROM products_options_values POV, products_options_values_to_products_options POVtoPO WHERE language_id = '" . $languages_id . "' AND POVtoPO.products_options_id = '" . $options_values['products_options_id'] . "' AND POVtoPO.products_options_values_id = POV.products_options_values_id ORDER BY POV.products_options_values_id"); Quote Contributions Discount Coupon Codes Donations Link to comment Share on other sites More sharing options...
Brandi Lee Posted March 8, 2006 Author Share Posted March 8, 2006 Fixed. Thanks!!!!!!!!! :thumbsup: :D Quote Link to comment Share on other sites More sharing options...
Guest Posted May 19, 2006 Share Posted May 19, 2006 I was having the very same problem and was going crazy trying to fix it! This worked!!! Thanks so much! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.