MySQL update errors with "Subquery returns more than 1 row" despite lack of subquery

Question

I have a query on mysql 5.1.56:

select * from team_member_accounts where node = 33136

...that returns exactly one row. However, the following query errors with Subquery returns more than 1 row:

update team_member_accounts
set fee_remaining = 0,
    loan_account_balance = 35000,
    reimbursable_amount = 0, 
    reimbursed_amount = 0
where node = 33136

Um...what? What subquery? And how is it more than one row?

Is team_member_accounts a real table, or is it a view (which could be a combination of selects across multiple tables)? — Nick Shaw, Nov 22 '11 at 15:24
triggers! totally forgot. thanks@MarcB! (and it was a real table) — Kev, Nov 22 '11 at 15:37
@MarcB: As far as I understand notifications, I'd guess that you did not receive one... — Peter Lang, Nov 22 '11 at 16:01

score 1 · Accepted Answer · answered Dec 13 '13 at 14:42

1

The table likely has a trigger.

answered Dec 13 '13 at 14:42

Kev

15,899
15
79
112

score 0 · Answer 2 · answered Dec 13 '13 at 02:59

may be try this one update team_member_accounts set fee_remaining = 0, loan_account_balance = 35000, reimbursable_amount = 0, reimbursed_amount = 0 where node = (SELECT DISTINCT(NODE) FROM team_member_accounts where node = 33136)

if it doesnt work, i think strange in your table

MySQL update errors with "Subquery returns more than 1 row" despite lack of subquery

2 Answers2