Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Bundle product with digital-products won't show in invoice #13

Open
hurby opened this issue Oct 5, 2023 · 5 comments
Open

Bundle product with digital-products won't show in invoice #13

hurby opened this issue Oct 5, 2023 · 5 comments

Comments

@hurby
Copy link

hurby commented Oct 5, 2023

A single download product wil be inside the invoice

Scherm­afbeelding 2023-10-05 om 13 12 59

A bundle containing digital products wil not.
Scherm­afbeelding 2023-10-05 om 13 13 57

@hurby
Copy link
Author

hurby commented Oct 5, 2023

It has something to do with the amout of digital products inside the bundle, a bundle of 59 digital products will not show in the invoice a bundle with 4 products will. Strange since the bundle is the only product needing to be in the invoice

this i find in the error log

INSERT INTO modx_commerce_order_address (id, class_key, properties, order, type, user_address, fullname, firstname, lastname, company, address1, address2, address3, zip, city, state, country, phone, mobile, email, notes, address) VALUES (1249, 'comOrderAddress', 'a:1:{s:16:"vat_registration";s:0:"";}', 1420, 'billing', 14, 'dewa', '', '', '', 'dew', '', '', '23', '32', '32', 'NL', '', '', '[email protected]', '', 0)
Array
(
[0] => 23000
[1] => 1062
[2] => Duplicate entry '1249' for key 'PRIMARY'
)

[2023-10-05 11:27:41] (ERROR @ /www/core/xpdo/om/xpdoobject.class.php : 1452) Error 23000 executing statement:
INSERT INTO modx_commerce_order_address (id, class_key, properties, order, type, user_address, fullname, firstname, lastname, company, address1, address2, address3, zip, city, state, country, phone, mobile, email, notes, address) VALUES (1250, 'comOrderAddress', 'a:0:{}', 1420, 'shipping', 13, 'dewa', '', '', '', 'dew', '', '', '23', '32', '32', 'NL', '', '', '[email protected]', '', 0)
Array
(
[0] => 23000
[1] => 1062
[2] => Duplicate entry '1250' for key 'PRIMARY'
)

@muzzwood
Copy link
Contributor

muzzwood commented Oct 5, 2023

I don't think that error is related, though that's also interesting. Is that being logged during the address step of checkout?
I've only tested with a few products so far, but will look into it.

@hurby
Copy link
Author

hurby commented Oct 5, 2023

The bundle contains 59 files. I know it is a lot of files
Mayby there's something going wrong with the order object to pdf. Mail is much bigger to generate but fine.
It is pure the invoice.

@hurby
Copy link
Author

hurby commented Oct 5, 2023

From address step onwards till payment, the last two lines are the thing i think

[2023-10-05 11:49:42] (ERROR @ /www/core/xpdo/om/xpdoobject.class.php : 1452) Error 23000 executing statement:
INSERT INTO modx_commerce_order_address (id, class_key, properties, order, type, user_address, fullname, firstname, lastname, company, address1, address2, address3, zip, city, state, country, phone, mobile, email, notes, address) VALUES (1261, 'comOrderAddress', 'a:1:{s:16:"vat_registration";s:0:"";}', 1423, 'billing', 14, 'dewa', '', '', '', 'dew', '', '', '23', '32', '32', 'NL', '', '', '[email protected]', '', 0)
Array
(
[0] => 23000
[1] => 1062
[2] => Duplicate entry '1261' for key 'PRIMARY'
)

[2023-10-05 11:49:42] (ERROR @ /www/core/xpdo/om/xpdoobject.class.php : 1452) Error 23000 executing statement:
INSERT INTO modx_commerce_order_address (id, class_key, properties, order, type, user_address, fullname, firstname, lastname, company, address1, address2, address3, zip, city, state, country, phone, mobile, email, notes, address) VALUES (1262, 'comOrderAddress', 'a:0:{}', 1423, 'shipping', 80, 'herbert', '', '', '', 'Plein Eendragt 25b', '', '', '3111 AS', 'Schiedam', '', 'BE', '0626142194', '', '[email protected]', '', 0)
Array
(
[0] => 23000
[1] => 1062
[2] => Duplicate entry '1262' for key 'PRIMARY'
)

[2023-10-05 11:49:43] (ERROR @ /www/core/cache/includes/elements/modplugin/25.include.cache.php : 5) PHP warning: Undefined property: modX::$hpCount
[2023-10-05 11:50:18] (ERROR @ /www/core/cache/includes/elements/modplugin/25.include.cache.php : 5) PHP warning: Undefined property: modX::$hpCount
[2023-10-05 11:50:28] (ERROR @ /www/core/cache/includes/elements/modplugin/25.include.cache.php : 5) PHP warning: Undefined property: modX::$hpCount
[2023-10-05 11:50:28] (ERROR @ /www/core/xpdo/om/xpdoobject.class.php : 811) comOrderAddress: Attempt to set NOT NULL field order to NULL
[2023-10-05 11:50:28] (ERROR @ /www/core/xpdo/om/xpdoobject.class.php : 811) comOrderAddress: Attempt to set NOT NULL field order to NULL

@hurby
Copy link
Author

hurby commented Oct 5, 2023

i,ve setup a testing environment with three products 1 single digi product , 1 bundels with 4 digi products , one bundle with 59 digi products. the last one is the only one failing in invoice. The invoice doesn't need to contain the bundles content. Something there is off

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants