yandod/candycane

a port of Redmine to CakePHP from Ruby on Rails

CandyCane

CandyCane is a issue tracking system. The original implementation on which it is based, is Redmine

You can view a live demo of CandyCane, as well as the bug tracking for CandyCane here: http://my.candycane.jp/

• Continuous Integration is running on here: https://travis-ci.org/yandod/candycane
• Coverage report is genrated at Coverall
• versioneye

Installation

1. Extract all files, and place into a directory that is accessible to the web server, and able to run PHP.
2. Setup correct permissions on files and folders:
   • chmod -R 777 app/Config
   • chmod -R 777 app/files
   • chmod -R 777 app/tmp
   • chmod -R 777 app/Plugin
3. Access the site via your web server. If you installed into a subdirectory, then ensure that directory is in your URL: http://mysite.com/candycane
4. The step-by-step installer will appear.
5. Just use it!

Development setup

1. Install Vagrant and VirtualBox.
2. Install vagrant-berkshelf plugin. vagrant plugin install vagrant-berkshelf
3. Download candycane box vagrant box add candycane {url}
4. just type vagrant up
5. ssh into vm vagrant ssh
6. cd to app cd /vagrant_data/app
7. run test ./Console/cake test app All
8. run selenium test

vagrant ssh
cd /vagrant_data/
/usr/bin/Xvfb :1 -screen 0 1024x768x8 > /tmp/xvfb.log 2> /tmp/xvfb.error &
export DISPLAY=:1.0
java -jar /var/chef/cache/selenium-server-standalone-2.39.0.jar > /tmp/selenium.log 2> /tmp/selenium.error &
mysql -u root -e "drop database if exists test_candycane;create database test_candycane;"
./vendor/bin/phpunit app/Test/Case/Selenium/InstallerTest.php

Updating to latest version

You need to copy these file and directories into extracted latest codes. Currently we don't make database schema change.

• app/Config/database.php
• app/files
• app/Plugin

Notes

Currently some features which are present in Redmine are not supported by CandyCane. These are:

• Repository viewer
• Forum
• Documents

CandyCane is using CakePHP v2.3.

Contributors

• yandod
• halt
• Ignacio Albors
• k-kishida
• Graham Weldon (predominant)
• akiyan
• Takuya Sato
• Yoshio HANAWA
• kaz29
• Dima
• Norio Suzuki
• hamaco
• kiang
• okonomi
• shin1x1
• Steve Grosbois
• Spenser Jones
• tomo
• hiromi2424
• Mindiell
• mzdakr
• Òscar Casajuana
• elboletaire
• Michito Suzuki
• Shogo Kawahara
• Sebastien pencreach
• Sardorbek Pulatov
• Hisateru Tanaka
• Jose Gonzalez (savant)

We will appreciate any pull requests.

I try to merge as much as possible. Please fork the repository if you find something you want to fix, and submit a pull request.

candycane's Issues

version bumps

• bump cakephp to available latest without breakiing.
• bump php version to meaningful range.

What are the apache modules that are needed?

Hi,

I tried to install candycane on a fresh ubuntu apache2 server (with mysql and php enabled), however, it fails when it tries to install the database

Not Found

The requested URL /candycane/install/database was not found on this server.
Apache/2.2.16 (Ubuntu) Server at localhost Port 80

I have enabled mod_rewrite. Are there other modules or what should I do to overcome this?

Thanks.

Empty Projects on Migration

When importing an existing Redmine database into the new candy can db projects do not show up. All settings and other data is visible (users, settings etc) however the projects returns an empty list.

Creating a New Project also has the same issue, Project is created in the DB however will not show up on the projects page.

Switching Debug on does show some db_errors possibly due to changes int he schema between Rails and PHP??

Warning (512): SQL Error: 1054: Unknown column 'Member.role_id' in 'on clause' [CORE/cake/libs/model/datasources/dbo_source.php, line 525]
Query: SELECT `Member`.`id`, `Member`.`user_id`, `Member`.`project_id`, `Member`.`created_on`, `Member`.`mail_notification`, `Project`.`id`, `Project`.`name`, `Project`.`description`, `Project`.`homepage`, `Project`.`is_public`, `Project`.`parent_id`, `Project`.`created_on`, `Project`.`updated_on`, `Project`.`identifier`, `Project`.`status`, `Project`.`lft`, `Project`.`rgt`, `Role`.`id`, `Role`.`name`, `Role`.`position`, `Role`.`assignable`, `Role`.`builtin`, `Role`.`permissions`, `User`.`id`, `User`.`login`, `User`.`hashed_password`, `User`.`firstname`, `User`.`lastname`, `User`.`mail`, `User`.`mail_notification`, `User`.`admin`, `User`.`status`, `User`.`last_login_on`, `User`.`language`, `User`.`auth_source_id`, `User`.`created_on`, `User`.`updated_on`, `User`.`type`, `User`.`identity_url` FROM `members` AS `Member` LEFT JOIN `projects` AS `Project` ON (`Member`.`project_id` = `Project`.`id`) LEFT JOIN `roles` AS `Role` ON (`Member`.`role_id` = `Role`.`id`) LEFT JOIN `users` AS `User` ON (`Member`.`user_id` = `User`.`id`)  WHERE `project_id` = 3 AND `User`.`status` = 1   ORDER BY `Role`.`position` ASC  

