error add user mysql

[theprincy]

when add user to database have this error

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''`centroprotesi`' *.* TO 'centrous'@'localhost' IDENTIFIED BY '210269'' at line 1

user is add to table mysql ispc ( sql_user) but not assign database and in mysql user.

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''`centroprotesi`' *.* TO 'centrous'@'localhost' IDENTIFIED BY '210269'' at line 1
File: /var/www/ispcp/gui/client/sql_user_add.php (Line: 321) Function: exec_query
File: /var/www/ispcp/gui/client/sql_user_add.php (Line: 393) Function: add_sql_user

[joximu]

Hi

which version of ispcp do you use?

If you took a nightly then use a newer nightly - the bug is fixed. If you use the official 1.0.0 then maybe a patch may fix the problem: maybe use the latest version of the file:
http://www.isp-control.net/ispcp/browser...er_add.php

/J

[theprincy]

is a nightly trunk-20090806.tar.bz2 mmm i have installed today ... mmm

[joximu]

hm... but on line 321 in the actual version there is no exec_query... this is rev. 1879 (or before). Just use the new version of this file.

/J