[ww-bugs] Bug 2645: New: database issues with a newly created admin course

[bugzilla-daemon at webwork.maa.org]

http://bugs.webwork.maa.org/show_bug.cgi?id=2645

           Summary: database issues with a newly created admin course
           Product: WeBWorK 2
           Version: unspecified
          Platform: PC
        OS/Version: Windows
            Status: NEW
          Severity: enhancement
          Priority: P5
         Component: General
        AssignedTo: gage at math.rochester.edu
        ReportedBy: apizer at math.rochester.edu
        Web browser ---
           version:


There are database issues with a newly created admin course.

On an absolutely new installation, I created the admin course with the command:
/opt/webwork/webwork2/bin/addcourse admin --db-layout=sql_single
--users=adminClasslist.lst --professors=admin

Logging into the admin course the FIRST TIME (note this message disappears on
the second and subsequent logins) I see on the opening page at the top

Warning -- there may be something wrong with this question. Please inform your
instructor including the warning messages below.

and below

Archived Courses
WeBWorK Warnings
WeBWorK has encountered warnings while processing your request. If this occured
when viewing a problem, it was likely caused by an error or ambiguity in that
problem. Otherwise, it may indicate a problem with the WeBWorK system itself.
If you are a student, report these warnings to your professor to have them
corrected. If you are a professor, please consult the warning output below for
more information.

Warning messages
version_id from admin_problem_user is only in schema, not in database, so
adding it ... at /opt/webwork/webwork2/lib/WeBWorK/Utils/CourseManagement.pm
line 1031.
added column version_id to table admin_problem_user at
/opt/webwork/webwork2/lib/WeBWorK/Utils/CourseManagement.pm line 1034.
version_id from admin_set_user is only in schema, not in database, so adding it
... at /opt/webwork/webwork2/lib/WeBWorK/Utils/CourseManagement.pm line 1031.
added column version_id to table admin_set_user at
/opt/webwork/webwork2/lib/WeBWorK/Utils/CourseManagement.pm line 1034.
Request information
Time    Tue Jun 25 13:19:28 2013
Method    POST
URI    /webwork2/admin/

NOTE:  Logging into the admin course a SECOND TIME, these warning do not appear
on the opening page.

Then clicking on upgrade courses, you see for the admin course:
Database tables need updating
and after clicking on upgrade the results are 

Database:

achievement Table is ok
achievement_user Table is ok
global_user_achievement Table is ok
key Table is ok
password Table is ok
past_answer Table is ok
permission Table is ok
problem Table is ok
problem_user Schema and database table definitions do not agree
Field problem_seed => is ok
Field flags => is ok
Field sub_status => is ok
Field max_attempts => is ok
Field status => is ok
Field value => is ok
Field last_answer => is ok
Field source_file => is ok
Field set_id => is ok
Field version_id => missing in schema
Field problem_id => is ok
Field num_incorrect => is ok
Field num_correct => is ok
Field attempted => is ok
Field user_id => is ok
set Table is ok
set_locations Table is ok
set_locations_user Table is ok
set_user Schema and database table definitions do not agree
Field enable_reduced_scoring => is ok
Field version_time_limit => is ok
Field restrict_ip => is ok
Field set_header => is ok
Field psvn => is ok
Field hardcopy_header => is ok
Field version_creation_time => is ok
Field open_date => is ok
Field hide_work => is ok
Field hide_score => is ok
Field relax_restrict_ip => is ok
Field problem_randorder => is ok
Field versions_per_interval => is ok
Field version_last_attempt_time => is ok
Field visible => is ok
Field time_interval => is ok
Field set_id => is ok
Field version_id => missing in schema
Field problems_per_page => is ok
Field assignment_type => is ok
Field due_date => is ok
Field answer_date => is ok
Field time_limit_cap => is ok
Field user_id => is ok
Field attempts_per_version => is ok
Field hide_score_by_problem => is ok
Field restricted_login_proctor => is ok
setting Table is ok
user Table is ok
Database tables are ok

There are extra database fields which are not defined in the schema for at
least one table. They can only be removed manually from the database.

Directory structure

DATA => /opt/webwork/courses/admin/DATA rwx 
achievements => /opt/webwork/courses/admin/templates/achievements rwx 
achievements_html => /opt/webwork/courses/admin/html/achievements rwx 
email => /opt/webwork/courses/admin/templates/email rwx 
html => /opt/webwork/courses/admin/html rwx 
html_images => /opt/webwork/courses/admin/html/images rwx 
html_temp => /opt/webwork/webwork2/htdocs/tmp/admin rwx 
logs => /opt/webwork/courses/admin/logs rwx 
macros => /opt/webwork/courses/admin/templates/macros rwx 
mailmerge => /opt/webwork/courses/admin/DATA/mailmerge rwx 
root => /opt/webwork/courses/admin rwx 
scoring => /opt/webwork/courses/admin/scoring rwx 
templates => /opt/webwork/courses/admin/templates rwx 
tmpEditFileDir => /opt/webwork/courses/admin/templates/tmpEdit rwx 
Directory structure is ok

Lars Jensen reports
(http://webwork.maa.org/moodle/mod/forum/discuss.php?d=2980) the same errors
when trying to upgrade the admin course from a earlier version of WeBWorK to
WW2.7

-- 
Configure bugmail: http://bugs.webwork.maa.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are watching all bug changes.