Forum archive 2000-2006

Bill Ziemer - mysql unknown column error

Bill Ziemer - mysql unknown column error

by Arnold Pizer -
Number of replies: 0
inactiveTopicmysql unknown column error topic started 8/29/2005; 12:13:21 AM
last post 8/29/2005; 8:21:54 AM
userBill Ziemer - mysql unknown column error  blueArrow
8/29/2005; 12:13:21 AM (reads: 637, responses: 2)
I upgraded from 2.0 to 2.1.3 and have the following error when I try and create a problem:

DBD::mysql::st execute failed: Unknown column 'assignment_type' in 'field list' at /var/www/webwork/webwork2/lib/WeBWorK/DB/Schema/SQL.pm line 186

Is the utility webwork2/bin/ww_db_v2_to_v3 what I need to do?

<| Post or View Comments |>

userBill Ziemer - Re: mysql unknown column error  blueArrow
8/29/2005; 12:49:35 AM (reads: 703, responses: 0)
Well I went ahead and ran it, and got the error:

Can't call method "creation_date" on an undefined value at /var/www/webwork/webwork2/lib/WeBWorK/DBv3.pm line 284. Compilation failed in require at ./ww_db_v2_to_v3 line 181. BEGIN failed--compilation aborted at ./ww_db_v2_to_v3 line 181.

<| Post or View Comments |>

userGavin LaRose - Re: mysql unknown column error  blueArrow
8/29/2005; 8:21:54 AM (reads: 706, responses: 0)
Hi Bill,

The 'assignment_type' column was added in the HEAD branch of WeBWorK for gateway tests. There's a utility in the bin directory of the webwork2 tree called wwdb_addgw that adds the columns to existing classes/databases. It's pretty straightforward, if not extensively tested.

Gavin

<| Post or View Comments |>