ERROR 1227 (42000): Access denied; you need the SUPER privilege for this operation on simple INSERT
we have Server version: 5.0.51a-24+lenny5 (Debian)
I run this command:
insert into PUBLISH (TXT,INGRESS,LEVELS,PUBLISH_UP,LINK,HIS_USER_ID,FREETEXT,ACTIVE,PUBLISH_ID,TEMPLATE,PRIORITY) values ('test53','','0','1260','','100764','','on','1283','artikkelkategori','50');
and get this error reported:
ERROR 1227 (42000): Access denied; you need the SUPER privilege for this operation
but, otherwise the data is inserted... and things seems to work. is this a bug? or something I am doing wrong?
mysql> desc PUBLISH;
+------------------+-----------------+------+-----+-------------------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------------+-----------------+------+-----+-------------------+-------+
| PUBLISH_ID | varchar(50) | NO | PRI | | |
| TXT | varchar(100) | NO | | | |
| LOGO | varchar(255) | NO | | | |
| FREETEXT | text | NO | | NULL | |
| TEMPLATE | varchar(30) | NO | | | |
| PRIORITY | int(11) | NO | | 0 | |
| MISC1 | varchar(255) | NO | | | |
| MISC2 | varchar(255) | NO | | | |
| SHOP_ID | varchar(30) | YES | | NULL | |
| LEVELS | int(11) | NO | | 0 | |
| PUBLISH_UP | varchar(50) | NO | | 0 | |
| ACTIVE | char(3) | YES | | on | |
| TS | timestamp | NO | | CURRENT_TIMESTAMP | |
| ACCESS_INTERNETT | set('on','off') | YES | | on | |
| ACCESS_EXTRANETT | set('on','off') | YES | | off | |
| ACCESS_INTRANETT | set('on','off') | YES | | off | |
| MD5_UPDATE | varchar(32) | YES | | NULL | |
| MD5_MASTER | varchar(32) | YES | | NULL | |
| INGRESS | text | YES | | NULL | |
| LINK | varchar(255) | YES | | NULL | |
| HELP_ID | int(11) | YES | | NULL | |
| ICON | varchar(255) | YES | | NULL | |
| SEFURL | varchar(255) | YES | | NULL | |
| HIS_USER_ID | int(11) | YES | | NULL | |
+------------------+-----------------+------+-----+-------------------+-------+
before:
mysql> select * from PUBLISH where PUBLISH_ID = "1283";
Empty set (0.00 sec)
after:
| PUBLISH_ID | TXT | LOGO | FREETEXT | TEMPLATE | PRIORITY | MISC1 | MISC2 | SHOP_ID | LEVELS | PUBLISH_UP | ACTIVE | TS | ACCESS_INTERNETT | ACCESS_EXTRANETT | ACCESS_INTRANETT | MD5_UPDATE | MD5_MASTER | INGRESS | LINK | HELP_ID | ICON | SEFURL | HIS_USER_ID |
+------------+--------+------+----------+------------------+----------+-------+-------+---------+--------+------------+--------+---------------------+------------------+------------------+------------------+------------+------------+---------+------+---------+------+--------+-------------+
| 1283 | test53 | | | artikkelkategori | 50 | | | NULL | 0 | 1260 | on | 2011-12-19 05:04:10 | on | off | off | NULL | NULL | | | NULL | NULL | NULL | 100764 |
+------------+--------+------+----------+------------------+----------+-------+-------+---------+--------+------------+--------+---------------------+------------------+------------------+------------------+------------+------------+---------+------+---------+------+--------+-------------+