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

[lat9]

Hi, thanks for your responses.

More tests were done but there are still some issues.
This module prioritises products_model as the primary key during import and ignore products_id by creating a new one. Is it possible to have an option in the configuration for choosing the import/export primary key: products_id or products_model, like in EP4? The main reason is that products_id always has an automatic unique number no matter what; whereas products_model has to be manually made unique but some suppliers use the same model numbers for products with different colors.

Although command ADD may work for adding products with the same products_model, it adds the linked product as a new product instead. Turning it on and off in configuration can be confusing and inconvenient.

Is there a way to bulk create categories before importing products?

I'm not seeing that behavior in my testing.

If I take an existing product, I can change its model. If your site's configured to allow duplicate models, then using a dbio_command of ADD (with a products_id of 0) will create a new product with the same model number.

There is not currently a means to export and import categories separately.

[chuckrey]

Using zc 2.1.0 php 8.2.0, ZCA Bootstrap

This is the 2nd site I have installed DBIO, the first works great, no issues and all installed without a problem. I just recently installed via Github the DBIO plugin to a new site and it installed without issues and all imports worked initially. This is where I have a problem. It was either during the import of data for the Attributes Basic or Attributes Raw that created a 500 error on the website. The error is related to the constant DIR_FS_ADMIN as undefined in the file: /home/xxxx/public_html/includes/extra_datafiles/dbio_file_database_names_admin.php..

The log is as follows:
[28-May-2025 15:00:10 UTC] PHP Fatal error: Uncaught Error: Undefined constant "DIR_FS_ADMIN" in /home/xxxxxx/public_html/includes/extra_datafiles/dbio_file_database_names_admin.php:6
Stack trace:
#0 /home/xxxxxx/public_html/includes/init_includes/init_file_db_names.php(54): include()
#1 /home/xxxxxx/public_html/includes/application_top.php(292): require('/home/xxxxxx/...')
#2 /home/xxxxxx/public_html/index.php(25): require('/home/xxxxxx/...')
#3 {main}
thrown in /home/xxxxxx/public_html/includes/extra_datafiles/dbio_file_database_names_admin.php on line 6

[28-May-2025 15:00:10 UTC] Request URI: /index.php?main_page=index, IP address: xx.xx.xxx.xxxx
--> PHP Fatal error: Uncaught Error: Undefined constant "DIR_FS_ADMIN" in /home/xxxxxx/public_html/includes/extra_datafiles/dbio_file_database_names_admin.php:6
Stack trace:
#0 /home/xxxxxx/public_html/includes/init_includes/init_file_db_names.php(54): include()
#1 /home/xxxxxx/public_html/includes/application_top.php(292): require('/home/xxxxxx/...')
#2 /home/xxxxxx/public_html/index.php(25): require('/home/xxxxxx/...')
#3 {main}
thrown in /home/xxxxxx/public_html/includes/extra_datafiles/dbio_file_database_names_admin.php on line 6.

[28-May-2025 15:00:10 UTC] Request URI: /index.php?main_page=index, IP address: xx.xx.xxx.xxx
--> PHP Fatal error: Uncaught Error: Undefined constant "DIR_FS_ADMIN" in /home/xxxxxx/public_html/includes/extra_datafiles/dbio_file_database_names_admin.php:6
Stack trace:
#0 /home/xxxxxx/public_html/includes/init_includes/init_file_db_names.php(54): include()
#1 /home/xxxxxx/public_html/includes/application_top.php(292): require('/home/xxxxxx/...')
#2 /home/xxxxxx/public_html/index.php(25): require('/home/xxxxxx/...')
#3 {main}
thrown in /home/xxxxxx/public_html/includes/extra_datafiles/dbio_file_database_names_admin.php on line 6.

Any idea what could have caused the 500 error when importing, more specifically that would trigger the constant error?

Thanks so much !

[lat9]

Using zc 2.1.0 php 8.2.0, ZCA Bootstrap

