| 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: | |
| Category: | MySQL Administrator | Severity: | S1 (Critical) |
| Version: | 1.1.5 | OS: | Windows (Windows XP Professional) |
| Assigned to: | Assigned Account | CPU Architecture: | Any |
| Tags: | User Management | ||
[21 Nov 2005 14:13]
Ionut Muntean
[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.
