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

[lat9]

You're welcome, @OopsIbrickedIT, I'm glad to have helped.

[lat9]

I've just submitted v1.5.3 of the DbIo Manager to the Zen Cart plugins for review and will post back here when it's available for download (https://www.zen-cart.com/downloads.php?do=file&id=2091).

This release contains corrections for the following GitHub issues:


#127: Auto-create categories error on more recent/strict versions of MySQL.
#128: Fatal error adding a product
#129: Incorrect detection of invalid integer fields.
#130: Unwanted PHP Notice when creating a product.

[howb]

Great plugin and will be very useful, but I'm not sure if there is a problem with plugin or my DB. Maybe I'm doing something wrong, but when I am trying to add new items to ProductOption, I make all new options have "v_products_options_id" equal to "0". I upload CSV and it says import is successful but when I check the Option Name Manager, none are entered except for the last entry, which in Option Name Manager has ID = 0.

[lat9]

I've just submitted v1.5.3 of the DbIo Manager to the Zen Cart plugins for review and will post back here when it's available for download (https://www.zen-cart.com/downloads.php?do=file&id=2091).

This release contains corrections for the following GitHub issues:


#127: Auto-create categories error on more recent/strict versions of MySQL.
#128: Fatal error adding a product
#129: Incorrect detection of invalid integer fields.
#130: Unwanted PHP Notice when creating a product.

Now available for download.

[lat9]

Great plugin and will be very useful, but I'm not sure if there is a problem with plugin or my DB. Maybe I'm doing something wrong, but when I am trying to add new items to ProductOption, I make all new options have "v_products_options_id" equal to "0". I upload CSV and it says import is successful but when I check the Option Name Manager, none are entered except for the last entry, which in Option Name Manager has ID = 0.

I've created this issue (https://github.com/lat9/dbio/issues/131) to track the change required.

[lat9]

I've created this issue (https://github.com/lat9/dbio/issues/131) to track the change required.

Noting that a similar issue is associated with the ProductsOptionsValues import. Part of the underlying cause was a subtle coding change introduced in zc156 where a default (id = 0) entry was added to each of the products_options and products_options_values tables.

[lat9]

I've just submitted v1.5.4 for review by the plugin moderators. This release contains the changes associated with the following GitHub issues:

#122: Update ProductsAttribsRaw to support a "REMOVE" command.
#131: ProductsOptions/ProductsOptionsValues: Insert error.
#132: Correct various PHP "Notice" issues.
#133: ProductsAttribsRaw throws error for strict MySQL installations.
#134: ProductsDiscountQuantity throws error for strict MySQL installations.


I'll post back once it's available for download.

[lat9]

I've just submitted v1.5.4 for review by the plugin moderators. This release contains the changes associated with the following GitHub issues:

#122: Update ProductsAttribsRaw to support a "REMOVE" command.
#131: ProductsOptions/ProductsOptionsValues: Insert error.
#132: Correct various PHP "Notice" issues.
#133: ProductsAttribsRaw throws error for strict MySQL installations.
#134: ProductsDiscountQuantity throws error for strict MySQL installations.


I'll post back once it's available for download.

That was lightning fast! Now available for download.

[howb]

That was lightning fast! Now available for download.

Thanks for fixing the issues! ProductOptions working well now. It's a great replacement for Apsona.

I'm trying to change a products Master category? Is this possible? When I change category in Products Handler it makes it a linked product?

Thanks again for all your help

[lat9]

@howb, I've created this issue (https://github.com/lat9/dbio/issues/135) on the DbIo GitHub repository to track the associated change.