chrometweaks.org

Building a website with iPage one question best answer 10points?

Click Here To View All Answers...


My question is Building a website with iPage one question best answer 10points? Hoping for any comment. Another question on my mind: Hi,.

Can someone tell me of a contrib that actually works and adds a description to the product listings. I'm looking for something that adds only the first X amount of characters of the ORIGNAL description, if possible?.

I've tried one contrib, installed it exactly as instructed and I got constant errors. I've used the ShortDescription contrib too but I don't want to have to write ANOTHER decription for each item..

I know there's probably one out there that will work and is more straight forward, so if someone could point me in the right direction I'd be EXTREMELY grateful..

Thanks to all who reply..

Ed...

Comments (158)

Hmm... I need to find out myself. I don't know what is the answer to your question. I'll do some investigation and get back to you if I bump into an good answer. You should email the people at iPage as they probably can help you..

Comment #1

Thanks for that. I'll try it out and let you know..

Ed...

Comment #2

Hi,.

I tried the contrib and got the same errors as before, when I tried using a similar one. I'm thinking it's SQL related. I get this code in place of the products listings?.

1064 - You have an error in your SQL syntax near ' pd.products_name, , pd.products_description, , p.products_id, p.manufacturers_' at line 1.

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 = '24' order by pd.products_name limit 0, 20.

I don't know what this is supposed to mean, I've followed the install.txt word for word, I've even tried it on a fresh install of OSC and had the same problem..

Has anyone got any ideas?.

Please help! Thanks..

Ed..

Comment #3

Here is the product description mod I used:.

Http://www.oscommerce.com/community/contri...ns,1210/page,18.

It's a very simple addon..

Comment #4

1064 - You have an error in your SQL syntax near ' pd.products_name, , pd.products_description, , p.products_id, p.manufacturers_' at line 1.

Looks like you've got some extra commas in the code (index.php, I think) here:.

Try removing those and see what happens..

HTH,.

Terry..

Comment #5

A big thanks to everyone...

Noobish, I did try the contrib you posted and got the same errors near enough:.

Product Listings  .

1064 - You have an error in your SQL syntax near '.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(' at line 1.

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 = '21' order by pd.products_name limit 0, 20.

I've tried 3 different ones now and they all produce an SQL related error??.

Can anyone tell me what I need to do please?.

Ed..

Comment #6

Anyone at all have any ideas what I might need to do?.

Please!.

Thanks...

Comment #7

It looks like you syntax erro mmight be coming from a missing , right after pd.product_description.

Select p.products_image, pd.products_name, pd.products_description p.products_id, p.manufacturers_id,.....

Make that fix and try it.....

Comment #8

Hey guys, ^^ I will give it a shot..

I think I've narrowed it down to this though, in index.php:.

When I change:.

Case 'PRODUCT_LIST_NAME':.

         $select_column_list .= 'pd.products_name';.

To:.

Case 'PRODUCT_LIST_NAME':.

         $select_column_list .= 'pd.products_name, pd.products_description';.

As directed by the install.txt, THAT is when the error is occuring. Just having the SQL data loaded in the database is not causing any problems because when I use the default index.php from out the box, it works fine, this is what is causing the problem.. Why is that though? It looks pretty straight forward code to me?.

Any help please?.

Thanks all...

Comment #9

The section of code you have posted is correct, so that makes me think that it is something else..

Are you using MS1??.

Bee sure you have the SQL data right. it seems like it is hanging when it hits the description in the query..

This post has been edited by.

Noobish-n-stuff.

: 29 January 2004, 02:17..

Comment #10

I'm using MS2 but I think the contrib may be for MS1? If so, is there anything I can change to adapt it?.

Thanks,.

Ed..

Comment #11

I've tried Terry's script again and removed the extra commas, now the error looks like this:.

1064 - You have an error in your SQL syntax near ' p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, ' at line 1.

Select p.products_image, pd.products_description, pd.products_name, , 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 = '21' order by pd.products_name limit 0, 7.

I've scanned over every piece of code comparing my files to the ones in the contrib (even tried uploading the actual ones in the contrib zip) and I'm still getting errors???.

Any ideas? Is it something to do with the SQL query I had to run, being incorrect?.

These are what I used (as instructed by install.txt):.

The first is to enable the display of Products Description in the Listing 0 = No 99 = Yes.

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);.

The second defines the number of characters to display before truncating the description.

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);.

Any ideas.. Pleeease??.

Ed..

Comment #12

Ed,.

When you ran the SQL query, did you get a message saying it was successful? Did you start with the INSERT INTO part of the code, or did you include the instructions above it? And did you run it all as one query, or did you do each query separately?.

Can you look in your database and see whether the fields the SQL query was attempting to create have been added to your configuration table?.

Terry..

Comment #13

1064 - You have an error in your SQL syntax near ' p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, ' at line 1.

Select p.products_image, pd.products_description, pd.products_name,  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 = '21' order by pd.products_name limit 0, 7.

Try that, as the extra comma was still in the code, is this in the product_info or product_listing php file?..

Comment #14

One thing I noticed when trying to install:.

In includes/modules/product_listing.php.

Where the instructions inputed a line that had $listing, that should actually be $listing_values.

There is only one instance of $listing, so you'll just need to do a search for it until you find it..

Another issue could be where the instructions said the include this too inside the }.

Make sure the content that was below that is inside the }.

Hope this helps,.

Scott..

Comment #15

Hi,.

Can someone tell me of a contrib that actually works and adds a description to the product listings. I'm looking for something that adds only the first X amount of characters of the ORIGNAL description, if possible?.

I've tried one contrib, installed it exactly as instructed and I got constant errors. I've used the ShortDescription contrib too but I don't want to have to write ANOTHER decription for each item..

I know there's probably one out there that will work and is more straight forward, so if someone could point me in the right direction I'd be EXTREMELY grateful..

Thanks to all who reply..

Ed...

Comment #16

I installed "Description in Product Listing MS2 Version 2.5, and it works well for me. Contrib can be found here:.

Http://www.oscommerce.com/community/contri...ons,1375/page,8.

HTH,.

Terry..

Comment #17


This question was taken from a support group/message board and re-posted here so others can learn from it.