Installation

2.19 upgrade_admin_db.pl issues

Re: 2.19 upgrade_admin_db.pl issues

by Volkan Akgul -
Number of replies: 0

I upgraded from version 2.15 to 2.19. I created a MySQL dump and then imported it into the new system.
In the mentioned site.conf, the admin_course_id value is already set to "admin." After that, I ran the upgrade_admin_db.pl script and saw the confirmation that it was updated, but I am still getting the following error.


WeBWorK error

An error occurred while processing your request.

For help, please send mail to this site's webmaster, including all of the following information as well as what what you were doing when the error occurred.

Error record identifier

aef3d35e-44da-5f2c-aa31-3066c08e436e::7e1d76a5-a706-11ef-a5fb-e73fab8e8d32

Warning messages

  • It looks like the database is missing a column. You may need to upgrade your course tables. If this is the admin course then you will need to upgrade the admin tables using the upgrade_admin_db.pl script. at /opt/webwork/webwork2/lib/WeBWorK/DB/Schema/NewSQL/Std.pm line 925.

Error messages

DBD::MariaDB::st execute failed: Unknown column 'key' in 'field list' at /opt/webwork/webwork2/lib/WeBWorK/DB/Schema/NewSQL/Std.pm line 930.

Context

  • 925: 			warn(
  • 926: 				"It looks like the database is missing a column.  You may need to upgrade your course tables.  If this is the admin course then you will need to upgrade the admin tables using the upgrade_admin_db.pl script."
  • 927: 			);
  • 928: 		}
  • 929: 
  • 930: 		die $errmsg;
  • 931: 	}
  • 932: }
  • 933: 
  • 934: sub DESTROY {
  • 935: }

