please help with the "subquery returns more than 1 row" error

[giusseppe]

hello i have a mysql database that i made from some oracle scripts, any way the tables are created with no problems also the views and the triggers, but i try to insert in one table some values and i get the error "subquery returns more than 1 row"

the table definition is:

CREATE TABLE ACCIONES_GRUPOS (
ACCIONGRUPOID	INTEGER NOT NULL,
GRUPOID      	INTEGER NOT NULL,
ACCIONID     	INTEGER NULL
)ENGINE=INNODB;

and the insert is:

INSERT INTO `sac`.`acciones_grupos`(`acciongrupoid`, `grupoid`, `accionid`)
VALUES (1, 0, 0),
  (2, 0, 1),
  (3, 0, 2),
  (4, 0, 3),
  (5, 0, 4),
  (6, 0, 5),
  (7, 1, 10),
  (8, 1, 11),
  (9, 1, 12),
  (10, 1, 13),
  (11, 1, 14),
  (12, 1, 15),
  (13, 1, 16),
  (14, 2, 20),
  (15, 2, 21),
  (16, 2, 22),
  (17, 2, 23),
  (18, 2, 24),
  (19, 2, 25),
  (20, 3, 30),
  (21, 3, 31),
  (22, 3, 32),
  (23, 3, 33),
  (24, 3, 34),
  (25, 3, 35),
  (26, 3, 36),
  (27, 4, 40),
  (28, 4, 41),
  (29, 4, 42),
  (30, 4, 43),
  (31, 4, 44),
  (32, 4, 45),
  (33, 5, 50),
  (34, 5, 51),
  (35, 5, 52),
  (36, 5, 53),
  (37, 5, 54),
  (38, 5, 55),
  (39, 5, 56),
  (40, 6, 60),
  (41, 6, 61),
  (42, 6, 62),
  (43, 6, 63),
  (44, 6, 64),
  (45, 6, 65),
  (46, 7, 70),
  (47, 7, 71),
  (48, 7, 72),
  (49, 7, 73),
  (50, 7, 74),
  (51, 7, 75),
  (52, 8, 80),
  (53, 8, 81),
  (54, 8, 82),
  (55, 8, 83),
  (56, 8, 84),
  (57, 8, 85),
  (58, 9, 90);

thank you so much

[fenway]

Use code tags next time.

 

That's a strange error for an INSERT... are you sure?

[giusseppe]

sorry!!!

 

i have a mysql 5.0.67 version, the exact error is:"Subquery returns more than 1 row  error number 1242". and yeah i am very sure of the error, i really can't figurate what's going on.

 

thank you!

[fenway]

There is no subquery present...