Installation Error during assigment configuration

Installation Error during assigment configuration

by Hugh O'Brien -
Number of replies: 1

OS Version: Windows 2000 Professional
Apache Version: 2.0.54
PHP Version: 5.0.4
MySQL Version: 4.1.7
Moodle Version: 1.4.5


While configuring moodle during a new isntallation, I get the following problem:


assignment

(mysql): CREATE TABLE `mdl_assignment` ( `id` int(10) unsigned NOT NULL auto_increment, `course` int(10) unsigned NOT NULL default '0', `name` varchar(255) NOT NULL default '', `description` text NOT NULL, `format` tinyint(2) unsigned NOT NULL default '0', `resubmit` tinyint(2) unsigned NOT NULL default '0', `type` int(10) unsigned NOT NULL default '1', `maxbytes` int(10) unsigned NOT NULL default '100000', `timedue` int(10) unsigned NOT NULL default '0', `grade` int(10) NOT NULL default '0', `timemodified` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`), KEY `course` (`course`)) COMMENT='Defines assignments'  
1005: Can't create table '.\moodle\mdl_assignment.frm' (errno: 121)
         
      
  

Error

(mysql): CREATE TABLE `mdl_assignment_submissions` ( `id` int(10) unsigned NOT NULL auto_increment, `assignment` int(10) unsigned NOT NULL default '0', `userid` int(10) unsigned NOT NULL default '0', `timecreated` int(10) unsigned NOT NULL default '0', `timemodified` int(10) unsigned NOT NULL default '0', `numfiles` int(10) unsigned NOT NULL default '0', `grade` int(11) NOT NULL default '0', `comment` text NOT NULL, `teacher` int(10) unsigned NOT NULL default '0', `timemarked` int(10) unsigned NOT NULL default '0', `mailed` tinyint(1) unsigned NOT NULL default '0', PRIMARY KEY (`id`), KEY `assignment` (`assignment`), KEY `userid` (`userid`), KEY `mailed` (`mailed`), KEY `timemarked` (`timemarked`)) COMMENT='Info about submitted assignments'  
1005: Can't create table '.\moodle\mdl_assignment_submissions.frm' (errno: 121)
         
      
  

Error


                        

    
    
    
                            
    
    
                                

                                        
Average of ratings:  - 

                                        
                                

    
                            
                    

                

            

        

    
        

                

                    

                        
                
                        

                            

                                        

                                                
                                        

                                

                                        In reply to Hugh O'Brien
                                        
Re: Installation Error during assigment configuration

                                        

                                            by Hugh O'Brien - 
                        

                                

                
                                        

                                        

                            

                
                            

                
                                

                                    

                                        After starring at the sql that was erroring out, I realized that the key referring back to the 'course' table should have read 'mdl_course' since I took the install defaults and let the installation program use a table prefix.  I blew away the original install and started again and chose no table prefix.  Lo and behold, I got past the point where I had problems originally.

So it appears there is a bug in the installation using table prefixes.


                                    

                
                
                
                                        
                
                
                                            

                                                    
Average of ratings:  -