Bug #15099 Unknown column 'Create_view_priv' in 'field list' (1054)
Submitted: 21 Nov 2005 14:13 Modified: 10 Aug 2006 15:14
Reporter: Ionut Muntean Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Administrator Severity:S1 (Critical)
Version:1.1.5 OS:Microsoft Windows (Windows XP Professional)
Assigned to: Assigned Account CPU Architecture:Any
Tags: User Management

[21 Nov 2005 14:13] Ionut Muntean
Description:
I'm using Mysql Administrator version 1.1.5 to manage server on a Linux (Debian) machine. Info:

MySQL Server Information
--------------------------------------------------------------------------------
Connected to MySQL Server Instance
  Username:                root
  Hostname:                shuttle
  Port:                    17249
--------------------------------------------------------------------------------
Server Information
  MySQL Version:           MySQL 5.0.15-Debian_2-log via TCP/IP
  Network Name:            gw-e100
  IP:                      xx.xx.xx.xx
--------------------------------------------------------------------------------
Client Information
  Version:                 MySQL Client Version 5.0.11
  Network Name:            osiris
  IP:                      xx.xx.xx.xx
  Operating System:        Windows XP
  Hardware:                AMD Athlon(tm) 64 Processor 3000+, 1.0 GB RAM

All the time I try to edit/add an user the following message is displayed:

Unknown column 'Create_view_priv' in 'field list' (1054)

How to repeat:
Use the above configuration and the error is repeatable.

Suggested fix:
No clue ??
[21 Nov 2005 17:00] Jorge del Conde
Hi!

Can you tell me exactly what version of mysql are you running ?

Thanks!
[22 Nov 2005 7:18] Ionut Muntean
Mysql was installed through apt-get from ftp.debian.org. The version is 5.0.15-Debian_2-log.
[22 Nov 2005 7:19] Ionut Muntean
Output from mysqladmin version:

Server version          5.0.15-Debian_2-log
Protocol version        10
Connection              Localhost via UNIX socket
UNIX socket             /var/run/mysqld/mysqld.sock
Uptime:                 7 days 12 hours 4 min 42 sec

Threads: 10  Questions: 2223451  Slow queries: 0  Opens: 0  Flush tables: 1  Open tables: 64  Queries per second avg: 3.430
[29 Nov 2005 22:21] Carl Schwarcz
I get the same error on Windows XP SP2 when trying to display or modify user account info:

Error while fetching user information.  The following error occured: Unknown column 'Create_view_priv' in field list (1054).

Using MySQL 5.0.15 with Administrator 1.1.15.

This means that I can not do any admin of user accounts.
[9 Dec 2005 19:28] David Tosh
Same error message when attempting to display user information.
Windows 2000 professional
MySQL 5.0.15nt via TCP
connected to localhost as root
MySQL Administrator 1.1.5 (downloaded 9 December)
Could this be the same as Create_tmp_table_priv that is found in the MySQL/user table?

DLT
[15 Dec 2005 13:22] Resent beingforcedtosignup
This feature worked when I was using MySQL 4.1 with MySQL Administrator 1.1.5

When I upgraded to Version 5.0.16 I get the error described above
[14 Jan 2006 15:30] Nikola Goran Cutura
I had the same problem with MySQL 5.0.18 on SuSE 9.3 Pro.
After executing 'mysql_fix_privilege_tables' problem disappeared and 'user' table has two new columns. Details in reference manual:

5.4. mysql_fix_privilege_tables — Upgrade MySQL System Tables

Regards,
NGC
[10 Jul 2006 14:18] Vladimir Kolesnikov
Hi Ionut,

Can you confirm or decline that updating MySQL system tables fixed the problem?

