Issue Details (XML | Word | Printable)

Key: CONTRIB-736
Type: Bug Bug
Status: Resolved Resolved
Resolution: Fixed
Priority: Minor Minor
Assignee: Anthony Borrow
Reporter: paul rayner
Votes: 0
Watchers: 0
Operations

Add/Edit UI Mockup to this issue
If you were logged in you would be able to see more operations.
Non-core contributed modules

MUSQL error with MRBS

Created: 01/Oct/08 05:58 AM   Updated: 03/Oct/08 10:56 AM
Return to search
Component/s: Block: Mrbs
Affects Version/s: 1.9.1
Fix Version/s: 1.9

Environment:
I'm using Apache2Triad distribution and Moodle 1.9.1 on a windows 2003 server.
PHP 5.1.2
MYSQL 5.0.18

Database: MySQL
URL: http://210.18.232.140/lms/blocks/mrbs/web/edit_area_room.php
Participants: Anthony Borrow and paul rayner
Security Level: None
Resolved date: 01/Oct/08
Affected Branches: MOODLE_19_STABLE
Fixed Branches: MOODLE_19_STABLE


 Description  « Hide
In trying to edit rooms in MRBS, I get the following error-
Update room failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'computers, room_admin_email='' WHERE id=5' at line 1.

I wanted to add info to the room - examples

Description - Whiteboard/TV
Capacity - 30 Computers
As soon as i hit change, the MYSQL error comes up.


 All   Comments   Change History   Version Control      Sort Order: Ascending order - Click to sort in descending order
arborrow committed 1 file to 'Contrib CVS' - 01/Oct/08 07:31 AM
CONTRIB-736 - adding missing capacity param check, capacity is in an integer
MODIFY plugins/blocks/mrbs/web/edit_area_room.php   Rev. 1.7    (+2 -1 lines)