sql - mysql crashes when alter table -

-

i using mysql version 6.1.4 , windows 7

i have empty table want drop column , foreign key. when try apply changes workbench crashes , when try stop mysql returns error

error 2013: lost connection mysql server during query sql statement: alter table `teste_db`.`search_products`  drop foreign key `product_id_id_refs_id_aa2f4dab`     error: error when running failback script. details follow.  error 2006: mysql server has gone away

i have looked around lot , not find clue...

thanks in advance help!

please follow steps , if dont

  1. if myisam table repair first , check table .
  2. where empty table , check if index present delete that,

try , if still not work

please paste table structure , table engine name.


Comments

Post a Comment

Popular posts from this blog

c++ - How to add Crypto++ library to Qt project -

-
Image
i downloaded crypto++ source , compiled cryptlib project in visual studio 2013, , added generated .lib file qt project, made .pro file this: qt += core gui qt += sql greaterthan(qt_major_version, 4):qt += widgets target = untitled template = app sources += main.cpp\ mainwindow.cpp headers += mainwindow.h \ databasecontrol.h \ test.h forms += mainwindow.ui win32:config(release, debug|release): libs += -l$$pwd/ -lcryptlib else:win32:config(debug, debug|release): libs += -l$$pwd/ -lcryptlibd else:unix: libs += -l$$pwd/ -lcryptlib includepath += $$pwd/ dependpath += $$pwd/ win32-g++:config(release, debug|release): pre_targetdeps += $$pwd/libcryptlib.a else:win32-g++:config(debug, debug|release): pre_targetdeps += $$pwd/libcryptlibd.a else:win32:!win32-g++:config(release, debug|release): pre_targetdeps += $$pwd/cryptlib.lib else:win32:!win32-g++:config(debug, debug|release): pre_targetdeps += $$pwd/cryptlibd.lib else:unix: pre_targetdeps += $$pw...
Read more

jQuery Mobile app not scrolling in Firefox -

-
i have mobile app built in jquery mobile. scrolling fine in chrome & safari, fails scroll in firefox on desktop. have other instances of same app, different features, , works across browsers. life of me, cannot figure this, please help! located here: http://re-brand.us/dsus/index.html seems bug in firefox: bug log . able scroll using keyboard not trackpad on mac. are using mac? i'll keep looking see if can find way around it.
Read more

python - RuntimeError: Optimal parameters not found: Number of calls to function has reached maxfev = 800 -

-
i have image pick randow row in , try fit gaussian curve in row. using scipy.optimize curve_fit method fitting gaussian. picking of randow rows according array vector [10, 20, 40, 60, 100], meaning in first try pick 10 randow rows (hence, 10 gaussian fits) in image, then, more rows selected , on. most of time, code working, however, error (especially, when number of rows large: around 60 or more), says optimal parameters not found . i have found similar posts in stackoverflow still can not able solve problem. seems problem appears quite curve_fit method . laser beam, chance? ;-) anyway, problem rows selected "hard" fit gaussian curve scipy's curve_fit function. first suggestion debug (using e.g. python's logging module) see if error pops on specific rows. my second suggestion change initial guess curve_fit. rows curve-fitting possible, should able extract few parameters. on other rows, mean of gaussian @ approximately same position , aplitud...
Read more