Jump to content

ddggggdd

Members
  • Content count

    8
  • Joined

  • Last visited

Profile Information

  • Real Name
    Jason Zhou
  1. just mention that I want to show this all products page in the index page. So I simply changed the code: <td><?php include(DIR_WS_MODULES . FILENAME_NEW_PRODUCTS); ?></td> to <td><?php include(DIR_WS_MODULES . FILENAME_ALLPRODS); ?></td> Then I got the above mentioned error. Any one can help? Thanks
  2. Mysql 5 compatibility problem? I just installed this contribution and got error like this: " 1109 - Unknown table 'p' in field list select count(p.products_id) as total " After reading through this forum, I guess it's due to mysql 5 compatibility with line 149 in allprods.php: $listing_sql = "select p.products_id, p.products_model, pd.products_name, pd.products_description, p.products_image, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, p.products_date_added, m.manufacturers_name from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id $where order by pd.products_name"; But I don't know how to change. Anyone please help? Thanks.
×