Bug 1899

Summary: 小区管理:导入门口机信息,只加了楼号单元SN门口机别名,出错。
Product: [云服务软件] 核心模块 Reporter: 杨玲 <yangling>
Component: 核心模块Assignee: 杜二红 <duerhong>
Status: VERIFIED FIXED QA Contact:
Severity: critical    
Priority: ---    
Version: 未指定   
Target Milestone: ---   
Hardware: BG   
OS: Windows   
Whiteboard:

Description 杨玲 2017-06-29 16:49:08 CST
:(
SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'roomnumber' cannot be null
错误位置

FILE: /var/www/html/huijiatong/ThinkPHP/Library/Think/Db/Driver.class.php  LINE: 217
TRACE

#0 /var/www/html/huijiatong/ThinkPHP/Library/Think/Db/Driver.class.php(217): PDOStatement->execute()
#1 /var/www/html/huijiatong/ThinkPHP/Library/Think/Db/Driver.class.php(813): Think\Db\Driver->execute('INSERT INTO `xq...', false)
#2 /var/www/html/huijiatong/ThinkPHP/Library/Think/Model.class.php(320): Think\Db\Driver->insert(Array, Array, false)
#3 /var/www/html/huijiatong/Application/Core/Controller/VillageController.class.php(184): Think\Model->add(Array)
#4 [internal function]: Core\Controller\VillageController->device_import()
#5 /var/www/html/huijiatong/ThinkPHP/Library/Think/App.class.php(164): ReflectionMethod->invoke(Object(Core\Controller\VillageController))
#6 /var/www/html/huijiatong/ThinkPHP/Library/Think/App.class.php(202): Think\App::exec()
#7 /var/www/html/huijiatong/ThinkPHP/Library/Think/Think.class.php(120): Think\App::run()
#8 /var/www/html/huijiatong/ThinkPHP/ThinkPHP.php(97): Think\Think::start()
#9 /var/www/html/huijiatong/index.php(19): require('/var/www/html/h...')
#10 {main}

ThinkPHP3.2.3 { Fast & Simple OOP PHP Framework } -- [ WE CAN DO IT JUST THINK ]
Comment 1 杜二红 2017-07-05 17:13:46 CST
已经将不填写的 楼 单元,房间默认设置为 00 00 0000
Comment 2 杨玲 2017-07-06 16:18:46 CST
已验证