Jack_mcs Posted June 7, 2007 Share Posted June 7, 2007 You would have to use phpmyadmin and remove it from the configuration table. Jack Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. All of My Addons Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
Jobu Posted June 8, 2007 Share Posted June 8, 2007 You would have to use phpmyadmin and remove it from the configuration table. Jack Super! Tnx for your quick response! Everything is smooooooth now :) Quote Link to comment Share on other sites More sharing options...
Escu Posted June 8, 2007 Share Posted June 8, 2007 well..i can't change the picture sizes. take a look here: http://www.eventshop.ro/index.php?cPath=40_33_32_79 i need a solution, please help Quote Link to comment Share on other sites More sharing options...
Jack_mcs Posted June 8, 2007 Share Posted June 8, 2007 The size of the images are controlled by settings in your shop (admin->Configuation->Images). This contribution doesn't control any of that. Jack Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. All of My Addons Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
Escu Posted June 8, 2007 Share Posted June 8, 2007 i understand, but i changed the values...and no luck. Quote Link to comment Share on other sites More sharing options...
Guest Posted June 11, 2007 Share Posted June 11, 2007 I have several items that appear in two catagories. This is because I copied them in the admin, using the "link to" choice. I have not actually listed them twice.When I look at the all products page, I see those items listed twice. Can I avoid this? Nevermind. I found that some of my items had been correctly linked, but others had not. Quote Link to comment Share on other sites More sharing options...
Guest Posted June 21, 2007 Share Posted June 21, 2007 Having a problem where if there are no products in a category (i.e "F" or "Z") then I get the following message: 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 '-30, 30' at line 1 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 products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join products_description pd on p.products_id = pd.products_id and pd.language_id = '1' left join specials s on p.products_id = s.products_id where pd.products_name like 'A%' AND p.products_status='1' order by pd.products_name limit -30, 30 Any ideas? Thanks. Quote Link to comment Share on other sites More sharing options...
Jack_mcs Posted June 21, 2007 Share Posted June 21, 2007 That's a known compatibility problem with the oscommerce code, not all products. Look in the update file in the latest oscommerce release and search for split_page_results.php for the fix. Jack Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. All of My Addons Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
Guest Posted June 25, 2007 Share Posted June 25, 2007 Having a problem where if there are no products in a category (i.e "F" or "Z") then I get the following message: 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 '-30, 30' at line 1 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 products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join products_description pd on p.products_id = pd.products_id and pd.language_id = '1' left join specials s on p.products_id = s.products_id where pd.products_name like 'A%' AND p.products_status='1' order by pd.products_name limit -30, 30 Any ideas? Thanks. Worked like a charm. Much obliged. :) Quote Link to comment Share on other sites More sharing options...
frieda Posted June 26, 2007 Share Posted June 26, 2007 Does anyone else have this problem or is it just me? When I open allprods.php I see all my prods as I should. If I click the prod description, I go to the prod page, as it should do. But when I click the manufacturer link, I get the no products found page. The problem is with the link but I cant see where the problem is. Here is a sample of my link when I click the manufacturer: IT IS www.mysite.com/index.php?manufacturers_id= SHOULD BE www.mysite.com/index.php?manufacturers_id=10 I have the same problem with 4.4g and was wondering if someone knows where to change the code? Quote Link to comment Share on other sites More sharing options...
What_the_ Posted July 11, 2007 Share Posted July 11, 2007 All Products plus STS/HTC. I resolved the problem of the blank all products page by editing catalog/includes/header_tags.php: - changed require(DIR_WS_FUNCTIONS . 'clean_html_comments.php'); - to require_once(DIR_WS_FUNCTIONS . 'clean_html_comments.php'); Does this sound sensible? Something similar was suggested in the installation docs for HTC if users of STS were having problems. THX! You saved my day! :thumbsup: Now I only need to find out how to change the font and it's color on the all products pages, and if I should install the HTC fixes or not, but these things are peanuts compared with the FATAL ERROR (w00t) screen... Muchas Gracias! Quote Link to comment Share on other sites More sharing options...
skhs Posted July 30, 2007 Share Posted July 30, 2007 Hey, Great contribution! Very useful. I was wondering if anyone can think of how I might go about omitting a certain categories products from the allproducts.php listing, if this is even possible? Basically I would like allproducts.php to work exactly as it now does, but omits all products from a specific category. I know it seems like a somewhat strange request (as it pretty much defeats the purpose of all products :huh: ) But any help would be much appreciated. Thanks. Quote Link to comment Share on other sites More sharing options...
Guest Posted August 9, 2007 Share Posted August 9, 2007 I would like to add my kudos to the author(s) of this contribution. I am not skilled in making changes in osCommerce, but the installation of this contribution was very easy for me and didn't take much time. Thanks for a great one! http://mirroroftime.com Quote Link to comment Share on other sites More sharing options...
ddggggdd Posted August 24, 2007 Share Posted August 24, 2007 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. Quote Link to comment Share on other sites More sharing options...
ddggggdd Posted August 25, 2007 Share Posted August 25, 2007 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 Quote Link to comment Share on other sites More sharing options...
Jack_mcs Posted August 25, 2007 Share Posted August 25, 2007 The code isn't made to be ran like that, thus the error. Jack Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. All of My Addons Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
narcolepticdriver Posted September 18, 2007 Share Posted September 18, 2007 I just made a few cosmetic changes to this contrib. But given the layout of my site, I'd like for there to be more listings shown per page. Here's my site http://www.stroller-roller.com/allprods.php. Is there an easy way to do this? Thanks. Mark Quote Link to comment Share on other sites More sharing options...
Jack_mcs Posted September 18, 2007 Share Posted September 18, 2007 See the search results option in admin->Configuration->My Store->Maximum Values. Jack Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. All of My Addons Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
narcolepticdriver Posted September 18, 2007 Share Posted September 18, 2007 Lol, now I feel stupid. :blink: Thanks a bunch. Quote Link to comment Share on other sites More sharing options...
rovshan Posted September 23, 2007 Share Posted September 23, 2007 QUOTE(sgreiner @ Sep 1 2006, 02:35 AM) Does anyone else have this problem or is it just me? When I open allprods.php I see all my prods as I should. If I click the prod description, I go to the prod page, as it should do. But when I click the manufacturer link, I get the no products found page. The problem is with the link but I cant see where the problem is. Here is a sample of my link when I click the manufacturer: IT IS www.mysite.com/index.php?manufacturers_id= SHOULD BE www.mysite.com/index.php?manufacturers_id=10 I have the same problem with 4.4g and was wondering if someone knows where to change the code? _____________________________ I have the same problem with 4.4g !!!!!!!!!!!!!!!!!!!!!!!!!!!!! help needed..... Quote Link to comment Share on other sites More sharing options...
kbking Posted September 26, 2007 Share Posted September 26, 2007 Today I added this version: All Products v4.4 MS 2.2 with Images Jack_mcs 26 Dec 2005 I have no products that begins with the letter Z. When I click on the Z, I get: Displaying 0 to 0 (of 0 products) Result Pages: -4 -3 -2 -1 0 instead of: There are no products to list in this category. As long as there are products, which has the same first character as the character clicked on, everything is fine! Any ideas what needs to be done here? Quote Link to comment Share on other sites More sharing options...
Jack_mcs Posted September 26, 2007 Share Posted September 26, 2007 I've never seen that before. What version of oscommerce, php and mysql are you using? Jack Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. All of My Addons Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
kbking Posted September 27, 2007 Share Posted September 27, 2007 (edited) I've never seen that before. What version of oscommerce, php and mysql are you using? Jack In aplication_top I found: // Define the project version define('PROJECT_VERSION', 'osCommerce 2.2-MS2'); In Admin->Tools->Server Info: PHP Version 5.2.3 In phpMyAdmin - 2.10.1: MySQL client version: 5.0.37 I have applied the update-20051113 and the update-20060817 as well as added this patch On top of this I have added all the patches for MySQL 5.0 Compatibility, posted here by Monica Mathe aka Monica in Germany I believe I have done the above with requiered carefulness. I hope it can be worked out, because this is an essential contribution to my store! :) PS. As I said, this is what I can see on the screen: Displaying 0 to 0 (of 0 products) Result Pages: -4 -3 -2 -1 0 When I click on -4 I see this: Displaying -99 to -80 (of 0 products) Result Pages: [Next >>] When I click on [Next>>] I see: Displaying -79 to -60 (of 0 products) Result Pages: [Next >>] and then: Displaying -59 to -40 (of 0 products) Result Pages: [Next >>] and then: Displaying -39 to -20 (of 0 products) Result Pages: [Next >>] and then again: Displaying 0 to 0 (of 0 products) Result Pages: -4 -3 -2 -1 0 DS. Edited September 27, 2007 by kbking Quote Link to comment Share on other sites More sharing options...
Jack_mcs Posted September 27, 2007 Share Posted September 27, 2007 I'm sorry but I don't have an answer for this one. It might be related to the php/mysql versions but I would think an error would be displayed instead of just incorrect output. All I can suggest is to create a new oscommerce shop, using standard code, and see if it works that way. If it does, then there is something in your shop at fault. Jack Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. All of My Addons Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
kbking Posted September 27, 2007 Share Posted September 27, 2007 Well I wanted All Products: Display ModeDisplay in standard table format (true=on false=off) to be set to false, because I liked the three column display better. When I change to true the page behaves, and shows the correct message for the character Z. And I guess it's partly because TEXT_NO_PRODUCTS is to be found in both modules/product_listing.php and in the language folder. Maybe it's my fault, then... But I'd like to know which settings I need to change in order to use the three column view and not the standard table format. Hope the above make sense. :) Thanks! 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.