headers
Anthony Lawrence | 1 Jun 16:51
Picon

Undefined Index

I've inherited an MRBS system.
 
Last week, users compained that the system wasn't working.  Upon investigation, I found that someone had stolen the kvm connection from this machine and shut it down.  hat explained why it wasn't working :-)
 
I restarted it and all seemed fine until they tried to reserve equipment.  In the logs I see
 
--
PHP Notice: Undefined index: ea_needs_tv_vcr in /var/www/html/info-sys/mrbs/web/mail-amy.php on line 19
--
 
This is repeated for reserve.ph and reserve2.php and for other equipment.
 
I see the equipment defined in conf.html so I assume that having the power rudely shut off might have damaged things.   If that is the likely cause, how can we rebuild the indices?

--

Tony Lawrence
http://aplawrence.com 
------------------------------------------------------------------------------
Register Now for Creativity and Technology (CaT), June 3rd, NYC. CaT 
is a gathering of tech-side developers & brand creativity professionals. Meet
the minds behind Google Creative Lab, Visual Complexity, Processing, & 
iPhoneDevCamp as they present alongside digital heavyweights like Barbarian 
Group, R/GA, & Big Spaceship. http://p.sf.net/sfu/creativitycat-com 
_______________________________________________
mrbs-general mailing list
mrbs-general <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mrbs-general
Permalink | Reply | 1 comment |
headers
John Beranek - MRBS Developer | 1 Jun 17:14
Picon

Re: Undefined Index

Anthony Lawrence wrote:
> I've inherited an MRBS system.
> 
> Last week, users compained that the system wasn't working.  Upon
> investigation, I found that someone had stolen the kvm connection from this
> machine and shut it down.  hat explained why it wasn't working :-)
> 
> I restarted it and all seemed fine until they tried to reserve equipment.
> In the logs I see
> 
> --
> PHP Notice: Undefined index: ea_needs_tv_vcr in
> /var/www/html/info-sys/mrbs/web/mail-amy.php on line 19
> --
> 
> This is repeated for reserve.ph and reserve2.php and for other equipment.

None of the files you mention are provided by a standard MRBS 
installation. So, some custom MRBS modifications are going wrong - I 
can't really do anything to help there...

John.

--

-- 
John Beranek - MRBS Developer <http://mrbs.sourceforge.net/>

To generalise is to be an idiot.
   -- William Blake

------------------------------------------------------------------------------
Register Now for Creativity and Technology (CaT), June 3rd, NYC. CaT 
is a gathering of tech-side developers & brand creativity professionals. Meet
the minds behind Google Creative Lab, Visual Complexity, Processing, & 
iPhoneDevCamp as they present alongside digital heavyweights like Barbarian 
Group, R/GA, & Big Spaceship. http://p.sf.net/sfu/creativitycat-com
Permalink | Reply | 0 comments |
headers
Tony Lawrence | 1 Jun 19:44

Re: Undefined Index

Thanks.   Somebody added a lot of custom tables; I've just started looking through them today and ran out of time.  Will pick up on it tomorrow I hope.

On Mon, Jun 1, 2009 at 11:53 AM, Mark Belanger <mark_belanger <at> ltx.com> wrote:
Anthony Lawrence wrote:
I've inherited an MRBS system.
 Last week, users compained that the system wasn't working.  Upon investigation, I found that someone had stolen the kvm connection from this machine and shut it down.  hat explained why it wasn't working :-)
 I restarted it and all seemed fine until they tried to reserve equipment.  In the logs I see
 --
PHP Notice: Undefined index: ea_needs_tv_vcr in /var/www/html/info-sys/mrbs/web/mail-amy.php on line 19
--
 This is repeated for reserve.ph <http://reserve.ph> and reserve2.php and for other equipment.

 I see the equipment defined in conf.html so I assume that having the power rudely shut off might have damaged things.   If that is the likely cause, how can we rebuild the indices?

First off, see what the DB backend is - usually it's mysql.  Presuming it
is, you should connect to the db using the info in config.inc - something like
mysql -u dbuser -p -host dbhost dbname
>From there you can query the structure of the tables:
mysql> desc tablename;
mysql> show index from tablename;

>From here you should be able to google to find the drop index and
create index syntax.  There is also a repair table command that you may
or may not need depending on the state of the DB.

Of course I would backup the database completely before you do anything.  This
can be done by shutting down mysql and tarring it up, or using mysqldump - which
will create all the sql needed to recreate and populate the tables.

Give me a call if you need a hand - 774-766-8141

-Mark



--

Tony Lawrence
781 249-8010
My Unix/Linux Troubleshooting Book
http://aplawrence.com/troubleshootingbook.html
------------------------------------------------------------------------------
Register Now for Creativity and Technology (CaT), June 3rd, NYC. CaT 
is a gathering of tech-side developers & brand creativity professionals. Meet
the minds behind Google Creative Lab, Visual Complexity, Processing, & 
iPhoneDevCamp as they present alongside digital heavyweights like Barbarian 
Group, R/GA, & Big Spaceship. http://p.sf.net/sfu/creativitycat-com 
_______________________________________________
mrbs-general mailing list
mrbs-general <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mrbs-general
Permalink | Reply | 0 comments |
headers
Leon Huang | 2 Jun 05:17
Picon
Picon
Favicon

