mysql - Possible bug with Workbench model synchronization/Forward Engineer? -


i have updated databases model file many times, now, when attempt forward engineer model existing database, or synchronize database, seems tables have triggers associated them (a new thing us) not updated. forward engineering nothing these tables, , in synchronization, there no arrow indicating change detected (there added fields). has else run this? i've wracked net trying find answer. have workaround, it's lot of of work.

an example here: table tbl_wbselements has added fields, workbench isn't spotting them. seems happen tables have triggers; tables without triggers, sps, views, new tables seem foreng , synchronize fine.

this has been solved; pure coincidence several tables triggers affected. problem table designer had added several foreign-key fields tables , left default value of "not nullable" set; so, when workbench tried insert field, found there existing records in foreign table, , couldn't leave field null, skipped new field.

i'd see workbench give sort of warning when happens, took 2 days of investigation sort out (and discovered accident). i'm sure others have been caught type of thing well.


Comments

Post a Comment

Popular posts from this blog

aws api gateway - SerializationException in posting new Records via Dynamodb Proxy Service in API -

i getting "__type": "com.amazon.coral.service#serializationexception" as reply in postman & in test console in api gateway trying post record directly dynamodb using api proxy services.. referring aws article - https://aws.amazon.com/blogs/compute/using-amazon-api-gateway-as-a-proxy-for-dynamodb/ here's mapping { "tablename": "tablenamegoeshere", "item": { "id" : "$context.requestid" "eventname" : "$input.path('$.eventname')", "timestamp" : $input.path('$.timestamp'), "answers": "$util.parsejson($input.path('$.answers'))" } } update: did asked ... , worked if try add array of json objects gives me above same error - here's trying now. please - couldnt find on google well #set($inputroot = $input.path('$')) { "tablename": "answer", "item": {
Read more

asp.net - Problems sending emails from forum -

i have been redesigning site has message board, has been written guy looked after site. it has few problems , written in .asp , uses .mdb files database. you can see whole thing here . feel free post if helps, test thing have set using original files , new database. the basic problem when posts message, supposed email sent them, have posted it. when replies, originator supposed message, replier has been posted. i’d have thought @ point in process there should script/file in postmessage.asp? the postmessage.asp page below. <% option explicit %> <!-- #include virtual="common/adovbs.inc" --> <html> <head> <meta http-equiv="content-type" content="text/html; charset=windows-1252"> <meta name="generator" content="microsoft frontpage 4.0"> <meta name="progid" content="frontpage.editor.document"> <title>new page 2</title> <base target="_self"
Read more