Product Order Details Missing

[Deno]

Hi all

OK, so a new install of ZenCart and first order has come through successfully and payment taken my paypal BUT when invoicing via ZenCart there is no detail of the product ordered. I'll attach the latest log file and remove the customer details.

Any ideas why this would happen?

Thanks

Dene

[29-Jul-2018 18:10:51 UTC] Request URI: /store/ipn_main_handler.php, IP address: 173.0.81.1
#1  trigger_error() called at [/var/www/vhosts/ee5b4f0.online-server.cloud/httpdocs/gep/store/includes/classes/db/mysql/query_factory.php:171]
#2  queryFactory->show_error() called at [/var/www/vhosts/ee5b4f0.online-server.cloud/httpdocs/gep/store/includes/classes/db/mysql/query_factory.php:143]
#3  queryFactory->set_error() called at [/var/www/vhosts/ee5b4f0.online-server.cloud/httpdocs/gep/store/includes/classes/db/mysql/query_factory.php:270]
#4  queryFactory->Execute() called at [/var/www/vhosts/ee5b4f0.online-server.cloud/httpdocs/gep/store/includes/functions/functions_general.php:978]
#5  zen_db_perform() called at [/var/www/vhosts/ee5b4f0.online-server.cloud/httpdocs/gep/store/ipn_main_handler.php:324]

[29-Jul-2018 18:10:51 UTC] PHP Fatal error:  1366:Incorrect string value: '\xA0' for column 'address_state' at row 1 :: INSERT INTO paypal (order_id, txn_type, module_name, module_mode, reason_code, payment_type, payment_status, pending_reason, invoice, mc_currency, first_name, last_name, payer_business_name, address_name, address_street, address_city, address_state, address_zip, address_country, address_status, payer_email, payer_id, payer_status, payment_date, business, receiver_email, receiver_id, txn_id, parent_txn_id, num_cart_items, mc_gross, mc_fee, settle_amount, settle_currency, exchange_rate, notify_version, verify_sign, date_added, memo) VALUES ('1', 'cart', 'paypal (ipn-handler)', 'IPN', '', 'instant', 'Completed', '', '', 'GBP', 'John', '', '', 'John', '', '', '##', '', 'United Kingdom', 'confirmed', '', '73L8FS2N7YVAN', 'verified', '2018-07-29 11:10:42', '[email protected]', '[email protected]', 'TR6L66FGMVR74', '6E1240972T167191B', '', '1', '11.50', '0.59', '0', '', '1', '3.9', 'AQK2rlTiA7yEvIpfpBGXpUmqXHfDA-C0eMtwZ-bMXkSTXF-1tUtqmajY', now(), '{Record generated by IPN} [ProtectionEligibility:Eligible]') ==> (as called by) /var/www/vhosts/ee5b4f0.online-server.cloud/httpdocs/gep/store/includes/functions/functions_general.php on line 978 <== in /var/www/vhosts/ee5b4f0.online-server.cloud/httpdocs/gep/store/includes/classes/db/mysql/query_factory.php on line 171

[lat9]

Is your database configured to use a DB_CHARSET of utf8 (as set via your /includes/configure.php and /admin/includes/configure.php files)?

If so, is your database actually using a utf8 type of "collation", e.g. utf8_general_ci? You can see that using your webhost's cPanel's phpMyAdmin tool and viewing the 'collation' columns for the various tables in the database.

PayPal sends its information back to your store via IPN using a utf8-character set. That log implies that something's gone amiss in that communication.

[Deno]

Hello mate, thanks for the reply.

OK, in that case, do you think it might be because I didn't have the PDT token setup?

I've done that now and will see if it helps?

Thanks

Dene

[dbltoe]

The token should not have an effect in this situation.

How was your site loaded? Did you download the zip, extract it, and install it on your site? Did you use an "auto-installer"?

No one here would advocate installing with an auto-installer over the tried and true zip file method.

That said, I agree with lat9 that you have a character set problem. There's a download to fix the database at https://www.zen-cart.com/downloads.php?do=file&id=1318

You will still need to make sure other language files match the utf-8 settings.

[Deno]

I installed using the Zip/Unizip on to the server and installed form there.

Collation shows utf8_general_ci in phpMyAdmin

[Deno]

OK, i set up the PDT token and everything seems ok on the 2 orders we’ve got in.

One last question though. In the top left of the invoice it just says ‘store name’, ‘store address’ etc etc

Where so I submit the information to fill that in?

Thanks

Dene

[dbltoe]

In the Admin menu under Configuration is My Store.