Thread: 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 1 == 2 ) 


you can do a test in clean601 site for this, it works fine there :

http://clean601.devmysite.com

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

You are the best.

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.

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.

Originally Posted by Baalfyre

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.

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?

Originally Posted by Baalfyre

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?

..

Originally Posted by Baalfyre

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!!!!

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?

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

PayPal DB Error Fix


....