Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

1109 - Unknown table 'POV.POV' in order clause


Recommended Posts

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!

Link to comment
Share on other sites

$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");

Contributions

 

Discount Coupon Codes

Donations

Link to comment
Share on other sites

  • 2 months later...

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...