Forum archive 2000-2006

Steven Xiao - ERROR 1047 at line 4: Unknown command

Steven Xiao - ERROR 1047 at line 4: Unknown command

by Arnold Pizer -
Number of replies: 0
inactiveTopicERROR 1047 at line 4: Unknown command topic started 8/6/2004; 2:41:28 PM
last post 8/20/2004; 2:30:11 PM
userSteven Xiao - ERROR 1047 at line 4: Unknown command  blueArrow
8/6/2004; 2:41:28 PM (reads: 1424, responses: 1)
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 |>


userSteven Xiao - Re: ERROR 1047 at line 4: Unknown command  blueArrow
8/20/2004; 2:30:11 PM (reads: 1652, responses: 0)
It looks like I need to reset my mysqld start up options. After I changed it to:

mysql-safe --user=mysql --datadir=/var/libmysql &

It seems that it works fine. I had another option --skip-grant-tables.

<| Post or View Comments |>