More problems

5 views
Skip to first unread message

Keith Instone

unread,
Nov 1, 2016, 9:23:43 AM11/1/16
to tol-ca...@googlegroups.com
I am noticing more problems, and more serious ones, with the new version.

1. NONE of the “tags” on events were migrated. I used tags a lot to connect series of events together. Example: http://old.toledotechevents.org/events/search?tag=coderdojo

This is a MAJOR bummer for me. Really makes the calendar less useful to show the history of the community. Can we get those tags back in the new version or do I have to spend HOURS editing?

2. When you edit an event, it changes the date to TODAY. It does not keep the date and time that is already assigned to the event. Maybe that is part of the JS snafu, not sure. But it means editing an event is very risky.

Until #2 is fixed, then I cannot afford to make other corrections. Too painful to have to set the date just to make a small change to an event.

3. Events just disappeared. There used to be 4 events for the B&N Maker Faire, but 2 disappeared. I added the 2 missing ones, but it was painful. Greg Miller noticed other things like this. Maybe it was part of the migration, maybe it was a person doing it, maybe it was some sort of spam detection (e.g., delete events that have duplicate descriptions - in my case, the descriptions were the same, for a good reason).

Keith


Jason Slagle

unread,
Nov 1, 2016, 10:04:39 AM11/1/16
to tol-ca...@googlegroups.com
I'll look at the tags and see if I can see what happened.

I took a DB dump 30 minutes before I brought the new site online, so I'd only expect anything edited in that window to be missing.  Can you give examples of anything else missing?