Call stack

  • in Mojolicious::_die called at line 930 of /opt/webwork/webwork2/lib/WeBWorK/DB/Schema/NewSQL/Std.pm
  • in WeBWorK::DB::Schema::NewSQL::Std::handle_error called at line 517 of /opt/webwork/webwork2/lib/WeBWorK/DB/Schema/NewSQL/Std.pm
  • in WeBWorK::DB::Schema::NewSQL::Std::_get_fields_where_prepex called at line 485 of /opt/webwork/webwork2/lib/WeBWorK/DB/Schema/NewSQL/Std.pm
  • in WeBWorK::DB::Schema::NewSQL::Std::get_fields_where called at line 545 of /opt/webwork/webwork2/lib/WeBWorK/DB/Schema/NewSQL/Std.pm
  • in WeBWorK::DB::Schema::NewSQL::Std::get_records_where called at line 844 of /opt/webwork/webwork2/lib/WeBWorK/DB/Schema/NewSQL/Std.pm
  • in WeBWorK::DB::Schema::NewSQL::Std::gets called at line 810 of /opt/webwork/webwork2/lib/WeBWorK/DB.pm
  • in WeBWorK::DB::getKey called at line 893 of /opt/webwork/webwork2/lib/WeBWorK/Authen.pm
  • in WeBWorK::Authen::check_session called at line 461 of /opt/webwork/webwork2/lib/WeBWorK/Authen.pm
  • in WeBWorK::Authen::verify_normal_user called at line 273 of /opt/webwork/webwork2/lib/WeBWorK/Authen.pm
  • in WeBWorK::Authen::do_verify called at line 161 of /opt/webwork/webwork2/lib/WeBWorK/Authen.pm
  • in WeBWorK::Authen::verify called at line 177 of /opt/webwork/webwork2/lib/WeBWorK.pm
  • in (eval) called at line 60 of /opt/webwork/webwork2/lib/WeBWorK.pm
  • in WeBWorK::dispatch called at line 162 of /opt/webwork/webwork2/lib/Mojolicious/WeBWorK.pm
  • in (eval) called at line 162 of /opt/webwork/webwork2/lib/Mojolicious/WeBWorK.pm
  • in (eval) called at line 145 of /opt/webwork/webwork2/lib/Mojolicious/WeBWorK.pm
  • in Mojolicious::WeBWorK::__ANON__ called at line 15 of /usr/share/perl5/Mojolicious/Plugins.pm
  • in Mojolicious::Plugins::__ANON__ called at line 18 of /usr/share/perl5/Mojolicious/Plugins.pm
  • in Mojolicious::Plugins::emit_chain called at line 88 of /usr/share/perl5/Mojolicious/Routes.pm
  • in Mojolicious::Routes::_action called at line 161 of /usr/share/perl5/Mojolicious/Routes.pm
  • in Mojolicious::Routes::_controller called at line 44 of /usr/share/perl5/Mojolicious/Routes.pm
  • in Mojolicious::Routes::continue called at line 46 of /usr/share/perl5/Mojolicious/Routes.pm
  • in Mojolicious::Routes::continue called at line 46 of /usr/share/perl5/Mojolicious/Routes.pm
  • in Mojolicious::Routes::continue called at line 52 of /usr/share/perl5/Mojolicious/Routes.pm
  • in Mojolicious::Routes::dispatch called at line 127 of /usr/share/perl5/Mojolicious.pm
  • in Mojolicious::dispatch called at line 136 of /usr/share/perl5/Mojolicious.pm
  • in Mojolicious::__ANON__ called at line 15 of /usr/share/perl5/Mojolicious/Plugins.pm
  • in Mojolicious::Plugins::__ANON__ called at line 203 of /usr/share/perl5/Mojolicious.pm
  • in (eval) called at line 203 of /usr/share/perl5/Mojolicious.pm
  • in Mojolicious::_exception called at line 15 of /usr/share/perl5/Mojolicious/Plugins.pm
  • in Mojolicious::Plugins::__ANON__ called at line 18 of /usr/share/perl5/Mojolicious/Plugins.pm
  • in Mojolicious::Plugins::emit_chain called at line 141 of /usr/share/perl5/Mojolicious.pm
  • in Mojolicious::handler called at line 72 of /usr/share/perl5/Mojo/Server.pm
  • in Mojo::Server::__ANON__ called at line 15 of /usr/share/perl5/Mojo/EventEmitter.pm
  • in Mojo::EventEmitter::emit called at line 103 of /usr/share/perl5/Mojo/Server/Daemon.pm
  • in Mojo::Server::Daemon::__ANON__ called at line 15 of /usr/share/perl5/Mojo/EventEmitter.pm
  • in Mojo::EventEmitter::emit called at line 60 of /usr/share/perl5/Mojo/Transaction/HTTP.pm
  • in Mojo::Transaction::HTTP::server_read called at line 224 of /usr/share/perl5/Mojo/Server/Daemon.pm
  • in Mojo::Server::Daemon::_read called at line 202 of /usr/share/perl5/Mojo/Server/Daemon.pm
  • in Mojo::Server::Daemon::__ANON__ called at line 15 of /usr/share/perl5/Mojo/EventEmitter.pm
  • in Mojo::EventEmitter::emit called at line 109 of /usr/share/perl5/Mojo/IOLoop/Stream.pm
  • in Mojo::IOLoop::Stream::_read called at line 57 of /usr/share/perl5/Mojo/IOLoop/Stream.pm
  • in Mojo::IOLoop::Stream::__ANON__ called at line 141 of /usr/share/perl5/Mojo/Reactor/Poll.pm
  • in (eval) called at line 141 of /usr/share/perl5/Mojo/Reactor/Poll.pm
  • in Mojo::Reactor::Poll::_try called at line 54 of /usr/share/perl5/Mojo/Reactor/EV.pm
  • in Mojo::Reactor::EV::__ANON__ called at line 32 of /usr/share/perl5/Mojo/Reactor/EV.pm
  • in (eval) called at line 32 of /usr/share/perl5/Mojo/Reactor/EV.pm
  • in Mojo::Reactor::EV::start called at line 134 of /usr/share/perl5/Mojo/IOLoop.pm
  • in Mojo::IOLoop::start called at line 38 of /usr/share/perl5/Mojo/Server/Daemon.pm
  • in Mojo::Server::Daemon::run called at line 31 of /usr/share/perl5/Mojolicious/Command/daemon.pm
  • in Mojolicious::Command::daemon::run called at line 57 of /usr/share/perl5/Mojolicious/Commands.pm
  • in Mojolicious::Commands::run called at line 184 of /usr/share/perl5/Mojolicious.pm
  • in Mojolicious::start called at line 82 of /usr/share/perl5/Mojolicious/Commands.pm
  • in Mojolicious::Commands::start_app called at line 44 of /opt/webwork/webwork2/bin/webwork2