I have been asked by one of our deputy heads at our school if I can develop a message of the dday block for Moodle. I thought that it shouldnot prove too tricky as it could just be a block that accesses a database table of quotations and randomly chooses one to dispaly each day. When in the blocks configuarion page the option to add / remove quotes could then be made available.
I have gone through the Moodle documentation for making a block, and all was well. However when I try to get my block to create a new table within the Moodle database I get an error about being unable to create table in MySQL. I have checked that my MySQL is correct by running the SQL commands straight into MySQL command line and they work. I am really stumped as to why this willnot work. Any pointers to how best to develop a block of this type would be much appreciated.
I am away from my desk at present so can not attach my working so far, but will add it to this message when I get back to my desk.
Jon