WordPress.org

Ready to get started?Download WordPress

Forums

[Plugin: eShop] PayPal incomplete redirected information. (21 posts)

  1. vasilissk
    Member
    Posted 4 years ago #

    I am testing the plug with real information and I try to check out one item with PayPal.
    But there is a problem. Most billing information does not pass to PayPal screen to pay with credit card information.

    From all cells only the First Name, Last Name and Email are transferred.
    The Billing Address1-2, City, State, Zip Code and Telephone information does not transfer.
    This is inconvenient because it takes time to enter all contact information in the check-out box, and when the same information doesn’t transfer from one side to-the-other it makes people to change their minds and cancel their order.

    http://wordpress.org/extend/plugins/eshop/

  2. elfin
    Moderator
    Posted 4 years ago #

    I have not yet released a version for WP 2.9 - that may fix some of the issues you are experiencing. Starting on it next week however.

  3. vasilissk
    Member
    Posted 4 years ago #

    I download the new version of eShop and the problem remains the same.

  4. elfin
    Moderator
    Posted 4 years ago #

    the correct info is sent from eShop to paypal - so not much I can do about it.

  5. vasilissk
    Member
    Posted 4 years ago #

    I made to stop the send sequence from eShop to Paypal before the paypal screen appear in order to debug the problem, and with-in a split of a second before the new screen loads, there is a quick error code on the bottom of the screen.
    The error in the screen is:

    WordPress database error Field 'thememo' doesn't have a default value for query INSERT INTO wp_eshop_orders (checkid, first_name, last_name,company,email,phone, address1, address2, city, state, zip, country, reference, ship_name,ship_company,ship_phone, ship_address, ship_city, ship_postcode, ship_state, ship_country, custom_field,transid,edited,comments,paidvia)VALUES( '6e-what-ever-b8', 'Fname', 'Lname', '', 'Email@dot.com', 'Zipcode', 'address', '', 'town', '11', 'Zip', 'US', '', 'name', '', 'phone', 'address', 'city', 'zip', '11', 'US', '20--what-ever-this-number-is--05', 'Processing…', NOW(), '', 'paypal' ); made by require, require_once, include, the_content, apply_filters, call_user_func_array, do_shortcode, preg_replace_callback, do_shortcode_tag, call_user_func, eshop_show_checkout, eshop_checkout, include, orderhandle WordPress database error Field 'optsets' doesn't have a default value for query INSERT INTO wp_eshop_order_items (checkid, item_id,item_qty,item_amt)values( '33-what-ever-5e', 'postage', '1', '7.99'); made by require, require_once, include, the_content, apply_filters, call_user_func_array, do_shortcode, preg_replace_callback, do_shortcode_tag, call_user_func, eshop_show_checkout, eshop_checkout, include, orderhandle

    I checked all fields one by one to have the same information but all the time this error shows on the bottom of the screen.
    I also open the database with PHPmyAdmin and I looked in the wp_eshop_orders and under Default all fields are blank.
    *PS.
    For quality purposes all personal information have been modified.

  6. elfin
    Moderator
    Posted 4 years ago #

    what db type is your wp_eshop_orders table? If it isn't myisam - change it to that and see if that helps.

  7. vasilissk
    Member
    Posted 4 years ago #

    I changed the DB from InnoDB to MyISAM but the result is the same.
    Everything else in the Data Base works and have Data in, besides this one.

  8. elfin
    Moderator
    Posted 4 years ago #

    please confirm you actually made another test order after you changed the db type, it isn't clear from your last comment.

    Please also confirm which version of the plugin you are using.

  9. vasilissk
    Member
    Posted 4 years ago #

    I did some tests again with MyISAM DB and I still have the same errors on the screen. I am using eShop 4.2.3. For some reason that I cannot explain the information do not enter in the database.

  10. elfin
    Moderator
    Posted 4 years ago #

    ok try this.

    Open cart-functions.php and change this line(521):
    custom_field,transid,edited,comments,paidvia)VALUES(
    to
    custom_field,transid,edited,comments,paidvia,thememo)VALUES(

    and change this line(547):
    '$paidvia'
    to
    '$paidvia',''

    If that fixes it I'll add it into the plugin for future updates.

  11. vasilissk
    Member
    Posted 4 years ago #

    I did the update in the lines you mention above and there is a little progress.
    I have a new error on the bottom of the screen from before.
    You pass the 'thethemo' now is the 'admin_note'.

    WordPress database error Field 'admin_note' doesn't have a default value for query INSERT INTO wp_eshop_orders (checkid...

  12. elfin
    Moderator
    Posted 4 years ago #

    do the same again and retest:
    Open cart-functions.php and change this line(521):
    custom_field,transid,edited,comments,paidvia)VALUES(
    to
    custom_field,transid,edited,comments,paidvia,thememo,admin_note)VALUES(

    and change this line(547):
    '$paidvia'
    to
    '$paidvia','',''
    let me know how that does.

  13. vasilissk
    Member
    Posted 4 years ago #

    So far all the changes seems to work and the error got smaller in size.
    I also opened the database and I see now the first entry in wp_eshop_order.
    The paypal window opens and it pops up the checkout window expanded.

    The next error is:

    WordPress database error Field 'optsets' doesn't have a default value for query INSERT INTO wp_eshop_order_items (checkid, item_id,item_qty,item_amt)values( '560-Big-Number-3b', 'postage', '1', '0'); made by require, require_once, include, the_content, apply_filters, call_user_func_array, do_shortcode, preg_replace_callback, do_shortcode_tag, call_user_func, eshop_show_checkout, eshop_checkout, include, orderhandle

    Ps.
    I think you are very close to solve this problem.

  14. elfin
    Moderator
    Posted 4 years ago #

    yeah apologies, but as I can't replicate I have to ask you to test at each step.

    so change lines 624-629 from this:

    $querypostage=$wpdb->query("INSERT INTO  $itemstable
    (checkid, item_id,item_qty,item_amt)
    values
    ('$checkid','postage','1','$postage');");

    to this

    $querypostage=$wpdb->query("INSERT INTO  $itemstable
    (checkid, item_id,item_qty,item_amt,optsets)
    values
    ('$checkid','postage','1','$postage','');");

    In theory these errors shouldn't be needed - so it is actually a database issue - I'm just not sure why you are getting them.

  15. vasilissk
    Member
    Posted 4 years ago #

    There is no more errors in this option. I guess Bug fixed.
    It looks like because there wasn't some virables in the code the computer couldn't find the path to store the information to database.

    I don't see any visible error on the screen.

  16. elfin
    Moderator
    Posted 4 years ago #

    well I might add them in, or make some changes to at least stop it appearing - keep an eye out for the next version and re-test, just in case I missed any of them.

  17. vasilissk
    Member
    Posted 4 years ago #

    I am trying to find the reason why the address, phone number etc. do not pass from eShop to paypal checkout.
    I also saw in the paypal.php this:
    //$p->add_field('address_override','1');//causes errors :(

    This command works only when the seller wants to sell items in the current Country. If you change it to 'address_override','0' then the seller can selll items all over the world.

    I am trying to find the virable which passes the first-name and the last-name to paypal checkout. If I find the "token" I might be able to debug.

  18. elfin
    Moderator
    Posted 4 years ago #

    so have you tested with uncommenting that line and changing it to a 0 ?

    the names are passed from the checkout form itself.

  19. vasilissk
    Member
    Posted 4 years ago #


  20. vasilissk
    Member
    Posted 4 years ago #

    Yes it works when the line is set to "0".

    About some problems rederecting information to Paypal.
    I used today the sandbox (Testing) instead the Live mode and it poped up this error:

    Bad Request

    Your browser sent a request that this server could not understand.
    Size of a request header field exceeds server limit.

    Cookie: cwrClyrK4LoCV1fydGbAxiNL6iG=FbCmndluqTmEs79GLc0qdCwyUskiS0xEIJBxIiD0JF-J0esoL7vAq357DwfsBen800a5o2vuM-xj9s9FkkBmNgNbNUQLoNQ8RkyQBxX0liDhutv360Q4OydZHSXIhRqkFsAM50%

    This cookie is so long that it needs a larger page.

    CMTZ3rsNKeFnefDQh4wRDbMeMeJjEl8RGHS7jyrpLfTThGmkH9MeFE7D2DJ5LZXjxGsK4cRmFkhkAdkxeXDOT7a_kwTS8E4upemgAUL0_GRhPpfZZgC-eLOtTWMO

  21. elfin
    Moderator
    Posted 4 years ago #

    thanks re the address.

    The 2nd is not an eShop issue.

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags