Jan Zonjee Posted January 7, 2009 Share Posted January 7, 2009 There are differences between the two files. The STS installation is as below, with the Line 78 code being $sts->image($src); // Take image from template folder if exists. OK, so the object $sts is not instantiated. That definitely has to do with STS and not with product listing. See if there is something in application_top.php that says $sts = new Whatever; I don't know what "Whatever" should be, so the $sts = new part is the part you could search for in the contribution files. Quote Link to comment Share on other sites More sharing options...
JonathanR Posted January 8, 2009 Share Posted January 8, 2009 Yes. Definitely STS causing the conflict, but I just couldn't suss out what to do! However, I have now successfully installed the Product Listing Enhancements, Thumbnails & Manufacturer Headings V1.8 contribution, with complete success - very happy! Â Thanks for your help, Jan. I must admit I didn't realise that some of the contributions on here need some additional tweaking if STS is used, as well as if other contributions are also installed. The Product Listing Enhancements takes into account other contributions that may be installed - making it extra clever! Â Well on the road to achieving what I want, now. Â Jonathan Quote Link to comment Share on other sites More sharing options...
Lady Lionheart Posted March 2, 2009 Share Posted March 2, 2009 Hi, Â I have a question, I installed this addon and it works great, but I also want in addition to the products in columns to add a short description to the products. So I installed before this one, Product description 1.5, which now since installing this addon stopped working, can anyone help me to get it working again? Â Thanks so much! Quote Link to comment Share on other sites More sharing options...
spooks Posted March 2, 2009 Share Posted March 2, 2009 I don't think this contrib has any option for that, however  Product Listing Enhancements, Thumbnails & Manufacturer Headings http://addons.oscommerce.com/info/6051  has built in support for short descriptions with http://addons.oscommerce.com/info/3123 Quote Sam  Remember, What you think I ment may not be what I thought I ment when I said it.  Contributions:  Auto Backup your Database, Easy way  Multi Images with Fancy Pop-ups, Easy way  Products in columns with multi buy etc etc  Disable any Category or Product, Easy way  Secure & Improve your account pages et al. Link to comment Share on other sites More sharing options...
Lady Lionheart Posted March 2, 2009 Share Posted March 2, 2009 I just want my website to look a lot better, because I think it looks like crap at the moment. I want a better products_listing and products_info display. I want them to be like this: http://www.reddotcommerce.nl/catalog/blood.html for listing and like this for info: http://www.reddotcommerce.nl/catalog/cardc...llscroll-1.html can anyone please help with this? Quote Link to comment Share on other sites More sharing options...
spooks Posted March 2, 2009 Share Posted March 2, 2009 The contrib I just mentioned can do that & better, there are page views within the contrib, take a look at them & see if its close. Quote Sam  Remember, What you think I ment may not be what I thought I ment when I said it.  Contributions:  Auto Backup your Database, Easy way  Multi Images with Fancy Pop-ups, Easy way  Products in columns with multi buy etc etc  Disable any Category or Product, Easy way  Secure & Improve your account pages et al. Link to comment Share on other sites More sharing options...
Lady Lionheart Posted March 2, 2009 Share Posted March 2, 2009 Ok thanks so much! I'll go try that right now. Quote Link to comment Share on other sites More sharing options...
Lady Lionheart Posted March 2, 2009 Share Posted March 2, 2009 Well I installed the addon, but it doesn't work, the settings don't change anything, the settings from product listing however do work, how can I fix this? Quote Link to comment Share on other sites More sharing options...
spooks Posted March 2, 2009 Share Posted March 2, 2009 not clear what you mean, what does'nt work?? Quote Sam  Remember, What you think I ment may not be what I thought I ment when I said it.  Contributions:  Auto Backup your Database, Easy way  Multi Images with Fancy Pop-ups, Easy way  Products in columns with multi buy etc etc  Disable any Category or Product, Easy way  Secure & Improve your account pages et al. Link to comment Share on other sites More sharing options...
Lady Lionheart Posted March 2, 2009 Share Posted March 2, 2009 Well it didn't work at all, but I put back a backup from the database and website and now it works. Can you tell me what settings to use to get the view I want? It looks like this now: http://www.cosplaydreams.nl/catalog/index....list=thumbnails as you can see the text is not aligned properly and so on, please help? Quote Link to comment Share on other sites More sharing options...
spooks Posted March 2, 2009 Share Posted March 2, 2009 You need to make sure you do everthing detailed in the install, not just some of it.  I don't see any of the css changes. Quote Sam  Remember, What you think I ment may not be what I thought I ment when I said it.  Contributions:  Auto Backup your Database, Easy way  Multi Images with Fancy Pop-ups, Easy way  Products in columns with multi buy etc etc  Disable any Category or Product, Easy way  Secure & Improve your account pages et al. Link to comment Share on other sites More sharing options...
Lady Lionheart Posted March 2, 2009 Share Posted March 2, 2009 Oh yeah I forgot to upload it, it's online now. But I still see no description even after installing the short_description mod (which was by the way extremely complicated to do in my opinion) help plz? :) Quote Link to comment Share on other sites More sharing options...
spooks Posted March 2, 2009 Share Posted March 2, 2009 Three points,  have you enabled the Product Listing Short Description option within Product Listing in admin  did you makes sure you added the line $select_column_list .= 'pd.short_desc, '; to index.php  Have you edited your product in admin and added any short descriptions? Quote Sam  Remember, What you think I ment may not be what I thought I ment when I said it.  Contributions:  Auto Backup your Database, Easy way  Multi Images with Fancy Pop-ups, Easy way  Products in columns with multi buy etc etc  Disable any Category or Product, Easy way  Secure & Improve your account pages et al. Link to comment Share on other sites More sharing options...
Lady Lionheart Posted March 3, 2009 Share Posted March 3, 2009 (edited) Right, now I see it works! Just didn't know it had a seperate input in the product creation screen. Â But now switch between list/column function now doesn't seem to work anymore, and the sort order function also disappeared, any suggestions? Â Thanks you're helping me so much! Edited March 3, 2009 by Lady Lionheart Quote Link to comment Share on other sites More sharing options...
spooks Posted March 3, 2009 Share Posted March 3, 2009 the list/column switch is turned on off in admin under product listing  I've no idea why your drops have gone, perhaps u changed smthing in product_listing.php module? try uploading the contrib version again Quote Sam  Remember, What you think I ment may not be what I thought I ment when I said it.  Contributions:  Auto Backup your Database, Easy way  Multi Images with Fancy Pop-ups, Easy way  Products in columns with multi buy etc etc  Disable any Category or Product, Easy way  Secure & Improve your account pages et al. Link to comment Share on other sites More sharing options...
Lady Lionheart Posted March 3, 2009 Share Posted March 3, 2009 Ok I uploaded them again, and it looks quite reasonable now, it's just that the short description doesn't display yet. I'll try following the instructions again.  And do you have suggestions how I can:  http://www.cosplaydreams.nl/catalog/index....amp;language=nl  1. Put the word 'Artikelen' more to the top and change it to the name of the series and add a description?  2. make the products_info more like this: http://www.reddotcommerce.nl/catalog/haruh...all-scroll.html with a resized picture and so on? Quote Link to comment Share on other sites More sharing options...
Lady Lionheart Posted March 3, 2009 Share Posted March 3, 2009 Well I tried following the instructions for the short description again, but it still doesn't work. It shows in the admin, but it doesn't show it on the website. Â I also added the addon descriptions for the categories, which also doesn't work, it again shows in the admin page where I can add a description to a category, but again it does not show on the website, HELP PLEASE I don't know what to do anymore *cries* Quote Link to comment Share on other sites More sharing options...
spooks Posted March 3, 2009 Share Posted March 3, 2009 (edited) did you makes sure you added the line $select_column_list .= 'pd.short_desc, '; to index.php ?  also if you add the line:  echo '<hr>' . $listing_sql . '<hr>';  before the last  ?>  in product_listing.php, shows if your creating a valid query.  Please move this to the correct thread, as you've moved away from this contrib http://www.oscommerce.com/forums/index.php?showtopic=307010 Edited March 3, 2009 by spooks Quote Sam  Remember, What you think I ment may not be what I thought I ment when I said it.  Contributions:  Auto Backup your Database, Easy way  Multi Images with Fancy Pop-ups, Easy way  Products in columns with multi buy etc etc  Disable any Category or Product, Easy way  Secure & Improve your account pages et al. Link to comment Share on other sites More sharing options...
magiaa Posted March 18, 2009 Share Posted March 18, 2009 Hi, I've installed only for listing product, but when I try to list my product I get the next error: Â 1054 - Unknown column 'p.products_id' in 'on clause' Â select count(p.products_id) as total 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 = '3' and p2c.categories_id = '40' Â [TEP STOP] Â anybody knows how to solve it? Quote Link to comment Share on other sites More sharing options...
Rachael w. Posted March 20, 2009 Share Posted March 20, 2009 Is there anyone out there who has successfully changed the product listing sort order in product_listing_col.php? I understand it defaults to A-Z (products_name) but I'd like to change that to sort by products_date_added. I've looked over the posts here and didnt really find a solution. Â Thanks in advance for your help! Quote Link to comment Share on other sites More sharing options...
spooks Posted March 20, 2009 Share Posted March 20, 2009 not related to this, or any listing contrib, look in tips, answer is there Quote Sam  Remember, What you think I ment may not be what I thought I ment when I said it.  Contributions:  Auto Backup your Database, Easy way  Multi Images with Fancy Pop-ups, Easy way  Products in columns with multi buy etc etc  Disable any Category or Product, Easy way  Secure & Improve your account pages et al. Link to comment Share on other sites More sharing options...
Rachael w. Posted March 20, 2009 Share Posted March 20, 2009 Sam, Â Thank you! I looked over that thread in my search and for some reason missed the solution entirely! The answer is HERE! Quote Link to comment Share on other sites More sharing options...
magiaa Posted March 22, 2009 Share Posted March 22, 2009 Hi, I've installed only for listing product, but when I try to list my product I get the next error: Â 1054 - Unknown column 'p.products_id' in 'on clause' Â select count(p.products_id) as total 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 = '3' and p2c.categories_id = '40' Â [TEP STOP] Â anybody know how to solve it? Quote Link to comment Share on other sites More sharing options...
Joe234 Posted March 22, 2009 Share Posted March 22, 2009 Likely an sql upgade issue (on your server), look in contribs for details on making sql statements comply with the latest versions  As I recall its the joins that are the problem area Quote Link to comment Share on other sites More sharing options...
Bennsen Posted March 24, 2009 Share Posted March 24, 2009 Hy there at all. Â At first, sorry for my english. Â I have installed Product Listing in Columns. Â I have also installed the TOTALB2B contrib. Â After installing the Product Listing in Columns is works, but it show wrong prices in the categorys... Â at the moment i have set the option in categorys "show price" to "false" Â but i want to set it to "true" Â Please can anybody help me?? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.