Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

K3D

Pioneers
  • Posts

    130
  • Joined

  • Last visited

  • Days Won

    1

Posts posted by K3D

  1. I have been testing out Sagepay Server on an existing site and ran into the redirect issue. My problem turned out to be that the site was set to "Force Cookie Use" to true. Disabling Force Cookie use stopped the site redirecting the simulator to the login page.

     

    As I wanted to keep "Force Cookie Use" enabled I added an IP check in application top that lets Sagepay IP's through.

  2. Access to up-to-date UK Postcode data through these companies is always on a charge for basis. Royal Mail collect revenue from these licensed companies, that is why you need an account with craftyclicks.

     

    You as a shop owner pay for a service/feature that you offer to your customers. You wouldn't expect PayPal to process payments for free just because osCommerce is an open source cart.

  3. I have a problem in that if the OTF text field filled out by the customer contains either single or double quotes, the customer will not be able to delete the item from the cart. Not sure why this is happening or if there is a documented fix (I'm guessing the field contents have to be escaped), but my cart's live and pretty busy, so if someone's fixed this already, I'd love to know how. Thanks in advance to anyone who might be able to help me out. I've spent many an hour over the last couple of days deleting items from customers' baskets in phpMyAdmin--be sweet not to have to do that anymore.

     

    I was having a similar situation with my cart and deletion of text fields with backslashes. I have now enabled magic_quotes_gpc via my .htaccess file as my host has it switched off in the php.ini file, all is working so I guess there is an unchecked update to the database that magic quotes is catching.

     

    To do this you can add:

     

    php_value magic_quotes_gpc on

     

    to the bottom of your .htaccess file

  4. I am currently getting quite a few customers each day not selecting the proper card type. Instead they submit the payment details with the first option of American Express, this obviously then results in a failure and put back to the payment page with all the card details to enter again.

     

    I know that the BIN ranges were dropped as they were unreliable, however perhaps if the default option was "Select Card" and then do some error checking to make sure that the person selects a list item might stop some of these errors?

  5. I would just like to say what a trouble free move I have had changing from the form module to this one.

     

    However.. I have noticed an issue that a few customers are having whilst browsing the protx_direct table. We deal with quite a few customers from Dublin and also with BFPO addresses overseas, these people when filling in their Billing details often duplicate their postcode into other areas of the Billing address in order to fill required fields.

     

    This generates the following protx error "INVALID: The BillingPostCode you provided also appears to be included as part of the BillingAddress. You should remove the Post Code from the Address field before submitting the address, or AVS checks will fail"

     

    Now I guess the solution would be to do a couple of IF statements on the billing address in protx_process while building the $billing_add variable. I have not done anything yet however as we are running live at a busy time and I have only just noticed this issue.

  6. Your version will not clean install properly. Firstly there are language files missing, then when I add the language file from v1.06 I get:

     

    Fatal error: Cannot redeclare class cc in /usr/www/........./includes/modules/payment/cc.php on line 13

     

    when attempting to install the module via the admin interface (modules / payment)

     

    It will install however if I remove the decrypt_protx.php file from the modules/payment directory. Not sure if it is trying to read decrypt_protx.php as a payment module in its own right and getting confused.

     

    regards

    kev

  7. It is likely that you have assigned two or more TEXT value attributes when there should only be one.

     

    be sure to check out the database table - product_options_values_id

     

    make sure there is an entry as I have described above where you reference the TEXT as products_options_values_id = 0

     

    otherwise if it is anything other that 0 you have to edit this section of catalog/includes/configure.php (bottom line of this chunk of code)

    // CLR 020605 defines needed for Product Option Type feature.
    define('PRODUCTS_OPTIONS_TYPE_SELECT', 0);
    define('PRODUCTS_OPTIONS_TYPE_TEXT', 1);
    define('PRODUCTS_OPTIONS_TYPE_RADIO', 2);
    define('PRODUCTS_OPTIONS_TYPE_CHECKBOX', 3);
    define('TEXT_PREFIX', 'txt_');
    define('PRODUCTS_OPTIONS_VALUE_TEXT_ID', 0); //Must match id for user defined "TEXT" value in db table TABLE_PRODUCTS_OPTIONS_VALUES

     

    note what I am saying is stated at the bottom part of this code.

  8. I found the posting of the jumbling solution.

     

    Original link to it is HERE

    I would like to thank compugeek2003 for the solution, it has saved me no end. ;)

     

    I did make alterations to the original posted code however as my shopping_cart.php had a slightly different original line to the "change this to this" posting (compare it with link provided).

     

    File to edit is Catalog/Includes/Classes/shopping_cart.php. The line should be around line 56 if you have option type installed, I recommend searching for //attributes to get you to the right place.

     

    change this

    $attributes_query = tep_db_query("select products_options_id, products_options_value_id, products_options_value_text from " . TABLE_CUSTOMERS_BASKET_ATTRIBUTES . " where customers_id = '" . (int)$customer_id . "' and products_id = '" . tep_db_input($products['products_id']) . "'");

     

     

    to this

    $attributes_query = tep_db_query("select customers_basket_attributes_id, products_options_id, products_options_value_id, products_options_value_text from " . TABLE_CUSTOMERS_BASKET_ATTRIBUTES . " where customers_id = '" . (int)$customer_id . "' and products_id = '" . tep_db_input($products['products_id']) . "' order by customers_basket_attributes_id"); //ECS Edited - 04/25/2003

     

    Please make sure your "change this" line is identical to mine if using the above code.

  9. Ok I had a problem with this as well, here is a post I made in the option type contribution support posting.

     

    I figured it out, im gutted to say it was in the read me. so apologies to everyone having to read my posts. However I will spend the time enlightening you. The problem is, is that I had multiple TEXT fields defined in the table PRODUCT_OPTIONS_VALUES. (readme is explicit about only having one TEXT field)

     

    What you need to do is go there via phpmyadmin and convert one of your existing text boxes to read as follows:

     

    Edit | Delete | 0 | 1 | TEXT (0 for product_options_values_id is important)

     

    You then need to go into your attributes for each product (bottom of page) and change the option value to TEXT where applicable.

     

    I think this was everything that I done, it now works flawlessly.

     

    You will also almost definately have a problem with your attributes jumbling up with each other when going through the checkout, I recently found the solution to this on these wonderful forums, however the link is on my works pc and I will have to post it tomorrow.

  10. That's the exact same thing i'm seeing.? No option label.? I posted directly above you.? I installed http://www.oscommerce.com/community/contri...,attribute+sort to get rid of my sorting problems, but I still have the no option name problem.

     

    I figured it out, im gutted to say it was in the read me. so apologies to everyone having to read my posts. However I will spend the time enlightening you. The problem is, is that I had multiple TEXT fields defined in the table PRODUCT_OPTIONS_VALUES. (readme is explicit about only having one TEXT field)

     

    What you need to do is go there via phpmyadmin and convert one of your existing text boxes to read as follows:

     

    Edit | Delete | 0 | 1 | TEXT (0 for product_options_values_id is important)

     

    You then need to go into your attributes for each product (bottom of page) and change the option value to TEXT where applicable.

     

    I think this was everything that I done, it now works flawlessly.

     

    * Solicitation

  11. Mmmm I signed up a test account with your shop (sorry to be a nuisance) I had the same problem with your site as on mine, a quick test on your product resulted in:

     

    Travel Trailer Camping Log & Diary

     

    Selected Options:

    - Custom Line #3: CCCCCCCCCCCCCC

    - Custom Line #2: GGGGGGGGGGGGG

    - Custom Line #1: XXXXXXXXXXXXXXX

     

    But as spaceboy has said, looking back now it happens with standard attributes so I will stop the thread hijack ;)

     

    Where your site differs however is that yours displays [ - Custom Line #1: XXXXXXXX ] where mine misses off the text label and simply displays [ - XXXXXXXX ]. If I can get that fixed, the earlier problem wouldnt matter as I can see which is line 1, line 2 and line 3. (same problem the poster above is having I think)

  12. Hi,

     

    Not sure if anyone has come across this issue before, its proving to be a bit of a problem.

     

    I need to use 3 text boxes for a product. For example the person enters in:

     

    line1 = AAAAAAAAAAA

    line2 = BBBBBBBBBBB

    line3 = CCCCCCCCCC

     

    Everything is fine until the person creates an account, then all of a sudden as they get to the confirmation screen they see that the lines have been jumbled, for example to:

     

    line2=BBBBBBBBBB

    line3=CCCCCCCCC

    line1=AAAAAAAAAA

     

    I am not sure how this happens, the jumbling is always random and not alphabetically related.

     

    Any help would be much appreciated.

×
×
  • Create New...