the question about plugin of Backlogs.

Added by xinqi hu about 1 year ago

1、when i add one story, the error tips:
Mysql2::Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'where id = 14' at line 1: update issues set position = where id = 14
what can i do?who can help me?

2、
if the linux have a suitable environment that suitable ruby&rails version. we can direct to install the plugin? and it can auto download and install the redmine too?

why i ask this question. because i find a shell script "redmine_install.sh" in the plugin's root path.

Replies (13)

RE: the question about plugin of Backlogs. - Added by Frederico Camara about 1 year ago

I write that questions in "https://www.redmine.org/projects/redmine/boards/3". but no one answer me.
could you tell me what kands of parameters in your redmine server. like this
redmine version:
ruby:
rails:

It really does not matter that much, but...

Redmine version 3.2.0.stable
Ruby version 2.2.1-p85 (2015-02-26) [x86_64-linux]
Rails version 4.2.5.2

Notice, this setup was brand new when I installed it some years ago. I would try to use latest versions of Redmine/Ruby/Rails for a brand new installation. You have to look at the projects compatibility pages to see if thay are compatible with the Ruby/Rails version you would like to use. Sometimes you would have to patch a plugin, or use an older version of Rails/Ruby. Keep in mind:

1. It's not hard and it doesn't take too long to setup a different environment of Rails/Ruby
2. If you don't know how to do it, do a Rails tutorial (first chapter of railstutorial dot org, for example)
3. Once you are confident in your test installation, you can setup the whole environment (Apache, passenger, etc) for production
4. Grep the logs for errors

this is my question,who can help me? - Added by xinqi hu 12 months ago

when i add one story, the error tips:
Mysql2::Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'where id = 14' at line 1: update issues set position = where id = 14
what can i do?who can help me?

RE: the question about plugin of Backlogs. - Added by xinqi hu 12 months ago

the version is 3.2.x, the plugin is backlogs.

this is my question&backlog source link: https://github.com/fredsdc/redmine_backlogs/commit/f07882300884a2c1fc310aa358529589575d2c44

RE: the question about plugin of Backlogs. - Added by xinqi hu 12 months ago

Frederico Camara wrote:

I write that questions in "https://www.redmine.org/projects/redmine/boards/3". but no one answer me.
could you tell me what kands of parameters in your redmine server. like this
redmine version:
ruby:
rails:

It really does not matter that much, but...

Redmine version 3.2.0.stable
Ruby version 2.2.1-p85 (2015-02-26) [x86_64-linux]
Rails version 4.2.5.2

Notice, this setup was brand new when I installed it some years ago. I would try to use latest versions of Redmine/Ruby/Rails for a brand new installation. You have to look at the projects compatibility pages to see if thay are compatible with the Ruby/Rails version you would like to use. Sometimes you would have to patch a plugin, or use an older version of Rails/Ruby. Keep in mind:

1. It's not hard and it doesn't take too long to setup a different environment of Rails/Ruby
2. If you don't know how to do it, do a Rails tutorial (first chapter of railstutorial dot org, for example)
3. Once you are confident in your test installation, you can setup the whole environment (Apache, passenger, etc) for production
4. Grep the logs for errors

when i add one story, the error tips:
Mysql2::Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'where id = 14' at line 1: update issues set position = where id = 14
what can i do?who can help me?
the version is 3.2.x, the plugin is backlogs.

this is my question&backlog source link: https://github.com/fredsdc/redmine_backlogs/commit/f07882300884a2c1fc310aa358529589575d2c44

RE: the question about plugin of Backlogs. - Added by Frederico Camara 12 months ago

xinqi hu wrote:

when i config backlogs. the submit button is gray all time. what the plugin's rules? could you help me?

The interface here is is portuguese, I will translate as best as I can.

This plugin implements Scrum. Simplifying, in Scrum there are 3 kinds of tasks: Epics, User Stories, Tasks. They are organized in layers: Epics have User Stories (which are what you plan in Sprints), User stories have Tasks (which are the pieces of postit you move on the kanban).

In the Backlogs plugin you have to determine which Redmine tracker you will use as User Stories (can be more than one), and which tracker you will use as a Task.

First selector is for User Stories, select as many as you like.
Second selector is the default user Story.
Third selector is for which tracker will be a Task, select only one.

Projects that use this plugin will have these restrictions:
- If a task is neither a User Story nor a Task, it may be an Epic or completely unrelated.
- A User Story cannot be child to another User Story.
- User Story subtasks, and their subtasks are always of the kind selected as Task.

RE: the question about plugin of Backlogs. - Added by xinqi hu 12 months ago

thank you very much.

when i install it in centos 7.3 & redmine 3.4.6, all the above errors have been erased.
but when i open the menu "Sprints",it can be show a sprints page, then i open the "Task kan ban" link, the link a error page like this:
"Not Found

The requested URL /rb/taskboards/1 was not found on this server."

RE: the question about plugin of Backlogs. - Added by xinqi hu 12 months ago

thank you very much.

when i install it in centos 7.3 & redmine 3.4.6, all the above errors have been erased.
but when i open the menu "Sprints",it can be show a sprints page, then i open the "Task kan ban" link, the link a error page like this:
"Not Found

The requested URL /rb/taskboards/1 was not found on this server."

