net2ftp Unable to execute the SQL query.

After installing EHCP I logged in, as admin, and chose to "Add new (quick)" a domain. I then logged out and logged back in under the newly created domain. I selected WebFtp (net2ftp) and got the following.

Unable to execute the SQL query.

The error occured in file /var/www/vhosts/ehcp/net2ftp/includes/authorizations.inc.php on line 728.

* function logAccess (/var/www/vhosts/ehcp/net2ftp/main.inc.php on line 213)
* function net2ftp (/var/www/vhosts/ehcp/net2ftp/index.php on line 38)
o argument 0: sendHttpHeaders

I have installed and currently use a previous version of EHCP and did not have this problem. Thanks in advance for your help.

somehow, your installer did not put correct password in net2ftp's configuration file

so,
after installing new ehcp,
if you are not able to use net2ftp,

open file
/var/www/vhosts/ehcp/net2ftp/settings.inc.php

in your server console,
find line with:
$net2ftp_settings["dbpassword"]='';

put correct mysql ehcp user pass in quotes.. your webftp should work hereafter.

i checked the installer again, to see if everything ok; will check again..

I opened
/var/www/vhosts/ehcp/net2ftp/settings.inc.php

and found
$net2ftp_settings["dbpassword"]='xxxxxxxx';

this is the correct password.

after looking at the file I decided to make a change to the following
$net2ftp_settings["use_database"] = "yes"; // "yes" or "no"

I changed the yes to a no and I can now access net2ftp.

Hello. I have the same issue and in the /var/www/vhosts/ehcp/net2ftp/settings.inc.php there is correct password

can you attache here your settings.inc.php, (after deleting your pass),
i will check..

here is a portion of mine:
$net2ftp_settings["use_database"] = "yes"; // "yes" or "no"
// Enter your MySQL settings
$net2ftp_settings["dbusername"] = "ehcp";
$net2ftp_settings["dbpassword"]='xxxx';
$net2ftp_settings["dbname"] = "ehcp";
$net2ftp_settings["dbserver"] = "localhost"; // on many configurations, this is "localhost"

if you say "no" to use_database, then, you will not be able to use some db features of net2ftp, nevertheless, your net2ftp will work in that case too.

$net2ftp_settings["use_database"] = "no"; // "yes" or "no"

// Enter your MySQL settings
$net2ftp_settings["dbusername"] = "ehcp";
$net2ftp_settings["dbpassword"]='xxxxxxxx';
$net2ftp_settings["dbname"] = "ehcp";
$net2ftp_settings["dbserver"] = "localhost"; // on many configurations, this is "localhost"

of course that was "yes" before

this net2ftp error is completely fixed in ehcp ver 0.29.13 and later

The error occured in file /var/www/vhosts/ehcp/net2ftp/includes/authorizations.inc.php on line 728.
function logAccess (/var/www/vhosts/ehcp/net2ftp/main.inc.php on line 213)
function net2ftp (/var/www/vhosts/ehcp/net2ftp/index.php on line 38)
argument 0: sendHttpHeaders