Categories
View Replies (18)

Resolved Advanced Order Export fails

  1. Donnerflug
    Donnerflug
  2. RO CSVI
  3. Tuesday, 11 October 2022
  4.  Subscribe via email
Hello Tharuna,

unfortunately I have trouble with the order export.

1. If a customer orders as a guest, the customer is saved in the database with virtuemart_user_id 0. Until recently, the 0 was stored in the XML when exported. Now nothing is passed in the field. But I need the 0 for the import into the merchandise management. I tried it with a rule - unfortunately without success.

It's a live site and I need a solution asap. Sorry!

2. Sometimes it happens that orders have to be exported again. For this purpose I have copied the export template and enter the corresponding order ID(s) in the options tab. Unfortunately, the export fails with the new CSVI versions.

Thanks in advavance!

Manuela

Joomla 3.10.11
VM 4.0.7 V10718
CSVI 8.4.0
Attachments (3)
order_export_error.png order_export_error.png
csvi_templates_metzgerei-hambel.de_20221011.xml
com_csvi.log.128492.zip
0
Responses (18)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Manuela,
1. If a customer orders as a guest, the customer is saved in the database with virtuemart_user_id 0. Until recently, the 0 was stored in the XML when exported. Now nothing is passed in the field. But I need the 0 for the import into the merchandise management. I tried it with a rule - unfortunately without success.

I was able to reproduce this issue and fixed it with the attached patch file. Please load the attached patch file, try the export and let me know.

2. Sometimes it happens that orders have to be exported again. For this purpose I have copied the export template and enter the corresponding order ID(s) in the options tab. Unfortunately, the export fails with the new CSVI versions.

I see that you have an override file set for the export. It is possible that the override file is not updated to latest code and you see this error. When you run the export without the override, do you still see this error?
Attachments (1)
patch_2022_10_12.zip
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
Donnerflug
Donnerflug
Accepted Answer Pending Moderation
Hello Tharuna,

1. Thank you a lot, the patch file works fine :D

2. I tried the export without override and it seems to work - except the missing columns. Would you please adjust the override.
If there are any costs please let me know. It#s really urgent, our customers cannot process the online orders and now they need to re-export after the patch.

Kind regards,

Manuela
Attachments (1)
advancedexport.zip
  1. more than a month ago
  2. RO CSVI
  3. # 2
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Manuela,
I have updated the override file. Please check if export works as expected.
Attachments (1)
advancedexport_updated.zip
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 3
Donnerflug
Donnerflug
Accepted Answer Pending Moderation
Hello Tharuna,

sorry, it doesn't work - see attached image.

Kind regards,

Manuela
Attachments (1)
export-error2.png export-error2.png
  1. more than a month ago
  2. RO CSVI
  3. # 4
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Manuela,
Did you save the export template after applying the new override file? If not please resave the export template and check.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 5
Donnerflug
Donnerflug
Accepted Answer Pending Moderation
Hello Tharuna,

yes, I confirm the template is saved.

Kind regards,
Manuela
  1. more than a month ago
  2. RO CSVI
  3. # 6
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Manuela,
I don't see the error when I run the export here with override. Can you send me the Site login details and (S)FTP Details? I will check it on your site. You can post it on Site Details tab under your reply.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 7
Donnerflug
Donnerflug
Accepted Answer Pending Moderation
Hello Tharuna,

thanks, here the access data.

Kind regards,
Manuela
  1. more than a month ago
  2. RO CSVI
  3. # 8
Donnerflug
Donnerflug
Accepted Answer Pending Moderation
Hello Tharuna,

Unfortunately, the "standard" export with my "since last run" no longer works either. Now I can't pick up any more orders. Could it be related to PHP 8.0.23?

Should I downgrade to PHP 7.4.30?

Kind regards,

Manuela
  1. more than a month ago
  2. RO CSVI
  3. # 9
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Manuela,
Error with Order advanced export is fixed. Please check on your site.

Unfortunately, the "standard" export with my "since last run" no longer works either. Now I can't pick up any more orders. Could it be related to PHP 8.0.23?

I don't think it is related to PHP version. Do you see any error on export? Is it on the same site where we fixed the advanced order export? If not, please send me the export debug log to check.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 10
Donnerflug
Donnerflug
Accepted Answer Pending Moderation
Hello Tharuna,

I don't think it is related to PHP version. Do you see any error on export? Is it on the same site where we fixed the advanced order export? If not, please send me the export debug log to check.


I've done a few tests. It is actually related to PHP 8.0.23.

I'm back on PHP 7.4.30 with the modified Advanced Order version. I had to update the available fields. And lo and behold! It works.

