bulk editing serialized arrays doesn't work on integers
The support doesn work on Saturdays and Sundays, so some Friday requests can be answered on Monday. If you have problems with registration ask help on contact us page pleaseIf you not got email within 24~36 business hours, firstly check your spam box, and if no any email from the support there - back to the forum and read answer here. DO NOT ANSWER ON EMAILS [noreply@pluginus.net] FROM THE FORUM!! Emails are just for your info, all answers should be published only here.
The support doesn work on Saturdays and Sundays, so some Friday requests can be answered on Monday.
Quote from arty on April 6, 2023, 10:28Hi,
I have specified a custom field from wp_postmeta as an array for bulk editing/filtering.
Unfortunately BEAR doesn't work with integers on the serialized array
for instance my current array is: a:2:{i:0;i:5843;i:1;i:53203;} which is not recognised by bear.
if i change the array to string like: a:2:{i:0;i:"5843";i:1;i:"53203";} it works perfectly.
Is there any workaround on this issue?
thank you in advance,
Menelaos
Hi,
I have specified a custom field from wp_postmeta as an array for bulk editing/filtering.
Unfortunately BEAR doesn't work with integers on the serialized array
for instance my current array is: a:2:{i:0;i:5843;i:1;i:53203;} which is not recognised by bear.
if i change the array to string like: a:2:{i:0;i:"5843";i:1;i:"53203";} it works perfectly.
Is there any workaround on this issue?
thank you in advance,
Menelaos
Quote from Pablo Borysenco on April 6, 2023, 12:09Hello Menelaos
Please watch this video - https://bulk-editor.com/video#video_3044
Hello Menelaos
Please watch this video - https://bulk-editor.com/video#video_3044
Quote from arty on April 6, 2023, 15:56Hi Pablo,
i hope that my message finds you well.
I have watched the video and i have carefully followed the instructions.
The fields are visible in BEAR editor however they show up empty although they have values.
After checking the relative sql entry in wp_postmeta table i can see that exists: a:2:{i:0;i:5843;i:1;i:53203;}
which is a serialized array based in integer values.
Now if i manually change the array from phpmyadmin to: a:2:{i:0;i:"5843";i:1;i:"53203";}
and i click on the corresponding "array" button, it reads the existing information without an issue.
So i concluded that BEAR doesn't support int type serialized values but works well with string type serialized values.
I have modified the plugin(WCPA) where these values come from and forced to create string type values, which solves the problem for new entries.
However all old entries are set as integers and it needs a lot of custom work in order to make the compatibled with BEAR.
is it possible to modify BEAR so it can work with integer serialized arrays?
if yes, how much would it cost us?
thank you in advance,
Menelaos
Hi Pablo,
i hope that my message finds you well.
I have watched the video and i have carefully followed the instructions.
The fields are visible in BEAR editor however they show up empty although they have values.
After checking the relative sql entry in wp_postmeta table i can see that exists: a:2:{i:0;i:5843;i:1;i:53203;}
which is a serialized array based in integer values.
Now if i manually change the array from phpmyadmin to: a:2:{i:0;i:"5843";i:1;i:"53203";}
and i click on the corresponding"array" button, it reads the existing information without an issue.
So i concluded that BEAR doesn't support int type serialized values but works well with string type serialized values.
I have modified the plugin(WCPA) where these values come from and forced to create string type values, which solves the problem for new entries.
However all old entries are set as integers and it needs a lot of custom work in order to make the compatibled with BEAR.
is it possible to modify BEAR so it can work with integer serialized arrays?
if yes, how much would it cost us?
thank you in advance,
Menelaos
Quote from Pablo Borysenco on April 7, 2023, 09:38Hello Menelaos
What plugin version number are you using?
Hello Menelaos
What plugin version number are you using?
Quote from Pablo Borysenco on April 7, 2023, 11:08Please paste your license key here - https://share.pluginus.net/image/i20230222134241.png -> https://share.pluginus.net/image/i20230222134511.png and wp-admin access - https://share.pluginus.net/image/i20230222134615.png - I will check it
Please paste your license key here - https://share.pluginus.net/image/i20230222134241.png -> https://share.pluginus.net/image/i20230222134511.png and wp-admin access - https://share.pluginus.net/image/i20230222134615.png - I will check it
Quote from arty on April 7, 2023, 11:13Hi Pablo,
I have provided necessary information
thaank you for your time,
Menelaos
Hi Pablo,
I have provided necessary information
thaank you for your time,
Menelaos
Quote from Pablo Borysenco on April 7, 2023, 14:34Please add FTP access - https://share.pluginus.net/image/i20230222134241.png ->https://share.pluginus.net/image/i20230222134615.png
and exact link or ID of a product where this feature does not work
Please add FTP access - https://share.pluginus.net/image/i20230222134241.png ->https://share.pluginus.net/image/i20230222134615.png
and exact link or ID of a product where this feature does not work
Quote from arty on April 10, 2023, 11:33Hi Pablo,
i have added ftp connection credentials.
one of the products is id: 151437
a screenshot with the relative sql entry in wp_postmeta is: https://prnt.sc/7NAY-CUSkKuD
if you go to https://new.an-agapas.gr/wp-admin/post.php?post=151437&action=edit&lang=el and click on Custom Product Options you can see that the 2 forms are selected connecting them with the sql entry i have provided the screenshot above.
However in BEAR it's empty like: https://prnt.sc/w9b6xgWBX5Jk
now if i transform the entry to: a:2:{i:0;i:"5843";i:1;i:"44667";} it's working perfect
thank you again for your time,
Menelaos
Hi Pablo,
i have added ftp connection credentials.
one of the products is id: 151437
a screenshot with the relative sql entry in wp_postmeta is: https://prnt.sc/7NAY-CUSkKuD
if you go to https://new.an-agapas.gr/wp-admin/post.php?post=151437&action=edit&lang=el and click on Custom Product Options you can see that the 2 forms are selected connecting them with the sql entry i have provided the screenshot above.
However in BEAR it's empty like: https://prnt.sc/w9b6xgWBX5Jk
now if i transform the entry to: a:2:{i:0;i:"5843";i:1;i:"44667";} it's working perfect
thank you again for your time,
Menelaos
Quote from Pablo Borysenco on April 10, 2023, 12:28Hello Menelaos
Please give me the product ID where it doesn't work. I can't test it if I don't see an error. You have over 15,000 products and it's hard for me to find a product with an error
Hello Menelaos
Please give me the product ID where it doesn't work. I can't test it if I don't see an error. You have over 15,000 products and it's hard for me to find a product with an error
Quote from arty on April 10, 2023, 13:08hi, i have provided product id on my previous answer.
the edit link is: https://new.an-agapas.gr/wp-admin/post.php?post=151437&action=edit&lang=en
hi, i have provided product id on my previous answer.
the edit link is: https://new.an-agapas.gr/wp-admin/post.php?post=151437&action=edit&lang=en
Quote from Pablo Borysenco on April 12, 2023, 09:39Hello
Ok! I checked it - https://c2n.me/4ihNsKK.png - everything works correctly
Hello
Ok! I checked it - https://c2n.me/4ihNsKK.png - everything works correctly
Quote from arty on April 12, 2023, 11:45Hi Pablo,
I can confirm that it's working now.
if i update the plugin on next release, will we loose this funcionality?
thank you in advance,
Menelaos
Hi Pablo,
I can confirm that it's working now.
if i update the plugin on next release, will we loose this funcionality?
thank you in advance,
Menelaos
Quote from Pablo Borysenco on April 12, 2023, 12:53I didn't change anything at all. I checked and from the beginning everything worked correctly. For this reason, I wrote to you so that you would give a link to a product where it does not work
I didn't change anything at all. I checked and from the beginning everything worked correctly. For this reason, I wrote to you so that you would give a link to a product where it does not work
Quote from arty on April 13, 2023, 10:02Hi Pablo,
All old products still face the same issue.
please check product ids: 151437 15496 159490 159486 159476 159480
the issue is there in all old products.
products that have been updated don't face this issue anymore as i have modified the plugin that saves the custom array to use string instead of int.
So all products that have been editing using standard woocommerce product editor seems to be working on BEAR because of the above fix.
However all older products still face the issue.
please advice,
kind regards,
Menelaos
Hi Pablo,
All old products still face the same issue.
please check product ids: 151437 15496 159490 159486 159476 159480
the issue is there in all old products.
products that have been updated don't face this issue anymore as i have modified the plugin that saves the custom array to use string instead of int.
So all products that have been editing using standard woocommerce product editor seems to be working on BEAR because of the above fix.
However all older products still face the issue.
please advice,
kind regards,
Menelaos
Quote from Pablo Borysenco on April 13, 2023, 11:45Hello Menelaos
I did a test - https://c2n.me/4iisV8M.mp4
products that have been updated don't face this issue anymore as i have modified the plugin that saves the custom array to use string instead of int. - I get it, do you have products where you haven't updated it?
Hello Menelaos
I did a test - https://c2n.me/4iisV8M.mp4
products that have been updated don't face this issue anymore as i have modified the plugin that saves the custom array to use string instead of int. - I get it, do you have products where you haven't updated it?
Quote from arty on April 13, 2023, 11:48please check product ids: 151437 15496 159490 159486 159476 159480
the above are only some of them
please check product ids: 151437 15496 159490 159486 159476 159480
the above are only some of them
Quote from Pablo Borysenco on April 13, 2023, 11:59Ok! I checked these products - https://c2n.me/4iitE5I.mp4
Ok! I checked these products - https://c2n.me/4iitE5I.mp4
Quote from arty on April 13, 2023, 12:01the issue is with column Custom_forms and not with tiered_pricing
the issue is with column Custom_forms and not with tiered_pricing
Quote from Pablo Borysenco on April 14, 2023, 13:17Hello
Please do a test
In file - \wp-content\plugins\woocommerce-bulk-editor\ext\meta\assets\js\meta.js - I added this code - https://share.pluginus.net/image/i20230414141655.png
Hello
Please do a test
In file - \wp-content\plugins\woocommerce-bulk-editor\ext\meta\assets\js\meta.js - I added this code - https://share.pluginus.net/image/i20230414141655.png