>Descritpion:
Hello,
I've got MySQL installed on a P-III 1ghz machine running RedHat 7. I am
havign the same error, over and over again when I attempt to delete anything from any
table. I've tried this delete from being ROOT to being a peon user.
Heres my query:
DELETE FROM topicexception WHERE word='SEXY';
And heres my return text:
ERROR 1175: You are using safe update mode and you tried to update a table without a
WHERE that uses a KEY column
As part of a sanity check, i deleted and readded ALL of the tables and database, even
restarted MySQLd using safe_mysqld and after it stil did it, i ran one mysqld --args,
and STILL got the error.
Heres some info on the tables and database:
+----------------------+
| Tables_in_dynastynet |
+----------------------+
| admfounder |
| admin |
| nickexception |
| nickkeyword |
| topicexception |
| topickeyword |
| vhost |
+----------------------+
7 rows in set (0.00 sec)
+-------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+-------+
| word | varchar(30) | | | | |
+-------+-------------+------+-----+---------+-------+
+-------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+-------+
| id | varchar(30) | | | | |
| pass | varchar(30) | | | | |
+-------+-------------+------+-----+---------+-------+
+-------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+-------+
| word | varchar(30) | | | | |
+-------+-------------+------+-----+---------+-------+
>How-To-Repeat:
Just for fun, i created a stable from scratch with the same problem.. ALL tables do
this.
mysql> CREATE TABLE test (badword text);
Query OK, 0 rows affected (0.00 sec)
mysql> insert into test ('lala');
ERROR 1064: You have an error in your SQL syntax near ''lala')' at line 1
mysql> insert into test values ('lala');
Query OK, 1 row affected (0.01 sec)
mysql> delete from test where badword='lala';
ERROR 1175: You are using safe update mode and you tried to update a table without a
WHERE that uses a KEY column
mysql> drop table test
-> ;
Query OK, 0 rows affected (0.00 sec)
>Fix:
No fix.. Nothing in the documentation about this either. I've asked onIRC,
deja news, etc etc.. no ones ever seen this so im convinced its a bug of some sort.
>Submitter-Id: <submitter ID>
>Originator: Jason Brascum
>Organization:
No organiztion
>MySQL support: none
>Synopsis: im completely unable to delete from tables
>Severity: serious
>Priority: medium
>Category: mysql
>Class: sw-bug
>Release: mysql-3.23.39 (Source distribution)
>Environment:
System: Linux whorebox.terron.com 2.2.16-22 #1 Tue Aug 22 16:49:06 EDT 2000 i686
unknown
Architecture: i686
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc
/usr/bin/cc GCC: Reading specs from
/usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96
20000731 (Red Hat Linux 7.0) Compilation info: CC='gcc' CFLAGS=''
CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx 1 root root 11 Mar
24 20:54 /lib/libc.so.6 -> libc-2.2.so -rwxr-xr-x 1 root root 5155229
Jan 10 2001 /lib/libc-2.2.so -rw-r--r-- 1 root root 24498288 Jan 10
2001 /usr/lib/libc.a -rw-r--r-- 1 root root 178 Jan 10 2001
/usr/lib/libc.so Configure command: ./configure
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php