Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: Bug fixed -- checkout.php (paypal)

  1. #1
    mark
    Guest

    Post Bug fixed -- checkout.php (paypal)

    IN file checkout/paypal.php

    lookfor this line :

    PHP Code:
        // member form prepopulation
        
    if ( $enable_prepopulation 
    change it to :
    PHP Code:
        // member form prepopulation
        
    if ( $enable_prepopulation and == 
    you can do a test in clean601 site for this, it works fine there :

    http://clean601.devmysite.com

  2. #2

    Join Date
    Sep 2006
    Posts
    191

    Talking

    Thank you, this works great! Yea I dont think I would have every figured that out.

    You are the best.
    ------------------------------------
    Have a MMORPG character you are proud
    of - Toon in your Character at
    http://www.charnation.com

  3. #3

    Join Date
    Aug 2006
    Posts
    127

    Default

    Such an important part of the process to strike while the iron is hot and such a turnoff if it doesn't work for prospective members.

    Thanks Mark for finding this.

  4. #4
    Baalfyre's Avatar
    Join Date
    Sep 2006
    Posts
    50

    Default

    I did the fix and still getting an error. It looks like it just doesn't communicate with the database when the 'Check Out' button is pushed and the next thing I know I get a page that shows 'Database query error'

    Also, IE shows an error in the bottom left corner when I click on the recurring payment checkbox.
    I can't seem to control the world yet...so weird!

    Dolphin 6.0.2

  5. #5
    mark
    Guest

    Post Please be more specific if you think its bug

    Quote Originally Posted by Baalfyre View Post
    page that shows 'Database query error'
    .
    Please be more specific, you can turn on the debugging mode in the admin panel so that it will show the detailed database query error.
    Last edited by mark; 10-03-2007 at 11:53 PM.

  6. #6
    Baalfyre's Avatar
    Join Date
    Sep 2006
    Posts
    50

    Default

    The DB query error shows the same as the previous post. I turned off payment prepopulation in the admin panel for paypal and I was able to get through to the payment area of paypal. I made the change to the script you had suggested but that had no effect. The only thing that has worked so far was taking away form prepopulation. Any suggestions?
    I can't seem to control the world yet...so weird!

    Dolphin 6.0.2

  7. #7
    mark
    Guest

    Post paypal checkout db error

    Quote Originally Posted by Baalfyre View Post
    The DB query error shows the same as the previous post.
    Im not sure if its the same, since I did'nt see exactly what you see, care to post it here?

    ..

  8. #8
    mark
    Guest

    Post paypal checkout db error

    Quote Originally Posted by Baalfyre View Post
    I turned off payment prepopulation in the admin panel for paypal and I was able to get through to the payment area of paypal. I made the change to the script you had suggested but that had no effect. The only thing that has worked so far was taking away form prepopulation. Any suggestions?
    Your probably editing the wrong script, Im sure with that and also I think you're just trying to say here is... your fixed is better, why not just say "here is the alternative fixed for this bug", you made the short story long!!!!

  9. #9
    Baalfyre's Avatar
    Join Date
    Sep 2006
    Posts
    50

    Default

    If I could fix the script I wouldn't be looking for help. The fact is, when I un-checked form prepopulation the error went away. When I check it...which would be preferable, this is the error I get...

    Database error in Your Virtual Vancouver
    Query:
    SELECT `RealName`, `HomeAddress`, `City`, `Country`, `zip` FROM `Profiles` WHERE `ID` = 1

    Mysql error:
    Unknown column 'RealName' in 'field list'

    Found error in file /home/XXXXXX/public_html/yourvancity/checkout/paypal.php
    at line 506. Called db_arr function
    with erroneous argument #0

    Debug backtrace:
    Array
    (
    [1] => Array
    (
    [file] => /home/XXXXXXX/public_html/yourvancity/inc/db.inc.php
    [line] => 115
    [function] => db_res
    [args] => Array
    (
    [0] => SELECT `RealName`, `HomeAddress`, `City`, `Country`, `zip` FROM `Profiles` WHERE `ID` = 1
    [1] => 1
    )

    )

    [2] => Array
    (
    [file] => /home/XXXXXX/public_html/yourvancity/checkout/paypal.php
    [line] => 506
    [function] => db_arr
    [args] => Array
    (
    [0] => SELECT `RealName`, `HomeAddress`, `City`, `Country`, `zip` FROM `Profiles` WHERE `ID` = 1
    )

    )

    [3] => Array
    (
    [file] => /home/XXXXXX/public_html/yourvancity/checkout.php
    [line] => 319
    [function] => moduleStartTransaction
    [args] => Array
    (
    [0] => 35
    [1] =>
    [2] => 30
    )

    )

    [4] => Array
    (
    [file] => /home/XXXXXX/public_html/yourvancity/checkout.php
    [line] => 88
    [function] => StartCheckout
    [args] => Array
    (
    [0] =>
    )

    )

    )


    Called script: /checkout.php

    Request parameters:
    Array
    (
    [action] => start_checkout
    [checkout_action] => membership
    [amount] => 19.99
    [data] => 5
    [allow_subscribe] => on
    [subscribe_days] => 30
    [prov_id] => 1
    [memberID] => 1
    [memberPassword] => 5x64xx411459f75xx3301573530xxx37
    [adminID] => xxxxxx
    [adminPassword] => 5x64xx411459f75xx3301573530xxx37
    )


    --
    Auto-report system

    So, if I simply said...it doesn't work, then I would have had to explain why. Either way I would have to explain why it does, or doesn't work. I can find my way to the script you had said to change also, so I did make the dit on the correct part of the script. When I say 'any suggestions?' it really does mean I need suggestions because I don't have the chops to fix the problem.

    So...is this a form issue? Doesn't the form on the script just not match the form for paypal or something? What did you see when you signed up for the site?
    I can't seem to control the world yet...so weird!

    Dolphin 6.0.2

  10. #10
    mark
    Guest

    Post To make it short here is the fixed, by smoge

    To make it short here is the exact fixed, by smoge

    PayPal DB Error Fix


    ....

Page 1 of 2 12 LastLast

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Paypal checkout database query error dolphin 6.0.2
    By Baalfyre in forum Payment Processing
    Replies: 4
    Last Post: 10-03-2007, 03:32 PM
  2. Error in Checkout.php
    By ArnMan in forum Dolphin General Discussion v6.00 and above
    Replies: 3
    Last Post: 10-02-2007, 05:29 PM
  3. PayPal Checkout Page - Credit Card Use Option
    By Smoge in forum Payment Processing
    Replies: 3
    Last Post: 11-03-2006, 09:18 AM
  4. Database access error - Paypal post checkout payment
    By planetgay in forum General Troubleshooting
    Replies: 34
    Last Post: 05-04-2006, 01:12 AM
  5. v4.01 PayPal Checkout With Membership Levels
    By Smoge in forum Bugs and Fixes
    Replies: 1
    Last Post: 07-24-2005, 08:36 PM

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
  •