#258 Cannot create a reservation

None
closed
nobody
None
1
2012-09-05
2012-07-31
Prof_Moriarti
No

Hello all

I have a problem with the mrbs system, i have installed and configured the system and it had worked fine for some days (2 weeks more or less), then when anybody wants to create a reservation the mrbs is very very slow. (it doesnt appears the 2 green check marks at the end of the page).

I have done the isntallation on several enviroments
Windows with xampp same issue, so i thought it could be better to move it to a linux environment, but it happens again. Witha fresh installation it works fine but when after some days past the mrbs is hanged.

I have updated to the latest versions of apache mysql and php but with no solutions.

I have others websites in the system (using mysql) and there are no problems in these websites.

Server is not overloaded in its resources

Sever is in a intranet with 4 or 5 accesses per day (is almost nothing).

the database has only 175 records.

Loading Reports page and getting the results of any query runs perfect is only when you try to make a reservation.

If you need further information i will provide it

Sistema de Reservas de Salas y Aulas: MRBS 1.4.8
Base de Datos: MySQL 5.1.61-0ubuntu0.10.10.1
Sistema: Linux wikisalas 2.6.35-22-generic-pae #33-Ubuntu SMP Sun Sep 19 22:14:14 UTC 2010 i686
Hora del Servidor: mar 31 jul 2012 14:42:47 CEST
PHP: 5.3.3-1ubuntu9.10

Sorry for my poor english

Best regards

Nacho

Related

Bugs: #240

Discussion

