Results 1 to 5 of 5

Thread: Orders: Province in Albania posted for invoice instead of correct Canada/US province/state

  1. #1
    Active Member
    Orders: Province in Albania posted for invoice instead of correct Canada/US province/state


    Join Date
    Sep 2009
    Location
    Vancouver, BC, Canada
    Posts
    472
    Total Contributions For

    JRR     $ 180.00
    Rep Power
    66


    Default Orders: Province in Albania posted for invoice instead of correct Canada/US province/state

    I'm getting some odd orders lately - the customers address is correct when I go to the actual Customers listing, however the invoice chooses a province in Albania instead of Canada or the USA. This only happens about once every couple of weeks...today the invoice was saying Tropoje, Canada instead of Alberta, Canada. Customer didn't catch it, not sure if he even noticed.
    Suggestions?
    Thanks!

  2. #2
    osCMax Development Team

    Orders: Province in Albania posted for invoice instead of correct Canada/US province/state

    ridexbuilder's Avatar
    Join Date
    Jul 2008
    Location
    Haggisland
    Posts
    4,124
    Total Contributions For

    ridexbuilder     $ 15.00
    Rep Power
    96


    Default Re: Orders: Province in Albania posted for invoice instead of correct Canada/US province/state

    A pre-existing customer, prior to an osCmax upgrade?
    This can happen due to the addition of many more countries/counties compared to older osCmax versions. New customers will get the correct county/state/zone but not existing customers. (This is an ongoing issue that I'm trying to get my puny brain around.)

    This doesn't sound exactly like your scenario but does indicate a problem between the country and zones relationship/database tables.

    Developers resource at bitbucket
    *** *** ***
    oscmax.co.uk / ejsolutions.co.uk
    Hosting plans with installation, configuration, contributions, support and maintenance.
    *** FREE osCmax hosting available ***
    oscmaxtemplates.com

  3. #3
    Active Member
    Orders: Province in Albania posted for invoice instead of correct Canada/US province/state


    Join Date
    Sep 2009
    Location
    Vancouver, BC, Canada
    Posts
    472
    Total Contributions For

    JRR     $ 180.00
    Rep Power
    66


    Default Re: Orders: Province in Albania posted for invoice instead of correct Canada/US province/state

    Nope not old customer, in both recent cases a new customer.
    I have been running the same version of oscMax (2.5.4) since it came out a couple of years ago. Current PHP is 5.6.23, Apache 2.4.29, MySQL 5.0.11

  4. #4
    osCMax Development Team

    Orders: Province in Albania posted for invoice instead of correct Canada/US province/state

    ridexbuilder's Avatar
    Join Date
    Jul 2008
    Location
    Haggisland
    Posts
    4,124
    Total Contributions For

    ridexbuilder     $ 15.00
    Rep Power
    96


    Lightbulb Re: Orders: Province in Albania posted for invoice instead of correct Canada/US province/state

    Quote Originally Posted by JRR View Post
    Nope not old customer, in both recent cases a new customer.
    A completely different tack then, assuming that you've checked the zones table to make sure ones with the Canada country ID are correct.
    If you run Apache with mod_sec, look for any triggers relevant to osCmax URLs and disable any highlighted rule(s). I've had mod_sec play havoc with stores and it took a while to look there.

    Developers resource at bitbucket
    *** *** ***
    oscmax.co.uk / ejsolutions.co.uk
    Hosting plans with installation, configuration, contributions, support and maintenance.
    *** FREE osCmax hosting available ***
    oscmaxtemplates.com

  5. #5
    Active Member
    Orders: Province in Albania posted for invoice instead of correct Canada/US province/state


    Join Date
    Sep 2009
    Location
    Vancouver, BC, Canada
    Posts
    472
    Total Contributions For

    JRR     $ 180.00
    Rep Power
    66


    Default Re: Orders: Province in Albania posted for invoice instead of correct Canada/US province/state

    I haven't touched the Apache settings, and (in fact) don't know how to implement mod_sec. So can't imagine that is the problem. Went through the Server Information and could not find anything there about Apache settings.

    Further to Albania, I have Albania's Status set to Inactive (along with a few other countries - in Admin|Locations/Countries), so theoretically it should not allow Albania to be selected. Problem hasn't recurred, and may not show up for another month or so.

Similar Threads

  1. Replies: 3
    Last Post: 10-19-2012, 08:34 AM
  2. Province italiane
    By michael_s in forum New osCommerce Contributions
    Replies: 0
    Last Post: 11-23-2010, 11:50 AM
  3. Country Spain, State/Province ALABAMA
    By brettuk1984 in forum osCommerce 2.2 Installation Help
    Replies: 6
    Last Post: 10-13-2010, 12:09 PM
  4. Thailand Zone(Province)
    By michael_s in forum New osCommerce Contributions
    Replies: 0
    Last Post: 05-06-2008, 12:21 AM
  5. Trying to add the MOD “Select State/Province from Dropdown..
    By webwolfe in forum osCMax v1.7 General Mods Discussion
    Replies: 1
    Last Post: 04-08-2006, 12:40 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •