The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

mysqlup: ERROR 1175

Discussion in 'General Discussion' started by linux4me, Sep 20, 2008.

  1. linux4me

    linux4me Member

    Joined:
    Jul 14, 2007
    Messages:
    20
    Likes Received:
    1
    Trophy Points:
    1
    I just did an upgrade from MySQL version 4.2.2-standard to 5.0.51a-community using /scripts/mysqlup, and the script seems to have been successful, but I received the following three lines of output at the very end of the script:
    I searched here and Googled, but I couldn't find any mention of that error in regard to running mysqlup.

    Is there something I need to do to address the error, or can I safely ignore it?
     
  2. Humayun

    Humayun Member

    Joined:
    Jul 15, 2008
    Messages:
    21
    Likes Received:
    0
    Trophy Points:
    1
    Hi ,
    does it cause the problem in MySQL ?? if not ignore it ;)
     
  3. linux4me

    linux4me Member

    Joined:
    Jul 14, 2007
    Messages:
    20
    Likes Received:
    1
    Trophy Points:
    1
    I haven't noticed any problems yet...
     
  4. webhostinghelps

    Joined:
    Sep 22, 2008
    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    1
    The error code '1175' occur when you call MySQL from any host language.

    We can separate this error in the following categories.

    Name- ERROR
    Code -1175
    State-(HY000)

    You can find the name and Error Code definitions in the `include/mysqld_error.h' MySQL source file and SQLSTATE in the `include/sql_state.h'. SQLSTATE error code is displayed only if you use MySQL version 4.1 and up.



    http://webhostinghelps.net
    http://blog.webhostinghelps.net
     
  5. linux4me

    linux4me Member

    Joined:
    Jul 14, 2007
    Messages:
    20
    Likes Received:
    1
    Trophy Points:
    1
    Thanks for the info, Webhostinghelps.

    I am concerned about the significance of the error appearing at that particular part of the mysqlup script, and am wondering if it represents a problem I need to address.

    I'm not an expert on bash scripts, but it looks like the error is generated somewhere in the mysqlup script around this point judging by the lines that precede and follow it:
    Code:
    my $touchmysql = 0;
    if ( $updated > 0 ) {
        checkselinux();
        system '/scripts/perlinstaller', '--force', 'DBD::mysql';
        system '/scripts/securemysql',   '-qFa',    'removelockntmp';
    
        $touchmysql = 1;
    }
    
    my $mysqld = cPScript::DbUtils::find_mysqld();
    my $mysqld_mtime = (stat($mysqld))[9] || 0;
    my $mysqlup_mtime = (stat('/scripts/mysqlup'))[9]  || 0;
    
    if ( $mysqld_mtime < $mysqlup_mtime ) {
        $touchmysql = 1;
    }
    
    if ($touchmysql) {
        cPScript::FileUtils::touchfile($mysqld);
    }
    
    print "Install Complete\n";
    
    When I submitted the original question, I was hoping someone familiar with the mysqlup script could tell me if the error was something to worry about, and how to fix the underlying problem, if any.
     
  6. Ghulam Yaseen

    Ghulam Yaseen Well-Known Member

    Joined:
    Mar 14, 2008
    Messages:
    49
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Karachi,Pakistan
  7. linux4me

    linux4me Member

    Joined:
    Jul 14, 2007
    Messages:
    20
    Likes Received:
    1
    Trophy Points:
    1
    Thanks, Yaseen. Since I posted I found a table called "objectcache" in a mediawiki site that was corrupted, and had to fix that using myisamchk. That's all I found so far; I'm hoping that was it.
     
Loading...

Share This Page