Warning (2): Invalid argument supplied for foreach() [APP/controllers/projects_controller.php, line 867]

Creating the column manually seems to be ok but wanted to raise.

i try to open category but i can't

Default NGINX configuraion file

Hello,

Congratulations on your project ! It's a life saviour, mark my word.

it would be great to provide a default nginx configuration file with the rewrite rules and so one.
By default, candycane launches with no CSS style..

I would take a "simple" copy/paste from you but would save us some time.

have a good night.

Missing file [database.php.install]

The default packet does not come with (APP.'config'.DS.'database.php.install) required in automated installation at app/plugins/install/controllers/install_controller.php:74

After making a new issue

i clicked submit and continue..
and got error

Licence clarification

please, clarify which licence candycane is being / has been released under.

The request has been black-holed

When updating account information and hit save i get this error:

Error: The requested address '/CandyCane/my/account/1' was not found on this server.

CandyCane version 0.9.6

Versions should be sorted by due date

Now versions are sorted wrongly.

They should be sorted in at least:

• Preferences / Versions
• Roadmap

During work experinces

problem after creating to new project

when i try to enter the project i get error: requested adress in not on the server..
i bypass it by entering to projects.. and then entering
i add print screen

Emails goes to all project members

Emails are sent to all memebers of the project, not only to watchers/assigned to users.
Notification settings cannot be updated, because after save - there is an error:

The request has been black-holed
Error: The requested address '/my/account/6' was not found on this server.

Working with Gantt

I want work with Gantt into CandyCane

i found this:
https://github.com/yandod/candycane/blob/8814533099b3d26c9f6f18a0c5f5a373b8b158c8/app/View/Elements/issues/sidebar.ctp

i'm read to working on this, give me a start

Deleting project

I don't know if this is because of my language or not (french), but when I want to delete the Sample project I've this :

Êtes-vous sûr de vouloir supprimer ce projet et toutes les données liées ? <% if @project_to_destroy.children.any? %>
<%= l(:text_subprojects_destroy_warning, content_tag('strong', h(@project_to_destroy.children.sort.collect{|p| p.to_s}.join(', ')))) %> <% end %>

I think there must be something somewhere :)

configuration of smtp outgoing server

Hi,

Where can I configure the settings for smtp outgoing server? Is it at conf/settings.php ?

My outgoing smtp server requires authentication (i.e. user id + pwd over SSL). Is there any place that I can configure it that way?

Thanks.

Quotes in <code> tags are replaces by curly quotes, breaking compatibility with SQL codes.

If a user updates a issue using <code> (some SQL with quotes) </code>, simple quotes will be replaced with curly quotes which if directly pasted to a Database Manager like MySQL Workbench will alert erros for bad syntax.

CI fail

The command "wget http://selenium.googlecode.com/files/selenium-server-standalone-2.39.0.jar" failed and exited with 8 during .

Invalid use of Object::cakeError() in a couple of places

There are a couple of cakeError() calls in code. As documentation states:

For 2.0 Object::cakeError() has been removed. Instead it has been replaced with a number of exceptions.

As stated here Exceptions should be used instead.

I'll try to fix this issue and I'll open a Pull Request, so you can assume this task is assigned to me.

Last one for today.

when you enter a bug and you try to relate it refers to last projects too and then you cant relate to the numbers that you already used..

CI Issue on Travis?

#274

Unable to send out test mail

Hi,

when I click on Settings -> Email Notifications -> Send a test email, I am getting an error message:

Notice (8): Undefined variable: Settings [APP\views\layouts\base.ctp, line 56]
Notice (8): Trying to get property of non-object [APP\views\layouts\base.ctp, line 56]
Missing View

Error: The view for AdminController::test_email() was not found.

Error: Confirm you have created the file: [REMOVED_FOR_SECURITY]\app\views\admin\test_email.ctp

Notice: If you want to customize this error message, create app\views\errors\missing_view.ctp

What should I do to test whether my configuration is set up correctly for email notifications.

Thanks.

-P

can't change status from listing of tasks

I tried to change status and it going to another page:

on submit it doing nothing

And it will be perfectly to change status more than one task in edit

