Receiving Unknown column Error - Please Help

[CallCarrie]

Good Day,

 

I've successfully installed this great contribution, but am receiving the following error:

 

1054 - Unknown column 'pd.short_desc' in 'field list'

 

select p.products_image, pd.products_name, pd.short_desc, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join specials s on p.products_id = s.products_id, products_to_categories p2c where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '23' order by pd.products_name limit 0, 10

 

I have the Short Description mod added, and followed your specific instructions and added the necessary line of code at the end of:

 

    $select_column_list = '';

   for ($i=0, $n=sizeof($column_list); $i<$n; $i++) {
     switch ($column_list[$i]) {
       case 'PRODUCT_LIST_MODEL':
         $select_column_list .= 'p.products_model, ';
         break;
       case 'PRODUCT_LIST_NAME':
         $select_column_list .= 'pd.products_name, ';
         break;
       case 'PRODUCT_LIST_MANUFACTURER':
         $select_column_list .= 'm.manufacturers_name, ';
         break;
       case 'PRODUCT_LIST_QUANTITY':
         $select_column_list .= 'p.products_quantity, ';
         break;
       case 'PRODUCT_LIST_IMAGE':
         $select_column_list .= 'p.products_image, ';
         break;
       case 'PRODUCT_LIST_WEIGHT':
         $select_column_list .= 'p.products_weight, ';
         break;
     }
   }

$select_column_list .= 'pd.short_desc, ';

 

I inherited this client, and am new to osCommerce. I'm not even sure what modifications had been made prior to me, so maybe there is something I'm missing.

 

I greatly appreciate any help and thank you in advance,

CArRiE

[web-project]

the short_desc field is missing from the products_description table.