Re: Restrict Login via button only

I had the same request - Campbell has modified 2 files. You can try and
replace the files I've attached.

Regards,

Leon Huang,

-----Original Message-----
From: school.it <at> st-bedes.surrey.sch.uk
[mailto:school.it <at> st-bedes.surrey.sch.uk] 
Sent: Saturday, 30 May 2009 10:45 PM
To: mrbs-general <at> lists.sourceforge.net
Subject: [MRBS-general] Restrict Login via button only

MRBS installed and working OK.

At present a login screen is presented when a visitor clicks on a 
blank/vacant slot, or clicks on admin link (at top) (and on Login button

at top right)

We would like to restrict it so nothing happens when clicking on vacant 
slot (or admin link) until user has logged in using button at top right.

Have looked through messages without luck.

Suggestions on best way to do this would be welcome.

TIA
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* * *
This email has been sent from Saint Bede's School, Carlton Road,
Redhill, Surrey, UK, RH1 2LQ. (tel: +44(0)1737-212108)

If forwarding this message, you should remove the sender's e-mail
address(es) unlesss their permission has been sought and granted.

If you have received this email in error, or the contents are considered
inappropriate, please notify the sender or
postmaster <at> st-bedes.surrey.sch.uk

Saint Bede's School reserves the right to monitor all incoming and
outgoing mail.

------------------------------------------------------------------------
------
Register Now for Creativity and Technology (CaT), June 3rd, NYC. CaT 
is a gathering of tech-side developers & brand creativity professionals.
Meet
the minds behind Google Creative Lab, Visual Complexity, Processing, & 
iPhoneDevCamp as they present alongside digital heavyweights like
Barbarian 
Group, R/GA, & Big Spaceship. http://p.sf.net/sfu/creativitycat-com 
_______________________________________________
mrbs-general mailing list
mrbs-general <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mrbs-general
Attachment (functions.inc): application/octet-stream, 35 KiB
Attachment (month.php): application/octet-stream, 19 KiB
------------------------------------------------------------------------------
OpenSolaris 2009.06 is a cutting edge operating system for enterprises 
looking to deploy the next generation of Solaris that includes the latest 
innovations from Sun and the OpenSource community. Download a copy and 
enjoy capabilities such as Networking, Storage and Virtualization. 
Go to: http://p.sf.net/sfu/opensolaris-get
_______________________________________________
mrbs-general mailing list
mrbs-general <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mrbs-general
Permalink | Reply | 0 comments |
headers
Zak Burke | 2 Jun 21:15
Picon
Gravatar

code organization

I started working with MRBS last summer, doing some customizations for
a client who required support for Oracle, bind variables and a
template system. I offered the Oracle and bind-variables code but was
told there was no interest, and that it would be cumbersome to
maintain, in part because there was no DB abstraction layer. In the
last year, I've also done a lot of work with the CodeIgniter
framework, which is beautifully organized to separate DB stuff from
business logic from display code from config code ... you get the
idea. MRBS is a powerful application, but separation of concerns in
the codebase is not its strong suit.

>From the end-user point of view, MRBS is a great application, but as a
developer, I find it rather difficult to work with. Given this, I have
two questions:

# 1: There's now a nice DB abstraction layer in 1.4.x; is there now
any interest in adding support for bind variables, Oracle (via the
oci9 functions) or PDO DB handlers?

# 2: Is there any interest in refactoring the codebase to help get the
SQL, config logic and display logic separated? Just replacing the
100-plus print/echo statements with "$output .= '...'" and a single
"print $output" would vastly simplify templating.

Cheers,

Zak

------------------------------------------------------------------------------
OpenSolaris 2009.06 is a cutting edge operating system for enterprises 
looking to deploy the next generation of Solaris that includes the latest 
innovations from Sun and the OpenSource community. Download a copy and 
enjoy capabilities such as Networking, Storage and Virtualization. 
Go to: http://p.sf.net/sfu/opensolaris-get
Permalink | Reply | 0 comments |
headers
RC | 11 Jun 23:58
Picon
Favicon

MRBS title

Hi,

How can I change the title underneath the $mrbs_company, which I've set to Sonoma Club.
On the day/week/month.php page I see Sonoma Club as my company name, but underneath, I see:
"Meeting Room Booking System" with a link to "index.php."

Instead of "Meeting Room Booking System" I'd like for that to say:
"Squash Court Booking System."

Thank you,
RC

------------------------------------------------------------------------------
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensing option that enables unlimited
royalty-free distribution of the report engine for externally facing 
server and web deployment.
http://p.sf.net/sfu/businessobjects
_______________________________________________
mrbs-general mailing list
mrbs-general <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mrbs-general
Permalink | Reply | 1 comment |
headers
Campbell Morrison | 12 Jun 00:11
Picon

Re: MRBS title

It's in lang.en
 
Campbell
 
----- Original Message -----
From: RC
Sent: Thursday, June 11, 2009 10:58 PM
Subject: [MRBS-general] MRBS title

