Brandi Lee Posted March 8, 2006 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
kgt Posted March 8, 2006 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
Brandi Lee Posted March 8, 2006 Author Posted March 8, 2006 Fixed. Thanks!!!!!!!!! :thumbsup: :D Quote
Guest Posted May 19, 2006 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
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.
Note: Your post will require moderator approval before it will be visible.