将Codeigniter升级到版本3.0后,我在尝试调用任何控制器后收到错误DB:
Error Number: 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE `id` = 'd1d384b0ceed0bd72fa210337acc666aab1a04e5'' at line 2
SELECT `data` WHERE `id` = 'd1d384b0ceed0bd72fa210337acc666aab1a04e5'
Filename: libraries/Session/drivers/Session_database_driver.php
当我重新加载页面时,我再次使用另一个生成的哈希会话获得它。如何解决?
在config.php
我设置了会话存储:$config['sess_driver'] = 'database';
我查看了错误所在的文件(第 138 行):
public function read($session_id)
{
if ($this->_get_lock($session_id) !== FALSE)
{
// Needed by write() to detect session_regenerate_id() calls
$this->_session_id = $session_id;
$this->_db
->select('data')
->from($this->_config['save_path'])
->where('id', $session_id);
if ($this->_config['match_ip'])
{
$this->_db->where('ip_address', $_SERVER['REMOTE_ADDR']);
}
if (($result = $this->_db->get()->row()) === NULL) // Line 138
{
$this->_fingerprint = md5('');
return '';
}
$this->_fingerprint = md5(rtrim($result->data));
$this->_row_exists = TRUE;
return $result->data;
}
$this->_fingerprint = md5('');
return '';
}
我遇到了同样的问题,花了一段时间才找到解决方案。从表面上看,说明告诉您只加载会话驱动程序,一切都很酷,但是如果您向下查看 CodeIgniter 文档的数据库驱动程序部分,您会发现您需要在 config.php 文件中配置 $config['sess_save_path'] 变量。例如:
$config[‘sess_save_path’] = ‘ci_sessions’
http://www.codeigniter.com/userguide3/libraries/sessions.html#initializing-a-session
当然,您还必须在数据库中设置ci_sessions表,但这为我解决了缺少的表名。
使用 codeigniter 3.0 :
在配置文件中:
$config['sess_driver'] = 'database';
$config['sess_save_path'] = 'ci_sessions';
在您的 MySQL 数据库中:
CREATE TABLE IF NOT EXISTS `ci_sessions` (
`id` varchar(40) NOT NULL,
`ip_address` varchar(45) NOT NULL,
`timestamp` int(10) unsigned DEFAULT 0 NOT NULL,
`data` blob NOT NULL,
PRIMARY KEY (id),
KEY `ci_sessions_timestamp` (`timestamp`));
字段的名称与版本 2.0 不同
使用 Codeigniter 版本 3
编辑配置文件并将会话驱动程序设置为"数据库",sess_save_path设置为表名
$config['sess_driver'] = 'database';//enable session with db
$config['sess_cookie_name'] = 'ci_session';
$config['sess_expiration'] = 7200;
$config['sess_save_path'] = 'ci_sessions';//database table name
$config['sess_match_ip'] = FALSE;
$config['sess_time_to_update'] = 300;
$config['sess_regenerate_destroy'] = FALSE;
对于 MySql
CREATE TABLE IF NOT EXISTS `ci_sessions` (
`id` varchar(40) NOT NULL,
`ip_address` varchar(45) NOT NULL,
`timestamp` int(10) unsigned DEFAULT 0 NOT NULL,
`data` blob NOT NULL,
KEY `ci_sessions_timestamp` (`timestamp`)
);
对于PostgreSQL:
CREATE TABLE "ci_sessions" (
"id" varchar(40) NOT NULL,
"ip_address" varchar(45) NOT NULL,
"timestamp" bigint DEFAULT 0 NOT NULL,
"data" text DEFAULT '' NOT NULL
);
CREATE INDEX "ci_sessions_timestamp" ON "ci_sessions" ("timestamp");
会话数据库驱动程序的官方代码点火器文档
我使用 CI 3 并更改:
$config['sess_save_path'] = 'ci_sessions';
作品.. =)
从TABLE_NAME中选择"数据",其中"id"='d1d384b0ceed0bd72fa210337acc666aab1a04e5'
您缺少表名以及代码包含特殊字符。