Menu

#18 Errors occures while installing AccountLab

open
nobody
5
2015-02-09
2012-12-31
Anonymous
No

When i try to install AccountLab got this error:

==========================================
Errors occured while upgrade
==========================================
SQL:"ALTER TABLE `order_conf` ADD `u_invoice_date` INT( 3 ) NOT NULL DEFAULT '90'";
MYSQL ERROR : 1146: Table 'kassit_acclab.order_conf' doesn't exist
SQL:"ALTER TABLE `order_conf` ADD `build` INT( 11 ) NOT NULL DEFAULT '1' ";
MYSQL ERROR : 1146: Table 'kassit_acclab.order_conf' doesn't exist
SQL:"ALTER TABLE `order_conf` ADD `ask_login_info` ENUM( '1', '0' ) NOT NULL ";
MYSQL ERROR : 1146: Table 'kassit_acclab.order_conf' doesn't exist
SQL:"ALTER TABLE `sub_order` ADD `cat_id` INT( 11 ) NOT NULL DEFAULT '1' AFTER `parent_id`";
MYSQL ERROR : 1146: Table 'kassit_acclab.sub_order' doesn't exist
SQL:"ALTER TABLE `tax` CHANGE `tax_amount` `tax_amount` DECIMAL( 4, 2 ) NOT NULL DEFAULT '0.00'";
MYSQL ERROR : 1146: Table 'kassit_acclab.tax' doesn't exist
SQL:"ALTER TABLE `customers` ADD `creation_date` DATE NOT NULL";
MYSQL ERROR : 1146: Table 'kassit_acclab.customers' doesn't exist
SQL:"UPDATE order_conf SET `build`='2'";
MYSQL ERROR : 1146: Table 'kassit_acclab.order_conf' doesn't exist
SQL:" CREATE TABLE `extra_fields` ( `field_id` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY , `cust_id` INT( 11 ) NOT NULL , `sub_id` INT( 11 ) NOT NULL , `inv_no` INT( 11 ) NOT NULL ) TYPE = MyISAM";
MYSQL ERROR : 1064: 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 'TYPE = MyISAM' at line 8
SQL:"ALTER TABLE `customers` CHANGE `discount` `discount` DECIMAL( 4, 2 ) NOT NULL DEFAULT '0.00'";
MYSQL ERROR : 1146: Table 'kassit_acclab.customers' doesn't exist
SQL:"ALTER TABLE `payment_log` ADD `posted_vars` TEXT NOT NULL";
MYSQL ERROR : 1146: Table 'kassit_acclab.payment_log' doesn't exist
SQL:"ALTER TABLE `payment_log` ADD `payment_method` VARCHAR( 25 ) NOT NULL";
MYSQL ERROR : 1146: Table 'kassit_acclab.payment_log' doesn't exist
SQL:"ALTER TABLE `order_conf` ADD `en_html_editor` ENUM( '1', '0' ) NOT NULL DEFAULT '1'";
MYSQL ERROR : 1146: Table 'kassit_acclab.order_conf' doesn't exist
SQL:"ALTER TABLE `invoices` CHANGE `transaction_id` `transaction_id` VARCHAR( 255 ) NOT NULL DEFAULT '0'";
MYSQL ERROR : 1146: Table 'kassit_acclab.invoices' doesn't exist
SQL:"UPDATE order_conf SET `build`='3'";
MYSQL ERROR : 1146: Table 'kassit_acclab.order_conf' doesn't exist
SQL:"ALTER TABLE `hosting_price` ADD `plan_friendly_name` VARCHAR( 255 ) NOT NULL";
MYSQL ERROR : 1146: Table 'kassit_acclab.hosting_price' doesn't exist
SQL:"ALTER TABLE `hosting_price` ADD `activation_mail_template` TEXT NOT NULL";
MYSQL ERROR : 1146: Table 'kassit_acclab.hosting_price' doesn't exist
SQL:"ALTER TABLE `hosting_price` ADD `suspended_mail_template` TEXT NOT NULL";
MYSQL ERROR : 1146: Table 'kassit_acclab.hosting_price' doesn't exist
SQL:"ALTER TABLE `hosting_price` ADD `cpanel_reseller` ENUM( '0', '1' ) NOT NULL";
MYSQL ERROR : 1146: Table 'kassit_acclab.hosting_price' doesn't exist
SQL:"ALTER TABLE `hosting_price` ADD `cpr_profile_id` INT( 11 ) NOT NULL";
MYSQL ERROR : 1146: Table 'kassit_acclab.hosting_price' doesn't exist
SQL:"ALTER TABLE `hosting_price` ADD `plesk_profile_id` INT( 11 ) NOT NULL";
MYSQL ERROR : 1146: Table 'kassit_acclab.hosting_price' doesn't exist
SQL:"ALTER TABLE `hosting_price` ADD `cip` ENUM( '0', '1' ) NOT NULL";
MYSQL ERROR : 1146: Table 'kassit_acclab.hosting_price' doesn't exist
SQL:"ALTER TABLE `hosting_price` ADD `cgi` ENUM( '0', '1' ) NOT NULL";
MYSQL ERROR : 1146: Table 'kassit_acclab.hosting_price' doesn't exist
SQL:"ALTER TABLE `hosting_price` ADD `quota` VARCHAR( 11 ) NOT NULL";
MYSQL ERROR : 1146: Table 'kassit_acclab.hosting_price' doesn't exist
SQL:"ALTER TABLE `hosting_price` ADD `frontpage` ENUM( '0', '1' ) NOT NULL";
MYSQL ERROR : 1146: Table 'kassit_acclab.hosting_price' doesn't exist
SQL:"ALTER TABLE `hosting_price` ADD `cp` VARCHAR( 25 ) NOT NULL";
MYSQL ERROR : 1146: Table 'kassit_acclab.hosting_price' doesn't exist
SQL:"ALTER TABLE `hosting_price` ADD `maxftp` VARCHAR( 11 ) NOT NULL";
MYSQL ERROR : 1146: Table 'kassit_acclab.hosting_price' doesn't exist
SQL:"ALTER TABLE `hosting_price` ADD `maxsql` VARCHAR( 11 ) NOT NULL";
MYSQL ERROR : 1146: Table 'kassit_acclab.hosting_price' doesn't exist
SQL:"ALTER TABLE `hosting_price` ADD `maxpop` VARCHAR( 11 ) NOT NULL";
MYSQL ERROR : 1146: Table 'kassit_acclab.hosting_price' doesn't exist
SQL:"ALTER TABLE `hosting_price` ADD `maxlst` VARCHAR( 11 ) NOT NULL";
MYSQL ERROR : 1146: Table 'kassit_acclab.hosting_price' doesn't exist
SQL:"ALTER TABLE `hosting_price` ADD `maxsub` VARCHAR( 11 ) NOT NULL";
MYSQL ERROR : 1146: Table 'kassit_acclab.hosting_price' doesn't exist
SQL:"ALTER TABLE `hosting_price` ADD `bwlimit` VARCHAR( 11 ) NOT NULL";
MYSQL ERROR : 1146: Table 'kassit_acclab.hosting_price' doesn't exist
SQL:"ALTER TABLE `hosting_price` ADD `hasshell` ENUM( '0', '1' ) NOT NULL";
MYSQL ERROR : 1146: Table 'kassit_acclab.hosting_price' doesn't exist
SQL:"ALTER TABLE `hosting_price` ADD `maxpark` VARCHAR( 11 ) NOT NULL";
MYSQL ERROR : 1146: Table 'kassit_acclab.hosting_price' doesn't exist
SQL:"ALTER TABLE `hosting_price` ADD `maxaddon` VARCHAR( 11 ) NOT NULL";
MYSQL ERROR : 1146: Table 'kassit_acclab.hosting_price' doesn't exist
SQL:"ALTER TABLE `hosting_price` ADD `da_reseller` ENUM( '0', '1', '2', '3' ) NOT NULL";
MYSQL ERROR : 1146: Table 'kassit_acclab.hosting_price' doesn't exist
SQL:"ALTER TABLE `servers` ADD `server_pass` LONGTEXT NOT NULL AFTER `server_user`";
MYSQL ERROR : 1146: Table 'kassit_acclab.servers' doesn't exist
SQL:" CREATE TABLE `cpanel_reseller_profiles` ( `cpr_profile_id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY , `limit_type` ENUM( '0', '1', '2' ) NOT NULL , `resnumlimitamt` INT NOT NULL , `rslimit_disk` INT NOT NULL , `rsolimit_disk` ENUM( '0', '1' ) NOT NULL , `rslimit_bw` INT NOT NULL , `rsolimit_bw` ENUM( '0', '1' ) NOT NULL , `edit_ns` ENUM( '0', '1' ) NOT NULL , `acl_allow_unlimited_disk_pkgs` ENUM( '0', '1' ) NOT NULL , `acl_allow_unlimited_pkgs` ENUM( '0', '1' ) NOT NULL , `acl_edit_pkg` ENUM( '0', '1' ) NOT NULL , `acl_create_acct` ENUM( '0', '1' ) NOT NULL , `acl_edit_account` ENUM( '0', '1' ) NOT NULL , `acl_suspend_acct` ENUM( '0', '1' ) NOT NULL , `acl_kill_acct` ENUM( '0', '1' ) NOT NULL , `acl_upgrade_account` ENUM( '0', '1' ) NOT NULL , `acl_create_dns` ENUM( '0', '1' ) NOT NULL , `acl_add_pkg` ENUM( '0', '1' ) NOT NULL , `acl_all` ENUM( '0', '1' ) NOT NULL , `acl_add_pkg_shell` ENUM( '0', '1' ) NOT NULL , `acl_add_pkg_ip` ENUM( '0', '1' ) NOT NULL , `acl_allow_addoncreate` ENUM( '0', '1' ) NOT NULL , `acl_allow_parkedcreate` ENUM( '0', '1' ) NOT NULL , `acl_limit_bandwidth` ENUM( '0', '1' ) NOT NULL , `acl_clustering` ENUM( '0', '1' ) NOT NULL , `acl_kill_dns` ENUM( '0', '1' ) NOT NULL , `acl_onlyselfandglobalpkgs` ENUM( '0', '1' ) NOT NULL , `acl_edit_dns` ENUM( '0', '1' ) NOT NULL , `acl_edit_mx` ENUM( '0', '1' ) NOT NULL , `acl_frontpage` ENUM( '0', '1' ) NOT NULL , `acl_ssl` ENUM( '0', '1' ) NOT NULL , `acl_mod_subdomains` ENUM( '0', '1' ) NOT NULL , `acl_list_accts` ENUM( '0', '1' ) NOT NULL , `acl_mailcheck` ENUM( '0', '1' ) NOT NULL , `acl_disallow_shell` ENUM( '0', '1' ) NOT NULL , `acl_news` ENUM( '0', '1' ) NOT NULL , `acl_park_dns` ENUM( '0', '1' ) NOT NULL , `acl_passwd` ENUM( '0', '1' ) NOT NULL , `acl_quota` ENUM( '0', '1' ) NOT NULL , `acl_rearrange_accts` ENUM( '0', '1' ) NOT NULL , `acl_res_cart` ENUM( '0', '1' ) NOT NULL , `acl_restart` ENUM( '0', '1' ) NOT NULL , `acl_resftp` ENUM( '0', '1' ) NOT NULL , `acl_demo_setup` ENUM( '0', '1' ) NOT NULL , `acl_show_bandwidth` ENUM( '0', '1' ) NOT NULL , `acl_stats` ENUM( '0', '1' ) NOT NULL , `acl_status` ENUM( '0', '1' ) NOT NULL ) TYPE = MyISAM";
MYSQL ERROR : 1064: 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 'TYPE = MyISAM' at line 51
SQL:" CREATE TABLE `plesk_ids` ( `cust_id` INT( 11 ) NOT NULL , `plesk_id` INT( 11 ) NOT NULL ) TYPE = MyISAM";
MYSQL ERROR : 1064: 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 'TYPE = MyISAM' at line 6
SQL:" CREATE TABLE `plesk_profiles` ( `plesk_profile_id` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY , `create_domains` ENUM( '0', '1' ) NOT NULL , `manage_phosting` ENUM( '0', '1' ) NOT NULL , `manage_quota` ENUM( '0', '1' ) NOT NULL , `manage_subdomains` ENUM( '0', '1' ) NOT NULL , `manage_not_chroot_shell` ENUM( '0', '1' ) NOT NULL , `change_limits` ENUM( '0', '1' ) NOT NULL , `manage_dns` ENUM( '0', '1' ) NOT NULL , `manage_log` ENUM( '0', '1' ) NOT NULL , `manage_crontab` ENUM( '0', '1' ) NOT NULL , `manage_anonftp` ENUM( '0', '1' ) NOT NULL , `manage_webapps` ENUM( '0', '1' ) NOT NULL , `manage_sh_access` ENUM( '0', '1' ) NOT NULL , `manage_maillists` ENUM( '0', '1' ) NOT NULL , `manage_drweb` ENUM( '0', '1' ) NOT NULL , `make_dumps` ENUM( '0', '1' ) NOT NULL , `site_builder` ENUM( '0', '1' ) NOT NULL ) TYPE = MyISAM";
MYSQL ERROR : 1064: 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 'TYPE = MyISAM' at line 21
SQL:" CREATE TABLE `ord_inv_rec` ( `rec_ord_id` INT( 11 ) NOT NULL , `rec_next_date` DATE NOT NULL DEFAULT '0000-00-00' ) TYPE = MyISAM";
MYSQL ERROR : 1064: 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 'TYPE = MyISAM' at line 6
SQL:"ALTER TABLE `ord_inv_rec` ADD UNIQUE ( `rec_ord_id` )";
MYSQL ERROR : 1146: Table 'kassit_acclab.ord_inv_rec' doesn't exist
SQL:"ALTER TABLE `order_server_ip` CHANGE `acct_status` `acct_status` ENUM( '0', '1', '2', '3' ) NOT NULL DEFAULT '0'";
MYSQL ERROR : 1146: Table 'kassit_acclab.order_server_ip' doesn't exist
SQL:"UPDATE order_conf SET `build`='4'";
MYSQL ERROR : 1146: Table 'kassit_acclab.order_conf' doesn't exist
SQL:"ALTER TABLE `order_conf` ADD `emailer` ENUM( 'mail', 'sendmail', 'smtp' ) NOT NULL";
MYSQL ERROR : 1146: Table 'kassit_acclab.order_conf' doesn't exist
SQL:"ALTER TABLE `order_conf` ADD `email_priority` ENUM( '1','3','5' ) NOT NULL";
MYSQL ERROR : 1146: Table 'kassit_acclab.order_conf' doesn't exist
SQL:"ALTER TABLE `order_conf` ADD `email_charset` VARCHAR( 15 ) NOT NULL";
MYSQL ERROR : 1146: Table 'kassit_acclab.order_conf' doesn't exist
SQL:"ALTER TABLE `order_conf` ADD `email_content_type` VARCHAR( 15 ) NOT NULL";
MYSQL ERROR : 1146: Table 'kassit_acclab.order_conf' doesn't exist
SQL:"ALTER TABLE `order_conf` ADD `email_encoding` ENUM( '8bit', '7bit', 'binary', 'base64', 'quoted-printable' ) NOT NULL";
MYSQL ERROR : 1146: Table 'kassit_acclab.order_conf' doesn't exist
SQL:"ALTER TABLE `order_conf` ADD `email_wordwrap` INT( 3 ) NOT NULL DEFAULT '0'";
MYSQL ERROR : 1146: Table 'kassit_acclab.order_conf' doesn't exist
SQL:"ALTER TABLE `order_conf` ADD `email_sender` VARCHAR( 255 ) NOT NULL";
MYSQL ERROR : 1146: Table 'kassit_acclab.order_conf' doesn't exist
SQL:"ALTER TABLE `order_conf` ADD `sendmail_path` VARCHAR( 255 ) NOT NULL";
MYSQL ERROR : 1146: Table 'kassit_acclab.order_conf' doesn't exist
SQL:"ALTER TABLE `order_conf` ADD `reading_confirm` VARCHAR( 255 ) NOT NULL";
MYSQL ERROR : 1146: Table 'kassit_acclab.order_conf' doesn't exist
SQL:"ALTER TABLE `order_conf` ADD `smtp_host` VARCHAR( 255 ) NOT NULL";
MYSQL ERROR : 1146: Table 'kassit_acclab.order_conf' doesn't exist
SQL:"ALTER TABLE `order_conf` ADD `smtp_port` INT( 10 ) NOT NULL";
MYSQL ERROR : 1146: Table 'kassit_acclab.order_conf' doesn't exist
SQL:"ALTER TABLE `order_conf` ADD `smtp_auth` ENUM( '0', '1' ) NOT NULL";
MYSQL ERROR : 1146: Table 'kassit_acclab.order_conf' doesn't exist
SQL:"ALTER TABLE `order_conf` ADD `smtp_user` VARCHAR( 255 ) NOT NULL";
MYSQL ERROR : 1146: Table 'kassit_acclab.order_conf' doesn't exist
SQL:"ALTER TABLE `order_conf` ADD `smtp_pass` VARCHAR( 255 ) NOT NULL";
MYSQL ERROR : 1146: Table 'kassit_acclab.order_conf' doesn't exist
SQL:" CREATE TABLE IF NOT EXISTS `registerfly` ( `registerfly_id` MEDIUMINT(8) NOT NULL AUTO_INCREMENT PRIMARY KEY , `registerfly_uid` VARCHAR(255) NOT NULL , `registerfly_pw` VARCHAR(255) NOT NULL , `registerfly_active` VARCHAR(10) NOT NULL , `registerfly_test_mode` VARCHAR(255) NOT NULL ) TYPE = MYISAM";
MYSQL ERROR : 1064: 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 'TYPE = MYISAM' at line 8
SQL:"UPDATE order_conf SET `build`='5'";
MYSQL ERROR : 1146: Table 'kassit_acclab.order_conf' doesn't exist
SQL:"ALTER TABLE `emails` ADD `email_subject` TEXT NOT NULL";
MYSQL ERROR : 1146: Table 'kassit_acclab.emails' doesn't exist
SQL:"ALTER TABLE `order_conf` ADD `decimal_str` VARCHAR( 15 ) NOT NULL DEFAULT '.' ";
MYSQL ERROR : 1146: Table 'kassit_acclab.order_conf' doesn't exist
SQL:"ALTER TABLE `order_conf` ADD `thousand_str` VARCHAR( 15 ) NOT NULL DEFAULT ',' ";
MYSQL ERROR : 1146: Table 'kassit_acclab.order_conf' doesn't exist
SQL:"ALTER TABLE `order_conf` ADD `en_prorate` ENUM( '0', '1' ) NOT NULL DEFAULT '0' ";
MYSQL ERROR : 1146: Table 'kassit_acclab.order_conf' doesn't exist
SQL:"ALTER TABLE `order_conf` ADD `curr_symbol_prefixed` ENUM( '0', '1' ) NOT NULL DEFAULT '1' ";
MYSQL ERROR : 1146: Table 'kassit_acclab.order_conf' doesn't exist
SQL:"ALTER TABLE `order_conf` ADD `date_format` VARCHAR( 25 ) NOT NULL DEFAULT 'd-M-Y' ";
MYSQL ERROR : 1146: Table 'kassit_acclab.order_conf' doesn't exist
SQL:"ALTER TABLE `order_conf` ADD `decimal_number` INT( 3 ) NOT NULL DEFAULT '2' ";
MYSQL ERROR : 1146: Table 'kassit_acclab.order_conf' doesn't exist
SQL:"ALTER TABLE `order_conf` ADD `records_per_page` INT( 11 ) NOT NULL DEFAULT '50' ";
MYSQL ERROR : 1146: Table 'kassit_acclab.order_conf' doesn't exist
SQL:"ALTER TABLE `order_conf` ADD `prorate_date` INT( 2 ) NOT NULL ";
MYSQL ERROR : 1146: Table 'kassit_acclab.order_conf' doesn't exist
SQL:"ALTER TABLE `order_conf` ADD `tax_calculation` ENUM( '0', '1', '2' ) NOT NULL DEFAULT '0' ";
MYSQL ERROR : 1146: Table 'kassit_acclab.order_conf' doesn't exist
SQL:"ALTER TABLE `order_conf` ADD `show_loader` ENUM( '0', '1' ) NOT NULL DEFAULT '0' ";
MYSQL ERROR : 1146: Table 'kassit_acclab.order_conf' doesn't exist
SQL:"ALTER TABLE `currency` ADD `curr_decimal_number` INT( 3 ) NOT NULL DEFAULT '2'";
MYSQL ERROR : 1146: Table 'kassit_acclab.currency' doesn't exist
SQL:"ALTER TABLE `currency` ADD `curr_decimal_str` VARCHAR( 15 ) NOT NULL DEFAULT '.'";
MYSQL ERROR : 1146: Table 'kassit_acclab.currency' doesn't exist
SQL:"ALTER TABLE `currency` ADD `curr_thousand_str` VARCHAR( 15 ) NOT NULL DEFAULT ','";
MYSQL ERROR : 1146: Table 'kassit_acclab.currency' doesn't exist
SQL:"ALTER TABLE `currency` ADD `curr_symbol_prefixed` ENUM( '0', '1' ) NOT NULL DEFAULT '1'";
MYSQL ERROR : 1146: Table 'kassit_acclab.currency' doesn't exist
SQL:"ALTER TABLE `invoices` ADD `pay_curr_decimal_number` INT( 3 ) NOT NULL DEFAULT '2' ";
MYSQL ERROR : 1146: Table 'kassit_acclab.invoices' doesn't exist
SQL:"ALTER TABLE `invoices` ADD `pay_curr_decimal_str` VARCHAR( 15 ) NOT NULL DEFAULT '.' ";
MYSQL ERROR : 1146: Table 'kassit_acclab.invoices' doesn't exist
SQL:"ALTER TABLE `invoices` ADD `pay_curr_thousand_str` VARCHAR( 15 ) NOT NULL DEFAULT ',' ";
MYSQL ERROR : 1146: Table 'kassit_acclab.invoices' doesn't exist
SQL:"ALTER TABLE `invoices` ADD `pay_curr_symbol_prefixed` ENUM( '0', '1' ) NOT NULL DEFAULT '1' ";
MYSQL ERROR : 1146: Table 'kassit_acclab.invoices' doesn't exist
SQL:"ALTER TABLE `invoices` ADD `prorate_desc` TEXT NOT NULL ";
MYSQL ERROR : 1146: Table 'kassit_acclab.invoices' doesn't exist
SQL:"ALTER TABLE `invoices` ADD `prorate_amount` DECIMAL( 16, 6 ) NOT NULL DEFAULT '0.00'";
MYSQL ERROR : 1146: Table 'kassit_acclab.invoices' doesn't exist
SQL:"ALTER TABLE `servers` ADD `username_regexp` VARCHAR( 255 ) NOT NULL DEFAULT ''";
MYSQL ERROR : 1146: Table 'kassit_acclab.servers' doesn't exist
SQL:"ALTER TABLE `servers` ADD `username_prefix` VARCHAR( 255 ) NOT NULL";
MYSQL ERROR : 1146: Table 'kassit_acclab.servers' doesn't exist
SQL:"ALTER TABLE `sub_order` CHANGE `dom_user` `dom_user` VARCHAR( 255 ) NOT NULL";
MYSQL ERROR : 1146: Table 'kassit_acclab.sub_order' doesn't exist
SQL:"ALTER TABLE `sub_order` CHANGE `dom_pass` `dom_pass` VARCHAR( 255 ) NOT NULL";
MYSQL ERROR : 1146: Table 'kassit_acclab.sub_order' doesn't exist
SQL:"INSERT INTO `emails` ( `email_id` , `email_text` , `email_subject` ) VALUES ( '3', 'Dear <

Discussion


Log in to post a comment.