今天
reivewboard终于恢复了。但发现之前的工程无法识别diff文件信息,报file_not_found异常。
后来了解,当初上传diff的时候,由于把BaseDirectory写成绝对路径了,加上原svn迁移了到其他位置,所以记录绝对路径的diff信息无法找到相应的文件。(写成绝对路径后在数据库中会保存绝对路径,然后会根据此路径去找相应的文件。在svn迁移后,尤其地址变了,会导致无法获取svn内的文件,在查看diff信息时页面会显示报错信息,提示file_not_found。) 而上传时填相对路径的则无影响。
修订方法:
去官网了解一下Data Storage Table,知道Diff信息相关的数据库表为Diffviewer_*
Diffviewer | |
Diff set histories | Groupings of revisioned diff sets, each owned by a review request. |
Diff sets | A revisioned set of file diffs owned by a diff set history. |
File diffs | Per-file diffs, along with the path and revision of the referenced files in the repository. |
具体的数据库表如下:
然后用update [table_name] set col_name=repalce(col_name, "[绝对路径前缀]", "")将diffviewer_diffset中的base_dir和diffviewer_filediff中的source_file和dest_file的绝对路径改成相关路径即可。
以后在上传Diff文件时,要记得要将Base Directory设置成相对路径。