pafranklin Posted March 17, 2006 Posted March 17, 2006 Hi there, I have been using Quick Updates for a while successfully and have recently added "Individual Shipping v4.2a" Seperately both have been and are working fine. I then decided to add Quick Updates 2.90 Individual Ship English so that I could easily update the shipping costs for all products. I have obviously done something wrong as I now receive the error: - 1054 - Unknown column 'p.products_ship_price' in 'field list' select p.products_id, p.products_image, p.products_model, pd.products_name, p.products_status, p.products_ship_price, p.products_ship_price_two, p.products_weight, p.products_quantity, p.products_price, p.products_tax_class_id, m.manufacturers_id, m.manufacturers_name from products p, products_description pd, manufacturers m where p.products_id = pd.products_id and m.manufacturers_id = p.manufacturers_id and pd.language_id = '1' limit 0, 100 [TEP STOP] I believe that I need to add or change something in my database and have been using PHPAdmin ok but am really not sure what to do and how to do it. I would be really grateful for some help if possible?? Very many thanks. :( You will never learn if you don't try. And boy am I trying....!
gtr_rider Posted April 15, 2006 Posted April 15, 2006 Hi there, I have been using Quick Updates for a while successfully and have recently added "Individual Shipping v4.2a" Seperately both have been and are working fine. I then decided to add Quick Updates 2.90 Individual Ship English so that I could easily update the shipping costs for all products. I have obviously done something wrong as I now receive the error: - I believe that I need to add or change something in my database and have been using PHPAdmin ok but am really not sure what to do and how to do it. I would be really grateful for some help if possible?? Very many thanks. :( having the same trouble, anyone?
gtr_rider Posted April 16, 2006 Posted April 16, 2006 Found solution on my own... under [root]/admin/quick_updates.php change... //// select categories if ($current_category_id == 0){ if($manufacturer){ //vendors// $products_query_raw = "select p.products_id, p.products_image, p.products_model, pd.products_name, p.products_status, p.products_weight, p.products_quantity, p.manufacturers_id, p.products_price, p.vendors_product_price, p.products_tax_class_id, m.manufacturers_id, manufacturers_name, v.vendors_id, v.vendors_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, ".TABLE_MANUFACTURERS." m, ".TABLE_VENDORS ." v where p.products_id = pd.products_id and m.manufacturers_id = p.manufacturers_id and v.vendors_id = p.vendors_id and pd.language_id = '$languages_id' and p.manufacturers_id = " . $manufacturer . " $sort_by "; $products_query_raw = "select p.products_id, p.products_image, p.products_model, pd.products_name, p.products_status, p.products_ship_price, p.products_ship_price_two, p.products_weight, p.products_quantity, p.products_price, p.products_tax_class_id, m.manufacturers_id, manufacturers_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, ".TABLE_MANUFACTURERS." m where p.products_id = pd.products_id and m.manufacturers_id = p.manufacturers_id and pd.language_id = '$languages_id' and p.manufacturers_id = " . $manufacturer . " $sort_by "; }else{ //vendors// $products_query_raw = "select p.products_id, p.products_image, p.products_model, pd.products_name, p.products_status, p.products_weight, p.products_quantity, p.manufacturers_id, p.products_price, p.vendors_product_price, p.products_tax_class_id, m.manufacturers_id, manufacturers_name, v.vendors_id, v.vendors_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, ".TABLE_MANUFACTURERS." m, ".TABLE_VENDORS ." v where p.products_id = pd.products_id and m.manufacturers_id = p.manufacturers_id and v.vendors_id = p.vendors_id and pd.language_id = '$languages_id' $sort_by "; $products_query_raw = "select p.products_id, p.products_image, p.products_model, pd.products_name, p.products_status, p.products_ship_price, p.products_ship_price_two, p.products_weight, p.products_quantity, p.products_price, p.products_tax_class_id, m.manufacturers_id, m.manufacturers_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, ".TABLE_MANUFACTURERS." m where p.products_id = pd.products_id and m.manufacturers_id = p.manufacturers_id and pd.language_id = '$languages_id' $sort_by "; } } else { if($manufacturer){ //vendors// $products_query_raw = "select p.products_id, p.products_image, p.products_model, pd.products_name, p.products_status, p.products_weight, p.products_quantity, p.manufacturers_id, p.products_price, p.products_tax_class_id, m.manufacturers_id, manufacturers_name, v.vendors_id, v.vendors_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " pc, ".TABLE_MANUFACTURERS." m, ".TABLE_VENDORS ." v where p.products_id = pd.products_id and m.manufacturers_id = p.manufacturers_id and v.vendors_id = p.vendors_id and pd.language_id = '$languages_id' and p.products_id = pc.products_id and pc.categories_id = '" . $current_category_id . "' and p.manufacturers_id = " . $manufacturer . " $sort_by "; $products_query_raw = "select p.products_id, p.products_image, p.products_model, pd.products_name, p.products_status, p.products_ship_price, p.products_ship_price_two, p.products_weight, p.products_quantity, p.products_price, p.products_tax_class_id, m.manufacturers_id, manufacturers_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " pc, ".TABLE_MANUFACTURERS." m where p.products_id = pd.products_id and m.manufacturers_id = p.manufacturers_id and pd.language_id = '$languages_id' and p.products_id = pc.products_id and pc.categories_id = '" . $current_category_id . "' and p.manufacturers_id = " . $manufacturer . " $sort_by "; }else{ //vendors// $products_query_raw = "select p.products_id, p.products_image, p.products_model, pd.products_name, p.products_status, p.products_weight, p.products_quantity, p.manufacturers_id, p.products_price, p.products_tax_class_id, m.manufacturers_id, manufacturers_name, v.vendors_id, v.vendors_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " pc, ".TABLE_MANUFACTURERS." m, ".TABLE_VENDORS ." v where p.products_id = pd.products_id and m.manufacturers_id = p.manufacturers_id and v.vendors_id = p.vendors_id and pd.language_id = '$languages_id' and p.products_id = pc.products_id and pc.categories_id = '" . $current_category_id . "' $sort_by "; $products_query_raw = "select p.products_id, p.products_image, p.products_model, pd.products_name, p.products_status, p.products_ship_price, p.products_ship_price_two, p.products_weight, p.products_quantity, p.products_price, p.products_tax_class_id, m.manufacturers_id, m.manufacturers_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " pc, ".TABLE_MANUFACTURERS." m where p.products_id = pd.products_id and m.manufacturers_id = p.manufacturers_id and pd.language_id = '$languages_id' and p.products_id = pc.products_id and pc.categories_id = '" . $current_category_id . "' $sort_by "; } } to //// select categories if ($current_category_id == 0){ if($manufacturer){ //vendors// $products_query_raw = "select p.products_id, p.products_image, p.products_model, pd.products_name, p.products_status, p.products_weight, p.products_quantity, p.manufacturers_id, p.products_price, p.vendors_product_price, p.products_tax_class_id, m.manufacturers_id, manufacturers_name, v.vendors_id, v.vendors_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, ".TABLE_MANUFACTURERS." m, ".TABLE_VENDORS ." v where p.products_id = pd.products_id and m.manufacturers_id = p.manufacturers_id and v.vendors_id = p.vendors_id and pd.language_id = '$languages_id' and p.manufacturers_id = " . $manufacturer . " $sort_by "; $products_query_raw = "select p.products_id, p.products_image, p.products_model, pd.products_name, p.products_status, ps.products_ship_price, ps.products_ship_price_two, p.products_weight, p.products_quantity, p.products_price, p.products_tax_class_id, m.manufacturers_id, manufacturers_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_SHIPPING." ps, ".TABLE_MANUFACTURERS." m where p.products_id = pd.products_id and m.manufacturers_id = p.manufacturers_id and pd.language_id = '$languages_id' and p.manufacturers_id = " . $manufacturer . " $sort_by "; }else{ //vendors// $products_query_raw = "select p.products_id, p.products_image, p.products_model, pd.products_name, p.products_status, p.products_weight, p.products_quantity, p.manufacturers_id, p.products_price, p.vendors_product_price, p.products_tax_class_id, m.manufacturers_id, manufacturers_name, v.vendors_id, v.vendors_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, ".TABLE_MANUFACTURERS." m, ".TABLE_VENDORS ." v where p.products_id = pd.products_id and m.manufacturers_id = p.manufacturers_id and v.vendors_id = p.vendors_id and pd.language_id = '$languages_id' $sort_by "; $products_query_raw = "select p.products_id, p.products_image, p.products_model, pd.products_name, p.products_status, ps.products_ship_price, ps.products_ship_price_two, p.products_weight, p.products_quantity, p.products_price, p.products_tax_class_id, m.manufacturers_id, m.manufacturers_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_SHIPPING." ps, ".TABLE_MANUFACTURERS." m where p.products_id = pd.products_id and m.manufacturers_id = p.manufacturers_id and pd.language_id = '$languages_id' $sort_by "; } } else { if($manufacturer){ //vendors// $products_query_raw = "select p.products_id, p.products_image, p.products_model, pd.products_name, p.products_status, p.products_weight, p.products_quantity, p.manufacturers_id, p.products_price, p.products_tax_class_id, m.manufacturers_id, manufacturers_name, v.vendors_id, v.vendors_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " pc, ".TABLE_MANUFACTURERS." m, ".TABLE_VENDORS ." v where p.products_id = pd.products_id and m.manufacturers_id = p.manufacturers_id and v.vendors_id = p.vendors_id and pd.language_id = '$languages_id' and p.products_id = pc.products_id and pc.categories_id = '" . $current_category_id . "' and p.manufacturers_id = " . $manufacturer . " $sort_by "; $products_query_raw = "select p.products_id, p.products_image, p.products_model, pd.products_name, p.products_status, ps.products_ship_price, ps.products_ship_price_two, p.products_weight, p.products_quantity, p.products_price, p.products_tax_class_id, m.manufacturers_id, manufacturers_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_SHIPPING." ps, " . TABLE_PRODUCTS_TO_CATEGORIES . " pc, ".TABLE_MANUFACTURERS." m where p.products_id = pd.products_id and m.manufacturers_id = p.manufacturers_id and pd.language_id = '$languages_id' and p.products_id = pc.products_id and pc.categories_id = '" . $current_category_id . "' and p.manufacturers_id = " . $manufacturer . " $sort_by "; }else{ //vendors// $products_query_raw = "select p.products_id, p.products_image, p.products_model, pd.products_name, p.products_status, p.products_weight, p.products_quantity, p.manufacturers_id, p.products_price, p.products_tax_class_id, m.manufacturers_id, manufacturers_name, v.vendors_id, v.vendors_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " pc, ".TABLE_MANUFACTURERS." m, ".TABLE_VENDORS ." v where p.products_id = pd.products_id and m.manufacturers_id = p.manufacturers_id and v.vendors_id = p.vendors_id and pd.language_id = '$languages_id' and p.products_id = pc.products_id and pc.categories_id = '" . $current_category_id . "' $sort_by "; $products_query_raw = "select p.products_id, p.products_image, p.products_model, pd.products_name, p.products_status, ps.products_ship_price, ps.products_ship_price_two, p.products_weight, p.products_quantity, p.products_price, p.products_tax_class_id, m.manufacturers_id, m.manufacturers_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_SHIPPING." ps, " . TABLE_PRODUCTS_TO_CATEGORIES . " pc, ".TABLE_MANUFACTURERS." m where p.products_id = pd.products_id and m.manufacturers_id = p.manufacturers_id and pd.language_id = '$languages_id' and p.products_id = pc.products_id and pc.categories_id = '" . $current_category_id . "' $sort_by "; } } and change... <!-----// Ship Price 1 & Ship Price 2--------> <td class="dataTableHeadingContent" align="center" valign="top"> <table border="0" cellspacing="1" cellpadding="2"> <tr class="dataTableHeadingRow"> <td class="dataTableHeadingContent" align="center" valign="top"> <?php echo "???<a href=\"" . tep_href_link( FILENAME_QUICK_UPDATES, 'cPath='. $current_category_id .'&sort_by=p.products_ship_price ASC&page=' . $page.'&row_by_page=' . $row_by_page . '&manufacturer=' . $manufacturer) ."\" >".tep_image(DIR_WS_IMAGES . 'icon_up.gif', TEXT_SORT_ALL . TABLE_HEADING_SHIP_PRICE . ' ' . TEXT_ASCENDINGLY)."</a> <a href=\"" . tep_href_link( FILENAME_QUICK_UPDATES, 'cPath='. $current_category_id .'&sort_by=p.products_ship_price DESC&page=' . $page.'&row_by_page=' . $row_by_page . '&manufacturer=' . $manufacturer) ."\" >".tep_image(DIR_WS_IMAGES . 'icon_down.gif', TEXT_SORT_ALL . TABLE_HEADING_SHIP_PRICE . ' ' . TEXT_DESCENDINGLY)."</a> <br> " . TABLE_HEADING_SHIP_PRICE . "</td>";?> </tr> </table> </td> <td class="dataTableHeadingContent" align="center" valign="top"> <table border="0" cellspacing="1" cellpadding="2"> <tr class="dataTableHeadingRow"> <td class="dataTableHeadingContent" align="center" valign="top"> <?php echo "???<a href=\"" . tep_href_link( FILENAME_QUICK_UPDATES, 'cPath='. $current_category_id .'&sort_by=p.products_ship_price_two ASC&page=' . $page.'&row_by_page=' . $row_by_page . '&manufacturer=' . $manufacturer) ."\" >".tep_image(DIR_WS_IMAGES . 'icon_up.gif', TEXT_SORT_ALL . TABLE_HEADING_SHIP_PRICE_TWO . ' ' . TEXT_ASCENDINGLY)."</a> <a href=\"" . tep_href_link( FILENAME_QUICK_UPDATES, 'cPath='. $current_category_id .'&sort_by=p.products_ship_price_two DESC&page=' . $page.'&row_by_page=' . $row_by_page . '&manufacturer=' . $manufacturer) ."\" >".tep_image(DIR_WS_IMAGES . 'icon_down.gif', TEXT_SORT_ALL . TABLE_HEADING_SHIP_PRICE_TWO . ' ' . TEXT_DESCENDINGLY)."</a> <br> " . TABLE_HEADING_SHIP_PRICE_TWO . "</td>";?> </tr> </table> </td> <!-----// Ship Price & Ship Price two //--------> to <!-----// Ship Price 1 & Ship Price 2--------> <td class="dataTableHeadingContent" align="center" valign="top"> <table border="0" cellspacing="1" cellpadding="2"> <tr class="dataTableHeadingRow"> <td class="dataTableHeadingContent" align="center" valign="top"> <?php echo "???<a href=\"" . tep_href_link( FILENAME_QUICK_UPDATES, 'cPath='. $current_category_id .'&sort_by=ps.products_ship_price ASC&page=' . $page.'&row_by_page=' . $row_by_page . '&manufacturer=' . $manufacturer) ."\" >".tep_image(DIR_WS_IMAGES . 'icon_up.gif', TEXT_SORT_ALL . TABLE_HEADING_SHIP_PRICE . ' ' . TEXT_ASCENDINGLY)."</a> <a href=\"" . tep_href_link( FILENAME_QUICK_UPDATES, 'cPath='. $current_category_id .'&sort_by=ps.products_ship_price DESC&page=' . $page.'&row_by_page=' . $row_by_page . '&manufacturer=' . $manufacturer) ."\" >".tep_image(DIR_WS_IMAGES . 'icon_down.gif', TEXT_SORT_ALL . TABLE_HEADING_SHIP_PRICE . ' ' . TEXT_DESCENDINGLY)."</a> <br> " . TABLE_HEADING_SHIP_PRICE . "</td>";?> </tr> </table> </td> <td class="dataTableHeadingContent" align="center" valign="top"> <table border="0" cellspacing="1" cellpadding="2"> <tr class="dataTableHeadingRow"> <td class="dataTableHeadingContent" align="center" valign="top"> <?php echo "???<a href=\"" . tep_href_link( FILENAME_QUICK_UPDATES, 'cPath='. $current_category_id .'&sort_by=ps.products_ship_price_two ASC&page=' . $page.'&row_by_page=' . $row_by_page . '&manufacturer=' . $manufacturer) ."\" >".tep_image(DIR_WS_IMAGES . 'icon_up.gif', TEXT_SORT_ALL . TABLE_HEADING_SHIP_PRICE_TWO . ' ' . TEXT_ASCENDINGLY)."</a> <a href=\"" . tep_href_link( FILENAME_QUICK_UPDATES, 'cPath='. $current_category_id .'&sort_by=ps.products_ship_price_two DESC&page=' . $page.'&row_by_page=' . $row_by_page . '&manufacturer=' . $manufacturer) ."\" >".tep_image(DIR_WS_IMAGES . 'icon_down.gif', TEXT_SORT_ALL . TABLE_HEADING_SHIP_PRICE_TWO . ' ' . TEXT_DESCENDINGLY)."</a> <br> " . TABLE_HEADING_SHIP_PRICE_TWO . "</td>";?> </tr> </table> </td> <!-----// Ship Price & Ship Price two //-------->
Recommended Posts
Archived
This topic is now archived and is closed to further replies.