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

[lat9]

v2.2.0 of the Database I/O Manager is now available for download: https://www.zen-cart.com/downloads.php?do=file&id=2091

This release contains changes associated with these GitHub issues:


#242: Correct PHP 8.5 deprecation on use of boolean vs. bool cast.
#245: Correct PHP warning when exporting ProductsOptionsValues.
#246: Correct PHP "strict mode" fatal error when using ProductsAttribsRaw handler.
#251: Allow 'NULL' import to nullable fields.
#254: Dropping support for zc157
- Adding support for array-based handler language files.
- Removing zen_cfg_read_only.php from the extra_functions directory; it's in-core for zc158+.
#253: Font Awesome classes changed for FA v6, still keeping FA 4 support for zc158.
#255: Use updated Encoding class, for PHP 8.0+ support.
#257: Various handlers can have unencoded text fields for a latin1 export.
#259: Provide a zen_config polyfill, supporting that change for zc300.
#261: Added handlers for Products' Options' Stock Manager; it needs to be installed for the handlers to be used.
#247: Adding type-hints to plugin's classes; all files in /YOUR_ADMIN/includes/classes/dbio were modified.
#264: DbioProductsOptionsValuesHandler issuing incorrect errors for missing option-id values.

[lat9]

v2.2.1 of the Database I/O Manager is now available for download: https://www.zen-cart.com/downloads.php?do=file&id=2091

This release contains updates for these GitHub issues and should be used instead of v2.2.0:


#265: Correct language_id default to prevent PHP Fatal error if no language element in import.
#266: Correct type-hint for DbioHandler::key_index; changing to int|false.
#267: Additional modifications for missed type-hinting changes introduced in v2.2.0.

[cheddars]

I cannot load Dbio manager from the tools menu. I have upgraded from v2.1.0 to v 2.2.1 and I am using ZC 2.2.2 and PHP 8.2
I receive the following http 500 error. Any advice please?

[23-Jun-2026 09:12:30 UTC] PHP Parse error: syntax error, unexpected identifier "DBIO_HANDLER_VERSION", expecting "=" in /admin/includes/classes/dbio/DbIoHandler.php on line 23

[23-Jun-2026 09:12:30 UTC] Request URI: /admin/index.php?cmd=dbio_manager, IP address: xx.xxx.xxx.xx
--> PHP Parse error: syntax error, unexpected identifier "DBIO_HANDLER_VERSION", expecting "=" in /admin/includes/classes/dbio/DbIoHandler.php on line 23.

[23-Jun-2026 09:12:30 UTC] Request URI: /admin/index.php?cmd=dbio_manager, IP address: xx.xxx.xxx.xx
--> PHP Parse error: syntax error, unexpected identifier "DBIO_HANDLER_VERSION", expecting "=" in /admin/includes/classes/dbio/DbIoHandler.php on line 23.

[lat9]

I cannot load Dbio manager from the tools menu. I have upgraded from v2.1.0 to v 2.2.1 and I am using ZC 2.2.2 and PHP 8.2
I receive the following http 500 error. Any advice please?

[23-Jun-2026 09:12:30 UTC] PHP Parse error: syntax error, unexpected identifier "DBIO_HANDLER_VERSION", expecting "=" in /admin/includes/classes/dbio/DbIoHandler.php on line 23

[23-Jun-2026 09:12:30 UTC] Request URI: /admin/index.php?cmd=dbio_manager, IP address: xx.xxx.xxx.xx
--> PHP Parse error: syntax error, unexpected identifier "DBIO_HANDLER_VERSION", expecting "=" in /admin/includes/classes/dbio/DbIoHandler.php on line 23.

[23-Jun-2026 09:12:30 UTC] Request URI: /admin/index.php?cmd=dbio_manager, IP address: xx.xxx.xxx.xx
--> PHP Parse error: syntax error, unexpected identifier "DBIO_HANDLER_VERSION", expecting "=" in /admin/includes/classes/dbio/DbIoHandler.php on line 23.

Yes, those last updates now require PHP 8.3 or later.

[allmart]

Yes, those last updates now require PHP 8.3 or later.

I upgraded to 2.2.1 and I am using ZC 2.1.0 and PHP 8.4. No longer able to import new products, when i check the file before import, there are no errors but when i try to import, it crashes with this error

