禅道筛选出符合条件的数据后导出为GBK-CVS格式,数据总数不对,只有24条
大熊
|
1.在测试模块内筛选出符合条件的BUG,共134条数据 2.导出数据 3.导入为CVS--GBK,选中数据 4.表格内只有24条数据 5.试过只导出55条数据打开也只有24条数据 6.已经尝试过多种浏览器仍一样 |
石洋洋 |
导出 选择 全部数据 不选择 选中记录 ,看看能导出多少条。
|
大熊
|
也只有24条,禅道版本7.2,使用UTF-8---CVS可导出所有数据,但数据为乱码
|
石洋洋 |
zentao(pro/pms)/config/my.php 中debug的值改成true 重新操作一下 看日志文件 zentao(pms/pro)/tmp/log/php开头的今天的文件有什么报错。utf-8 和 gbk肯定只有一个是可以正常显示的,如果都能正常显示也不需要做2个编码选择的。
|
大熊
|
操作: 1.筛选
2.筛选出120条数据 3.选中一百条 4.导出选中记录
日志如下: 20170328 08:53:04: /zentao/www/index.php?m=bug&f=export&productID=25&orderBy=id_desc SELECT * FROM `zt_config` WHERE owner IN ('system','yonghuming') ORDER BY `id` SELECT * FROM `zt_lang` ORDER BY `lang`,`id` SELECT *, IF(INSTR(" closed", status) < 2, 0, 1) AS isClosed FROM `zt_product` WHERE deleted = '0' ORDER BY `isClosed`,`order` desc
20170328 08:53:09: /zentao/www/index.php?m=bug&f=export&productID=25&orderBy=id_desc SELECT * FROM `zt_config` WHERE owner IN ('system','xiongting') ORDER BY `id` SELECT * FROM `zt_lang` ORDER BY `lang`,`id` SELECT *, IF(INSTR(" closed", status) < 2, 0, 1) AS isClosed FROM `zt_product` WHERE deleted = '0' ORDER BY `isClosed`,`order` desc SELECT * FROM `zt_bug` WHERE (( 1 AND `module` IN ('228','230','231','232','233','234','244') ) OR ( 1 AND `module` IN ('229','235','236','237','238','239','243') )) AND `product` = 25 AND deleted = '0' AND id IN ('4754','4753','4752','4748','4747','4745','4744','4743','4742','4740','4739','4717','4716','4714','4710','4704','4703','4701','4688','4687','4686','4684','4682','4667','4662','4660','4658','4657','4655','4652','4649','4633','4632','4631','4630','4629','4628','4627','4626','4625','4624','4622','4621','4620','4619','4618','4616','4615','4614','4613','4612','4611','4610','4609','4608','4607','4606','4600','4599','4598','4597','4596','4595','4594','4593','4592','4590','4589','4588','4587','4586','4585','4584','4583','4581','4580','4578','4577','4576','4575','4574','4573','4572','4571','4570','4569','4568','4567','4566','4565','4564','4563','4562','4560','4559','4558','4557','4555','4554','4553') ORDER BY `id` desc SELECT account, realname FROM `zt_user` ORDER BY `account` SELECT *, IF(INSTR(" closed", status) < 2, 0, 1) AS isClosed FROM `zt_product` WHERE deleted = '0' ORDER BY `isClosed`,`order` desc SELECT *, IF(INSTR(" done", status) < 2, 0, 1) AS isDone FROM `zt_project` WHERE iscat = '0' AND deleted = '0' ORDER BY `isDone`,`status`,`order` desc SELECT id, name FROM `zt_module` WHERE id IN ('238','239','233','243','234','228','231','244','236','229','235','230','237') SELECT id,title FROM `zt_story` WHERE id IN ('0') SELECT id, name FROM `zt_task` WHERE id IN ('0') SELECT id, title FROM `zt_bug` WHERE id IN ('0','4625','4592') SELECT id, title FROM `zt_case` WHERE id IN ('0') SELECT id, name FROM `zt_build` WHERE id IN ('50','63','65','56','62','59','61','51','48','52','47','49','44','45','43','40','trunk','41','42') SELECT id, objectID, pathname, title FROM `zt_file` WHERE objectType = 'bug' AND objectID IN ('4754','4753','4752','4748','4747','4745','4744','4743','4742','4740','4739','4717','4716','4714','4710','4704','4703','4701','4688','4687','4686','4684','4682','4667','4662','4660','4658','4657','4655','4652','4649','4633','4632','4631','4630','4629','4628','4627','4626','4625','4624','4622','4621','4620','4619','4618','4616','4615','4614','4613','4612','4611','4610','4609','4608','4607','4606','4600','4599','4598','4597','4596','4595','4594','4593','4592','4590','4589','4588','4587','4586','4585','4584','4583','4581','4580','4578','4577','4576','4575','4574','4573','4572','4571','4570','4569','4568','4567','4566','4565','4564','4563','4562','4560','4559','4558','4557','4555','4554','4553') 这次导出了42条 然后按条件筛选出来的选中的是120
|
石洋洋 |
zentao(pro/pms)/config/my.php 中debug的值改成true 重新操作一下 看日志文件 zentao(pms/pro)/tmp/log/php开头的今天的文件有什么报错。 不要找 sql开头的日志。
|
大熊
|
13:52:57 iconv(): Detected an illegal character in input string in /var/www/html/zentao/module/file/control.php on line 129 when visiting /zentao/www/index.php?m=bug&f=export&productID=25&orderBy=id_desc 13:53:06 iconv(): Detected an illegal character in input string in /var/www/html/zentao/module/file/control.php on line 129 when visiting /zentao/www/index.php?m=bug&f=export&productID=25&orderBy=id_desc |
大熊
|
请问这个问题,我的日志导出的对吗,是什么原因引起的
|
石洋洋 |
升级一下禅道版本到最新9.1版本 再导出试试,9.1下载:http://www.zentao.net/download/80031.html
|
大熊
|
好的,请问升级之后现的数据都会有吗,主要是现在整个公司都在用,怕升级后造成影响,操作方式与7.2有没有很大的差异
|
石洋洋 |
还是有一些差异的,可以在你本地先搭建一个9.1.1版本的禅道试一下,看看里面的功能。
|