Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

Description in Product Listing MS2 Error


Recommended Posts

after importing the sql commands and

replacing the needed files in catalog, this is the

error i get. on a fresh install of oscommerce 2.2 MS2.


1064 - You have an error in your SQL syntax. Check the
manual that corresponds to your MySQL server version
for the right syntax to use near ' p.products_id,
p.manufacturers_id, p.products_price, p.produc

select p.products_image, pd.products_name,
pd.products_description, , 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, products_to_categories p2c left
join specials s on p.products_id = s.products_id 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 = '19'
order by pd.products_name limit 0, 20


any help would be appreciated.


Link to comment
Share on other sites

yes, fresh install with no other contributions installed. using the install.txt as a guide. i replaced the necessary files on my server with the ones included in the contributions. these:






catalog/includes/modules/product_listing.php (removed colspan="<?php echo $colspan; ?>" from td tags as well)


then made the necessary sql queries.


INSERT INTO `configuration` (`configuration_id`, `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES ('', 'Display Product Description', 'PRODUCT_LIST_DESCRIPTION', '99', 'Set to 0 to disable, set to 99 to enable.', '8', '11', '', '', NULL, NULL);


 INSERT INTO `configuration` (`configuration_id`, `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES ('', 'Length of Truncated Product Description', 'PRODUCT_LIST_DESCRIPTION_LENGTH', '350', 'How many characters would you like to display? ', '8', '12', '2002-03-16 18:51:26', '2002-03-16 18:51:26', NULL, NULL);


my result:





Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Create New...