Database I/O Manager (DbIo) Plugin [Support Thread]

[chuckrey]

Using ZC 2.1.0 / php 8.2
I haven't given up on this working but nearly there. I am using a test site completely free of other plugins and installed DBIO from Github.
Installed Products Options - Worked, no issue
Installed Product Options Vales - Inserts all lines, however when trying to view products via Catalog > Option Value Manager - Nothing appears, just blank.
I then went to PHPMyadmin and viewed the table of Products_Options_Values and they are all there...
I also checked products_options_values_to_products_options and it was blank.

Anyone suggestions? Anyone? Thanks :)

[lat9]

Using ZC 2.1.0 / php 8.2
I haven't given up on this working but nearly there. I am using a test site completely free of other plugins and installed DBIO from Github.
Installed Products Options - Worked, no issue
Installed Product Options Vales - Inserts all lines, however when trying to view products via Catalog > Option Value Manager - Nothing appears, just blank.
I then went to PHPMyadmin and viewed the table of Products_Options_Values and they are all there...
I also checked products_options_values_to_products_options and it was blank.

Anyone suggestions? Anyone? Thanks :)

That blank-screen display sounds like there's a PHP error that's been logged into the site's /logs directory. If you find that and post its full contents (obfuscating the name of the site's admin directory), that would give me something to "go on".

[chuckrey]

That blank-screen display sounds like there's a PHP error that's been logged into the site's /logs directory. If you find that and post its full contents (obfuscating the name of the site's admin directory), that would give me something to "go on".

I am including a log below. But let me better explain the issue. When I said "blank" I did not mean the entire page was a white blank page. I meant that the "field values" imported were not displayed on the catalog>option values menu. The header, footer, etc, was all there, but not the fields imported. However, when I went to PHPmyadmin all fields were imported. Here is the log..

[17-Apr-2025 03:11:13 UTC] Request URI: /xxxx/index.php?cmd=attributes_controller&products_filter=18&current_category_id=2, IP address: 107.201.xxx.xxx, Language id 1
#0 /home/xxxx/public_html/xxxx/attributes_controller.php(1962): zen_debug_error_handler()
#1 /home/xxxx/public_html/xxxx/index.php(16): require('/home/xxxx/...')
--> PHP Warning: Undefined variable $attributes_value in /home/xxxx/public_html/xxxx/attributes_controller.php on line 1962.

[lat9]

I am including a log below. But let me better explain the issue. When I said "blank" I did not mean the entire page was a white blank page. I meant that the "field values" imported were not displayed on the catalog>option values menu. The header, footer, etc, was all there, but not the fields imported. However, when I went to PHPmyadmin all fields were imported. Here is the log..

[17-Apr-2025 03:11:13 UTC] Request URI: /xxxx/index.php?cmd=attributes_controller&products_filter=18&current_category_id=2, IP address: 107.201.xxx.xxx, Language id 1
#0 /home/xxxx/public_html/xxxx/attributes_controller.php(1962): zen_debug_error_handler()
#1 /home/xxxx/public_html/xxxx/index.php(16): require('/home/xxxx/...')
--> PHP Warning: Undefined variable $attributes_value in /home/xxxx/public_html/xxxx/attributes_controller.php on line 1962.

That log's a known issue; see this Zen Cart PR for details: https://github.com/zencart/zencart/c...cd7ad2904ddaae

I'm still looking at the non-display of the imported option values.

[chuckrey]

That log's a known issue; see this Zen Cart PR for details: https://github.com/zencart/zencart/c...cd7ad2904ddaae

I'm still looking at the non-display of the imported option values.

Great. Thank you so much for your help. I also forgot to mention when trying to add attributes to a test product via admin, it does not display either. Just in PHPmyadmin. Thanks again.

[lat9]

Great. Thank you so much for your help. I also forgot to mention when trying to add attributes to a test product via admin, it does not display either. Just in PHPmyadmin. Thanks again.

Is this when you're trying to add attributes using the option values you've created via DbIo?

[chuckrey]

Is this when you're trying to add attributes using the option values you've created via DbIo?

Yes. When I go to the attribute controller, I can see the option names but there are no values listed. All values added were via DBIo.

[lat9]

Yes. When I go to the attribute controller, I can see the option names but there are no values listed. All values added were via DBIo.

Yep, as noted in our discussion above, the current implementation of the handler for the importing of options' values is quite messed up.

I should have an update (essentially a total rewrite) available within a couple of days.

[chuckrey]

Yep, as noted in our discussion above, the current implementation of the handler for the importing of options' values is quite messed up.

I should have an update (essentially a total rewrite) available within a couple of days.

Okay, thanks for getting back to me. I will keep an eye out for the rewrite...

[chadlly2003]

I found a bug.

when importing products if your text has a characteristics it does not like it still will import. But when you go to export file it looks or distorted within the excel sheet.


The issue is 'product_desc' table

If you open in excel and trim / clean formula in the description it will solve the issue and everything import/export fine.

This can really mess things up if people forgot to clean there html during the import process.