Bugfree使用点滴
BugFree是借鉴微软公司软件研发理念、免费且开放源代码、基于Web的精简版缺陷管理系统。它是目前唯一“克隆”微软内部Bug管理工具 Product Stuido（以前叫Raid）的自由软件。BugFree是用PHP+MySQL写，在Linux和Windows平台上都可以运行，我们推荐的使用环境是LAMP（Linux+Apache+MySQL+PHP）。
官方网站：http://www.bugfree.org.cn/
1、安装
2008-01-28 BugFree 2.0 RTM build 下载地址：http://www.bugfree.org.cn/download/bugfree2.0.1128_rtm.tar.gz
配置好PHP环境和MYSQL
出现比较多的问题是SQL安装脚本无法正确执行，出现如下错误：
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 ' CREATE TABLE `bugfree_BugInfo` ( `BugID` mediumint(7) unsigned NOT NULL a' at line 1
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 ''', `OpenedBy` varchar(30) NOT NULL default '', `OpenedDate` datetime NOT NU' at line 13
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 ''', `AssignedTo` varchar(30) NOT NULL default '', `AssignedDate` datetime NO' at line 14
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 ''', PRIMARY KEY (`ActionID`), KEY `Action` (`ActionTarget`,`IdValue`) ) TYP' at line 8
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 ''', `NewValue` text '', PRIMARY KEY (`HistoryID`), KEY `ActionID` (`Actio' at line 5
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 ''', `GroupACL` text '', `AddDate` datetime NOT NULL default '0000-00-00 00:0' at line 4
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 ''', `AddDate` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY ' at line 6
解决方法：下载本人修改好的BugFree2.0 SQL脚本：https://files.cnblogs.com/idragonet/CreateTable.rar
2.为什么“自定义显示”的字段不能保存，过一段时间又恢复成默认？
BugFree把字段显示设置保存在COOKIE里，并且COOKIE有效期是10小时（36000秒），所以10小时后你的字段显示设置又变成默认。
解决方法：修改文件 Include\FuncModel.inc.php
找到3123行，“@setcookie($Mode . "CustomFields", $_...............................”,
改为：“ @setcookie($Mode . "CustomFields", $_POST['FieldsToShow'], time()+360000000);”
说明：360000000是秒，也就是100000小时后COOKIE超时。
3.设置邮件发送
修改文件 Include\Config.inc.php
修改配置如下（仅供参考）：
/* 8. Mail setting. */
$_CFG['Mail']['On'] = true;
$_CFG['Mail']['FromAddress'] = "username@163.com";
$_CFG['Mail']['FromName'] = 'BugFree';
$_CFG['Mail']['ReportTo'] = array(); // Where bug statistics message sened to. If empty, to all users.
$_CFG['Mail']['SendMethod'] = 'SMTP'; // MAIL|SENDMAIL|SMTP|QMAIL
/* 9. SMTP param setting. */
$_CFG['Mail']['SendParam']['Host'] = 'smtp.163.com'; // The server to connect. Default is localhost
$_CFG['Mail']['SendParam']['SMTPAuth'] = true; // Whether or not to use SMTP authentication. Default is FALSE
$_CFG['Mail']['SendParam']['Username'] = 'username'; // The username to use for SMTP authentication.
$_CFG['Mail']['SendParam']['Password'] = 'password'; // The password to use for SMTP authentication.
官方网站：http://www.bugfree.org.cn/
1、安装
2008-01-28 BugFree 2.0 RTM build 下载地址：http://www.bugfree.org.cn/download/bugfree2.0.1128_rtm.tar.gz
配置好PHP环境和MYSQL
出现比较多的问题是SQL安装脚本无法正确执行，出现如下错误：
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 ' CREATE TABLE `bugfree_BugInfo` ( `BugID` mediumint(7) unsigned NOT NULL a' at line 1
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 ''', `OpenedBy` varchar(30) NOT NULL default '', `OpenedDate` datetime NOT NU' at line 13
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 ''', `AssignedTo` varchar(30) NOT NULL default '', `AssignedDate` datetime NO' at line 14
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 ''', PRIMARY KEY (`ActionID`), KEY `Action` (`ActionTarget`,`IdValue`) ) TYP' at line 8
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 ''', `NewValue` text '', PRIMARY KEY (`HistoryID`), KEY `ActionID` (`Actio' at line 5
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 ''', `GroupACL` text '', `AddDate` datetime NOT NULL default '0000-00-00 00:0' at line 4
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 ''', `AddDate` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY ' at line 6
解决方法：下载本人修改好的BugFree2.0 SQL脚本：https://files.cnblogs.com/idragonet/CreateTable.rar2.为什么“自定义显示”的字段不能保存，过一段时间又恢复成默认？
BugFree把字段显示设置保存在COOKIE里，并且COOKIE有效期是10小时（36000秒），所以10小时后你的字段显示设置又变成默认。
解决方法：修改文件 Include\FuncModel.inc.php找到3123行，“@setcookie($Mode . "CustomFields", $_...............................”,
改为：“ @setcookie($Mode . "CustomFields", $_POST['FieldsToShow'], time()+360000000);”
说明：360000000是秒，也就是100000小时后COOKIE超时。
3.设置邮件发送
修改文件 Include\Config.inc.php
修改配置如下（仅供参考）：
/* 8. Mail setting. */
$_CFG['Mail']['On'] = true;
$_CFG['Mail']['FromAddress'] = "username@163.com";
$_CFG['Mail']['FromName'] = 'BugFree';
$_CFG['Mail']['ReportTo'] = array(); // Where bug statistics message sened to. If empty, to all users.
$_CFG['Mail']['SendMethod'] = 'SMTP'; // MAIL|SENDMAIL|SMTP|QMAIL
/* 9. SMTP param setting. */
$_CFG['Mail']['SendParam']['Host'] = 'smtp.163.com'; // The server to connect. Default is localhost
$_CFG['Mail']['SendParam']['SMTPAuth'] = true; // Whether or not to use SMTP authentication. Default is FALSE
$_CFG['Mail']['SendParam']['Username'] = 'username'; // The username to use for SMTP authentication.
$_CFG['Mail']['SendParam']['Password'] = 'password'; // The password to use for SMTP authentication.
