Description in Product Listing MS2 Error

[spr1nt]

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.

-spr1nt

[Guest]

Are you *sure* it's a fresh install?

 

When do you get this? Do you have a URL?

 

-jared

[spr1nt]

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/advanced_search_result.php

catalog/index.php

catalog/includes/classes/boxes.php

catalog/includes/functions/general.php

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:

 

http://s95228338.onlinehome.us/catalog3/index.php?cPath=2_19

 

:(

[Guest]

I get "Warning: mysql_connect(): Access denied for user: " when I try to connect to your site now.

 

-jared