Community Forums
Connect with us on LinkedIn
Community Notice
+ Reply to Thread
Results 1 to 2 of 2
  1. #1
    Member
    Join Date
    Oct 2001
    Posts
    651

    Default Problem/Annoyance

    I am getting this in my upcp email ever day now:

    This scripts updates the mysql.user, mysql.db, mysql.host and the
    mysql.func tables to MySQL 3.22.14 and above.


    This is needed if you want to use the new GRANT functions,
    CREATE AGGREGATE FUNCTION or want to use the more secure passwords in 3.23


    If you get 'Access denied' errors, you should run this script again
    and give the MySQL root user password as an argument!
    Converting all privilege tables to MyISAM format


    If your tables are already up to date or partially up to date you will
    get some warnings about 'Duplicated column name'. You can safely ignore these!
    ERROR 1060 at line 2: Duplicate column name 'File_priv'


    Creating Grant Alter and Index privileges if they don't exists
    You can ignore any Duplicate column errors
    ERROR 1060 at line 1: Duplicate column name 'Grant_priv'
    ERROR 1060 at line 2: Duplicate column name 'Grant_priv'
    ERROR 1060 at line 3: Duplicate column name 'Grant_priv'


    Setting default privileges for the new grant, index and alter privileges


    Adding columns needed by GRANT .. REQUIRE (openssl)
    You can ignore any Duplicate column errors
    ERROR 1060 at line 1: Duplicate column name 'ssl_type'


    Creating the new table and column privilege tables
    Changing name of columns_priv.Type -> columns_priv.Column_priv
    You can ignore any Unknown column errors from this
    ERROR 1054 at line 1: Unknown column 'Type' in 'columns_priv'


    Fixing the func table
    You can ignore any Duplicate column errors
    ERROR 1060 at line 1: Duplicate column name 'type'


    Adding new fields used by MySQL 4.0.2 to the privilege tables
    You can ignore any Duplicate column errors
    ERROR 1060 at line 1: Duplicate column name 'Show_db_priv'


    Updating new privileges in MySQL 4.0.2 from old ones


    ERROR 1060 at line 1: Duplicate column name 'max_questions'
    ERROR 1060 at line 1: Duplicate column name 'Create_tmp_table_priv'
    ERROR 1060 at line 4: Duplicate column name 'Create_tmp_table_priv'
    Is there any reason for this to continue?
    Marty Hoskins
    TLC Web Enterprises

  2. #2
    Member
    Join Date
    Mar 2003
    Location
    Sothern California, USA
    Posts
    11

    Default

    I been wondering myself why that is happening. I already ran the commands needed to "update/fix" the databases for mysql 4 ... so I am wondering myself why this keeps poping up in my emails as well.

Similar Threads & Tags
Similar threads

  1. Security annoyance: Hide Exim version
    By sv70 in forum E-mail Discussions
    Replies: 8
    Last Post: 11-09-2010, 10:19 PM
  2. MySQL annoyance = server load issues!
    By robbie_troster in forum cPanel and WHM Discussions
    Replies: 9
    Last Post: 09-27-2009, 08:27 PM
  3. Cpanel/WHM problem, Exim problem, Mail problem
    By iroku in forum cPanel and WHM Discussions
    Replies: 4
    Last Post: 08-18-2006, 05:28 PM
  4. Email Sending Problem (451 Temporary local problem)
    By saj in forum E-mail Discussions
    Replies: 1
    Last Post: 03-30-2006, 11:07 AM
  5. Weird problem, urgent help needed with Mail problem
    By fuzioneer in forum cPanel and WHM Discussions
    Replies: 1
    Last Post: 09-07-2005, 05:00 AM
Linkedin       Facebook       Twitter       RSS       Flickr       YouTube