1 2 > >> (Page 1 of 2)
  • Things to try:
    (1) Can you try disabling JavaScript in your browser and see if the problem goes away? (2) Whether it does or not can you then turn JavaScript back on and look in the JavaScript console to see if there are any error messages
    (3) Can you check your system error logs

    Campbell

     
  • Prof_Moriarti
    Prof_Moriarti
    2012-08-01

    Hello Campbell
    Thxs for your reply

    a) Disabling scripts same speed same behaviour in IE 9 and Firefox 14 and
    lower
    b) No errors at least i have undersood that in the console, just a warning
    referring the color schema (see attached screenshot) (sorry messages are in
    Spanish)
    c) I have try to find any problem in the system logs but i haven´t found
    anything, i have make some captures that show you the preformance of the
    server.

    Deleting a reservation is fast, editing and creating is slow
    Looking forward to hearing from you

    Regards
    Nacho

    2012/7/31 Campbell Morrison cimorrison@users.sf.net

    Things to try:
    (1) Can you try disabling JavaScript in your browser and see if the
    problem goes away? (2) Whether it does or not can you then turn JavaScript
    back on and look in the JavaScript console to see if there are any error
    messages
    (3) Can you check your system error logs

    Campbell

    • support-requests:258 Cannot create a reservation*

    Status: open Created: Tue Jul 31, 2012 12:43 PM UTC by Prof_Moriarti Last
    Updated:
    Tue Jul 31, 2012 12:43 PM UTC Owner: nobody

    Hello all

    I have a problem with the mrbs system, i have installed and configured the
    system and it had worked fine for some days (2 weeks more or less), then
    when anybody wants to create a reservation the mrbs is very very slow. (it
    doesnt appears the 2 green check marks at the end of the page).

    I have done the isntallation on several enviroments
    Windows with xampp same issue, so i thought it could be better to move it
    to a linux environment, but it happens again. Witha fresh installation it
    works fine but when after some days past the mrbs is hanged.

    I have updated to the latest versions of apache mysql and php but with no
    solutions.

    I have others websites in the system (using mysql) and there are no
    problems in these websites.

    Server is not overloaded in its resources

    Sever is in a intranet with 4 or 5 accesses per day (is almost nothing).

    the database has only 175 records.

    Loading Reports page and getting the results of any query runs perfect is
    only when you try to make a reservation.

    If you need further information i will provide it

    Sistema de Reservas de Salas y Aulas: MRBS 1.4.8
    Base de Datos: MySQL 5.1.61-0ubuntu0.10.10.1
    Sistema: Linux wikisalas 2.6.35-22-generic-pae #33-Ubuntu SMP Sun Sep 19
    22:14:14 UTC 2010 i686
    Hora del Servidor: mar 31 jul 2012 14:42:47 CEST
    PHP: 5.3.3-1ubuntu9.10

    Sorry for my poor english

    Best regards

    Nacho

    Sent from sourceforge.net because you indicated interest in
    https://sourceforge.net/p/mrbs/support-requests/258/

    To unsubscribe from further messages, please visit
    https://sourceforge.net/auth/prefs/

     
  • Can you try making the following change and let me know if it makes any difference. See also SF Support Request 252 and SF Bug 240.

    Thanks,

    Campbell

    In edit_entry_handler.php add the line

    sql_mutex_unlock("$tbl_entry");

    at line 647, ie just after

    // If this is an Ajax request and if it's not a valid booking which we want
    // to commit, then output the results and exit. Otherwise we go on to commit the
    // booking
    if ($ajax && function_exists('json_encode'))
    {
    if (!($commit && $valid_booking))
    {

     
  • Prof_Moriarti
    Prof_Moriarti
    2012-08-08

    Hi Campbell
    Same speed :(
    I have attached the modified file, in order to check if the changes are good
    Nacho

    2012/8/8 Campbell Morrison cimorrison@users.sf.net

    Can you try making the following change and let me know if it makes any
    difference. See also SF Support Request 252 and SF Bug 240.

    Thanks,

    Campbell

    In edit_entry_handler.php add the line

    sql_mutex_unlock("$tbl_entry");

    at line 647, ie just after

    // If this is an Ajax request and if it's not a valid booking which we want
    // to commit, then output the results and exit. Otherwise we go on to
    commit the
    // booking
    if ($ajax && function_exists('json_encode'))
    {
    if (!($commit && $valid_booking))
    {


    • support-requests:258 Cannot create a reservation*

    Status: open Created: Tue Jul 31, 2012 12:43 PM UTC by Prof_Moriarti Last
    Updated:
    Tue Jul 31, 2012 08:41 PM UTC Owner: nobody

    Hello all

    I have a problem with the mrbs system, i have installed and configured the
    system and it had worked fine for some days (2 weeks more or less), then
    when anybody wants to create a reservation the mrbs is very very slow. (it
    doesnt appears the 2 green check marks at the end of the page).

    I have done the isntallation on several enviroments
    Windows with xampp same issue, so i thought it could be better to move it
    to a linux environment, but it happens again. Witha fresh installation it
    works fine but when after some days past the mrbs is hanged.

    I have updated to the latest versions of apache mysql and php but with no
    solutions.

    I have others websites in the system (using mysql) and there are no
    problems in these websites.

    Server is not overloaded in its resources

    Sever is in a intranet with 4 or 5 accesses per day (is almost nothing).

    the database has only 175 records.

    Loading Reports page and getting the results of any query runs perfect is
    only when you try to make a reservation.

    If you need further information i will provide it

    Sistema de Reservas de Salas y Aulas: MRBS 1.4.8
    Base de Datos: MySQL 5.1.61-0ubuntu0.10.10.1
    Sistema: Linux wikisalas 2.6.35-22-generic-pae #33-Ubuntu SMP Sun Sep 19
    22:14:14 UTC 2010 i686
    Hora del Servidor: mar 31 jul 2012 14:42:47 CEST
    PHP: 5.3.3-1ubuntu9.10

    Sorry for my poor english

    Best regards

    Nacho

    Sent from sourceforge.net because you indicated interest in
    https://sourceforge.net/p/mrbs/support-requests/258/

    To unsubscribe from further messages, please visit
    https://sourceforge.net/auth/prefs/

     
  • For some reason I cannot see any of your attachments. I am attaching my own copy of edit_entry_handler.php with the modification. Can you try that, or else compare it with your file?

    Thanks,

    Campbell

     
  • Prof_Moriarti
    Prof_Moriarti
    2012-08-09

    Good Morning Campbell

    I have not receive any file in your last email
    Please can you send me it zipped to
    nacho.aguinaga@accelya.com
    It seems gmail is doing things

    Thxs
    Nacho

    2012/8/8 Campbell Morrison cimorrison@users.sf.net

    Can you try making the following change and let me know if it makes any
    difference. See also SF Support Request 252 and SF Bug 240.

    Thanks,

    Campbell

    In edit_entry_handler.php add the line

    sql_mutex_unlock("$tbl_entry");

    at line 647, ie just after

    // If this is an Ajax request and if it's not a valid booking which we want
    // to commit, then output the results and exit. Otherwise we go on to
    commit the
    // booking
    if ($ajax && function_exists('json_encode'))
    {
    if (!($commit && $valid_booking))
    {


    • support-requests:258 Cannot create a reservation*

    Status: open Created: Tue Jul 31, 2012 12:43 PM UTC by Prof_Moriarti Last
    Updated:
    Tue Jul 31, 2012 08:41 PM UTC Owner: nobody

    Hello all

    I have a problem with the mrbs system, i have installed and configured the
    system and it had worked fine for some days (2 weeks more or less), then
    when anybody wants to create a reservation the mrbs is very very slow. (it
    doesnt appears the 2 green check marks at the end of the page).

    I have done the isntallation on several enviroments
    Windows with xampp same issue, so i thought it could be better to move it
    to a linux environment, but it happens again. Witha fresh installation it
    works fine but when after some days past the mrbs is hanged.

    I have updated to the latest versions of apache mysql and php but with no
    solutions.

    I have others websites in the system (using mysql) and there are no
    problems in these websites.

    Server is not overloaded in its resources

    Sever is in a intranet with 4 or 5 accesses per day (is almost nothing).

    the database has only 175 records.

    Loading Reports page and getting the results of any query runs perfect is
    only when you try to make a reservation.

    If you need further information i will provide it

    Sistema de Reservas de Salas y Aulas: MRBS 1.4.8
    Base de Datos: MySQL 5.1.61-0ubuntu0.10.10.1
    Sistema: Linux wikisalas 2.6.35-22-generic-pae #33-Ubuntu SMP Sun Sep 19
    22:14:14 UTC 2010 i686
    Hora del Servidor: mar 31 jul 2012 14:42:47 CEST
    PHP: 5.3.3-1ubuntu9.10

    Sorry for my poor english

    Best regards

    Nacho

    Sent from sourceforge.net because you indicated interest in
    https://sourceforge.net/p/mrbs/support-requests/258/

    To unsubscribe from further messages, please visit
    https://sourceforge.net/auth/prefs/

     
  • Prof_Moriarti
    Prof_Moriarti
    2012-08-09

    Hi Campbell i have paste the downloaded page and i have compared them
    Both are indentical
    Same slow speed.

    /nacho

    2012/8/9 Campbell Morrison cimorrison@users.sf.net

    The file won't come through in the notification email, but it is posted on
    the Sourceforge site here:

    https://sourceforge.net/p/mrbs/support-requests/_discuss/thread/7c40ca32/95df/attachment/edit_entry_handler.php

    Campbell

    • support-requests:258 Cannot create a reservation*

    Status: open Created: Tue Jul 31, 2012 12:43 PM UTC by Prof_Moriarti Last
    Updated:
    Wed Aug 08, 2012 09:34 AM UTC Owner: nobody

    Hello all

    I have a problem with the mrbs system, i have installed and configured the
    system and it had worked fine for some days (2 weeks more or less), then
    when anybody wants to create a reservation the mrbs is very very slow. (it
    doesnt appears the 2 green check marks at the end of the page).

    I have done the isntallation on several enviroments
    Windows with xampp same issue, so i thought it could be better to move it
    to a linux environment, but it happens again. Witha fresh installation it
    works fine but when after some days past the mrbs is hanged.

    I have updated to the latest versions of apache mysql and php but with no
    solutions.

    I have others websites in the system (using mysql) and there are no
    problems in these websites.

    Server is not overloaded in its resources

    Sever is in a intranet with 4 or 5 accesses per day (is almost nothing).

    the database has only 175 records.

    Loading Reports page and getting the results of any query runs perfect is
    only when you try to make a reservation.

    If you need further information i will provide it

    Sistema de Reservas de Salas y Aulas: MRBS 1.4.8
    Base de Datos: MySQL 5.1.61-0ubuntu0.10.10.1
    Sistema: Linux wikisalas 2.6.35-22-generic-pae #33-Ubuntu SMP Sun Sep 19
    22:14:14 UTC 2010 i686
    Hora del Servidor: mar 31 jul 2012 14:42:47 CEST
    PHP: 5.3.3-1ubuntu9.10

    Sorry for my poor english

    Best regards

    Nacho

    Sent from sourceforge.net because you indicated interest in
    https://sourceforge.net/p/mrbs/support-requests/258/

    To unsubscribe from further messages, please visit
    https://sourceforge.net/auth/prefs/

     
  • Prof_Moriarti
    Prof_Moriarti
    2012-08-30

    Hello Campbell do you any idea
    unfortunatelly system is getting more a more slow

    2012/8/9 Prof_Moriarti prof_moriarti@users.sf.net

    Hi Campbell i have paste the downloaded page and i have compared them
    Both are indentical
    Same slow speed.

    /nacho

    2012/8/9 Campbell Morrison cimorrison@users.sf.net

    The file won't come through in the notification email, but it is posted on
    the Sourceforge site here:

    https://sourceforge.net/p/mrbs/support-requests/_discuss/thread/7c40ca32/95df/attachment/edit_entry_handler.php
    Campbell

    • support-requests:258 Cannot create a reservation*

    Status: open Created: Tue Jul 31, 2012 12:43 PM UTC by Prof_Moriarti Last
    Updated:
    Wed Aug 08, 2012 09:34 AM UTC Owner: nobody

    Hello all

    I have a problem with the mrbs system, i have installed and configured the
    system and it had worked fine for some days (2 weeks more or less), then
    when anybody wants to create a reservation the mrbs is very very slow. (it
    doesnt appears the 2 green check marks at the end of the page).

    I have done the isntallation on several enviroments
    Windows with xampp same issue, so i thought it could be better to move it
    to a linux environment, but it happens again. Witha fresh installation it
    works fine but when after some days past the mrbs is hanged.

    I have updated to the latest versions of apache mysql and php but with no
    solutions.

    I have others websites in the system (using mysql) and there are no
    problems in these websites.

    Server is not overloaded in its resources

    Sever is in a intranet with 4 or 5 accesses per day (is almost nothing).

    the database has only 175 records.

    Loading Reports page and getting the results of any query runs perfect is
    only when you try to make a reservation.

    If you need further information i will provide it

    Sistema de Reservas de Salas y Aulas: MRBS 1.4.8
    Base de Datos: MySQL 5.1.61-0ubuntu0.10.10.1
    Sistema: Linux wikisalas 2.6.35-22-generic-pae #33-Ubuntu SMP Sun Sep 19
    22:14:14 UTC 2010 i686
    Hora del Servidor: mar 31 jul 2012 14:42:47 CEST
    PHP: 5.3.3-1ubuntu9.10

    Sorry for my poor english

    Best regards
    Nacho

    Sent from sourceforge.net because you indicated interest in
    https://sourceforge.net/p/mrbs/support-requests/258/

    To unsubscribe from further messages, please visit
    https://sourceforge.net/auth/prefs/


    • support-requests:258 Cannot create a reservation*

    Status: open Created: Tue Jul 31, 2012 12:43 PM UTC by Prof_Moriarti Last
    Updated:
    Thu Aug 09, 2012 07:37 AM UTC Owner: nobody

    Hello all

    I have a problem with the mrbs system, i have installed and configured the
    system and it had worked fine for some days (2 weeks more or less), then
    when anybody wants to create a reservation the mrbs is very very slow. (it
    doesnt appears the 2 green check marks at the end of the page).

    I have done the isntallation on several enviroments
    Windows with xampp same issue, so i thought it could be better to move it
    to a linux environment, but it happens again. Witha fresh installation it
    works fine but when after some days past the mrbs is hanged.

    I have updated to the latest versions of apache mysql and php but with no
    solutions.

    I have others websites in the system (using mysql) and there are no
    problems in these websites.

    Server is not overloaded in its resources

    Sever is in a intranet with 4 or 5 accesses per day (is almost nothing).

    the database has only 175 records.

    Loading Reports page and getting the results of any query runs perfect is
    only when you try to make a reservation.

    If you need further information i will provide it

    Sistema de Reservas de Salas y Aulas: MRBS 1.4.8
    Base de Datos: MySQL 5.1.61-0ubuntu0.10.10.1
    Sistema: Linux wikisalas 2.6.35-22-generic-pae #33-Ubuntu SMP Sun Sep 19
    22:14:14 UTC 2010 i686
    Hora del Servidor: mar 31 jul 2012 14:42:47 CEST
    PHP: 5.3.3-1ubuntu9.10

    Sorry for my poor english

    Best regards

    Nacho

    Sent from sourceforge.net because you indicated interest in
    https://sourceforge.net/p/mrbs/support-requests/258/

    To unsubscribe from further messages, please visit
    https://sourceforge.net/auth/prefs/

     
1 2 > >> (Page 1 of 2)


Anonymous


Cancel   Add attachments