migration error

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:

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:

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 ...

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 ....

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]

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 ...