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

[Renee Mott]

have they come up with an inventory report by model yet??? The inventory report or low on inventory report not great for over 2000 items. would love to narrow it down by model or category/model

[lat9]

have they come up with an inventory report by model yet??? The inventory report or low on inventory report not great for over 2000 items. would love to narrow it down by model or category/model

DbIo provides a category-filter for its Products export. Using that in conjunction with the quantity_only DbIo "template" should yield you close to what you're looking for.

[dbltoe]

FWIW

Soon to be updated 1.5.7d with PHP 7.4.33.

After initial install, clicking on Tools >> Database I/O Manager threw a 500

[09-Oct-2025 13:45:00 America/New_York] PHP Parse error: syntax error, unexpected '|', expecting '{' in /******/includes/functions/dbio_manager_functions.php on line 10

[09-Oct-2025 13:45:00 America/New_York] Request URI: /******/index.php?cmd=dbio_manager, IP address: 216.177.186.199
--> PHP Parse error: syntax error, unexpected '|', expecting '{' in /yakmaster/includes/functions/dbio_manager_functions.php on line 10.

Changing line 10 from:

function dbioGetFieldValue(string $field_name): array|string

to

function dbioGetFieldValue(string $field_name)

allows operation with no problems found so far.

[lat9]

Right, the array|string type hint isn't supported on PHP versions prior to 8.0.

[dbltoe]

After reviewing the docs, wiki, and template creation info, I wonder if it is possible to join tables for the query.

I need to have the ID, Model, Price, and Price_W, which are all available in the products table, but I would also like to include the product's name, which is in the products_description table.

Is this possible without munging code or creating a joined table?

[lat9]

After reviewing the docs, wiki, and template creation info, I wonder if it is possible to join tables for the query.

I need to have the ID, Model, Price, and Price_W, which are all available in the products table, but I would also like to include the product's name, which is in the products_description table.

Is this possible without munging code or creating a joined table?

The default DbIoProduct export (er) exports all fields in the products and products_descriptions tables (a couple of others, too).

[dbltoe]

I guess what threw me was that the items are apparently sorted by table, other than alphabetically.

I found what I needed and learned a little. Check Mark for the day.

THANX

[swguy]

Attempting to do an update for FEATURED is failing with the latest dbio. If I do an EXPORT of the featured data, then an upload and an Import (Full), I get this log:

[04-Nov-2025 14:38:58 America/New_York] Request URI: /admin/index.php?cmd=dbio_manager&action=file, IP address: ::1, Language id 1
#0 [internal function]: zen_debug_error_handler()
#1 /Users/scott/Sites/mmpgamers/includes/classes/db/mysql/query_factory.php(667): trigger_error()
#2 /Users/scott/Sites/mmpgamers/includes/classes/db/mysql/query_factory.php(634): queryFactory->show_error()
#3 /Users/scott/Sites/mmpgamers/includes/classes/db/mysql/query_factory.php(275): queryFactory->set_error()
#4 /Users/scott/Sites/mmpgamers/admin/includes/classes/dbio/DbIoHandler.php(1029): queryFactory->Execute()
#5 /Users/scott/Sites/mmpgamers/admin/includes/classes/dbio/DbIo.php(274): DbIoHandler->importCsvRecord()
#6 /Users/scott/Sites/mmpgamers/admin/dbio_manager.php(242): DbIo->dbioImport()
#7 /Users/scott/Sites/mmpgamers/admin/index.php(11): require('/Users/scott/Si...')
--> PHP Fatal error: 1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SE WHERE p.products_model = 'NSG-FTE' AND f.products_id = p.products_id' at line 1 :: UPDATE zen_products p SE WHERE p.products_model = 'NSG-FTE' AND f.products_id = p.products_id ==> (as called by) /Users/scott/Sites/mmpgamers/admin/includes/classes/dbio/DbIoHandler.php on line 1029 <== in /Users/scott/Sites/mmpgamers/includes/classes/db/mysql/query_factory.php on line 667.

[lat9]

Attempting to do an update for FEATURED is failing with the latest dbio. If I do an EXPORT of the featured data, then an upload and an Import (Full), I get this log:

[04-Nov-2025 14:38:58 America/New_York] Request URI: /admin/index.php?cmd=dbio_manager&action=file, IP address: ::1, Language id 1
#0 [internal function]: zen_debug_error_handler()
#1 /Users/scott/Sites/mmpgamers/includes/classes/db/mysql/query_factory.php(667): trigger_error()
#2 /Users/scott/Sites/mmpgamers/includes/classes/db/mysql/query_factory.php(634): queryFactory->show_error()
#3 /Users/scott/Sites/mmpgamers/includes/classes/db/mysql/query_factory.php(275): queryFactory->set_error()
#4 /Users/scott/Sites/mmpgamers/admin/includes/classes/dbio/DbIoHandler.php(1029): queryFactory->Execute()
#5 /Users/scott/Sites/mmpgamers/admin/includes/classes/dbio/DbIo.php(274): DbIoHandler->importCsvRecord()
#6 /Users/scott/Sites/mmpgamers/admin/dbio_manager.php(242): DbIo->dbioImport()
#7 /Users/scott/Sites/mmpgamers/admin/index.php(11): require('/Users/scott/Si...')
--> PHP Fatal error: 1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SE WHERE p.products_model = 'NSG-FTE' AND f.products_id = p.products_id' at line 1 :: UPDATE zen_products p SE WHERE p.products_model = 'NSG-FTE' AND f.products_id = p.products_id ==> (as called by) /Users/scott/Sites/mmpgamers/admin/includes/classes/dbio/DbIoHandler.php on line 1029 <== in /Users/scott/Sites/mmpgamers/includes/classes/db/mysql/query_factory.php on line 667.

Shoot a copy of the import csv to my direct email; I'll see what's going on in the morning.

Zen Cart version? DbIo version (latest doesn't cut it)?

[swguy]

File Sent - Versions are ZC 1.5.8a and DbIo 2.0.2.