Question mysql 8.0.29 warnings

[madness85]

Hi,

I'm getting warnings from mysql on importing database and thought I'd share the output with you.


Warning (Code 1831): Duplicate index 'user_id_last_update' defined on the table 'mydadata.xf_dbtech_shop_item'. This is deprecated and will be disallowed in a future release.
Warning (Code 1831): Duplicate index 'lottery_user_id' defined on the table 'mydadata.xf_dbtech_shop_lottery_ticket'. This is deprecated and will be disallowed in a future release.
Warning (Code 1831): Duplicate index 'lottery_id_draw_date' defined on the table 'mydadata.xf_dbtech_shop_lottery_ticket'. This is deprecated and will be disallowed in a future release.
Warning (Code 1831): Duplicate index 'item_id' defined on the table 'mydadata.xf_dbtech_shop_purchase'. This is deprecated and will be disallowed in a future release.
Warning (Code 1831): Duplicate index 'user_id' defined on the table 'mydadata.xf_dbtech_shop_purchase'. This is deprecated and will be disallowed in a future release.
Warning (Code 1831): Duplicate index 'buyer_user_id' defined on the table 'mydadata.xf_dbtech_shop_purchase'. This is deprecated and will be disallowed in a future release.
Warning (Code 1831): Duplicate index 'creator_user_id' defined on the table 'mydadata.xf_dbtech_shop_trade'. This is deprecated and will be disallowed in a future release.
Warning (Code 1831): Duplicate index 'recipient_user_id' defined on the table 'mydadata.xf_dbtech_shop_trade'. This is deprecated and will be disallowed in a future release.

 

[Fillip H.]

There are no duplicate indexes in the core add-on. You can remove these indexes manually using a database management app like phpMyAdmin.

 

[madness85]

There are no duplicate indexes in the core add-on. You can remove these indexes manually using a database management app like phpMyAdmin.

Done. Thanks buddy.

 

[DragonByte Technologies]

Hello @madness85,

We hope your ticket regarding DragonByte Shop has been addressed to your satisfaction. This ticket has now been scheduled to be closed.

If your ticket has not been resolved, you can reply to this thread at any point in the next 7 days in order to reopen the ticket, afterwards this thread will be closed.

Please do not reply to this thread if your ticket has been resolved.

Thank you.


- DragonByte Technologies, Ltd.

 

[DragonByte Technologies]

Hello @madness85,

As we have not heard back from you, your ticket regarding DragonByte Shop has now been closed.

If your ticket has not been resolved, please feel free to start a new support ticket and link back to this ticket.

If you have time, please leave a review on XenForo.com's Resource Manager.

Thank you.


- DragonByte Technologies, Ltd.