Test Remy lefévère

A trouble with assign new issue to user

"Assigned to" combobox is empty (
But several users was added in the project

Thank you

An Internal Error Has Occurred. on Activity v0.9.4

Hello, i just installed Candy Cande.

I fulfill all requirements, but on the Activity tab of any project I get

An Internal Error Has Occurred
Error: An Internal Error Has Occurred.

When I enabled the debug mode, i got this.

Database Error

Error: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'pisodigi_candy-cane.issues' doesn't exist

SQL Query: select s.id as status_id, s.is_closed as closed, t.id as tracker_id, count(i.id) as total from issues i, issue_statuses s, trackers t where i.status_id=s.id and i.tracker_id=t.id and i.project_id=2 group by s.id, s.is_closed, t.id

Notice: If you want to customize this error message, create app/View/Errors/pdo_error.ctp

Stack Trace

CORE/Cake/Model/Datasource/DboSource.php line 460 → PDOStatement->execute(array)
CORE/Cake/Model/Datasource/DboSource.php line 426 → DboSource->_execute(string, array)
CORE/Cake/Model/Datasource/DboSource.php line 670 → DboSource->execute(string, array, array)
CORE/Cake/Model/Datasource/DboSource.php line 539 → DboSource->fetchAll(string)
[internal function] → DboSource->query(string)
CORE/Cake/Model/Model.php line 3061 → call_user_func_array(array, array)
APP/Model/Report.php line 32 → Model->query(string)
APP/Controller/ReportsController.php line 176 → Report->findIssuesByTracker(string)
APP/Controller/ReportsController.php line 159 → ReportsController->_issues_by_tracker(string)
[internal function] → ReportsController->issue_report()
CORE/Cake/Controller/Controller.php line 486 → ReflectionMethod->invokeArgs(ReportsController, array)
CORE/Cake/Routing/Dispatcher.php line 187 → Controller->invokeAction(CakeRequest)
CORE/Cake/Routing/Dispatcher.php line 162 → Dispatcher->_invoke(ReportsController, CakeRequest, CakeResponse)
APP/webroot/index.php line 96 → Dispatcher->dispatch(CakeRequest, CakeResponse)

I think this is because the table prefix, it is don't recognize it.

Internal Server Error appears when adding a new ticket

Hey there,
first of all, thanks for this great rebuild of redmine in php!

I just installed it and it works fine for me. But when i add a new ticket, i'll get an internal server error. The debug log is the following:

2015-07-27 23:20:37 Notice: Notice (8): Undefined index: custom_field_values in [/is/htdocs/wp1170705_JOTHUDWOQD/www/redmine/app/Controller/ProjectsController.php, line 372]
Trace:
ProjectsController::edit() - APP/Controller/ProjectsController.php, line 372
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 486
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 187
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 162
[main] - APP/webroot/index.php, line 96

the error log is:

2015-07-27 23:20:41 Warning: Warning (2): Invalid argument supplied for foreach() in [/is/htdocs/wp1170705_JOTHUDWOQD/www/redmine/app/View/Projects/index.ctp, line 34]
Trace:
include - APP/View/Projects/index.ctp, line 34
View::_evaluate() - CORE/Cake/View/View.php, line 947
View::_render() - CORE/Cake/View/View.php, line 909
View::render() - CORE/Cake/View/View.php, line 471
Controller::render() - CORE/Cake/Controller/Controller.php, line 948
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 194
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 162
[main] - APP/webroot/index.php, line 96

Hope you can help me

roadmap is not available

also preferences

Unable to change tracker when editing an issue

The 'tracker' option is not shown when editing an issue.

Resolved issue cannot be marked as new

I am marking resolved issue as a new, but it has no effect.

Administration / Informations

This page (admin/info) is not processed ?
I have this on my screen :
"
label_information_plural

<%= Redmine::Info.versioned_name %> (mysql)
text_default_administrator_account_changed
text_file_repository_writable ()
text_plugin_assets_writable ()
text_rmagick_available
"

which seems very strange :)

Real build steps.

we have entire framework of CakePHP on our codebase.

ideally we should install cake from composer, and create composite zip/tar ball as build step.

Is CandyCane Dev Freezed since 2015 ?

Hello,

Is CandyCane Dev Freezed since 2015 ?
This is the best alternative for Redmine Ruby.

Thanks,

Feature : Delete a user

In the new release of Redmine, it is now possible to delete a user.
It would be so great to be able to do the same in candycane !

Bulk move is not working

I go to issues list, then I select multiple tasks and open context menu in which I select Move and I get:

An Internal Error Has Occurred.
Error: An Internal Error Has Occurred.

After I dug into code I found two issues:

First, move method checks:

