Koozali.org: home of the SME Server
Obsolete Releases => SME Server 7.x => Topic started by: SchulzStefan on August 23, 2007, 12:23:22 PM
-
I need some help to point me in the right direction:
During the startup I get the following errors in the messages.log:
Aug 23 11:45:14 warp 10fix_privilege_tables: ERROR 1060 (42S21) at line 22: Duplicate column name 'File_priv'
Aug 23 11:45:14 warp 10fix_privilege_tables: ERROR 1060 (42S21) at line 28: Duplicate column name 'Grant_priv'
Aug 23 11:45:14 warp 10fix_privilege_tables: ERROR 1060 (42S21) at line 29: Duplicate column name 'Grant_priv'
Aug 23 11:45:14 warp 10fix_privilege_tables: ERROR 1060 (42S21) at line 30: Duplicate column name 'Grant_priv'
Aug 23 11:45:14 warp 10fix_privilege_tables: ERROR 1060 (42S21) at line 41: Duplicate column name 'ssl_type'
Aug 23 11:45:15 warp 10fix_privilege_tables: ERROR 1054 (42S22) at line 87: Unknown column 'Type' in 'columns_priv'
Aug 23 11:45:15 warp 10fix_privilege_tables: ERROR 1060 (42S21) at line 93: Duplicate column name 'type'
Aug 23 11:45:15 warp 10fix_privilege_tables: ERROR 1060 (42S21) at line 103: Duplicate column name 'Show_db_priv'
Aug 23 11:45:15 warp 10fix_privilege_tables: ERROR 1060 (42S21) at line 120: Duplicate column name 'max_questions'
Aug 23 11:45:15 warp 10fix_privilege_tables: ERROR 1060 (42S21) at line 130: Duplicate column name 'Create_tmp_table_priv'
Aug 23 11:45:15 warp 10fix_privilege_tables: ERROR 1060 (42S21) at line 133: Duplicate column name 'Create_tmp_table_priv'
Aug 23 11:45:15 warp 10fix_privilege_tables: ERROR 1061 (42000) at line 141: Duplicate key name 'Grantor'
Aug 23 11:45:15 warp 10fix_privilege_tables: @hadGrantPriv:=1
Aug 23 11:45:15 warp 10fix_privilege_tables: 1
Aug 23 11:45:15 warp last message repeated 2 times
Aug 23 11:45:15 warp 10fix_privilege_tables: @hadShowDbPriv:=1
Aug 23 11:45:15 warp 10fix_privilege_tables: 1
Aug 23 11:45:15 warp last message repeated 2 times
Thank's for any reply in advance.
stefan
-
Stephan, Bugzilla is your friend....
Check : http://bugs.contribs.org/show_bug.cgi?id=3223
------- Comment #1 From John H. Bennett III 2007-07-30 05:57:05 [reply] -------
These errors have been around for quite some time. Here is an excerpt from the
script that is run.
more /usr/share/mysql/mysql_fix_privilege_tables.sql
-- This script converts any old privilege tables to privilege tables suitable
-- for MySQL 4.0.
-- You can safely ignore all 'Duplicate column' and 'Unknown column' errors"
-- because these just mean that your tables are already up to date.
-- This script is safe to run even if your tables are already up to date!
Nothing to worry about.
chris
-
Chris,
you are right! Bugtracker is the friend of everybody!
Thank you for your reply.
stefan