A new install fails with SQL Errors
Posted: Tue Oct 14, 2014 4:51 am
I am trying to install nuBuilderPro by loading "nuinstall.php" file.
The install fails with SQL Errors as follows:
Please help.
Done!
No Schema Changes!
SQL Errors:
Array
(
[0] => Array
(
[0] => 1
[1] => Can't create/write to file '/usr/local/mysql/data/site_c/template_zzzsys_access_level.MYI' (Errcode: 2)
[2] => CREATE TABLE `template_zzzsys_access_level` (`zzzsys_access_level_id` varchar(25) NOT NULL DEFAULT '',`sal_code` varchar(50) DEFAULT NULL,`sal_description` varchar(200) DEFAULT NULL,`sal_zzzsys_form_id` varchar(25) NOT NULL,`zzzsys_access_level_log_added_at` datetime NOT NULL,`zzzsys_access_level_log_added_by` varchar(25) NOT NULL,`zzzsys_access_level_log_changed_at` datetime NOT NULL,`zzzsys_access_level_log_changed_by` varchar(25) NOT NULL,`zzzsys_access_level_log_viewed_at` datetime NOT NULL,`zzzsys_access_level_log_viewed_by` varchar(25) NOT NULL,PRIMARY KEY (`zzzsys_access_level_id`),KEY `sal_name` (`sal_code`),KEY `sal_zzzsys_form_id` (`sal_zzzsys_form_id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8
)
[1] => Array
(
[0] => 1146
[1] => Table 'site_c.template_zzzsys_access_level' doesn't exist
[2] => LOCK TABLES `template_zzzsys_access_level` WRITE
)
[2] => Array
(
[0] => 1[*]
[1] => Can't create/write to file '/usr/local/mysql/data/site_c/template_zzzsys_access_level_form.MYI' (Errcode: 2)
[2] => CREATE TABLE `template_zzzsys_access_level_form` (`zzzsys_access_level_form_id` varchar(25) NOT NULL DEFAULT '',`slf_zzzsys_access_level_id` varchar(25) DEFAULT NULL,`slf_zzzsys_form_id` varchar(25) DEFAULT NULL,`slf_add_button` varchar(1) NOT NULL,`slf_save_button` varchar(1) NOT NULL,`slf_delete_button` varchar(1) NOT NULL,`slf_clone_button` varchar(1) NOT NULL,`slf_new_button` varchar(1) NOT NULL,`slf_print_button` varchar(1) NOT NULL,`zzzsys_access_level_form_log_added_at` datetime NOT NULL,`zzzsys_access_level_form_log_added_by` varchar(25) NOT NULL,`zzzsys_access_level_form_log_changed_at` datetime NOT NULL,`zzzsys_access_level_form_log_changed_by` varchar(25) NOT NULL,`zzzsys_access_level_form_log_viewed_at` datetime NOT NULL,`zzzsys_access_level_form_log_viewed_by` varchar(25) NOT NULL,PRIMARY KEY (`zzzsys_access_level_form_id`),KEY `saf_zzzsys_access_level_id` (`slf_zzzsys_access_level_id`),KEY `slf_zzzsys_form_id` (`slf_zzzsys_form_id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8
)
[3] => Array
-
-
-
-
-
-
-
[51] => Array
(
[0] => 1146
[1] => Table 'site_c.template_zzzsys_user_log' doesn't exist
[2] => LOCK TABLES `template_zzzsys_user_log` WRITE
)
)
No Warnings![/color]
The install fails with SQL Errors as follows:
Please help.
Done!
No Schema Changes!
SQL Errors:
Array
(
[0] => Array
(
[0] => 1
[1] => Can't create/write to file '/usr/local/mysql/data/site_c/template_zzzsys_access_level.MYI' (Errcode: 2)
[2] => CREATE TABLE `template_zzzsys_access_level` (`zzzsys_access_level_id` varchar(25) NOT NULL DEFAULT '',`sal_code` varchar(50) DEFAULT NULL,`sal_description` varchar(200) DEFAULT NULL,`sal_zzzsys_form_id` varchar(25) NOT NULL,`zzzsys_access_level_log_added_at` datetime NOT NULL,`zzzsys_access_level_log_added_by` varchar(25) NOT NULL,`zzzsys_access_level_log_changed_at` datetime NOT NULL,`zzzsys_access_level_log_changed_by` varchar(25) NOT NULL,`zzzsys_access_level_log_viewed_at` datetime NOT NULL,`zzzsys_access_level_log_viewed_by` varchar(25) NOT NULL,PRIMARY KEY (`zzzsys_access_level_id`),KEY `sal_name` (`sal_code`),KEY `sal_zzzsys_form_id` (`sal_zzzsys_form_id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8
)
[1] => Array
(
[0] => 1146
[1] => Table 'site_c.template_zzzsys_access_level' doesn't exist
[2] => LOCK TABLES `template_zzzsys_access_level` WRITE
)
[2] => Array
(
[0] => 1[*]
[1] => Can't create/write to file '/usr/local/mysql/data/site_c/template_zzzsys_access_level_form.MYI' (Errcode: 2)
[2] => CREATE TABLE `template_zzzsys_access_level_form` (`zzzsys_access_level_form_id` varchar(25) NOT NULL DEFAULT '',`slf_zzzsys_access_level_id` varchar(25) DEFAULT NULL,`slf_zzzsys_form_id` varchar(25) DEFAULT NULL,`slf_add_button` varchar(1) NOT NULL,`slf_save_button` varchar(1) NOT NULL,`slf_delete_button` varchar(1) NOT NULL,`slf_clone_button` varchar(1) NOT NULL,`slf_new_button` varchar(1) NOT NULL,`slf_print_button` varchar(1) NOT NULL,`zzzsys_access_level_form_log_added_at` datetime NOT NULL,`zzzsys_access_level_form_log_added_by` varchar(25) NOT NULL,`zzzsys_access_level_form_log_changed_at` datetime NOT NULL,`zzzsys_access_level_form_log_changed_by` varchar(25) NOT NULL,`zzzsys_access_level_form_log_viewed_at` datetime NOT NULL,`zzzsys_access_level_form_log_viewed_by` varchar(25) NOT NULL,PRIMARY KEY (`zzzsys_access_level_form_id`),KEY `saf_zzzsys_access_level_id` (`slf_zzzsys_access_level_id`),KEY `slf_zzzsys_form_id` (`slf_zzzsys_form_id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8
)
[3] => Array
-
-
-
-
-
-
-
[51] => Array
(
[0] => 1146
[1] => Table 'site_c.template_zzzsys_user_log' doesn't exist
[2] => LOCK TABLES `template_zzzsys_user_log` WRITE
)
)
No Warnings![/color]