The adding new course problem is growing...

The adding new course problem is growing...

by Jeff Hague -
Number of replies: 1

Earlier today, I posted an issue I found after migrating to a new server wherin I cant add a new course (see the post pasted below for details). Now I find that I cant add a new quiz either. I get;


Could not add a new instance of quiz

Existing quizzes are fine and I can edit them, I just cant create new ones. Could this be a permissions problem? Maybe a database problem? Are there logs I can scour to try to track it down?

Thanks for any help - this is now becoming a problem...

Jeff

earlier post:

I am having an issue with a "moved" installation of Moodle - (Moodle 1.5.3+ (2005060230))
Old server was Windows 2000, Apache 2, MySQL 5 and PHP 5. New server is Windows 2003, IIS6, MySQL 5 and PHP 5. I set up the new server, installed PHP, created the phpasapi web service, installed MySQL, restored the database from the old server to the new one and then copied the entire Moodle directory - everything seemed to be working like a charm until I went to restore to a new course. As soon as I hit the Restore this course now button I receive this:

Course restore: backup-net263-20060515-0402.zip

  • Creating new course
    Error while creating the new empty course.

 
 

>
An error has occurred and the restore could not be completed!

 

As I was working the issue (trying other course backups, leaving out user data, leaving out modules, etc.), I found that I cannot create any new courses at all - which is, of course, what the error is telling me. If I restore a course into an existing course (deleting the existing course) it works.

I can survive this for a few weeks I think but, at some point, Ill need to create a new course or two. Does anyone have any ideas?

Thanks!

Average of ratings: -
In reply to Jeff Hague

Re: The adding new course problem is growing...

by Jeff Hague -

Fixed!

Somehow, when I installed MySQL on the new server, I missed remming out this line:

#sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

in my.ini.

Funny what a simple pound sign can do isnt it? Everything seems to be working well now...

Thanks all!

Jeff

Average of ratings: -