We are using Moodle 1.5 with IIS6 and PHP5/mySQL5. Everything is set up well and authenticating through LDAP.
The problem occurs when trying to "Display Directory" from within a course. I have all my course material uploaded and working ok by using the "Add Resource" action, but wish to show directory content for a folder containing Tutor Resources which will be hidden from students.
When I click Display Directory in the drop menu for the topic of a course, I am taken to the Add Resource page, I add a name, the display directory drop menu contains all of the files I have uploaded and the Directory I wish to display which I add.
When I click Save Changes and am taken to http://mySite.ac.uk/moodle/course/mod.php there is an error of:
"Could not add a new instance of resource"
I have tried to add a new course and varied the order in which I have added resources to the course topic but with the same outcome. The only similar problem I have come across while browsing the forums relates to an issue after an upgrade. We have not done an upgrade, as this was a new installation we started right off with 1.5.
Has anybody experienced a similar problem or know of a "fix"?
I am running Moodle 1.5.3+ on IIS6 on a freshly installed Win2k3 server. PHP 5.1, MySQL 5.x, all the usual stuff.
Any assistance would be greatly appreciated!
Yukon Flats School District
Sorry for the delay in replying. After some research and then finding help by way of a moodle support partner here in the UK, it was traced to the install of MySQL5. There is an issue with reserved words. After going down to MySQL 4.1.18 and getting the latest moodle release everything is now OK. I have been working on it extensively and have not found any other problems.
Hope that helps.