MIgration Manager BUG

[datahaus]

Found a BUG in migration manager plesk module PleskX.pl (Version 7.5.2) execution on Redhat Linux 9.0 fail with this error:

SELECT c.id FROM certificates c, Repo
sitory r WHERE c.id=r.component_id AND r.rep_id= ORDER BY c.id
You have an error in your SQL syntax near 'ORDER BY c.id' at line 1

line 3161:

    $sql = "SELECT c.id FROM certificates c, Repository r ".                                                                  
      "WHERE c.id=r.component_id AND r.rep_id=".$domain{'cert_rep_id'}.                                                      
      " ORDER BY c.id";

changed to:

    $sql = "SELECT c.id FROM certificates c, Repository r ".                                                                  
      "WHERE c.id=r.component_id AND r.rep_id='".$domain{'cert_rep_id'}.                                                      
      "' ORDER BY c.id";

Hope this will help

 

[0031]

In Plesk 7.5.3 beta1 SQL query is fixed as you suggested