mysql 1615_php – Laravel：一般错误：1615准备好的声明需要重新准备

最新推荐文章于 2024-01-18 10:49:18 发布

尔德童

最新推荐文章于 2024-01-18 10:49:18 发布

阅读量479

点赞数

文章标签： mysql 1615

本文链接：https://blog.csdn.net/weixin_32246721/article/details/113419205

版权

我在宅基地虚拟机(流浪汉)中使用最新版本的laravel(5.1).

我将我的项目连接到本地mariaDB服务器,其中我有一些表和2个db-view.

由于我只在db-view表上做了一些select,所以我随机收到了这个错误：

General error: 1615 Prepared statement needs to be re-prepared

从今天开始,我只在db视图上选择时才会出现此错误.

如果我打开我的phpMyAdmin并进行相同的选择它会返回正确的结果.

我试图打开php artisan tinker并选择db-view的一条记录,但它返回相同的错误：

// Select one user from user table

>>> $user = new App\User

=> {}

>>> $user = App\User::find(1);

=> {

id: 1,

name: "Luca",

email: "luca@email.it",

customerId: 1,

created_at: "2015-08-06 04:17:57",

updated_at: "2015-08-11 12:39:01"

}

>>>

// Select one source from Source db-view

>>> $source = new App\Source

=> {}

>>> $source = App\Source::find(1);

Illuminate\Database\QueryException with message 'SQLSTATE[HY000]: General error: 1615 Prepared statement needs to be re-prepared (SQL: select * from `sources` where `sources`.`id` = 1 limit 1)'

我该如何解决这个问题？

我读到了mysqldump的一个问题(但不是我的情况)并且增加了table_definition_cache的值,但它不确定它是否可行,我无法修改它们.

这是一种laravel bug吗？

我怎么能弄明白呢？

编辑：

如我所知,我添加了我的模型源代码.

Source.php：

namespace App;

use Illuminate\Database\Eloquent\Model;

class Source extends Model

{

protected $table = 'sources';

|--------------------------------------------------------------------------

| FOREIGN KEYS

|--------------------------------------------------------------------------

/**

* @return [type] [description]

public function customersList(){

return $this->hasMany("App\CustomerSource", "sourceId", "id");

}

/**

* @return [type] [description]

public function issues(){

return $this->hasMany("App\Issue", "sourceId", "id");

}

编辑2：

如果我使用mysqli在项目中执行相同的查询,它可以工作：

$db = new mysqli(getenv('DB_HOST'), getenv('DB_USERNAME'), getenv('DB_PASSWORD'), getenv('DB_DATABASE'));

if($db->connect_errno > 0){

dd('Unable to connect to database [' . $db->connect_error . ']');

}

$sql = "SELECT * FROM `sources` WHERE `id` = 4";

if(!$result = $db->query($sql)){

dd('There was an error running the query [' . $db->error . ']');

}

dd($result->fetch_assoc());

编辑3：

Afeter 2个月,我还在那里.相同的错误,没有找到解决方案

我决定尝试一下aritsan tinker的小解决方案,但没有好消息.

我报告了我尝试过的内容：

首先尝试获取表模型：

>>> $user = \App\User::find(1);

=> App\User {#697

id: 1,

name: "Luca",

email: "luca.d@company.it",

customerId: 1,

created_at: "2015-08-06 04:17:57",

updated_at: "2015-10-27 11:28:14",

}

现在尝试获取视图表模型：

>>> $ir = \App\ContentRepository::find(15);

Illuminate\Database\QueryException with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'dbname.content_repositories' doesn't exist (SQL: select * from `content_repositories` where `content_repositories`.`id` = 1 limit 1)'

当contentRepository在模型ContentRepository.php中没有正确的表名设置时：

>>> $pdo = DB::connection()->getPdo();

=> PDO {#690

inTransaction: false,

errorInfo: [

"00000",

1146,

"Table 'dbname.content_repositories' doesn't exist",

attributes: [

"CASE" => NATURAL,

"ERRMODE" => EXCEPTION,

"AUTOCOMMIT" => 1,

"PERSISTENT" => false,

"DRIVER_NAME" => "mysql",

"SERVER_INFO" => "Uptime: 2513397 Threads: 12 Questions: 85115742 Slow queries: 6893568 Opens: 1596 Flush tables: 1 Open tables: 936 Queries per second avg: 33.864",

"ORACLE_NULLS" => NATURAL,

"CLIENT_VERSION" => "mysqlnd 5.0.11-dev - 20120503 - $Id: id_here $",

"SERVER_VERSION" => "5.5.5-10.0.17-MariaDB-1~wheezy-wsrep-log",

"STATEMENT_CLASS" => [

"PDOStatement",

"EMULATE_PREPARES" => 0,

"CONNECTION_STATUS" => "localiphere via TCP/IP",

"DEFAULT_FETCH_MODE" => BOTH,

}

>>>

更改表值内部模型ContentRepository.php：

>>> $ir = \App\ContentRepository::find(15);

Illuminate\Database\QueryException with message 'SQLSTATE[HY000]: General error: 1615 Prepared statement needs to be re-prepared (SQL: select * from `contentRepository` where `contentRepository`.`id` = 15 limit 1)'

如果正确,请注意缺少的“errorInfo”：