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

Login with username, password and session length
News: Booked 2.7 beta has been released!
 
   Home   Help Login Register  
Pages: [1] 2 3 ... 10
 1 
 on: May 18, 2018, 03:22:52 PM 
Started by crogers - Last post by crogers
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.

 2 
 on: May 18, 2018, 12:32:45 PM 
Started by Elca - Last post by Elca
It was my server's problem.
I have cleaned all my server of malicious code and it seems that it has been fixed.

 3 
 on: May 17, 2018, 01:12:12 PM 
Started by PEM - Last post by PEM
This is the error received in booked-error.log:

[Wed May 16 15:28:56.584387 2018] [:error] [pid 2344] [client ] PHP Fatal error:  Uncaught Error: Call to undefined function simplexml_load_file() in /var/www/html/booked/lib/external/log4php/configurators/LoggerConfigurationAdapterXML.php:87\nStack trace:\n#0 /var/www/html/booked/lib/external/log4php/configurators/L$


I forgot to mention that this is on Ubuntu 16.04

 4 
 on: May 17, 2018, 12:42:48 PM 
Started by gustavoBB - Last post by gustavoBB
He dado de alta en Google con nuevo captcha V2. ya tengo mi clave publica y privada
Las he actualizado en config.php
pongo este trocito de codigo en la cabecera (en el tpl)

script src='https://www.google.com/recaptcha/api.js'></scrip>

y este dentro de form en register.tpl

<div class="g-recaptcha" data-sitekey="6LdJFlkUAAAAAJFXYw1-FtbQ7hnCXoMWNDCaxrua"></div>

con MI key, no con etsa que es del manual

veo en register.tpl  este <div>
<div class="form-group">{control type="CaptchaControl"}</div> que es el que carga el captcha V1 que ya no funciona. Lo comento

y compruebo al cargar register.php:

que el captcha v2 aparece y funciona, hace el test, detecta que soy humano, pero al enviar los datos del formulario me salta un error, el form  me dice que no he rellenado los codigo de seguridad, como si el captcha no se hubiera rellenado
Es decir que el captcha funciona, comprueba que no soy un robot, pero no le pasa al formulario la validacion

que es lo que hago mal?





 5 
 on: May 16, 2018, 07:33:12 PM 
Started by PEM - Last post by PEM
I'm trying to enable logging in order to troubleshoot an SMTP issue however, when I rename the config/log4php.config.dist.xml to log4php.config.xml the site stops working.  The menus load, but the content does not.  As soon as I rename the file back to dist.xml, the site works as it should.

I have modified the file to enable default logging which is set to debug and have set the log folder value.  I also did chown 0777 of that log folder (in case it is a permissions issue).

Is there something else that I should be doing in order to enable log4php?

Thanks in advance

 6 
 on: May 16, 2018, 02:04:14 PM 
Started by ivenoclue - Last post by astpierre
ivenoclue, did you ever resolve this yourself? I'm in a similar predicament.

 7 
 on: May 16, 2018, 08:23:07 AM 
Started by alexandre.kieffer@uha.fr - Last post by jaktens
hello,

for now i'm using the CAS Authentication this is working pretty well

however i get email address on all user attribute ( for the first name, last name and username) there is a way to get correct attribute from the CAS ?

Lucas,


Same question here... my username is twice ma name.surname ...

 8 
 on: May 15, 2018, 08:20:19 PM 
Started by algobar - Last post by infocarlosamv
buenas... al final despues de tanto golpe esta funcionando....
no se si fue al único que le paso pero cuando ponia español me daba error. despues de mucho buscar encontre en un foro que el archivo es.php habia que guardarlo en modo ansi

asi lo hice y funciono solo quedo cambiar los tildes y eñes por su codigo del tipo &iacuate;

adjunto el idioma actualizado ya que habia palabras que no estaban y se muestran por defecto en ingles.

saludos!! excelente soft!!

Hola como cambiaste las tildes y las eñes?Huh


[attachment deleted by admin]

 9 
 on: May 15, 2018, 02:48:34 PM 
Started by Sonic007 - Last post by YZone
Hi,

Just a guess, try to use a comma separated list:

$conf['settings']['authentication']['required.email.domains'] = 'mydomain1.co.uk,mydomain2.co.uk,mydomain3.co.uk'


YZone

 10 
 on: May 15, 2018, 01:32:18 PM 
Started by Sonic007 - Last post by Sonic007
Is there a way so I can authorise users from several email domains to sign in to Booked.

eg. In my config.php I have:

Code:
$conf['settings']['authentication']['required.email.domains'] = 'mydomain1.co.uk';

We have users at two other email domains. mydomain2 and mydomain3.co.uk

How can I add to the config file so that if you are on domain 1, 2 or 3 then you can sign in.

Many Thanks.


Pages: [1] 2 3 ... 10
Powered by MySQL Powered by PHP Powered by SMF 1.1.20 | SMF © 2006-2007, Simple Machines Valid XHTML 1.0! Valid CSS!