php - Mysql cannot create foreign key error 121 but doesn't exists -

-

i have strange problem, i'm trying create foreign key specific name mysql says: "can't create table #sql-85f_169' (errno: 121)" understand name must unique , is, because there no 1 name.

complete story: have 16 databases in 1 server (ubuntu server14) multiple web pages same structure, same tables, same different database name. add new database new client, make copy of of 16, download 1 , replace name of database , keep same structure. need add new foreign key table "orders", deleted 2 previous foreign keys, name "order_ibfk_1" , "order_ibfk_2" , added 3 more:

alter table `orders`   add constraint `order_ibfk_1` foreign key (`id_reception`) references `recepction` (`id_recepction`),   add constraint `order_ibfk_2` foreign key (`id_type_order`) references `type_order` (`id_type_order`),   add constraint `order_ibfk_3` foreign key (`id_company`) references `company` (`id_company`);

i did on every of 16 databases , worked fine, not in new one, new database 17 show (errno: 121) deleted foreigns keys, table empty, deleted entire table , make new 1 , keep saying same error. checked information_schema.table_constraints , key_column_usage not exist name "order_ibfk_1" in database. in show engine innodb status\g section latest foreign key error says duplicated name.

¿maybe in cache or something?, restarted service , server, happened on production server, on local worked fine. database , others 16 operational , working 24h cannot interrupt work every time.

i'm thinking in deleting database number 17 in first chance, later restore it. error #2013 - lost connection mysql server during query when try run foreign key query, when working phpmyadmin or ssh on database 17, same query on others 16 not make error, use set @@global.max_allowed_packet = 1048576*10; execute query same error 121. ¿any idea? ¿mysql haunted?

here did:

i downloaded database use in local, try run sql , goes fine.

so downloaded database, deleted on server, re-upload , run sql in server , sudenly works perfectly. guess in cache or memory.


Comments

Post a Comment

Popular posts from this blog

How to show in django cms breadcrumbs full path? -

-
need advice - how show in breadcrumbs whole path article or page? i've got code: {% ance in ancestors %} <li> {% if not forloop.last %} <a href="{{ ance.get_absolute_url }}">{{ ance.get_menu_title }}</a> {% else %} <span class="active">{{ ance.get_menu_title }}</span> {% endif %} </li> {% endfor %} but shows "home" , current page. how modify show whole path in breadcrumbs? i've found in file menu_tags.py code calls ancestors. @ least there class showbreadcrumbs: class showbreadcrumb(inclusiontag): """ shows breadcrumb node has same url current request - start level: after level should breadcrumb start? 0=home - template: template used render breadcrumb """ name = 'show_breadcrumb' template = 'menu/dummy.html' options = options( argument('start_level', default=0, require...
Read more

php - Invalid Cofiguration - yii\base\InvalidConfigException - Yii2 -

-
Image
i've installed yii2-user module/dektrium yii2-app-basic application command composer require "dektrium/yii2-user:0.9.*@dev" config/console.php return [ . . 'modules' => [ 'gii' => 'yii\gii\module', 'user' => [ 'class' => 'dektrium\user\module', ], ], . . ] config/web.php 'components' => [ . . /* 'user' => [ 'identityclass' => 'app\models\user', 'enableautologin' => true, ], */ 'modules' => [ 'user' => [ 'class' => 'dektrium\user\module', ], ], . . ] after that, run command $ php yii migrate/up --migrationpath=@vendor/dektrium/yii2-user/migrations updating database schema . but, when run http://localhost/mylawsuit/yii/web/index.php?r=u...
Read more

ruby on rails - npm error: tunneling socket could not be established, cause=connect ETIMEDOUT -

-
i have app uses rails framework , implements angularjs part of front end. i have pushed heroku , have heroku toolbelt installed, when try migrate db using "heroku run rake db:migrate" receive following error(s): installing core plugins heroku-cli-addons, heroku-apps, heroku-fork, heroku-git, heroku-local, heroku-run, heroku-status... error installing package. try running again gode_debug=info see more output. ! `run` not heroku command. ! perhaps meant `-h`, `2fa`, `auth`, `join`, `open`, `orgs`, `pg`, `ps` or `rake`. ! see `heroku help` list of available commands. i run command "gode_debug=info heroku run rake db:migrate" , receive error: npm err! darwin 14.5.0 npm err! argv "/users/christopher_pelnar/.heroku/node-v4.2.1-darwin-x64/bin/node" "/users/christopher_pelnar/.heroku/node-v4.2.1-darwin-x64/lib/node_modules/npm/cli.js" "install" "heroku-cli-addons" "heroku-apps" "heroku-fork...
Read more