possibilite to upgrade clockingt it 0.99.3 Database to the current jobsworth db schema

[badb...@gmx.de]

Hello,

is there an possibility to upgrade the database directly? Or have i to do this things, step by step?

https://github.com/ari/jobsworth/wiki/ClockingIT-database-migration-guide

Thank you for your help

Regards
badbender

[Aristedes Maniatis]

That's the best known set of instructions for upgrading. It has been quite a ride over the last 5 years.

If you can improve on this as you go, please don't hesitate to update the wiki for other people.

Ari

> --
>
> ---
> You received this message because you are subscribed to the Google Groups "jobsworth" group.
> To unsubscribe from this group and stop receiving emails from it, send an email to jobsworth+...@googlegroups.com.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>

--
-------------------------->
Aristedes Maniatis
ish
http://www.ish.com.au
Level 1, 30 Wilson Street Newtown 2042 Australia
phone +61 2 9550 5001 fax +61 2 9550 4001
GPG fingerprint CBFB 84B4 738D 4E87 5E5C 5EFA EF6A 7D2E 3E49 102A

[badb...@gmx.de]

Hello at the moment i try to update, from clocking it v0.9.33 database to josbworth v1.2 which environment should i use for the rake db:migrate command?

[badb...@gmx.de]

because im getting this error when i call the script
 rake db:migrate
