MantisBT - ATutor
View Issue Details
0002358ATutorInstallationpublic2006-04-06 06:052006-05-02 06:17
greg 
user2 
normalminoralways
closedfixed 
 
1.5.3 
0002358: create tables fails on new install
I get the following errors when installing at step 2

 Error

    * Table AT_assignments creation failed.
    * Table AT_reading_list creation failed.
    * Table AT_external_resources creation failed.
No tags attached.
Issue History
2006-04-06 06:05gregNew Issue
2006-04-06 06:09gregNote Added: 0001757
2006-04-06 06:20user2Note Added: 0001758
2006-04-06 06:23gregNote Added: 0001759
2006-04-06 06:28gregNote Added: 0001760
2006-04-06 06:29gregNote Added: 0001761
2006-04-13 08:50user2Statusnew => resolved
2006-04-13 08:50user2Fixed in Version => 1.5.3
2006-04-13 08:50user2Resolutionopen => fixed
2006-04-13 08:50user2Assigned To => user2
2006-04-13 08:50user2Note Added: 0001765
2006-05-02 06:17user2Statusresolved => closed

Notes
(0001757)
greg   
2006-04-06 06:09   
MySQL said: Documentation
0001067 - Invalid default value for 'reading_id'
(0001758)
user2   
2006-04-06 06:20   
which version of mysql?
(0001759)
greg   
2006-04-06 06:23   
DEFAULT 0 also needs to be removed from the upgrade script.

I also see that the bitwise values for the readlist module (and assignments and file_storage) inserted into the modules table is hard coded. What happens if other modules are installed using those numbers?
(0001760)
greg   
2006-04-06 06:28   
I'm using 4.1.14
(0001761)
greg   
2006-04-06 06:29   
It works ok if I remove "Default 0" from the reading_id field and the other id field in the other tables
(0001765)
user2   
2006-04-13 08:50   
auto inc should not specify a default value