mysqlup: ERROR 1175

[linux4me]

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:

perlmod--Install done
ERROR 1175 (HY000) at line 1: You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column
Install Complete

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?

[Humayun]

Hi ,
does it cause the problem in MySQL ?? if not ignore it

[linux4me]

Hi ,
does it cause the problem in MySQL ?? if not ignore it

I haven't noticed any problems yet...

[webhostinghelps]

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

[linux4me]

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:

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.

[Ghulam Yaseen]

Hello,

I think you have created a table in a database that is not correctly made. This error is one out of other hundreds of mysql error codes. Please try find the buggy database and fix the error table and then try again. for further please refer these links
http://linuxqna.com/tag/%ED%8F%AC%ED%8A%B8
http://binboy.sphere.pl/index.php?sh...-handling.html

[linux4me]

Hello,

I think you have created a table in a database that is not correctly made. This error is one out of other hundreds of mysql error codes. Please try find the buggy database and fix the error table and then try again. for further please refer these links
http://linuxqna.com/tag/%ED%8F%AC%ED%8A%B8
http://binboy.sphere.pl/index.php?sh...-handling.html

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.