But only with VM 4.0.6 and VM 4.0.7. With VM 3.8.9.10622 installed comes the error message when running export: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'subSKU' in 'field list' - see attached log file.

Kind regards,
Manuela
Attachments (1)
com_csvi.log_VM3.8.9.10622_92254.zip
  1. more than a month ago
  2. RO CSVI
  3. # 11
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Manuela,
I've done a few tests. It is actually related to PHP 8.0.23.

I'm back on PHP 7.4.30 with the modified Advanced Order version. I had to update the available fields. And lo and behold! It works.

I don't understand how the PHP version can get different results with same query. May I know if you had any error on PHP 8.0.23? What was the export output?

But only with VM 4.0.6 and VM 4.0.7. With VM 3.8.9.10622 installed comes the error message when running export: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'subSKU' in 'field list' - see attached log file.

I am assuming you have two different Joomla installation with different VM versions. Please check if you have subSKU field created in VirtueMart 3.8.9.10622 version. Unknown column error is when query has the field subSKU but the field is missing in database table.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 12
Donnerflug
Donnerflug
Accepted Answer Pending Moderation
Hello Tharuna,
I don't understand how the PHP version can get different results with same query. May I know if you had any error on PHP 8.0.23? What was the export output?

I'm not really understand your question. I still attached the error in posts above.
The error on export see attached image. NO output is created.

I am assuming you have two different Joomla installation with different VM versions. Please check if you have subSKU field created in VirtueMart 3.8.9.10622 version. Unknown column error is when query has the field subSKU but the field is missing in database table.

Of course there are two installations. In both DOESN'T EXISTS the subSKU field in custom fields list. In 4.0.7 it works (php7) and 3.8.9 it doesn't works. I removed in "override.sql" the subSKU field and now it works in 3.8.9 too.

Now I try it with PHP8 and will remove the field in the sql file.

Kind regards,
Manuela
Attachments (1)
export-error-php8.png export-error-php8.png
  1. more than a month ago
  2. RO CSVI
  3. # 13
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
I'm not really understand your question. I still attached the error in posts above.
The error on export see attached image. NO output is created.

There is some misunderstanding. The attached error is not because of PHP version but with the changes in new override file. There is a change in variable name in new override file. I had fixed this in the site you sent the details. Are you still having this error on same site?

Of course there are two installations. In both DOESN'T EXISTS the subSKU field in custom fields list. In 4.0.7 it works (php7) and 3.8.9 it doesn't works. I removed in "override.sql" the subSKU field and now it works in 3.8.9 too.

Now I try it with PHP8 and will remove the field in the sql file.

Instead of removing the override.sql file you can remove only this field from override.sql, update available fields and remove this field from template fields if added already. That should solve the problem.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 14
Donnerflug
Donnerflug
Accepted Answer Pending Moderation
Hello Tharuna,
Instead of removing the override.sql file you can remove only this field from override.sql, update available fields and remove this field from template fields if added already. That should solve the problem.

Yes, i did it in the morning and it solves the problem in all VM3.8.9, 4.0.6 and 4.0.7
However the only version where the export works with PHP8 is the VM4.0.7.

The other versions give the same error as shown in the export-error-php8.png image.

For now the solution is OK, thank you.

Kind regards,
Manuela
  1. more than a month ago
  2. RO CSVI
  3. # 15
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Manuela,
However the only version where the export works with PHP8 is the VM4.0.7.

I am curious to know why there is error with other versions. Is there any test site I can take a look at the error?
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 16
Donnerflug
Donnerflug
Accepted Answer Pending Moderation
Hello Tharuna,

First of all, I wish you all the best in the new year!

Sorry but we are still having trouble with Advanced Order Export along with PHP8.

The "normal" import and export processes work perfectly - apparently only the overrides for the advanced order export cause problems.

Could you please check and fix this? I set up a test environment with php 8.0.26 and 8.1.13 - see the access data in the site details.

Kind regards,

Manuela
Attachments (3)
php_8.0.26.png php_8.0.26.png
php_8.1.13.png php_8.1.13.png
error-php-8.0.26.png error-php-8.0.26.png
  1. more than a month ago
  2. RO CSVI
  3. # 17
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Manuela,
Thank you for posting the details. The problem was with override file. The variable in override file for group by and sort by fields were used as $groupbyfields and $sortbyfields instead of $groupByFields and $sortByFields (notice the capital letter variable names) for custom fields added in override file and that was throwing error. I fixed it on https://php80.weinbar-meier.de/ site and now there is no error on export. Please check and let me know.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 18
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!