学习资料 - 常熟市虞山镇爱学堂教育培训中心（星燚艺术）

Warning (512): SQL Error: 1054: Unknown column '错误字符53f6f7e3' in 'where clause' [CORE/cake/libs/model/datasources/dbo_source.php, line 549]

Code | Context

            $out = null;
            if ($error) {
                trigger_error("<span style = \"color:Red;text-align:left\"><b>SQL Error:</b> {$this->error}</span>", E_USER_WARNING);

$sql	=	"select fid,count(fid) c from file_tags  as FileTag where tid in ('0',错误字符53f6f7e3-77f8-4cda-ae9b-5ea4cbdd56cb错误字符,错误字符53f59c38-3df8-4c36-9cad-5ea4cbdd56cb错误字符,错误字符53f59c39-f038-456e-bf80-5ea4cbdd56cb错误字符) group by fid having count(fid)=3"
$error	=	"1054: Unknown column '错误字符53f6f7e3' in 'where clause'"
$out	=	null

DboSource::showQuery() - CORE/cake/libs/model/datasources/dbo_source.php, line 549
DboSource::execute() - CORE/cake/libs/model/datasources/dbo_source.php, line 216
DboSource::fetchAll() - CORE/cake/libs/model/datasources/dbo_source.php, line 354
DboSource::query() - CORE/cake/libs/model/datasources/dbo_source.php, line 236
Model::query() - CORE/cake/libs/model/model.php, line 2405
InfosController::filetype() - APP/controllers/infos_controller.php, line 1104
Object::dispatchMethod() - CORE/cake/libs/object.php, line 123
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 240
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 206
[main] - APP/webroot/index.php, line 83

Query: select fid,count(fid) c from file_tags as FileTag where tid in ('0',错误字符53f6f7e3-77f8-4cda-ae9b-5ea4cbdd56cb错误字符,错误字符53f59c38-3df8-4c36-9cad-5ea4cbdd56cb错误字符,错误字符53f59c39-f038-456e-bf80-5ea4cbdd56cb错误字符) group by fid having count(fid)=3

Warning (2): Invalid argument supplied for foreach() [APP/controllers/infos_controller.php, line 1105]

Code | Context

            $objcountid=count($objtid);

            $objfts=$this->FileTag->query("select fid,count(fid) c from file_tags  as FileTag where tid in ('0'".$tid.") group by fid having count(fid)=".($objcountid-1));

            foreach ($objfts as $objft){

$pagesize	=	10
$paging	=	array(
	"show" => 10,
	"url" => "/infos/filetype/"
)
$urlcount	=	0
$where	=	"Attachment.is_top = '1'"
$tagstr	=	""
$w	=	"'0'"
$tid	=	",错误字符53f6f7e3-77f8-4cda-ae9b-5ea4cbdd56cb错误字符,错误字符53f59c38-3df8-4c36-9cad-5ea4cbdd56cb错误字符,错误字符53f59c39-f038-456e-bf80-5ea4cbdd56cb错误字符"
$str	=	StrHelper
StrHelper::$helpers = NULL
StrHelper::$base = NULL
StrHelper::$webroot = NULL
StrHelper::$themeWeb = NULL
StrHelper::$here = NULL
StrHelper::$params = array
StrHelper::$action = NULL
StrHelper::$plugin = NULL
StrHelper::$data = NULL
StrHelper::$namedArgs = NULL
StrHelper::$argSeparator = NULL
StrHelper::$validationErrors = NULL
StrHelper::$tags = array
StrHelper::$__tainted = NULL
StrHelper::$__cleaned = NULL
StrHelper::$_log = NULL
$objtid	=	array(
	"",
	"错误字符53f6f7e3-77f8-4cda-ae9b-5ea4cbdd56cb错误字符",
	"错误字符53f59c38-3df8-4c36-9cad-5ea4cbdd56cb错误字符",
	"错误字符53f59c39-f038-456e-bf80-5ea4cbdd56cb错误字符"
)
$objcountid	=	4
$objfts	=	false

InfosController::filetype() - APP/controllers/infos_controller.php, line 1105
Object::dispatchMethod() - CORE/cake/libs/object.php, line 123
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 240
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 206
[main] - APP/webroot/index.php, line 83

Query: SELECT `Tag`.`title` FROM `tags` AS `Tag` WHERE id in ('0',错误字符53f6f7e3-77f8-4cda-ae9b-5ea4cbdd56cb错误字符,错误字符53f59c38-3df8-4c36-9cad-5ea4cbdd56cb错误字符,错误字符53f59c39-f038-456e-bf80-5ea4cbdd56cb错误字符)

Warning (2): Invalid argument supplied for foreach() [APP/controllers/infos_controller.php, line 1113]

Code | Context

            $this->loadModel("Tag");

            $objtags=$this->Tag->findAll("id in ('0'".$tid.")","title");

            foreach ($objtags as $objtag){

$pagesize	=	10
$paging	=	array(
	"show" => 10,
	"url" => "/infos/filetype/"
)
$urlcount	=	0
$where	=	"Attachment.is_top = '1' and Attachment.id in ('0')"
$tagstr	=	""
$w	=	"'0'"
$tid	=	",错误字符53f6f7e3-77f8-4cda-ae9b-5ea4cbdd56cb错误字符,错误字符53f59c38-3df8-4c36-9cad-5ea4cbdd56cb错误字符,错误字符53f59c39-f038-456e-bf80-5ea4cbdd56cb错误字符"
$str	=	StrHelper
StrHelper::$helpers = NULL
StrHelper::$base = NULL
StrHelper::$webroot = NULL
StrHelper::$themeWeb = NULL
StrHelper::$here = NULL
StrHelper::$params = array
StrHelper::$action = NULL
StrHelper::$plugin = NULL
StrHelper::$data = NULL
StrHelper::$namedArgs = NULL
StrHelper::$argSeparator = NULL
StrHelper::$validationErrors = NULL
StrHelper::$tags = array
StrHelper::$__tainted = NULL
StrHelper::$__cleaned = NULL
StrHelper::$_log = NULL
$objtid	=	array(
	"",
	"错误字符53f6f7e3-77f8-4cda-ae9b-5ea4cbdd56cb错误字符",
	"错误字符53f59c38-3df8-4c36-9cad-5ea4cbdd56cb错误字符",
	"错误字符53f59c39-f038-456e-bf80-5ea4cbdd56cb错误字符"
)
$objcountid	=	4
$objfts	=	false
$objtags	=	false

InfosController::filetype() - APP/controllers/infos_controller.php, line 1113
Object::dispatchMethod() - CORE/cake/libs/object.php, line 123
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 240
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 206
[main] - APP/webroot/index.php, line 83

搜索结果（0）

学习资料

获取更多资料

学生管理系统
Mobile

名称	大小	上传时间	操作

暂无信息

兴趣班（小学、幼儿）、招生简章

(default) 11 queries took 5 ms
Nr	Query	Error	Affected	Num. rows	Took (ms)
1	DESCRIBE `file_tags`		3	3	1
2	select fid,count(fid) c from file_tags as FileTag where tid in ('0',错误字符53f6f7e3-77f8-4cda-ae9b-5ea4cbdd56cb错误字符,错误字符53f59c38-3df8-4c36-9cad-5ea4cbdd56cb错误字符,错误字符53f59c39-f038-456e-bf80-5ea4cbdd56cb错误字符) group by fid having count(fid)=3	1054: Unknown column '错误字符53f6f7e3' in 'where clause'			0
3	DESCRIBE `tags`		6	6	1
4	SELECT `Tag`.`title` FROM `tags` AS `Tag` WHERE id in ('0',错误字符53f6f7e3-77f8-4cda-ae9b-5ea4cbdd56cb错误字符,错误字符53f59c38-3df8-4c36-9cad-5ea4cbdd56cb错误字符,错误字符53f59c39-f038-456e-bf80-5ea4cbdd56cb错误字符)	1054: Unknown column '错误字符53f6f7e3' in 'where clause'			0
5	SELECT COUNT(*) AS `count` FROM `attachments` AS `Attachment` WHERE `Attachment`.`is_top` = '1' and `Attachment`.`id` in ('0')		1	1	0
6	DESCRIBE `seokeywords`		5	5	1
7	SELECT `Seokeyword`.`id`, `Seokeyword`.`keywords`, `Seokeyword`.`description`, `Seokeyword`.`created`, `Seokeyword`.`modified` FROM `seokeywords` AS `Seokeyword` WHERE 1 = 1 LIMIT 1		1	1	0
8	DESCRIBE `keywords`		7	7	1
9	SELECT `Keyword`.`title`, `Keyword`.`url_path` FROM `keywords` AS `Keyword` WHERE `Keyword`.`status`='1' ORDER BY `Keyword`.`is_top` asc		6	6	0
10	DESCRIBE `txtlists`		6	6	1
11	SELECT `Txtlist`.`content` FROM `txtlists` AS `Txtlist` WHERE `Txtlist`.`status`='1' ORDER BY `Txtlist`.`is_top` asc		19	19	0

(default) 11 queries took 5 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `file_tags`

select fid,count(fid) c from file_tags as FileTag where tid in ('0',错误字符53f6f7e3-77f8-4cda-ae9b-5ea4cbdd56cb错误字符,错误字符53f59c38-3df8-4c36-9cad-5ea4cbdd56cb错误字符,错误字符53f59c39-f038-456e-bf80-5ea4cbdd56cb错误字符) group by fid having count(fid)=3

1054: Unknown column '错误字符53f6f7e3' in 'where clause'

DESCRIBE `tags`

SELECT `Tag`.`title` FROM `tags` AS `Tag` WHERE id in ('0',错误字符53f6f7e3-77f8-4cda-ae9b-5ea4cbdd56cb错误字符,错误字符53f59c38-3df8-4c36-9cad-5ea4cbdd56cb错误字符,错误字符53f59c39-f038-456e-bf80-5ea4cbdd56cb错误字符)

1054: Unknown column '错误字符53f6f7e3' in 'where clause'

SELECT COUNT(*) AS `count` FROM `attachments` AS `Attachment` WHERE `Attachment`.`is_top` = '1' and `Attachment`.`id` in ('0')

DESCRIBE `seokeywords`

SELECT `Seokeyword`.`id`, `Seokeyword`.`keywords`, `Seokeyword`.`description`, `Seokeyword`.`created`, `Seokeyword`.`modified` FROM `seokeywords` AS `Seokeyword` WHERE 1 = 1 LIMIT 1

DESCRIBE `keywords`

SELECT `Keyword`.`title`, `Keyword`.`url_path` FROM `keywords` AS `Keyword` WHERE `Keyword`.`status`='1' ORDER BY `Keyword`.`is_top` asc

DESCRIBE `txtlists`

SELECT `Txtlist`.`content` FROM `txtlists` AS `Txtlist` WHERE `Txtlist`.`status`='1' ORDER BY `Txtlist`.`is_top` asc