Hi,
I downloaded WebWork 2.0.1 from sourceforge.net, followed the
installation instruction and installed. Everthing looked fine until I
run the command
bin/addcourse --db-layout=sql --sql-user=root --sql-pass=secret
--sql-db=webwork_admin --sql-wwhost=localhost
--users=courses/adminClasslist.lst --professors=admin admin
to try to create an admin account. The error message is
ERROR 1047 at line 4: Unknown command
admin: course database creation failed.
I checked the webwork_admin database. I can see the table there:
mysql> show tables;
+-------------------------+
| Tables_in_webwork_admin |
+-------------------------+
| problem_user |
+-------------------------+
1 row in set (0.00 sec)
mysql> describe problem_user;
+---------------+------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------------+------+------+-----+---------+-------+
| user_id | text | YES | | NULL | |
| set_id | text | YES | | NULL | |
| problem_id | text | YES | | NULL | |
| source_file | text | YES | | NULL | |
| value | text | YES | | NULL | |
| max_attempts | text | YES | | NULL | |
| problem_seed | text | YES | | NULL | |
| status | text | YES | | NULL | |
| attempted | text | YES | | NULL | |
| last_answer | text | YES | | NULL | |
| num_correct | text | YES | | NULL | |
| num_incorrect | text | YES | | NULL | |
+---------------+------+------+-----+---------+-------+
12 rows in set (0.00 sec)
mysql> select * from problem_user;
Empty set (0.00 sec)
mysql>
Apparently, I got an empty database there.
Does anyone have any idea what is wrong?
Thanks,
My MySQL is version 4.0.20. Http is 1.3.31.
<| Post or View Comments |>
|