Creating mysql trigger
Asked Modified Viewed 735 times
douwe_yntema
douwe_yntema 33
- Senior Member, joined since
- Contributed 667 posts on the community forums.
- Started 57 threads in the forums
- Started this discussions
- Answered 1 question
I am trying to create a mysql trigger on my database with php.
I am getting error:
sqlstate[42000]: syntax error or access violation: 1064
I tried al possible escaping etc. But nothing works.
I get the feeling it is a bug in the pdo driver.
Manual entering via phpmyadmin works well.
It is for V9.03.50
EDIT:
Already solved. It was not possible to have 2 triggers of the same kind on the same table
I am getting error:
sqlstate[42000]: syntax error or access violation: 1064
I tried al possible escaping etc. But nothing works.
I get the feeling it is a bug in the pdo driver.
Manual entering via phpmyadmin works well.
It is for V9.03.50
EDIT:
Already solved. It was not possible to have 2 triggers of the same kind on the same table
Edited by douwe_yntema on 13-04-2020 12:13,
There are no post found.
Category Forum
Suspected Bugs and Errors - 9Labels
None yet
Statistics
- Views 0 views
- Posts 0 posts
- Votes 0 votes
- Topic users 1 member
1 participant
douwe_yntema 33
- Senior Member, joined since
- Contributed 667 posts on the community forums.
- Started 57 threads in the forums
- Started this discussions
- Answered 1 question
Notifications
Track thread
You are not receiving notifications from this thread.
Related Questions