Versions Compared

Old Version 25

changes.mady.by.user Paul Phillips

Saved on

compared with

New Version 26

changes.mady.by.user Paul Phillips

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Additional Information


Domains

Note
titleBROKEN

This query needs to be modified, it does not work as expected. Do not run it. This message will be removed when it has been updated.

When services and domains are imported and there is no mapping file, they will be imported using the Universal Module, or the Generic Domains module respectively. People have asked how, post migration, they can switch all of their domains from Generic Domains to another registrar module. We are providing the following query AS-IS to accomplish this. If you have multiple domain registrars that were imported into Blesta using the Generic Domains module, this may not be a solution for you. It will update ALL Generic Domain module domains to the registrar module specified.

...

By changing 'enom' to the desired registrar module.

Code Block
languagesql
    UPDATE services
    INNER JOIN `module_rows` ON `services`.`module_row_id` = `module_rows`.`id`
    INNER JOIN `modules` ON `modules`.`id` = `module_rows`.`module_id` AND `modules`.`class` = 'generic_domains'
    INNER JOIN `modules` AS enom_module ON `enom_module`.`class` = 'enom'
    INNER JOIN `module_rows` AS enom_module_row ON `enom_module_row`.`module_id` = `enom_module`.`id`
    INNER JOIN `package_pricing` ON `package_pricing`.`id` = `services`.`pricing_id`
    INNER JOIN `packages` ON `package_pricing`.`package_id` = `packages`.`id`
    INNER JOIN `package_meta` ON `package_meta`.`package_id` = `packages`.`id` AND `package_meta`.`key` = 'tlds'
    INNER JOIN `pricings` ON `package_pricing`.`pricing_id` = `pricings`.`id`
INNER JOIN `modules` AS enom_module ON `enom_module`.`class` = 'enom'
INNER JOIN `module_rows` AS enom_module_row ON `enom_module_row`.`module_id` = `enom_module`.`id`
INNER JOIN `pricings` AS enom_pricings ON `enom_pricings`.`term` = `pricings`.`term`
        AND `enom_pricings`.`period` = `pricings`.`period`
    INNER JOIN `package_pricing` AS enom_package_pricing ON `enom_package_pricing`.`pricing_id` = `enom_pricings`.`id`
    INNER JOIN `packages` AS enom_packages ON `enom_package_pricing`.`package_id` = `enom_packages`.`id`
    AND `enom_packages`.`module_id` = `enom_module`.`id`
INNER JOIN `package_meta` AS enom_package_meta ON `enom_package_meta`packages`.`value``id` = `package`enom_package_meta`.`value``package_id` AND `enom_package_meta`.`key` = 'tlds'
    AND `enom_packages`package_meta`.`id``value` = `enom_package`package_meta`.`package_id`
    `value`
SET services`services`.module`module_row_idid` = `enom_module_row`.`id`, services`services`.pricing`pricing_idid` = `enom_package_pricing`.`id`

...