Upgrade

[dyoung]

Just looking for verification.
To upgrade to 1.7.1, I would do a git pull form my zuluru home directory. (like the original install)
Then I would go to following url [zuluru_base]/install/upgrade, which will update the database tables.

This is what is in the README file and I want to make sure it is just that easy.

[GregS]

Should be [zuluru_base]/install/install/update (two installs, plus update instead of upgrade), but other than that, you're bang on. I use this on a regular basis to keep all of my hosted sites in sync after any code changes.

[dyoung]

Well, in my [zuluru_base] directory I did:
git init
git config remote.origin.url git://github.com/Zuluru/Zuluru.git
git pull

I got the following:

remote: Counting objects: 260, done.
remote: Compressing objects: 100% (134/134), done.
remote: Total 189 (delta 133), reused 107 (delta 53)
Receiving objects: 100% (189/189), 113.37 KiB, done.
Resolving deltas: 100% (133/133), completed with 57 local objects.
From git://github.com/Zuluru/Zuluru
* branch HEAD -> FETCH_HEAD
Updating 3c4f8e2..5185199
Fast-forward
app_controller.php | 126 ++++---
config/schema/schema.php | 9 +
config/version.php | 6 +-
controllers/components/user_cache.php | 78 +++-
controllers/events_controller.php | 16 +-
controllers/games_controller.php | 53 ++-
controllers/people_controller.php | 213 ++++++++++-
controllers/questions_controller.php | 3 +-
controllers/registrations_controller.php | 18 +-
controllers/task_slots_controller.php | 7 +-
controllers/tasks_controller.php | 16 +-
controllers/team_events_controller.php | 113 +++++-
controllers/teams_controller.php | 47 +--
models/person.php | 8 +
views/all/splash.ctp | 760 ++++++++++++++++++++-------------------
views/elements/all/kickstart.ctp | 184 ++++++++++
views/elements/email/html/relative_add.ctp | 16 +
views/elements/email/html/relative_approve.ctp | 6 +
views/elements/email/html/relative_remove.ctp | 7 +
views/elements/email/text/relative_add.ctp | 21 ++
views/elements/email/text/relative_approve.ctp | 9 +
views/elements/email/text/relative_remove.ctp | 11 +
views/elements/events/list.ctp | 31 +-
views/elements/games/splash.ctp | 164 +++++++++
views/elements/help/games/recent_and_upcoming.ctp | 9 +-
views/elements/help/settings/feature/twitter.ctp | 10 +-
views/elements/help/waivers/edit/text.ctp | 32 +-
views/elements/leagues/block.ctp | 5 +-
views/elements/people/number.ctp | 4 +-
views/elements/people/roster_position.ctp | 5 +-
views/elements/people/roster_role.ctp | 5 +-
views/elements/people/search_results.ctp | 5 +-
views/elements/questionnaires/edit.ctp | 18 +-
views/elements/selector.ctp | 44 +++
views/elements/selector_classes.ctp | 11 +
views/elements/settings/banner.ctp | 16 +-
views/elements/tasks/splash.ctp | 39 ++
views/elements/teams/splash.ctp | 50 +++
views/events/index.ctp | 50 ++-
views/games/add_score.ctp | 4 +-
views/games/delete_score.ctp | 4 +-
views/helpers/zuluru_jquery_engine.php | 12 +-
views/leagues/index.ctp | 32 +-
views/people/add_relative.ctp | 26 ++
views/people/registrations.ctp | 33 +-
views/people/teams.ctp | 49 ++-
views/people/view.ctp | 93 ++++-
views/questions/autocomplete.ctp | 8 +-
views/registrations/statistics.ctp | 73 +++-
views/task_slots/ical.ctp | 4 +-
views/teams/numbers_ajax.ctp | 16 +-
webroot/css/zuluru/layout.css | 14 +
webroot/js/jquery.autocomplete.js | 808 ------------------------------------------
webroot/js/questionnaire.js | 4 +-
54 files changed, 1958 insertions(+), 1447 deletions(-)
create mode 100755 views/elements/all/kickstart.ctp
create mode 100755 views/elements/email/html/relative_add.ctp
create mode 100755 views/elements/email/html/relative_approve.ctp
create mode 100755 views/elements/email/html/relative_remove.ctp
create mode 100755 views/elements/email/text/relative_add.ctp
create mode 100755 views/elements/email/text/relative_approve.ctp
create mode 100755 views/elements/email/text/relative_remove.ctp
create mode 100755 views/elements/games/splash.ctp
create mode 100755 views/elements/selector.ctp
create mode 100755 views/elements/selector_classes.ctp
create mode 100755 views/elements/tasks/splash.ctp
create mode 100755 views/elements/teams/splash.ctp
create mode 100755 views/people/add_relative.ctp
delete mode 100755 webroot/js/jquery.autocomplete.js

When I go to [zuluru_base]/install/install/update I get :

[GregS]

