警告：PDOStatement :: execute（）[pdostatement.execute]：SQLSTATE [23000]：[重复]

This question already has an answer here:

Error 1062 - Duplicate entry '127' for key 'PRIMARY' - can't find the reason 3 answers

Can anyone help with this please?

Warning: PDOStatement::execute() [pdostatement.execute]: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '127' for key 1 in /usr/www/users/firstiw/competitions/facebook/64ongordon/competition.php on line 33

</div>

写回答
好问题 0 提建议
追加酬金
关注问题
分享
邀请回答
编辑收藏删除结题
收藏举报

1条回答默认最新

关注

码龄粉丝数原力等级 --

被采纳

被点赞

采纳率
duanrebo3559 2011-04-18 19:33
关注
You already have a record that has id=127 or some of your relationships are messed up. But i am shooting in the dark right now. You would have to provide more information about this. What exactly are you trying to do?

解决无用
评论打赏
分享
举报

评论

按下Enter换行，Ctrl+Enter发表内容

报告相同问题？

关注问题

警告：PDOStatement :: execute（）：SQLSTATE [42000]：语法错误或访问冲突：1064 mysql php
2015-07-29 14:25

回答 1 已采纳 MySQL doesn't support FROM clause in Update Statement. Unlike SQL Server, your join statement need
PDOStatement :: execute（）：SQLSTATE [HY093]错误[关闭] php
2016-03-29 17:21

回答 1 已采纳 INSERT INTO transaction SET date = ?, name = ?, cac = ?, caa = ?, cc = ?, dac = ?, daa = ?, dc = ?
警告：PDOStatement :: bindValue（）：SQLSTATE [HY093]：参数号无效：列/参数从1开始 mysql php
2015-01-24 10:40

回答 2 已采纳 $i = 0 And Warning: PDOStatement::bindValue(): SQLSTATE[HY093]: Invalid parameter number: C
mysql pdo execute_mysql中PDO参数化引号引起的Warning: PDOStatement::execute(): SQLSTATE[HY093]:报错...
2021-01-19 07:12

weixin_29722785的博客出现了Warning: PDOStatement::execute(): SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens报错然后改成：INSERT INTO tablename SET a = :a,b = :b,c =...
SQL LIMIT：PDOStatement :: execute（）：SQLSTATE [HY093]：参数号无效：绑定变量数与令牌数不匹配 php
2015-12-29 21:27

回答 1 已采纳 When you want to fill in parameters of a PDO query, you either Use bindParam() or bindValue() to
PHP：获得2个警告和6个通知[关闭] json mysql php
2016-03-01 19:39