This is the 2nd site I have installed DBIO, the first works great, no issues and all installed without a problem. I just recently installed via Github the DBIO plugin to a new site and it installed without issues and all imports worked initially. This is where I have a problem. It was either during the import of data for the Attributes Basic or Attributes Raw that created a 500 error on the website. The error is related to the constant DIR_FS_ADMIN as undefined in the file: /home/xxxx/public_html/includes/extra_datafiles/dbio_file_database_names_admin.php..

The log is as follows:
[28-May-2025 15:00:10 UTC] PHP Fatal error: Uncaught Error: Undefined constant "DIR_FS_ADMIN" in /home/xxxxxx/public_html/includes/extra_datafiles/dbio_file_database_names_admin.php:6
Stack trace:
#0 /home/xxxxxx/public_html/includes/init_includes/init_file_db_names.php(54): include()
#1 /home/xxxxxx/public_html/includes/application_top.php(292): require('/home/xxxxxx/...')
#2 /home/xxxxxx/public_html/index.php(25): require('/home/xxxxxx/...')
#3 {main}
thrown in /home/xxxxxx/public_html/includes/extra_datafiles/dbio_file_database_names_admin.php on line 6

[28-May-2025 15:00:10 UTC] Request URI: /index.php?main_page=index, IP address: xx.xx.xxx.xxxx
--> PHP Fatal error: Uncaught Error: Undefined constant "DIR_FS_ADMIN" in /home/xxxxxx/public_html/includes/extra_datafiles/dbio_file_database_names_admin.php:6
Stack trace:
#0 /home/xxxxxx/public_html/includes/init_includes/init_file_db_names.php(54): include()
#1 /home/xxxxxx/public_html/includes/application_top.php(292): require('/home/xxxxxx/...')
#2 /home/xxxxxx/public_html/index.php(25): require('/home/xxxxxx/...')
#3 {main}
thrown in /home/xxxxxx/public_html/includes/extra_datafiles/dbio_file_database_names_admin.php on line 6.

[28-May-2025 15:00:10 UTC] Request URI: /index.php?main_page=index, IP address: xx.xx.xxx.xxx
--> PHP Fatal error: Uncaught Error: Undefined constant "DIR_FS_ADMIN" in /home/xxxxxx/public_html/includes/extra_datafiles/dbio_file_database_names_admin.php:6
Stack trace:
#0 /home/xxxxxx/public_html/includes/init_includes/init_file_db_names.php(54): include()
#1 /home/xxxxxx/public_html/includes/application_top.php(292): require('/home/xxxxxx/...')
#2 /home/xxxxxx/public_html/index.php(25): require('/home/xxxxxx/...')
#3 {main}
thrown in /home/xxxxxx/public_html/includes/extra_datafiles/dbio_file_database_names_admin.php on line 6.

Any idea what could have caused the 500 error when importing, more specifically that would trigger the constant error?

Thanks so much !

You've somehow installed the admin file dbio_file_database_names_admin.php on the storefront. There is no storefront component to DbIo; all its files are intended to be copied to your Zen Cart admin directory.

[chuckrey]

You've somehow installed the admin file dbio_file_database_names_admin.php on the storefront. There is no storefront component to DbIo; all its files are intended to be copied to your Zen Cart admin directory.

Okay, I will remove those files from the directory. Should it resolve or will I need to reinstate backup and reinstall?

[lat9]

Okay, I will remove those files from the directory. Should it resolve or will I need to reinstate backup and reinstall?

Since I'm not exactly sure what you've done, I'll suggest doing a file-compare against all the DbIo files present in the distribution zip's YOUR_ADMIN/includes directory to ensure that they, too, haven't been copied to the storefront.

Then, you'll need to see if those files were copied to your admin's /includes subdirectory.

[chuckrey]

Since I'm not exactly sure what you've done, I'll suggest doing a file-compare against all the DbIo files present in the distribution zip's YOUR_ADMIN/includes directory to ensure that they, too, haven't been copied to the storefront.

Then, you'll need to see if those files were copied to your admin's /includes subdirectory.

Will do.
Thanks for the help