241 Posted March 30, 2005 Author Share Posted March 30, 2005 Hello Steve, I installed this contribution and i got to say it works great. This is what i was looking for but I do have a simple question. I have set Words per short description when it's not written to 0 so no words show up but now i get ---- and i want to be able to remove the it. You can see herehere what i'm talking about. THANKS! <{POST_SNAPBACK}> the ....... is the more info text which can be replaced with an image the code line is in languages/english/index.php define('TEXT_MORE_INFO', '......'); Quote No longer giving free advice. Please place deposit in meter slot provided. Individual: [=] SME: [==] Corporation: [===] If deposit does not fit one of the slots provided then you are asking too much! Is your Osc dated try Phoenix raising oscommerce from the ashes. Link to comment Share on other sites More sharing options...
tyad Posted April 10, 2005 Share Posted April 10, 2005 Hi, I have installed this contribution and it worked great!! thank you for that. I do have one problem though, i removed all my products and categories from my site to start afresh, now there seems to be ghost categories showing up in featured sets, Anyone know what this could be ? The featured products work fine (because i didnt have any featured products before i removed all my products/categories/manufacturers). you can take a look at My Webpage Cheerz Drew Quote Link to comment Share on other sites More sharing options...
tyad Posted April 10, 2005 Share Posted April 10, 2005 Hi, I have installed this contribution and it worked great!! thank you for that. I do have one problem though, i removed all my products and categories from my site to start afresh, now there seems to be ghost categories showing up in featured sets, Anyone know what this could be ? The featured products work fine (because i didnt have any featured products before i removed all my products/categories/manufacturers). you can take a look at My Webpage Cheerz Drew <{POST_SNAPBACK}> Ok just changed the layout position and it dissappeared ..hmmz Quote Link to comment Share on other sites More sharing options...
241 Posted April 10, 2005 Author Share Posted April 10, 2005 Ok just changed the layout position and it dissappeared ..hmmz <{POST_SNAPBACK}> The ghost image you refer to would have been a case of featured manufacturer with products being active. Quote No longer giving free advice. Please place deposit in meter slot provided. Individual: [=] SME: [==] Corporation: [===] If deposit does not fit one of the slots provided then you are asking too much! Is your Osc dated try Phoenix raising oscommerce from the ashes. Link to comment Share on other sites More sharing options...
tyad Posted April 10, 2005 Share Posted April 10, 2005 The ghost image you refer to would have been a case of featured manufacturer with products being active. <{POST_SNAPBACK}> Yeah i understand that now - my previous post with the layout changes didnt fix it it just hid them, The ghost images shouldnt be there though - should they ? even if i have a manufacturer, a product a category and manufacturer with product active this is what i get -->> My Webpage, Plus in my store i only have 1 product, 1 manufacturer, 1 category. Hope anyone can help with this ,,,, ive set all the featured sets to true. Cheerz Drew Quote Link to comment Share on other sites More sharing options...
241 Posted April 26, 2005 Author Share Posted April 26, 2005 (edited) set each featured set to false in turn to determine which is causing the issue you have an error in your product_info.php as it shows code } ?> although this is a seperate issue to be discussed in another thread Edited April 26, 2005 by 241 Quote No longer giving free advice. Please place deposit in meter slot provided. Individual: [=] SME: [==] Corporation: [===] If deposit does not fit one of the slots provided then you are asking too much! Is your Osc dated try Phoenix raising oscommerce from the ashes. Link to comment Share on other sites More sharing options...
ipimen Posted May 13, 2005 Share Posted May 13, 2005 Hi. I have just tried installing this contribution and after making all modifications i get this error when running the file featuredsets.sql on my DB SQL-query: ALTER TABLE `manufacturers_info` CHANGE `manufacturers_id` `manufacturers_id` INT( 11 ) DEFAULT '0' NOT NULL AUTO_INCREMENT MySQL said: Documentation #1067 - Invalid default value for 'manufacturers_id' I then tried to make the changes on a clean installation and got exactly the same error. Any ideas? Quote Link to comment Share on other sites More sharing options...
241 Posted May 13, 2005 Author Share Posted May 13, 2005 Hi. I have just tried installing this contribution and after making all modifications i get this error when running the file featuredsets.sql on my DB SQL-query: ALTER TABLE `manufacturers_info` CHANGE `manufacturers_id` `manufacturers_id` INT( 11 ) DEFAULT '0' NOT NULL AUTO_INCREMENT MySQL said: Documentation #1067 - Invalid default value for 'manufacturers_id' I then tried to make the changes on a clean installation and got exactly the same error. Any ideas? <{POST_SNAPBACK}> Try changing the sql statement to this: ALTER TABLE `manufacturers_info` CHANGE `manufacturers_id` `manufacturers_id` INT( 11 ) NOT NULL AUTO_INCREMENT; This only appears to affect certain versions of mysql Quote No longer giving free advice. Please place deposit in meter slot provided. Individual: [=] SME: [==] Corporation: [===] If deposit does not fit one of the slots provided then you are asking too much! Is your Osc dated try Phoenix raising oscommerce from the ashes. Link to comment Share on other sites More sharing options...
akkinmore Posted May 13, 2005 Share Posted May 13, 2005 Hi, I have the following problem. ******* Featured Products Products Status Action 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 '-12, 12' at line 1 select p.products_id, pd.products_name, s.featured_id, s.featured_date_added, s.featured_last_modified, s.expires_date, s.date_status_change, s.status from products p, featured s, products_description pd where p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = s.products_id order by pd.products_name limit -12, 12 [TEP STOP] ******* I am using osC MS2 2.2 and followed instructions exactly. Previous post did not mention any solution. Any help would be appreciated. Thank you in advance for your time. :blush: Quote Link to comment Share on other sites More sharing options...
241 Posted May 13, 2005 Author Share Posted May 13, 2005 (edited) Hi,I have the following problem. ******* Featured Products Products Status Action 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 '-12, 12' at line 1 select p.products_id, pd.products_name, s.featured_id, s.featured_date_added, s.featured_last_modified, s.expires_date, s.date_status_change, s.status from products p, featured s, products_description pd where p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = s.products_id order by pd.products_name limit -12, 12 [TEP STOP] ******* I am using osC MS2 2.2 and followed instructions exactly. Previous post did not mention any solution. Any help would be appreciated. Thank you in advance for your time. :blush: <{POST_SNAPBACK}> This is a split page issue which may be due to the version of mysql being used. Tom aka Oceanranch gave a good account of this issue here Click to view topic: Split happens Edited May 13, 2005 by 241 Quote No longer giving free advice. Please place deposit in meter slot provided. Individual: [=] SME: [==] Corporation: [===] If deposit does not fit one of the slots provided then you are asking too much! Is your Osc dated try Phoenix raising oscommerce from the ashes. Link to comment Share on other sites More sharing options...
ipimen Posted May 13, 2005 Share Posted May 13, 2005 Try changing the sql statement to this: ALTER TABLE `manufacturers_info` CHANGE `manufacturers_id` `manufacturers_id` INT( 11 ) NOT NULL AUTO_INCREMENT; This only appears to affect certain versions of mysql <{POST_SNAPBACK}> THANK U THANK U :D All working now :thumbsup: Quote Link to comment Share on other sites More sharing options...
Guest Posted August 12, 2005 Share Posted August 12, 2005 Hey there, We are currently building a new site and had a developer helping us. He has installed your featured sets contribution. They have been working beautifully and our developer has changed some stuff to get it looking pretty - but I have noticed that the special prices are not removed when a special becomes inactive (ie specials_status = '0'). Is this a known bug - or is it something that we have inadvertantly changed??? I cannot contact my developer and was wondering if you could point out the code that checks the status of the special so I can update our code. We go live in a couple of days and I would appreciate any help I can get! Quote Link to comment Share on other sites More sharing options...
241 Posted August 12, 2005 Author Share Posted August 12, 2005 Hey there,We are currently building a new site and had a developer helping us. He has installed your featured sets contribution. They have been working beautifully and our developer has changed some stuff to get it looking pretty - but I have noticed that the special prices are not removed when a special becomes inactive (ie specials_status = '0'). Is this a known bug - or is it something that we have inadvertantly changed??? I cannot contact my developer and was wondering if you could point out the code that checks the status of the special so I can update our code. We go live in a couple of days and I would appreciate any help I can get! <{POST_SNAPBACK}> In catalog/includes/modules/featured_sets.php locate code around line #42 'specials_price' => $featured_products['specials_new_products_price'], 'tax_class_id' => $featured_products['products_tax_class_id']); change to 'specials_price' => $featured_products['specials_new_products_price'], 'specials_status' => $featured_products['specstat'], 'tax_class_id' => $featured_products['products_tax_class_id']); In catalog/includes/modules/featured_products.php locate code around line #26 if ($featured_products_array[$i]['specials_price']) { change to if (($featured_products_array[$i]['specials_price']) && ($featured_products_array[$i]['specials_status'] == '1')) { Quote No longer giving free advice. Please place deposit in meter slot provided. Individual: [=] SME: [==] Corporation: [===] If deposit does not fit one of the slots provided then you are asking too much! Is your Osc dated try Phoenix raising oscommerce from the ashes. Link to comment Share on other sites More sharing options...
Guest Posted August 13, 2005 Share Posted August 13, 2005 Thanks so much for this - I made the changes and it all worked perfectly. It's so easy when your told what to do. I love this contribution. :D :D Quote Link to comment Share on other sites More sharing options...
MagazineMonkey Posted August 27, 2005 Share Posted August 27, 2005 Hello all :D First, THANK YOU for making this Steve...its what I've been looking for. Being the slow person that I am, I'm sure I'm missing something totally obvious here, but.... I did a fresh install of osCommerce on the test site. I uploaded your Contribution..No errors at all. However, I can't figure out how to make my products come up on the homepage :blush: In Admin, I turned off featured manufactures, categories, etc. Featured product is enabled. I'm just looking to place a few hot items on the homepage. What am I missing here? Sorry for the (I'm sure) dumb question, but I'm not seeing it. ;-) Rob Quote ---------------------- osC common questions Knowledge Base osC Documentation Link to comment Share on other sites More sharing options...
241 Posted August 27, 2005 Author Share Posted August 27, 2005 Hello all :D First, THANK YOU for making this Steve...its what I've been looking for. Being the slow person that I am, I'm sure I'm missing something totally obvious here, but.... I did a fresh install of osCommerce on the test site. I uploaded your Contribution..No errors at all. However, I can't figure out how to make my products come up on the homepage :blush: In Admin, I turned off featured manufactures, categories, etc. Featured product is enabled. I'm just looking to place a few hot items on the homepage. What am I missing here? Sorry for the (I'm sure) dumb question, but I'm not seeing it. ;-) Rob <{POST_SNAPBACK}> possibly this post may help http://www.oscommerce.com/forums/index.php?sho...ndpost&p=413494 Once you have set this in the catalog/index.php you should just need to set the products that you want to be featured as featured status active and they will show. Quote No longer giving free advice. Please place deposit in meter slot provided. Individual: [=] SME: [==] Corporation: [===] If deposit does not fit one of the slots provided then you are asking too much! Is your Osc dated try Phoenix raising oscommerce from the ashes. Link to comment Share on other sites More sharing options...
MagazineMonkey Posted August 27, 2005 Share Posted August 27, 2005 That was it Steve :D A million thanks! Other than that part I missed, this was by far the easiest contribution to do. Thank you again, Rob Quote ---------------------- osC common questions Knowledge Base osC Documentation Link to comment Share on other sites More sharing options...
MagazineMonkey Posted August 27, 2005 Share Posted August 27, 2005 Oh no... back again :D Just wondering...is there a way to have featured products listed, as well as new products. Ideally, featured on top and new products under that? Thanks, Rob Quote ---------------------- osC common questions Knowledge Base osC Documentation Link to comment Share on other sites More sharing options...
241 Posted August 29, 2005 Author Share Posted August 29, 2005 Oh no... back again :D Just wondering...is there a way to have featured products listed, as well as new products. Ideally, featured on top and new products under that? Thanks, Rob <{POST_SNAPBACK}> yes instead of replacing the code from your previous question you would add the code line below so as to be <tr> <td><?php include(DIR_WS_MODULES . FILENAME_FEATURED_SETS); ?></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td><?php include(DIR_WS_MODULES . FILENAME_NEW_PRODUCTS); ?></td> </tr> Quote No longer giving free advice. Please place deposit in meter slot provided. Individual: [=] SME: [==] Corporation: [===] If deposit does not fit one of the slots provided then you are asking too much! Is your Osc dated try Phoenix raising oscommerce from the ashes. Link to comment Share on other sites More sharing options...
MagazineMonkey Posted August 29, 2005 Share Posted August 29, 2005 possibly this post may help http://www.oscommerce.com/forums/index.php?sho...ndpost&p=413494 Once you have set this in the catalog/index.php you should just need to set the products that you want to be featured as featured status active and they will show. <{POST_SNAPBACK}> Got it...anyway to have featured products on top, and still have new products following that? Thanks, Rob Quote ---------------------- osC common questions Knowledge Base osC Documentation Link to comment Share on other sites More sharing options...
241 Posted August 29, 2005 Author Share Posted August 29, 2005 Got it...anyway to have featured products on top, and still have new products following that? Thanks, Rob <{POST_SNAPBACK}> Read my last reply to you Quote No longer giving free advice. Please place deposit in meter slot provided. Individual: [=] SME: [==] Corporation: [===] If deposit does not fit one of the slots provided then you are asking too much! Is your Osc dated try Phoenix raising oscommerce from the ashes. Link to comment Share on other sites More sharing options...
MagazineMonkey Posted August 29, 2005 Share Posted August 29, 2005 Opps...I didn't see that :D If I could read, i'd be dangerous :lol: rob Quote ---------------------- osC common questions Knowledge Base osC Documentation Link to comment Share on other sites More sharing options...
houseofebook Posted August 29, 2005 Share Posted August 29, 2005 (edited) Wow, this contrib sounds great, and i was so exited to get it installed i worked whole night y'day to install it, but :( :( :( :( Actually i am using BTS, anyway, is it possible for someone to have just installation instructions in a readme.txt file ?? like find and replace stuff... I would be really thankfull if someone could get me these instructions. And i am sure this contrib will be very much popular soon. Thank you in advance. Naved Edited August 30, 2005 by 241 Quote Link to comment Share on other sites More sharing options...
MagazineMonkey Posted August 30, 2005 Share Posted August 30, 2005 When I try to upload the SQL file, it says this: Error SQL query: ALTER TABLE `manufacturers_info` CHANGE `manufacturers_id` `manufacturers_id` INT( 11 ) DEFAULT '0' NOT NULL AUTO_INCREMENT MySQL said: #1067 - Invalid default value for 'manufacturers_id' Any ideas? Thank you! Rob Quote ---------------------- osC common questions Knowledge Base osC Documentation Link to comment Share on other sites More sharing options...
241 Posted August 30, 2005 Author Share Posted August 30, 2005 When I try to upload the SQL file, it says this: Error SQL query: ALTER TABLE `manufacturers_info` CHANGE `manufacturers_id` `manufacturers_id` INT( 11 ) DEFAULT '0' NOT NULL AUTO_INCREMENT MySQL said: #1067 - Invalid default value for 'manufacturers_id' Any ideas? Thank you! Rob <{POST_SNAPBACK}> this previous post has the answer http://www.oscommerce.com/forums/index.php?sho...ndpost&p=612729 Quote No longer giving free advice. Please place deposit in meter slot provided. Individual: [=] SME: [==] Corporation: [===] If deposit does not fit one of the slots provided then you are asking too much! Is your Osc dated try Phoenix raising oscommerce from the ashes. 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.