Hi, I wonder if you can help me with a issue.
I am attempting to import from WHMCS to Blesta, but I am stuck at this point.
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 `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_packages`.`id` = `enom_package_meta`.`package_id` AND `enom_package_meta`.`key` = 'tlds'
AND `enom_package_meta`.`value` = `package_meta`.`value`
SET `services`.`module_row_id` = `enom_module_row`.`id`, `services`.`pricing_id` = `enom_package_pricing`.`id`
I am trying to run the SQL to change from generic_domains to Enom but it is returning " 0 rows affected. (Query took 0.0008 seconds.)"
Any ideas how I can resolve it?
kind regards