• request->params['issue_id']
• request->params['url']['ids']
• request->data['Issue']['ids']

but it does not check request->query['ids'], which should be done as bulk move adds ids query param.

Second, instead of $this->cakeError there should be thrown an exception, for example BadRequestException.

This is already reported in #278.

I also try to fix this issue and open a pull request with my fix proposal.

Italian translation locale

Hi!

i want contribute to translate into Italian (it_IT) lang

actually i have copied and rename /app/Locale/fra into new one /app/Locale/ita
and try to update default.po file...

BUT: what is the right way to manage it??

translation are not applied, i suppose a cache problem... [RESOLVED]

if we want add my translations found it here
https://github.com/francescobianco/CandyCane-IT

Not receiving emails from CandyCane

My CandyCane deployment was working absolutely fine, but suddenly today (with nothing changed) it has started throwing an error message at pretty much every action inside the system. The error message is:

An Internal Error Has Occurred.
Error: An Internal Error Has Occurred.

I have not changed anything on the server nor in CandyCane configuration or files. Surprisingly, the action gets successfully done (eg: editing an issue might throw this error but on refreshing the issue, it is observed that the issue was successfully updated).

No idea what is happening here.

Email notifications

When I select "I don't want to be notified of changes that I make myself" in my account I am stlll receiving notifactions.

When we create a filter for issues, and uncheck default columns, there should be two multiple drop downs. Right now its showing <%= l(:field_column_names) %>....

When we create a filter for issues, and uncheck default columns, there should be two multiple drop downs. Right now its showing <%= l(:field_column_names) %>....

update tcpdf in composer.json

seems the project has been migrated.
https://packagist.org/packages/ensepar/tcpdf

More selenium test.

to accept PR from community, we need to have more integration test by Selenium side.

currently we have only instalation steps and creating first issue.

https://github.com/yandod/candycane/tree/master/app/Test/Case/Selenium

Server Application Error 500

If any users are getting Server Application Error 500 like I was, they should consider these things:

• I failed to copy up the .htaccess file when I did scp * [email protected]:~/public_html/bugs/. I had to go back and copy that up.
• I was on a2hosting.com. They require a php.ini step for the allow_url_fopen. I followed these instructions: https://www.a2hosting.com/kb/developer-corner/php/custom-php.ini-files
• After all that, I was getting the 500 error. I had to do chmod -R 755 on ~/public_html/bugs/ to make the problem go away. That advice came from this link: http://www.zen-cart.com/showthread.php?102316-Apache-2-0-SoftException-in-Application-cpp-544-Directory-is-writeable-by-group ...because my cPanel Apache error log kept saying "oftException in Application.cpp:601: Directory "/home/example/public_html/bugs/app/webroot" is writeable by group".

And now it's operational! :)

Now that I've done that, can you tell me what the permissions should be? I don't want to do anything risky. Or, can you share a bash script that I can run which should set the permissions the way they should?

500 Error after creation or updating of issue

Issue is being created\updated. The 500 error is shown then and no redirect occured

Textile - escape javascript

I noticed that "pre" markup in textile does not escape javascript code.

Issues can't be changed from New to resolved,closed etc

So ive done 1 installation of CandyCane wich worked out perfect everything works.

However on my second installation (new folder + new db prefix CCv2_) i cannot change the status from new to something else. The only option i have is New. Ive looked in the settings for issue statuses but everything seems to be there.

Maybe ive made a mistake somewhere in the settings but its a fresh install without any settings changed.

EDIT: When ii change the user role from manage to a new one called lead with the exact same options enabled then you only have the option NEW under issue Status. Maybe im missing something

You can visit this link http://revolutionart.nl/CC/ register automatic and edit the issue to see the problem. Ill leave this link online for a couple of weeks

wikiのSidebarページが更新できない

redmineでは、Sidebar という名前のWikiページは特別扱いされ、
右側のbarに扱われるようですが、candycaneで なぜか無視されるようです。

What about copy paste image in tasks?

It will be very useful

simple manager can paste bugs and fix only copy paste images in field message (as in facebook messenger)

All my customers use facebook messenger to send me srceenshots

Unable to set admin user

Logged in as admin user.
Goto Administration->Users
Select a normal user
Check on the "Admin" checkbox
Click Save

Goto Administration->Users
Select the same user
The checkbox for "Admin" is not on.

Please verify that this is a bug.

enable wiki in the github project to collaborate in documentation

hi!, please enable the wiki collaboration on the github project, to collaborate with documentation..

i'm very impressive with this port of redmine, its was i need!

i installed and in few days i'll report some isues sure..

keep the good work

CSS not loading after installation

Hi,

i installed it on my subdomain and its CSS is not loading, please check below url and advise what could be the issue.

http://pm.rganix.com/