The tag data is IN the database:  calagator@localhost [calagator]> select * from taggings where tag_id = 610;
+------+--------+-------------+---------------+-----------+-------------+---------+---------------------+
| id   | tag_id | taggable_id | taggable_type | tagger_id | tagger_type | context | created_at          |
+------+--------+-------------+---------------+-----------+-------------+---------+---------------------+
| 3169 |    610 |        1502 | Event         |      NULL | NULL        | tags    | 2015-06-02 14:57:53 |
| 3189 |    610 |        1516 | Event         |      NULL | NULL        | tags    | 2015-06-12 10:28:44 |
| 3190 |    610 |        1521 | Event         |      NULL | NULL        | tags    | 2015-06-14 13:07:14 |
| 3191 |    610 |        1522 | Event         |      NULL | NULL        | tags    | 2015-06-14 13:08:39 |
| 3192 |    610 |        1523 | Event         |      NULL | NULL        | tags    | 2015-06-14 13:08:54 |
| 3193 |    610 |        1524 | Event         |      NULL | NULL        | tags    | 2015-06-14 13:09:08 |
| 3194 |    610 |        1525 | Event         |      NULL | NULL        | tags    | 2015-06-14 13:09:19 |
| 3292 |    610 |        1575 | Event         |      NULL | NULL        | tags    | 2015-07-28 18:23:38 |
| 3294 |    610 |        1577 | Event         |      NULL | NULL        | tags    | 2015-07-28 18:25:11 |
| 3295 |    610 |        1578 | Event         |      NULL | NULL        | tags    | 2015-07-28 18:25:24 |
| 3296 |    610 |        1579 | Event         |      NULL | NULL        | tags    | 2015-07-28 18:25:37 |
| 3458 |    610 |        1655 | Event         |      NULL | NULL        | tags    | 2015-08-24 20:00:19 |
| 3459 |    610 |        1656 | Event         |      NULL | NULL        | tags    | 2015-08-24 20:00:37 |
| 3460 |    610 |        1657 | Event         |      NULL | NULL        | tags    | 2015-08-24 20:00:48 |
| 3461 |    610 |        1658 | Event         |      NULL | NULL        | tags    | 2015-08-24 20:01:00 |
| 3615 |    610 |        1713 | Event         |      NULL | NULL        | tags    | 2015-10-03 15:54:04 |
| 3618 |    610 |        1715 | Event         |      NULL | NULL        | tags    | 2015-10-11 13:37:06 |
| 3619 |    610 |        1716 | Event         |      NULL | NULL        | tags    | 2015-10-11 13:37:18 |
| 3620 |    610 |        1717 | Event         |      NULL | NULL        | tags    | 2015-10-11 13:37:42 |
| 3621 |    610 |        1718 | Event         |      NULL | NULL        | tags    | 2015-10-11 13:38:17 |
| 3622 |    610 |        1719 | Event         |      NULL | NULL        | tags    | 2015-10-11 13:38:43 |
| 3623 |    610 |        1720 | Event         |      NULL | NULL        | tags    | 2015-10-11 13:39:08 |
| 3624 |    610 |        1721 | Event         |      NULL | NULL        | tags    | 2015-10-11 13:39:39 |
| 3625 |    610 |        1722 | Event         |      NULL | NULL        | tags    | 2015-10-11 13:40:23 |
| 3626 |    610 |        1723 | Event         |      NULL | NULL        | tags    | 2015-10-11 13:40:43 |
| 3803 |    610 |        1796 | Event         |      NULL | NULL        | tags    | 2015-12-14 01:57:40 |
| 3804 |    610 |        1797 | Event         |      NULL | NULL        | tags    | 2015-12-14 01:58:14 |
| 3805 |    610 |        1798 | Event         |      NULL | NULL        | tags    | 2015-12-14 01:58:46 |
| 3806 |    610 |        1799 | Event         |      NULL | NULL        | tags    | 2015-12-14 01:59:15 |
| 3807 |    610 |        1800 | Event         |      NULL | NULL        | tags    | 2015-12-14 01:59:35 |
| 3880 |    610 |        1850 | Event         |      NULL | NULL        | tags    | 2016-02-04 16:18:31 |
| 3937 |    610 |        1870 | Event         |      NULL | NULL        | tags    | 2016-02-17 13:09:09 |
| 3938 |    610 |        1871 | Event         |      NULL | NULL        | tags    | 2016-02-17 13:09:21 |
| 3939 |    610 |        1872 | Event         |      NULL | NULL        | tags    | 2016-02-17 13:09:33 |
| 3979 |    610 |        1901 | Event         |      NULL | NULL        | tags    | 2016-03-04 21:17:42 |
| 3980 |    610 |        1902 | Event         |      NULL | NULL        | tags    | 2016-03-04 21:17:54 |
| 3981 |    610 |        1903 | Event         |      NULL | NULL        | tags    | 2016-03-04 21:18:05 |
| 4022 |    610 |        1930 | Event         |      NULL | NULL        | tags    | 2016-03-24 16:18:33 |
| 4023 |    610 |        1931 | Event         |      NULL | NULL        | tags    | 2016-03-24 16:18:45 |
| 4024 |    610 |        1932 | Event         |      NULL | NULL        | tags    | 2016-03-24 16:18:55 |
| 4025 |    610 |        1933 | Event         |      NULL | NULL        | tags    | 2016-03-24 16:19:05 |
| 4026 |    610 |        1934 | Event         |      NULL | NULL        | tags    | 2016-03-24 16:19:16 |
| 4285 |    610 |        2122 | Event         |      NULL | NULL        | tags    | 2016-04-26 13:32:57 |
| 4286 |    610 |        2123 | Event         |      NULL | NULL        | tags    | 2016-04-26 13:33:10 |
| 4287 |    610 |        2124 | Event         |      NULL | NULL        | tags    | 2016-04-26 13:33:21 |
| 4288 |    610 |        2125 | Event         |      NULL | NULL        | tags    | 2016-04-26 13:33:33 |
| 4289 |    610 |        2126 | Event         |      NULL | NULL        | tags    | 2016-04-26 13:33:46 |
| 4290 |    610 |        2127 | Event         |      NULL | NULL        | tags    | 2016-04-26 13:33:58 |
| 4291 |    610 |        2128 | Event         |      NULL | NULL        | tags    | 2016-04-26 13:34:12 |
| 4293 |    610 |        2121 | Event         |      NULL | NULL        | tags    | 2016-04-26 13:35:00 |
| 5026 |    610 |        2295 | Event         |      NULL | NULL        | tags    | 2016-07-02 17:03:40 |
| 5027 |    610 |        2296 | Event         |      NULL | NULL        | tags    | 2016-07-02 17:03:52 |
| 5028 |    610 |        2297 | Event         |      NULL | NULL        | tags    | 2016-07-02 17:04:01 |
| 5029 |    610 |        2298 | Event         |      NULL | NULL        | tags    | 2016-07-02 17:04:10 |
| 5261 |    610 |        2406 | Event         |      NULL | NULL        | tags    | 2016-07-30 21:12:05 |
| 5262 |    610 |        2407 | Event         |      NULL | NULL        | tags    | 2016-07-30 21:12:17 |
| 5263 |    610 |        2408 | Event         |      NULL | NULL        | tags    | 2016-07-30 21:12:29 |
| 5264 |    610 |        2409 | Event         |      NULL | NULL        | tags    | 2016-07-30 21:12:47 |
| 5265 |    610 |        2410 | Event         |      NULL | NULL        | tags    | 2016-07-30 21:13:01 |
| 5266 |    610 |        2411 | Event         |      NULL | NULL        | tags    | 2016-07-30 21:13:13 |
| 5267 |    610 |        2412 | Event         |      NULL | NULL        | tags    | 2016-07-30 21:13:55 |
| 5687 |    610 |        2643 | Event         |      NULL | NULL        | tags    | 2016-09-28 21:26:17 |
| 5704 |    610 |        2652 | Event         |      NULL | NULL        | tags    | 2016-10-01 17:30:44 |
| 5752 |    610 |        2676 | Event         |      NULL | NULL        | tags    | 2016-10-10 14:57:37 |
| 5760 |    610 |        2684 | Event         |      NULL | NULL        | tags    | 2016-10-18 15:09:33 |
| 5761 |    610 |        2685 | Event         |      NULL | NULL        | tags    | 2016-10-18 15:09:43 |
| 5762 |    610 |        2686 | Event         |      NULL | NULL        | tags    | 2016-10-18 15:09:53 |
| 5763 |    610 |        2687 | Event         |      NULL | NULL        | tags    | 2016-10-18 15:10:03 |
+------+--------+-------------+---------------+-----------+-------------+---------+---------------------+