/usr/local/rvm/gems/ruby-1.9.3-p392/gems/rake-0.8.7/lib/rake/alt_system.rb:32: Use RbConfig instead of obsolete and deprecated Config.
(in /jobsworth/jobsworth-master)
rake aborted!
cannot load such file -- lib/localization
/jobsworth/jobsworth-master/Rakefile:10:in `<top (required)>'
(See full trace by running task with --trace)
[root@ebitst20 jobsworth-master]# gem list

*** LOCAL GEMS ***

actionmailer (3.2.13, 2.3.8)
actionpack (3.2.13, 2.3.8)
activemodel (3.2.13)
activerecord (3.2.13, 2.3.8)
activerecord-mysql-adapter (0.0.1)
activeresource (3.2.13, 2.3.8)
activesupport (3.2.13, 2.3.8)
acts_as_list (0.2.0)
acts_as_tree (1.3.0)
addressable (2.3.4)
annotate (2.5.0)
arel (3.0.2)
bcrypt-ruby (3.0.1)
bigdecimal (1.1.0)
bootstrap-sass (2.3.1.0)
bourne (1.4.0)
builder (3.0.4)
bundle (0.0.1)
bundler (1.3.5)
capybara (2.1.0)
ci_reporter (1.8.4)
climate_control (0.0.3)
closure-compiler (1.1.8)
cocaine (0.5.1)
columnize (0.3.6)
crb (1.0.1)
cucumber (1.3.1)
cucumber-rails (1.3.1)
daemon_controller (1.1.4)
daemons (1.1.9)
database_cleaner (0.9.1)
debugger (1.5.0)
debugger-linecache (1.2.0)
debugger-ruby_core_source (1.2.0)
delayed_job (3.0.5)
delayed_job_active_record (0.4.4)
devise (2.2.3)
devise-encryptable (0.1.1)
diff-lcs (1.2.4)
dynamic_form (1.1.4)
erubis (2.7.0)
eventmachine (1.0.3)
exception_notification (2.6.1)
factory_girl (4.2.0)
factory_girl_rails (4.2.1)
faker (0.3.1)
fastthread (1.0.7)
faye-websocket (0.4.7)
gchartrb (0.8)
gherkin (2.12.0)
gli (2.5.6)
hashie (2.0.4)
hike (1.2.2)
http_parser.rb (0.5.3)
human_attribute (0.2.0)
i18n (0.6.1)
icalendar (1.3.0)
io-console (0.3)
journey (1.0.4)
jquery-rails (2.2.1)
json (1.7.7, 1.5.5)
launchy (2.3.0)
localeapp (0.6.9)
machinist (1.0.6)
mail (2.5.3)
metaclass (0.0.1)
mime-types (1.23)
minitest (2.5.1)
mocha (0.13.3)
multi_json (1.7.2)
mysql (2.9.1)
mysql2 (0.3.11)
net-ldap (0.3.1)
nokogiri (1.5.9)
orm_adapter (0.4.0)
paperclip (3.4.1)
passenger (4.0.2)
pg (0.15.1)
poltergeist (1.2.0)
polyglot (0.3.3)
rack (1.4.5, 1.1.6)
rack-cache (1.2)
rack-ssl (1.3.3)
rack-test (0.6.2)
rails (2.3.8)
railties (3.2.13)
rake (0.8.7)
rdoc (3.12.2, 3.9.5)
rdoc-data (3.12)
RedCloth (4.2.9)
remotipart (1.0.5)
rest-client (1.6.7)
rspec (2.13.0)
rspec-core (2.13.1)
rspec-expectations (2.13.0)
rspec-mocks (2.13.1)
rspec-rails (2.13.0)
ruby-prof (0.13.0)
rubygems-bundler (1.1.1)
rubygems-update (2.0.3)
rufus-scheduler (2.0.18)
rvm (1.11.3.7)
sass (3.2.8)
sass-rails (3.2.6)
shoulda (3.4.0)
shoulda-context (1.1.1)
shoulda-matchers (1.5.6)
simplecov (0.7.1)
simplecov-html (0.7.1)
spork (0.9.2)
sprockets (2.2.2)
sqlite3 (1.3.7)
thor (0.18.1)
tilt (1.3.7)
timecop (0.6.1)
treetop (1.4.12)
tzinfo (0.3.37)
v (0.1.1)
warden (1.2.1)
will_paginate (3.0.4)
xpath (2.0.0)
ya2yaml (0.31)

[badb...@gmx.de]

i did solve that error by myself, if found out that i have to use this version gem install rubygems-update -v 1.3.6
and then update it to old ruby version , now the rake db:migration script is starting and all packages are available but during running it get this error
has someone an idea? or a hint which versions i should try

[root@ebitst20 jobsworth-master]# rake db:migrate --trace
(in /jobsworth/jobsworth-master)
** Invoke db:migrate (first_time)
** Invoke environment (first_time)
** Execute environment
** Erubis 2.6.5
** Execute db:migrate
==  CopyTaskOwnerToWatcher: migrating =========================================
-- Copying task creators to watchers.
rake aborted!
An error has occurred, all later migrations canceled:

uninitialized constant CopyTaskOwnerToWatcher::Notification
/usr/local/rvm/gems/ruby-1.9.1-p431/gems/activesupport-2.3.8/lib/active_support/dependencies.rb:105:in `rescue in const_missing'
/usr/local/rvm/gems/ruby-1.9.1-p431/gems/activesupport-2.3.8/lib/active_support/dependencies.rb:94:in `const_missing'
/jobsworth/jobsworth-master/db/migrate/20081207130300_copy_task_owner_to_watcher.rb:7:in `block (2 levels) in up'
/jobsworth/jobsworth-master/db/migrate/20081207130300_copy_task_owner_to_watcher.rb:6:in `each'
/jobsworth/jobsworth-master/db/migrate/20081207130300_copy_task_owner_to_watcher.rb:6:in `block in up'
/usr/local/rvm/gems/ruby-1.9.1-p431/gems/activerecord-2.3.8/lib/active_record/migration.rb:328:in `block in say_with_time'
/usr/local/rvm/rubies/ruby-1.9.1-p431/lib/ruby/1.9.1/benchmark.rb:294:in `measure'
/usr/local/rvm/gems/ruby-1.9.1-p431/gems/activerecord-2.3.8/lib/active_record/migration.rb:328:in `say_with_time'
/jobsworth/jobsworth-master/db/migrate/20081207130300_copy_task_owner_to_watcher.rb:5:in `up'
/usr/local/rvm/gems/ruby-1.9.1-p431/gems/activerecord-2.3.8/lib/active_record/migration.rb:282:in `block in migrate'
/usr/local/rvm/rubies/ruby-1.9.1-p431/lib/ruby/1.9.1/benchmark.rb:294:in `measure'
/usr/local/rvm/gems/ruby-1.9.1-p431/gems/activerecord-2.3.8/lib/active_record/migration.rb:282:in `migrate'
/usr/local/rvm/gems/ruby-1.9.1-p431/gems/activerecord-2.3.8/lib/active_record/migration.rb:365:in `migrate'
/usr/local/rvm/gems/ruby-1.9.1-p431/gems/activerecord-2.3.8/lib/active_record/migration.rb:491:in `block (2 levels) in migrate'
/usr/local/rvm/gems/ruby-1.9.1-p431/gems/activerecord-2.3.8/lib/active_record/migration.rb:567:in `call'
/usr/local/rvm/gems/ruby-1.9.1-p431/gems/activerecord-2.3.8/lib/active_record/migration.rb:567:in `ddl_transaction'
/usr/local/rvm/gems/ruby-1.9.1-p431/gems/activerecord-2.3.8/lib/active_record/migration.rb:490:in `block in migrate'
/usr/local/rvm/gems/ruby-1.9.1-p431/gems/activerecord-2.3.8/lib/active_record/migration.rb:477:in `each'
/usr/local/rvm/gems/ruby-1.9.1-p431/gems/activerecord-2.3.8/lib/active_record/migration.rb:477:in `migrate'
/usr/local/rvm/gems/ruby-1.9.1-p431/gems/activerecord-2.3.8/lib/active_record/migration.rb:401:in `up'
/usr/local/rvm/gems/ruby-1.9.1-p431/gems/activerecord-2.3.8/lib/active_record/migration.rb:383:in `migrate'
/usr/local/rvm/gems/ruby-1.9.1-p431/gems/rails-2.3.8/lib/tasks/databases.rake:112:in `block (2 levels) in <top (required)>'
/usr/local/rvm/gems/ruby-1.9.1-p431/gems/rake-0.8.7/lib/rake.rb:636:in `call'
/usr/local/rvm/gems/ruby-1.9.1-p431/gems/rake-0.8.7/lib/rake.rb:636:in `block in execute'
/usr/local/rvm/gems/ruby-1.9.1-p431/gems/rake-0.8.7/lib/rake.rb:631:in `each'
/usr/local/rvm/gems/ruby-1.9.1-p431/gems/rake-0.8.7/lib/rake.rb:631:in `execute'
/usr/local/rvm/gems/ruby-1.9.1-p431/gems/rake-0.8.7/lib/rake.rb:597:in `block in invoke_with_call_chain'
/usr/local/rvm/rubies/ruby-1.9.1-p431/lib/ruby/1.9.1/monitor.rb:190:in `mon_synchronize'
/usr/local/rvm/gems/ruby-1.9.1-p431/gems/rake-0.8.7/lib/rake.rb:590:in `invoke_with_call_chain'
/usr/local/rvm/gems/ruby-1.9.1-p431/gems/rake-0.8.7/lib/rake.rb:583:in `invoke'
/usr/local/rvm/gems/ruby-1.9.1-p431/gems/rake-0.8.7/lib/rake.rb:2051:in `invoke_task'
/usr/local/rvm/gems/ruby-1.9.1-p431/gems/rake-0.8.7/lib/rake.rb:2029:in `block (2 levels) in top_level'
/usr/local/rvm/gems/ruby-1.9.1-p431/gems/rake-0.8.7/lib/rake.rb:2029:in `each'
/usr/local/rvm/gems/ruby-1.9.1-p431/gems/rake-0.8.7/lib/rake.rb:2029:in `block in top_level'
/usr/local/rvm/gems/ruby-1.9.1-p431/gems/rake-0.8.7/lib/rake.rb:2068:in `standard_exception_handling'
/usr/local/rvm/gems/ruby-1.9.1-p431/gems/rake-0.8.7/lib/rake.rb:2023:in `top_level'
/usr/local/rvm/gems/ruby-1.9.1-p431/gems/rake-0.8.7/lib/rake.rb:2001:in `block in run'
/usr/local/rvm/gems/ruby-1.9.1-p431/gems/rake-0.8.7/lib/rake.rb:2068:in `standard_exception_handling'
/usr/local/rvm/gems/ruby-1.9.1-p431/gems/rake-0.8.7/lib/rake.rb:1998:in `run'
/usr/local/rvm/gems/ruby-1.9.1-p431/gems/rake-0.8.7/bin/rake:31:in `<top (required)>'
/usr/local/rvm/gems/ruby-1.9.1-p431/bin/rake:19:in `load'
/usr/local/rvm/gems/ruby-1.9.1-p431/bin/rake:19:in `<main>'
/usr/local/rvm/gems/ruby-1.9.1-p431/bin/ruby_noexec_wrapper:14:in `eval'
/usr/local/rvm/gems/ruby-1.9.1-p431/bin/ruby_noexec_wrapper:14:in `<main>'

*** LOCAL GEMS ***

abstract (1.0.0)
actionmailer (2.3.8)
actionpack (2.3.8)
activerecord (2.3.8)
activerecord-mysql2-adapter (0.0.3)
activeresource (2.3.8)
activesupport (2.3.8)
acts_as_list (0.2.0)
acts_as_tree (0.1.1)
arel (3.0.2)
builder (3.0.4)
bullet (1.7.6)
bundler (1.3.5)
daemons (1.1.0)
erubis (2.6.5)
eventmachine (1.0.3)
gchartrb (0.8)
hike (1.2.2)
hoe (3.6.1)
i18n (0.4.1, 0.4.0)
icalendar (1.1.5)
journey (1.0.4)
jquery-rails (0.2.4)
json (1.8.0)
mail (2.5.4)
mime-types (1.23)
multi_json (1.7.3)
mysql (2.9.1)
mysql2 (0.2.4)
paperclip (2.3.3)

polyglot (0.3.3)
rack (1.4.5, 1.1.6)
rack-cache (1.2)
rack-ssl (1.3.3)
rack-test (0.6.2)
rails (2.3.8)
railties (3.2.13)
rake (0.8.7)

rdoc (3.12.2)
rdoc-data (3.12)
RedCloth (4.2.3)
rubygems-bundler (1.1.1)
rubygems-update (1.6.1, 1.5.0, 1.4.2, 1.3.5)
rvm (1.11.3.7)
smurf (1.0.4)
splattael-activerecord_base_without_table (0.1.1)
sprockets (2.2.2)
test-unit (1.2.3)
thor (0.18.1)
tilt (1.4.1)
treetop (1.4.12)
tzinfo (0.3.37)
uniform_notifier (1.2.0)
will_paginate (2.3.14)

[badb...@gmx.de]

thanks for the good tipp ....

there is a log file which shows me the error detailed, i though it was an environment problem, but it is a database migration problem. Now
i'm thinking how to fix this problem. I would be wunderful i some body has an idea or tipp for me

Migrating to CopyTaskOwnerToWatcher (20081207130300)
  [4;36;1mLocale Load (0.2ms)[0m   [0;1mSELECT * FROM `locales` WHERE (locales.locale = '--- :default\n' AND locales.key = 'last') LIMIT 1[0m
  [4;35;1mTask Load (3.6ms)[0m   [0mSELECT * FROM `tasks` [0m

Am Donnerstag, 9. Mai 2013 10:42:44 UTC+2 schrieb badb...@gmx.de: