search

meeting-room-booking-system / mrbs-code

MRBS application code
Other
124 stars 61 forks source link

Error saving series #661

Open jberanek opened 4 years ago

jberanek commented 4 years ago

I get this when I try to save series:

Uncaught exception 'MRBS\DBException' in /storage/ssd5/030/12000030/public_html/lib/MRBS/DB.php at line 109
SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`id12000030_mrbs`.`mrbs_entry`, CONSTRAINT `mrbs_entry_ibfk_2` FOREIGN KEY (`repeat_id`) REFERENCES `mrbs_repeat` (`id`) ON DELETE CASCADE ON UPDATE CASCADE)
SQL: INSERT INTO mrbs_entry (`start_time`, `end_time`, `entry_type`, `repeat_id`, `room_id`, `create_by`, `modified_by`, `name`, `type`, `description`, `status`, `ical_uid`, `ical_sequence`, `ical_recur_id`, `docentes_responsables`, `actividades`, `cod_materias`, `planes_materias`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Params: Array
(
    [0] => 1582030800
    [1] => 1582041600
    [2] => 1
    [3] => 27
    [4] => 2
    [5] => salud
    [6] =>
    [7] => Docencia en Enfermería
    [8] => I
    [9] =>
    [10] => 0
    [11] => MRBS-5e3d7982ef3c4-5299d00f@resaulassalud.000webhostapp.com
    [12] => 0
    [13] => 20200218T130000Z
    [14] =>
    [15] =>
    [16] => 57
    [17] => 1994
)

#0 /storage/ssd5/030/12000030/public_html/mrbs_sql.inc(815): MRBS\DB->command('INSERT INTO mrb...', Array)
#1 /storage/ssd5/030/12000030/public_html/mrbs_sql.inc(846): MRBS\mrbsCreateEntry('mrbs_entry', Array)
#2 /storage/ssd5/030/12000030/public_html/mrbs_sql.inc(1130): MRBS\mrbsCreateSingleEntry(Array)
#3 /storage/ssd5/030/12000030/public_html/mrbs_sql.inc(2124): MRBS\mrbsCreateRepeatingEntrys(Array)
#4 /storage/ssd5/030/12000030/public_html/edit_entry_handler.php(742): MRBS\mrbsMakeBookings(Array, NULL, false, NULL, NULL, false, 'series')
#5 {main}
MRBS GET: Array
(
)
MRBS POST: Array
(
    [csrf_token] => 0f0ad74263ae7172f6d2e1fcb01c9d0084b3eb23b9926aef7ce1f1daa382b19f
    [returl] => http://resaulassalud.000webhostapp.com/week.php?area=1&room=2&year=2020&month=02&day=16
    [create_by] => salud
    [rep_id] => 0
    [edit_type] => series
    [name] => Docencia en Enfermería
    [description] =>
    [start_date] => 2020-02-18
    [start_seconds] => 36000
    [end_date] => 2020-02-18
    [end_seconds] => 46800
    [rooms] => Array
        (
            [0] => 2
        )

    [type] => I
    [confirmed] => 1
    [f_docentes_responsables] =>
    [f_actividades] =>
    [f_cod_materias] => 57
    [f_planes_materias] => 1994
    [rep_type] => 2
    [rep_day] => Array
        (
            [0] => 2
        )

    [rep_num_weeks] => 1
    [month_type] => 0
    [month_absolute] => 18
    [month_relative_ord] => 3
    [month_relative_day] => TU
    [rep_end_date] => 2020-06-28
)
MRBS SESSION: Array
(
    [csrf_token] => 0f0ad74263ae7172f6d2e1fcb01c9d0084b3eb23b9926aef7ce1f1daa382b19f
    [UserName] => salud
)

E_WARNING in /storage/ssd5/030/12000030/public_html/functions.inc at line 234
Cannot modify header information - headers already sent by (output started at /storage/ssd5/030/12000030/public_html/functions_error.inc:62)
MRBS GET: Array
(
)
MRBS POST: Array
(
    [csrf_token] => 0f0ad74263ae7172f6d2e1fcb01c9d0084b3eb23b9926aef7ce1f1daa382b19f
    [returl] => http://resaulassalud.000webhostapp.com/week.php?area=1&room=2&year=2020&month=02&day=16
    [create_by] => salud
    [rep_id] => 0
    [edit_type] => series
    [name] => Docencia en Enfermería
    [description] =>
    [start_date] => 2020-02-18
    [start_seconds] => 36000
    [end_date] => 2020-02-18
    [end_seconds] => 46800
    [rooms] => Array
        (
            [0] => 2
        )

    [type] => I
    [confirmed] => 1
    [f_docentes_responsables] =>
    [f_actividades] =>
    [f_cod_materias] => 57
    [f_planes_materias] => 1994
    [rep_type] => 2
    [rep_day] => Array
        (
            [0] => 2
        )

    [rep_num_weeks] => 1
    [month_type] => 0
    [month_absolute] => 18
    [month_relative_ord] => 3
    [month_relative_day] => TU
    [rep_end_date] => 2020-06-28
)
MRBS SESSION: Array
(
    [csrf_token] => 0f0ad74263ae7172f6d2e1fcb01c9d0084b3eb23b9926aef7ce1f1daa382b19f
    [UserName] => salud
)

E_WARNING in /storage/ssd5/030/12000030/public_html/functions.inc at line 221
Cannot modify header information - headers already sent by (output started at /storage/ssd5/030/12000030/public_html/functions_error.inc:62)
MRBS GET: Array
(
)
MRBS POST: Array
(
    [csrf_token] => 0f0ad74263ae7172f6d2e1fcb01c9d0084b3eb23b9926aef7ce1f1daa382b19f
    [returl] => http://resaulassalud.000webhostapp.com/week.php?area=1&room=2&year=2020&month=02&day=16
    [create_by] => salud
    [rep_id] => 0
    [edit_type] => series
    [name] => Docencia en Enfermería
    [description] =>
    [start_date] => 2020-02-18
    [start_seconds] => 36000
    [end_date] => 2020-02-18
    [end_seconds] => 46800
    [rooms] => Array
        (
            [0] => 2
        )

    [type] => I
    [confirmed] => 1
    [f_docentes_responsables] =>
    [f_actividades] =>
    [f_cod_materias] => 57
    [f_planes_materias] => 1994
    [rep_type] => 2
    [rep_day] => Array
        (
            [0] => 2
        )

    [rep_num_weeks] => 1
    [month_type] => 0
    [month_absolute] => 18
    [month_relative_ord] => 3
    [month_relative_day] => TU
    [rep_end_date] => 2020-06-28
)
MRBS SESSION: Array
(
    [csrf_token] => 0f0ad74263ae7172f6d2e1fcb01c9d0084b3eb23b9926aef7ce1f1daa382b19f
    [UserName] => salud
)

E_WARNING in /storage/ssd5/030/12000030/public_html/functions.inc at line 222
Cannot modify header information - headers already sent by (output started at /storage/ssd5/030/12000030/public_html/functions_error.inc:62)
MRBS GET: Array
(
)
MRBS POST: Array
(
    [csrf_token] => 0f0ad74263ae7172f6d2e1fcb01c9d0084b3eb23b9926aef7ce1f1daa382b19f
    [returl] => http://resaulassalud.000webhostapp.com/week.php?area=1&room=2&year=2020&month=02&day=16
    [create_by] => salud
    [rep_id] => 0
    [edit_type] => series
    [name] => Docencia en Enfermería
    [description] =>
    [start_date] => 2020-02-18
    [start_seconds] => 36000
    [end_date] => 2020-02-18
    [end_seconds] => 46800
    [rooms] => Array
        (
            [0] => 2
        )

    [type] => I
    [confirmed] => 1
    [f_docentes_responsables] =>
    [f_actividades] =>
    [f_cod_materias] => 57
    [f_planes_materias] => 1994
    [rep_type] => 2
    [rep_day] => Array
        (
            [0] => 2
        )

    [rep_num_weeks] => 1
    [month_type] => 0
    [month_absolute] => 18
    [month_relative_ord] => 3
    [month_relative_day] => TU
    [rep_end_date] => 2020-06-28
)
MRBS SESSION: Array
(
    [csrf_token] => 0f0ad74263ae7172f6d2e1fcb01c9d0084b3eb23b9926aef7ce1f1daa382b19f
    [UserName] => salud
)

Then this message:

Error: la base de datos no está disponible en este momento.

Yesterday was working well. I'm ussing free web hosting 000webhost

Reported by: *anonymous

Original Ticket: mrbs/bugs/457

jberanek commented 4 years ago

Was this a new series or were you editing an existing series?

Original comment by: campbell-m

jberanek commented 4 years ago

Some more questions:

  1. Can you look at the repeat table using phpMyAdmin (or similar) and see if you have a row with id 27?
  2. Were there any other errors before this?
  3. Can you reproduce the problem? If so, how?

Original comment by: campbell-m

jberanek commented 4 years ago

Hello,

I'm currently having the same issue, with version 1.6.1 and wordpress authentication. Your help would be very appreciated, thank you.

Here is the error. 

[10-Feb-2020 16:05:37 America/Santiago] 
E_NOTICE in /home/sctbcl/public_html/sitios/sctb.cl/wp-config.php at line 95
Constant COOKIEPATH already defined

[10-Feb-2020 16:05:37 America/Santiago] Uncaught exception 'MRBS\DBException' in /home/sctbcl/public_html/sitios/reservas/lib/MRBS/DB.php at line 98
SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`sctbcl_reservas`.`cas_entry`, CONSTRAINT `cas_entry_ibfk_2` FOREIGN KEY (`create_by`) REFERENCES `cas_users` (`name`) ON UPDATE CASCADE)
SQL: INSERT INTO cas_entry (`start_time`, `end_time`, `entry_type`, `repeat_id`, `room_id`, `create_by`, `modified_by`, `name`, `type`, `description`, `status`, `ical_uid`, `ical_sequence`, `ical_recur_id`, `galones`, `matricula`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Params: Array
(
    [0] => 1581462000
    [1] => 1581465600
    [2] => 0
    [3] => 
    [4] => 36
    [5] => alfredo@loot.cl
    [6] => 
    [7] => asddsa
    [8] => E
    [9] => asdasdaa
    [10] => 0
    [11] => MRBS-5e41a981afa4b-3e316df6@reservas.sctb.cl
    [12] => 0
    [13] => 
    [14] => 
    [15] => 
)

#0 /home/sctbcl/public_html/sitios/reservas/mrbs_sql.inc(755): MRBS\DB->command('INSERT INTO cas...', Array)
#1 /home/sctbcl/public_html/sitios/reservas/mrbs_sql.inc(786): MRBS\mrbsCreateEntry('cas_entry', Array)
#2 /home/sctbcl/public_html/sitios/reservas/mrbs_sql.inc(2032): MRBS\mrbsCreateSingleEntry(Array)
#3 /home/sctbcl/public_html/sitios/reservas/edit_entry_handler.php(713): MRBS\mrbsMakeBookings(Array, NULL, false, NULL, NULL, true, 'series')
#4 {main}
MRBS GET: Array
(
)
MRBS POST: Array
(
    [name] => asddsa
    [description] => asdasdaa
    [start_day] => 11
    [start_month] => 2
    [start_year] => 2020
    [start_seconds] => 72000
    [end_day] => 11
    [end_month] => 2
    [end_year] => 2020
    [end_seconds] => 75600
    [area] => 2
    [rooms] => Array
        (
            [0] => 36
        )

    [type] => E
    [f_galones] => 
    [f_matricula] => 
    [rep_type] => 0
    [rep_day] => Array
        (
            [0] => 2
        )

    [rep_num_weeks] => 1
    [month_type] => 0
    [month_absolute] => 11
    [month_relative_ord] => 2
    [month_relative_day] => TU
    [rep_end_day] => 11
    [rep_end_month] => 2
    [rep_end_year] => 2020
    [returl] => https://reservas.sctb.cl/day.php?year=2020&month=2&day=11&area=2&room=37
    [create_by] => alfredo@loot.cl
    [rep_id] => 0
    [edit_type] => series
)

Original comment by: lootcl

jberanek commented 4 years ago

Same questions as above, ie

  1. Can you look at the repeat table using phpMyAdmin (or similar) and see if you have a row with id 36?
  2. Were there any other errors before this?
  3. Can you reproduce the problem? If so, how?

Original comment by: campbell-m

jberanek commented 4 years ago

Hello, thanks for your response.

Yes, there is a row with ID 36 in the repeat table. I've deleted all of the repeat entries and I get this error: 

[10-Feb-2020 16:29:34 America/Santiago] Uncaught exception 'MRBS\DBException' in /home/sctbcl/public_html/sitios/reservas/lib/MRBS/DB.php at line 106
SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`sctbcl_reservas`.`cas_entry`, CONSTRAINT `cas_entry_ibfk_2` FOREIGN KEY (`create_by`) REFERENCES `cas_users` (`name`) ON UPDATE CASCADE)
SQL: INSERT INTO cas_entry (`start_time`, `end_time`, `entry_type`, `repeat_id`, `room_id`, `create_by`, `modified_by`, `name`, `type`, `description`, `status`, `ical_uid`, `ical_sequence`, `ical_recur_id`, `galones`, `matricula`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Params: Array
(
    [0] => 1581462000
    [1] => 1581465600
    [2] => 0
    [3] => 
    [4] => 37
    [5] => alfredo@loot.cl
    [6] => 
    [7] => joaquin
    [8] => E
    [9] => fdas
    [10] => 0
    [11] => MRBS-5e41af1e0be4d-fd412072@reservas.sctb.cl
    [12] => 0
    [13] => 
    [14] => 
    [15] => 
)

##0 /home/sctbcl/public_html/sitios/reservas/mrbs_sql.inc(758): MRBS\DB->command('INSERT INTO cas...', Array)
#1 /home/sctbcl/public_html/sitios/reservas/mrbs_sql.inc(789): MRBS\mrbsCreateEntry('cas_entry', Array)
#2 /home/sctbcl/public_html/sitios/reservas/mrbs_sql.inc(2073): MRBS\mrbsCreateSingleEntry(Array)
#3 /home/sctbcl/public_html/sitios/reservas/edit_entry_handler.php(738): MRBS\mrbsMakeBookings(Array, NULL, false, NULL, NULL, true, 'series')
#4 {main}
MRBS GET: Array
(
)
MRBS POST: Array
(
    [csrf_token] => 9fc3b6db1b1621818fe093f5da0df2cae6e9f65218a8a64f2d91dd64427baefa
    [name] => joaquin 
    [description] => fdas
    [start_day] => 11
    [start_month] => 2
    [start_year] => 2020
    [start_seconds] => 72000
    [end_day] => 11
    [end_month] => 2
    [end_year] => 2020
    [end_seconds] => 75600
    [area] => 2
    [rooms] => Array
        (
            [0] => 37
        )

    [type] => E
    [f_galones] => 
    [f_matricula] => 
    [rep_type] => 0
    [rep_day] => Array
        (
            [0] => 2
        )

    [rep_num_weeks] => 1
    [month_type] => 0
    [month_absolute] => 11
    [month_relative_ord] => 2
    [month_relative_day] => TU
    [rep_end_day] => 11
    [rep_end_month] => 2
    [rep_end_year] => 2020
    [returl] => https://reservas.sctb.cl/day.php?year=2020&month=2&day=11&area=2&room=37
    [create_by] => alfredo@loot.cl
    [rep_id] => 0
    [edit_type] => series
)
MRBS SESSION: Array
(
    [csrf_token] => 9fc3b6db1b1621818fe093f5da0df2cae6e9f65218a8a64f2d91dd64427baefa
)

Before this, no error on saving, this started when started using wordpress authentication when I upgraded to 1.6.1, now using 1.7.0.

Also, for some reason, the cookie is not passing the logged in, so I must re log again with the wordpress credentials.

thank you very much.

Original comment by: lootcl

jberanek commented 4 years ago

Thanks. Is there a reason you are using 1.7.0 rather than the latest release (1.7.4.1)?

Also, were you using Wordpress authentication when you were using 1.6.1? If not, what authentication scheme were you using with 1.6.1?

Original comment by: campbell-m

jberanek commented 4 years ago

One more question: which version of MySQL are you using? The information is on the MRBS Help page.

Original comment by: campbell-m

jberanek commented 4 years ago

When I try to upgrade to 1.7.4.1 I get a "Wordpress critical error" "database is not available" when updating the data base. Wordpress is on the latest version. The stable version that works for me now is 1.7.0

I was using 1.4 before with db authentication, now I want clients to just log in one time in order to use all the services on the website.

the MySql version is "MySQL 10.2.31-MariaDB-cll-lve" server_software Apache PHP 7.3.14

Thank you sir!

Original comment by: lootcl

jberanek commented 4 years ago

I know it's probably nothing to do with the integrity constraint violation error, but what's the Wordpress critical error you get? Is there any information in your PHP error log?

Original comment by: campbell-m

jberanek commented 4 years ago

When upgrading from 1.7.0 to 1.7.4.1 I get the following error: 

Actualizando Base de Datos a versión: 55
Error: la base de datos no está disponible en este momento.
There has been a critical error on your website.
Learn more about debugging in WordPress.

0 /home/sctbcl/public_html/sitios/reservas/upgrade.inc(168): MRBS\DB->query('\nALTER TABLE ca...')
1 /home/sctbcl/public_html/sitios/reservas/upgrade.inc(67): MRBS\upgrade_database(false, '54', 59, Object(MRBS\DB_mysql))
2 /home/sctbcl/public_html/sitios/reservas/defaultincludes.inc(33): require_once('/home/sctbcl/pu...')
3 /home/sctbcl/public_html/sitios/reservas/index.php(9): require('/home/sctbcl/pu...')
4 {main}
MRBS GET: Array
(
)
MRBS POST: Array
(
    [csrf_token] => 9fc3b6db1b1621818fe093f5da0df2cae6e9f65218a8a64f2d91dd64427baefa
    [form_username] => sctbcl_reservas
    [form_password] => ****PASSWORD HIDDEN****
)
MRBS SESSION: Array
(
    [csrf_token] => 9fc3b6db1b1621818fe093f5da0df2cae6e9f65218a8a64f2d91dd64427baefa
)

[10-Feb-2020 17:14:01 America/Santiago] 
E_NOTICE in /home/sctbcl/public_html/sitios/reservas/trailer.inc at line 61
Array to string conversion

[10-Feb-2020 17:14:01 America/Santiago] 
E_WARNING in /home/sctbcl/public_html/sitios/reservas/trailer.inc at line 68
mktime() expects parameter 4 to be int, array given
MRBS GET: Array
(
)
MRBS POST: Array
(
    [csrf_token] => 9fc3b6db1b1621818fe093f5da0df2cae6e9f65218a8a64f2d91dd64427baefa
    [form_username] => sctbcl_reservas
    [form_password] => ****PASSWORD HIDDEN****
)
MRBS SESSION: Array
(
    [csrf_token] => 9fc3b6db1b1621818fe093f5da0df2cae6e9f65218a8a64f2d91dd64427baefa
)

[10-Feb-2020 17:14:01 America/Santiago] 
E_WARNING in /home/sctbcl/public_html/sitios/reservas/trailer.inc at line 68
mktime() expects parameter 4 to be int, array given
MRBS GET: Array
(
)
MRBS POST: Array
(
    [csrf_token] => 9fc3b6db1b1621818fe093f5da0df2cae6e9f65218a8a64f2d91dd64427baefa
    [form_username] => sctbcl_reservas
    [form_password] => ****PASSWORD HIDDEN****
)
MRBS SESSION: Array
(
    [csrf_token] => 9fc3b6db1b1621818fe093f5da0df2cae6e9f65218a8a64f2d91dd64427baefa
)

[10-Feb-2020 17:14:01 America/Santiago] 
E_WARNING in /home/sctbcl/public_html/sitios/reservas/trailer.inc at line 68
mktime() expects parameter 4 to be int, array given
MRBS GET: Array
(
)
MRBS POST: Array
(
    [csrf_token] => 9fc3b6db1b1621818fe093f5da0df2cae6e9f65218a8a64f2d91dd64427baefa
    [form_username] => sctbcl_reservas
    [form_password] => ****PASSWORD HIDDEN****
)
MRBS SESSION: Array
(
    [csrf_token] => 9fc3b6db1b1621818fe093f5da0df2cae6e9f65218a8a64f2d91dd64427baefa
)

[10-Feb-2020 17:14:01 America/Santiago] 
E_WARNING in /home/sctbcl/public_html/sitios/reservas/trailer.inc at line 68
mktime() expects parameter 4 to be int, array given
MRBS GET: Array
(
)
MRBS POST: Array
(
    [csrf_token] => 9fc3b6db1b1621818fe093f5da0df2cae6e9f65218a8a64f2d91dd64427baefa
    [form_username] => sctbcl_reservas
    [form_password] => ****PASSWORD HIDDEN****
)
MRBS SESSION: Array
(
    [csrf_token] => 9fc3b6db1b1621818fe093f5da0df2cae6e9f65218a8a64f2d91dd64427baefa
)

[10-Feb-2020 17:14:01 America/Santiago] 
E_WARNING in /home/sctbcl/public_html/sitios/reservas/trailer.inc at line 68
mktime() expects parameter 4 to be int, array given
MRBS GET: Array
(
)
MRBS POST: Array
(
    [csrf_token] => 9fc3b6db1b1621818fe093f5da0df2cae6e9f65218a8a64f2d91dd64427baefa
    [form_username] => sctbcl_reservas
    [form_password] => ****PASSWORD HIDDEN****
)
MRBS SESSION: Array
(
    [csrf_token] => 9fc3b6db1b1621818fe093f5da0df2cae6e9f65218a8a64f2d91dd64427baefa
)

[10-Feb-2020 17:14:01 America/Santiago] 
E_WARNING in /home/sctbcl/public_html/sitios/reservas/trailer.inc at line 68
mktime() expects parameter 4 to be int, array given
MRBS GET: Array
(
)
MRBS POST: Array
(
    [csrf_token] => 9fc3b6db1b1621818fe093f5da0df2cae6e9f65218a8a64f2d91dd64427baefa
    [form_username] => sctbcl_reservas
    [form_password] => ****PASSWORD HIDDEN****
)
MRBS SESSION: Array
(
    [csrf_token] => 9fc3b6db1b1621818fe093f5da0df2cae6e9f65218a8a64f2d91dd64427baefa
)

[10-Feb-2020 17:14:01 America/Santiago] 
E_WARNING in /home/sctbcl/public_html/sitios/reservas/trailer.inc at line 68
mktime() expects parameter 4 to be int, array given
MRBS GET: Array
(
)
MRBS POST: Array
(
    [csrf_token] => 9fc3b6db1b1621818fe093f5da0df2cae6e9f65218a8a64f2d91dd64427baefa
    [form_username] => sctbcl_reservas
    [form_password] => ****PASSWORD HIDDEN****
)
MRBS SESSION: Array
(
    [csrf_token] => 9fc3b6db1b1621818fe093f5da0df2cae6e9f65218a8a64f2d91dd64427baefa
)

[10-Feb-2020 17:14:01 America/Santiago] 
E_WARNING in /home/sctbcl/public_html/sitios/reservas/trailer.inc at line 68
mktime() expects parameter 4 to be int, array given
MRBS GET: Array
(
)
MRBS POST: Array
(
    [csrf_token] => 9fc3b6db1b1621818fe093f5da0df2cae6e9f65218a8a64f2d91dd64427baefa
    [form_username] => sctbcl_reservas
    [form_password] => ****PASSWORD HIDDEN****
)
MRBS SESSION: Array
(
    [csrf_token] => 9fc3b6db1b1621818fe093f5da0df2cae6e9f65218a8a64f2d91dd64427baefa
)

[10-Feb-2020 17:14:01 America/Santiago] 
E_WARNING in /home/sctbcl/public_html/sitios/reservas/trailer.inc at line 68
mktime() expects parameter 4 to be int, array given
MRBS GET: Array
(
)
MRBS POST: Array
(
    [csrf_token] => 9fc3b6db1b1621818fe093f5da0df2cae6e9f65218a8a64f2d91dd64427baefa
    [form_username] => sctbcl_reservas
    [form_password] => ****PASSWORD HIDDEN****
)
MRBS SESSION: Array
(
    [csrf_token] => 9fc3b6db1b1621818fe093f5da0df2cae6e9f65218a8a64f2d91dd64427baefa
)

[10-Feb-2020 17:14:01 America/Santiago] 
E_WARNING in /home/sctbcl/public_html/sitios/reservas/trailer.inc at line 68
mktime() expects parameter 4 to be int, array given
MRBS GET: Array
(
)
MRBS POST: Array
(
    [csrf_token] => 9fc3b6db1b1621818fe093f5da0df2cae6e9f65218a8a64f2d91dd64427baefa
    [form_username] => sctbcl_reservas
    [form_password] => ****PASSWORD HIDDEN****
)
MRBS SESSION: Array
(
    [csrf_token] => 9fc3b6db1b1621818fe093f5da0df2cae6e9f65218a8a64f2d91dd64427baefa
)

[10-Feb-2020 17:14:01 America/Santiago] 
E_WARNING in /home/sctbcl/public_html/sitios/reservas/trailer.inc at line 68
mktime() expects parameter 4 to be int, array given
MRBS GET: Array
(
)
MRBS POST: Array
(
    [csrf_token] => 9fc3b6db1b1621818fe093f5da0df2cae6e9f65218a8a64f2d91dd64427baefa
    [form_username] => sctbcl_reservas
    [form_password] => ****PASSWORD HIDDEN****
)
MRBS SESSION: Array
(
    [csrf_token] => 9fc3b6db1b1621818fe093f5da0df2cae6e9f65218a8a64f2d91dd64427baefa
)

[10-Feb-2020 17:14:01 America/Santiago] 
E_WARNING in /home/sctbcl/public_html/sitios/reservas/trailer.inc at line 68
mktime() expects parameter 4 to be int, array given
MRBS GET: Array
(
)
MRBS POST: Array
(
    [csrf_token] => 9fc3b6db1b1621818fe093f5da0df2cae6e9f65218a8a64f2d91dd64427baefa
    [form_username] => sctbcl_reservas
    [form_password] => ****PASSWORD HIDDEN****
)
MRBS SESSION: Array
(
    [csrf_token] => 9fc3b6db1b1621818fe093f5da0df2cae6e9f65218a8a64f2d91dd64427baefa
)

[10-Feb-2020 17:14:01 America/Santiago] 
E_WARNING in /home/sctbcl/public_html/sitios/reservas/trailer.inc at line 68
mktime() expects parameter 4 to be int, array given
MRBS GET: Array
(
)
MRBS POST: Array
(
    [csrf_token] => 9fc3b6db1b1621818fe093f5da0df2cae6e9f65218a8a64f2d91dd64427baefa
    [form_username] => sctbcl_reservas
    [form_password] => ****PASSWORD HIDDEN****
)
MRBS SESSION: Array
(
    [csrf_token] => 9fc3b6db1b1621818fe093f5da0df2cae6e9f65218a8a64f2d91dd64427baefa
)

[10-Feb-2020 17:14:01 America/Santiago] 
E_WARNING in /home/sctbcl/public_html/sitios/reservas/trailer.inc at line 68
mktime() expects parameter 4 to be int, array given
MRBS GET: Array
(
)
MRBS POST: Array
(
    [csrf_token] => 9fc3b6db1b1621818fe093f5da0df2cae6e9f65218a8a64f2d91dd64427baefa
    [form_username] => sctbcl_reservas
    [form_password] => ****PASSWORD HIDDEN****
)
MRBS SESSION: Array
(
    [csrf_token] => 9fc3b6db1b1621818fe093f5da0df2cae6e9f65218a8a64f2d91dd64427baefa
)

[10-Feb-2020 17:14:01 America/Santiago] 
E_NOTICE in /home/sctbcl/public_html/sitios/reservas/trailer.inc at line 117
Array to string conversion

[10-Feb-2020 17:14:01 America/Santiago] 
E_WARNING in /home/sctbcl/public_html/sitios/reservas/trailer.inc at line 121
mktime() expects parameter 4 to be int, array given
MRBS GET: Array
(
)
MRBS POST: Array
(
    [csrf_token] => 9fc3b6db1b1621818fe093f5da0df2cae6e9f65218a8a64f2d91dd64427baefa
    [form_username] => sctbcl_reservas
    [form_password] => ****PASSWORD HIDDEN****
)
MRBS SESSION: Array
(
    [csrf_token] => 9fc3b6db1b1621818fe093f5da0df2cae6e9f65218a8a64f2d91dd64427baefa
)

[10-Feb-2020 17:14:01 America/Santiago] 
E_WARNING in /home/sctbcl/public_html/sitios/reservas/trailer.inc at line 128
mktime() expects parameter 4 to be int, array given
MRBS GET: Array
(
)
MRBS POST: Array
(
    [csrf_token] => 9fc3b6db1b1621818fe093f5da0df2cae6e9f65218a8a64f2d91dd64427baefa
    [form_username] => sctbcl_reservas
    [form_password] => ****PASSWORD HIDDEN****
)
MRBS SESSION: Array
(
    [csrf_token] => 9fc3b6db1b1621818fe093f5da0df2cae6e9f65218a8a64f2d91dd64427baefa
)

[10-Feb-2020 17:14:01 America/Santiago] 
E_WARNING in /home/sctbcl/public_html/sitios/reservas/trailer.inc at line 137
mktime() expects parameter 4 to be int, array given
MRBS GET: Array
(
)
MRBS POST: Array
(
    [csrf_token] => 9fc3b6db1b1621818fe093f5da0df2cae6e9f65218a8a64f2d91dd64427baefa
    [form_username] => sctbcl_reservas
    [form_password] => ****PASSWORD HIDDEN****
)
MRBS SESSION: Array
(
    [csrf_token] => 9fc3b6db1b1621818fe093f5da0df2cae6e9f65218a8a64f2d91dd64427baefa
)

[10-Feb-2020 17:14:01 America/Santiago] 
E_WARNING in /home/sctbcl/public_html/sitios/reservas/trailer.inc at line 128
mktime() expects parameter 4 to be int, array given
MRBS GET: Array
(
)
MRBS POST: Array
(
    [csrf_token] => 9fc3b6db1b1621818fe093f5da0df2cae6e9f65218a8a64f2d91dd64427baefa
    [form_username] => sctbcl_reservas
    [form_password] => ****PASSWORD HIDDEN****
)
MRBS SESSION: Array
(
    [csrf_token] => 9fc3b6db1b1621818fe093f5da0df2cae6e9f65218a8a64f2d91dd64427baefa
)

[10-Feb-2020 17:14:01 America/Santiago] 
E_WARNING in /home/sctbcl/public_html/sitios/reservas/trailer.inc at line 137
mktime() expects parameter 4 to be int, array given
MRBS GET: Array
(
)
MRBS POST: Array
(
    [csrf_token] => 9fc3b6db1b1621818fe093f5da0df2cae6e9f65218a8a64f2d91dd64427baefa
    [form_username] => sctbcl_reservas
    [form_password] => ****PASSWORD HIDDEN****
)
MRBS SESSION: Array
(
    [csrf_token] => 9fc3b6db1b1621818fe093f5da0df2cae6e9f65218a8a64f2d91dd64427baefa
)

[10-Feb-2020 17:14:01 America/Santiago] 
E_WARNING in /home/sctbcl/public_html/sitios/reservas/trailer.inc at line 128
mktime() expects parameter 4 to be int, array given
MRBS GET: Array
(
)
MRBS POST: Array
(
    [csrf_token] => 9fc3b6db1b1621818fe093f5da0df2cae6e9f65218a8a64f2d91dd64427baefa
    [form_username] => sctbcl_reservas
    [form_password] => ****PASSWORD HIDDEN****
)
MRBS SESSION: Array
(
    [csrf_token] => 9fc3b6db1b1621818fe093f5da0df2cae6e9f65218a8a64f2d91dd64427baefa
)

[10-Feb-2020 17:14:01 America/Santiago] 
E_WARNING in /home/sctbcl/public_html/sitios/reservas/trailer.inc at line 137
mktime() expects parameter 4 to be int, array given
MRBS GET: Array
(
)
MRBS POST: Array
(
    [csrf_token] => 9fc3b6db1b1621818fe093f5da0df2cae6e9f65218a8a64f2d91dd64427baefa
    [form_username] => sctbcl_reservas
    [form_password] => ****PASSWORD HIDDEN****
)
MRBS SESSION: Array
(
    [csrf_token] => 9fc3b6db1b1621818fe093f5da0df2cae6e9f65218a8a64f2d91dd64427baefa
)

[10-Feb-2020 17:14:01 America/Santiago] 
E_WARNING in /home/sctbcl/public_html/sitios/reservas/trailer.inc at line 128
mktime() expects parameter 4 to be int, array given
MRBS GET: Array
(
)
MRBS POST: Array
(
    [csrf_token] => 9fc3b6db1b1621818fe093f5da0df2cae6e9f65218a8a64f2d91dd64427baefa
    [form_username] => sctbcl_reservas
    [form_password] => ****PASSWORD HIDDEN****
)
MRBS SESSION: Array
(
    [csrf_token] => 9fc3b6db1b1621818fe093f5da0df2cae6e9f65218a8a64f2d91dd64427baefa
)

[10-Feb-2020 17:14:01 America/Santiago] 
E_WARNING in /home/sctbcl/public_html/sitios/reservas/trailer.inc at line 137
mktime() expects parameter 4 to be int, array given
MRBS GET: Array
(
)
MRBS POST: Array
(
    [csrf_token] => 9fc3b6db1b1621818fe093f5da0df2cae6e9f65218a8a64f2d91dd64427baefa
    [form_username] => sctbcl_reservas
    [form_password] => ****PASSWORD HIDDEN****
)
MRBS SESSION: Array
(
    [csrf_token] => 9fc3b6db1b1621818fe093f5da0df2cae6e9f65218a8a64f2d91dd64427baefa
)

[10-Feb-2020 17:14:01 America/Santiago] 
E_WARNING in /home/sctbcl/public_html/sitios/reservas/trailer.inc at line 128
mktime() expects parameter 4 to be int, array given
MRBS GET: Array
(
)
MRBS POST: Array
(
    [csrf_token] => 9fc3b6db1b1621818fe093f5da0df2cae6e9f65218a8a64f2d91dd64427baefa
    [form_username] => sctbcl_reservas
    [form_password] => ****PASSWORD HIDDEN****
)
MRBS SESSION: Array
(
    [csrf_token] => 9fc3b6db1b1621818fe093f5da0df2cae6e9f65218a8a64f2d91dd64427baefa
)

[10-Feb-2020 17:14:01 America/Santiago] 
E_WARNING in /home/sctbcl/public_html/sitios/reservas/trailer.inc at line 137
mktime() expects parameter 4 to be int, array given
MRBS GET: Array
(
)
MRBS POST: Array
(
    [csrf_token] => 9fc3b6db1b1621818fe093f5da0df2cae6e9f65218a8a64f2d91dd64427baefa
    [form_username] => sctbcl_reservas
    [form_password] => ****PASSWORD HIDDEN****
)
MRBS SESSION: Array
(
    [csrf_token] => 9fc3b6db1b1621818fe093f5da0df2cae6e9f65218a8a64f2d91dd64427baefa
)

[10-Feb-2020 17:14:01 America/Santiago] 
E_WARNING in /home/sctbcl/public_html/sitios/reservas/trailer.inc at line 128
mktime() expects parameter 4 to be int, array given
MRBS GET: Array
(
)
MRBS POST: Array
(
    [csrf_token] => 9fc3b6db1b1621818fe093f5da0df2cae6e9f65218a8a64f2d91dd64427baefa
    [form_username] => sctbcl_reservas
    [form_password] => ****PASSWORD HIDDEN****
)
MRBS SESSION: Array
(
    [csrf_token] => 9fc3b6db1b1621818fe093f5da0df2cae6e9f65218a8a64f2d91dd64427baefa
)

[10-Feb-2020 17:14:01 America/Santiago] 
E_WARNING in /home/sctbcl/public_html/sitios/reservas/trailer.inc at line 137
mktime() expects parameter 4 to be int, array given
MRBS GET: Array
(
)
MRBS POST: Array
(
    [csrf_token] => 9fc3b6db1b1621818fe093f5da0df2cae6e9f65218a8a64f2d91dd64427baefa
    [form_username] => sctbcl_reservas
    [form_password] => ****PASSWORD HIDDEN****
)
MRBS SESSION: Array
(
    [csrf_token] => 9fc3b6db1b1621818fe093f5da0df2cae6e9f65218a8a64f2d91dd64427baefa
)

[10-Feb-2020 17:14:01 America/Santiago] 
E_WARNING in /home/sctbcl/public_html/sitios/reservas/trailer.inc at line 128
mktime() expects parameter 4 to be int, array given
MRBS GET: Array
(
)
MRBS POST: Array
(
    [csrf_token] => 9fc3b6db1b1621818fe093f5da0df2cae6e9f65218a8a64f2d91dd64427baefa
    [form_username] => sctbcl_reservas
    [form_password] => ****PASSWORD HIDDEN****
)
MRBS SESSION: Array
(
    [csrf_token] => 9fc3b6db1b1621818fe093f5da0df2cae6e9f65218a8a64f2d91dd64427baefa
)

[10-Feb-2020 17:14:01 America/Santiago] 
E_WARNING in /home/sctbcl/public_html/sitios/reservas/trailer.inc at line 137
mktime() expects parameter 4 to be int, array given
MRBS GET: Array
(
)
MRBS POST: Array
(
    [csrf_token] => 9fc3b6db1b1621818fe093f5da0df2cae6e9f65218a8a64f2d91dd64427baefa
    [form_username] => sctbcl_reservas
    [form_password] => ****PASSWORD HIDDEN****
)
MRBS SESSION: Array
(
    [csrf_token] => 9fc3b6db1b1621818fe093f5da0df2cae6e9f65218a8a64f2d91dd64427baefa
)

[10-Feb-2020 17:14:01 America/Santiago] 
E_WARNING in /home/sctbcl/public_html/sitios/reservas/trailer.inc at line 128
mktime() expects parameter 4 to be int, array given
MRBS GET: Array
(
)
MRBS POST: Array
(
    [csrf_token] => 9fc3b6db1b1621818fe093f5da0df2cae6e9f65218a8a64f2d91dd64427baefa
    [form_username] => sctbcl_reservas
    [form_password] => ****PASSWORD HIDDEN****
)
MRBS SESSION: Array
(
    [csrf_token] => 9fc3b6db1b1621818fe093f5da0df2cae6e9f65218a8a64f2d91dd64427baefa
)

[10-Feb-2020 17:14:01 America/Santiago] 
E_WARNING in /home/sctbcl/public_html/sitios/reservas/trailer.inc at line 137
mktime() expects parameter 4 to be int, array given
MRBS GET: Array
(
)
MRBS POST: Array
(
    [csrf_token] => 9fc3b6db1b1621818fe093f5da0df2cae6e9f65218a8a64f2d91dd64427baefa
    [form_username] => sctbcl_reservas
    [form_password] => ****PASSWORD HIDDEN****
)
MRBS SESSION: Array
(
    [csrf_token] => 9fc3b6db1b1621818fe093f5da0df2cae6e9f65218a8a64f2d91dd64427baefa
)

[10-Feb-2020 17:14:01 America/Santiago] 
E_WARNING in /home/sctbcl/public_html/sitios/reservas/trailer.inc at line 128
mktime() expects parameter 4 to be int, array given
MRBS GET: Array
(
)
MRBS POST: Array
(
    [csrf_token] => 9fc3b6db1b1621818fe093f5da0df2cae6e9f65218a8a64f2d91dd64427baefa
    [form_username] => sctbcl_reservas
    [form_password] => ****PASSWORD HIDDEN****
)
MRBS SESSION: Array
(
    [csrf_token] => 9fc3b6db1b1621818fe093f5da0df2cae6e9f65218a8a64f2d91dd64427baefa
)

[10-Feb-2020 17:14:01 America/Santiago] 
E_WARNING in /home/sctbcl/public_html/sitios/reservas/trailer.inc at line 137
mktime() expects parameter 4 to be int, array given
MRBS GET: Array
(
)
MRBS POST: Array
(
    [csrf_token] => 9fc3b6db1b1621818fe093f5da0df2cae6e9f65218a8a64f2d91dd64427baefa
    [form_username] => sctbcl_reservas
    [form_password] => ****PASSWORD HIDDEN****
)
MRBS SESSION: Array
(
    [csrf_token] => 9fc3b6db1b1621818fe093f5da0df2cae6e9f65218a8a64f2d91dd64427baefa
)

[10-Feb-2020 17:14:01 America/Santiago] 
E_NOTICE in /home/sctbcl/public_html/sitios/reservas/trailer.inc at line 173
Array to string conversion

[10-Feb-2020 17:14:01 America/Santiago] PHP Fatal error:  Uncaught Error: Unsupported operand types in /home/sctbcl/public_html/sitios/reservas/trailer.inc:180
Stack trace:
0 /home/sctbcl/public_html/sitios/reservas/trailer.inc(217): MRBS\generate_trailer()
1 /home/sctbcl/public_html/sitios/reservas/functions_error.inc(124): MRBS\output_trailer()
2 /home/sctbcl/public_html/sitios/reservas/functions_error.inc(112): MRBS\fatal_error('Error: la base ...')
3 [internal function]: MRBS\exception_handler(Object(MRBS\DBException))
4 {main}
  thrown in /home/sctbcl/public_html/sitios/reservas/trailer.inc on line 180

Original comment by: lootcl

jberanek commented 4 years ago

Can you reproduce this problem (ie the integrity constraint violation) reliably? If so, how?

Original comment by: campbell-m