View Single Post
  #8  
Old 6th February 2008, 08:56
dactor dactor is offline
Junior Member
 
Join Date: Jan 2008
Posts: 21
Thanks: 1
Thanked 0 Times in 0 Posts
Default

Thanks, for your reply.

I have checked all tables in the database to find the below errors. Then repaided the DB yet still get the below errors!! is this relevant!!

Problems with indexes of table `del_status`
PRIMARY and INDEX keys should not both be set for column `id`
Problems with indexes of table `dns_nodes`
PRIMARY and INDEX keys should not both be set for column `tree_id`
Problems with indexes of table `doctype`
PRIMARY and INDEX keys should not both be set for column `doctype_id`
Problems with indexes of table `groups`
PRIMARY and INDEX keys should not both be set for column `groupid`
Problems with indexes of table `help_documents`
PRIMARY and INDEX keys should not both be set for column `doc_id`
Problems with indexes of table `help_nodes`
PRIMARY and INDEX keys should not both be set for column `tree_id`
Problems with indexes of table `isp_dep`
PRIMARY and INDEX keys should not both be set for column `dep_id`
Problems with indexes of table `isp_fakt_dep`
PRIMARY and INDEX keys should not both be set for column `dep_id`
Problems with indexes of table `isp_fakt_nodes`
PRIMARY and INDEX keys should not both be set for column `tree_id`
Problems with indexes of table `isp_htaccess`
PRIMARY and INDEX keys should not both be set for column `doc_id`
Problems with indexes of table `isp_nodes`
PRIMARY and INDEX keys should not both be set for column `tree_id`
Problems with indexes of table `isp_server_ip`
PRIMARY and INDEX keys should not both be set for column `doc_id`
Problems with indexes of table `isp_traffic`
PRIMARY and INDEX keys should not both be set for column `doc_id`
Problems with indexes of table `listtype`
PRIMARY and INDEX keys should not both be set for column `listtype_id`
Problems with indexes of table `login`
PRIMARY and INDEX keys should not both be set for column `login_id`
Problems with indexes of table `multidoc_dep`
PRIMARY and INDEX keys should not both be set for column `dep_id`
Problems with indexes of table `multidoc_nodes`
PRIMARY and INDEX keys should not both be set for column `tree_id`
Problems with indexes of table `session`
PRIMARY and INDEX keys should not both be set for column `id`
Problems with indexes of table `sys_dep`
PRIMARY and INDEX keys should not both be set for column `dep_id`
Problems with indexes of table `sys_modules`
PRIMARY and INDEX keys should not both be set for column `doc_id`
Problems with indexes of table `sys_news`
PRIMARY and INDEX keys should not both be set for column `doc_id`
Problems with indexes of table `sys_nodes`
PRIMARY and INDEX keys should not both be set for column `tree_id`
Problems with indexes of table `sys_user`
PRIMARY and INDEX keys should not both be set for column `doc_id`
Problems with indexes of table `user_groups`
PRIMARY and INDEX keys should not both be set for column `usergroupid`


on the other hand, the result of the code SELECT * FROM isp_server; is:

doc_id 1
doctype_id 1010
server_host www
server_domain li7-94.members.linode.com
server_ip 64.62.231.94
server_netzmaske 255.255.255.0
server_sprache de
server_db_type mysql
server_db_user
server_db_passwort
server_path_httpd_conf /etc/apache2
server_path_httpd_root /var/www
server_httpd_user www-data
server_httpd_group www-data
server_path_frontpage /usr/local/frontpage/version5.0/bin/owsadm.exe
server_path_httpd_error /home/admispconfig/ispconfig/web/multidoc/edit
server_name Server 1
server_mta postfix
server_sendmail_virtuser_datei /etc/postfix/virtusertable
server_sendmail_cw /etc/postfix/local-host-names
server_ftp_typ proftpd
server_proftpd_conf_datei /etc/proftpd.conf
server_proftpd_log /var/log/xferlog
server_bind_user root
server_bind_group root
server_bind_named_conf /etc/bind/named.conf
server_bind_zonefile_dir /etc/bind
userid_von 10000
groupid_von 10000
passwd_datei /etc/passwd
group_datei /etc/group
server_ipliste
shadow_datei /etc/shadow
server_bind_ns1_default li7-94.members.linode.com
server_bind_ns2_default li7-94.members.linode.com
server_path_httpd_log /var/log/httpd/ispconfig_access_log
server_soap_ip
server_soap_port
server_soap_encoding
server_admin_email admin@li7-94.members.linode.com
server_bind_standard_mx 0
server_bind_adminmail_default root@localhost
server_mail_log_save 0
server_ftp_log_save 0
server_httpd_suexec 0
dist debianlenny/sid0
dist_init_scripts /etc/init.d
dist_runlevel /etc
dist_smrsh /home/admispconfig/ispconfig/web/multidoc/edit
dist_shells /etc/shells
dist_bind_init_script bind9
dist_bind_pidfile /var/run/bind/run/named.pid
dist_bind_hintfile db.root
dist_bind_localfile db.local
dist_cron_daemon cron
dist_cron_tab /var/spool/cron/crontabs/root
dist_mysql_group mysql
dist_httpd_daemon apache2
dist_pop3
dist_pop3_version
dist_ftp_version standalone
dist_httpd_conf /etc/apache2/apache2.conf
dist_mail_log /var/log/mail.log
use_maildir 1
virusadmin admispconfig@localhost
spamfilter_enable 1
server_enable_frontpage 1
client_salutatory_email_sender_email NULL
client_salutatory_email_sender_name NULL
client_salutatory_email_bcc NULL
client_salutatory_email_subject NULL
client_salutatory_email_message NULL
res_salutatory_email_sender_email NULL
res_salutatory_email_sender_name NULL
res_salutatory_email_bcc NULL
res_salutatory_email_subject NULL
res_salutatory_email_message NULL
standard_index NULL
user_standard_index NULL
traffic_suspension_sender_email NULL
traffic_suspension_sender_name NULL
traffic_suspension_email_bcc NULL
traffic_suspension_email_subject NULL
traffic_suspension_email_message NULL
traffic_notification_sender_email NULL
traffic_notification_sender_name NULL
traffic_notification_email_bcc NULL
traffic_notification_email_subject NULL
traffic_notification_email_message NULL
res_traffic_suspension_sender_email NULL
res_traffic_suspension_sender_name NULL
res_traffic_suspension_email_bcc NULL
res_traffic_suspension_email_subject NULL
res_traffic_suspension_email_message NULL
res_traffic_notification_sender_email NULL
res_traffic_notification_sender_name NULL
res_traffic_notification_email_bcc NULL
res_traffic_notification_email_subject NULL
res_traffic_notification_email_message NULL


thanks again....we are really struggling as we cant administer the ISP anymore!!
Reply With Quote