error on export
| User, date | Message |
|---|---|
|
Written by sergtop
3 years ago Category: General 50 posts since Mon, 23 Nov 09 |
after on of the last updates (since 13.08.2010) export operation threows exception SQL Error (1231): Variable 'foreign_key_checks' can't be set to the value of '1' |
|
Written by ansgar
3 years ago 3977 posts since Fri, 07 Apr 06 |
Sounds like issue #2121 - fixed yesterday, please update your build. |
|
Written by sergtop
3 years ago 50 posts since Mon, 23 Nov 09 |
I have build #3481 |
|
Written by ansgar
3 years ago 3977 posts since Fri, 07 Apr 06 |
r3481 is from today, and you said you have it since 13.08. But I see it too in the latest build, so I just reverted r3478. Will see if there is a better fix for issue #2121. |
|
Written by sergtop
3 years ago 50 posts since Mon, 23 Nov 09 |
reverting helped... this issue doesn`t occur now |
|
Written by ansgar
3 years ago 3977 posts since Fri, 07 Apr 06 |
Yes. Only the reporter of issue #2121 will now get the error again - not sure why and when he gets it, I could not reproduce that. |
|
Written by sergtop
3 years ago 50 posts since Mon, 23 Nov 09 |
maybe this is due to different mysql engines... I have myisam tables |
|
Written by lemon_juice
3 years ago 95 posts since Tue, 29 Jun 10 |
I got the same error yesterday on build #3481 - so I don't know if it's still relevant. It happened when I was exporting 2 innodb tables to an online server. In my case the tables were exported properly, the crash must have happened after that. But these tables were empty so I don't know if inserts would have been executed properly - if there were any. |
|
Please login to leave a reply, or register at first. |