duanrou5680 2015-09-26 19:08
浏览 47
已采纳

codeigniter 3.0.1中的数据库错误

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` = '0bc6ecedf769fe4ccd8199bd7bc76c15369c7419'' at line 2

SELECT `data` WHERE `id` = '0bc6ecedf769fe4ccd8199bd7bc76c15369c7419'

Filename: libraries/Session/drivers/Session_database_driver.php

Line Number: 160

i've no idea how this error is coming, all i did was copied my models, controllers, helpers and views from CI 2.2 to CI 3.0.1

my session config looks like this

$config['sess_driver'] = 'database';
$config['sess_cookie_name'] = 'ci_sessions';
$config['sess_expiration'] = 7200;
$config['sess_save_path'] = NULL;
$config['sess_match_ip'] = FALSE;
$config['sess_time_to_update'] = 300;
$config['sess_regenerate_destroy'] = FALSE;

and these are my database settings

$db['default'] = array(
    'dsn'   => '',
    'hostname' => 'host',
    'username' => 'admin',
    'password' => 'password',
    'database' => 'db_name',
    'dbdriver' => 'mysqli',
    'dbprefix' => '',
    'pconnect' => FALSE,
    'db_debug' => (ENVIRONMENT !== 'production'),
    'cache_on' => FALSE,
    'cachedir' => '',
    'char_set' => 'utf8',
    'dbcollat' => 'utf8_general_ci',
    'swap_pre' => '',
    'encrypt' => FALSE,
    'compress' => FALSE,
    'stricton' => FALSE,
    'failover' => array(),
    'save_queries' => TRUE
);
  • 写回答

1条回答 默认 最新

  • dovt85093 2015-09-26 19:31
    关注

    $config['sess_save_path'] = NULL; was set to null instead of table name

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 做个有关计算的小程序
  • ¥15 MPI读取tif文件无法正常给各进程分配路径
  • ¥15 如何用MATLAB实现以下三个公式(有相互嵌套)
  • ¥30 关于#算法#的问题:运用EViews第九版本进行一系列计量经济学的时间数列数据回归分析预测问题 求各位帮我解答一下
  • ¥15 setInterval 页面闪烁,怎么解决
  • ¥15 如何让企业微信机器人实现消息汇总整合
  • ¥50 关于#ui#的问题:做yolov8的ui界面出现的问题
  • ¥15 如何用Python爬取各高校教师公开的教育和工作经历
  • ¥15 TLE9879QXA40 电机驱动
  • ¥20 对于工程问题的非线性数学模型进行线性化