Jump to content
Latest News: (loading..)

TheKnight

Members
  • Content count

    8
  • Joined

  • Last visited

Profile Information

  • Real Name
    The Knight with the entomophagous wivern
  1. TheKnight

    Paypal overrides shipping method ?

    We had this problem too. We use Paypal Express 3.1 and osc 2.3.3.4. At the beginning Paypal worked well, shipping have been calculated correctly. From one day to the other, shipping method was always set to free pick up in store. In the checkout_confirmation and at the paypal side, the correct shipping method and the correct shipping cost were displayed. However, the wrong shipping method and the false shipping cost were sent to the customer and were stored into our db. With the reference of the thread http://forums.oscommerce.com/topic/398267-paypal-express-31-update-not-pushing-shipping-method-selected/ to the instant notification function and the descriptions in the manual of the contribution I have found the cause of the error. Many thanks to Kevin for his hint. The cause is the missing 'Payment Zone' for Paypal. Goto 'Locations / Taxes' -> 'Tax Zones' in the admin menu. Then create a tax zone for the countries from which you want to accept the paypal payments, for example 'worldwide'. I used the contribution "Rest of the World tax zone". (Contrib "Rest of the World tax zone" from 21.Jul 2014 contains an error and does not work. Change line45 to: <?php echo tep_draw_form('doprocess', 'setup_international_zone.php', 'action=' . $_SERVER['PHP_SELF'], 'post'); ?> and it works fine). You can also manually create the new tax zone or perhaps there is already an appropriate zone. If the new zone has been created, then go to 'Modul' -> 'Payment' -> 'PayPal Express Checkout'. Scroll down to 'Payment Zone' and select 'worldwide' (or the name you've chossed) from the pull-down menu. The default '--none--' does not work and causes the described incorrect behaviour. Click Save and afterwards enjoy the working 'PayPal Express Checkout'.
  2. TheKnight

    PayPal Express 3.1 Update Not Pushing Shipping Method Selected

    We had this problem too. We use Paypal Express 3.1 and osc 2.3.3.4. The shop runs with SSL. At the beginning Paypal worked well, shipping and taxes have been calculated correctly. From one day to the other, shipping method was always set to free pick up in store. In the checkout_confirmation and at the paypal side, the correct shipping method and the correct shipping cost were displayed. However, the wrong shipping method and the false shipping cost were sent to the customer and were stored into our db. With the reference of Kevin to the instant notification function and the descriptions in the manual of the contribution I have found the cause of the error. The cause is the missing 'Payment Zone' for Paypal. Goto 'Locations / Taxes' -> 'Tax Zones' in the admin menu. Then create a tax zone for the countries from which you want to accept the paypal payments, for example 'worldwide'. I used the contribution "Rest of the World tax zone". (Contrib "Rest of the World tax zone" from 21.Jul 2014 contains an error and does not work. Change line45 to: <?php echo tep_draw_form('doprocess', 'setup_international_zone.php', 'action=' . $_SERVER['PHP_SELF'], 'post'); ?> and it works fine). You can also manually create the new tax zone or perhaps there is already an appropriate zone. If the new zone has been created, then go to 'Modul' -> 'Payment' -> 'PayPal Express Checkout'. Scroll down to 'Payment Zone' and select 'worldwide' (or the name you've chossed) from the pull-down menu. Click Save and afterwards enjoy the working 'PayPal Express Checkout'. :rolleyes:
  3. Today I've released version 1.1.0 of my contribution "httpbl4osc"

    Project Honeypot - HTTP Blacklist

    which is now compatible with osCommerce v2.2 and v2.3

  4. Hi,

    my contribution "httpbl4osc" is not tested with OSC v2.3.

    I'm still running MS2.2rc2a.

    I'll install V2.3 and "httpbl4osc" onto my test-server and check the compatibility.

  5. Hello, Will your contribution "httpbl4osc" work for OSC v2.3?

  6. Hi tedbooks, the first call of login page sets the 'fail' column to 1. So your notice is correct: 'fail' column starts at 2 for the first failed login. The 'process' column in the db must be set to NULL, not empty. - The database column 'process' is defined 'process varchar(6) DEFAULT NULL'. - The login.php script updates the column with NULL: tep_db_query("update `anti_hacker_login` set `process` = NULL WHERE ahl_id='" .$included_code['ahl_id'] . "'"); - Afterwards the login.php script tests the column to NULL: $ahl_process = (is_null($ahl_array['process']) ? false : true); Please check the database 'process' column if it contains a NULL. kind regards TheKnight
  7. Hi guavatone, it's my mistake. I know this error message. Please open file /catalog/login.php an go to line 52. The command: echo "debug endtime:".$endtime.", starttime:".$starttime.", timediff:".$timediff.", fail:".$included_code['fail']."<br>"; is for debug output only. This line outputs the message: 'debug endtime:1287694103, starttime:1287694090, timediff:0, fail:1' Delete line 52 (echo "debug .... <br>"; ) and the login script will work. Today I've released a updated login.php (version 1.0.2). kind regards TheKnight
  8. You are welcome. It's my contribution and I would like to develop good quality. A good product that can be used by anyone. In the next days I will read the MySQL manual concerning the TIMESTAMP data type. Please give me a feedback, whether the problem is really solved. Thanks in advance.
  9. Hi kbking, thanks a lot for your detailed post. It's very helpful. The problem is the negativ value of 'timediff'. Your 'starttime' is greater than the 'endtime'. When fetching the row from the database, the value of 'dt' is updated and the current time is stored in 'starttime', I suppose. This behaviour is different from my test system as well as from my hosted web- and database servers. Unfortunately I am not a mysql specialist. But take a look onto 'dt' attribute 'on update CURRENT_TIMESTAMP'. Please delete this attribute. My login.php script updates the timestamp when necessary, using the function 'now()'. The timestamp 'dt' may not be updated when reading the database. I'm looking forward to your hopefully positive answer concerning this problem. TheKnight
  10. Hello kbking, your table seems to be ok. After entering the third wrong password the value 'fail' should be '4' and 'process' should be '1' (or true). I've done some tests, but I cannot reproduce your problem. Following a more detailed description to clarify how it works: The 'New Customer' and 'Returning Customer' dialogue is disabled when fail>3 AND process==true AND the login button was pressed. Please note, the 'New Customer' and 'Returning Customer' dialogue is always disabled when this condition is met. If in this state, the browsers 'reload' button is pressed, the wrong password is send again to the server. The result is that the 'New Customer' and 'Returning Customer' dialogue disabled again, 'fail' is increased and the dialogue-disable-time is increased by one minute. The dialogue will reappear when you wait one minute and then click on the 'My Account' (mitt konto) link or type in the browser address field: https://<your domain>/catalog/account.php?osCsid=<your session ID> For debugging please search the following line in login.php (line no. 50): $timediff = intval(($endtime-$starttime)/60); // $timediff in minutes Please insert following line afterwards: echo "endtime:".$endtime.", starttime:".$starttime.", timediff:".$timediff.", fail:".$included_code['fail']."<br>"; Please report the output and please describe more detailed how the problem appears (what link you used? how long you wait? and so on). Thanks for your assistance.
  11. Hello kbking, I need more information of your problem. Do you use 'login.php' or 'login_4_purchase_without_account_2.1.php'? First, please check your database: 1. Is the new table 'anti_hacker_login' added? 2. Check the rows of the table. The field `dt` contains the current TIMESTAMP, `fail` is the counter of the failed logins and 'process' must be empty or 'false'. I suppose the field 'process' contains the value true or 1. 3. Please delete the database rows or change the stored IP values to a value that is not yours. 4. Go to your shop and click the 'My Account' link. Is a new row containing your IP and your osCid added to the table? The field `dt` should contain the current TIMESTAMP, `fail` should be 1 and 'process' must be empty or 'false'. Please report the values of the latest row. Afterwards I will try to reproduce the problem.
×