./ispcp-htuser-mngr error with mysql

[pawouk]

Hello all, could you please help me with this error ... I am using trunk r899 with some modifications (like maia, etc). Thanx in an advance

Code:

nexus:/var/www/ispcp/engine# ./ispcp-htuser-mngr
"my" variable $uname masks earlier declaration in same scope at ./ispcp-htuser-mngr line 817.
DEBUG: push_el() sub_name: htuser_mngr_start_up(), msg: Starting...
DEBUG: push_el() sub_name: del_file(), msg: Starting...
DEBUG: push_el() sub_name: del_file(), msg: Ending...
DEBUG: push_el() sub_name: get_conf(), msg: Starting...
DEBUG: push_el() sub_name: get_file(), msg: Starting...
DEBUG: push_el() sub_name: get_file(), msg: Ending...
DEBUG: push_el() sub_name: setup_main_vars(), msg: Starting...
DEBUG: push_el() sub_name: decrypt_db_password(), msg: Starting...
DEBUG: push_el() sub_name: decrypt_db_password(), msg: Ending...
DEBUG: push_el() sub_name: setup_main_vars(), msg: Ending...
DEBUG: push_el() sub_name: get_conf(), msg: Ending...
DEBUG: push_el() sub_name: doSQL(), msg: Starting...
DEBUG: push_el() sub_name: doSQL(), msg: Ending...
DEBUG: push_el() sub_name: htuser_mngr_start_up(), msg: Ending...
DEBUG: push_el() sub_name: htuser_mngr_engine(), msg: Starting...
Use of uninitialized value in concatenation (.) or string at ./ispcp-htuser-mngr line 895.
DEBUG: push_el() sub_name: doSQL(), msg: Starting...
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
DEBUG: pop_el() sub_name: doSQL(), msg: Starting...
DEBUG: pop_el() sub_name: htuser_mngr_engine(), msg: Starting...
DEBUG: pop_el() sub_name: htuser_mngr_start_up(), msg: Ending...
DEBUG: pop_el() sub_name: doSQL(), msg: Ending...
DEBUG: pop_el() sub_name: doSQL(), msg: Starting...
DEBUG: pop_el() sub_name: get_conf(), msg: Ending...
DEBUG: pop_el() sub_name: setup_main_vars(), msg: Ending...
DEBUG: pop_el() sub_name: decrypt_db_password(), msg: Ending...
DEBUG: pop_el() sub_name: decrypt_db_password(), msg: Starting...
DEBUG: pop_el() sub_name: setup_main_vars(), msg: Starting...
DEBUG: pop_el() sub_name: get_file(), msg: Ending...
DEBUG: pop_el() sub_name: get_file(), msg: Starting...
DEBUG: pop_el() sub_name: get_conf(), msg: Starting...
DEBUG: pop_el() sub_name: del_file(), msg: Ending...
DEBUG: pop_el() sub_name: del_file(), msg: Starting...
DEBUG: pop_el() sub_name: htuser_mngr_start_up(), msg: Starting...
DEBUG: pop_el() sub_name: get_conf(), msg: Ending...
DEBUG: pop_el() sub_name: setup_main_vars(), msg: Ending...
DEBUG: pop_el() sub_name: decrypt_db_password(), msg: Ending...
DEBUG: pop_el() sub_name: decrypt_db_password(), msg: Starting...
DEBUG: pop_el() sub_name: setup_main_vars(), msg: Starting...
DEBUG: pop_el() sub_name: get_file(), msg: Ending...
DEBUG: pop_el() sub_name: get_file(), msg: Starting...
DEBUG: pop_el() sub_name: get_conf(), msg: Starting...
DEBUG: pop_el() Empty 'EL' Stack !
DEBUG: push_el() sub_name: htuser_mngr_shut_down(), msg: Starting...
DEBUG: push_el() sub_name: htuser_mngr_shut_down(), msg: Ending...

nexus:~#

[BeNe]

Which OS and MySQL Server version do you use ?

Greez BeNe

[pawouk]

Debian Etch and MySQL5 - I have followed the installation instructions in doc/etch/install

I have no clue where to look... to solve it

[joximu]

- did you change ispcp-htuser-mngr
- when does the error occur?

/J

[pawouk]

- no I dont remember changing anything in ispcp-htuser-mngr
- this occurs when I run it manualy from the bash