Thanks
[3 Aug 2006 19:24] Kevin McHale
I have MySQL 5.0.22 and neither the mysql_upgrade application nor the scripts/mysql_fix_privilege_tables.sql script is included with the distribution. In fact, there is not scripts directory at all.
[10 Aug 2006 23:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
[1 Dec 2006 3:49] Marlon Cork
I am having similar problem on Fedora Core 6 running mysql 5.0.22. I recently upgraded from version 4. Running the mysql_upgrade command returns ok for all tables but I still am not able to administer users even after restarting database. If I run mysql-fix_privilege_tables, I get the following error-> Got a failure from command:
cat /usr/share/mysql/mysql_fix_privilege_tables.sql | /usr/bin/mysql --no-defaults --force --user=root --host=localhost --database=mysql
Please check the above output and try again. So I try this command from shell: cat /usr/share/mysql/mysql_fix_privilege_tables.sql | /usr/bin/mysql --no-defaults --force --user=root --host=localhost --database=mysql --password
then I get the following output. Any ideas?

ERROR 1060 (42S21) at line 22: Duplicate column name 'File_priv'
ERROR 1060 (42S21) at line 28: Duplicate column name 'Grant_priv'
ERROR 1060 (42S21) at line 29: Duplicate column name 'Grant_priv'
ERROR 1060 (42S21) at line 30: Duplicate column name 'Grant_priv'
ERROR 1060 (42S21) at line 41: Duplicate column name 'ssl_type'
ERROR 1060 (42S21) at line 70: Duplicate column name 'Routine_type'
ERROR 1054 (42S22) at line 94: Unknown column 'Type' in 'columns_priv'
ERROR 1060 (42S21) at line 100: Duplicate column name 'type'
ERROR 1060 (42S21) at line 110: Duplicate column name 'Show_db_priv'
ERROR 1060 (42S21) at line 127: Duplicate column name 'max_questions'
ERROR 1060 (42S21) at line 137: Duplicate column name 'Create_tmp_table_priv'
ERROR 1060 (42S21) at line 140: Duplicate column name 'Create_tmp_table_priv'
ERROR 1061 (42000) at line 145: Duplicate key name 'Grantor'
ERROR 1060 (42S21) at line 252: Duplicate column name 'Create_view_priv'
ERROR 1060 (42S21) at line 253: Duplicate column name 'Create_view_priv'
ERROR 1060 (42S21) at line 254: Duplicate column name 'Create_view_priv'
ERROR 1060 (42S21) at line 259: Duplicate column name 'Show_view_priv'
ERROR 1060 (42S21) at line 260: Duplicate column name 'Show_view_priv'
ERROR 1060 (42S21) at line 261: Duplicate column name 'Show_view_priv'
ERROR 1060 (42S21) at line 282: Duplicate column name 'Create_routine_priv'
ERROR 1060 (42S21) at line 283: Duplicate column name 'Create_routine_priv'
ERROR 1060 (42S21) at line 284: Duplicate column name 'Create_routine_priv'
ERROR 1060 (42S21) at line 289: Duplicate column name 'Alter_routine_priv'
ERROR 1060 (42S21) at line 290: Duplicate column name 'Alter_routine_priv'
ERROR 1060 (42S21) at line 291: Duplicate column name 'Alter_routine_priv'
ERROR 1060 (42S21) at line 293: Duplicate column name 'Execute_priv'
ERROR 1060 (42S21) at line 294: Duplicate column name 'Execute_priv'
ERROR 1060 (42S21) at line 306: Duplicate column name 'max_user_connections'
ERROR 1060 (42S21) at line 315: Duplicate column name 'Create_user_priv'
[10 Apr 2008 21:33] Dan LeGate
I'm having the same problem with MySQL Administrator 1.2.11 and MySQL 5.0.37-community on Windows 2003 Server.

Following the links seems to indicate I should run mysql_upgrade, but running:

mysqlcheck --check-upgrade --all-databases 

doesn't find any problems.  I'm also seeing that "mysql_upgrade supersedes the older mysql_fix_privilege_tables script" so I'm not sure where to go from here.