回答 3 已采纳 Basically your file_get_contents("php://input") doesnt return a file object, so rest is failing (a
未捕获的异常PDOException：完整性约束违规错误 php sql
2019-04-12 18:35

回答 1 已采纳 A foreign key constraint requires a record in the foreign table for INSERT. A record cannot be de
php pdo execute,PHP-PDOStatement :: execute()：SQLSTATE [HY093]：无效...
2021-03-24 11:39

合光聚乐的博客您只需要将一个数组传递给execute方法.因此,您更新的代码如下所示：$sql = 'INSERT INTO `' . $table_name . '` '. '(`day`, `campaign_name`, `campaign_id`, `views`, `CPM`, `cost`, `currency`, `cost_EUR`) ...
PHP：PDO MySQL错误 mysql php
2015-09-02 13:38

回答 4 已采纳 You are misusing the prepare() function. When using prepared statements, you are supposed to use
异常'PDOException'，消息'SQLSTATE [HY093]：参数号无效 mysql php sql
2016-09-18 10:29

回答 1 已采纳 See this statement here, $this->bind(':unix_sign_up_time', time()); And compare the above st
PDO：MySQL服务器已经消失，无法捕获异常 mysql php
2018-10-07 02:46

回答 1 已采纳 As determined in the comments, you're running this code within another namespace. This means that
mysql hy093_Warning: PDOStatement::bindValue(): SQLSTATE[HY093]: Invalid parameter number: Columns/P...
2021-02-07 08:31

成政睿的博客 and the result is : Warning: PDOStatement::bindValue(): SQLSTATE[HY093]: Invalid parameter number: Columns/Parameters are 1-based Warning: PDOStatement::execute(): SQLSTATE[HY093]: Invalid parameter ...
General error: 1364 Field doesn't have a default v php
2015-12-26 07:02

回答 1 已采纳问题标签： hibernate、@ManyToMany 、主键抛出异常： ERROR: Field ‘scId’ doesn’t have a default value 问题描述：有
php mysql pdo出错_php – PDO错误：SQLSTATE [HY000]：常规错误：2031
2021-01-28 11:56

Actor.又戈叔的博客 } $sth->execute($criteria); 查询包含占位符(：占位符).但是要添加这些LIMIT占位符,我需要使用手动方法(bindValue),否则引擎会将它们变成字符串. 我没有得到无效数量的参数错误,所以所有占位符已被正确绑定(我假设...
php pdo errorinfo,PHP PDOStatement::errorInfo讲解
2021-04-16 14:28

weixin_39952937的博客 PDOStatement::errorInfoPDOStatement::errorInfo — 获取跟上一次语句句柄操作相关的扩展错误信息(PHP 5 >= 5.1.0, PECL pdo >= 0.1.0)说明语法array PDOStatement::errorInfo ( void )PDOStatement::error...
php column not found,Uncaught PDOException: SQLSTATE[42S22]: Column not found in PHP code
2021-05-06 03:10

晨雨竹的博客 I get this message:Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'Password' in 'field list' in C:\xampp\htdocs\eCommerce\admin\index.php:26 Stack trace: #0...
mysql sqlcode 2014_SQLSTATE[HY000]: General error: 2014 Cannot execute queries while other unbuffere...
2021-03-13 20:43

山和蓝枝的博客服务器操作系统：LINUX服务器环境：nginx1.4.7php版本：php5.6.9mysql版本：mysql5.5.34-log开源框架：tpshop报错详情：SQLSTATE[HY000]: General error: 2014 Cannot execute queries while other unbuffered ...
Illuminate\Database\QueryException : SQLSTATE[42000]: Syntax error or access violation: 1071 Speciif
2023-02-28 13:20

myydan的博客 max key length is 1000 bytes") 2 E:\phpstudy_pro\WWW\shopapi\vendor\laravel\framework\src\Illuminate\Database\Connection.php:501 PDOStatement::execute() 这是由于Laravel 默认使用 utf8mb4 字符，包括...
ThinkPHP SQLSTATE[HY000]: General error: 2014 Cannot execute queries while other unbuffered queries
2017-04-08 09:17

狂野小青年的博客 SQLSTATE[HY000]: General error: 2014 Cannot execute queries while other unbuffered queries are active. Consider using PDOStatement::fetchAll(). Alternatively, if your code is only ever going to run ag
mysql pdo bindvalue_PDOStatement::bindValue
2021-02-01 17:59

Osh的博客 }// output: PHP Warning: PDOStatement::execute(): SQLSTATE[HY093]: Invalid parameter number: parameter was not defined?> [#2] Vladimir Kovpak [2015-02-19 06:11:06] $sql = 'SELECT * ...
没有解决我的问题, 去提问

悬赏问题

¥17 pro*C预编译“闪回查询”报错SCN不能识别
¥15 微信会员卡接入微信支付商户号收款
¥15 如何获取烟草零售终端数据
¥15 数学建模招标中位数问题
¥15 phython路径名过长报错不知道什么问题
¥15 深度学习中模型转换该怎么实现
¥15 HLs设计手写数字识别程序编译通不过
¥15 Stata外部命令安装问题求帮助！
¥15 从键盘随机输入A-H中的一串字符串，用七段数码管方法进行绘制。提交代码及运行截图。
¥15 TYPCE母转母，插入认方向

警告：PDOStatement :: execute（）[pdostatement.execute]：SQLSTATE [23000]：[重复]

1条回答 默认 最新

悬赏问题

1条回答默认最新