Threaded Mode | Linear Mode

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 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** · 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

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_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** · 12-07-2007 05:14 PM

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

Greez BeNe

**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

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?

**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

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

**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

bkxxl · 12-15-2007 01:18 AM

I have tested dmn_id and htaccess id.

Threaded Mode \| Linear Mode htaccess problem VHCS Script
Author	Message