Development Notes

JIRA: User have the permission but can not see ‘log work’ context menu

Categories: Development Notes; Tagged with: BackLog • JIRA; @ April 1st, 2013 19:58

Problem: User have the permission, but unable to log work.

Cause & Solution:

Follow these steps:

Ensure the user has the “Work on Issues” permission in the permission scheme. It’s possible that the user is not in the group, or not in the project role.
Ensure that time tracking is enabled globally.
Check whether the issue is ‘Closed’, or the workflow has put the issue in a state that is uneditable.
Ensure that the Time Tracking field is visible (not hidden) on the Field Configuration.
Note that this last procedure will allow editing of closed issues. If you wish to edit only this one issue, simply reopen the issue, add time tracking, and re-close.
1. Choose the issue that is being affected by this problem (e.g. issues with Closed status).
2. Navigate to Administration >> Global Settings >> Workflows and check for the Active workflow that the issue is using.
3. Create a draft workflow since the current workflow is in an Active state.
4. Click on View Properties for the affected issue status.
5. Delete jira.issue.editable if it’s set to false.
6. Add a new property with the same property key (jira.issue.editable) but set to true.
7. Publish this workflow draft.

For my case, the project has it’s own field schema, and the ‘Time tracking’ filed was hided, after ‘show’ the ‘Time tracking’ filed, user can log work.

For more details: https://confluence.atlassian.com/display/JIRAKB/Unable+to+Log+Work

Bitbucket: Free Git Private Repository 免费私有Git空间

Categories: Development Notes; Tagged with: Bitbucket • Git; @ March 31st, 2013 11:48

About Bitbucket

Host your code online in as many public and private repositories as you want. Free for 5 users.

Give your code a home on the web. Share what you’re working on with your colleagues, collaborators, or potential employers.

All 5 user accounts are FREE.

Checkout: https://bitbucket.org/

WordPress: batch deleting spam comments 批量删除垃圾回复

Categories: Development Notes • WordPress; Tagged with: MySQL • SQL • WordPress; @ March 16th, 2013 10:50

Use sql to delete all the spam comments quickly:

Status of comment

SELECT DISTINCT comment_approved  FROM `x_comments`

Results:

0 – Pending

1 – approved

spam – spam

trash – trash

Deleting SQL

–delete spam & trash:

DELETE FROM `dbName`.`x_comments` WHERE comment_approved = 'spam' or comment_approved = 'trash'

--delete pending:
DELETE FROM `dbName`.`x_comments` WHERE comment_approved = '0'

WordPress: change language 更改语言中文/英文

Categories: Development Notes • WordPress; Tagged with: WordPress; @ March 16th, 2013 10:39

Modify the wp_config.php

If you want to change the language to ‘English’

/**
* WordPress Localized Language, defaults to English.
*
* Change this to localize WordPress. A corresponding MO file for the chosen
* language must be installed to wp-content/languages. For example, install
* de.mo to wp-content/languages and set WPLANG to ‘de’ to enable German
* language support.
*/
define (‘WPLANG’, ”);

Keep the value empty.

如果你想改变为中文:

/**
* WordPress 语言设置，中文版本默认为中文。
*
* 本项设定能够让 WordPress 显示您需要的语言。
* wp-content/languages 内应放置同名的 .mo 语言文件。
* 要使用 WordPress 简体中文界面，只需填入 zh_CN。
*/
define(‘WPLANG’, ‘zh_CN’);

修改后控制台会有提示下载语言包.

JIRA Error: Unexpected token UNIQUE, requires COLLATION in statement [SET DATABASE UNIQUE])

Categories: Development Notes; Tagged with: HSQL • JIRA; @ March 14th, 2013 15:32

HTTP Status 500 – com.opensymphony.module.propertyset.PropertyImplementationException: Unable to esablish a connection with the database. (error in script file line: 1 Unexpected token UNIQUE, requires COLLATION in statement [SET DATABASE UNIQUE])

type Exception report

message com.opensymphony.module.propertyset.PropertyImplementationException: Unable to esablish a connection with the database. (error in script file line: 1 Unexpected token UNIQUE, requires COLLATION in statement [SET DATABASE UNIQUE])

description The server encountered an internal error (com.opensymphony.module.propertyset.PropertyImplementationException: Unable to esablish a connection with the database. (error in script file line: 1 Unexpected token UNIQUE, requires COLLATION in statement [SET DATABASE UNIQUE])) that prevented it from fulfilling this request.

I got this Error after I use DbVisualizer to connect to JIRA HSQL database.

the HSQL driver version I’m using in DbVis is 2.2.9, but the driver in my JIRA is 1.8.0.5.

Solution

Update the JIRA_HOME/lib hsdb driver and restart the JIRA server.

Link: http://stackoverflow.com/questions/12969109/error-in-script-file-line-1-unexpected-token-unique-requires-collation-in-stat

Newer Posts <-> Older Posts