Hi,

How can I change the title underneath the $mrbs_company, which I've set to Sonoma Club.
On the day/week/month.php page I see Sonoma Club as my company name, but underneath, I see:
"Meeting Room Booking System" with a link to "index.php."

Instead of "Meeting Room Booking System" I'd like for that to say:
"Squash Court Booking System."

Thank you,
RC

------------------------------------------------------------------------------
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensing option that enables unlimited
royalty-free distribution of the report engine for externally facing
server and web deployment.
http://p.sf.net/sfu/businessobjects

_______________________________________________
mrbs-general mailing list
mrbs-general <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mrbs-general
------------------------------------------------------------------------------
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensing option that enables unlimited
royalty-free distribution of the report engine for externally facing 
server and web deployment.
http://p.sf.net/sfu/businessobjects
_______________________________________________
mrbs-general mailing list
mrbs-general <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mrbs-general
Permalink | Reply | 0 comments |
headers
RC | 12 Jun 21:28
Picon
Favicon

Re: MRBS title

Campbell,

Thank you so much! Much better now.

I didn't get an email with your reply. Thankfully, I found your reply on the archives page.

I will ask another question in a new email.

Cheers,
RC

--- On Thu, 6/11/09, RC <menoclu <at> yahoo.com> wrote:

From: RC <menoclu <at> yahoo.com>
Subject: MRBS title
To: mrbs-general <at> lists.sourceforge.net
Date: Thursday, June 11, 2009, 4:58 PM

Hi,

How can I change the title underneath the $mrbs_company, which I've set to Sonoma Club.
On the day/week/month.php page I see Sonoma Club as my company name, but underneath, I see:
"Meeting Room Booking System" with a link to "index.php."

Instead of "Meeting Room Booking System" I'd like for that to say:
"Squash Court Booking System."

Thank you,
RC


------------------------------------------------------------------------------
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensing option that enables unlimited
royalty-free distribution of the report engine for externally facing 
server and web deployment.
http://p.sf.net/sfu/businessobjects
_______________________________________________
mrbs-general mailing list
mrbs-general <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mrbs-general
Permalink | Reply | 0 comments |
headers
Jim Scott | 14 Jun 18:17
Picon
Favicon

Report Help

Hi All

 

MRBS 1.4.1+svn

Database:

MySQL 5.0.67-community

System:

Linux srv22.000webhost.com 2.6.18-92.1.22.el5 #1 SMP Tue Dec 16 12:03:43 EST 2008 i686

Server time:

Sun 14 Jun 2009 16:50:25 BST

PHP:

5.2.8

 

We use MRBS to book facilities at a sports complex, we have 4 area’s and several rooms. I would like to produce a report that has Date, Area, Room, Time booked from and to, and Client. Please can someone point me in the right direction and also how to prepare it for printing so that I don’t have to highlight to print.  If you want to look at the system it is www.Cumbriasa.co.uk/web   I have looked in the archives but only found one reference to reports.

 

Thanks Jim.    

 

 

 

 

------------------------------------------------------------------------------
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensing option that enables unlimited
royalty-free distribution of the report engine for externally facing 
server and web deployment.
http://p.sf.net/sfu/businessobjects
_______________________________________________
mrbs-general mailing list
mrbs-general <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mrbs-general
Permalink | Reply | 501 comments |
headers
Campbell Morrison | 15 Jun 00:14
Picon

Re: Report Help

I'm not quite sure what you're looking for.    Do you mean a produce a table that has columns for Date, Area, Room, etc. a bit like the output of Search?   And I'm not sure what you mean by having to highlight to print.
 
Campbell
 
 
 
----- Original Message -----
From: Jim Scott
Sent: Sunday, June 14, 2009 5:17 PM
Subject: [MRBS-general] Report Help

Hi All

 

MRBS 1.4.1+svn

Database:

MySQL 5.0.67-community

System:

Linux srv22.000webhost.com 2.6.18-92.1.22.el5 #1 SMP Tue Dec 16 12:03:43 EST 2008 i686

Server time:

Sun 14 Jun 2009 16:50:25 BST

PHP:

5.2.8

 

We use MRBS to book facilities at a sports complex, we have 4 area’s and several rooms. I would like to produce a report that has Date, Area, Room, Time booked from and to, and Client. Please can someone point me in the right direction and also how to prepare it for printing so that I don’t have to highlight to print.  If you want to look at the system it is www.Cumbriasa.co.uk/web   I have looked in the archives but only found one reference to reports.

 

Thanks Jim.    

 

 

 

 

------------------------------------------------------------------------------
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensing option that enables unlimited
royalty-free distribution of the report engine for externally facing
server and web deployment.
http://p.sf.net/sfu/businessobjects

_______________________________________________
mrbs-general mailing list
mrbs-general <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mrbs-general
------------------------------------------------------------------------------
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensing option that enables unlimited
royalty-free distribution of the report engine for externally facing 
server and web deployment.
http://p.sf.net/sfu/businessobjects
_______________________________________________
mrbs-general mailing list
mrbs-general <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mrbs-general
Permalink | Reply | 502 comments |

Gmane