1.5.7 Problems

[websmith]

I just got to checking on the PayPal and reloaded the modules. Now every time they go to PayPal you get:

There’s a problem with your shipping address.
Please return to the merchant and update your information, including your city, state, and ZIP code.
test Local Ship address
123 anywhere undefined
Penascola FL 32506

I believe this has been noted before but I am not going to chase it tonight, it has been a long day.

Just wanted to let you know what happened when I tried it.

Stan

[mc12345678]

You're going to need to stretch your products_name column to fit your supersized data! :)

First MAKE A BACKUP of your database. Then:

In Admin > Tools > Install SQL Patches do

ALTER TABLE products_description MODIFY COLUMN products_name varchar(128) NOT NULL default '';

When you had that issue, you were doing a copy product, which appends the string "[DUPLICATE]" on to the product name. So even if you kept to your own limit, you could still blow the old 64 character size because of that appended value.

Also need to update the products_name field in the orders_products table so that its size lines up with the products_name field of the products_description table. Otherwise during the purchase process, there will be a similar error generated and purchasing will stop.

[swguy]

Ah good point. Yes, these two should match just to make things more self-documenting, even if you plan to trim the title back before the product can be purchased.

[websmith]

I have been working with the problem I had with PayPal all day which is why I did not respond sooner, I had to rebuild the sites since I had not backup the database (I forgot there was an update to the database so I could not fall back on the original backup it was built from).

I had a split login page that was not accepting the login from existing users. Once I tracked it to the page causing the problem turning it off and back on cleared the problem.

I have retested the PayPal remove and reinstall and it seems to work now not sure why it caused a problem the first time, I had no logged errors to track. Hoping it will go as well on the live sites. I have a test order out I am waiting for the owner to refund the payment to see if it refunds without the error.

I found the products_name field in the orders_products table and changed it to 128 also. I had originally thought the field on the form would stay at 64 even when the database was now 128 but I see that is not the case it's size has also changed so it will allow a longer field, would have been nice if it had stayed at 64 it would have made things easier. I will just have to figure out a way to limit the title when parts are created so they do not cause a problem we have to do something similar on the long image names so I am sure I can figure something.

[websmith]

The refund for the PayPal came through it is still throwing the error after reloading the module.

[06-Jul-2020 08:48:08 America/Chicago] Request URI: /ipn_main_handler.php, IP address: 173.0.81.1
--> PHP Warning: Use of undefined constant MODULE_PAYMENT_PAYPALWPP_REFUNDED_STATUS_ID - assumed 'MODULE_PAYMENT_PAYPALWPP_REFUNDED_STATUS_ID' (this will throw an Error in a future version of PHP) in /var/www/alt.humphreystrailerparts.com/public_html/ipn_main_handler.php on line 437.

Can I just put on the single quotes on line 437 without causing problems?

[swguy]

Note your settings, then remove and reinstall PayPal Express Checkout. That will fix this issue.

[websmith]

I do not use express checkout I use the standard. Sorry I should have passed that on with the original information. PayPal Express and PayPal Pro are not installed.

[websmith]

I should have included this on the last response, I have twice in fact removed and reinstalled the PayPal standard.

[DrByte]

The refund for the PayPal came through it is still throwing the error after reloading the module.

[06-Jul-2020 08:48:08 America/Chicago] Request URI: /ipn_main_handler.php, IP address: 173.0.81.1
--> PHP Warning: Use of undefined constant MODULE_PAYMENT_PAYPALWPP_REFUNDED_STATUS_ID - assumed 'MODULE_PAYMENT_PAYPALWPP_REFUNDED_STATUS_ID' (this will throw an Error in a future version of PHP) in /var/www/alt.humphreystrailerparts.com/public_html/ipn_main_handler.php on line 437.

I do not use express checkout I use the standard.

Sorry, we don't do very aggressive testing with the old "PayPal Standard" module anymore.

You can get rid of that warning by making this change:
https://github.com/zencart/zencart/c...5a76af886eb2e6

[websmith]

Thank you I have the information and will make the change on all sites.

Stan