I know you say it's not a bug but.......

[Bside2234]

I've done 3 fresh installs of TB now and I'm getting the same result every time. This last time I did it in a brand new folder and checked install the demo stuff. The ONLY thing I've done is change the stock on one candle combo to 0 and it messes all the stock up just like I've been saying.

Am I doing something wrong? I've been using Prestashop since 1.4 and run/maintain the shop myself so I kind of know what I'm doing but maybe there is something/some setting in TB that I need to change?

Here is the Demo/Test shop product I changed the stock quantity: http://griffineffects.com/shop/gifts/candle#/1-size-12_oz/22-scent-honey

The pic below shows I just changed the quantity of Candle-Size-12oz. Scent - Honey to 0

The below picture shows 12oz Honey has a quantity of 1799 (quantity is mixed up with 24oz/Puffin) and should be 0 and the Add to cart button is shown.

Now the below picture shows 12oz/Puffin has 0 quantity and the Add to cart button is gone. This is mixed up with 12oz/Honey.

So all the quantities are mixed up.

Honey/12oz shows 1799 items when it should be 0
Honey/16oz shows 899 items when it should be 900
Honey/24oz shows 3600 items when it should be 900
Puffin/12oz shows 0 items when it should be 899
Puffin/16oz shows 900 items when it should be 3600
Puffin/24oz shows 900 items when it should be 1799

I've now done this 4 time total (1 with my own products and 3 with the demo products). Brand new database ever time. I've use Filezilla 2 times and by CPanel 2 times to upload the files. Same result every time.

If this isn't a bug, what is going on? Brand new store. Nothing change but one quantity to 0 on demo item and stock gets all messed up.
 

[haylau]

Hi

We use attributes extensively and it works fine for us. Could you DM back office log in details and I will compare every setting to ours to see if I can spot anything?

[Bside2234]

42 minutes ago, haylau said:

Hi

We use attributes extensively and it works fine for us. Could you DM back office log in details and I will compare every setting to ours to see if I can spot anything?

Sent you the info

[haylau]

Well, that is weird. It is a very real affect. And I can't reproduce it on my installation.Though we do have some modules / code changes installed so perhaps that is having an effect.

I am packing for my holidays now, so nothing more I can do for now. 

I will tag @datakick to have another look (perhaps he can log into your installation also)

I set up a new product AND new attributes and the affect is real. I don;t think it is reading in reverse but I did notice that everything works fine until you change one of the stock quantities to zero. At that moment I think the default combination gets corropted

See here, I have set the default combinations to "10"

As soon as you change a quantity to zero the defaul combination on the quantity tab changes, but stays the same on the combinations tab

 

So it looks like the combinations tab thinks the default is different to the quantity tab. Then there is no way back, it just gets worse with every change. Weird

Good luck, hope someone can help further

[Bside2234]

5 hours ago, haylau said:

Well, that is weird. It is a very real affect. And I can't reproduce it on my installation.Though we do have some modules / code changes installed so perhaps that is having an effect.

I am packing for my holidays now, so nothing more I can do for now. 

I will tag @datakick to have another look (perhaps he can log into your installation also)

I set up a new product AND new attributes and the affect is real. I don;t think it is reading in reverse but I did notice that everything works fine until you change one of the stock quantities to zero. At that moment I think the default combination gets corropted

See here, I have set the default combinations to "10"

As soon as you change a quantity to zero the defaul combination on the quantity tab changes, but stays the same on the combinations tab

 

So it looks like the combinations tab thinks the default is different to the quantity tab. Then there is no way back, it just gets worse with every change. Weird

Good luck, hope someone can help further

