area admin meeting approval modification errors

[jberanek]

HI

i have installed MRBS and configured to authenticate through LDAP(AD). everything seems working fine

i tried to do some changes on mrbs code .i created extra column on mrbs_room called mrbs_admin

and i have changed three files

1] mrbs_auth.inc modified function 2] pending.php 3] Themes/default/header.inc

but the issue is after reloading the Apache server, mrbs home page is getting, but when i try to login with ldap user, i am getting below error

[Tue Jan 07 06:14:23 2014] [error] [client 10.18.9.101] MRBS: Fatal error: unfortunately the database is not available at the moment., referer: http://mrbs.test.com/week.php?year=2014&month=1&day=7&area=25&room=32 [Tue Jan 07 06:14:23 2014] [error] [client 10.18.9.101] MRBS GET: Array\n(\n [year] => 2014\n [month] => 1\n [day] => 7\n [area] => 25\n [room] => 32\n)\n, referer: http://mrbs.test.com/week.php?year=2014&month=1&day=7&area=25&room=32 [Tue Jan 07 06:14:23 2014] [error] [client 10.18.9.101] MRBS SESSION: Array\n(\n [UserName] => ben.george\n)\n, referer: http://mrbs.test.com/week.php?year=2014&month=1&day=7&area=25&room=32

even i got "unfortunately the database is not available at the moment.," on web page also. but the mysql DB is running

if i revert the 3 files back , it's got worked again.

anyone please help me to solve this issue

i am attaching the modified files here

Reported by: bentech4u

Original Ticket: mrbs/support-requests/445

Attachments: https://sourceforge.net/p/mrbs/support-requests/445/attachment/header.inc https://sourceforge.net/p/mrbs/support-requests/445/attachment/mrbs_auth.inc https://sourceforge.net/p/mrbs/support-requests/445/attachment/pending.php

[jberanek]

The message "unfortunately the database is not available at the moment" is just a general purpose message and usually means that there's been an SQL error. As the standard files work you'll have to put some debugging code in to find out which of your changes has caused the error.

Campbell

Original comment by: campbell-m

[jberanek]

HI

thanks campbell for the replay.

how can i put debugging codes, and where i need to put these codes

Original comment by: bentech4u

[jberanek]

You could put some echo statements in the code at suitable points to see what's happening. var_dump() and print_r() are also useful.

Campbell

Original comment by: campbell-m

[jberanek]

Hi CAmpbell,

thanks for the reply. Can you please tell me where can i put the statement.i didn't get you statement

suitable points to see what's happening. var_dump() and print_r()

Original comment by: bentech4u

[jberanek]

I meant that var_dump() and print_r() are useful PHP functions for looking at the contents of variables. See the PHP manual http://www.php.net/manual/en/index.php for more details.

As to where to put them then that's going to be up to you. You'll need to work through your changes to find out where the problem is.

Campbell

Original comment by: campbell-m

[jberanek]

HI campbell,

i saw one replay you posted on same question : http://sourceforge.net/p/mrbs/support-requests/467/#87df

is that will work on my case?

Original comment by: bentech4u

[jberanek]

I don't know. What do you want to achieve?

Campbell

Original comment by: campbell-m