Install Booked Scheduler

Community Support for Booked Scheduler
Post Reply
araci
Posts: 4
Joined: Sun Aug 02, 2020 3:36 am

Install Booked Scheduler

Post by araci »

Hy,
I got a lot of erros messages, but I don't know how to fix. Those erros are in statements/ commands of the Booked Scheduler,
Sorry, but I am not a expert. If someone explain what shoud I do, ate least in one of the erros, I believe that I will be able to do all others.
I am installing with Xampp in my notebbok. Bellow are the messages:
----------------
Install Booked Scheduler
Executing: ../../database_schema/create-schema.sql
Failed. Details:
SQL Statement:

-- UPGRADE TO VERSION 2.2

DROP TABLE IF EXISTS `custom_attributes`
Error Code:
1451
Error Text:
Cannot delete or update a parent row: a foreign key constraint fails
-------------------------------
Executing: ../../database_schema/create-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.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
Success
Executing: ../../database_schema/upgrades/2.2/schema.sql
Failed. Details:
SQL Statement:
DROP TABLE IF EXISTS `custom_attributes`
Error Code:
1451
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
Success
Executing: ../../database_schema/upgrades/2.3/data.sql
Success
Executing: ../../database_schema/upgrades/2.4/schema.sql
Success
Executing: ../../database_schema/upgrades/2.4/data.sql
Success
--------------------------------------
Executing: ../../database_schema/upgrades/2.5/schema.sql
Failed. Details:
SQL Statement:
ALTER TABLE `custom_attributes` ADD COLUMN `entity_id` mediumint(8) unsigned
Error Code:
1060
Error Text:
Duplicate column name 'entity_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
---------------------------------------------------
Executing: ../../database_schema/upgrades/2.7/schema.sql
Failed. Details:
SQL Statement:
# noinspection SqlNoDataSourceInspectionForFile

ALTER TABLE `users` CHANGE `credit_count` `credit_count` DECIMAL(7,2) NULL DEFAULT '0'
Error Code:
1054
Error Text:
Unknown column 'credit_count' in 'users'
-------------------------------------------------
Executing: ../../database_schema/upgrades/2.7/data.sql
Success
Executing: ../../database_schema/upgrades/2.8/schema.sql
Success
Executing: ../../database_schema/upgrades/2.8/data.sql
Success

There were problems with the installation. Please correct them and retry the installation.

1139807000@qq.com
Posts: 26
Joined: Mon Jul 27, 2020 2:07 am

Re: Install Booked Scheduler

Post by 1139807000@qq.com »

Try to enter the homepage to see. If there is no error, the installation may be successful. If it still does not work, your booked version is not too old. I think you should check the php version (7.0↑) and the mysql version (5.7√)

araci
Posts: 4
Joined: Sun Aug 02, 2020 3:36 am

Re: Install Booked Scheduler

Post by araci »

Hy,
I look the site and now this is the error:

JQMIGRATE: Migrate is installed, version 3.0.1
view-schedule.php:188 Uncaught SyntaxError: Unexpected token '<'

Post Reply