That's really bizarre. views/elements/notice.ctp should not be used at all for anything install-related. Can you take a look in the system log and see if the update page maybe generated a redirect to some other page? I can't think why it would do that, but I can't think of any other explanation right now for this error. Also, maybe just try the update page again, if you haven't already; there's an outside chance that it might be somehow related to the notice display itself, which probably wouldn't recur if you loaded it again.

[dyoung]

I have tried updating the page numerous times with no luck.
For grins I did a "sudo chown -R (html_user):(html_group) * " to make sure any new files have the right user.
The only log file that I see anything in is the /var/log/apache2/access.log. When I refresh the page I get:
127.0.0.1 - - [13/Dec/2013:23:03:37 -0500] "GET /nvjcyo/install/install/update HTTP/1.1" 500 3934 "-" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:25.0) Gecko/20100101 Firefox/25.0"
127.0.0.1 - - [13/Dec/2013:23:03:37 -0500] "GET /nvjcyo/css/zuluru/layout.css HTTP/1.1" 304 226 "http://localhost/nvjcyo/install/install/update" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:25.0) Gecko/20100101 Firefox/25.0"
127.0.0.1 - - [13/Dec/2013:23:03:37 -0500] "GET /nvjcyo/css/zuluru/look.css HTTP/1.1" 304 225 "http://localhost/nvjcyo/install/install/update" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:25.0) Gecko/20100101 Firefox/25.0"
127.0.0.1 - - [13/Dec/2013:23:03:37 -0500] "GET /nvjcyo/css/cssplay_flyout_ltr.css HTTP/1.1" 304 224 "http://localhost/nvjcyo/install/install/update" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:25.0) Gecko/20100101 Firefox/25.0"
127.0.0.1 - - [13/Dec/2013:23:03:37 -0500] "GET /nvjcyo/css/zuluru/debug.css HTTP/1.1" 304 224 "http://localhost/nvjcyo/install/install/update" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:25.0) Gecko/20100101 Firefox/25.0"
127.0.0.1 - - [13/Dec/2013:23:03:37 -0500] "GET /nvjcyo/js/tooltip.js HTTP/1.1" 304 224 "http://localhost/nvjcyo/install/install/update" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:25.0) Gecko/20100101 Firefox/25.0"
127.0.0.1 - - [13/Dec/2013:23:03:37 -0500] "GET /nvjcyo/js/placeholder.js HTTP/1.1" 304 224 "http://localhost/nvjcyo/install/install/update" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:25.0) Gecko/20100101 Firefox/25.0"
127.0.0.1 - - [13/Dec/2013:23:03:37 -0500] "GET /nvjcyo/img/facebook.png HTTP/1.1" 304 201 "http://localhost/nvjcyo/install/install/update" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:25.0) Gecko/20100101 Firefox/25.0"

I tar'd my directory and backed up my database before I did the update. Any suggestions on how to move forward would be greatly appreciated. (If you are looking to "fool proof" your software, I know I can help. )

[GregS]

I'm wondering if it's related to the fact that you've got Zuluru in a sub-folder (nvjcyo). Or at least, that's how it looks from the log. Is that right? You're accessing the Zuluru "home page" through http://example.com/nvjcyo, and the install through http://example.com/nvjcyo/install/install/update? Anything helpful in zuluru/tmp/logs/error.log?

[dyoung]

Yes, it is in the nvjcyo directory and that is how I am accessing the update page. I changed the directory name back to zuluru and I still get the same error.
I looked in the zuluru/tmp/log/error.log and found nothing. The last few lines are:
2013-12-08 21:50:49 Warning: Warning (2): array_key_exists() expects parameter 2 to be array, null given in [/var/www/nvjcyo/controllers/components/sport.php, line 388]
2013-12-08 21:50:49 Warning: Warning (2): array_key_exists() expects parameter 2 to be array, null given in [/var/www/nvjcyo/controllers/components/sport.php, line 388]
2013-12-09 10:23:46 Warning: Warning (2): Illegal string offset 'action' in [/var/www/nvjcyo/controllers/divisions_controller.php, line 1803]

[GregS]

I don't know that I've tested installation in a subfolder, so I'll have to give that a try here and see if I can replicate the problem. Won't happen tonight or tomorrow, maybe Sunday or Monday. In the meantime, you could just manually execute this query to create the new table:

Code: Select all

CREATE TABLE `people_people` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `person_id` int(11) NOT NULL DEFAULT '0',
  `relative_id` int(11) NOT NULL DEFAULT '0',
  `approved` tinyint(1) NOT NULL DEFAULT '0',
  `created` date DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `person` (`person_id`),
  KEY `relative` (`relative_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

and increment the schema version number in config/installed.php. This is all that the automatic update would be doing for this round anyway.

[dyoung]

New Error:

install_error.png (35.52 KiB) Viewed 334346 times

[GregS]

If you've created the table manually, there's no need to run the update process any more. Just proceed with use as normal!