Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

petsk

Members
  • Content count

    103
  • Joined

  • Last visited

Everything posted by petsk

  1. Can you also have a look why the contribution breaks if you set SESSION_FORCE_COOKIE_USE to True. It looks like the contribution can't find the session and is redirecting to admin/index.php. 'Force cookie usage' in the admin directory was introduced with oscommerce-2.3.4. oscommerce-2.3.3.2 line 76 in catalog/admin/functions/sessions.php: if (isset($HTTP_GET_VARS[tep_session_name()])) { if (preg_match('/^[a-zA-Z0-9,-]+$/', $HTTP_GET_VARS[tep_session_name()]) == false) { oscommerce-2.3.4 changed to: if ( isset($HTTP_GET_VARS[tep_session_name()]) ) { if ( (SESSION_FORCE_COOKIE_USE == 'True') || (preg_match('/^[a-zA-Z0-9,-]+$/', $HTTP_GET_VARS[tep_session_name()]) == false) ) { If you remove (SESSION_FORCE_COOKIE_USE == 'True') || in the line above the contribution load as normal.
  2. This is issue occurs when sorting is activated. Open /catalog/admin/attributeManager/includes/attributeManagerPrompts.inc.php Change this, around line 40: $optionSortDrop = array('1', '2', '3', '4', '5', '6', '7', '8', '9'); $return .= ' <tr>'; if(AM_USE_SORT_ORDER) { To this: $optionSortDrop = array(); for ($i=1; $i<=10; $i++) { $optionSortDrop[] = array('id' => $i, 'text' => $i); } $return .= ' <tr>'; if(AM_USE_SORT_ORDER) {
  3. Hi everyone, I'm using featured products contribution, http://www.oscommerce.com/community/contributions,651 Is there a way to show the product_model in front of the product name in the pull down list? I can't figure it out, I've tried to add the product_model in various places but nothing shows up. The code for pull down menu: <td class="main"><?php echo ($sInfo->products_name) ? $sInfo->products_name : tep_draw_products_pull_down('products_id', 'style="font-size:10px"', $featured_array); echo tep_draw_hidden_field('products_price', $sInfo->products_price); ?></td> Any ideas? :blink: :D
  4. Does anyone know how to get images from a external domain working, eg: www.your-store.com/product_thumb.php?img=http://www.external-domain.com/some_image.jpg I can't find the problem in product_thumb.php. There's nothing wrong with the tep_image(); function anyway. Any ideas? :thumbsup:
  5. Have anyone managed to get the Page Cache contribution working with STS? It's truly a wonderful contribution that significantly increases the page loading time but I can't get the shopping cart items updated dynamically, it cache's the whole page. Any help is highly appreciated :thumbsup:
  6. petsk

    Newsletter products, HTML email

    A missing () caused the problem: $images_query = tep_db_query("select p.products_id, pd.language_id, pd.products_name, p.products_image, p.products_price, p.products_tax_class_id, if(s.status, s.specials_new_products_price, NULL) as specials_price from (" . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd) left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where pd.language_id = '1' and pd.products_id = p.products_id and p.products_id in(" . $this->products . ")");
  7. petsk

    Newsletter products, HTML email

    I belive it's the "left join " . TABLE_SPECIALS . "" that needs to be changed in $images_query... My code: $images_query = tep_db_query("select p.products_id, pd.language_id, pd.products_name, p.products_image, p.products_price, p.products_tax_class_id, if(s.status, s.specials_new_products_price, NULL) as specials_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where pd.language_id = '1' and pd.products_id = p.products_id and p.products_id in(" . $this->products . ")");
  8. petsk

    Newsletter products, HTML email

    I get the following sql error. Does anyone have a solution? :) The problem occurs using MySQL 5, version 4 doesn't give any errors. 1054 - Unknown column 'p.products_id' in 'on clause' select p.products_id, pd.products_name, p.products_image, p.products_price, p.products_tax_class_id, if(s.status, s.specials_new_products_price, NULL) as specials_price from products p, products_description pd left join specials s on p.products_id = s.products_id where pd.products_id = p.products_id and p.products_id in(738,990,938,855,175,353,1059,1043,874,895,884,749,350) and pd.language_id=1 [TEP STOP]
  9. I'm reciving this SQL-error when I'm trying to reach admin/coupons.php: 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 '-50, 50' at line 1 select * from discount_coupons cd order by cd.coupons_date_end, coupons_date_start limit -50, 50 [TEP STOP] And this SQL-error when I'm trying to reach admin/stats_discount_coupons.php: 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 '-50, 50' at line 1 select dc.coupons_id, dc.coupons_discount_percent, dc.coupons_number_available, COUNT(dcto.discount_coupons_to_orders_id) AS coupons_use_count from discount_coupons AS dc left join discount_coupons_to_orders AS dcto ON dc.coupons_id = dcto.coupons_id group by dc.coupons_id order by coupons_use_count desc, dc.coupons_id asc limit -50, 50 [TEP STOP] Any suggestions? <_<
  10. Sure, here comes... Open: admin/includes/functions/general.php Find this at line ~199 $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>'; } } Change to: $products_query = tep_db_query("select p.products_id, p.products_model, 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_model'] . ']?' . $products['products_name'] . '?(' . $currencies->format($products['products_price']) . ')</option>'; } } You can actually put almost any product information in the pulldown menu, eg stock quantity etc. // Peter EDIT: Note that this "hack" is going to show up in every pull down menu in admin
  11. petsk

    AJAX Quick Search

    I have the same problem :( Any help whit this would be appreciated :)
  12. My product counts wrap too :/ How do I make it stop wrapping, is there a solution? I'm using the latest version 2.1
  13. Chris, The code that generates the coupon code is added in general.php, the only thing missing in the instructions was defining the "SECURITY_CODE_LENGTH", therefor I did add it. But now I have a new problem, when enabling the "Downloadable Products" it jumps straight to checkout_payment.php instead of checkout_shipping.php. The problem is probably in includes/classes/shopping_cart.php, but does anyone know what to change in that file? Can I overwrite it whit the original osC file, or does it contain relevant code making the CCGV contribution stop working properly? :blush: /Peter
  14. Thanks! I have found out what it was now, It was a coding issue! If somebody else have the same problem, this is the fix.. In file: /includes/functions/general.php Add: define('SECURITY_CODE_LENGTH', '10'); /Peter
  15. Lovely contribution :D But I have two strange problems.. 1. When sending a Gift Voucher to a friend using the page gv_send.php in storefront the gv-link in the recived mail is outputted like this: http://localhost/store/gv_redeem.php?gv_no= In other words, no ID/number is added at the end of the trail. :blink: If I send a Gift Voucher trough admin the url is generated properly, eg: http://localhost/store/gv_redeem.php?gv_no=6eb0e4 2. If I try to send the same Gift Voucher once again, or trying to send a new Gift Voucher to a friend using the page gv_send.php in storefront the server stops responding :blink: :blink: When I drop/recreate the Gift Voucher database tables the server start responding again. <_< I'm using Gift Voucher version 5.14 on MS2.2. I've also reinstalled Gift Voucher contribution several times. I've also tested this on a clean shop, I did overwrite the stores files whit the changed files whitin this contribution, and it's still not working when trying to send Gift Voucher to friends. Very strange to me :( I have searched trough the web and this support tread and did find one other storeowner that had the exact same problem, but no one had replayed to the user. Please somebody, give me hint about what could be wrong :'(
  16. Hi :D I can't get these two contributions working together: Actualy Price in Pull down option menus QTpro v1.0 - Quantity Tracking Professional The actual attributes prices (instead of eg. +50 €) won't show up in product_info.php when I'm using QTPro. In includes/classes/pad_base.php if ($products_options['options_values_price'] != '0') { $products_options_array[sizeof($products_options_array)-1]['text'] .= ' (' . $products_options['price_prefix'] . $currencies->display_price($products_options['options_values_price'], tep_get_tax_rate($this->products_tax_class_id)) .')'; } Changed to: $original_price = $product_info['products_price']; $option_price = $products_options['options_values_price']; if ($products_options['price_prefix'] == "-") // in case price lowers, don't add values, subtract. { $show_price = 0.0 + $original_price - $option_price; // force float (in case) using the 0.0; } else { $show_price = 0.0 + $original_price + $option_price; // force float (in case) using the 0.0; } if ($products_options['options_values_price'] != '') { $products_options_array[sizeof($products_options_array)-1]['text'] .= ' (' . $currencies->display_price($products_options['options_values_price'], tep_get_tax_rate($this->products_tax_class_id)) .')'; } Does anyone have a clues why it's not working? :blink: Best wishes, Peter
  17. Hi, I use the QTPro contribution, is it possible to use Actual Attribute Price whit this contribution? :) Best wishes, Peter
  18. Hi, Thanks for the contribution! Do anyone have a clue about what's causing this strange problem: The sitemapindex.xml don't contain the links to sitemapcategories.xml and sitemapproducts.xml. No problems whit sitemapcategories.xml and sitemapproducts.xml, they contain links to products. If I run this contribution on localhost I DO get links to both sitemapcategories.xml and sitemapproducts.xml in sitemapindex.xml :blink: EDIT: It's runnin ok at localhost (windows xp) but at the hosting company (linux) the problem occur.
  19. Thank you very much for this contribution, it's fantastic! I'm also using the Credit Class & Gift Voucher contribution and when I did install Ultimate SEO URLs the Gift Voucher stoped working the way it should. When I enter the redeem code in the checkout process (checkout_payment.php) a message/notice have been displayed before, informing the customer if the redeem code is OK or not. The message won't show up anymore, just a read border around the message table, no text/information is being displayed in the table. :'( I did try to take a look in the code and found out that if I replace the Ultimate SEO URLs class whit the original class in includes/functions/html_output.php the redeem message shows up again. Any of you guys using both these contributions? Is there a fix or solution for this problem? Best regards, Peter
  20. Thank you very much Steve! The general-file really did the trick :D
  21. petsk

    Newsletter & Subscribtion for MS2

    I do get a error when I try sending my newsletter from admin, ~2000 subscribers. 2013 - Lost connection to MySQL server during query update newsletters set date_sent = now(), status = '1' ehere newsletters_id= '1' [TEP STOP] Altough, the newsletter seems to be sent to everyone. Any ideas? :(
  22. petsk

    PDF Catalogs v.159

    This contribution is generating a big amount of all kinds of errors :( My product images do not show up at all, for example. enurweb, edit DIR_S_CATALOG ti DIR_FS_CATALOG in admin/pdf_fpdf.php on line 1495.
  23. petsk

    Newsletter & Subscribtion for MS2

    Okay, I'll do that! Thanks hotnuts21
  24. petsk

    Newsletter & Subscribtion for MS2

    I get the following error after 1 hour trying to send the newsletters: 2013 mysql lost connection to mysql server during query update newsletters set date_sent = now(), status='1' where newsletters_id='1' Using Sendmail on a FreeBSD system. The subscribers are ~1100. Is something serious wrong?
×