database integrity

[peter4661]

Just for information and learning

 

We recently moved our site to new server. Before the move we tested this site on future location, create order, create product, ect. When we thought all was O.K., decided to move.

Once the site resolved on new location and we started to work with it all kind of weird things happend... We considered could be database issue and applied PrestaShop Cleaner to resolve Functional integrity constraints. The message from this action was ( see example below), problem solved ( at least we thought) 

 

After spending hours of problem solving it turned out the new server database did allow "null"  fields.

 

On the new server, database setting was changed by the host to  allow " null" field, website is up & running now. https://www.derks-wielersport.nl   Issue solved!??  Host database expert made a remark " having NULLs everywhere leads to data with no integrity " ??

 

On the old server we had seen the warning ' empty field not allowed'  with product save and stay action. But when we repeated the action save and stay, the warning did not came back.

 

 

Bottom line question, is our database integrity at stake here? 

 

 

 

 

 

 

DELETE FROM `ps_cart_cart_rule` WHERE `id_cart` NOT IN (SELECT `id_cart` FROM `ps_cart`)
    1 lijn(en)
    DELETE FROM `ps_cart_product` WHERE `id_cart` NOT IN (SELECT `id_cart` FROM `ps_cart`)
    150 lijn(en)
    DELETE FROM `ps_category_product` WHERE `id_product` NOT IN (SELECT `id_product` FROM `ps_product`)
    1 lijn(en)
    DELETE FROM `ps_hook_module` WHERE `id_module` NOT IN (SELECT `id_module` FROM `ps_module`)
    59 lijn(en)
    DELETE FROM `ps_message` WHERE `id_cart` NOT IN (SELECT `id_cart` FROM `ps_cart`)
    183 lijn(en)
    DELETE FROM `ps_module_access` WHERE `id_module` NOT IN (SELECT `id_module` FROM `ps_module`)
    78 lijn(en)
    DELETE FROM `ps_module_country` WHERE `id_module` NOT IN (SELECT `id_module` FROM `ps_module`)
    31 lijn(en)
    DELETE FROM `ps_module_currency` WHERE `id_module` NOT IN (SELECT `id_module` FROM `ps_module`)
    2 lijn(en)
    DELETE FROM `ps_module_currency` WHERE `id_currency` NOT IN (SELECT `id_currency` FROM `ps_currency`)
    3 lijn(en)
    DELETE FROM `ps_module_group` WHERE `id_module` NOT IN (SELECT `id_module` FROM `ps_module`)
    42 lijn(en)
    DELETE FROM `ps_product_attribute` WHERE `id_product` NOT IN (SELECT `id_product` FROM `ps_product`)
    3 lijn(en)
    DELETE FROM `ps_product_attribute_combination` WHERE `id_product_attribute` NOT IN (SELECT `id_product_attribute` FROM `ps_product_attribute`)
    1 lijn(en)
    DELETE FROM `ps_product_sale` WHERE `id_product` NOT IN (SELECT `id_product` FROM `ps_product`)
    1 lijn(en)
    DELETE FROM `ps_product_tag` WHERE `id_tag` NOT IN (SELECT `id_tag` FROM `ps_tag`)
    5615 lijn(en)
    DELETE FROM `ps_specific_price_priority` WHERE `id_product` NOT IN (SELECT `id_product` FROM `ps_product`)
    205 lijn(en)
    DELETE FROM `ps_stock_available` WHERE `id_product` NOT IN (SELECT `id_product` FROM `ps_product`)
    147 lijn(en)

 

 

 

Edited October 13, 2014 by peter4661 (see edit history)