Phoenix 1.0.8.5 @ 7a8144f
Sale does not go thru and paypal express checkout returns to a blank page:-
"
https://www.BLAHBLAH.com.au/ext/modules ... VTDUZFTDCA"
I have no input to Paypal site : Edit Instant Payment Notification (IPN) settings
What goes in there?
Auto-return is set to on :-
https://www.BLAHBLAH.com.au/checkout_process.php
Payment data transfer (optional) :on and filled.
.From Error Log.
AH01071: Got error 'PHP message: PHP Notice: Undefined index: name in /ext/modules/payment/paypal/express.php on line 46PHP message: PHP Notice: Undefined index: iso_code_2 in /ext/modules/payment/paypal/express.php on line 47PHP message: PHP Notice: Undefined index: iso_code_3 in /ext/modules/payment/paypal/express.php on line 48PHP message: PHP Notice: Undefined index: format_id in /ext/modules/payment/paypal/express.php on line 49PHP message: PHP Notice: Undefined property: shoppingCart::$cartID in /ext/modules/payment/paypal/express.php on line 60PHP message: PHP Fatal error: Uncaught Error: Call to a member function fetch_to_address() on null in /includes/system/versioned/1.0.7.10/cart_order_builder.php:79\nStack trace:\n#0 /includes/system/versioned/1.0.7.10/cart_order_builder.php(163): cart_order_builder->build_addresses()\n#1 /includes/system/versioned/1.0.7.10/order.php(25): cart_order_builder::build()\n#2 /ext/modules/payment/paypal/express.php(155): order->__construct()\n#3 {main}\n thrown in /includes/system/versioned/1.0.7.10/cart_order_builder.php on line 79'
AH01071: Got error 'PHP message: PHP Notice: Undefined index: PAYMENTREQUEST_0_SHIPTOSTREET2 in /ext/modules/payment/paypal/express.php on line 393PHP message: PHP Fatal error: Uncaught TypeError: Argument 1 passed to Text::input() must be of the type string, null given, called in /includes/functions/database.php on line 75 and defined in /includes/system/versioned/1.0.8.2/text.php:34\nStack trace:\n#0 /includes/functions/database.php(75): Text::input()\n#1 /ext/modules/payment/paypal/express.php(393): tep_db_prepare_input()\n#2 {main}\n thrown in /includes/system/versioned/1.0.8.2/text.php on line 34', referer:
https://www.sandbox.paypal.com/
This is allmost a vanilla install localised to Australia:
Ran this script through phpMyAdmin.
-- Tables affected:
-- address_format;
-- countries;
-- zones;
-- geo_zones;
-- zones_to_geo_zones;
-- tax_rates;
-- tax_class;
DELETE FROM address_format;
-- Data based on that provided with v 2.3.4 installation, and added formats 6 to 10.
INSERT INTO address_format (address_format_id, address_format, address_summary) VALUES
(1, '$name$cr$streets$cr$city, $postcode$cr$statecomma$country','$city / $country'),
(2, '$name$cr$streets$cr$city, $state $postcode$cr$country', '$city, $state / $country'),
(3, '$name$cr$streets$cr$city$cr$postcode - $statecomma$country', '$state / $country'),
(4, '$name$cr$streets$cr$city ($postcode)$cr$country', '$postcode / $country'),
(5, '$name$cr$streets$cr$postcode $city$cr$country', '$city / $country'),
(6, '$name$cr$streets$cr$city, $postcode$cr$statecomma$country', '$city $country'),
(7, '$name$cr$streets$cr$city,$cr$state$cr$postcode$cr$country', '$city, $state / $country'),
(8, '$name$cr$streets$cr$city$cr$postcode $country', '$country / $postcode'),
(9, '$name$cr$streets$cr$city $state $postcode$cr$country', '$city / $country'),
(10, '$name$cr$streets$cr$postcode $city$cr$country', '$city / $country');
-- Select a small set of reasonable countries
DELETE FROM countries;
INSERT INTO countries (countries_id, countries_name, countries_iso_code_2, countries_iso_code_3, address_format_id) VALUES
(13, 'Australia', 'AU', 'AUS', 6),
(153, 'New Zealand', 'NZ', 'NZL', 1),
(96, 'Hong Kong', 'HK', 'HKG', 1),
(222, 'United Kingdom', 'GB', 'GBR', 7),
(223, 'United States', 'US', 'USA', 2),
(38, 'Canada', 'CA', 'CAN', 2),
(81, 'Germany', 'DE', 'DEU', 5),
(203, 'Sweden', 'SE', 'SWE', 5),
(103, 'Ireland', 'IE', 'IRL', 9),
(188, 'Singapore', 'SG', 'SGP', 7),
(150, 'Netherlands', 'AN', 'NLD', 11),
(221, 'United Arab Emirates', 'AE', 'ARE', 6);
-- Add Australian states
DELETE FROM zones;
INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES
(1, 13, 'VIC', 'Victoria'),
(2, 13, 'NSW', 'New South Wales'),
(3, 13, 'QLD', 'Queensland'),
(4, 13, 'SA', 'South Australia'),
(5, 13, 'NT', 'Northern Territory'),
(6, 13, 'TAS', 'Tasmania'),
(7, 13, 'ACT', 'Australian Capital Territory'),
(8, 13, 'WA', 'Western Australia');
-- Create zones for AU GST, overseas, and one for NZ (useful for shipping)
DELETE FROM geo_zones;
INSERT INTO geo_zones (geo_zone_id, geo_zone_name, geo_zone_description, last_modified, date_added) VALUES
(1, 'Australia', 'GST within Australia', NOW(), NOW()),
(2, 'Outside Australia', 'Outside Australia', NOW(), NOW()),
(3, 'New Zealand', 'New Zealand', NOW(), NOW());
DELETE FROM zones_to_geo_zones;
INSERT INTO zones_to_geo_zones (
association_id, zone_country_id, zone_id, geo_zone_id, last_modified, date_added) VALUES
(1, 13, NULL, 1, NOW(), NOW() ),
(2, 153, 0, 3, NOW(), NOW() ),
(3, 96, 0, 2, NOW(), NOW() ),
(4, 222, 0, 2, NOW(), NOW() ),
(5, 223, 0, 2, NOW(), NOW() ),
(6, 38, 0, 2, NOW(), NOW() ),
(7, 81, 0, 2, NOW(), NOW() ),
(8, 203, 0, 2, NOW(), NOW() ),
(9, 103, 0, 2, NOW(), NOW() ),
(10, 188, 0, 2, NOW(), NOW() ),
(11, 150, 0, 2, NOW(), NOW() ),
(12, 221, 0, 2, NOW(), NOW() );
DELETE FROM tax_rates;
INSERT INTO tax_rates (tax_rates_id, tax_zone_id, tax_class_id, tax_priority, tax_rate, tax_description, last_modified, date_added) VALUES
(1, 1, 1, 1, 10.0000, 'GST', NOW(), NOW());
DELETE FROM tax_class;
INSERT INTO tax_class (tax_class_id, tax_class_title, tax_class_description, last_modified, date_added) VALUES
(1, 'Taxable Goods', 'The following types of products are included non-food, services, etc', NOW(), NOW()),
(2, 'GST free','GST free goods eg. unprocessed food.',NOW(),NOW());
And
both English.php edited to
setlocale(LC_ALL, ['en_AU.UTF-8', 'en_AU.UTF8', 'ena_au']);
and
const LANGUAGE_CURRENCY = 'AUD';
Any ideas?
