CRM plugin
Added by Kirill Bezrukov (RedmineUP) almost 14 years ago
Replies (170)
RE: Contacts plugin - Added by Kirill Bezrukov (RedmineUP) over 13 years ago
Francisco José Martínez wrote:
Francisco José Martínez wrote:
The version 1.2.1 doesn't work for me beacuse i use redmine 1.0.X. Do you know how to downgrade to version 1.1.6.?
I'm trying uninstall 1.2.1, and then install 1.1.6 but i get some errors using the plugins because some database columns don't exists.
I will fix it in 1.2.2
Now you could install 1.2.0 it work's with 1.0.x
RE: Contacts plugin - Added by Kirill Bezrukov (RedmineUP) over 13 years ago
Mario Glockner wrote:
Oh I see, thank you! As I said, it would be very great, If there'd be a view or page where I can get this information consolidated!
I don't understand what do you mean? Could you make sketch?
RE: Contacts plugin - Added by Mario Glockner over 13 years ago
Of course, perhaps something like this:
RE: Contacts plugin - Added by Francisco José Martínez over 13 years ago
I will fix it in 1.2.2
Now you could install 1.2.0 it work's with 1.0.x
I installed 1.2.0 version and work fine.
But i have a problem:
I've created 2 contacts: person1 and person2, then I create a new issue from contact menu (in sidebar) with person1, it's OK.
Now I want add a person2 to Contact list (in a issue). When I click on "Add" link doesn't show anything. Is this normal?
How can i add new contact to contact list?
RE: Contacts plugin - Added by Francisco José Martínez over 13 years ago
I read this message from log when i click on "Add" link
Processing ContactsController#add_contact_to_issue (for 192.168.111.11 at 2011-04-20 14:01:10) [POST] Parameters: {"issue_id"=>"8376", "project_id"=>"test1", "action"=>"add_contact_to_issue", "authenticity_token"=>"--------", "controller"=>"contacts"} Filter chain halted as [:find_contact] rendered_or_redirected. Completed in 3ms (View: 1, DB: 0) | 404 Not Found [http://mypage/contacts/add_contact_to_issue?issue_id=8376&project_id=test1]
I hope it's help!
RE: Contacts plugin - Added by Kirill Bezrukov (RedmineUP) over 13 years ago
Francisco José Martínez wrote:
I read this message from log when i click on "Add" link
[...]I hope it's help!
I've send you new beta to email
Can't install Contacts plugin - Added by Alexander Sapozhnikov over 13 years ago
I try to install Contacts plugin 1.2.1 but migration does not work, I got error:
== CreateContactsProjects: migrating ========================================= -- create_table(:contacts_projects, {:id=>false}) rake aborted! An error has occurred, all later migrations canceled: Mysql::Error: Table 'contacts_projects' already exists: CREATE TABLE `contacts_projects` (`project_id` int(11) DEFAULT 0 NOT NULL, `contact_id` int(11) DEFAULT 0 NOT NULL) ENGINE=InnoDB
It seems that migration script tries to create table without checking of its existence. But table 'contacts_projects' may exists after previous failed migration.
When I delete table 'contacts_projects' and ran migration again I got another error:
== CreateContactsProjects: migrating ========================================= -- create_table(:contacts_projects, {:id=>false}) -> 0.0419s -- add_index(:contacts_projects, [:project_id, :contact_id], {:name=>"id_idx"}) -> 0.1566s rake aborted! An error has occurred, all later migrations canceled: Mysql::Error: Table 'redmine_test.contacts' doesn't exist: SELECT * FROM `contacts`
db/migrate/019_create_contacts_projects.rb and other migration scripts doesn’t contains command for 'contacts' table creation.
I tried sometimes redmine-customer-plugin — may be this module is root of troubles? I’ve install this module again and remove it:
rake db:migrate:plugin NAME=redmine-customer-plugin VERSION=0 RAILS_ENV=development
It didn’t help me.
What can I do?
P. S. http://hgftr.ru/svn/repository/redmine/redmine_contacts/trunk/ doesn’t work: 502 Bad Gateway
RE: Contacts plugin - Added by Terence Mill over 13 years ago
The contacts migrations is messed up, i had similar and worse problems. At the moment i don't have my papers around i wrote the exact howto workaround, but the summary was to clean up redmine's plugins migrations table from all contact's entries and remove all contacts tables from db and reinstall the complete plugin afterwards. Be aware that you will loose all contacts data on this approach.
The problems occours if you migrate down or reisntall sometimes, because there are a lot of errors i migration scripts history.
RE: Contacts plugin - Added by Kirill Bezrukov (RedmineUP) over 13 years ago
Terence Mill wrote:
The contacts migrations is messed up, i had similar and worse problems. At the moment i don't have my papers around i wrote the exact howto workaround, but the summary was to clean up redmine's plugins migrations table from all contact's entries and remove all contacts tables from db and reinstall the complete plugin afterwards. Be aware that you will loose all contacts data on this approach.
The problems occours if you migrate down or reisntall sometimes, because there are a lot of errors i migration scripts history.
After manualy deleting all plugin tables, such:
- contacts
- deals
- contacts_deals
- contacts_issues
- contacts_projects
- recently_vieweds
- notes
- tags
- taggings
After should delete all x-redmine_contacts records from shema_migrations table
RE: Contacts plugin - Added by Alexander Sapozhnikov over 13 years ago
I have no tables from this list: I’ve drop contacts_projects
, tags
and taggings
tables, rest of list didn’t exist.
But I got same error:
== CreateContactsProjects: migrating ========================================= -- create_table(:contacts_projects, {:id=>false}) -> 1.3342s -- add_index(:contacts_projects, [:project_id, :contact_id], {:name=>"id_idx"}) -> 0.1677s rake aborted! An error has occurred, all later migrations canceled: Mysql::Error: Table 'redmine_test.contacts' doesn't exist: SELECT * FROM `contacts`
RE: Contacts plugin - Added by Kirill Bezrukov (RedmineUP) over 13 years ago
Alexander Sapozhnikov wrote:
I have no tables from this list: I’ve drop
contacts_projects
,tags
andtaggings
tables, rest of list didn’t exist.But I got same error: [...]
You should delete all x-redmine_contacts records from shema_migrations table
RE: Contacts plugin - Added by Alexander Sapozhnikov over 13 years ago
DELETE FROM schema_migrations WHERE version LIKE '%contacts%';
is more clean than «delete all x-redmine_contacts records from shema_migrations table».
OK. I delete these data:
mysql> SELECT * FROM schema_migrations WHERE version LIKE '%contacts%'; +-------------------------+ | version | +-------------------------+ | 1-redmine_contacts_new | | 10-redmine_contacts_new | | 11-redmine_contacts_new | | 12-redmine_contacts_new | | 13-redmine_contacts_new | | 14-redmine_contacts_new | | 15-redmine_contacts_new | | 16-redmine_contacts_new | | 17-redmine_contacts_new | | 18-redmine_contacts | | 2-redmine_contacts_new | | 3-redmine_contacts_new | | 4-redmine_contacts_new | | 5-redmine_contacts_new | | 6-redmine_contacts_new | | 7-redmine_contacts_new | | 8-redmine_contacts_new | | 9-redmine_contacts_new | +-------------------------+ 18 rows in set (0.01 sec) mysql> DELETE FROM schema_migrations WHERE version LIKE '%contacts%'; Query OK, 18 rows affected (0.05 sec) mysql> DROP TABLE contacts_projects; Query OK, 0 rows affected (0.03 sec)And spawned migration. It works. Thank you.
RE: Contacts plugin - Added by Alexander Sapozhnikov over 13 years ago
Now I can see list of contacts and I can add new one.
But I can not see contact: I got Error message:
Expected /usr/local/lib/ruby/gems/1.8/gems/acts-as-taggable-on-2.0.6/lib/acts_as_taggable_on/acts_as_taggable_on.rb to define ActsAsTaggableOn::ActsAsTaggableOn
Specified file exists and is readable:
# ls -l /usr/local/lib/ruby/gems/1.8/gems/acts-as-taggable-on-2.0.6/lib/acts_as_taggable_on/acts_as_taggable_on.rb -rw-r--r-- 1 root wheel 1548 Apr 22 21:48 /usr/local/lib/ruby/gems/1.8/gems/acts-as-taggable-on-2.0.6/lib/acts_as_taggable_on/acts_as_taggable_on.rb
Is this bug of of acts-as-taggable-on? There’s open issue at GitHub with similar error.
acts-as-taggable-on installed via rake gems:install
Is there any method of using redmine-contacts with buggy acts-as-taggable-on?
RE: Contacts plugin - Added by Kirill Bezrukov (RedmineUP) over 13 years ago
Alexander Sapozhnikov wrote:
Now I can see list of contacts and I can add new one.
But I can not see contact: I got Error message:
Expected /usr/local/lib/ruby/gems/1.8/gems/acts-as-taggable-on-2.0.6/lib/acts_as_taggable_on/acts_as_taggable_on.rb to define ActsAsTaggableOn::ActsAsTaggableOnSpecified file exists and is readable: [...]
Is this bug of of acts-as-taggable-on? There’s open issue at GitHub with similar error.
acts-as-taggable-on installed via
rake gems:install
Is there any method of using redmine-contacts with buggy acts-as-taggable-on?
Check vendor/plugins folder, if acts-as-taggable-on is there, try to delete it
RE: Contacts plugin - Added by Alexander Sapozhnikov over 13 years ago
I tried both variants: with and without vendor/plugins/acts-as-taggable-on. Even vendor/plugins/acts-as-taggable-on deleted I see same error.
Full output from console:
/usr/local/lib/ruby/gems/1.8/gems/actionpack-2.3.11/lib/action_controller/mime_type.rb:80: warning: already initialized constant VCF SQL (0.9ms) SET NAMES 'utf8' SQL (0.6ms) SET SQL_AUTO_IS_NULL=0 Processing ContactsController#show (for [my IP here] at 2011-04-23 10:47:45) [GET] Parameters: {"action"=>"show", "id"=>"1", "controller"=>"contacts"} Setting Columns (1.8ms) SHOW FIELDS FROM `settings` SQL (1.3ms) SELECT max(`settings`.updated_on) AS max_updated_on FROM `settings` User Columns (1.9ms) SHOW FIELDS FROM `users` User Load (1.1ms) SELECT * FROM `users` WHERE (`users`.`id` = 3) AND (users.status = 1) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) ) SQL (5.9ms) SHOW TABLES Contact Columns (10.0ms) SHOW FIELDS FROM `contacts` Contact Load (1.2ms) SELECT * FROM `contacts` WHERE (`contacts`.`id` = 1) ActsAsTaggableOn::Tagging Load (1.0ms) SELECT `taggings`.* FROM `taggings` WHERE (`taggings`.`taggable_id` = 1 and `taggings`.`taggable_type` = 'Contact' AND (taggings.tagger_id IS NULL AND taggings.context = 'tags')) LoadError (Expected /usr/local/lib/ruby/gems/1.8/gems/acts-as-taggable-on-2.0.6/lib/acts_as_taggable_on/acts_as_taggable_on.rb to define ActsAsTaggableOn::ActsAsTaggableOn): vendor/plugins/redmine_contacts/app/controllers/contacts_controller.rb:158:in `find_contact' /usr/local/lib/ruby/1.8/webrick/httpserver.rb:104:in `service' /usr/local/lib/ruby/1.8/webrick/httpserver.rb:65:in `run' /usr/local/lib/ruby/1.8/webrick/server.rb:173:in `start_thread' /usr/local/lib/ruby/1.8/webrick/server.rb:162:in `start' /usr/local/lib/ruby/1.8/webrick/server.rb:162:in `start_thread' /usr/local/lib/ruby/1.8/webrick/server.rb:95:in `start' /usr/local/lib/ruby/1.8/webrick/server.rb:92:in `each' /usr/local/lib/ruby/1.8/webrick/server.rb:92:in `start' /usr/local/lib/ruby/1.8/webrick/server.rb:23:in `start' /usr/local/lib/ruby/1.8/webrick/server.rb:82:in `start' Rendered rescues/_trace (557.0ms) Rendered rescues/_request_and_response (46.5ms) Rendering rescues/layout (internal_server_error)All SQL queries listed above are correct and successfully executed.
RE: Contacts plugin - Added by Alex A over 13 years ago
Does this plugin work with non MySql database (e.g. postgresql)?
RE: Contacts plugin - Added by Kirill Bezrukov (RedmineUP) over 13 years ago
Alex A wrote:
Does this plugin work with non MySql database (e.g. postgresql)?
Now I have problems with Postgres, because I don't have experience on it. I've tested plugin only in SQLite and MySQL
I'm gonna porting plugin to postgres in future
RE: Contacts plugin - Added by Terence Mill over 13 years ago
I tried to register at http://redmine.hgftr.ru but but i can't login and don't get an i get an email send for password reset.
Can u check please for user "cforce" tx.
RE: Contacts plugin - Added by Anonymous over 13 years ago
Hi,
I also just ran into this problem. When I try to run rake db:migrate:plugins it always ends with this error
Mysql::Error: Table 'contacts_projects' already exists: CREATE TABLE `contacts_projects` (`project_id` int(11) DEFAULT 0 NOT NULL, `contact_id` int(11) DEFAULT 0 NOT NULL) ENGINE=InnoDB
no matter if I run
rake db:migrate:plugins RAILS_ENV=production
or
rake db:migrate:plugins PLUGIN=redmine_contacts VERSION=0 RAILS_ENV=production
in order to get rid of it.
Is there any way I can delete the whole thing?
Also, how can I grab the data that is in there? Is there a simple way to dump the data in "Contacts" into a CSV or XML/JSON or something?
Many thanks!
RE: Contacts plugin - Added by Terence Mill over 13 years ago
Start reading dwon from here
http://www.redmine.org/boards/3/topics/19392?r=23539#message-23539
RE: Contacts plugin - Added by Anonymous over 13 years ago
Thanks!
But then I lose all data, right? Do you know how I can grab the data? Any structured format would do really (but I am a total MySQL wuss, sorry :( So anything would help really.
RE: Contacts plugin - Added by Terence Mill over 13 years ago
If there is a expert knowing this, its
- Kirill Bezrukov.*
Maybe wait some time and he will see this post
Would be geart if this bugs could be fixed anyway. I am afraid updating every time.
Cheers
RE: Contacts plugin - Added by Kirill Bezrukov (RedmineUP) over 13 years ago
Jan Wedekind wrote:
Thanks!
But then I lose all data, right? Do you know how I can grab the data? Any structured format would do really (but I am a total MySQL wuss, sorry :( So anything would help really.
What the last working version do you have? And after which version do you have this problem.
If you wanna export contacts to XML, you should write yourRedmine/contacts.xml, but it exports only contacts data without comments and deals and related tasks.
And I can try to migrate your database if it is not so private
RE: Contacts plugin - Added by Anonymous over 13 years ago
Hi,
Version is 1.2.1. Thanks a lot for the XML tip! Will do that now just to be on the save side. There are practically no comments etc yet, so that's fine for now!
I can't really say anymore when it started. We migrated Redmine to a new server. Worked fine at the start, and then after one db:migrate:plugins, the error messages started.
RE: Contacts plugin - Added by Kirill Bezrukov (RedmineUP) over 13 years ago
Jan Wedekind wrote:
Hi,
Version is 1.2.1. Thanks a lot for the XML tip! Will do that now just to be on the save side. There are practically no comments etc yet, so that's fine for now!
I can't really say anymore when it started. We migrated Redmine to a new server. Worked fine at the start, and then after one db:migrate:plugins, the error messages started.
May be some other plugins have such table name. Try install only one contacts plugin and after add plugins by queue