Thanks again for taking a look. Here's other things I've tried since. Changing PHP version to 7.0 and 7.1 and reinstalling TB (didn't fix it). Created a subdomain for TB instead of just creating a folder to put it in in my main domain (did fix it). No matter what I do, fresh installs, download TB every time (not using the same download), I get the same results. I'm at a loss. Prestashop 1.6 works just fine.

I think I may try doing a fresh install of Prestahop 1.6 and use the PrestaShop to thirty bees Migrator module just to see what happens.

Edited August 17, 2021 by Bside2234

[Bside2234]

Here's a weird little twist. Not a good thing though.

Installed Prestashop 1.6.1.24 (the latest version of 1.6) and the same thing is happening. Stock is all messed up. It was even messed up on the demo products that it installed and I didn't touch.

       

Thinking maybe this may be a issue with the newer versions of 1.6. I installed the same version (1.6.1.6) that I'm currently using and is working just fine. It's messed up with this too!

        

I'm not sure what to make of this. I"m thinking it may be a issue with my web hosting now or some setting either in PHP or somewhere that isn't right. I am up to switching to a new webhost and I've been looking at Cloudways but it seems overly complicated and the email service options leave me with a lot of questions.

[wakabayashi]

I don't think it makes any sense, to solve this by switching the server. I would check all stock settings and deactivate all caches...

But honestly I would guess, that the problem is in javascript/ajax... There are some important questions:

• which combination is the standard combination?
• are you using multistore?

Edited August 20, 2021 by wakabayashi

[30knees]

Is this only with backend changes or also if someone buys something and the stock goes to 0?

Re Cloudways: I'm with them, in case you have any questions.

[Bside2234]

7 hours ago, wakabayashi said:

I don't think it makes any sense, to solve this by switching the server. I would check all stock settings and deactivate all caches...

But honestly I would guess, that the problem is in javascript/ajax... There are some important questions:

• which combination is the standard combination?
• are you using multistore?

I agree that changing servers may not be the issue and not make much sense but I really can't explain why it's happening on fresh installs with the demo products over and over again and nobody else seems to have this problem. Logic is starting to point towards my server or some setting my server/cpanel/database/etc. defaults to isn't right and I don't know what it is.

I'm not sure what you mean by "which combination is standard combination".

No, I don't use multistore. I run my store pretty "vanilla". Stock theme with a few CSS changes and not a lot of added modules. This is even happening on fresh installls using the demo products though without me changing anything other than one stock quantity to 0 and then it all gets messed up.

Caches cleared and all turned off and it's still the same. I didn't change any other settings at all in this install. Everything is as it is when installed. I just added one test product. That's all I've done.

Edited August 20, 2021 by Bside2234

[Bside2234]

4 hours ago, 30knees said:

Is this only with backend changes or also if someone buys something and the stock goes to 0?

Re Cloudways: I'm with them, in case you have any questions.

I honestly don't know. I'd have to check. Stock is messed up right from the beginning. It would be kind of interesting to see if someone bought something which quantity for which combination goes down but that still leaves the initial stock when the product is created messed up. So I guess to answer your question better. I've only noticed it during product creation/backend changes and I don't know if a product goes to 0 it affects anything

because it's already messed up on the backend when it's created regardless if the stock is 0 or not. As you can see in the pictures above, stock doesn't have to be 0 for it to be messed up.

RE: Cloudways. I've been looking into it and I think it's more than I need and way to complicated for what I need. I have a few others picked out that I think will work for me if I go this route. I really don't have much to lose by switching hosting. I found a few that look better/faster than what I have for about the same cost. I'm not giving up yet though. Just being trying to be prepared.

EDIT:

RE: It would be kind of interesting to see if someone bought something which quantity for which combination goes down but that still leaves the initial stock when the product is created messed up.

Using the previous images I posted, If I order Value 1 which has a quantity set to 1, the actual quantity that is reduced by the order is of Value 2 which is reduced from 2 down to 1 so it's not even taking the correct stock/quantity when there's a order.

Edited August 20, 2021 by Bside2234

[Bside2234]

Had a thought...could I be possibly setting up the database wrong? I'm really not doing anything other than selecting to add a database and choosing a name or password but is there some setting(s) in the database I should be looking at? I'm just trying to think of things that are different from everyone else's install and why mine would be any different.

I also enabled Advanced Stock Management and edited the product to use this and this didn't fix anything either.

When I checked the Configuration tab in the back office it saw this so I'm looking into this:

List of changed files

Changed/missing/obsolete files have been detected.

Obsolete files (12)

• vendor/bin/generate-defuse-key
• vendor/bin/update-versions
• vendor/bin/semver
• admin/backups
• admin/autoupgrade
• admin/CoreUpdaterBackup-2021-08-06--07-19-05
• admin/themes
• admin/CoreUpdaterBackup-2021-08-17--18-26-27
• admin/import
• admin/export
• admin/tabs
• admin/filemanager

Edited August 20, 2021 by Bside2234

[Bside2234]

Do you all have this stuff in your Core Updater/Database Schema Tab?

 

Database schema

This tool helps you discover and fix problems with database schema

List of differences

Severity	Flags	Description	Actions
critical		Column tb_referrer_shop.cache_pages has data type int instead of int(11)

critical		Column tb_referrer_shop.cache_visits has data type int instead of int(11)
critical		Column tb_referrer_shop.cache_registrations has data type int instead of int(11)
critical		Column tb_referrer_shop.cache_orders has data type int instead of int(11)
critical		Column tb_required_field.id_required_field has data type int instead of int(11)
critical		Column tb_request_sql.id_request_sql has data type int instead of int(11)
critical		Column tb_referrer_shop.cache_visitors has data type int instead of int(11)
critical		Column tb_product_shop.text_fields has data type tinyint instead of tinyint(4)
critical		Column tb_product_country_tax.id_country has data type int instead of int(11)
critical		Column tb_product_country_tax.id_product has data type int instead of int(11)
critical		Column tb_product_country_tax.id_tax has data type int instead of int(11)
critical		Column tb_country.call_prefix has data type int instead of int(10)
critical		Column tb_product_shop.uploadable_files has data type tinyint instead of tinyint(4)
critical		Column tb_product_shop.customizable has data type tinyint instead of tinyint(2)
critical		Column tb_risk.percent has data type tinyint instead of tinyint(3)
critical		Column tb_scene_products.x_axis has data type int instead of int(4)
critical		Column tb_tab_module_preference.id_tab_module_preference has data type int instead of int(11)
critical		Column tb_tab.id_parent has data type int instead of int(11)
critical		Column tb_tab_module_preference.id_employee has data type int instead of int(11)
critical		Column tb_tab_module_preference.id_tab has data type int instead of int(11)
critical		Column tb_carrier.max_depth has data type int instead of int(10)
critical		Column tb_carrier.grade has data type int instead of int(10)
critical		Column tb_cart_rule.reduction_product has data type int instead of int(10)
critical		Column tb_stock_available.quantity has data type int instead of int(10)
critical		Column tb_scene_products.zone_width has data type int instead of int(3)
critical		Column tb_scene_products.y_axis has data type int instead of int(4)
critical		Column tb_scene_products.zone_height has data type int instead of int(3)
critical		Column tb_specific_price_priority.id_specific_price_priority has data type int instead of int(11)
critical		Column tb_state.tax_behavior has data type smallint instead of smallint(1)
critical		Column tb_specific_price_priority.id_product has data type int instead of int(11)
critical		Column tb_product_attribute.quantity has data type int instead of int(10)
critical		Column tb_customer_message.id_customer_thread has data type int instead of int(11)
critical		Column tb_order_detail.product_quantity_in_stock has data type int instead of int(10)
critical		Column tb_import_match.id_import_match has data type int instead of int(10)
critical		Column tb_order_detail_tax.id_order_detail has data type int instead of int(11)
critical		Column tb_order_detail_tax.id_tax has data type int instead of int(11)
critical		Column tb_order_invoice.number has data type int instead of int(11)
critical		Column tb_order_invoice.id_order has data type int instead of int(11)
critical		Column tb_import_match.skip has data type int instead of int(2)
critical		Column tb_order_detail.id_order_invoice has data type int instead of int(11)
critical		Column tb_module_currency.id_currency has data type int instead of int(11)
critical		Column tb_module_carrier.id_reference has data type int instead of int(11)
critical		Column tb_module_preference.id_module_preference has data type int instead of int(11)
critical		Column tb_module_preference.id_employee has data type int instead of int(11)
critical		Column tb_log.error_code has data type int instead of int(11)
critical		Column tb_order_carrier.id_order_carrier has data type int instead of int(11)
critical		Column tb_order_invoice.delivery_number has data type int instead of int(11)
critical		Column tb_order_invoice_tax.id_order_invoice has data type int instead of int(11)
critical		Column tb_product.quantity has data type int instead of int(10)
critical		Column tb_customization.id_product has data type int instead of int(10)
critical		Column tb_product.customizable has data type tinyint instead of tinyint(2)
critical		Column tb_product.uploadable_files has data type tinyint instead of tinyint(4)
critical		Column tb_customer_message.private has data type tinyint instead of tinyint(4)
critical		Column tb_product.text_fields has data type tinyint instead of tinyint(4)
critical		Column tb_customization.quantity has data type int instead of int(10)
critical		Column tb_customization.quantity_refunded has data type int instead of int(11)
critical		Column tb_order_payment.id_order_payment has data type int instead of int(11)
critical		Column tb_order_invoice_tax.id_tax has data type int instead of int(11)
critical		Column tb_group.price_display_method has data type tinyint instead of tinyint(4)
critical		Column tb_gender.id_gender has data type int instead of int(11)
critical		Column tb_customization.quantity_returned has data type int instead of int(11)
critical		Column tb_customized_data.index has data type int instead of int(3)
critical		Column tb_carrier.max_height has data type int instead of int(10)
critical		Column tb_connections.ip_address has data type bigint instead of bigint(20)
critical		Column tb_tax_rule.id_country has data type int instead of int(11)
critical		Column tb_theme_meta.id_theme has data type int instead of int(11)
critical		Column tb_tax_rule.id_tax_rules_group has data type int instead of int(11)
critical		Column tb_tax_rule.id_tax_rule has data type int instead of int(11)
critical		Column tb_access.edit has data type int instead of int(11)
critical		Column tb_webservice_permission.id_webservice_account has data type int instead of int(11)
critical		Column tb_tax_rules_group.active has data type int instead of int(11)
critical		Column tb_access.delete has data type int instead of int(11)
critical		Column tb_theme.id_theme has data type int instead of int(11)
critical		Column tb_tax_rule.id_state has data type int instead of int(11)
critical		Column tb_theme_meta.id_theme_meta has data type int instead of int(11)
critical		Column tb_tax_rule.id_tax has data type int instead of int(11)
critical		Column tb_tax_rules_group.id_tax_rules_group has data type int instead of int(11)
critical		Column tb_tax_rule.behavior has data type int instead of int(11)
critical		Column tb_webservice_permission.id_webservice_permission has data type int instead of int(11)
critical		Column tb_access.add has data type int instead of int(11)
critical		Column tb_webservice_account.is_module has data type tinyint instead of tinyint(2)
critical		Column tb_carrier.shipping_method has data type int instead of int(2)
critical		Column tb_webservice_account.active has data type tinyint instead of tinyint(2)
critical		Column tb_webservice_account.id_webservice_account has data type int instead of int(11)
critical		Column tb_carrier.max_width has data type int instead of int(10)
critical		Column tb_access.view has data type int instead of int(11)
critical	dangerous	Column tb_page.id_page has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_pack.quantity has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_page.id_object has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_pack.id_product_attribute_item has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_pack.id_product_item has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_page_viewed.id_page has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_page_type.id_page_type has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_page_cache.id_country has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_page_cache.id_language has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_page_cache.id_shop has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_page.id_page_type has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_page_cache.id_entity has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_page_cache.id_currency has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_orders.gift has data type tinyint unsigned instead of tinyint(1) unsigned
critical	dangerous	Column tb_orders.id_shop_group has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_orders.id_shop has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_orders.id_carrier has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_orders.id_lang has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_orders.id_order has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_order_state_lang.id_lang has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_order_state.pdf_delivery has data type tinyint unsigned instead of tinyint(1) unsigned
critical	dangerous	Column tb_order_state.deleted has data type tinyint unsigned instead of tinyint(1) unsigned
critical	dangerous	Column tb_order_state.active has data type tinyint unsigned instead of tinyint(1) unsigned
critical	dangerous	Column tb_order_state_lang.id_order_state has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_orders.id_customer has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_orders.id_cart has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_page_viewed.id_shop_group has data type int unsigned instead of int(10) unsigned
critical	dangerous	Column tb_orders.invoice_number has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_orders.delivery_number has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_orders.valid has data type int unsigned instead of int(1) unsigned
critical	dangerous	Column tb_orders.recyclable has data type tinyint unsigned instead of tinyint(1) unsigned
critical	dangerous	Column tb_orders.current_state has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_orders.id_currency has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_orders.id_address_delivery has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_orders.id_address_invoice has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_pack.id_product_pack has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_product.id_supplier has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_product_attribute.id_product has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_theme_specific.id_object has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_theme_specific.entity has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_product_attribute.default_on has data type tinyint unsigned instead of tinyint(1) unsigned
critical	dangerous	Column tb_timezone.id_timezone has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_product_attribute.id_product_attribute has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_product.cache_default_attribute has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_product.pack_stock_type has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_product_attachment.id_product has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_product_attachment.id_attachment has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_product_attribute.minimal_quantity has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_product_attribute_combination.id_attribute has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_product_attribute_shop.default_on has data type tinyint unsigned instead of tinyint(1) unsigned
critical	dangerous	Column tb_product_attribute_shop.minimal_quantity has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_product_carrier.id_product has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_product_carrier.id_carrier_reference has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_product_attribute_shop.id_shop has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_product_attribute_shop.id_product_attribute has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_product_attribute_combination.id_product_attribute has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_product_attribute_image.id_product_attribute has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_product_attribute_image.id_image has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_product_attribute_shop.id_product has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_product.id_product_redirected has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_product.active has data type tinyint unsigned instead of tinyint(1) unsigned
critical	dangerous	Column tb_product.id_category_default has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_product.id_shop_default has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_product.id_tax_rules_group has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_product.on_sale has data type tinyint unsigned instead of tinyint(1) unsigned
critical	dangerous	Column tb_product.id_manufacturer has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_order_state.pdf_invoice has data type tinyint unsigned instead of tinyint(1) unsigned
critical	dangerous	Column tb_page_viewed.id_date_range has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_warehouse_product_location.id_product has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_page_viewed.counter has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_product.id_product has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_product.online_only has data type tinyint unsigned instead of tinyint(1) unsigned
critical	dangerous	Column tb_warehouse_product_location.id_warehouse_product_location has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_product.out_of_stock has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_warehouse.id_address has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_warehouse.id_currency has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_warehouse.id_warehouse has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_product.minimal_quantity has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_warehouse.id_employee has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_warehouse_carrier.id_warehouse has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_warehouse_carrier.id_carrier has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_warehouse.deleted has data type tinyint unsigned instead of tinyint(1) unsigned
critical	dangerous	Column tb_page_viewed.id_shop has data type int unsigned instead of int(10) unsigned
critical	dangerous	Column tb_order_state.unremovable has data type tinyint unsigned instead of tinyint(1) unsigned
critical	dangerous	Column tb_order_detail.id_order has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_zone.active has data type tinyint unsigned instead of tinyint(1) unsigned
critical	dangerous	Column tb_order_detail.id_warehouse has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_order_detail.id_shop has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_order_detail.id_order_detail has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_zone_shop.id_zone has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_order_cart_rule.id_order_cart_rule has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_order_cart_rule.id_order has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_order_cart_rule.id_cart_rule has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_order_cart_rule.id_order_invoice has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_access.id_profile has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_order_detail.product_attribute_id has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_order_detail.tax_computation_method has data type tinyint unsigned instead of tinyint(1) unsigned
critical	dangerous	Column tb_order_detail.download_nb has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_webservice_account_shop.id_shop has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_webservice_account_shop.id_webservice_account has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_order_detail.id_tax_rules_group has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_order_detail.product_quantity_reinjected has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_zone.id_zone has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_order_detail.product_quantity has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_order_detail.product_quantity_refunded has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_order_detail.product_quantity_return has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_order_carrier.id_order_invoice has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_order_carrier.id_carrier has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_module_country.id_module has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_module_country.id_shop has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_module_country.id_country has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_module_currency.id_module has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_zone_shop.id_shop has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_module_carrier.id_shop has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_module.active has data type tinyint unsigned instead of tinyint(1) unsigned
critical	dangerous	Column tb_module_access.id_profile has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_module_access.id_module has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_module_carrier.id_module has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_module_currency.id_shop has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_module_group.id_module has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_modules_perfs.memory_start has data type int unsigned instead of int(10) unsigned
critical	dangerous	Column tb_modules_perfs.memory_end has data type int unsigned instead of int(10) unsigned
critical	dangerous	Column tb_operating_system.id_operating_system has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_order_carrier.id_order has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_modules_perfs.session has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_modules_perfs.id_modules_perfs has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_module_group.id_shop has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_module_group.id_group has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_module_shop.id_module has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_module_shop.id_shop has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_order_history.id_order_history has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_order_history.id_employee has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_order_slip.shipping_cost has data type tinyint unsigned instead of tinyint(3) unsigned
critical	dangerous	Column tb_order_slip.order_slip_type has data type tinyint unsigned instead of tinyint(1) unsigned
critical	dangerous	Column tb_order_slip_detail.id_order_slip has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_order_slip_detail.id_order_detail has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_order_slip.id_order has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_order_slip.id_customer has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_order_return_state.active has data type tinyint unsigned instead of tinyint(1) unsigned
critical	dangerous	Column tb_order_return_state_lang.id_order_return_state has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_order_return_state_lang.id_lang has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_order_slip.id_order_slip has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_order_slip_detail.product_quantity has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_order_slip_detail_tax.id_order_slip_detail has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_order_state.hidden has data type tinyint unsigned instead of tinyint(1) unsigned
critical	dangerous	Column tb_order_state.delivery has data type tinyint unsigned instead of tinyint(1) unsigned
critical	dangerous	Column tb_warehouse_product_location.id_product_attribute has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_order_state.shipped has data type tinyint unsigned instead of tinyint(1) unsigned
critical	dangerous	Column tb_product_carrier.id_shop has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_warehouse_product_location.id_warehouse has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_order_slip_detail_tax.id_tax has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_order_state.id_order_state has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_order_state.invoice has data type tinyint unsigned instead of tinyint(1) unsigned
critical	dangerous	Column tb_order_state.send_email has data type tinyint unsigned instead of tinyint(1) unsigned
critical	dangerous	Column tb_order_return_state.id_order_return_state has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_order_return_detail.product_quantity has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_order_invoice_payment.id_order has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_web_browser.id_web_browser has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_warehouse_shop.id_warehouse has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_order_message.id_order_message has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_order_invoice_payment.id_order_payment has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_order_invoice_payment.id_order_invoice has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_order_history.id_order has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_order_history.id_order_state has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_order_invoice.id_order_invoice has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_order_invoice.shipping_tax_computation_method has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_order_message_lang.id_order_message has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_order_message_lang.id_lang has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_order_return.state has data type tinyint unsigned instead of tinyint(1) unsigned
critical	dangerous	Column tb_order_return_detail.id_order_return has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_order_return_detail.id_order_detail has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_order_return_detail.id_customization has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_order_return.id_order has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_order_return.id_customer has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_warehouse_shop.id_shop has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_order_payment.id_currency has data type int unsigned instead of int(10) unsigned
critical	dangerous	Column tb_order_return.id_order_return has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_order_state.paid has data type tinyint unsigned instead of tinyint(1) unsigned
critical	dangerous	Column tb_product_download.active has data type tinyint unsigned instead of tinyint(1) unsigned
critical	dangerous	Column tb_tax.id_tax has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_stock_available.depends_on_stock has data type tinyint unsigned instead of tinyint(1) unsigned
critical	dangerous	Column tb_stock_available.out_of_stock has data type tinyint unsigned instead of tinyint(1) unsigned
critical	dangerous	Column tb_stock_mvt.id_stock_mvt has data type bigint unsigned instead of bigint(20) unsigned
critical	dangerous	Column tb_stock_available.id_shop_group has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_stock_available.id_shop has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_stock.usable_quantity has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_stock_available.id_stock_available has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_stock_available.id_product has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_stock_available.id_product_attribute has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_stock_mvt.id_stock has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_stock_mvt.id_order has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_stock_mvt_reason.id_stock_mvt_reason has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_stock_mvt_reason.deleted has data type tinyint unsigned instead of tinyint(1) unsigned
critical	dangerous	Column tb_stock_mvt_reason_lang.id_stock_mvt_reason has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_stock_mvt_reason_lang.id_lang has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_stock_mvt.referer has data type bigint unsigned instead of bigint(20) unsigned
critical	dangerous	Column tb_stock_mvt.physical_quantity has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_stock_mvt.id_supply_order has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_stock_mvt.id_stock_mvt_reason has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_tag_count.counter has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_stock_mvt.id_employee has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_stock.physical_quantity has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_stock.id_product_attribute has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_specific_price_rule.id_currency has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_specific_price_rule.id_country has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_specific_price_rule.id_group has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_specific_price_rule.from_quantity has data type mediumint unsigned instead of mediumint(8) unsigned
critical	dangerous	Column tb_specific_price_rule.id_shop has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_specific_price_rule.id_specific_price_rule has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_specific_price.id_product_attribute has data type int unsigned instead of int(10) unsigned
critical	dangerous	Column tb_specific_price.from_quantity has data type mediumint unsigned instead of mediumint(8) unsigned
critical	dangerous	Column tb_tax_lang.id_tax has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_tax.deleted has data type tinyint unsigned instead of tinyint(1) unsigned
critical	dangerous	Column tb_specific_price_rule_condition.id_specific_price_rule_condition has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_specific_price_rule_condition.id_specific_price_rule_condition_group has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_tax.active has data type tinyint unsigned instead of tinyint(1) unsigned
critical	dangerous	Column tb_stock.id_stock has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_stock.id_warehouse has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_stock.id_product has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_state.id_zone has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_state.id_country has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_specific_price_rule_condition_group.id_specific_price_rule_condition_group has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_specific_price_rule_condition_group.id_specific_price_rule has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_state.id_state has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_store.id_store has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_store.id_country has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_supply_order_receipt_history.id_employee has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_supply_order_receipt_history.id_supply_order_state has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_supply_order_receipt_history.quantity has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_supply_order_state.id_supply_order_state has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_supply_order_receipt_history.id_supply_order_detail has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_supply_order_receipt_history.id_supply_order_receipt_history has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_supply_order_history.id_supply_order_history has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_supply_order_history.id_supply_order has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_supply_order_history.id_employee has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_supply_order_history.id_state has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_supply_order_state_lang.id_supply_order_state has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_supply_order_state_lang.id_lang has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_tag_count.id_tag has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_tag_count.id_group has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_tag.id_tag has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_tag.id_lang has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_tag_count.id_lang has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_tab_lang.id_lang has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_tab.id_tab has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_tag_count.id_shop has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_tab.position has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_tab_lang.id_tab has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_supply_order_detail.quantity_received has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_supply_order_detail.quantity_expected has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_supplier_lang.id_lang has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_supplier_shop.id_supplier has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_supplier_shop.id_shop has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_supply_order.id_supply_order has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_supplier_lang.id_supplier has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_supplier.id_supplier has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_store.id_state has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_store.active has data type tinyint unsigned instead of tinyint(1) unsigned
critical	dangerous	Column tb_store_shop.id_store has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_store_shop.id_shop has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_supply_order.id_supplier has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_supply_order.id_lang has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_supply_order_detail.id_supply_order has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_supply_order_detail.id_currency has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_supply_order_detail.id_product has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_supply_order_detail.id_product_attribute has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_supply_order_detail.id_supply_order_detail has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_supply_order.id_ref_currency has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_supply_order.id_warehouse has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_supply_order.id_supply_order_state has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_supply_order.id_currency has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_specific_price.id_customer has data type int unsigned instead of int(10) unsigned
critical	dangerous	Column tb_specific_price.id_group has data type int unsigned instead of int(10) unsigned
critical	dangerous	Column tb_product_supplier.id_product_attribute has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_product_supplier.id_supplier has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_product_supplier.id_currency has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_product_tag.id_product has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_product_supplier.id_product has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_product_supplier.id_product_supplier has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_product_shop.active has data type tinyint unsigned instead of tinyint(1) unsigned
critical	dangerous	Column tb_product_shop.id_product_redirected has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_product_shop.cache_default_attribute has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_product_shop.pack_stock_type has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_product_tag.id_tag has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_module.id_module has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_quick_access_lang.id_lang has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_range_price.id_range_price has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_range_price.id_carrier has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_range_weight.id_range_weight has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_quick_access_lang.id_quick_access has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_quick_access.id_quick_access has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_product_tag.id_lang has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_profile.id_profile has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_profile_lang.id_lang has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_profile_lang.id_profile has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_theme.product_per_page has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_product_shop.minimal_quantity has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_product_download.is_shareable has data type tinyint unsigned instead of tinyint(1) unsigned
critical	dangerous	Column tb_product_group_reduction_cache.id_product has data type int unsigned instead of int(10) unsigned
critical	dangerous	Column tb_product_group_reduction_cache.id_group has data type int unsigned instead of int(10) unsigned
critical	dangerous	Column tb_product_lang.id_product has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_product_download.nb_downloadable has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_product_download.nb_days_accessible has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_theme_specific.id_theme has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_theme_meta.id_meta has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_product_download.id_product_download has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_product_download.id_product has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_product_lang.id_shop has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_product_lang.id_lang has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_product_shop.id_category_default has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_product_shop.id_tax_rules_group has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_product_shop.on_sale has data type tinyint unsigned instead of tinyint(1) unsigned
critical	dangerous	Column tb_product_shop.online_only has data type tinyint unsigned instead of tinyint(1) unsigned
critical	dangerous	Column tb_product_shop.id_shop has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_product_shop.id_product has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_product_sale.id_product has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_product_sale.quantity has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_product_sale.sale_nbr has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_range_weight.id_carrier has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_redis_servers.id_redis_server has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_search_word.id_lang has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_shop.id_shop has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_shop.id_shop_group has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_shop.id_category has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_search_word.id_shop has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_search_word.id_word has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_search_engine.id_search_engine has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_search_index.id_product has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_search_index.id_word has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_search_index.weight has data type smallint unsigned instead of smallint(4) unsigned
critical	dangerous	Column tb_shop.id_theme has data type int unsigned instead of int(1) unsigned
critical	dangerous	Column tb_shop_group.id_shop_group has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_specific_price.id_shop has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_specific_price.id_shop_group has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_specific_price.id_currency has data type int unsigned instead of int(10) unsigned
critical	dangerous	Column tb_specific_price.id_country has data type int unsigned instead of int(10) unsigned
critical	dangerous	Column tb_specific_price.id_product has data type int unsigned instead of int(10) unsigned
critical	dangerous	Column tb_specific_price.id_cart has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_shop_url.id_shop_url has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_shop_url.id_shop has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_specific_price.id_specific_price has data type int unsigned instead of int(10) unsigned
critical	dangerous	Column tb_specific_price.id_specific_price_rule has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_scene_shop.id_shop has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_scene_shop.id_scene has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_referrer_shop.id_shop has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_tax_rules_group_shop.id_shop has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_tax_rules_group_shop.id_tax_rules_group has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_tax_rules_group.deleted has data type tinyint unsigned instead of tinyint(1) unsigned
critical	dangerous	Column tb_referrer_shop.id_referrer has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_referrer_cache.id_referrer has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_redis_servers.port has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_redis_servers.db has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_referrer.id_referrer has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_referrer_cache.id_connections_source has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_risk.id_risk has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_risk_lang.id_risk has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_scene_lang.id_lang has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_scene_products.id_scene has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_scene_products.id_product has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_tax_lang.id_lang has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_scene_lang.id_scene has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_scene_category.id_category has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_risk_lang.id_lang has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_scene.id_scene has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_scene_category.id_scene has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_theme_specific.id_shop has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_order_detail.product_id has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_connections_page.id_connections has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_connections_page.id_page has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_carrier_tax_rules_group_shop.id_shop has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_connections_source.id_connections_source has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_carrier_zone.id_carrier has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_connections.id_page has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_connections.id_shop_group has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_connections.id_shop has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_connections.id_guest has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_carrier_zone.id_zone has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_connections_source.id_connections has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_carrier_tax_rules_group_shop.id_tax_rules_group has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_contact_shop.id_shop has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_country.id_country has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_country.id_zone has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_country.id_currency has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_contact_shop.id_contact has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_contact_lang.id_lang has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_contact.id_contact has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_contact.position has data type tinyint unsigned instead of tinyint(2) unsigned
critical	dangerous	Column tb_carrier_tax_rules_group_shop.id_carrier has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_contact_lang.id_contact has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_connections.id_connections has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_cart.id_cart has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_cart.id_guest has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_cart.id_customer has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_configuration_kpi.id_configuration_kpi has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_cart.id_currency has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_configuration.id_shop has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_configuration.id_shop_group has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_compare_product.id_compare has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_compare_product.id_product has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_cart.recyclable has data type tinyint unsigned instead of tinyint(1) unsigned
critical	dangerous	Column tb_configuration.id_configuration has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_configuration_kpi.id_shop_group has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_configuration_kpi.id_shop has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_cart.id_shop has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_configuration_lang.id_configuration has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_configuration_lang.id_lang has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_cart.id_shop_group has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_cart.id_carrier has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_cart.id_lang has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_cart.id_address_invoice has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_cart.id_address_delivery has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_configuration_kpi_lang.id_configuration_kpi has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_configuration_kpi_lang.id_lang has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_country.active has data type tinyint unsigned instead of tinyint(1) unsigned
critical	dangerous	Column tb_carrier_shop.id_shop has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_carrier.position has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_customer.show_public_prices has data type tinyint unsigned instead of tinyint(1) unsigned
critical	dangerous	Column tb_customer.max_payment_days has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_customer.active has data type tinyint unsigned instead of tinyint(1) unsigned
critical	dangerous	Column tb_customer.optin has data type tinyint unsigned instead of tinyint(1) unsigned
critical	dangerous	Column tb_customer.newsletter has data type tinyint unsigned instead of tinyint(1) unsigned
critical	dangerous	Column tb_customer.id_gender has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_customer.id_default_group has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_customer.id_lang has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_customer.id_risk has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_carrier.need_range has data type tinyint unsigned instead of tinyint(1) unsigned
critical	dangerous	Column tb_carrier.shipping_external has data type tinyint unsigned instead of tinyint(1) unsigned
critical	dangerous	Column tb_customer_thread.id_shop has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_carrier.range_behavior has data type tinyint unsigned instead of tinyint(1) unsigned
critical	dangerous	Column tb_customer_thread.id_lang has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_customer_thread.id_contact has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_customer_thread.id_customer_thread has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_carrier.is_module has data type tinyint unsigned instead of tinyint(1) unsigned
critical	dangerous	Column tb_customer_group.id_group has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_customer_message.id_customer_message has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_customer_message.id_employee has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_carrier.is_free has data type tinyint unsigned instead of tinyint(1) unsigned
critical	dangerous	Column tb_customer.id_shop has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_customer.id_shop_group has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_currency.blank has data type tinyint unsigned instead of tinyint(1) unsigned
critical	dangerous	Column tb_currency.format has data type tinyint unsigned instead of tinyint(1) unsigned
critical	dangerous	Column tb_currency.decimals has data type tinyint unsigned instead of tinyint(1) unsigned
critical	dangerous	Column tb_currency.deleted has data type tinyint unsigned instead of tinyint(1) unsigned
critical	dangerous	Column tb_currency.id_currency has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_country_shop.id_shop has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_country_lang.id_country has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_carrier_shop.id_carrier has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_country_lang.id_lang has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_country_shop.id_country has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_carrier_lang.id_lang has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_carrier_lang.id_shop has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_carrier_group.id_group has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_currency_shop.id_shop has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_carrier_group.id_carrier has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_customer.id_customer has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_currency_shop.id_currency has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_carrier_lang.id_carrier has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_currency.active has data type tinyint unsigned instead of tinyint(1) unsigned
critical	dangerous	Column tb_currency_module.id_currency has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_currency_module.id_module has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_compare.id_customer has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_compare.id_compare has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_category.level_depth has data type tinyint unsigned instead of tinyint(3) unsigned
critical	dangerous	Column tb_category.nleft has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_category.nright has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_cart_rule.cart_rule_restriction has data type tinyint unsigned instead of tinyint(1) unsigned
critical	dangerous	Column tb_category.id_shop_default has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_category.id_parent has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_cart_rule_shop.id_cart_rule has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_cart_rule_shop.id_shop has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_cart_rule.product_restriction has data type tinyint unsigned instead of tinyint(1) unsigned
critical	dangerous	Column tb_category.id_category has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_category.active has data type tinyint unsigned instead of tinyint(1) unsigned
critical	dangerous	Column tb_category.display_from_sub has data type tinyint unsigned instead of tinyint(1) unsigned
critical	dangerous	Column tb_category_lang.id_shop has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_category_lang.id_lang has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_cart_rule.country_restriction has data type tinyint unsigned instead of tinyint(1) unsigned
critical	dangerous	Column tb_category_product.id_category has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_category_lang.id_category has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_category_group.id_group has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_cart_rule.group_restriction has data type tinyint unsigned instead of tinyint(1) unsigned
critical	dangerous	Column tb_cart_rule.carrier_restriction has data type tinyint unsigned instead of tinyint(1) unsigned
critical	dangerous	Column tb_category.position has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_category_group.id_category has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_cart_rule_product_rule_value.id_item has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_cart_rule.shop_restriction has data type tinyint unsigned instead of tinyint(1) unsigned
critical	dangerous	Column tb_cart_rule_combination.id_cart_rule_2 has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_cart_rule_country.id_cart_rule has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_cart_rule_country.id_country has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_cart_rule_group.id_cart_rule has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_cart_rule_combination.id_cart_rule_1 has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_cart_rule.gift_product_attribute has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_cart_rule.active has data type tinyint unsigned instead of tinyint(1) unsigned
critical	dangerous	Column tb_cart_rule.highlight has data type tinyint unsigned instead of tinyint(1) unsigned
critical	dangerous	Column tb_cart_rule_carrier.id_cart_rule has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_cart_rule_carrier.id_carrier has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_cart_rule.gift_product has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_cart_rule_group.id_group has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_cart_rule_product_rule_group.id_cart_rule has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_cart_rule_product_rule_group.quantity has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_cart_rule.reduction_tax has data type tinyint unsigned instead of tinyint(1) unsigned
critical	dangerous	Column tb_cart_rule_product_rule_value.id_product_rule has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_cart_rule.reduction_currency has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_cart_rule_product_rule_group.id_product_rule_group has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_cart_rule_lang.id_cart_rule has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_cart_rule_lang.id_lang has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_cart_rule_product_rule.id_product_rule has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_cart_rule_product_rule.id_product_rule_group has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_category_product.id_product has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_category_product.position has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_cart_product.id_shop has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_cms_lang.id_shop has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_cart_product.id_address_delivery has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_cart_product.id_product has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_cms_lang.id_lang has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_cms_lang.id_cms has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_cart_product.id_product_attribute has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_cms_category_lang.id_shop has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_cms_category_shop.id_cms_category has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_cms_category_shop.id_shop has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_cms_role.id_cms_role has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_cms_role.id_cms has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_cart.allow_seperated_package has data type tinyint unsigned instead of tinyint(1) unsigned
critical	dangerous	Column tb_cms_shop.id_cms has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_cms_shop.id_shop has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_cart.gift has data type tinyint unsigned instead of tinyint(1) unsigned
critical	dangerous	Column tb_cms_role_lang.id_shop has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_cms_role_lang.id_lang has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_cart_product.id_cart has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_cart_cart_rule.id_cart_rule has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_cart_cart_rule.id_cart has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_cms_role_lang.id_cms_role has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_cms_category_lang.id_lang has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_cms_category_lang.id_cms_category has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_category_shop.id_shop has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_category_shop.position has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_cms.id_cms has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_cart_rule.id_customer has data type int unsigned instead of int(10) unsigned
critical	dangerous	Column tb_cart_rule.quantity has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_cart_rule.quantity_per_user has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_category_shop.id_category has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_cart_rule.minimum_amount_currency has data type int unsigned instead of int(10) unsigned
critical	dangerous	Column tb_cart_rule.partial_use has data type tinyint unsigned instead of tinyint(1) unsigned
critical	dangerous	Column tb_cart_rule.priority has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_cms.id_cms_category has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_cms.position has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_cms_category.level_depth has data type tinyint unsigned instead of tinyint(3) unsigned
critical	dangerous	Column tb_cms_category.active has data type tinyint unsigned instead of tinyint(1) unsigned
critical	dangerous	Column tb_cms_category.position has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_cart_product.quantity has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_cms_category.id_parent has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_cms_category.id_cms_category has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_cms.active has data type tinyint unsigned instead of tinyint(1) unsigned
critical	dangerous	Column tb_cms.indexation has data type tinyint unsigned instead of tinyint(1) unsigned
critical	dangerous	Column tb_cart_rule.id_cart_rule has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_customer_thread.id_customer has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_customer_group.id_customer has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_attachment_lang.id_attachment has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_image.id_image has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_image.id_product has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_image.position has data type smallint unsigned instead of smallint(2) unsigned
critical	dangerous	Column tb_attachment_lang.id_lang has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_hook_module_exceptions.id_hook has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_attribute.id_attribute has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_hook_module_exceptions.id_hook_module_exceptions has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_hook_module_exceptions.id_shop has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_hook_module_exceptions.id_module has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_image.cover has data type tinyint unsigned instead of tinyint(1) unsigned
critical	dangerous	Column tb_attachment.file_size has data type bigint unsigned instead of bigint(11) unsigned
critical	dangerous	Column tb_image_shop.id_shop has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_image_shop.cover has data type tinyint unsigned instead of tinyint(1) unsigned
critical	dangerous	Column tb_alias.id_alias has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_image_type.id_image_type has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_image_shop.id_image has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_image_shop.id_product has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_attachment.id_attachment has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_image_lang.id_image has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_image_lang.id_lang has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_attribute.id_attribute_group has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_hook_module.position has data type tinyint unsigned instead of tinyint(2) unsigned
critical	dangerous	Column tb_guest.id_web_browser has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_guest.id_customer has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_attribute_group_lang.id_lang has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_guest.screen_resolution_x has data type smallint unsigned instead of smallint(5) unsigned
critical	dangerous	Column tb_attribute_group_shop.id_attribute_group has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_guest.id_operating_system has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_group_shop.id_group has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_group_shop.id_shop has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_guest.id_guest has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_guest.screen_resolution_y has data type smallint unsigned instead of smallint(5) unsigned
critical	dangerous	Column tb_guest.screen_color has data type tinyint unsigned instead of tinyint(3) unsigned
critical	dangerous	Column tb_hook_module.id_module has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_hook_module.id_shop has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_attribute.position has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_hook_module.id_hook has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_attribute_group.id_attribute_group has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_hook_alias.id_hook_alias has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_attribute_group_lang.id_attribute_group has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_customer_thread.id_order has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_attribute_group.position has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_image_type.width has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_image_type.height has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_message.id_customer has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_message.id_employee has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_address.id_address has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_message.id_order has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_message.id_cart has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_address.id_country has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_memcached_servers.port has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_address.id_state has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_memcached_servers.weight has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_message.id_message has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_message.private has data type tinyint unsigned instead of tinyint(1) unsigned
critical	dangerous	Column tb_message_readed.id_message has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_access.id_tab has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_meta_lang.id_meta has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_meta_lang.id_shop has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_meta_lang.id_lang has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_meta.configurable has data type tinyint unsigned instead of tinyint(1) unsigned
critical	dangerous	Column tb_meta.id_meta has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_message_readed.id_employee has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_accessory.id_product_2 has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_accessory.id_product_1 has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_memcached_servers.id_memcached_server has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_address.id_customer has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_log.id_log has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_log.object_id has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_log.id_employee has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_address.deleted has data type tinyint unsigned instead of tinyint(1) unsigned
critical	dangerous	Column tb_lang_shop.id_shop has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_lang_shop.id_lang has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_address_format.id_country has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_lang.id_lang has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_lang.active has data type tinyint unsigned instead of tinyint(3) unsigned
critical	dangerous	Column tb_mail.id_mail has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_address.active has data type tinyint unsigned instead of tinyint(1) unsigned
critical	dangerous	Column tb_address.id_manufacturer has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_manufacturer_lang.id_lang has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_manufacturer_shop.id_manufacturer has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_manufacturer_shop.id_shop has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_manufacturer_lang.id_manufacturer has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_address.id_supplier has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_mail.id_lang has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_address.id_warehouse has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_manufacturer.id_manufacturer has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_attribute_group_shop.id_shop has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_hook.id_hook has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_employee.id_lang has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_employee.stats_compare_option has data type int unsigned instead of int(1) unsigned
critical	dangerous	Column tb_employee.default_tab has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_employee.bo_width has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_attribute_shop.id_shop has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_employee.id_profile has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_delivery.id_range_weight has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_delivery.id_zone has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_carrier.id_carrier has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_employee.id_employee has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_attribute_shop.id_attribute has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_employee.active has data type tinyint unsigned instead of tinyint(1) unsigned
critical	dangerous	Column tb_employee_shop.id_employee has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_employee_shop.id_shop has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_feature.id_feature has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_feature.position has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_attribute_lang.id_lang has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_employee.id_last_customer has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_employee.optin has data type tinyint unsigned instead of tinyint(1) unsigned
critical	dangerous	Column tb_attribute_impact.id_attribute_impact has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_employee.id_last_customer_message has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_delivery.id_range_price has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_delivery.id_carrier has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_carrier.shipping_handling has data type tinyint unsigned instead of tinyint(1) unsigned
critical	dangerous	Column tb_customization_field.id_customization_field has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_customization_field.id_product has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_carrier.deleted has data type tinyint unsigned instead of tinyint(1) unsigned
critical	dangerous	Column tb_customization.in_cart has data type tinyint unsigned instead of tinyint(1) unsigned
critical	dangerous	Column tb_customization.id_cart has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_customer_thread.id_product has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_customization.id_customization has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_customization.id_product_attribute has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_customization.id_address_delivery has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_customization_field_lang.id_customization_field has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_customization_field_lang.id_lang has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_delivery.id_delivery has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_delivery.id_shop has data type int unsigned instead of int(10) unsigned
critical	dangerous	Column tb_carrier.id_reference has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_delivery.id_shop_group has data type int unsigned instead of int(10) unsigned
critical	dangerous	Column tb_carrier.id_tax_rules_group has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_date_range.id_date_range has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_customization_field_lang.id_shop has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_carrier.active has data type tinyint unsigned instead of tinyint(1) unsigned
critical	dangerous	Column tb_customized_data.id_customization has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_feature_lang.id_feature has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_employee.id_last_order has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_feature_value_lang.id_lang has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_gender_lang.id_gender has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_gender_lang.id_lang has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_feature_value.custom has data type tinyint unsigned instead of tinyint(3) unsigned
critical	dangerous	Column tb_feature_value.id_feature has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_feature_shop.id_shop has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_feature_value.id_feature_value has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_group.id_group has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_group.show_prices has data type tinyint unsigned instead of tinyint(1) unsigned
critical	dangerous	Column tb_group_reduction.id_group_reduction has data type mediumint unsigned instead of mediumint(8) unsigned
critical	dangerous	Column tb_group_reduction.id_group has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_group_reduction.id_category has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_group_lang.id_lang has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_attribute_impact.id_product has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_attribute_impact.id_attribute has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_group_lang.id_group has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_feature_shop.id_feature has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_feature_value_lang.id_feature_value has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_feature_product.id_feature_value has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_feature_product.id_feature has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_feature_lang.id_lang has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_attribute_lang.id_attribute has data type int unsigned instead of int(11) unsigned
critical	dangerous	Column tb_feature_product.id_product has data type int unsigned instead of int(11) unsigned
recommended		Columns in table tb_theme are in wrong order
recommended		Columns in table tb_cart_product are in wrong order
recommended		Columns in table tb_tag are in wrong order
recommended		Different unique key `alias` in table tb_alias
recommended		Columns in table tb_supplier are in wrong order
recommended		Columns in table tb_supply_order_state_lang are in wrong order
recommended		Columns in table tb_attribute_group are in wrong order
recommended		Columns in table tb_webservice_account_shop are in wrong order
recommended		Columns in table tb_stock_mvt are in wrong order
recommended		Columns in table tb_tax are in wrong order
recommended		Columns in table tb_cart_rule are in wrong order
recommended		Different unique key `resource_2` in table tb_webservice_permission
recommended		Columns in table tb_supplier_lang are in wrong order
recommended		Columns in table tb_access are in wrong order
recommended		Columns in table tb_zone_shop are in wrong order
recommended		Columns in table tb_tag_count are in wrong order
recommended		Columns in table tb_tax_rules_group_shop are in wrong order
recommended		Columns in table tb_zone are in wrong order
recommended		Columns in table tb_supply_order_detail are in wrong order
recommended		Columns in table tb_supplier_shop are in wrong order
recommended		Columns in table tb_alias are in wrong order
recommended		Columns in table tb_warehouse are in wrong order
recommended		Columns in table tb_tax_rules_group are in wrong order
recommended		Columns in table tb_supply_order_history are in wrong order
recommended		Columns in table tb_webservice_permission are in wrong order
recommended		Columns in table tb_carrier are in wrong order
recommended		Different unique key `id_product` in table tb_attribute_impact
recommended		Different unique key `id_product` in table tb_warehouse_product_location
recommended		Columns in table tb_supply_order_state are in wrong order
recommended		Columns in table tb_tab_lang are in wrong order
recommended		Columns in table tb_carrier_lang are in wrong order
recommended		Columns in table tb_address are in wrong order
recommended		Columns in table tb_theme_specific are in wrong order
recommended		Columns in table tb_tax_rule are in wrong order
recommended		Columns in table tb_tab are in wrong order
recommended		Columns in table tb_store_shop are in wrong order
recommended		Columns in table tb_address_format are in wrong order
recommended		Columns in table tb_store are in wrong order
recommended		Columns in table tb_warehouse_product_location are in wrong order
recommended		Columns in table tb_cart are in wrong order
recommended		Columns in table tb_supply_order are in wrong order
recommended		Different unique key `id_theme_2` in table tb_theme_meta
recommended		Columns in table tb_stock_mvt_reason are in wrong order
recommended		Columns in table tb_carrier_tax_rules_group_shop are in wrong order
recommended		Columns in table tb_webservice_account are in wrong order
recommended		Columns in table tb_attachment_lang are in wrong order
recommended		Different unique key `employee_module` in table tb_tab_module_preference
recommended		Columns in table tb_supply_order_receipt_history are in wrong order
recommended		Columns in table tb_tab_module_preference are in wrong order
recommended		Columns in table tb_stock_mvt_reason_lang are in wrong order
recommended		Columns in table tb_tax_lang are in wrong order
recommended		Columns in table tb_attribute_impact are in wrong order
recommended		Columns in table tb_attachment are in wrong order
recommended		Columns in table tb_attribute are in wrong order
recommended		Columns in table tb_theme_meta are in wrong order
recommended		Columns in table tb_configuration_kpi_lang are in wrong order
recommended		Columns in table tb_group_reduction are in wrong order
recommended		Columns in table tb_order_slip are in wrong order
recommended		Different unique key `id_group` in table tb_group_reduction
recommended		Columns in table tb_order_slip_detail are in wrong order
recommended		Columns in table tb_order_slip_detail_tax are in wrong order
recommended		Columns in table tb_order_state are in wrong order
recommended		Columns in table tb_feature_value are in wrong order
recommended		Columns in table tb_group are in wrong order
recommended		Columns in table tb_order_return_state_lang are in wrong order
recommended		Columns in table tb_order_return_state are in wrong order
recommended		Columns in table tb_hook_alias are in wrong order
recommended		Different unique key `alias` in table tb_hook_alias
recommended		Columns in table tb_order_payment are in wrong order
recommended		Different unique key `hook_name` in table tb_hook
recommended		Columns in table tb_order_return are in wrong order
recommended		Columns in table tb_order_return_detail are in wrong order
recommended		Columns in table tb_guest are in wrong order
recommended		Columns in table tb_hook are in wrong order
recommended		Columns in table tb_order_state_lang are in wrong order
recommended		Columns in table tb_feature_product are in wrong order
recommended		Columns in table tb_customer_thread are in wrong order
recommended		Columns in table tb_customization are in wrong order
recommended		Columns in table tb_customization_field are in wrong order
recommended		Columns in table tb_product are in wrong order
recommended		Columns in table tb_product_attachment are in wrong order
recommended		Different unique key `product_default` in table tb_product_attribute
recommended		Columns in table tb_product_attribute are in wrong order
recommended		Columns in table tb_customer_message are in wrong order
recommended		Columns in table tb_page_viewed are in wrong order
recommended		Columns in table tb_customized_data are in wrong order
recommended		Columns in table tb_pack are in wrong order
recommended		Columns in table tb_orders are in wrong order
recommended		Columns in table tb_employee are in wrong order
recommended		Columns in table tb_delivery are in wrong order
recommended		Columns in table tb_page are in wrong order
recommended		Columns in table tb_date_range are in wrong order
recommended		Columns in table tb_page_cache are in wrong order
recommended		Columns in table tb_order_message_lang are in wrong order
recommended		Columns in table tb_order_message are in wrong order
recommended		Different unique key `employee_module` in table tb_module_preference
recommended		Columns in table tb_module_preference are in wrong order
recommended		Columns in table tb_module_group are in wrong order
recommended		Columns in table tb_module_shop are in wrong order
recommended		Columns in table tb_manufacturer_lang are in wrong order
recommended		Columns in table tb_mail are in wrong order
recommended		Columns in table tb_manufacturer are in wrong order
recommended		Columns in table tb_modules_perfs are in wrong order
recommended		Columns in table tb_module_currency are in wrong order
recommended		Columns in table tb_message are in wrong order
recommended		Columns in table tb_module_access are in wrong order
recommended		Different unique key `page` in table tb_meta
recommended		Columns in table tb_module are in wrong order
recommended		Columns in table tb_meta are in wrong order
recommended		Columns in table tb_module_carrier are in wrong order
recommended		Columns in table tb_module_country are in wrong order
recommended		Columns in table tb_message_readed are in wrong order
recommended		Columns in table tb_order_carrier are in wrong order
recommended		Columns in table tb_log are in wrong order
recommended		Columns in table tb_image are in wrong order
recommended		Columns in table tb_order_history are in wrong order
recommended		Different unique key `idx_product_image` in table tb_image
recommended		Columns in table tb_order_invoice are in wrong order
recommended		Columns in table tb_hook_module_exceptions are in wrong order
recommended		Columns in table tb_hook_module are in wrong order
recommended		Columns in table tb_order_invoice_tax are in wrong order
recommended		Columns in table tb_order_invoice_payment are in wrong order
recommended		Different unique key `id_product_cover` in table tb_image
recommended		Columns in table tb_order_detail_tax are in wrong order
recommended		Columns in table tb_import_match are in wrong order
recommended		Columns in table tb_lang are in wrong order
recommended		Columns in table tb_order_cart_rule are in wrong order
recommended		Columns in table tb_image_type are in wrong order
recommended		Different unique key `id_product` in table tb_image_shop
recommended		Columns in table tb_order_detail are in wrong order
recommended		Columns in table tb_image_shop are in wrong order
recommended		Columns in table tb_customer are in wrong order
recommended		Columns in table tb_product_attribute_image are in wrong order
recommended		Columns in table tb_cms are in wrong order
recommended		Columns in table tb_search_engine are in wrong order
recommended		Columns in table tb_cms_category are in wrong order
recommended		Columns in table tb_search_word are in wrong order
recommended		Different unique key `id_lang` in table tb_search_word
recommended		Columns in table tb_shop_url are in wrong order
recommended		Columns in table tb_shop_group are in wrong order
recommended		Columns in table tb_shop are in wrong order
recommended		Columns in table tb_scene_products are in wrong order
recommended		Columns in table tb_cms_category_lang are in wrong order
recommended		Columns in table tb_cms_role are in wrong order
recommended		Columns in table tb_risk_lang are in wrong order
recommended		Different unique key `name` in table tb_cms_role
recommended		Columns in table tb_scene are in wrong order
recommended		Columns in table tb_scene_category are in wrong order
recommended		Columns in table tb_scene_lang are in wrong order
recommended		Columns in table tb_cms_lang are in wrong order
recommended		Different unique key `full_shop_url` in table tb_shop_url
recommended		Different unique key `full_shop_url_ssl` in table tb_shop_url
recommended		Columns in table tb_specific_price_rule_condition_group are in wrong order
recommended		Columns in table tb_cart_rule_product_rule_value are in wrong order
recommended		Columns in table tb_specific_price_rule are in wrong order
recommended		Columns in table tb_cart_rule_product_rule_group are in wrong order
recommended		Columns in table tb_state are in wrong order
recommended		Columns in table tb_stock_available are in wrong order
recommended		Columns in table tb_cart_rule_carrier are in wrong order
recommended		Columns in table tb_stock are in wrong order
recommended		Different unique key `id_product` in table tb_specific_price_priority
recommended		Columns in table tb_specific_price_priority are in wrong order
recommended		Columns in table tb_smarty_lazy_cache are in wrong order
recommended		Columns in table tb_smarty_last_flush are in wrong order
recommended		Columns in table tb_smarty_cache are in wrong order
recommended		Columns in table tb_category_lang are in wrong order
recommended		Columns in table tb_category are in wrong order
recommended		Different unique key `id_product_2` in table tb_specific_price
recommended		Columns in table tb_specific_price are in wrong order
recommended		Columns in table tb_risk are in wrong order
recommended		Columns in table tb_required_field are in wrong order
recommended		Columns in table tb_product_sale are in wrong order
recommended		Columns in table tb_product_lang are in wrong order
recommended		Columns in table tb_product_group_reduction_cache are in wrong order
recommended		Columns in table tb_country are in wrong order
recommended		Columns in table tb_contact_lang are in wrong order
recommended		Columns in table tb_connections_source are in wrong order
recommended		Columns in table tb_product_shop are in wrong order
recommended		Columns in table tb_contact are in wrong order
recommended		Different unique key `id_product` in table tb_product_download
recommended		Columns in table tb_product_download are in wrong order
recommended		Columns in table tb_product_carrier are in wrong order
recommended		Different unique key `id_product` in table tb_product_attribute_shop
recommended		Columns in table tb_product_attribute_shop are in wrong order
recommended		Columns in table tb_currency_shop are in wrong order
recommended		Columns in table tb_product_country_tax are in wrong order
recommended		Columns in table tb_currency are in wrong order
recommended		Different unique key `uc_id_currency` in table tb_currency_module
recommended		Columns in table tb_connections_page are in wrong order
recommended		Columns in table tb_product_supplier are in wrong order
recommended		Columns in table tb_configuration_kpi are in wrong order
recommended		Different unique key `id_carrier` in table tb_range_weight
recommended		Columns in table tb_range_weight are in wrong order
recommended		Columns in table tb_redis_servers are in wrong order
recommended		Columns in table tb_referrer are in wrong order
recommended		Columns in table tb_referrer_shop are in wrong order
recommended		Columns in table tb_compare_product are in wrong order
recommended		Columns in table tb_configuration are in wrong order
recommended		Different unique key `id_carrier` in table tb_range_price
recommended		Columns in table tb_range_price are in wrong order
recommended		Columns in table tb_product_tag are in wrong order
recommended		Columns in table tb_connections are in wrong order
recommended		Different unique key `id_product` in table tb_product_supplier
recommended		Columns in table tb_quick_access are in wrong order
recommended		Columns in table tb_configuration_lang are in wrong order
recommended		Columns in table tb_meta_lang are in wrong order
recommended		Columns in table tb_quick_access_lang are in wrong order
recommended		Different unique key `product_sqlstock` in table tb_stock_available

 

 

 

 

 

Edited August 21, 2021 by Bside2234

[toplakd]

I did have similar, about 38 pages long 🙂

[Bside2234]

20 hours ago, toplakd said:

I did have similar, about 38 pages long 🙂

Did you fix them? I'm curious why TB would create a database that has so many "problems".

[toplakd]

Yes, i fixed it one by one.

My shop started as PS 1.3.8 i think back in December 2010.

So lots of upgrades until 1.6 and then migration to thirty bees.

[Bside2234]

24 minutes ago, toplakd said:

Yes, i fixed it one by one.

My shop started as PS 1.3.8 i think back in December 2010.

So lots of upgrades until 1.6 and then migration to thirty bees.

I'm trying to fix it but I really don't know how. Clicking the fix buttons on these don't do anything. I went to the database/mysql and to to them and I'm really not sure what to change (i.e. where to add the (11) or if there is anything else to change along with it). I don't know much about databases and their structure.

Edit: For example, the first one on the list "Column tb_referrer_shop.cache_pages has data type int instead of int(11)" I assume I put 11 in the Length/Values field but it does nothing. Adding the () throws a error. Not really sure what to do here.

Edited August 22, 2021 by Bside2234

[toplakd]

Just clicking on fix buttons. Just skip those that wont do anything and try them later after clicking other ones.

[Bside2234]

9 minutes ago, toplakd said:

Just clicking on fix buttons. Just skip those that wont do anything and try them later after clicking other ones.

Ok. I'll give it a try

 

[30knees]

You said you use Advanced Stock Management. Perhaps try without that. Many people report problems.

[musicmaster]

22 hours ago, Bside2234 said:

Did you fix them? I'm curious why TB would create a database that has so many "problems".

I don't understand why TB flags these "problems". As far as I can see none is really a problem. The order of the fields doesn't matter and a field size of "int" instead of int(11) will only become a problem when you sell more than 2 billion products.

[Bside2234]

13 hours ago, 30knees said:

You said you use Advanced Stock Management. Perhaps try without that. Many people report problems.

In the all the installs I hadn't turned it on. It was only until this last one that I thought I'd try turning it on to see if it made a difference. It didn't.

[Bside2234]

17 minutes ago, musicmaster said:

I don't understand why TB flags these "problems". As far as I can see none is really a problem. The order of the fields doesn't matter and a field size of "int" instead of int(11) will only become a problem when you sell more than 2 billion products.

Yeah, as I was looking into what all of them meant a little, I do see what you are saying. At this point I'm just trying anything to fix it though.

[Bside2234]

So here's another twist to my problem.

I found out that even my original Prestashop site is having this issue now. I haven't had the Show Quantities on but all of a sudden I was having stock issues where customers were ordering stuff an I didn't have it. I know my stock is probably off a little bit but it's not off by that much if any. Anyway I turned on Show Quantities and discovered the issue is there too.

So I just decided since I was having this problem everywhere that I would just go live with my TB store. In the process of doing this I decided to try the Store Manager program/app to export/import customers with passwords a little more easily. That went smoothly. Now to the twist part. If I adjust the stock of a product with Store Manager, the actual stock shown on the page is

correct! It still shows wrong in the stores back office though.

Below is my 16mm potentiometer I've been linking to for an example. This is it in Store Manager. I set 100K to 1 and 500K to 5 for simplicity in keeping track of what is what.

Below is the pot as shown online showing the 100K is actually quantity 1! 500K also shows as quantity 5.

So Store Manager is allowing me to enter the correct quantity/stock and it's showing up correctly on the front end BUT....the pic below shows it's still wrong in the stores back office.

Now I wish I didn't have to fork out $200-350 dollars to get my stock to enter correctly but I may have to. I'm going to try it with a few other products (one's with more than two combinations) to see how it goes.

[musicmaster]

I don't have time to research this myself. But it shouldn't be that difficult if you are prepared to get dirty hands in Phpmyadmin:

 - in the first post of this thread you mention a product that shows 1799 stock while it is not in the settings. So do a database search for any field in any table with the content "1799".

 - stock is in many tables: ps_product, ps_product_shop and ps_stock_available. Only the last should count. But in cases like this it might be that things get mixed up. So you should check for that.

 - with profiling you can see the database queries that were made. That can provide leads were things go wrong.

[Bside2234]

7 hours ago, musicmaster said:

I don't have time to research this myself. But it shouldn't be that difficult if you are prepared to get dirty hands in Phpmyadmin:

 - in the first post of this thread you mention a product that shows 1799 stock while it is not in the settings. So do a database search for any field in any table with the content "1799".

 - stock is in many tables: ps_product, ps_product_shop and ps_stock_available. Only the last should count. But in cases like this it might be that things get mixed up. So you should check for that.

 - with profiling you can see the database queries that were made. That can provide leads were things go wrong.

Thanks for the tips and I'll look into all this. I am just so confused where the actual problem is now. The Store Manager app/program seems to connect only directly to the database and make changes there and this actually makes my stock quantities correct so I was leaning towards it not being a database problem and more of a back office problem.

The thing that's throwing me is with Store Manager, quantities are correct on it and in the store/front end now but they are still showing mixed up in the back office. This leads me to think something is wrong in the back office and not the database but I'll check the database a little more to see what's going on there.

Edit: Oh, and it's not that 1799 is not in the settings. It it actually is a quantity of another combination. Seems the combinations quantities are offset by 1 row. Meaning the quantity of the first combination is actually on the second row, the second combinations quantity is actually on the third row, etc. The last combinations quantity is moved up to the top row. So each quantity for

each combination is in the row below it.

Edited August 28, 2021 by Bside2234

[Bside2234]

Ok. So I adjusted the quantities/stock of another product that had a few more combinations using Store Manager and it worked again so Store Manager is entering my stock correctly and making it show up in the store correctly but it still shows up in the store back office as mixed up.

I attached pics of this other product which has 4 combinations. 100K W value is actually 16!

So I just have to figure out why things are off when combinations are generated in the back office. Oooooh! I'm going to try and create a new product with combinations in Store Manager to see what happens!