ce7

Yes, it is great to move on new one, to make it more secure, but is it necessary to disable the old addons link? I learn the oscommerce and addons knowlege by view old addons in the past few years, and ask helps from forum, you took this option away. I learned C++ 20 years ago, compare to now, will you comment it that it is old, so not useful? And after all, it is up to website owners to design what version they like to move on. Beside, your link to new apps, not thing is working yet. Maybe admin can disable the old addons after confirm the new apps area works properly.

Yes, you as admin can decide what you want, but as user like us, when we are not ready to move on the new plate form and it is not right you just disable the old addons while we are still rely on those addons to make our old version website working. Also we have the right to use old version, you just dont need to support, why need to disable the old addone links? The reason we use oscommerce these years is that lots of experts here gave their great support free and share their addons free. If you want to make money, that is fair enough, but not continue to support the old version website and disable addons, yes, I feel like we are abandoned and not respected. After this frustrated and disappointed new update, I dont think I will not continue to use osCommerce any more. And special Thank You to the old version Oscommerce and experts who kindly share their time, knowledge and help, sorry you did not earn money from me but you earn respect from me.

@auzStar hi, thank you for this great addon. It is working great! i also install theme switcher and with few clicks, you can change the theme easily. right now i am setting dark background and that make the search result hard to read, which file should I check to change the color setting for search result text color, and is there a way it can auto change depending on UI setting? also i like to type a hint in the search blank area to let users know please at least type min 3 letters, which files should I change? many thanks! Lynn

@raiwahi Rainer, Thank you very much for reply. Yes I have resolve the problem, not sure why, I did not add two tax on same product, but i have seperated tax rate, each product can choose 10% or 7% or no tax, not able to choose 2 tax rate at the same time... The default of my installation seems just add 2 tax rate as 17%, but when I go to renew the 5 default products and change the tax rate, refresh, then it works as it should be 10% or 7% as I set up.... Thanks! Lyn

@raiwa hi again, Quick update, after I post here, I quickly installed another specials addon to do the test, and found out that the tax rate did work, but it did have problem to show the right rate at first, so there are few default special products, need to get into categories, and refresh the tax rate, then it will show up the correct one, if no refresh, it will stay as 17% instead of 10% or 7% or tax free... Thanks you!

the file with customers_group_price, customers_group_id is actually @ admin/includes/functions/general.php Find: $products_query = tep_db_query("select p.products_id, pd.products_name, p.products_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' order by products_name"); while ($products = tep_db_fetch_array($products_query)) { if (!in_array($products['products_id'], $exclude)) { $select_string .= '<option value="' . $products['products_id'] . '">' . $products['products_name'] . ' (' . $currencies->format($products['products_price']) . ')</option>'; } } Replaced with: //BOF 0716 Separate Pricing Per Customer if (!in_array($products['products_id'], $exclude)) { $price_query=tep_db_query("select customers_group_price, customers_group_id from products_groups where products_id = " . $products['products_id']); $product_prices=array(); while($prices_array=tep_db_fetch_array($price_query)){ $product_prices[$prices_array['customers_group_id']]=$prices_array['customers_group_price']; } reset($all_groups); $price_string=""; $sde=0; while(list($sdek,$sdev)=each($all_groups)){ if (!in_array((int)$products['products_id'].":".(int)$sdek, $exclude)) { if($sde) $price_string.=", "; $price_string.=$sdev.": ".$currencies->format(isset($product_prices[$sdek]) ? $product_prices[$sdek]:$products['products_price']); $sde=1; } } $select_string .= '<option value="' . $products['products_id'] . '">' . $products['products_name'] . ' (' . $price_string . ')</option>\n'; } // EOF Separate Pricing Per Customer } // end while ($products = tep_db_fetch_array($products_query)) //EOF 0716 Separate Pricing Per Customer I tried to use unmodified specials.php but it is showing up the same error, and go back to check on the installation and found out the code is modified @ general.php, not sure how to fix it in order to get rid of this 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 '' at line 1 select customers_group_price, customers_group_id from products_groups where products_id =

hi @Dan Cole @greasemonkey Thank you for reply. I downloaded from addons.oscommerce.com/info/0716 (20151005) BOOTSTRAP - SPPC 2.3.4 BS GOLD - v1.1b version. it said: Line 33 [41 in edited file] **AFTER** add the mentioned code. I am not programmer, know a bit only SQL so no idea how to fix this....just follow the installation instruction... I know it is not a good idea to mix the addons in different version, but few 2.2 version still working perfect with 234.1Edge (BS), so I gave this a try, not sure if the complete add one working or not, but with the admin, assign customer group or attribute group, it seems working, admin/specials.php is the only file so far have the error message.... Thanks! Lyn

