MySQL :: Re: (UPDATED with Schema) Triggers before update error (Error Code: 1054. Unknown column 'workflow

Contact MySQL |
Login | Register

The world's most popular open source database

Documentation Downloads MySQL.com

Developer Zone

Section Menu:

New Topic

Re: (UPDATED with Schema) Triggers before update error (Error Code: 1054. Unknown column 'workflow_id' in 'NEW')

Posted by: Steve Landry
Date: January 28, 2014 12:25PM

Hi,

This issue happen on version 5.6.13, but if you're running the same code on version 5.5.32 it work like a charm without any errors.

You can check and test it here: http://sqlfiddle.com/#!2/91db7/1

We've downgraded to 5.5.32 and the trigger is running fine without any issues.

Hope this will help for future reference.

Steve

Navigate: Previous Message• Next Message

Options: Reply• Quote

Subject

Views

Written By

Posted

(UPDATED with Schema) Triggers before update error (Error Code: 1054. Unknown column 'workflow_id' in 'NEW')

3974

Steve Landry

January 23, 2014 11:24AM

Re: (UPDATED with Schema) Triggers before update error (Error Code: 1054. Unknown column 'workflow_id' in 'NEW')

1270

Peter Brawley

January 27, 2014 10:50PM

Re: (UPDATED with Schema) Triggers before update error (Error Code: 1054. Unknown column 'workflow_id' in 'NEW')

1801

Steve Landry

January 28, 2014 10:02AM

Re: (UPDATED with Schema) Triggers before update error (Error Code: 1054. Unknown column 'workflow_id' in 'NEW')

1382

Peter Brawley

January 28, 2014 02:38PM

Re: (UPDATED with Schema) Triggers before update error (Error Code: 1054. Unknown column 'workflow_id' in 'NEW')

1228

Steve Landry

January 28, 2014 12:25PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.