Booked Scheduler Community Support
May 20, 2018, 09:41:34 PM *
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
News: Booked is proud to recommend Shift Capsule in the employee shift scheduling space www.ShiftCapsule.com
 
   Home   Help Login Register  
Pages: [1]
  Print  
Author Topic: MySQL Errors on installation  (Read 11 times)
crogers
Newbie
*

Karma: 0
Posts: 1


« on: May 18, 2018, 03:22:52 PM »

I am trying to install Booked Scheduler on a server running RHEL 7, PHP 7.1, and MariaDB (mysql  Ver 15.1 Distrib 5.5.56-MariaDB, for Linux (x86_64) using readline 5.1).

I'm getting several database errors when running the installation.  Is there a preferred version of MySQL that I need to use?  All I saw was >5.5 in the Readme file.

Install Booked Scheduler (MySQL only)
Executing: ../../database_schema/create-db.sql
Success
Executing: ../../database_schema/create-schema.sql
Success
Executing: ../../database_schema/create-user.sql
Failed. Details:
SQL Statement:

GRANT ALL on bookedscheduler.* to 'bookedscheduler_user'@'127.0.0.1' identified by 'password'

Error Code:

1470

Error Text:

String 'bookedscheduler_user' is too long for user name (should be no longer than 16)

Executing: ../../database_schema/create-data.sql
Success
Executing: ../../database_schema/sample-data-utf8.sql
Success
Executing: ../../database_schema/upgrades/2.1/schema.sql
Failed. Details:
SQL Statement:


ALTER TABLE `resources` ADD COLUMN `admin_group_id` SMALLINT(5) unsigned

Error Code:

1060

Error Text:

Duplicate column name 'admin_group_id'

Executing: ../../database_schema/upgrades/2.1/data.sql
Failed. Details:
SQL Statement:

insert into roles values (3, 'Resource Admin', 3)

Error Code:

1062

Error Text:

Duplicate entry '3' for key 'PRIMARY'

Executing: ../../database_schema/upgrades/2.2/schema.sql
Failed. Details:
SQL Statement:

DROP TABLE IF EXISTS `custom_attributes`

Error Code:

1217

Error Text:

Cannot delete or update a parent row: a foreign key constraint fails

Executing: ../../database_schema/upgrades/2.2/data.sql
Success
Executing: ../../database_schema/upgrades/2.3/schema.sql
Failed. Details:
SQL Statement:

ALTER TABLE `schedules` ADD COLUMN `admin_group_id` SMALLINT(5) unsigned

Error Code:

1060

Error Text:

Duplicate column name 'admin_group_id'

Executing: ../../database_schema/upgrades/2.3/data.sql
Failed. Details:
SQL Statement:

insert into roles values (4, 'Schedule Admin', 4)

Error Code:

1062

Error Text:

Duplicate entry '4' for key 'PRIMARY'

Executing: ../../database_schema/upgrades/2.4/schema.sql
Failed. Details:
SQL Statement:


ALTER TABLE `time_blocks` ADD COLUMN `day_of_week` SMALLINT(5) unsigned

Error Code:

1060

Error Text:

Duplicate column name 'day_of_week'

Executing: ../../database_schema/upgrades/2.4/data.sql
Success
Executing: ../../database_schema/upgrades/2.5/schema.sql
Failed. Details:
SQL Statement:


ALTER TABLE `resources` ADD COLUMN `resource_type_id` mediumint(Cool unsigned

Error Code:

1060

Error Text:

Duplicate column name 'resource_type_id'

Executing: ../../database_schema/upgrades/2.5/data.sql
Success
Executing: ../../database_schema/upgrades/2.6/schema.sql
Failed. Details:
SQL Statement:

# noinspection SqlNoDataSourceInspectionForFile
ALTER TABLE `custom_attributes`
  ADD COLUMN `admin_only` TINYINT(1) UNSIGNED

Error Code:

1060

Error Text:

Duplicate column name 'admin_only'

Executing: ../../database_schema/upgrades/2.6/data.sql
Success
 
There were problems with the installation. Please correct them and retry the installation.
Logged
Pages: [1]
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.20 | SMF © 2006-2007, Simple Machines Valid XHTML 1.0! Valid CSS!