Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

ce7

Members
  • Posts

    644
  • Joined

  • Last visited

  • Days Won

    2

Everything posted by ce7

  1. @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
  2. @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
  3. @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!
  4. 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 =
  5. 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
  6. @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
  7. 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
  8. @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
  9. @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
  10. @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
  11. @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
  12. @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
  13. @Tsimi Thank you! It works perfectly! I just wonder if later on i installed what your add horizontal categories menu that Raiwa (Rainer) mentioned, do i need to change this code or just leave it as it is? Once again, thank you!
  14. @raiwa Thank you.I will install the horizontal categories menu later.... this is really helpful information. Back to the kiss thumbnail for image, i had installed it, however it is now showing two images at the same time, and it change the position from left top cornor to right bottom cornor. do i need to delete the original cm_pi_gallery.php and keep only cm_pi_gallery_kissit.php? which part is the code to change the image location? Thanks! Lyn
  15. @raiwa Thank you again! Sorry i will make a new thread later on about these image questions. I had installed the new 2.8.1 version, but not sure if it works, as I could not see anything change. In admin side, with new categoreis, it will show the image thumbnail for the folder, which is really helpful. And I maybe explained it wrong earlier, that I wondering if in the front page, categories infobox, will it possible to have the thumbnail inside that infobox (image | product categories) . The new one I installed suppose to do this way and somehow i made it wrong so doesn't show up? Thanks! Lyn
  16. @raiwa Thanks you, that is very quick! I was going to ask extra question....not fast as you respond! 🙂 It's nothing to do with this addon, but i just can not figure out where to change the set up, right now with Edge version, in the index.php, it is always showing 2 rows with 4 columns. And It is ok, however the 2nd row always only show up 2 columns, and the rest of left hand side remain blank. How can I make it show up 4 columns at the 2nd row. And I also have the special module (box) install, however, it only show up 1 product, is it possible to make it as 3rd row with 4 columns (4 products in one row). And I will try the 2.8.1 now, thanks again! Lyn
  17. @raiwa Thank you again for quick reply. I am not good at programming at all, yet try hard to self-learning oscommerce from scratch, start from 2.2-2.3.1, and now trying 234.1 Edge (BS). My product_info.php about the image is not the same as the installation instruction. #1 echo tep_image('images/' . $product_info['products_image'], NULL, NULL, NULL, 'itemprop="image" style="display:none;"'); #2 echo tep_image('images/'. $pi['image'], '', '', '', 'id="piGalImg_' . $pi_counter . '"'); #3 echo tep_image('images/'. $pi['image'], '', '', '', 'id="piGalImg_' . $pi_counter . '"'); However I found in the modules with this file: cm_pi_gallery.php and this is what i change, but it doesn't work, can you please help this out to have it show the thumbnail correctly in the front-end? #1 $pi_output .= '<div class="piGal" data-imgcount="' . $photoset_layout . KISSIT_MAIN_PRODUCT_IMAGE_WIDTH, KISSIT_MAIN_PRODUCT_IMAGE_HEIGHT . '">'; #2 list($width, $height) = file_exists('images/'. $pi['image'])? getimagesize('images/'. $pi['image']) : array(150,150); $pi_output .= tep_image('images/'. $pi['image'], addslashes($product_info['products_name']) . ' ' . $pi_counter, (($pi_counter > 1 )? round(KISSIT_MAIN_PRODUCT_IMAGE_WIDTH/(($pi_total <= 5)? $pi_total-1 : 5)) : KISSIT_MAIN_PRODUCT_IMAGE_WIDTH), (($pi_counter > 1 )? round(KISSIT_MAIN_PRODUCT_IMAGE_HEIGHT/(($pi_total <= 5)? $pi_total-1 : 5)) : KISSIT_MAIN_PRODUCT_IMAGE_HEIGHT), 'id="piGalImg_' . $pi_counter . '" '. ((KISSIT_MAIN_PRODUCT_WATERMARK_SIZE > 0)? preg_replace('%<img width="[0-9 ]+" height="[0-9 ]+" src="(.*)title=.+%', 'data-highres="$1', tep_image('images/'. $pi['image'], null, $width, $height)) : 'data-highres="'. 'images/'. $pi['image'] . '"')); #3 else { list($width, $height) = file_exists(DIR_WS_IMAGES . $product_info['products_image'])? getimagesize(DIR_WS_IMAGES . $product_info['products_image']) : array(150,150); Thanks! Lyn
  18. @raiwa Thank you for the solution! with KissIT images thumbnail, it is now working perfect in the admin site, I am not sure if i do it right but will it also show at the frontpage categories? It will be great to have thumbnail next to the name, for example /thumbnail Gadagets/. Thanks! Lyn
  19. @raiwa Thank you very much! Yes, I have lots of problem in DB and trying to fix it these couple days! Thank you for point it out! After fix the old ones, i will come back to test this addon. Lyn
  20. @raiwa Thank you for reply and sorry not be online for a while! I did uninstalled the store. however now i am having new problem, after uninstall, i trying to install and this is the error message i have Fatal error: Uncaught exception 'mysqli_sql_exception' with message 'Duplicate entry '0' for key 'PRIMARY'' in /home/mysite.com/admin/includes/functions/database.php:55 Stack trace: #0 /home/mysite.com/admin/includes/functions/database.php(55): mysqli_query(Object(mysqli), 'insert into con...') #1 /home/mysite.com/includes/modules/store/st_wholesale.php(81): tep_db_query('insert into con...') #2 /home/mysite.com/admin/modules.php(54): st_wholesale->install() #3 {main} thrown in /home/mysite.com/admin/includes/functions/database.php on line 55 I haven't change any code with the files...not sure what is going on... Lyn
  21. @raiwa Yes I did. And this error message is showing when you click on admin/customers it will show admin/customers.php, on the grey heading area, it will show this error message, i still be able to click on individual customer name, but i like to learn how to fix with constant, tried google but can get similar post and learn how to fix it myself....so come here to ask for help 🙂 Thanks Lyn
  22. @raiwa Hi, thank you very much for this addon. I orginal tried the addons.oscommerce.com/info/0716 almost done, but spend nearly a day still can not make the special price show correctly instead of 0.00, so gave up and found this addon. It showes the customer, just found a tiny warning: Warning: constant(): Couldn't find constant MODULE_STORE_WHOLESALE_ENTRY_WHOLESALE_ENGLISH does it mean need to define inside english folder? thanks! Lyn
  23. hi, thanks for this addon. I have installed it on 234.1Edge and it is work. However I think the admin site has something wrong with it, somehow the thumbnail directory not saved, and instead created a folder under admin, so it is like catalog/admin/DIR_WS_IMAGESthumbs/ there has no images generated inside. Something wrong I pasted with admin/includes/function/hutml_output.php ? Thanks! Lyn
  24. @raiwa Hi...raiwa, I am not native English speaker, so misunderstood sometimes with the 234.1 Edge version of the product_info.php i have, i am trying hard to figure out how to put code, but it is too hard, this is the file I have: <?php /* $Id$ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2010 osCommerce Released under the GNU General Public License */ require('includes/application_top.php'); if (!isset($_GET['products_id'])) { tep_redirect(tep_href_link('index.php')); } require('includes/languages/' . $language . '/product_info.php'); $product_check_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$_GET['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'"); $product_check = tep_db_fetch_array($product_check_query); require('includes/template_top.php'); if ($product_check['total'] < 1) { ?> <div class="contentContainer"> <div class="row"> <?php echo $oscTemplate->getContent('product_info_not_found'); ?> </div> </div> <?php } else { $product_info_query = tep_db_query("select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id, p.products_gtin from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$_GET['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'"); $product_info = tep_db_fetch_array($product_info_query); tep_db_query("update " . TABLE_PRODUCTS_DESCRIPTION . " set products_viewed = products_viewed+1 where products_id = '" . (int)$_GET['products_id'] . "' and language_id = '" . (int)$languages_id . "'"); ?> <?php echo tep_draw_form('cart_quantity', tep_href_link('product_info.php', tep_get_all_get_params(array('action')). 'action=add_product', 'NONSSL'), 'post', 'class="form-horizontal" role="form"'); ?> <?php if ($messageStack->size('product_action') > 0) { echo $messageStack->output('product_action'); } ?> <div class="contentContainer"> <div class="row is-product"> <?php echo $oscTemplate->getContent('product_info'); ?> </div> </div> </form> <?php } require('includes/template_bottom.php'); require('includes/application_bottom.php'); ?> I dont know much about PHP, only memory long time ago at uni for basic c++, so excuse me if i ask silly questions thank you!
  25. hi raiwa, Thank you for point out my problem. After reading your post, i went back to recheck my file, I comment out and did not copy the rename part, that is why the problem happened. Thank you!!! anther question, if i like to change the location where the thumbnails save, like from catalog/images/ to catalog/images/thumbnails/ what should I do? Lyn
×
×
  • Create New...