htaccess problem VHCS Script

[bkxxl]

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 22

OS: 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.

[joximu]

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

[bkxxl]

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_id

I have checked the Lines at ISPCP Script and there were the same entries.

Same Error Like: http://isp-control.net/forum/ispcp-htuse...-1731.html

and there were no solve, too.

[BeNe]

If really so - please open a Ticket for RC4 about this Problem.

Greez BeNe

[joximu]

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

[bkxxl]

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?

[joximu]

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

[bkxxl]

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' ";

[joximu]

without having a deeper look (a bit busy at the moment)

try the "domain id" instead of htaccess-id

/J

[bkxxl]

I have tested dmn_id and htaccess id.