Installing and upgrading help

I carefully backed up and followed the upgrade instruction and received only the following errors during the database upgrade:


(mysql): ALTER TABLE `mdl_user` ADD INDEX user_auth (auth)  
1072: Key column 'auth' doesn't exist in table

    adodb_mysql._execute( ALTER TABLE `mdl_user` ADD INDEX user_auth (auth) , false) % line 804, file: adodb.inc.php
  adodb_mysql.execute( ALTER TABLE `mdl_user` ADD INDEX user_auth (auth) ) % line 30, file: datalib.php
execute_sql( ALTER TABLE `mdl_user` ADD INDEX user_auth (auth) ) % line 848, file: mysql.php
main_upgrade(2004083125) % line 161, file: index.php


Error
(mysql): ALTER TABLE `mdl_course` ADD INDEX idnumber (idnumber)  
1072: Key column 'idnumber' doesn't exist in table

    adodb_mysql._execute( ALTER TABLE `mdl_course` ADD INDEX idnumber (idnumber) , false) % line 804, file: adodb.inc.php
  adodb_mysql.execute( ALTER TABLE `mdl_course` ADD INDEX idnumber (idnumber) ) % line 30, file: datalib.php
execute_sql( ALTER TABLE `mdl_course` ADD INDEX idnumber (idnumber) ) % line 852, file: mysql.php
main_upgrade(2004083125) % line 161, file: index.php


Error


Everything else seems to be fine except that when clicking on any Resources, they do not load. Running tail on the Apache logs gives me these (or very similar) errors:


[Mon Feb 14 20:20:23 2005] [error] PHP Warning: main(/Library/WebServer/rmhs/moodle/mod/resource/type/4/resource.class.php): failed to open stream: No such file or directory in /Library/WebServer/rmhs/moodle/mod/resource/view.php on line 20

[Mon Feb 14 20:20:27 2005] [error] PHP Warning: main(/Library/WebServer/rmhs/moodle/mod/resource/type/6/resource.class.php): failed to open stream: No such file or directory in /Library/WebServer/rmhs/moodle/mod/resource/view.php on line 20

[Mon Feb 14 20:20:33 2005] [error] PHP Warning: main(/Library/WebServer/rmhs/moodle/mod/resource/type/3/resource.class.php): failed to open stream: No such file or directory in /Library/WebServer/rmhs/moodle/mod/resource/view.php on line 20


Any idea what the problem here is? Is the database hosed? Seems that the problem here is related to the resources table.


Thanks for your help!