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

[lat9]

I've just submitted v1.6.6 of the Database I/O Manager for the Zen Cart moderators' review and will post back here when it's available for download.

This release contains changes associated with the following GitHub issues:

#184: PHP 8.1+ preparation.
#185: Correcting PHP Fatal error (Uncaught ArgumentCountError) for DbIoProductsHandler.
#186: Add 'v_products_link' (storefront link) to the DbIoProductsHandler.

Now available for download: https://www.zen-cart.com/downloads.php?do=file&id=2091

[shrimp-gumbo-mmmhhh]

Great will test it out!

[g2ktcf]

Is there a comparison of DbIo vs EP4 anywhere? I tried searching and did not find anything significant.

[lat9]

Is there a comparison of DbIo vs EP4 anywhere? I tried searching and did not find anything significant.

There some information in the DbIo's readme: https://vinosdefrutastropicales.com/...io/readme.html

Update: Look specifically in the Customization tab.

[shrimp-gumbo-mmmhhh]

Hello lat9,

You mentioned that a could change the template to take out unpopulated fields to make the file size smaller..... do I really need to create a template as long as I just take away fields from an existing template?

Thank you!

Shrimp

[lat9]

Hello lat9,

You mentioned that a could change the template to take out unpopulated fields to make the file size smaller..... do I really need to create a template as long as I just take away fields from an existing template?

Thank you!

Shrimp

You don't need to make a special template if you're going to simply remove columns from the import. It's just that having a template that 'supports' the import you're looking to do is a bit of a time-saver.

[kernheimer]

dear guys, i'm sorry if the answer was already given and i overlooked it. can this be installed besides EP without problems?
it looks great, ( i would if possible use it to export my customers and all, to implement in a new shop)
but my dyslectic puts a break on some reading sometimes. ( do my best honestly)
have a good weekend

[lat9]

dear guys, i'm sorry if the answer was already given and i overlooked it. can this be installed besides EP without problems?
it looks great, ( i would if possible use it to export my customers and all, to implement in a new shop)
but my dyslectic puts a break on some reading sometimes. ( do my best honestly)
have a good weekend

DbIo is a totally separate entity from EP and can be safely installed together with EP.

[kernheimer]

DbIo is a totally separate entity from EP and can be safely installed together with EP.

thank you so much for your quick answer! very much appreciated! i'm giving it a go

[strelitzia]

Zen Cart 1.5.7c
PHP Version 7.4.16
MySQL 5.7.32

I'm getting a MySQL error with exports for Manufacturers, ProuctsAttribsbasic, and Products.
For a manufacturers export the log is as follows:

[06-Aug-2021 20:33:34 Europe/Paris] Request URI: /testadmin/index.php?cmd=dbio_manager&action=export, IP address: ::1
#1  trigger_error() called at [/Users/steph/Sites/localhost/homebrew/includes/classes/db/mysql/query_factory.php:170]
#2  queryFactory->show_error() called at [/Users/steph/Sites/localhost/homebrew/includes/classes/db/mysql/query_factory.php:142]
#3  queryFactory->set_error() called at [/Users/steph/Sites/localhost/homebrew/includes/classes/db/mysql/query_factory.php:269]
#4  queryFactory->Execute() called at [/Users/steph/Sites/localhost/homebrew/testadmin/includes/classes/dbio/DbIo.php:167]
#5  DbIo->dbioExport() called at [/Users/steph/Sites/localhost/homebrew/testadmin/dbio_manager.php:156]
#6  require(/Users/steph/Sites/localhost/homebrew/testadmin/dbio_manager.php) called at [/Users/steph/Sites/localhost/homebrew/testadmin/index.php:11]
--> 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 'ORDER BY m.manufacturers_id ASC' at line 1 :: SELECT m.manufacturers_id, m.manufacturers_name, m.manufacturers_image, m.date_added, m.last_modified FROM zen_manufacturers AS m, zen_manufacturers_info AS mi WHERE m.manufacturers_id = mi.manufacturers_id AND mi.languages_id =  ORDER BY m.manufacturers_id ASC  ==> (as called by) /Users/steph/Sites/localhost/homebrew/testadmin/includes/classes/dbio/DbIo.php on line 167 <== in /Users/steph/Sites/localhost/homebrew/includes/classes/db/mysql/query_factory.php on line 170.

Note the lack of a languages_id just before the ORDER BY.

I went to DbioManufacturersHandler.php and set some error_log outputs after

$export_language = ($this->export_language == 'all') ? $this->languages[$this->first_language_code] : $this->languages[$this->export_language];

error_log("export language: ".$this->export_language);
error_log("first_language_code: ".$this->languages[$this->first_language_code]);
error_log("this export langueage: ".$this->languages[$this->export_language]);
error_log("export language var: ".$export_language);

the results of which are

[06-Aug-2021 20:33:34 Europe/Paris] export language: all
[06-Aug-2021 20:33:34 Europe/Paris] first_language_code: 
[06-Aug-2021 20:33:34 Europe/Paris] this export langueage: 
[06-Aug-2021 20:33:34 Europe/Paris] export language var:

The error logs for ProuctsAttribsbasic and Products also show a missing language_id in the query.

Any suggestions on the cause, and a solution to this issue?