Starting database setup
Checking table: perm_group_to_resource
Table (perm_group_to_resource) column perm have different types(int NULL != int)
Checking table: perm_resources
Table (perm_resources) column resource_name have different types(varchar(256) NULL != varchar(256))
Checking table: perm_roles_to_resource
Table (perm_roles_to_resource) column role_id have different types(int NULL != int)
Table (perm_roles_to_resource) column resource_id have different types(int NULL != int)
Table (perm_roles_to_resource) column perm have different types(int NULL != int)
Checking table: perm_roles
Checking table: perm_user_to_resource
Table (perm_user_to_resource) column perm have different types(int NULL != int)
Checking table: perm_user_to_role
Checking table: tbl_Company
Table (tbl_Company) column CompanyName have different types(varchar(64) NULL != nvarchar(64) NULL)
Table (tbl_Company) column AddressName have different types(varchar(128) NULL != nvarchar(128) NULL)
Table (tbl_Company) column AddressName2 have different types(varchar(128) NULL != nvarchar(128) NULL)
Table (tbl_Company) column CityName have different types(varchar(128) NULL != nvarchar(128) NULL)
Table (tbl_Company) column PostalCode have different types(varchar(32) NULL != nvarchar(32) NULL)
Table (tbl_Company) column CompanyLogoUrl have different types(varchar(512) NULL != nvarchar(512) NULL)
Table (tbl_Company) column ImagePath have different types(varchar(512) NULL != nvarchar(512) NULL)
Table (tbl_Company) column DefaultEmail have different types(varchar(64) NULL != nvarchar(64) NULL)
Table (tbl_Company) column Password have different types(varchar(64) NULL != nvarchar(64) NULL)
Table (tbl_Company) column SMTPServer have different types(varchar(64) NULL != nvarchar(64) NULL)
Checking table: tbl_Contact
Table (tbl_Contact) column FirstName have different types(varchar(20) NULL != nvarchar(20))
Table (tbl_Contact) column LastName have different types(varchar(30) NULL != nvarchar(30))
Table (tbl_Contact) column Email have different types(varchar(50) NULL != nvarchar(50))
Table (tbl_Contact) column PhoneNumber have different types(varchar(50) NULL != nvarchar(50) NULL)
Table (tbl_Contact) column Notes have different types(varchar(1000) NULL != nvarchar(1000) NULL)
Table (tbl_Contact) column UserType have different types(int NULL != int)
Table (tbl_Contact) column Timezone have different types(varchar(64) NULL != nvarchar(64))
Table (tbl_Contact) column DateTimeFormat have different types(varchar(64) NULL != nvarchar(64))
Table (tbl_Contact) column CompanyID have different types(int NULL != int)
Table (tbl_Contact) column ImagePath have different types(varchar(512) NULL != nvarchar(512) NULL)
Checking table: tbl_ContactGroups
Table (tbl_ContactGroups) column CompanyID have different types(int NULL != int)
Table (tbl_ContactGroups) column ContactGroupName have different types(varchar(64) NULL != nvarchar(64) NULL)
Table (tbl_ContactGroups) column ContactGroupDesc have different types(varchar(2048) NULL != nvarchar(2048) NULL)
Checking table: tbl_ContactInGroup
Table (tbl_ContactInGroup) column ContactGroupID have different types(int NULL != int)
Table (tbl_ContactInGroup) column ContactID have different types(int NULL != int)
Checking table: tbl_DashboardReport
Table (tbl_DashboardReport) column CompanyID have different types(int NULL != int)
Table (tbl_DashboardReport) column DepartmentID have different types(int NULL != int)
Table (tbl_DashboardReport) column Description have different types(varchar(255) NULL != nvarchar(255) NULL)
Table (tbl_DashboardReport) column DashboardReportStatusID have different types(int NULL != int)
Checking table: tbl_DashboardReportEntry
Table (tbl_DashboardReportEntry) column DashboardReportID have different types(int NULL != int)
Table (tbl_DashboardReportEntry) column ServiceAreaID have different types(int NULL != int)
Table (tbl_DashboardReportEntry) column ServiceAreaShift have different types(varchar(256) NULL != nvarchar(256))
Table (tbl_DashboardReportEntry) column EntryNotes have different types(varchar(256) NULL != nvarchar(256))
Checking table: tbl_DashboardReportStatus
Table (tbl_DashboardReportStatus) column DashboardReportStatus have different types(varchar(32) NULL != nvarchar(32))
Checking table: tbl_Department
Table (tbl_Department) column CompanyID have different types(int NULL != int)
Table (tbl_Department) column DepartmentName have different types(varchar(64) NULL != nvarchar(64) NULL)
Table (tbl_Department) column Notes have different types(varchar(1000) NULL != nvarchar(1000) NULL)
Checking table: tbl_Role
Table (tbl_Role) column Role have different types(varchar(64) NULL != nvarchar(64) NULL)
Checking table: tbl_ServiceAreas
Table (tbl_ServiceAreas) column CompanyID have different types(int NULL != int)
Table (tbl_ServiceAreas) column ServiceAreaName have different types(varchar(255) NULL != nvarchar(255) NULL)
Table (tbl_ServiceAreas) column Contact have different types(varchar(255) NULL != nvarchar(255) NULL)
Table (tbl_ServiceAreas) column ContactPhone have different types(varchar(255) NULL != nvarchar(255) NULL)
Table (tbl_ServiceAreas) column ContactEmail have different types(varchar(255) NULL != nvarchar(255) NULL)
Table (tbl_ServiceAreas) column IsEnabled have different types(int NULL != bit)
Table (tbl_ServiceAreas) column Notes have different types(varchar(1000) NULL != nvarchar(1000) NULL)
Table (tbl_ServiceAreas) column DirectorManagerName have different types(varchar(255) NULL != nvarchar(255) NULL)
Ooops something went wrong: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'DirectorManagerPhone'#0 /var/www/html/vendor/kajna/core/Core/Database/MySqlDatabase.php(75): PDOStatement->execute(Array) #1 /var/www/html/App/Controllers/Setup.php(120): Core\Database\MySqlDatabase->query('ALTER TABLE tbl...') #2 [internal function]: App\Controllers\Setup->init() #3 /var/www/html/vendor/kajna/core/Core/Routing/Executable.php(91): call_user_func_array(Array, Array) #4 /var/www/html/vendor/kajna/core/Core/Routing/Route.php(119): Core\Routing\Executable->__invoke() #5 /var/www/html/vendor/kajna/core/Core/Core/Core.php(157): Core\Routing\Route->__invoke(Object(Core\Core\Resolver)) #6 /var/www/html/App/Middleware/CustomCorsMiddleware.php(44): Core\Core\Core->__invoke() #7 [internal function]: App\Middleware\CustomCorsMiddleware->__invoke(Object(Core\Core\Core)) #8 /var/www/html/vendor/kajna/core/Core/Core/Core.php(232): call_user_func(Object(App\Middleware\CustomCorsMiddleware), Object(Core\Core\Core)) #9 /var/www/html/App/Middleware/RegistryMiddleware.php(176): Core\Core\Core->Core\Core\{closure}() #10 [internal function]: App\Middleware\RegistryMiddleware->__invoke(Object(Closure)) #11 /var/www/html/vendor/kajna/core/Core/Core/Core.php(232): call_user_func(Object(App\Middleware\RegistryMiddleware), Object(Closure)) #12 /var/www/html/vendor/kajna/core/Core/Core/Core.php(103): Core\Core\Core->Core\Core\{closure}() #13 /var/www/html/www/index.php(134): Core\Core\Core->execute() #14 {main}
Adding constraints...
Constraint errorSQLSTATE[42000]: Syntax error or access violation: 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 'CONSTRAINT FK_CompanyID' at line 1Constraint errorSQLSTATE[23000]: Integrity constraint violation: 1022 Can't write; duplicate key in table '#sql-1_28'Constraint errorSQLSTATE[42000]: Syntax error or access violation: 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 'CONSTRAINT FK_DepartmentID' at line 1Constraint errorSQLSTATE[23000]: Integrity constraint violation: 1022 Can't write; duplicate key in table '#sql-1_28'Constraint errorSQLSTATE[42000]: Syntax error or access violation: 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 'CONSTRAINT FK_ServiceAreaID' at line 1Constraint errorSQLSTATE[23000]: Integrity constraint violation: 1022 Can't write; duplicate key in table '#sql-1_28'Constraint errorSQLSTATE[42000]: Syntax error or access violation: 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 'CONSTRAINT FK_ContactID' at line 1Constraint errorSQLSTATE[23000]: Integrity constraint violation: 1022 Can't write; duplicate key in table '#sql-1_28'Constraint errorSQLSTATE[42000]: Syntax error or access violation: 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 'CONSTRAINT FK_ContactGroupID' at line 1Constraint errorSQLSTATE[23000]: Integrity constraint violation: 1022 Can't write; duplicate key in table '#sql-1_28'Constraint errorSQLSTATE[42000]: Syntax error or access violation: 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 'CONSTRAINT FK_ContactID' at line 1Constraint errorSQLSTATE[23000]: Integrity constraint violation: 1022 Can't write; duplicate key in table '#sql-1_28'Constraint errorSQLSTATE[42000]: Syntax error or access violation: 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 'CONSTRAINT FK_CompanyID' at line 1Constraint errorSQLSTATE[23000]: Integrity constraint violation: 1022 Can't write; duplicate key in table '#sql-1_28'Constraint errorSQLSTATE[42000]: Syntax error or access violation: 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 'CONSTRAINT FK_DashboardReportStatusID' at line 1Constraint errorSQLSTATE[HY000]: General error: 1215 Cannot add foreign key constraintConstraint errorSQLSTATE[42000]: Syntax error or access violation: 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 'CONSTRAINT FK_DepartmentID' at line 1Constraint errorSQLSTATE[23000]: Integrity constraint violation: 1022 Can't write; duplicate key in table '#sql-1_28'Constraint errorSQLSTATE[42000]: Syntax error or access violation: 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 'CONSTRAINT FK_DashboardReportID' at line 1Constraint errorSQLSTATE[23000]: Integrity constraint violation: 1022 Can't write; duplicate key in table '#sql-1_28'Constraint errorSQLSTATE[42000]: Syntax error or access violation: 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 'CONSTRAINT FK_ServiceAreaID' at line 1Constraint errorSQLSTATE[23000]: Integrity constraint violation: 1022 Can't write; duplicate key in table '#sql-1_28'Constraint errorSQLSTATE[42000]: Syntax error or access violation: 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 'CONSTRAINT FK_CompanyID' at line 1Constraint errorSQLSTATE[23000]: Integrity constraint violation: 1022 Can't write; duplicate key in table '#sql-1_28'Constraint errorSQLSTATE[42000]: Syntax error or access violation: 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 'CONSTRAINT FK_CompanyID' at line 1Constraint errorSQLSTATE[23000]: Integrity constraint violation: 1022 Can't write; duplicate key in table '#sql-1_28'