########################################################################## Attempt on currently archived course YY_Math_200 ########################################################################## ______________________ At Importing _______________________________________________________ WeBWorK error An error occured while processing your request. For help, please send mail to this site's webmaster (webmaster@localhost), including all of the following information as well as what what you were doing when the error occured. Tue Jul 14 16:13:45 2015 Warning messages Failed to restore table 'YY_Math_200_global_user_achievement' with command '2>&1 /usr/bin/mysql --defaults-file=/tmp/QxDEWFxyex webworkdb < /opt/webwork/courses/YY_Math_200/DATA/mysqldump/global_user_achievement.sql' (exit=2 signal=0 core=0): sh: 1: cannot open /opt/webwork/courses/YY_Math_200/DATA/mysqldump/global_user_achievement.sql: No such file

Failed to restore table 'YY_Math_200_achievement' with command '2>&1 /usr/bin/mysql --defaults-file=/tmp/jQk7IuOVbh webworkdb < /opt/webwork/courses/YY_Math_200/DATA/mysqldump/achievement.sql' (exit=2 signal=0 core=0): sh: 1: cannot open /opt/webwork/courses/YY_Math_200/DATA/mysqldump/achievement.sql: No such file

Failed to restore table 'YY_Math_200_past_answer' with command '2>&1 /usr/bin/mysql --defaults-file=/tmp/5AH2LhdM1O webworkdb < /opt/webwork/courses/YY_Math_200/DATA/mysqldump/past_answer.sql' (exit=2 signal=0 core=0): sh: 1: cannot open /opt/webwork/courses/YY_Math_200/DATA/mysqldump/past_answer.sql: No such file

Failed to restore table 'YY_Math_200_achievement_user' with command '2>&1 /usr/bin/mysql --defaults-file=/tmp/0CGVxoS6gg webworkdb < /opt/webwork/courses/YY_Math_200/DATA/mysqldump/achievement_user.sql' (exit=2 signal=0 core=0): sh: 1: cannot open /opt/webwork/courses/YY_Math_200/DATA/mysqldump/achievement_user.sql: No such file

