MySQL Trigger not Visisble

I am using MySQL workbench 6.0 and have created a trigger but when i go to teh alter table command it is not visible.

All the other triggers are visible, any reason why this is not.

Need to change the statement, any way I can script it or make it visible for editing.
BrogrimInformation Systems Development ManagerAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

jrm213jrm213Commented:
Is the trigger actually working?

Is it possible it didn't save?

I have accidentally copied triggers from one table to another and only changed the Trigger table name, and forgot to change it in the Trigger Event table name, so when you save it, it gets put on the other table... Appears to be missing, but it is just under the wrong table.
0
BrogrimInformation Systems Development ManagerAuthor Commented:
I have checked the trigger table event name, I dropped the trigger and created it again and it still does'nt display.

It is firing on that table so very confusing. I have used SHOW TRIGGERS and it is returned in the trigger list with all the other triggers that are been displayed correctly.
0
jrm213jrm213Commented:
Are you creating the trigger with a script or through the table editor.  There was a bug in a previous version that was fixed that is pretty much this exact issue if you are creating the trigger outside of workbench.

it's possible that it is just a bug again in the new version of workbench. Out of curiosity do you have an older version of workbench on another machine you could use to see if the trigger appears in that. If it does, I would report it as a bug on bugs.mysql.com
0
BrogrimInformation Systems Development ManagerAuthor Commented:
I have MySQL Worbench CE 5.02 installed on the server and the latest workbench 6.0 on my desktop.

Worbench CE 5.02 is displaying the trigger but still no sign of it on my desktop workbench 6.0
0
jrm213jrm213Commented:
I would report it as a bug and let them resolve it. If it displays in 5.02 and not in 6.0 then it sounds like a software issue.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
MySQL Server

From novice to tech pro — start learning today.