Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

mattsc

Members
  • Posts

    53
  • Joined

  • Last visited

Posts posted by mattsc

  1. I'm running into an issue with SPPC and the tep_db_check_age_specials_retail_table function. When a special is created, on the first time the category that product exists in is is visited it generates a 1062 Duplicate Entry SQL error.

     

    1062 - Duplicate entry '1600' for key 'PRIMARY'

    insert into specials_retail_prices select s.products_id, s.specials_new_products_price, s.status, s.customers_group_id from specials s where s.customers_group_id = '0'

     

     

    It's being caused by the "query2" query in the tep_db_check_age_specials_retail_table() function below:

        if (!$table_srp_exists || ($last_update_table_specials > $last_update_table_srp)) {
          if ($table_srp_exists) {
            $query1 = "truncate " . TABLE_SPECIALS_RETAIL_PRICES . "";
            if (tep_db_query($query1)) {
              $query2 = "insert into " . TABLE_SPECIALS_RETAIL_PRICES .
                " select s.products_id, s.specials_new_products_price, s.status, s.customers_group_id from " .
                TABLE_SPECIALS . " s where s.customers_group_id = '0'";
              $result = tep_db_query($query2);
            }

    I thought it might be that the query1 truncate syntax might have needed the "table" added to it for a possible mysql syntax change, but changing it from truncate to truncate table didn't help.

     

    Looking in the database directly, I can see an entry with a products_id of 1600, with a $0 amount in specials_new_products_price, but that's not coming from me when I create the special, and the products I'm creating specials for don't have product_id=1600 either. I've grep'd the code and can't find anything with a 1600 in it, so I've no clue where that value is coming from either.

     
    I'm at a loss here. I can't figure out why it's only occurring on the first visit to the page, why it's happening in the first place, or how to fix it.
  2. Yes I'm sure there's no javascript errors. I pushed my latest dev work up to the staging server... so the bug is live now... but at least you may be able to see it to see if there's just something I did which is stupid. You can check for yourself if you think I may be missing something. The server URL is:

    http://tyga-usa.com/index.php

     

    Is it possible to maybe load the images using a 1x1 pixel height and width, so at least WHILE they are loading it doesn't fill the screen with banner images? That was my best guess at how to possibly resolve it...

  3. I've never seen the banners load slowly enough that you could tell they were there before the rotator started. How big are your images? Try compressing them.

     

    The Javascript is set up to load in the footer to avoid slowing the page load. You could try loading it in the head instead. Find this code in the module file:

          $oscTemplate->addBlock($add_scripts, 'footer_scripts');
    

    and change it to:

          $oscTemplate->addBlock($add_scripts, 'header_tags');
    

    I have no idea why the Easing selector is not working. It's working on my test site. Maybe a different version of PHP?

     

    Regards

    Jim

     

    The banner images are 50-70kb each. Maybe it's that there's 6 of them... but I know the eventual plan is to have as many as 20-25.

     

    PHP version is 5.6.27. I can update the database directly, just seems odd that it's only the pulldown menu that's not updating when the edits are saved to the module config.

     

    Changing from footer_scripts to header_tags caused the slider to break. All banner images loaded and never was loaded into the rotator.

  4. I'm running into an issue with the banner rotator for modular front page v1.0.1 from http://addons.oscommerce.com/info/9436 (tho once installed it's reporting itself as v2.0.1)

     

    Basically it's loading all of the banners on the page, pushing all the content down as it loads one banner after another after another. Once all the banners finish loading it redraws and shows only one and rotates through as expected.

     

    also, when I edit the "Easing" setting from the 30+ odd available methods available, it never takes, and always reverts back to Swing.

     

    I'm running an OSC 2.3.4-GOLD Responsive install.

     

    It's doing this in both Chrome and IE, so I don't think it's a browser specific bug. Not sure why it's doing this or how to resolve it.

  5. I am having the worst time with trying to get this module working. I've tried versions 1.2, 1.3, 1.4, and 1.5. All have one problem or another with either the top fields not holding settings, or when set loading the index.php page instead (looks like that's being caused by the hidden osCAdminID field as when I pull it from the form that stops at least) but... I can't get ANY of these versions to actually update the database!

     

    I've tried fixing v1.5 as it had the least number of problems out of the gate and I figured it was the latest so likely best to try working from given how NONE of them worked...

     

    The SQL isn't the problem, it's the form from what I can tell. The IF blocks for the tests on updated values aren't being entered because of some reason I can't figure out. I've put test trace statements above and below the IF blocks and sure enough... it's passing right over them.

     

    The IF statements for each updated section like:

    if(_POST['product_new_price']){

     

    are failing the test, because it looks like the vars aren't actually being passed back to the browser for the POST form. I've tried messing around with various incantations of the form declaration, to no avail. I've blown 2 days now on trying to figure out this, and am about to abandon the add-on and just write one from scratch at this point. I've got test code I've written that is succeeding with the IF check, when the vars are being passed back into the browser. When I check the form submission with a var_dump I'm getting an EMPTY arrays tho.

     

    I'm running php 5.6.27 with Apache 2.2.15. Not that I think that's the issue at hand as my test code is working fine.

     

    I'm running OSC 2.3.4-GOLD Responsive with the latest SPPC version "BOOTSTRAP - SPPC 2.3.4 BS GOLD - v1.1b" tho I also don't think that's salient as it doesn't appear as if the scheme has changed in a long time.

  6. I'm running the latest code as of 10/29/16 and am trying to install the paypal v3.2 module. I'm running into an issue however, in that it's calling function tep_href_link, and near as I can tell, that function doesn't seem to exist... well... anywhere anymore. I'm seeing references to it in the 2.2rc2a readme changelog, but a grep of the codebase can't find the function. I had to manually insert the osc_configuration parameters, or the paypal module completely failed to be loaded on the Legacy->Modules->Payment screen. Once I copy the 4 PayPal files into the respective target locations, I see the Install Module tab correctly increments by one (from default of 3 to 4) but then I hit the problem with the module at:
    Call to undefined function tep_href_link() with /catalog/includes/modules/payment/paypal_standard.php on line 980

    of:
    $test_url = tep_href_link(FILENAME_MODULES, 'set=payment&module=' . $this->code . '&action=install&subaction=conntest');

    To fetch the code for my install I just did a get clone of the repo. I fetched the codebase for 2.3.4, 2.3.3,4, 2.2rc2a, and 2.2rc2 tags as well... recursive grep of those tags is also failing to find the tep_href_link function, so I'm completely baffled!

    What am I missing here??? Has the function been renamed or deprecated?

×
×
  • Create New...