php - 仅在服务器上的完整性约束违规错误
问题描述
我有Integrity constraint violation: 1452 Cannot add or update a child row:
错误;
我认为这与foreign constraint
.
但是我的 SQL 看起来是正确的。
此外,它只发生在服务器上而不是本地服务器上。
- 本地主机
mysql Ver 8.0.12 for osx10.13 on x86_64 (Homebrew)
- 服务器
mysql Ver 14.14 Distrib 5.7.24, for Linux (x86_64) using EditLine wrapper
我的错误信息如下所示。
An exception occurred while executing 'INSERT INTO AcStatus (friendsStr, followersStr, oneFriendsStr, oneFollowersStr, friendsNum, followersNum, oneFriendsNum, oneFollower
sNum, createdAt, updatedAt, enabled, ac_st) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params ["2828207060,944898932982685696,1306248181,1028832299054325762,1030018
242280972288,1030020969190969344,1054737499443118082,1328082421,995233455683260417,1041877822199934976,1065186035569647616,985898196655259648,830752034085183488,9724266408
59934720,1082994874062786560,978215033778814977,915330694468984832,1018880555381751815,906489953814581249,1028032641310711808,1025004564422901761,1045576483840786432,10027
65007971602432,1089531262568562688,903352143146393600,1047803936457932801,224570452,138706740,995223326250254336,731377603676774400,970899520220311553,2292932660,317830558
9,38836238,803424126257885184,1009439059318431745,1056577591996440579", "830752034085183488,978215033778814977,1005728442657144832,1009439059318431745,44785665,10811191070
16085505,1056577591996440579", "2828207060,944898932982685696,1306248181,1028832299054325762,1030018242280972288,1030020969190969344,1054737499443118082,1328082421,9952334
55683260417,1041877822199934976,1065186035569647616,985898196655259648,972426640859934720,1082994874062786560,915330694468984832,1018880555381751815,906489953814581249,102
8032641310711808,1025004564422901761,1045576483840786432,1002765007971602432,1089531262568562688,903352143146393600,1047803936457932801,224570452,138706740,995223326250254
336,731377603676774400,970899520220311553,2292932660,3178305589,38836238,803424126257885184", "1005728442657144832,44785665,1081119107016085505", 37, 7, 33, 3, "2019-01-28
02:54:48", "2019-01-28 02:54:48", 1, 6]:
SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`twitmax`.`AcStatus`, CONSTRAINT `FK_F7258AEB7F7907
90` FOREIGN KEY (`ac_st`) REFERENCES `twitteraccount` (`id`) ON DELETE CASCADE)
这些是我的课。
class AcStatus
{
/**
* @var integer
*
* @ORM\Column(name="id", type="integer")
* @ORM\Id
* @ORM\GeneratedValue(strategy="AUTO")
*/
private $id;
/**
* @ORM\ManyToOne(targetEntity="Acme\UserBundle\Entity\TwitterAccount", inversedBy="stIds")
* @ORM\JoinColumn(name="ac_st",referencedColumnName = "id",onDelete="CASCADE")
*/
private $acId;
class TwitterAccount
{
/**
* @var integer
*
* @ORM\Column(name="id", type="integer")
* @ORM\Id
* @ORM\GeneratedValue(strategy="AUTO")
*/
private $id;
/**
*
* @ORM\OneToMany(targetEntity="Acme\UserBundle\Entity\AcStatus",mappedBy="acId")
*
*/
private $stIds;
解决方案
AcStatus
FK_F7258AEB7F7907
列具有导致违规的外键约束。
您需要检查相关表的值。它很可能没有在 Foreign Table 上插入相关数据。
您可以使用检查错误详细信息SHOW ENGINE INNODB STATUS
推荐阅读
- php - Magento 事件未在整页缓存上触发
- c# - C# SQL - 更新与父表具有相同值的子表
- selenium - Selenium html按钮未单击
- javascript - 使用 webpack-dev-server 客户端和 hapi API 设置 cookie
- java - 为初学者处理用户输入时的异常处理
- c# - Winform x 坐标略有偏移
- xml - XSLT 如何在匹配目标时访问属性的值
- regex - 正则表达式捕获两个单词之间,然后在该结果中
- javascript - 鼠标悬停时不隐藏对象
- javascript - 从子页面调用模型更改时视图不刷新(Ionic 和 Angular)