Re: [MRBS-general] Edit Area Error

[Campbell M. <cam...@gm...>]

I don't recognize the field 'max_per_user_enabled'.    Also the error would
not come from line 447 in standard MRBS.    It sounds like you may have made
some modifications to MRBS to limit the number of bookings each user can
make on a per-area basis?   If so, I think the solution is to add those
fields back into the area table.   You'll know the details of your fields,
but I suspect something like

ALTER TABLE mrbs_area 
ADD COLUMN max_per_user_enabled tinyint(1) DEFAULT 0 NOT NULL,
ADD COLUMN max_per_user_secs int DEFAULT 0 NOT NULL;

would do the trick (replacing "mrbs_" by your $tbl_prefix).

The other solution would be to revert to standard MRBS.

Campbell





> -----Original Message-----
> From: Juan Gallaga [mailto:ga...@us...]
> Sent: 26 September 2011 16:35
> To: ma...@ca...; General purpose list
> (support/developers/users)
> Cc: 'General purpose list (support/developers/users)'
> Subject: Re: [MRBS-general] Edit Area Error
> 
> Error log says:
> 
> PHP Warning:  Unknown column 'max_per_user_enabled' in 'field list' in
> /srv/www/htdocs/grouprooms/nml/edit_area_room.ph
> p on line 447, referer: https://nml-
> 23.usc.edu/grouprooms/nml/edit_area_room.php?change_area=1&phase=1&area
> =2&day=21&month=9&year=2011
> [Fri Sep 23 14:57:36 2011] [error] [client 128.125.28.165] MRBS: Fatal
> error: unfortunately the database is not available at the moment.,
> referer: https://nml-23.usc.edu/grouproo
> ms/nml/edit_area_room.php?change_area=1&phase=1&area=2&day=21&month=9&y
> ear=2011
> 
> I have two instances of the MRBS and when comparing tables for 'area',
> I notice that the one that is giving me an error is missing two field
> entries, 'max_per_user_enabled'  as the log says, AND
> 'max_per_user_secs'.
> 
> 
> Is there anyway to get these fields back into the table?
> 
> 
> --Juan
> 
> 
> ----- Original Message -----
> From: Campbell Morrison <cam...@gm...>
> Date: Friday, September 23, 2011 10:44 pm
> Subject: Re: [MRBS-general] Edit Area Error
> To: "'General purpose list (support/developers/users)'" <mrbs-
> ge...@li...>
> 
> > What does your error log say?   The SQL error message should have
> been
> > written to the error log and that will give some clues.
> >
> > Campbell
> >
> >
> >
> > > -----Original Message-----
> > > From: Juan Gallaga [mailto:ga...@us...]
> > > Sent: 23 September 2011 22:42
> > > To: mrb...@li...
> > > Subject: [MRBS-general] Edit Area Error
> > >
> > > When I try to change anything in the Edit Area section, I get:
> > >
> > > Update area failed:
> > >
> > > Fatal error: unfortunately the database is not available at the
> > moment.>
> > > View Day:
> > > | | | | | | [ ] | | | | | | |
> > > View Week:
> > > | | | | [ ] | | | |
> > > View Month:
> > > | | [ ] | | | | | |
> > >
> > >
> > > but every other section is working. I can create a room. edit the
> > room.> post to the calendar.
> > > Only error comes from edit area.
> > > Any ideas?
> > >
> > > --Juan.
> > >
> > >
> > >
> > > ------------------------------------------------------------------
> > -----
> > > -------
> > > All of the data generated in your IT infrastructure is seriously
> > > valuable.
> > > Why? It contains a definitive record of application performance,
> > > security
> > > threats, fraudulent activity, and more. Splunk takes this data and
> > > makes
> > > sense of it. IT sense. And common sense.
> > > http://p.sf.net/sfu/splunk-d2dcopy2
> > > _______________________________________________
> > > mrbs-general mailing list
> > > mrb...@li...
> > > https://lists.sourceforge.net/lists/listinfo/mrbs-general
> > > Want to unsubscribe: mailto:mrbs-general-
> > > re...@li...?subject=unsubscribe
> >
> >
> > --------------------------------------------------------------------
> > ----------
> > All of the data generated in your IT infrastructure is seriously
> > valuable.Why? It contains a definitive record of application
> > performance, security
> > threats, fraudulent activity, and more. Splunk takes this data and
> > makessense of it. IT sense. And common sense.
> > http://p.sf.net/sfu/splunk-d2dcopy2
> > _______________________________________________
> > mrbs-general mailing list
> > mrb...@li...
> > https://lists.sourceforge.net/lists/listinfo/mrbs-general
> > Want to unsubscribe: mailto:mrbs-general-
> > re...@li...?subject=unsubscribe