Error messages DBD::mysql::db do failed: Can't find file: './webworkdb/YY_Math_200_global_user_achievement.frm' (errno: 2) at /opt/webwork/webwork2/lib/WeBWorK/DB/Schema/NewSQL/Std.pm line 826. Call stack The information below can help locate the source of the problem. in WeBWorK::DB::Schema::NewSQL::Std::handle_error called at line 176 of /opt/webwork/webwork2/lib/WeBWorK/DB/Schema/NewSQL/Std.pm in WeBWorK::DB::Schema::NewSQL::Std::rename_table called at line 399 of /opt/webwork/webwork2/lib/WeBWorK/DB.pm in WeBWorK::DB::rename_tables called at line 489 of /opt/webwork/webwork2/lib/WeBWorK/Utils/CourseManagement.pm in WeBWorK::Utils::CourseManagement::renameCourse called at line 835 of /opt/webwork/webwork2/lib/WeBWorK/Utils/CourseManagement.pm in WeBWorK::Utils::CourseManagement::unarchiveCourse called at line 2094 of /opt/webwork/webwork2/lib/WeBWorK/ContentGenerator/CourseAdmin.pm in WeBWorK::ContentGenerator::CourseAdmin::do_unarchive_course called at line 450 of /opt/webwork/webwork2/lib/WeBWorK/ContentGenerator/CourseAdmin.pm in WeBWorK::ContentGenerator::CourseAdmin::body called at line 155 of /opt/webwork/webwork2/lib/WeBWorK/Template.pm in WeBWorK::Template::template called at line 530 of /opt/webwork/webwork2/lib/WeBWorK/ContentGenerator.pm in WeBWorK::ContentGenerator::content called at line 376 of /opt/webwork/webwork2/lib/WeBWorK/ContentGenerator/CourseAdmin.pm in WeBWorK::ContentGenerator::CourseAdmin::content called at line 202 of /opt/webwork/webwork2/lib/WeBWorK/ContentGenerator.pm in WeBWorK::ContentGenerator::go called at line 380 of /opt/webwork/webwork2/lib/WeBWorK.pm Request information Method POST URI /webwork2/admin/ HTTP Headers User-Agent Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/43.0.2357.132 Safari/537.36 Accept text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8 Connection keep-alive Referer http://webwork-dev.mydomain.com/webwork2/admin/ Content-Length 1039 Accept-Encoding gzip, deflate Cache-Control max-age=0 Origin http://webwork-dev.mydomain.com Content-Type multipart/form-data; boundary=----WebKitFormBoundary8okEy2mBmhc0LVcF Cookie WeBWorKCourseAuthen.Webwork101-testSava=admin%09Z9AJU7Ueptvx4JUEkcZDGLvgfyYFznI7%091436883605; WeBWorKCourseAuthen.admin=admin%09CbOC7mtJ1Gx7lUr1CMupUGAJunEEbXPl%091436904812; __utma=263452702.132162403.1431545094.1436468484.1436539804.34; __utmz=263452702.1436301639.31.15.utmcsr=hilbert.mathstat.mydomain.com|utmccn=(referral)|utmcmd=referral|utmcct=/index.html Accept-Language en-GB,en-US;q=0.8,en;q=0.6 Host webwork-dev.mydomain.com ______________________ At Viewing Course: ______________________ WeBWorK error An error occured while processing your request. For help, please send mail to this site's webmaster (webmaster@localhost), including all of the following information as well as what what you were doing when the error occured. Tue Jul 14 16:22:47 2015 Warning messages Error messages [missing table] Call stack The information below can help locate the source of the problem. in Exception::Class::Base::throw called at line 818 of /opt/webwork/webwork2/lib/WeBWorK/DB/Schema/NewSQL/Std.pm in WeBWorK::DB::Schema::NewSQL::Std::handle_error called at line 359 of /opt/webwork/webwork2/lib/WeBWorK/DB/Schema/NewSQL/Std.pm in WeBWorK::DB::Schema::NewSQL::Std::count_where called at line 369 of /opt/webwork/webwork2/lib/WeBWorK/DB/Schema/NewSQL/Std.pm in WeBWorK::DB::Schema::NewSQL::Std::exists_where called at line 848 of /opt/webwork/webwork2/lib/WeBWorK/DB.pm in WeBWorK::DB::settingExists called at line 1135 of /opt/webwork/webwork2/lib/WeBWorK/ContentGenerator.pm in WeBWorK::ContentGenerator::title called at line 155 of /opt/webwork/webwork2/lib/WeBWorK/Template.pm in WeBWorK::Template::template called at line 530 of /opt/webwork/webwork2/lib/WeBWorK/ContentGenerator.pm in WeBWorK::ContentGenerator::content called at line 202 of /opt/webwork/webwork2/lib/WeBWorK/ContentGenerator.pm in WeBWorK::ContentGenerator::go called at line 380 of /opt/webwork/webwork2/lib/WeBWorK.pm Request information Method GET URI /webwork2/MATH 200 Section YY/ HTTP Headers Connection keep-alive Referer http://webwork-dev.mydomain.com/webwork2/? User-Agent Mozilla/5.0 (Windows NT 6.1; WOW64; rv:39.0) Gecko/20100101 Firefox/39.0 Accept-Encoding gzip, deflate Accept text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8 Accept-Language en-US,en;q=0.5 Host webwork-dev.mydomain.com ########################################################################## Attempt at currently active course. My steps: - Archive it - Download archive file - Upload to new server ww2.10 - Unarchive - Upgrade ########################################################################## ______________________________________________________________________ before arching a course archive Course Report on database structure for course MATH_205_Summer_2_2015: key Table is ok password Table is ok permission Table is ok problem Table is ok problem_user Table is ok set Table is ok set_locations Table is ok set_locations_user Table is ok set_user Table is ok setting Table is ok user Table is ok Course MATH_205_Summer_2_2015 database is in order Directory structure DATA => /opt/webwork/courses/MATH_205_Summer_2_2015/DATA rwx email => /opt/webwork/courses/MATH_205_Summer_2_2015/templates/email rwx html => /opt/webwork/courses/MATH_205_Summer_2_2015/html rwx html_images => /opt/webwork/courses/MATH_205_Summer_2_2015/html/images rwx html_temp => /opt/webwork/courses/MATH_205_Summer_2_2015/html/tmp rwx logs => /opt/webwork/courses/MATH_205_Summer_2_2015/logs rwx macros => /opt/webwork/courses/MATH_205_Summer_2_2015/templates/macros rwx mailmerge => /opt/webwork/courses/MATH_205_Summer_2_2015/DATA/mailmerge rwx root => /opt/webwork/courses/MATH_205_Summer_2_2015 rwx scoring => /opt/webwork/courses/MATH_205_Summer_2_2015/scoring rwx templates => /opt/webwork/courses/MATH_205_Summer_2_2015/templates rwx tmpEditFileDir => /opt/webwork/courses/MATH_205_Summer_2_2015/templates/tmpEdit rwx Successfully unarchived MATH_205_Summer_2_2015.tar.gz to the course MATH_205_Summer_2_2015 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 Failed to restore table 'MATH_205_Summer_2_2015_global_user_achievement' with command '2>&1 /usr/bin/mysql --defaults-file=/tmp/9b61Pg7L1L webworkdb < /opt/webwork/courses/MATH_205_Summer_2_2015/DATA/mysqldump/global_user_achievement.sql' (exit=2 signal=0 core=0): sh: 1: cannot open /opt/webwork/courses/MATH_205_Summer_2_2015/DATA/mysqldump/global_user_achievement.sql: No such file Failed to restore table 'MATH_205_Summer_2_2015_achievement' with command '2>&1 /usr/bin/mysql --defaults-file=/tmp/3lMcJkr3uc webworkdb < /opt/webwork/courses/MATH_205_Summer_2_2015/DATA/mysqldump/achievement.sql' (exit=2 signal=0 core=0): sh: 1: cannot open /opt/webwork/courses/MATH_205_Summer_2_2015/DATA/mysqldump/achievement.sql: No such file Failed to restore table 'MATH_205_Summer_2_2015_past_answer' with command '2>&1 /usr/bin/mysql --defaults-file=/tmp/faXUnwuMUh webworkdb < /opt/webwork/courses/MATH_205_Summer_2_2015/DATA/mysqldump/past_answer.sql' (exit=2 signal=0 core=0): sh: 1: cannot open /opt/webwork/courses/MATH_205_Summer_2_2015/DATA/mysqldump/past_answer.sql: No such file Failed to restore table 'MATH_205_Summer_2_2015_achievement_user' with command '2>&1 /usr/bin/mysql --defaults-file=/tmp/7VnfX7tvRQ webworkdb < /opt/webwork/courses/MATH_205_Summer_2_2015/DATA/mysqldump/achievement_user.sql' (exit=2 signal=0 core=0): sh: 1: cannot open /opt/webwork/courses/MATH_205_Summer_2_2015/DATA/mysqldump/achievement_user.sql: No such file Request information Time Tue Jul 14 17:13:10 2015 Method POST URI /webwork2/admin/ ########################################################################## Viewing the course Viewing specific Assignment Errors: Warning -- there may be something wrong with this question. Please inform your instructor including the warning messages below. WeBWorK::Utils::readFile(/opt/webwork/courses/MATH_205_Summer_2_2015/templates/ucsbLibrary/Stewart5_5_4/Stewart5_5_4_6.pg) says: failed to read file /opt/webwork/courses/MATH_205_Summer_2_2015/templates/ucsbLibrary/Stewart5_5_4/Stewart5_5_4_6.pg: No such file or directory at /opt/webwork/webwork2/lib/WeBWorK/Utils.pm line 166. WeBWorK::Utils::readFile(/opt/webwork/courses/MATH_205_Summer_2_2015/templates/ucsbLibrary/Stewart5_5_4/Stewart5_5_4_6.pg) says: failed to read file /opt/webwork/courses/MATH_205_Summer_2_2015/templates/ucsbLibrary/Stewart5_5_4/Stewart5_5_4_6.pg: No such file or directory at /opt/webwork/webwork2/lib/WeBWorK/Utils.pm line 166.