Versions Compared

Key

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

...

  1. Upload/unzip v2 module to your HostBill server
  2. Make sure that the DirectAdmin2 module is enabled (you do not need to set up app connection for it)
  3. Connect to the database.
  4. You should run the query which is below.
  5. Once migration is complete deactivate old module in settings->modules

Query

Code Block
languagesql
titleMigration from cPanel to cPanel2
linenumberstrue
SET @directadmin2 = (SELECT `id` FROM hb_modules_configuration WHERE `filename` = 'class.directadmin2.php'),
@directadmin = (SELECT `id` FROM hb_modules_configuration WHERE `filename` = 'class.directadmin.php');
UPDATE hb_server_groups g, hb_servers s, hb_products_modules p
SET g.`module` = IF(@directadmin2 IS NOT NULL, @directadmin2, @directadmin),
s.`default_module` = IF(@directadmin2 IS NOT NULL, @directadmin2, @directadmin),
p.`module` = IF(@directadmin2 IS NOT NULL, @directadmin2, @directadmin)
WHERE g.`module` = @directadmin AND s.`default_module` = @directadmin AND p.`module` = @directadmin;

...