tmcca 3 Posted September 6, 2017 @TsimiWas this fixed? Share this post Link to post Share on other sites
♥Tsimi 518 Posted September 6, 2017 (edited) 37 minutes ago, tmcca said: @TsimiWas this fixed? If you mean the issue reflex-ocasion mentioned, no, not that I know of. Edited September 6, 2017 by Tsimi Share this post Link to post Share on other sites
reflex-ocasion 8 Posted September 6, 2017 No, I have not been able to solve it, I have not had time and now less because I have a family in the hospital. It should not be complicated, just add missing code at that particular point. Right now I do not remember which line it is, I'm sorry. Share this post Link to post Share on other sites
Michalis2421 0 Posted March 8, 2018 hi, I am trying to install the Wishlist module for 2.3. https://apps.oscommerce.com/jABxb&wishlist&v=23 But while importing the sql i get the following error: #1062 - Duplicate entry '12954' for key 'PRIMARY' Any ideas on what should i do? THanks Share this post Link to post Share on other sites
♥Tsimi 518 Posted March 8, 2018 @Michalis2421 When you import the sql file in phpMyAdmin uncheck Do not use AUTO_INCREMENT for zero values and try it again. Share this post Link to post Share on other sites
Michalis2421 0 Posted March 8, 2018 Same thing happened: This is the query: DROP TABLE IF EXISTS customers_wishlist; CREATE TABLE customers_wishlist ( customers_wishlist_id int unsigned NOT NULL auto_increment, customers_id int unsigned NOT NULL default '0', products_id tinytext NOT NULL, customers_wishlist_quantity int(2) NOT NULL, final_price decimal(15,4), customers_wishlist_date_added char(8), PRIMARY KEY (customers_wishlist_id), KEY idx_wishlist_customers_id (customers_id) ) CHARACTER SET utf8 COLLATE utf8_unicode_ci; DROP TABLE IF EXISTS customers_wishlist_attributes; CREATE TABLE customers_wishlist_attributes ( customers_wishlist_attributes_id int unsigned NOT NULL auto_increment, customers_id int unsigned NOT NULL default '0', products_id tinytext NOT NULL, products_options_id int unsigned NOT NULL default '0', products_options_value_id int unsigned NOT NULL default '0', PRIMARY KEY (customers_wishlist_attributes_id), KEY idx_wishlist_att_customers_id (customers_id) ) CHARACTER SET utf8 COLLATE utf8_unicode_ci; INSERT INTO configuration_group ( configuration_group_id , configuration_group_title , configuration_group_description , sort_order , visible ) VALUES ( '12954', 'Wish List Settings', 'Settings for your Wish List', '25', '1' ); 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 ( '', 'Max Wish List', 'MAX_DISPLAY_WISHLIST_PRODUCTS', '30', 'How many wish list items to show per page on the main wishlist page', '12954', '', now(), now(), 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 ( '', 'Max Wish List Box', 'MAX_DISPLAY_WISHLIST_BOX', '4', 'How many wish list items to display in the infobox before it changes to a counter', '12954', '', now(), now(), 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 ( '', 'Display Emails', 'DISPLAY_WISHLIST_EMAILS', '10', 'How many emails to display when the customer emails their wish list link', '12954', '', now(), now(), 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 ( '', 'Wish List Redirect', 'WISHLIST_REDIRECT', 'No', 'Do you want to redirect back to the original page when a customer adds a product to their wish list?', '12954', '', now(), now(), NULL , 'tep_cfg_select_option(array(\'Yes\', \'No\'),' ); Share this post Link to post Share on other sites
♥Tsimi 518 Posted March 8, 2018 (edited) Are you uploading the sql file via the import function or are you copy&pasting the sql code and then running it? Check your configuration_group table if there is an entry with the configuration_group_id 12954 already in there. If yes delete that entry and try to rund the sql file or code again. Edited March 8, 2018 by Tsimi Share this post Link to post Share on other sites
valquiria23 153 Posted June 8, 2018 Hello !! Does anyone know if this addon is compatible with OSC 2.3.4.1 EDGE? Best regards Valqui Please do not falsify my words. Are you interested in knowing who does it? Send me a PM. The Phoenix Club won't allow me to join - why not? Setting up a new Frozen site with so many nice addons available on the market. Community Oscommerce fan Share this post Link to post Share on other sites
♥Tsimi 518 Posted June 9, 2018 @valquiria23 It is not compatible with Edge or Frozen version. You'll have to hard code the FILENAME_ definitions replace all the HTTP_POST_VARS and HTTP_GET_VARS and all DIR_WS. I am sure you'll have to change some of the code to match it to the latest structure. 1 valquiria23 reacted to this Share this post Link to post Share on other sites
♥Tsimi 518 Posted June 27, 2018 New version uploaded. Now compatible with the latest osC CE Frozen version. https://apps.oscommerce.com/wS75s&wishlist-bs If you use an older version of the community edition please download the previous release. 3 raiwa, valquiria23 and altoid reacted to this Share this post Link to post Share on other sites
valquiria23 153 Posted June 27, 2018 Dear @Tsimi Have you planned to update the old version to be compatible with 2.3.4.1 BS Edge where the file names are hardcoded? Best regards Valqui Please do not falsify my words. Are you interested in knowing who does it? Send me a PM. The Phoenix Club won't allow me to join - why not? Setting up a new Frozen site with so many nice addons available on the market. Community Oscommerce fan Share this post Link to post Share on other sites
♥Tsimi 518 Posted June 27, 2018 9 minutes ago, valquiria23 said: Dear @Tsimi Have you planned to update the old version to be compatible with 2.3.4.1 BS Edge where the file names are hardcoded? Best regards Valqui Yes i wanted to do that next. Probably tomorrow i should have time. 1 valquiria23 reacted to this Share this post Link to post Share on other sites
♥Tsimi 518 Posted June 28, 2018 @valquiria23 New package uploaded. Now containing files and install instructions for FROZEN and EDGE version. Enjoy! 1 1 valquiria23 and raiwa reacted to this Share this post Link to post Share on other sites
valquiria23 153 Posted June 28, 2018 Thank you very much @Tsimi !!!! it!! Please do not falsify my words. Are you interested in knowing who does it? Send me a PM. The Phoenix Club won't allow me to join - why not? Setting up a new Frozen site with so many nice addons available on the market. Community Oscommerce fan Share this post Link to post Share on other sites
puggybelle 27 Posted October 10 A lot of posters have been looking for the ability to show Out Of Stock on items with zero quantity on a Wish List. Me, too so....this is what I came up with. I added a new language define for Out Of Stock in catalog/includes/languages/english/wishlist.php define('TEXT_OUT', 'Out Of Stock'); Then in catalog/includes/classes/wishlist.php, around line 350, you'll see a list of entries for the products_array, looks like this: 'name' => $products['products_name'], 'products_status' => $products['products_status'], 'model' => $products['products_model'], 'image' => $products['products_image'], 'price' => $products['products_price'], 'quantity' => $this->contents[$products_id]['qty'], 'stock' => $products['products_quantity'], 'weight' => $products['products_weight'], 'final_price' => ($products['products_price'] + $this->attributes_price($products_id)), 'tax_class_id' => $products['products_tax_class_id'], The new line to be entered is the one in boldface above for 'stock' Lastly, open catalog/wishlist.php and scroll down, around line 375, to see ****** CHECK TO SEE IF PRODUCT IS NO LONGER AVAILABLE ****** Directly below it you will see: if($products[$i]['products_status'] == 0) { echo '<br /><strong style="color: red">' . TEXT_ITEM_NOT_AVAILABLE . '</strong>'; } Below that, add the following code: if($products[$i]['stock'] == 0) { echo '<br /><strong style="color: red">' . TEXT_OUT . ' </strong>'; } The end result will be your items with zero quantity displaying Out Of Stock on the Wishlist, like this: For those of you who have items set up to be turned off in Admin when quantity hits zero, you will see the Item no longer available message instead. What I don't like about that...and it's always been an issue....is that the Select box gets removed from that one. See A Bug's Life (now turned off in Admin): The intent is to not allow the item to be added to the cart, but...if the Select field is gone...you can't delete it from your Wish List, either! This has always been a problem, no fix that I'm aware of, so....I personally just use the if statement regarding 'stock' and get rid of the first one that references 'products_status'. I never turn off items in Admin, anyway. The one thing I can't seem to remedy is what happens with the wishlist_public.php file. That's the link that is sent to someone after a buyer chooses to send their Wish List to a friend. The same code I applied in wishlist.php is not achieving the same result in wishlist_public.php. It's simply putting Out Of Stock on every item in the list, whether it's available or not. So, I leave that file alone for now. Perhaps someone else can take a look at that file. Other than that, the wishlist_public.php file is okay - just no Out Of Stock messages for those receiving a link to the customer's Wish List. They'll only know the item is available (or not) after adding it to their cart. - Andrea Share this post Link to post Share on other sites
kgtee 30 Posted October 10 The select boxes are good if you have a long list of items. Otherwise the table can be modified to that of shopping cart where there is a refresh button and delete button next to the quantity box of each item. Share this post Link to post Share on other sites