+- ispCP - Board - Support (http://www.isp-control.net/forum)
+-- Forum: ispCP Omega Support Area (/forum-30.html)
+--- Forum: Usage (/forum-34.html)
+--- Thread: htaccess problem VHCS Script (/thread-1951.html)
Pages: 1 2
htaccess problem VHCS Script - bkxxl - 12-07-2007 05:53 AM
hi at all,
when i run vhcs2-htuser-mngr, the script will send me the following Error Message:
Code:
DEBUG: push_el() sub_name: doSQL(), msg: ERROR: Incorrect SQL Query -> 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 'and
t1.user_id != 0
and
t1.dmn_id = t2.domain_id' at line 22
DEBUG: pop_el() sub_name: doSQL(), msg: ERROR: Incorrect SQL Query -> 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 'and
t1.user_id != 0
and
t1.dmn_id = t2.domain_id' at line 22OS: Debian Etch
PHP Version: 5.2.0-8+etch7
MySQL Client API: 5.0.32
I have checked the ISPCP Omega htaccess file, but there are the same QRY lines.
Maybe someone has the same error and can help me to fix it.
RE: htaccess problem VHCS Script - joximu - 12-07-2007 08:54 AM
Hi
well, we don't really support vhcs here but you could provide more information here if you could post the whole part in the vhcs2-htuser-mngr where the query is stored (I think the line numbers are different in "our"(ispcp) version).
/Joximu
RE: htaccess problem VHCS Script - bkxxl - 12-07-2007 03:15 PM
Code:
Use of uninitialized value in concatenation (.) or string at ./vhcs2-htuser-mngr line 764.Information at this line:
Code:
$sql = <<SQL_QUERY;
select
t1.dmn_id,
t2.domain_name,
t1.user_id,
t1.auth_type,
t1.auth_name,
t1.path,
t1.status,
t2.domain_uid,
t2.domain_gid
from
htaccess as t1,
domain as t2
where
t1.id = $main::htuser_task_id
and
t1.user_id != 0
and
t1.dmn_id = t2.domain_idI have checked the Lines at ISPCP Script and there were the same entries.
Same Error Like: http://isp-control.net/forum/ispcp-htuser-mngr-error-with-mysql-t-1731.html
and there were no solve, too.
RE: htaccess problem VHCS Script - BeNe - 12-07-2007 05:14 PM
If really so - please open a Ticket for RC4 about this Problem.
Greez BeNe
RE: htaccess problem VHCS Script - joximu - 12-07-2007 06:56 PM
No! no ticket.
Well it's easy: you should not run the copmmand without a parameter: the id of the user where ht-things have to be done.
Normally it runs like this:
The request manager finds the ids of the things to be done an it runs the several other perl scripts with the id as parameter so the script knows which row in the database.
If you run the script without paraemter there is no "$main::htuser_task_id" defined and therefore it's empty and the "and" afterwards will throw a sql error.
Ok, you could say: there should be an error message like "too few arguments" but the engine scripts are not meant to be run manually by everyone...
/Joximu
RE: htaccess problem VHCS Script - bkxxl - 12-07-2007 11:43 PM
ok, but why does i ever geht this message "Wird angelegt, bitte warten..." when i try to add, change or delete some htaccess user, group or area?
RE: htaccess problem VHCS Script - joximu - 12-07-2007 11:46 PM
I don't have a crystal ball...
the logfiles should give more info about errors in the engine files...
you could try this: find the id of the htuser row in the database which schould be changed (added etc) and then run the command with the id as the first parameter.
/J
RE: htaccess problem VHCS Script - bkxxl - 12-14-2007 11:43 PM
When i run the script with the htaccess user ID as first parameter, it shows me the following error:
./vhcs2-htuser-mngr 17
Quote:Use of uninitialized value in concatenation (.) or string at ./vhcs2-htuser-mngr line 1050.
DEBUG: push_el() sub_name: doSQL(), msg: Starting...
DEBUG: push_el() sub_name: doSQL(), msg: Ending...
DEBUG: push_el() sub_name: doSQL(), msg: Starting...
DEBUG: push_el() sub_name: doSQL(), msg: Ending...
Use of uninitialized value in concatenation (.) or string at ./vhcs2-htuser-mngr line 1129.
Line 1050:
Quote:$sql = "select uname, upass, dmn_id, status, id from htaccess_users where dmn_id = '".@$htaccess_data[0]."' and status != 'ok' ";
RE: htaccess problem VHCS Script - joximu - 12-15-2007 01:07 AM
without having a deeper look (a bit busy at the moment)
try the "domain id" instead of htaccess-id
/J
RE: htaccess problem VHCS Script - bkxxl - 12-15-2007 01:18 AM
I have tested dmn_id and htaccess id.