RE: the question about plugin of Backlogs. - Added by Frederico Camara 12 months ago

Many possibilities...

1. It looks like a problem with your permissions or your rails routing. Which version of the backlogs plugin are you using? The original plugin in the branch master is so out of date I don't think it works with redmine 3. The branch redmine-3 is better. TheMagician1 kept updating his branch develop. I didn't test it but fukachi has a very recent fork.

I really don't recommend using my Backlogs fork unless you are using my Redmine 3.2 patched version, because I implemented Worspaces to separate groups of Workflows from one another and had to make changes in function calls. Anyway, TheMagician1 has cherry picked most of my useful patches.

2. Have you installed the plugin properly?

- put a copy of the plugin in the plugins directory
- install the plugin in production (touch tmp/restart.txt;RAILS_ENV=production bundle exec rake redmine:plugins:migrate NAME=<name of plugin>)
- any gems missing? (touch tmp/restart.txt;RAILS_ENV=production bundle install)
- Have you migrated the database? (touch tmp/restart.txt;RAILS_ENV=production bundle exec rake db:migrate)

3. Maybe you are using a routing for older versions of Rails in your plugin.

4. Always look at the logs. The information at the browser window is for your users, not for your devops.

RE: the question about plugin of Backlogs. - Added by xinqi hu 12 months ago

Frederico Camara wrote:

Many possibilities...

1. It looks like a problem with your permissions or your rails routing. Which version of the backlogs plugin are you using? The original plugin in the branch master is so out of date I don't think it works with redmine 3. The branch redmine-3 is better. TheMagician1 kept updating his branch develop. I didn't test it but fukachi has a very recent fork.

I really don't recommend using my Backlogs fork unless you are using my Redmine 3.2 patched version, because I implemented Worspaces to separate groups of Workflows from one another and had to make changes in function calls. Anyway, TheMagician1 has cherry picked most of my useful patches.

2. Have you installed the plugin properly?

- put a copy of the plugin in the plugins directory
- install the plugin in production (touch tmp/restart.txt;RAILS_ENV=production bundle exec rake redmine:plugins:migrate NAME=<name of plugin>)
- any gems missing? (touch tmp/restart.txt;RAILS_ENV=production bundle install)
- Have you migrated the database? (touch tmp/restart.txt;RAILS_ENV=production bundle exec rake db:migrate)

3. Maybe you are using a routing for older versions of Rails in your plugin.

4. Always look at the logs. The information at the browser window is for your users, not for your devops.

-------------------------------------------------------------------
tkx for your help.

i'm using the version of the backlogs plugin is v2.02. it's the branch version. the gitlab repository link is:
https://github.com/TheMagician1/redmine_backlogs this version update so frequent.

but no i have a question:
when i create storys or tasks to backlog,it only show 4 fields for edit. when i in taskboard to decompose tasks from one story. it only show 4~5 fileds. how to show more fileds in one popup window? because i want fill in more fileds in one popup window when i assign a task.

could you help me to be done?tkx.

could i add your skype number? my number is hxqqqqqq

RE: the question about plugin of Backlogs. - Added by Frederico Camara 12 months ago

Sorry, I don't use Skype. It's blocked at work, anyway.

I don't think you can edit which fields are editable on the plugin. The purpose of this plugin is to implement agile scrum and kanban. Think of it as short writings on postit paper on boards. Only basic information is editable in the plugin, tasks dates are set to the sprints' initial and due dates. Redmine's custom fields are igonred. Tasks relationships are mostly ignored.

If you really need it, you can try adapting the plugin, in here we simply don't use it to create new issues, just to manage backlogs and sprints. I don't think I know enough javascript/html to understand the plugin enough to advise you.

PS: In the case of tasks, the html.erb is in plugins/redmine_backlogs/app/views/rb_tasks/_task.html.erb.

RE: the question about plugin of Backlogs. - Added by xinqi hu 11 months ago

are you the member of redmine developers? I create this question in new flag. but no one help me. so i add question in this place. could you help me?
I am useing redmine 3.4.6,
when i create a "spent time" custom feilds.
the only show two checks: required & used as a filter.
it's less than "Issues".
so when i created a "spent time" custom feilds. it can't display on the "spend time"'s table.

i think it is a bug. who can help fix it? tkx!

because i want to add "Abnormal working hours for personnel","Normal working hours of equipment","Abnormal working hours of equipment" these 3 custom feilds. but there are cat't display in the grid(table).

could you help me?tkx very much.

RE: the question about plugin of Backlogs. - Added by Frederico Camara 11 months ago

Worked for me.

1. I created a spent time custom field.
2. Added some spent time to a project
3. On the project general tab, I clicked on report (to the right of page)
4. Expanded Options
5. Moved spent time custom fields from left box to right box
6. Clicked apply

Look over Apply, there are two unexpanded fieldsets, expanding Options you can add columns available to columns shown. Click Apply after changing the table columns.

Tested on Redmine 3.2.

RE: the question about plugin of Backlogs. - Added by xinqi hu 11 months ago

yes, i got it.tkx.

by the way.
In "Issues" Page, how to create 2 or 3 Interconnected listbox(or combobox),the last one can depend on the Previous one?
could you have this plugin? could you help me?tkx。

(1-13/13)