Non-core contributed modules

MYSQL error with MRBS

Details

  • Type: Bug Bug
  • Status: Closed Closed
  • Priority: Minor Minor
  • Resolution: Not a bug
  • Affects Version/s: 1.9.1
  • Fix Version/s: None
  • Component/s: Block: Admin_alert
  • Labels:
    None
  • Environment:
    I'm using Apache2Triad distribution and Moodle 1.9.1 on a windows 2003 server.
    PHP 5.1.2
    MYSQL 5.0.18

Description

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.

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
José Coelho added a comment -

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.

Show
José Coelho added a comment - 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.
Hide
Permalink
paul rayner added a comment -

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.

Show
paul rayner added a comment - 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.
Hide
Permalink
José Coelho added a comment -

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).

Show
José Coelho added a comment - 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).
Hide
Permalink
paul rayner added a comment -

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????

Show
paul rayner added a comment - 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????
Hide
Permalink
José Coelho added a comment -

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.

Show
José Coelho added a comment - 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.
Hide
Permalink
paul rayner added a comment -

Thanks Jose

Show
paul rayner added a comment - Thanks Jose

People

Vote (0)
Watch (0)

Dates

  • Created:
    Updated:
    Resolved:
Atlassian JIRA (v4.4.3#663-r165197) | Report a problem
Powered by a free Atlassian JIRA open source license for Moodle. Try JIRA - bug tracking software for your team.