+- ispCP - Board - Support (http://www.isp-control.net/forum)
+-- Forum: ispCP Omega Support Area (/forum-30.html)
+--- Forum: Usage (/forum-34.html)
+--- Thread: error add user mysql (/thread-7414.html)
error add user mysql - theprincy - 08-07-2009 02:47 AM
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
RE: error add user mysql - joximu - 08-07-2009 03:42 AM
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/trunk/gui/client/sql_user_add.php
/J
RE: error add user mysql - theprincy - 08-07-2009 04:25 AM
is a nightly trunk-20090806.tar.bz2 mmm i have installed today ... mmm
RE: error add user mysql - joximu - 08-07-2009 06:54 AM
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