[#CONTRIB-733] MYSQL error with MRBS

Issue Details (XML | Word | Printable)

Key:	CONTRIB-733
Type:	Bug
Status:	Closed
Resolution:	Not a bug
Priority:	Minor
Assignee:	José Coelho
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

MYSQL error with MRBS

Created: 30/Sep/08 10:10 AM Updated: 02/Oct/08 12:38 AM

Component/s:

Block: Admin_alert

Affects Version/s:

1.9.1

Fix Version/s:

None

File Attachments:	1. moodle.zip (187 kB)
Environment:	« Hide I'm using Apache2Triad distribution and Moodle 1.9.1 on a windows 2003 server. PHP 5.1.2 MYSQL 5.0.18 Show » I'm using Apache2Triad distribution and Moodle 1.9.1 on a windows 2003 server. PHP 5.1.2 MYSQL 5.0.18

URL:	http://210.18.232.140/lms/blocks/mrbs/web/edit_area_room.php
Participants:	José Coelho and paul rayner
Security Level:	None
Affected 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:

[ Permalink | « Hide ]

José Coelho added a comment - 30/Sep/08 03:36 PM

I don't understand where you use the Administration Alert block in that page, since requires login. Can you send a snapshot instead?

The MySQL error does not appear to be from the block, but the screenshot could clarify the source of the problem.

[ Permalink | « Hide ]

paul rayner added a comment - 30/Sep/08 03:59 PM

I zipped the file.
I was in Admin mode when trying to edit the info for the area.
Error 1 isn't the error - it's just the screen dump of what i was trying to do, prior to hitting the change button.

Error 2 shows the result of hitting change - with the SQl error.

If you need a password to get access, I can provide one for you.

[ Permalink | « Hide ]

José Coelho added a comment - 30/Sep/08 04:38 PM

Probably you are in the wrong place, since it appears that you are not using Moodle neither the Administration Alert block of Moodle (you should see this block here: http://moodle.org/mod/data/view.php?d=13&rid=1540).

[ Permalink | « Hide ]

paul rayner added a comment - 30/Sep/08 07:35 PM

Are you saying I need to post somewhere else?

I went to http://moodle.org/mod/data/view.php?d=13&rid=734, and the info there said to go to tracker.moodle.org for any issues!!!

I've tried the site created for mrbs, but it offers no forum.

And, this implementation is in Moodle!!

Any thoughts of where to go next????

[ Permalink | « Hide ]

José Coelho added a comment - 30/Sep/08 08:53 PM

Yes, I found the place. Here it is: http://tracker.moodle.org/browse/CONTRIB/component/10216
I don't know how to move this Issue to that block, but you can start a new Issue and link to this one in the other block.

[ Permalink | « Hide ]

paul rayner added a comment - 01/Oct/08 06:00 AM

Thanks Jose

All content on this web site is made available under the GNU General Public License, unless otherwise stated.