@greasemonkey @Dan Cole hi I have 234.1 Edge (BS) with SPPC addons. in admin/catagories/special i can view and edit the special lists, but when i try to insert the new specials, i got this error: Product: 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 '' at line 1 select customers_group_price, customers_group_id from products_groups where products_id = and this is the code related in admin/special.php $price_query = tep_db_query("select customers_group_price from products_groups WHERE products_id = ".(int)$products_id . " AND customers_group_id = ".(int)$customers_group); and this is related SQL DROP TABLE IF EXISTS products_groups; CREATE TABLE `products_groups` ( `customers_group_id` smallint(5) UNSIGNED NOT NULL DEFAULT '0', `customers_group_price` decimal(15,4) NOT NULL DEFAULT '0.0000', `products_id` int(11) NOT NULL DEFAULT '0' ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; the error mentioned the MySQL version error, but dont know what how to write the right version for the ENGINE=.... part, can someone please help? Thanks! Lyn

hi, come back again for more question, found cid= with strange string, instead of product ID, so redo everything, and make sure it is all ok...new 234.1Edge (BS) now with the button working, however keep have error message (after enable SEO related modules) and also have this errors after add new catagories. Warning: imagesy() expects parameter 1 to be resource, boolean given in /home/catalog/includes/modules/kiss_image_thumbnailer/classes/Image.php on line 383 Warning: Division by zero in /home/home/catalog/includes/modules/kiss_image_thumbnailer/classes/Image.php on line 385 Warning: imagecreatetruecolor(): Invalid image dimensions in /home/home/catalog/includes/modules/kiss_image_thumbnailer/classes/Image.php on line 393 Warning: imagealphablending() expects parameter 1 to be resource, boolean given in /home/home/catalog/includes/modules/kiss_image_thumbnailer/classes/Image.php on line 394 Warning: imagesavealpha() expects parameter 1 to be resource, boolean given in /home/home/catalog/includes/modules/kiss_image_thumbnailer/classes/Image.php on line 395 Warning: imagefilledrectangle() expects parameter 1 to be resource, boolean given in /home/home/catalog/includes/modules/kiss_image_thumbnailer/classes/Image.php on line 397 Warning: imagecopyresampled() expects parameter 1 to be resource, boolean given in /home/home/catalog/includes/modules/kiss_image_thumbnailer/classes/Image.php on line 398 Warning: imagesx() expects parameter 1 to be resource, boolean given in /home/home/catalog/includes/modules/kiss_image_thumbnailer/classes/Image.php on line 400 Warning: imagesy() expects parameter 1 to be resource, boolean given in /home/home/catalog/includes/modules/kiss_image_thumbnailer/classes/Image.php on line 401 Warning: imagecopy() expects parameter 2 to be resource, boolean given in /home/home/catalog/includes/modules/kiss_image_thumbnailer/classes/Image.php on line 424 Not sure why this warning happened...can someone please help? Thanks! Lyn

@raiwa hi Raiwa, Thank you for our reply again. I have qtpro_functions.php in admin/includes/functions, however it is still showing up, so what I did is to include('includes/functions/qtpro_functions.php'); however it works sometimes and sometimes then show redirect error.... SEO error is similar situation, I make sure there are all those seo functions in admin/includes/functions/general.php, but it still showing the error, and if i include again the genearl.php then it straight away show up redirect error, so i end up need to disable all SEO related modules. I think I just focus on QTPro now, deal with SEO later and will post in a proper post, sorry to mention it here as the situation is similar... Thank you! Lyn

@raiwa hi I have QTPro BS on 234.1Ege, it was ok before, but after enable SEO and QTPro (not sure QT Pro Stock Table or Product Lisiting QTPro) now i getting this error: Fatal error: Call to undefined function qtpro_doctor_investigate_product() /categories.php on line 34 ---> $qtpro_sick_count = qtpro_sick_product_count(); Fatal error: Call to undefined function tep_get_products_seo_title() in /home/catalog/admin/categories.php on line 744 ---> <td class="main"><?php echo tep_image(tep_catalog_href_link('includes/languages/' . $languages[$i]['directory'] . '/images/' . $languages[$i]['image'], '', 'SSL'), $languages[$i]['name']) . '&nbsp;' . tep_draw_input_field('products_seo_title[' . $languages[$i]['id'] . ']', (empty($pInfo->products_id) ? '' : tep_get_products_seo_title($pInfo->products_id, $languages[$i]['id'])), 'style="width: 500px;"'); ?></td> Fatal error: Call to undefined function tep_get_products_seo_keywords() in /home/catalog/admin/categories.php on line 1004---> echo tep_draw_input_field('products_seo_keywords[' . $languages[$i]['id'] . ']', tep_get_products_seo_keywords($pInfo->products_id, $languages[$i]['id']), 'placeholder="' . PLACEHOLDER_COMMA_SEPARATION . '" style="width: 300px;"'); Fatal error: Call to undefined function tep_get_category_seo_title() in /home/catalog/admin/categories.php on line 1363---> $category_seo_title_string .= '<br />' . tep_image(tep_catalog_href_link('includes/languages/' . $languages[$i]['directory'] . '/images/' . $languages[$i]['image'], '', 'SSL'), $languages[$i]['name']) . '&nbsp;' . tep_draw_input_field('categories_seo_title[' . $languages[$i]['id'] . ']', tep_get_category_seo_title($cInfo->categories_id, $languages[$i]['id'])); can someone please advise how to fix this as now i can not modify add or modify product in the admin, thanks! Lyn

@raiwa Thank you! Sorry did not read the instruction carefully, just trying to find the code....and about the button, finally fix it, use dreamweaver to past the code, not working, but use ultraedit, it is working....not sure why... thank you very much for the add on and all the issue helps! Lyn

@raiwa Hi Raiwa, Thank you for the reply. Will try to check the button later on. I have one more question about the thumbnail. I have the thumbnail on product_info.php with the newest kiss_gallery, which is working great. However is there a way to have the thumbnail but no the watermark on the image? do i go to delete the ((KISSIT_MAIN_PRODUCT_WATERMARK_SIZE > 0) or need to do something with the configuration setting? Thanks! Lyn

@raiwa Thanks for reply. And continue question, sorry lots of questions 😂 After install KissIT, I found the button of add to cart is changed to grey, and the button of review became just text with link. How can I change it back to original one? image on the top: before KissIT has green add to cart button and reviews button Image on the top: after KissIT, somehow the Add to Cart and Reviews is different... not sure if i did something wrong.... Thanks! Lyn