Does techtoledo have a slack we can loiter in and discuss?  If not I can spin up a toledotechevents one.

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

Patrick McSweeny

unread,
Nov 1, 2016, 10:09:06 AM11/1/16
to tol-ca...@googlegroups.com
I uploaded a change to fix the issue with editing events.

To unsubscribe from this group and stop receiving emails from it, send an email to tol-calagator+unsubscribe@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "tol-calagator" group.
To unsubscribe from this group and stop receiving emails from it, send an email to tol-calagator+unsubscribe@googlegroups.com.

Chris Wammes

unread,
Nov 1, 2016, 10:10:30 AM11/1/16
to tol-calagator
If we can't get the tags pulled in I can look into creating a script to update all events with the tags from the old system.  Would just take some time to develop/test.

Chris

Jason Slagle

unread,
Nov 1, 2016, 10:17:08 AM11/1/16
to tol-ca...@googlegroups.com
I see what happened:

SELECT `events`.* FROM `events` JOIN taggings events_taggings_8cd5b34  ON events_taggings_8cd5b34.taggable_id = events.id AND events_taggings_8cd5b34.taggable_type = 'Calagator::Event' AND events_taggings_8cd5b34.tag_id = 610  ORDER BY start_time

Apparently taggable_type is the Ruby object type, which was previously Event.

Low and behold, we have tags.

I also bounced unicorn, which should bring Patricks changes into play.

Patrick McSweeny

unread,
Nov 1, 2016, 10:29:57 AM11/1/16
to tol-ca...@googlegroups.com
Jason, bounce unicorn again when you get a second, there was a few things I forgot to upload.

To unsubscribe from this group and stop receiving emails from it, send an email to tol-calagator+unsubscribe@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "tol-calagator" group.
To unsubscribe from this group and stop receiving emails from it, send an email to tol-calagator+unsubscribe@googlegroups.com.

Jason Slagle

unread,
Nov 1, 2016, 10:48:50 AM11/1/16
to tol-ca...@googlegroups.com
Done.  FYI, if you do ps -auxww|grep unicorn and just kill the production workers, it will respawn them.

Patrick McSweeny

unread,
Nov 1, 2016, 1:12:26 PM11/1/16
to tol-ca...@googlegroups.com
I tried that but it doesn't look like the process respawned and now the website is down.

To unsubscribe from this group and stop receiving emails from it, send an email to tol-calagator+unsubscribe@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "tol-calagator" group.
To unsubscribe from this group and stop receiving emails from it, send an email to tol-calagator+unsubscribe@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "tol-calagator" group.
To unsubscribe from this group and stop receiving emails from it, send an email to tol-calagator+unsubscribe@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "tol-calagator" group.
To unsubscribe from this group and stop receiving emails from it, send an email to tol-calagator+unsubscribe@googlegroups.com.

Jason Slagle

unread,
Nov 1, 2016, 1:29:48 PM11/1/16
to tol-ca...@googlegroups.com
You killed the master :)

I restarted it.
Reply all
Reply to author
Forward
0 new messages