Current time: 11-23-2024, 06:54 AM Hello There, Guest! (LoginRegister)


Post Reply 
Change ip don't working
Author Message
sfera Offline
Junior Member
*

Posts: 129
Joined: Oct 2008
Reputation: 0
Post: #1
Change ip don't working
Hi i try change the ip using the how to in debian 5 but i have a error
Code:
ServerWeb:/var/www/virtual# /etc/init.d/ispcp_daemon stop
Stopping ispCP GUI-Backend communication Daemon: ispcp_daemon.
ServerWeb:/var/www/virtual# mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 66
Server version: 5.0.51a-24+lenny4 (Debian)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> USE ispcp;
Database changed
mysql> UPDATE server_ips SET ip_number = "87.98.230.131" WHERE ip_id = 1;
Query OK, 0 rows affected (0.05 sec)
Rows matched: 1  Changed: 0  Warnings: 0

mysql> UPDATE `domain` SET `domain_status` = 'change' WHERE `domain_status` = 'ok';
Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

mysql> UPDATE `subdomain` SET `subdomain_status` = 'change' WHERE `subdomain_status` = 'ok';
Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

mysql> UPDATE `domain_aliasses` SET `alias_status` = 'change' WHERE `alias_status` = 'ok';
Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

mysql> UPDATE mail_users SET status="toadd" where status="ok";
ERROR 1017 (HY000): Can't find file: './ispcp/mail_users.frm' (errno: 13)
mysql> quit
Bye
ServerWeb:/var/www/virtual# /var/www/ispcp/engine/ispcp-rqst-mngr
DEBUG: push_el() sub_name: mngr_start_up(), msg: Starting...
DEBUG: push_el() sub_name: lock_system(), msg: Starting...
DEBUG: push_el() sub_name: lock_system(), 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: mngr_start_up(), msg: Ending...
DEBUG: push_el() sub_name: mngr_engine(), msg: Starting...
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: ERROR: Incorrect SQL Query -> Can't find file: './ispcp/mail_users.frm' (errno: 13)
Can't use string ("") as an ARRAY ref while "strict refs" in use at /var/www/ispcp/engine/ispcp-rqst-mngr line 183.

Any idea?

ÇThx in advanced.
07-09-2010 11:52 PM
Find all posts by this user Quote this message in a reply
BeNe Offline
Moderator
*****
Moderators

Posts: 5,899
Joined: Jan 2007
Reputation: 68
Post: #2
RE: Change ip don't working
Quote:Can't find file: './ispcp/mail_users.frm'
Seems to me that you DB is corrupt.
Please check the health with the MySQL DB tools and try it again after that.

Greez BeNe
07-11-2010 06:39 PM
Visit this user's website Find all posts by this user Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 1 Guest(s)