BUGFREE出现问题,报的错误内容:
ERROR OCCUR TO /BugList.php:
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 '' at line 1The FULL SQL IS:
SELECT BugID,BugStatus,BugID,BugSeverity,BugTitle,BugStatus,OpenedBy,AssignedTo,ResolvedBy,Resolution FROM bugfree_BugInfo WHERE ProjectID IN ('9','1','2','3','5','6','7','8','10','11','12','13','15','16','17','19','20','21','22','24','25','26','27','28','29','30','31','32','33','34','35') AND 1 AND IsDroped = '0' ORDER BY BugID DESC LIMIT 0,ERROR OCCUR TO /UserControl.php:
Table '.\bugfree\bugfree_buginfo' is ed as crashed and should be repairedThe FULL SQL IS:
SELECT BugID,BugTitle FROM bugfree_BugInfo WHERE OpenedBy = 'admin' AND BugStatus <> 'Closed' ORDER BY BugID DESC LIMIT 10
ERROR OCCUR TO /BugList.php:
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 '' at line 1The FULL SQL IS:
SELECT BugID,BugStatus,BugID,BugSeverity,BugTitle,BugStatus,OpenedBy,AssignedTo,ResolvedBy,Resolution FROM bugfree_BugInfo WHERE ProjectID IN ('9','1','2','3','5','6','7','8','10','11','12','13','15','16','17','19','20','21','22','24','25','26','27','28','29','30','31','32','33','34','35') AND 1 AND IsDroped = '0' ORDER BY BugID DESC LIMIT 0,ERROR OCCUR TO /UserControl.php:
Table '.\bugfree\bugfree_buginfo' is ed as crashed and should be repairedThe FULL SQL IS:
SELECT BugID,BugTitle FROM bugfree_BugInfo WHERE OpenedBy = 'admin' AND BugStatus <> 'Closed' ORDER BY BugID DESC LIMIT 10
1。 你的SQL语句的语法检查一下,试一下直接在mysql执行一下 ,特别是注意一下ProjectID, IsDroped 的字段类型,你下面的语句是认为这两个字段为字符型。SELECT BugID,BugStatus,BugID,BugSeverity,BugTitle,BugStatus,OpenedBy,AssignedTo,ResolvedBy,Resolution
FROM bugfree_BugInfo
WHERE ProjectID IN ('9','1','2','3','5','6','7','8','10','11','12','13','15','16','17','19','20','21','22','24','25','26','27','28','29','30','31','32','33','34','35')
AND 1 AND IsDroped = '0'
ORDER BY BugID DESC LIMIT 0
2. 在mysql中check table bugfree_buginfo; 或者直接 repair talbe bugfree_buginfo;
我在开始菜单中没有找到关于MYSQL的选项,另外在BUGFREE的安装目录中也没有找到MYSQL的可执行文件。
非常抱歉,我是一个数据库盲。
我看了在应用程序中有一个MYSQL的文件夹包含以下文件夹:
1.backup
2.bin
3.data
4.scripts
5.share
6.sql_bench
但还是不知道应该用什么状态下去输入你上面写的命令
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.1.33-community-log MySQL Community Server (GPL)Type 'help;' or '\h' for help. Type '\c' to clear the buffer.mysql>[/code]
access denied for user 'root@localhost' (using password : yes)
1.comp-err.exe
2.echo.exe
3.my_example.exe
4.my_print_default.exe
5.myisam_ftpdump.exe
6.myisamchk.exe
7.myisamlog.exe
8.myisampack.exe
9.mysql.exe
10.mysql_client_test.exe
11.mysql_upgrade.exe
12.mysqladmin.exe
13.mysqlbinlog.exe
14.mysqlcheck.exe
15.mysqld.exe
16.mysql_debug.exe
17.mysql_nt.exe
18.mysqldump.exe
19.mysqldump.exe
20.mysqlimport.exe
21.mysqlmanager.exe
22.mysqlshow.exe
23.mysqltest.exe
24.mytest.exe
25.perror.exe
26.replace.exe
27.winmysqladmin.exe(这个没有找到可以输入命令的地方)
mysql -u root -p123 你可以先试一下
mysql -u root有时很多数据库ROOT密码为空。
教训太深刻了!!
我应该怎么将数据备份和导入呢?
2. mysqldump -uroot mydb >xx.sql 导出导入呢?
mysql -uroot < xx.sql
参见以下官方文档8.8. mysqldump:数据库备份程序
http://dev.mysql.com/doc/refman/5.1/zh/client-side-scripts.html#mysqldump5.9. 备份与恢复
http://dev.mysql.com/doc/refman/5.1/zh/database-administration.html#disaster-prevention
5.9.1. 数据库备份
5.9.2. 示例用备份与恢复策略
5.9.3. 自动恢复
5.9.4. 表维护和崩溃恢复
5.9.5. myisamchk:MyISAM表维护实用工具
5.9.6. 建立表维护计划
5.9.7. 获取关于表的信息
BugFree 数据库创建失败: ERROR OCCUR TO /bugfree/install.php:
Access denied for user 'root'@'localhost' (using password: NO)The FULL SQL IS:
CREATE DATABASE bugfree2
请问各位大侠我的哪里出问题了?求指教!