ispCP - Board - Support
./ispcp-htuser-mngr error with mysql - Printable Version

+- ispCP - Board - Support (http://www.isp-control.net/forum)
+-- Forum: ispCP Omega Support Area (/forum-30.html)
+--- Forum: System Setup & Installation (/forum-32.html)
+--- Thread: ./ispcp-htuser-mngr error with mysql (/thread-1731.html)



./ispcp-htuser-mngr error with mysql - pawouk - 11-07-2007 04:58 AM

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:~#



RE: ./ispcp-htuser-mngr error with mysql - BeNe - 11-07-2007 05:13 AM

Which OS and MySQL Server version do you use ?

Greez BeNe


RE: ./ispcp-htuser-mngr error with mysql - pawouk - 11-07-2007 05:25 AM

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

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


RE: ./ispcp-htuser-mngr error with mysql - joximu - 11-07-2007 06:19 AM

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

/J


RE: ./ispcp-htuser-mngr error with mysql - pawouk - 11-07-2007 09:00 AM

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