File Contents( /home/xxx/public_html/logs/myDEBUG-adm-20260715-162715-199182.log)
[15-Jul-2026 16:27:15 America/Toronto] PHP Fatal error: Uncaught TypeError: DbIoProductsHandler::importUpdateRecordKey(): Argument #3 ($record_key_value) must be of type string|false, int given, called in /admin_xxx/includes/classes/dbio/DbIoHandler.php on line 1025 and defined in /admin_xxx/includes/classes/dbio/DbIoProductsHandler.php:1331
Stack trace:
#0 /admin_xxx/includes/classes/dbio/DbIoHandler.php(1025): DbIoProductsHandler->importUpdateRecordKey('products_descri...', Array, 1622)
#1 /admin_xxx/includes/classes/dbio/DbIo.php(270): DbIoHandler->importCsvRecord(Array)
#2 /admin_xxx/dbio_manager.php(239): DbIo->dbioImport('dbio.Products.L...', 'run')
#3 /admin_xxx/index.php(16): require('/home/xxx/p...')
#4 {main}
thrown in /admin_xxx/includes/classes/dbio/DbIoProductsHandler.php on line 1331

[15-Jul-2026 16:27:15 America/Toronto] Request URI: /admin_xxx/index.php?cmd=dbio_manager&action=file, IP address: 184.148.48.168
--> PHP Fatal error: Uncaught TypeError: DbIoProductsHandler::importUpdateRecordKey(): Argument #3 ($record_key_value) must be of type string|false, int given, called in /admin_xxx/includes/classes/dbio/DbIoHandler.php on line 1025 and defined in /admin_xxx/includes/classes/dbio/DbIoProductsHandler.php:1331
Stack trace:
#0 /admin_xxx/includes/classes/dbio/DbIoHandler.php(1025): DbIoProductsHandler->importUpdateRecordKey('products_descri...', Array, 1622)
#1 /admin_xxx/includes/classes/dbio/DbIo.php(270): DbIoHandler->importCsvRecord(Array)
#2 /admin_xxx/dbio_manager.php(239): DbIo->dbioImport('dbio.Products.L...', 'run')
#3 /admin_xxx/index.php(16): require('/home/xxx/p...')
#4 {main}
thrown in /admin_xxx/includes/classes/dbio/DbIoProductsHandler.php on line 1331.

[15-Jul-2026 16:27:15 America/Toronto] Request URI: /admin_xxx/index.php?cmd=dbio_manager&action=file, IP address: 184.148.48.168
--> PHP Fatal error: Uncaught TypeError: DbIoProductsHandler::importUpdateRecordKey(): Argument #3 ($record_key_value) must be of type string|false, int given, called in /admin_xxx/includes/classes/dbio/DbIoHandler.php on line 1025 and defined in /admin_xxx/includes/classes/dbio/DbIoProductsHandler.php:1331
Stack trace:
#0 /admin_xxx/includes/classes/dbio/DbIoHandler.php(1025): DbIoProductsHandler->importUpdateRecordKey('products_descri...', Array, 1622)
#1 /admin_xxx/includes/classes/dbio/DbIo.php(270): DbIoHandler->importCsvRecord(Array)
#2 /admin_xxx/dbio_manager.php(239): DbIo->dbioImport('dbio.Products.L...', 'run')
#3 /admin_xxx/index.php(16): require('/home/xxx/p...')
#4 {main}
thrown in /admin_xxx/includes/classes/dbio/DbIoProductsHandler.php on line 1331.

When looking at my database, of the 5 products the only product that is imported in this case is 1622 but there is no entry in the products_description table.

Thanks in advance for your help.

[dbltoe]

I upgraded to 2.2.1 and I am using ZC 2.1.0 and PHP 8.4. No longer able to import new products, when i check the file before import, there are no errors but when i try to import, it crashes with this error

This is the part that begs the question: How did you upgrade?

First, how can one upgrade to 2.2.1 and still be using 2.0.1? Hopefully a typo.

From which version, and why not 2.2.2?

Then, did you do a database only upgrade?

From the wording of your post, it looks like you may not have fully upgraded and a file or two is missing, you did not fully upgrade the database, or both.

[lat9]

@allmart, I've created a tracking issue on GitHub: https://github.com/lat9/dbio/issues/268

[lat9]

@allmart, I've created a tracking issue on GitHub: https://github.com/lat9/dbio/issues/268

Correction now available: https://github.com/lat9/dbio/commit/...dd03b712ef59f3

It's a simple update to line 1031 of admin/includes/classes/dbio/DbioHandler.php, adding a string cast:

                                                $record_key_value = (string)$db->insert_ID();

[allmart]

Correction now available: https://github.com/lat9/dbio/commit/...dd03b712ef59f3

It's a simple update to line 1031 of admin/includes/classes/dbio/DbioHandler.php, adding a string cast:

                                                $record_key_value = (string)$db->insert_ID();

Thank you so much lat9 ... you rock!