Featured Products MySQL error

[navyhost]

Hi guys,

 

I had a mod made for featured products and it was working on one of our sites but not the other (different servers)

 

Here is the error we are getting:

 

1054 - Unknown column 's.cat_id' in 'on clause'

select count(*) as total from products p, featured s, products_description pd left join fcat f on f.id = s.cat_id where p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = s.products_id

[TEP STOP]

 

This is the section where the code is being generated from:

<?php
$featured_query_raw = "select p.products_id, pd.products_name, s.featured_id, s.featured_date_added, s.featured_last_modified, s.expires_date, s.date_status_change, s.status, f.title as cat from " . TABLE_PRODUCTS . " p, " . TABLE_FEATURED . " s, " . TABLE_PRODUCTS_DESCRIPTION . " pd left join " . TABLE_FCAT . " f on f.id = s.cat_id where p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' and p.products_id = s.products_id order by pd.products_name";
$featured_split = new splitPageResults($HTTP_GET_VARS['page'], MAX_DISPLAY_SEARCH_RESULTS, $featured_query_raw, $featured_query_numrows);
$featured_query = tep_db_query($featured_query_raw);
while ($featured = tep_db_fetch_array($featured_query)) {
  if ( ((!$HTTP_GET_VARS['sID']) || ($HTTP_GET_VARS['sID'] == $featured['featured_id'])) && (!$sInfo) ) {

 

Any assistance in fixing this is greatly appreciated.

 

thanks

[♥geoffreywalton]

1054 - Unknown column 's.cat_id' in 'on clause'

 

select count(*) as total from products p, featured s, products_description pd left join fcat f on f.id = s.cat_id where p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = s.products_id

 

A field is missing in the db you are querying.

 

s.cat_is

 

Look for the letter s and you see featured s

 

so the table is called featured.

 

I would say the db on this second server has not been updated for some new fields or more likly the entire table does not exist.

 

s is featured

[navyhost]

1054 - Unknown column 's.cat_id' in 'on clause'

 

select count(*) as total from products p, featured s, products_description pd left join fcat f on f.id = s.cat_id where p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = s.products_id

 

A field is missing in the db you are querying.

 

s.cat_is

 

Look for the letter s and you see featured s

 

so the table is called featured.

 

I would say the db on this second server has not been updated for some new fields or more likly the entire table does not exist.

 

s is featured

Hey Geoffrey

 

Thank you for the input, I checked it out and it appeared all the fields were there. I decided to alter the left join comment and it appeared to work.