Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Quick Updates and Individual Shipping error


pafranklin

Recommended Posts

Posted

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....!

  • 5 weeks later...
Posted
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?

Posted

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 //-------->

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...