Posts by fulltilt

habe mal alle relevanten ispcp tables geleert bis auf die Haupt Domains
also alle raus FTP, SQL user, sub und alias, htaccess usw.
es bricht wieder mit gleicher Fehlermeldung ab
scheint etwas mit der DB Struktur nicht zu stimmen ...

könnte es noch etwas mit den Sprachen zu tun haben wenn diese nicht vorhanden sind (dutch)?
Hier ist die komplette Datenbank Struktur, vieleicht fällt euch ja noch etwas auf ...

[code=php]
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Datenbank: `ispcp`
--

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `admin`
--

CREATE TABLE `admin` (
`admin_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`admin_name` varchar(200) DEFAULT NULL,
`admin_pass` varchar(200) DEFAULT NULL,
`admin_type` varchar(10) DEFAULT NULL,
`domain_created` int(10) unsigned NOT NULL DEFAULT '0',
`customer_id` varchar(200) DEFAULT '0',
`created_by` int(10) unsigned DEFAULT '0',
`fname` varchar(200) DEFAULT NULL,
`lname` varchar(200) DEFAULT NULL,
`firm` varchar(200) DEFAULT NULL,
`zip` varchar(10) DEFAULT NULL,
`city` varchar(200) DEFAULT NULL,
`state` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`country` varchar(200) DEFAULT NULL,
`email` varchar(200) DEFAULT NULL,
`phone` varchar(200) DEFAULT NULL,
`fax` varchar(200) DEFAULT NULL,
`street1` varchar(200) DEFAULT NULL,
`street2` varchar(200) DEFAULT NULL,
`uniqkey` varchar(255) DEFAULT NULL,
`gender` varchar(1) DEFAULT NULL,
`uniqkey_time` timestamp NULL DEFAULT NULL,
UNIQUE KEY `admin_id` (`admin_id`),
UNIQUE KEY `admin_name` (`admin_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=463 ;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `autoreplies_log`
--

CREATE TABLE `autoreplies_log` (
`time` datetime NOT NULL COMMENT 'Date and time of the sent autoreply',
`from` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT 'autoreply message sender',
`to` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT 'autoreply message recipient',
KEY `time` (`time`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Sent autoreplies log table';

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `auto_num`
--

CREATE TABLE `auto_num` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`msg` varchar(255) DEFAULT NULL,
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1698 ;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `config`
--

CREATE TABLE `config` (
`name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`value` longtext COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `custom_menus`
--

CREATE TABLE `custom_menus` (
`menu_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`menu_level` varchar(10) DEFAULT NULL,
`menu_name` varchar(255) DEFAULT NULL,
`menu_link` varchar(200) DEFAULT NULL,
`menu_target` varchar(200) NOT NULL DEFAULT '',
PRIMARY KEY (`menu_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `domain`
--

CREATE TABLE `domain` (
`domain_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`domain_name` varchar(200) DEFAULT NULL,
`domain_gid` int(10) unsigned NOT NULL DEFAULT '0',
`domain_uid` int(10) unsigned NOT NULL DEFAULT '0',
`domain_admin_id` int(10) unsigned NOT NULL DEFAULT '0',
`domain_created_id` int(10) unsigned NOT NULL DEFAULT '0',
`domain_created` int(10) unsigned NOT NULL DEFAULT '0',
`domain_expires` int(10) unsigned NOT NULL DEFAULT '0',
`domain_last_modified` int(10) unsigned NOT NULL DEFAULT '0',
`domain_mailacc_limit` int(11) DEFAULT NULL,
`domain_ftpacc_limit` int(11) DEFAULT NULL,
`domain_traffic_limit` bigint(20) DEFAULT NULL,
`domain_sqld_limit` int(11) DEFAULT NULL,
`domain_sqlu_limit` int(11) DEFAULT NULL,
`domain_status` varchar(255) DEFAULT NULL,
`domain_alias_limit` int(11) DEFAULT NULL,
`domain_subd_limit` int(11) DEFAULT NULL,
`domain_ip_id` int(10) unsigned DEFAULT NULL,
`domain_disk_limit` bigint(20) unsigned DEFAULT NULL,
`domain_disk_usage` bigint(20) unsigned DEFAULT NULL,
`domain_php` varchar(15) DEFAULT NULL,
`domain_cgi` varchar(15) DEFAULT NULL,
`allowbackup` varchar(8) NOT NULL DEFAULT 'full',
`domain_dns` varchar(15) NOT NULL DEFAULT 'no',
UNIQUE KEY `domain_id` (`domain_id`),
UNIQUE KEY `domain_name` (`domain_name`),
KEY `i_domain_admin_id` (`domain_admin_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=454 ;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `domain_aliasses`
--

CREATE TABLE `domain_aliasses` (
`alias_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`domain_id` int(10) unsigned DEFAULT NULL,
`alias_name` varchar(200) DEFAULT NULL,
`alias_status` varchar(255) DEFAULT NULL,
`alias_mount` varchar(200) DEFAULT NULL,
`alias_ip_id` int(10) unsigned DEFAULT NULL,
`url_forward` varchar(200) DEFAULT NULL,
PRIMARY KEY (`alias_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=314 ;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `domain_dns`
--

CREATE TABLE `domain_dns` (
`domain_dns_id` int(11) NOT NULL AUTO_INCREMENT,
`domain_id` int(11) NOT NULL,
`alias_id` int(11) NOT NULL,
`domain_dns` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
`domain_class` enum('IN','CH','HS') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'IN',
`domain_type` enum('A','AAAA','CERT','CNAME','DNAME','GPOS','KEY','KX','MX','NAPTR','NSAP','NS','NXT','PTR','PX','SIG','SRV','TXT') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'A',
`domain_text` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
`protected` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
PRIMARY KEY (`domain_dns_id`),
UNIQUE KEY `domain_id` (`domain_id`,`alias_id`,`domain_dns`,`domain_class`,`domain_type`,`domain_text`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=14 ;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `domain_traffic`
--

CREATE TABLE `domain_traffic` (
`dtraff_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`domain_id` int(10) unsigned DEFAULT NULL,
`dtraff_time` bigint(20) unsigned DEFAULT NULL,
`dtraff_web` bigint(20) unsigned DEFAULT NULL,
`dtraff_ftp` bigint(20) unsigned DEFAULT NULL,
`dtraff_mail` bigint(20) unsigned DEFAULT NULL,
`dtraff_pop` bigint(20) unsigned DEFAULT NULL,
`zt_correction` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`dtraff_id`),
KEY `i_zt_correction` (`zt_correction`),
KEY `i_domain_traffic_domain_id` (`domain_id`),
KEY `i_domain_traffic_dtraff_time` (`dtraff_time`),
KEY `i_domain_id` (`domain_id`),
KEY `i_dtraff_time` (`dtraff_time`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=193992 ;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `email_tpls`
--

CREATE TABLE `email_tpls` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`owner_id` int(10) unsigned NOT NULL DEFAULT '0',
`name` varchar(200) DEFAULT NULL,
`subject` varchar(200) DEFAULT NULL,
`message` text,
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `error_pages`
--

CREATE TABLE `error_pages` (
`ep_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(10) unsigned NOT NULL DEFAULT '0',
`error_401` text NOT NULL,
`error_403` text NOT NULL,
`error_404` text NOT NULL,
`error_500` text NOT NULL,
PRIMARY KEY (`ep_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `ftp_group`
--

CREATE TABLE `ftp_group` (
`groupname` varchar(255) DEFAULT NULL,
`gid` int(10) unsigned NOT NULL DEFAULT '0',
`members` text,
UNIQUE KEY `groupname` (`groupname`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `ftp_users`
--

CREATE TABLE `ftp_users` (
`userid` varchar(255) DEFAULT NULL,
`passwd` varchar(255) DEFAULT NULL,
`uid` int(10) unsigned NOT NULL DEFAULT '0',
`gid` int(10) unsigned NOT NULL DEFAULT '0',
`shell` varchar(255) DEFAULT NULL,
`homedir` varchar(255) DEFAULT NULL,
UNIQUE KEY `userid` (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `hosting_plans`
--

CREATE TABLE `hosting_plans` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`reseller_id` int(10) unsigned NOT NULL DEFAULT '0',
`name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`props` text COLLATE utf8_unicode_ci,
`description` text COLLATE utf8_unicode_ci,
`price` decimal(10,2) NOT NULL DEFAULT '0.00',
`setup_fee` decimal(10,2) NOT NULL DEFAULT '0.00',
`value` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`payment` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`status` int(10) unsigned NOT NULL DEFAULT '0',
`tos` blob NOT NULL,
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=62 ;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `htaccess`
--

CREATE TABLE `htaccess` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`dmn_id` int(10) unsigned NOT NULL DEFAULT '0',
`user_id` varchar(255) DEFAULT NULL,
`group_id` varchar(255) DEFAULT NULL,
`auth_type` varchar(255) DEFAULT NULL,
`auth_name` varchar(255) DEFAULT NULL,
`path` text,
`status` text,
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=178 ;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `htaccess_groups`
--

CREATE TABLE `htaccess_groups` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`dmn_id` int(10) unsigned NOT NULL DEFAULT '0',
`ugroup` varchar(255) DEFAULT NULL,
`members` text,
`status` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=415 ;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `htaccess_users`
--

CREATE TABLE `htaccess_users` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`dmn_id` int(10) unsigned NOT NULL DEFAULT '0',
`uname` varchar(255) DEFAULT NULL,
`upass` varchar(255) DEFAULT NULL,
`status` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=420 ;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `lang_Dutch`
--

CREATE TABLE `lang_Dutch` (
`msgid` text COLLATE utf8_unicode_ci,
`msgstr` text COLLATE utf8_unicode_ci,
KEY `msgid` (`msgid`(25))
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `lang_EnglishBritain`
--

CREATE TABLE `lang_EnglishBritain` (
`msgid` text COLLATE utf8_unicode_ci,
`msgstr` text COLLATE utf8_unicode_ci,
KEY `msgid` (`msgid`(25))
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `lang_FrenchFrance`
--

CREATE TABLE `lang_FrenchFrance` (
`msgid` text COLLATE utf8_unicode_ci,
`msgstr` text COLLATE utf8_unicode_ci,
KEY `msgid` (`msgid`(25))
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `lang_GermanGermany`
--

CREATE TABLE `lang_GermanGermany` (
`msgid` text COLLATE utf8_unicode_ci,
`msgstr` text COLLATE utf8_unicode_ci,
KEY `msgid` (`msgid`(25))
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `lang_ItalianItaly`
--

CREATE TABLE `lang_ItalianItaly` (
`msgid` text COLLATE utf8_unicode_ci,
`msgstr` text COLLATE utf8_unicode_ci,
KEY `msgid` (`msgid`(25))
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `lang_Portuguese`
--

CREATE TABLE `lang_Portuguese` (
`msgid` text COLLATE utf8_unicode_ci,
`msgstr` text COLLATE utf8_unicode_ci,
KEY `msgid` (`msgid`(25))
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `lang_PortuguesePortugal`
--

CREATE TABLE `lang_PortuguesePortugal` (
`msgid` text COLLATE utf8_unicode_ci,
`msgstr` text COLLATE utf8_unicode_ci,
KEY `msgid` (`msgid`(25))
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `lang_Russian`
--

CREATE TABLE `lang_Russian` (
`msgid` text COLLATE utf8_unicode_ci,
`msgstr` text COLLATE utf8_unicode_ci,
KEY `msgid` (`msgid`(25))
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `lang_SpanishSpain`
--

CREATE TABLE `lang_SpanishSpain` (
`msgid` text COLLATE utf8_unicode_ci,
`msgstr` text COLLATE utf8_unicode_ci,
KEY `msgid` (`msgid`(25))
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `log`
--

CREATE TABLE `log` (
`log_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`log_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`log_message` varchar(250) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (`log_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `login`
--

CREATE TABLE `login` (
`session_id` varchar(200) NOT NULL DEFAULT '',
`lastaccess` int(10) unsigned DEFAULT NULL,
`ipaddr` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`login_count` tinyint(1) DEFAULT '0',
`captcha_count` tinyint(1) DEFAULT '0',
`user_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (`session_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `mail_users`
--

CREATE TABLE `mail_users` (
`mail_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`mail_acc` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`mail_pass` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`mail_forward` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
`domain_id` int(10) unsigned DEFAULT NULL,
`mail_type` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`sub_id` int(10) unsigned DEFAULT NULL,
`status` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`mail_auto_respond` tinyint(1) NOT NULL DEFAULT '0',
`mail_auto_respond_text` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
`quota` int(10) DEFAULT '10485760',
`mail_addr` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (`mail_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4277 ;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `orders`
--

CREATE TABLE `orders` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(10) unsigned NOT NULL DEFAULT '0',
`plan_id` int(10) unsigned NOT NULL DEFAULT '0',
`date` int(10) unsigned NOT NULL DEFAULT '0',
`domain_name` varchar(200) DEFAULT NULL,
`customer_id` varchar(200) DEFAULT NULL,
`fname` varchar(200) DEFAULT NULL,
`lname` varchar(200) DEFAULT NULL,
`firm` varchar(200) DEFAULT NULL,
`zip` varchar(10) DEFAULT NULL,
`city` varchar(200) DEFAULT NULL,
`state` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`country` varchar(200) DEFAULT NULL,
`email` varchar(200) DEFAULT NULL,
`phone` varchar(200) DEFAULT NULL,
`fax` varchar(200) DEFAULT NULL,
`street1` varchar(200) DEFAULT NULL,
`street2` varchar(200) DEFAULT NULL,
`status` varchar(255) DEFAULT NULL,
`gender` varchar(1) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=482 ;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `orders_settings`
--

CREATE TABLE `orders_settings` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(10) unsigned NOT NULL DEFAULT '0',
`header` text,
`footer` text,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `quotalimits`
--

CREATE TABLE `quotalimits` (
`name` varchar(30) NOT NULL DEFAULT '',
`quota_type` enum('user','group','class','all') NOT NULL DEFAULT 'user',
`per_session` enum('false','true') NOT NULL DEFAULT 'false',
`limit_type` enum('soft','hard') NOT NULL DEFAULT 'soft',
`bytes_in_avail` float NOT NULL DEFAULT '0',
`bytes_out_avail` float NOT NULL DEFAULT '0',
`bytes_xfer_avail` float NOT NULL DEFAULT '0',
`files_in_avail` int(10) unsigned NOT NULL DEFAULT '0',
`files_out_avail` int(10) unsigned NOT NULL DEFAULT '0',
`files_xfer_avail` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `quotatallies`
--

CREATE TABLE `quotatallies` (
`name` varchar(30) NOT NULL DEFAULT '',
`quota_type` enum('user','group','class','all') NOT NULL DEFAULT 'user',
`bytes_in_used` float NOT NULL DEFAULT '0',
`bytes_out_used` float NOT NULL DEFAULT '0',
`bytes_xfer_used` float NOT NULL DEFAULT '0',
`files_in_used` int(10) unsigned NOT NULL DEFAULT '0',
`files_out_used` int(10) unsigned NOT NULL DEFAULT '0',
`files_xfer_used` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `reseller_props`
--

CREATE TABLE `reseller_props` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`reseller_id` int(10) unsigned NOT NULL DEFAULT '0',
`current_dmn_cnt` int(11) DEFAULT NULL,
`max_dmn_cnt` int(11) DEFAULT NULL,
`current_sub_cnt` int(11) DEFAULT NULL,
`max_sub_cnt` int(11) DEFAULT NULL,
`current_als_cnt` int(11) DEFAULT NULL,
`max_als_cnt` int(11) DEFAULT NULL,
`current_mail_cnt` int(11) DEFAULT NULL,
`max_mail_cnt` int(11) DEFAULT NULL,
`current_ftp_cnt` int(11) DEFAULT NULL,
`max_ftp_cnt` int(11) DEFAULT NULL,
`current_sql_db_cnt` int(11) DEFAULT NULL,
`max_sql_db_cnt` int(11) DEFAULT NULL,
`current_sql_user_cnt` int(11) DEFAULT NULL,
`max_sql_user_cnt` int(11) DEFAULT NULL,
`current_disk_amnt` int(11) DEFAULT NULL,
`max_disk_amnt` int(11) DEFAULT NULL,
`current_traff_amnt` int(11) DEFAULT NULL,
`max_traff_amnt` int(11) DEFAULT NULL,
`support_system` enum('yes','no') NOT NULL DEFAULT 'yes',
`customer_id` varchar(200) DEFAULT NULL,
`reseller_ips` text,
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `server_ips`
--

CREATE TABLE `server_ips` (
`ip_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`ip_number` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`ip_domain` varchar(200) DEFAULT NULL,
`ip_alias` varchar(200) DEFAULT NULL,
`ip_card` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`ip_ssl_domain_id` int(10) DEFAULT NULL,
`ip_status` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
UNIQUE KEY `ip_id` (`ip_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `server_traffic`
--

CREATE TABLE `server_traffic` (
`straff_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`traff_time` bigint(20) unsigned DEFAULT NULL,
`bytes_in` bigint(20) unsigned DEFAULT NULL,
`bytes_out` bigint(20) unsigned DEFAULT NULL,
`bytes_mail_in` bigint(20) unsigned DEFAULT NULL,
`bytes_mail_out` bigint(20) unsigned DEFAULT NULL,
`bytes_pop_in` bigint(20) unsigned DEFAULT NULL,
`bytes_pop_out` bigint(20) unsigned DEFAULT NULL,
`bytes_web_in` bigint(20) unsigned DEFAULT NULL,
`bytes_web_out` bigint(20) unsigned DEFAULT NULL,
`zt_correction` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`straff_id`),
KEY `i_zt_correction` (`zt_correction`),
KEY `i_server_traffic_traff_time` (`traff_time`),
KEY `i_traff_time` (`traff_time`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=36506 ;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `sql_database`
--

CREATE TABLE `sql_database` (
`sqld_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`domain_id` int(10) unsigned DEFAULT '0',
`sqld_name` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT 'n/a',
UNIQUE KEY `sqld_id` (`sqld_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=874 ;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `sql_user`
--

CREATE TABLE `sql_user` (
`sqlu_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`sqld_id` int(10) unsigned DEFAULT '0',
`sqlu_name` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT 'n/a',
`sqlu_pass` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT 'n/a',
UNIQUE KEY `sqlu_id` (`sqlu_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=986 ;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `straff_settings`
--

CREATE TABLE `straff_settings` (
`straff_max` int(10) unsigned DEFAULT NULL,
`straff_warn` int(10) unsigned DEFAULT NULL,
`straff_email` int(10) unsigned DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `subdomain`
--

CREATE TABLE `subdomain` (
`subdomain_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`domain_id` int(10) unsigned DEFAULT NULL,
`subdomain_name` varchar(200) DEFAULT NULL,
`subdomain_mount` varchar(200) DEFAULT NULL,
`subdomain_url_forward` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`subdomain_status` varchar(255) DEFAULT NULL,
PRIMARY KEY (`subdomain_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=337 ;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `subdomain_alias`
--

CREATE TABLE `subdomain_alias` (
`subdomain_alias_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`alias_id` int(10) unsigned DEFAULT NULL,
`subdomain_alias_name` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
`subdomain_alias_mount` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
`subdomain_alias_url_forward` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
`subdomain_alias_status` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (`subdomain_alias_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=44 ;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `suexec_props`
--

CREATE TABLE `suexec_props` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`uid` int(10) unsigned DEFAULT NULL,
`gid` int(10) unsigned DEFAULT NULL,
`usr` varchar(255) DEFAULT NULL,
`grp` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `tickets`
--

CREATE TABLE `tickets` (
`ticket_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`ticket_level` int(10) DEFAULT NULL,
`ticket_from` int(10) unsigned DEFAULT NULL,
`ticket_to` int(10) unsigned DEFAULT NULL,
`ticket_status` int(10) unsigned DEFAULT NULL,
`ticket_reply` int(10) unsigned DEFAULT NULL,
`ticket_urgency` int(10) unsigned DEFAULT NULL,
`ticket_date` int(10) unsigned DEFAULT NULL,
`ticket_subject` varchar(255) DEFAULT NULL,
`ticket_message` text,
PRIMARY KEY (`ticket_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=51 ;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `user_gui_props`
--

CREATE TABLE `user_gui_props` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(10) unsigned NOT NULL DEFAULT '0',
`lang` varchar(255) DEFAULT '',
`layout` varchar(255) DEFAULT '',
`logo` varchar(255) NOT NULL DEFAULT '0',
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=528 ;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
[/php]

could you please give us some more details on this issue ...
which steps you perfomed?

danke euch
hier gabs schon mal so was:
http://forum.i-mscp.net/Thread-Migration-from-ISPCP-1-1-0

ich versuche morgen noch einmal mein glück ...
werde mal nach und nach verschiedene ispcp tables leeren und fange mal an mit den htaccess users und group ...
es ist glaube ich auch noch eine umlaut domain drauf, könnte auch noch in frage kommen ....

schau mal wie gross in MB oder eventl. GB die Logfiles sind ...
da könnte ein Web dabei sein was riesige logfiles produziert

aaaarg
no chance, I tested again with a ext3 server, 8GB Ram ...
after migrating ispcp the debug panel info shows that everything is OK
IMSCP migration > installation:
error while step 6 from imscp installation:

seems to be a bug ...

problem still exists ...
now I tested migration from ispcp with a v-server (real IP, 4GB)
the database dump is about 700 MB ...
the original ispcp server is using innodb, I did not change this my.cnf settings from original on v-server before ...
also ispcp uses roundcube but I have deleted the roundcube DB and user before migrating to imscp
also some special signs used in mysqp password like - + #
anyone please could help me to solve this problem?

this is the error msg from imscp-setup.log

[hr]

another try with same my.cnf as original and changed mysql password without +-# signs

[hr]
another try with git master:

Quote from tma

es freut mich zu lesen das Sie unsere DNS Services nutzen. Nicht schön, dass Sie damit Probleme haben.
Ich würde mich freuen, wenn wir hier eine Lösung finden. Am besten sprechen Sie mich direkt an (tm@dogado.de), gerne stehe ich jederzeit zur Verfügung.

Danke, momentan scheint alles wieder zu klappen.
Ich bin sehr zufrieden mit der GUI, der Domainrobot und die DNS Verwaltung ist sehr gut und alles ist gut zu handhaben.
Was nicht so gut ist dass in letzter Zeit öfter NS nicht erreichbar waren, wenn das Problem jetzt gelöst werden konnte, gibt es nichts mehr zu meckern

ich teste hier gerade eine Migration ispcp > IMSCP in einer V-BOX 2GB ram
die Installation bricht mit einem PHP Fehler ab ...
liegt das daran das zu wenig Ram vorhanden ist?
Die VM verwendet ausserdem eine lokale IP 129.168.0.33

Hier die Fehlermeldung:

kann jemand einen guten DNS service Anbieter empfehlen?
Momentan laufen alle NS über das Dogado DNS Panel, ist eigentlich nicht schlecht wegen der Template Verwaltung für verschiedene Server ...
allerdings gibt es in letzter Zeit zu viele Ausfälle und da ich keine eigenen NS verwende würde ich gerne schnellstmöglich wechseln ...