Advertisement

05.19.2008 at 10:47PM PDT, ID: 23416124
[x]
Attachment Details

"Application error Error Message "Rails application failed to start properly"

Asked by danfiggolf in Ruby Scripting Language

Whenever I try to signup on my insoshi installation at www.boabox.com, I get a

"Application error Rails application failed to start properly".

 Although the rest of the application works just fine and it successfully inputs the new user
into the database. I'm not understanding the significance of this error.  Could you please help me in understanding this error? Below is the output of the log file showing my signup with a new email account.Start Free Trial 
1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:
53:
54:
55:
56:
57:
58:
59:
60:
61:
62:
63:
64:
65:
66:
67:
68:
69:
70:
71:
72:
73:
74:
75:
76:
77:
78:
79:
80:
81:
82:
83:
84:
85:
86:
87:
88:
89:
90:
91:
92:
93:
94:
95:
96:
97:
98:
99:
100:
101:
102:
103:
104:
105:
106:
107:
108:
109:
110:
111:
112:
113:
114:
115:
116:
117:
118:
119:
120:
121:
122:
123:
124:
125:
126:
127:
128:
129:
130:
131:
132:
133:
134:
135:
136:
137:
138:
139:
140:
141:
142:
143:
144:
145:
146:
147:
148:
149:
150:
151:
152:
153:
154:
155:
156:
157:
158:
159:
160:
161:
162:
163:
164:
165:
166:
167:
168:
169:
170:
171:
172:
173:
174:
175:
176:
177:
178:
179:
180:
181:
182:
183:
184:
185:
186:
187:
188:
189:
190:
191:
192:
193:
194:
195:
196:
197:
198:
199:
200:
201:
202:
203:
204:
205:
206:
207:
208:
209:
210:
211:
212:
213:
214:
215:
216:
217:
218:
219:
220:
221:
222:
223:
224:
225:
226:
227:
228:
229:
230:
231:
232:
233:
234:
235:
236:
237:
238:
239:
240:
241:
242:
243:
244:
245:
246:
247:
248:
249:
250:
251:
252:
253:
254:
255:
256:
257:
258:
259:
260:
261:
262:
263:
264:
265:
266:
267:
268:
269:
270:
271:
272:
273:
274:
275:
276:
277:
278:
279:
280:
281:
282:
283:
284:
285:
286:
287:
288:
289:
290:
291:
292:
293:
294:
295:
296:
297:
298:
299:
300:
301:
302:
303:
304:
305:
306:
307:
308:
309:
310:
311:
312:
313:
314:
315:
316:
317:
318:
319:
320:
321:
322:
323:
324:
325:
326:
327:
328:
329:
330:
331:
332:
333:
334:
335:
336:
337:
338:
339:
340:
341:
342:
343:
344:
345:
346:
347:
348:
349:
350:
351:
352:
353:
354:
355:
356:
357:
358:
359:
360:
361:
362:
363:
364:
365:
366:
367:
368:
369:
370:
371:
372:
373:
374:
375:
376:
377:
378:
379:
380:
381:
382:
383:
384:
385:
386:
387:
388:
389:
390:
391:
392:
393:
394:
395:
396:
397:
398:
399:
400:
401:
402:
403:
404:
405:
406:
407:
408:
409:
410:
411:
412:
413:
414:
415:
416:
417:
418:
419:
420:
421:
422:
423:
424:
425:
426:
427:
428:
429:
430:
431:
432:
433:
434:
435:
436:
437:
438:
439:
440:
441:
442:
443:
444:
445:
446:
447:
448:
449:
450:
451:
452:
453:
454:
455:
456:
457:
458:
459:
460:
461:
462:
463:
464:
465:
466:
467:
468:
469:
470:
471:
472:
473:
474:
475:
476:
477:
478:
479:
480:
481:
482:
483:
484:
485:
486:
487:
488:
489:
490:
491:
492:
493:
494:
495:
496:
497:
498:
499:
500:
501:
502:
503:
504:
505:
506:
507:
508:
509:
510:
511:
512:
513:
514:
515:
516:
517:
518:
519:
520:
521:
522:
523:
524:
525:
526:
527:
528:
529:
530:
531:
532:
533:
534:
535:
536:
537:
538:
539:
540:
541:
542:
543:
544:
545:
546:
547:
548:
549:
550:
551:
552:
553:
554:
555:
556:
557:
558:
559:
560:
561:
562:
563:
564:
565:
566:
567:
568:
569:
570:
571:
572:
573:
574:
575:
576:
577:
578:
579:
580:
581:
582:
583:
584:
585:
586:
587:
588:
589:
590:
591:
592:
593:
594:
595:
596:
597:
598:
599:
600:
601:
602:
603:
604:
605:
606:
607:
608:
609:
610:
611:
612:
613:
614:
615:
616:
617:
618:
619:
620:
621:
622:
623:
624:
625:
626:
627:
628:
629:
630:
631:
632:
633:
634:
635:
636:
637:
638:
639:
640:
641:
642:
643:
644:
645:
646:
647:
648:
649:
650:
651:
652:
653:
654:
655:
656:
657:
658:
659:
660:
661:
662:
663:
664:
665:
666:
667:
668:
669:
670:
671:
672:
673:
674:
675:
676:
677:
678:
679:
680:
681:
682:
683:
684:
685:
686:
687:
688:
689:
690:
691:
692:
693:
694:
695:
696:
697:
698:
699:
700:
701:
702:
703:
704:
705:
706:
707:
708:
709:
710:
711:
712:
713:
714:
715:
716:
717:
718:
719:
720:
721:
722:
723:
724:
725:
726:
727:
728:
729:
730:
731:
732:
733:
734:
735:
736:
737:
738:
739:
740:
741:
742:
743:
744:
745:

Processing PeopleController#create (for 76.14.127.218 at 2008-05-19
22:20:23) [POST]
  Session ID:
BAh7CDoOcmV0dXJuX3RvIhEvcGVvcGxlL3Nob3ciCmZsYXNoSUM6J0FjdGlv
%0AbkNvbnRyb2xsZXI6OkZsYXNoOjpGbGFzaEhhc2h7AAY6CkB1c2VkewA6DGNz
%0AcmZfaWQiJTFmODkzZTkwYjE2OGUxZTZlZGQzMmQwZmVmMzExMzBm--63bf61a687c661f5c656b66b8c36249a47b98ca8
  Parameters: {"commit"=>"Sign up",
"authenticity_token"=>"6736f644c1b62a0fc926c03eb31df51e2aa31e3c",
"action"=>"create", "controller"=>"people",
"person"=>{"name"=>"mikfig", "password_confirmation"=>"miknik",
"password"=>"miknik", "email"=>"mikfig27@gmail.com"}}
  .[4;36;1mPageView Columns (0.000649).[0m   .[0;1mSHOW FIELDS FROM
`page_views`.[0m
  .[4;35;1mSQL (0.000036).[0m   .[0mBEGIN.[0m
  .[4;36;1mPageView Create (0.000153).[0m   .[0;1mINSERT INTO
`page_views` (`updated_at`, `referer`, `user_agent`, `user_id`,
`request_url`, `created_at`, `ip_address`) VALUES('2008-05-19
22:20:23', 'http://www.boabox.com/signup', 'Mozilla/5.0 (Windows; U;
Windows NT 5.1; en-US; rv:1.8.1.14) Gecko/20080404 Firefox/2.0.0.14',
NULL, '/people', '2008-05-19 22:20:23', '76.14.127.218').[0m
  .[4;35;1mSQL (0.001678).[0m   .[0mCOMMIT.[0m
Cookie set: auth_token=; path=/; expires=Thu, 01 Jan 1970 00:00:00 GMT
  .[4;36;1mSQL (0.000218).[0m   .[0;1mSHOW TABLES.[0m
  .[4;35;1mPerson Columns (0.001011).[0m   .[0mSHOW FIELDS FROM
`people`.[0m
Asked for a remote server ? true, ENV["FERRET_USE_LOCAL_INDEX"] is
nil, looks like we are not the server
Will use local index.
using index in /home/boaboxc/insoshi/index/development/person
default field list: [:description, :name]
  .[4;36;1mSQL (0.000200).[0m   .[0;1mSHOW TABLES.[0m
  .[4;35;1mPreference Load (0.000083).[0m   .[0mSELECT * FROM
`preferences` LIMIT 1.[0m
  .[4;36;1mAnalyzing Preference Load
.[0m   .[0;1mselect_type | key_len | type | Extra | id | possible_keys
| rows | table       | ref | key
 
------------------------------------------------------------------------------------------
   SIMPLE      |         | ALL  |       | 1  |               | 1    |
preferences |     |
.[0m
  .[4;35;1mSQL (0.000031).[0m   .[0mBEGIN.[0m
  .[4;36;1mPerson Load (0.000263).[0m   .[0;1mSELECT * FROM `people`
WHERE (people.email = 'mikfig27@gmail.com') LIMIT 1.[0m
  .[4;35;1mAnalyzing Person Load
.[0m   .[0mselect_type | key_len | type | Extra       | id |
possible_keys         | rows | table  | ref   | key
 
-----------------------------------------------------------------------------------------------------------------------
   SIMPLE      | 768     | ref  | Using where | 1  |
index_people_on_email | 1    | people | const | index_people_on_email
.[0m
  .[4;36;1mBlog Columns (0.000500).[0m   .[0;1mSHOW FIELDS FROM
`blogs`.[0m
  .[4;35;1mBlog Create (0.000329).[0m   .[0mINSERT INTO `blogs`
(`updated_at`, `person_id`, `created_at`) VALUES('2008-05-19
22:20:23', NULL, '2008-05-19 22:20:23').[0m
  .[4;36;1mPerson Create (0.000173).[0m   .[0;1mINSERT INTO `people`
(`blog_comment_notifications`, `connection_notifications`, `name`,
`updated_at`, `wall_comment_notifications`, `crypted_password`,
`wall_comments_count`, `admin`, `remember_token_expires_at`,
`deactivated`, `blog_post_comments_count`, `description`,
`last_contacted_at`, `last_logged_in_at`, `remember_token`,
`forum_posts_count`, `message_notifications`, `created_at`, `email`)
VALUES(1, 1, 'mikfig', '2008-05-19 22:20:23', 1, 'ohyN4/
BJmrpeix2vMZrlZreM3CjDEECvZOTOLCzJX+oR+6TSieSkZXfO9dAM
\neYzwLbf7E0sZJZzCIlK6fRRX9ppSuI3cO/sciT/5DE2RmdKiSu3pJazrlRph
\nKAkt8V9iR1JXiY9O+dpiIgEYqYVssZmuxMzFN23oldiSUR4si54=\n', 0, 0, NULL,
1, 0, NULL, NULL, NULL, NULL, 0, 1, '2008-05-19 22:20:23',
'mikfig27@gmail.com').[0m
ferret_create/update: Person : 7
creating doc for class: Person, id: 7
Adding field description with value '' to index
Adding field name with value 'mikfig' to index
  .[4;35;1mPerson Load (0.000273).[0m   .[0mSELECT * FROM `people`
WHERE (admin = 1) ORDER BY created_at LIMIT 1.[0m
  .[4;36;1mAnalyzing Person Load
.[0m   .[0;1mselect_type | key_len | type |
Extra                       | id | possible_keys         | rows |
table  | ref   | key
 
---------------------------------------------------------------------------------------------------------------------------------------
   SIMPLE      | 1       | ref  | Using where; Using filesort | 1  |
index_people_on_admin | 1    | people | const | index_people_on_admin
.[0m
  .[4;35;1mPreference Load (0.000056).[0m   .[0mSELECT * FROM
`preferences` LIMIT 1.[0m
  .[4;36;1mAnalyzing Preference Load
.[0m   .[0;1mselect_type | key_len | type | Extra | id | possible_keys
| rows | table       | ref | key
 
------------------------------------------------------------------------------------------
   SIMPLE      |         | ALL  |       | 1  |               | 1    |
preferences |     |
.[0m
  .[4;35;1mConnection Columns (0.000570).[0m   .[0mSHOW FIELDS FROM
`connections`.[0m
  .[4;36;1mConnection Load (0.000289).[0m   .[0;1mSELECT * FROM
`connections` WHERE (`connections`.`contact_id` = 1 AND
`connections`.`person_id` = 7) LIMIT 1.[0m
  .[4;35;1mAnalyzing Connection Load
.[0m   .[0mselect_type | key_len | type | Extra       | id |
possible_keys                                 | rows | table       |
ref         | key
 
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
   SIMPLE      | 10      | ref  | Using where | 1  |
index_connections_on_person_id_and_contact_id | 1    | connections |
const,const | index_connections_on_person_id_and_contact_id
.[0m
  .[4;36;1mConnection Create (0.000198).[0m   .[0;1mINSERT INTO
`connections` (`accepted_at`, `status`, `updated_at`, `contact_id`,
`person_id`, `created_at`) VALUES(NULL, 2, '2008-05-19 22:20:23', 1,
7, '2008-05-19 22:20:23').[0m
  .[4;35;1mConnection Create (0.000081).[0m   .[0mINSERT INTO
`connections` (`accepted_at`, `status`, `updated_at`, `contact_id`,
`person_id`, `created_at`) VALUES(NULL, 1, '2008-05-19 22:20:23', 7,
1, '2008-05-19 22:20:23').[0m
  .[4;36;1mConnection Load (0.000145).[0m   .[0;1mSELECT * FROM
`connections` WHERE (`connections`.`contact_id` = 7 AND
`connections`.`person_id` = 1) LIMIT 1.[0m
  .[4;35;1mAnalyzing Connection Load
.[0m   .[0mselect_type | key_len | type | Extra       | id |
possible_keys                                 | rows | table       |
ref         | key
 
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
   SIMPLE      | 10      | ref  | Using where | 1  |
index_connections_on_person_id_and_contact_id | 1    | connections |
const,const | index_connections_on_person_id_and_contact_id
.[0m
  .[4;36;1mSQL (0.000187).[0m   .[0;1mSHOW TABLES.[0m
  .[4;35;1mPreference Load (0.000088).[0m   .[0mSELECT * FROM
`preferences` LIMIT 1.[0m
  .[4;36;1mAnalyzing Preference Load
.[0m   .[0;1mselect_type | key_len | type | Extra | id | possible_keys
| rows | table       | ref | key
 
------------------------------------------------------------------------------------------
   SIMPLE      |         | ALL  |       | 1  |               | 1    |
preferences |     |
.[0m
  .[4;35;1mPerson Load (0.000176).[0m   .[0mSELECT * FROM `people`
WHERE (`people`.`id` = 1) .[0m
  .[4;36;1mAnalyzing Person Load
.[0m   .[0;1mselect_type | key_len | type  | Extra | id |
possible_keys | rows | table  | ref   | key
 
--------------------------------------------------------------------------------------------
   SIMPLE      | 4       | const |       | 1  | PRIMARY       | 1    |
people | const | PRIMARY
.[0m
  .[4;35;1mPerson Load (0.000179).[0m   .[0mSELECT * FROM `people`
WHERE (`people`.`id` = 7) .[0m
  .[4;36;1mAnalyzing Person Load
.[0m   .[0;1mselect_type | key_len | type  | Extra | id |
possible_keys | rows | table  | ref   | key
 
--------------------------------------------------------------------------------------------
   SIMPLE      | 4       | const |       | 1  | PRIMARY       | 1    |
people | const | PRIMARY
.[0m
Sent mail:
 From: Contact request <connection@boabox.com>
 
To: admin@example.com
 
Subject: [insoshi] New contact request
 
Mime-Version: 1.0
 
Content-Type: text/plain; charset=utf-8
 
 
 
You have a new connection request from mikfig:
 
http://www.boabox.com/connections/12/edit
 
To change your email notification preferences, visit
 
http://www.boabox.com/people/1-admin/edit
  .[4;35;1mConnection Load (0.000341).[0m   .[0mSELECT * FROM
`connections` WHERE (`connections`.`contact_id` = 1 AND
`connections`.`person_id` = 7) LIMIT 1.[0m
  .[4;36;1mAnalyzing Connection Load
.[0m   .[0;1mselect_type | key_len | type | Extra       | id |
possible_keys                                 | rows | table       |
ref         | key
 
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
   SIMPLE      | 10      | ref  | Using where | 1  |
index_connections_on_person_id_and_contact_id | 1    | connections |
const,const | index_connections_on_person_id_and_contact_id
.[0m
  .[4;35;1mConnection Update (0.000188).[0m   .[0mUPDATE `connections`
SET `created_at` = '2008-05-19 22:20:23', `status` = 0, `person_id` =
7, `contact_id` = 1, `updated_at` = '2008-05-19 22:20:23',
`accepted_at` = '2008-05-19 22:20:23' WHERE `id` = 11.[0m
  .[4;36;1mConnection Load (0.000171).[0m   .[0;1mSELECT * FROM
`connections` WHERE (`connections`.`contact_id` = 7 AND
`connections`.`person_id` = 1) LIMIT 1.[0m
  .[4;35;1mAnalyzing Connection Load
.[0m   .[0mselect_type | key_len | type | Extra       | id |
possible_keys                                 | rows | table       |
ref         | key
 
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
   SIMPLE      | 10      | ref  | Using where | 1  |
index_connections_on_person_id_and_contact_id | 1    | connections |
const,const | index_connections_on_person_id_and_contact_id
.[0m
  .[4;36;1mConnection Update (0.000132).[0m   .[0;1mUPDATE
`connections` SET `created_at` = '2008-05-19 22:20:23', `status` = 0,
`person_id` = 1, `contact_id` = 7, `updated_at` = '2008-05-19
22:20:23', `accepted_at` = '2008-05-19 22:20:23' WHERE `id` = 12.[0m
  .[4;35;1mConnection Load (0.000161).[0m   .[0mSELECT * FROM
`connections` WHERE (`connections`.`contact_id` = 1 AND
`connections`.`person_id` = 7) LIMIT 1.[0m
  .[4;36;1mAnalyzing Connection Load
.[0m   .[0;1mselect_type | key_len | type | Extra       | id |
possible_keys                                 | rows | table       |
ref         | key
 
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
   SIMPLE      | 10      | ref  | Using where | 1  |
index_connections_on_person_id_and_contact_id | 1    | connections |
const,const | index_connections_on_person_id_and_contact_id
.[0m
  .[4;35;1mSQL (0.000252).[0m   .[0mSHOW TABLES.[0m
  .[4;36;1mPerson Load (0.000385).[0m   .[0;1mSELECT * FROM `people`
WHERE (`people`.`id` = 7) .[0m
  .[4;35;1mAnalyzing Person Load
.[0m   .[0mselect_type | key_len | type  | Extra | id | possible_keys
| rows | table  | ref   | key
 
--------------------------------------------------------------------------------------------
   SIMPLE      | 4       | const |       | 1  | PRIMARY       | 1    |
people | const | PRIMARY
.[0m
  .[4;36;1mActivity Columns (0.000903).[0m   .[0;1mSHOW FIELDS FROM
`activities`.[0m
  .[4;35;1mActivity Create (0.000607).[0m   .[0mINSERT INTO
`activities` (`item_id`, `updated_at`, `public`, `person_id`,
`created_at`, `item_type`) VALUES(11, '2008-05-19 22:20:23', NULL, 7,
'2008-05-19 22:20:23', 'Connection').[0m
  .[4;36;1mPerson Load (0.000401).[0m   .[0;1mSELECT people.* FROM
people INNER JOIN connections ON people.id = connections.contact_id
WHERE ((connections.person_id = 7) AND ((status = 0 AND
 deactivated = 0))) ORDER BY people.created_at DESC.[0m
  .[4;35;1mAnalyzing Person Load
.[0m   .[0mselect_type | key_len | type | Extra
| id | possible_keys                                 | rows |
table       | ref                                        |
key
 
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
   SIMPLE      | 1       | ref  | Using where; Using filesort | 1  |
PRIMARY,index_people_on_deactivated           | 1    | people      |
const                                      |
index_people_on_deactivated
   SIMPLE      | 10      | ref  | Using where                 | 1  |
index_connections_on_person_id_and_contact_id | 1    | connections |
const,boaboxc_insoshiDevelopment.people.id |
index_connections_on_person_id_and_contact_id
.[0m
  .[4;36;1mActivity Load (0.000453).[0m   .[0;1mSELECT activities.*
FROM activities INNER JOIN feeds ON activities.id = feeds.activity_id
WHERE ((feeds.person_id = 1)) ORDER BY created_at DESC LIMIT 10.[0m
  .[4;35;1mAnalyzing Activity Load
.[0m   .[0mselect_type | key_len | type   |
Extra                                                     | id |
possible_keys                            | rows | table      |
ref                                          |
key
 
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
   SIMPLE      | 5       | ref    | Using where; Using index; Using
temporary; Using filesort | 1  |
index_feeds_on_person_id_and_activity_id | 2    | feeds      |
const                                        |
index_feeds_on_person_id_and_activity_id
   SIMPLE      | 4       | eq_ref
|                                                           | 1  |
PRIMARY                                  | 1    | activities |
boaboxc_insoshiDevelopment.feeds.activity_id |
PRIMARY
.[0m
  .[4;36;1mFeed Columns (0.000634).[0m   .[0;1mSHOW FIELDS FROM
`feeds`.[0m
  .[4;35;1mFeed Create (0.000223).[0m   .[0mINSERT INTO `feeds`
(`activity_id`, `person_id`) VALUES(6, 1).[0m
  .[4;36;1mPerson Load (0.000202).[0m   .[0;1mSELECT * FROM `people`
WHERE (`people`.`id` = 1) .[0m
  .[4;35;1mAnalyzing Person Load
.[0m   .[0mselect_type | key_len | type  | Extra | id | possible_keys
| rows | table  | ref   | key
 
--------------------------------------------------------------------------------------------
   SIMPLE      | 4       | const |       | 1  | PRIMARY       | 1    |
people | const | PRIMARY
.[0m
  .[4;36;1mPerson Load (0.000301).[0m   .[0;1mSELECT people.* FROM
people INNER JOIN connections ON people.id = connections.contact_id
WHERE ((connections.person_id = 1) AND ((status = 0 AND
 deactivated = 0))) ORDER BY people.created_at DESC.[0m
  .[4;35;1mAnalyzing Person Load
.[0m   .[0mselect_type | key_len | type | Extra
| id | possible_keys                                 | rows |
table       | ref                                        |
key
 
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
   SIMPLE      | 1       | ref  | Using where; Using filesort | 1  |
PRIMARY,index_people_on_deactivated           | 1    | people      |
const                                      |
index_people_on_deactivated
   SIMPLE      | 10      | ref  | Using where                 | 1  |
index_connections_on_person_id_and_contact_id | 1    | connections |
const,boaboxc_insoshiDevelopment.people.id |
index_connections_on_person_id_and_contact_id
.[0m
  .[4;36;1mConnection Load (0.000144).[0m   .[0;1mSELECT * FROM
`connections` WHERE (`connections`.`contact_id` = 1 AND
`connections`.`person_id` = 7) LIMIT 1.[0m
  .[4;35;1mAnalyzing Connection Load
.[0m   .[0mselect_type | key_len | type | Extra       | id |
possible_keys                                 | rows | table       |
ref         | key
 
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
   SIMPLE      | 10      | ref  | Using where | 1  |
index_connections_on_person_id_and_contact_id | 1    | connections |
const,const | index_connections_on_person_id_and_contact_id
.[0m
  .[4;36;1mBlog Update (0.000161).[0m   .[0;1mUPDATE `blogs` SET
`created_at` = '2008-05-19 22:20:23', `person_id` = 7, `updated_at` =
'2008-05-19 22:20:23' WHERE `id` = 7.[0m
  .[4;35;1mSQL (0.000317).[0m   .[0mCOMMIT.[0m
  .[4;36;1mEmailVerification Columns (0.000722).[0m   .[0;1mSHOW
FIELDS FROM `email_verifications`.[0m
  .[4;35;1mSQL (0.000033).[0m   .[0mBEGIN.[0m
  .[4;36;1mEmailVerification Create (0.000416).[0m   .[0;1mINSERT INTO
`email_verifications` (`updated_at`, `code`, `person_id`,
`created_at`) VALUES('2008-05-19 22:20:23', '9bb462e0-0849-012b-84df-
ffaa462cf309', 7, '2008-05-19 22:20:23').[0m
  .[4;35;1mPerson Load (0.000278).[0m   .[0mSELECT * FROM `people`
WHERE (`people`.`id` = 7) .[0m
  .[4;36;1mAnalyzing Person Load
.[0m   .[0;1mselect_type | key_len | type  | Extra | id |
possible_keys | rows | table  | ref   | key
 
--------------------------------------------------------------------------------------------
   SIMPLE      | 4       | const |       | 1  | PRIMARY       | 1    |
people | const | PRIMARY
.[0m
Sent mail:
 From: Email verification <email@boabox.com>
 
To: mikfig27@gmail.com
 
Subject: [insoshi] Email verification
 
Mime-Version: 1.0
 
Content-Type: text/plain; charset=utf-8
 
 
 
Click here to complete your email verification:
 
http://www.boabox.com/people/verify/9bb462e0-0849-012b-84df-ffaa462cf309
 
Thanks!
  .[4;35;1mSQL (0.000294).[0m   .[0mCOMMIT.[0m
Redirected to http://www.boabox.com/people
Completed in 0.21943 (4 reqs/sec) | DB: 0.01663 (7%) | 302 Found
[http://www.boabox.com/people]
  .[4;36;1mSQL (0.000104).[0m   .[0;1mSET SQL_AUTO_IS_NULL=0.[0m
  .[4;35;1mPreference Load (0.000097).[0m   .[0mSELECT * FROM
`preferences` LIMIT 1.[0m
  .[4;36;1mAnalyzing Preference Load
.[0m   .[0;1mselect_type | key_len | type | Extra | id | possible_keys
| rows | table       | ref | key
 
------------------------------------------------------------------------------------------
   SIMPLE      |         | ALL  |       | 1  |               | 1    |
preferences |     |
.[0m
  .[4;35;1mPreference Columns (0.001194).[0m   .[0mSHOW FIELDS FROM
`preferences`.[0m
 
 
Processing PeopleController#show (for 76.14.127.218 at 2008-05-19
22:22:48) [GET]
  Session ID:
BAh7CDoOcmV0dXJuX3RvIhEvcGVvcGxlL3Nob3ciCmZsYXNoSUM6J0FjdGlv
%0AbkNvbnRyb2xsZXI6OkZsYXNoOjpGbGFzaEhhc2h7AAY6CkB1c2VkewA6DGNz
%0AcmZfaWQiJTFmODkzZTkwYjE2OGUxZTZlZGQzMmQwZmVmMzExMzBm--63bf61a687c661f5c656b66b8c36249a47b98ca8
  Parameters: {"action"=>"show", "id"=>"index",
"controller"=>"people"}
  .[4;36;1mPageView Columns (0.000667).[0m   .[0;1mSHOW FIELDS FROM
`page_views`.[0m
  .[4;35;1mSQL (0.000035).[0m   .[0mBEGIN.[0m
  .[4;36;1mPageView Create (0.000157).[0m   .[0;1mINSERT INTO
`page_views` (`updated_at`, `referer`, `user_agent`, `user_id`,
`request_url`, `created_at`, `ip_address`) VALUES('2008-05-19
22:22:48', NULL, 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:
1.8.1.14) Gecko/20080404 Firefox/2.0.0.14', NULL, '/people/index',
'2008-05-19 22:22:48', '76.14.127.218').[0m
  .[4;35;1mSQL (0.001302).[0m   .[0mCOMMIT.[0m
Redirected to http://www.boabox.com/login
Filter chain halted as
[#<actionController::Filters::ClassMethods::SymbolFilter:0xb75a52a0
@filter=:login_required>] rendered_or_redirected.
Completed in 0.00734 (136 reqs/sec) | DB: 0.00356 (48%) | 302 Found
[http://www.boabox.com/people/index]
  .[4;36;1mSQL (0.000105).[0m   .[0;1mSET SQL_AUTO_IS_NULL=0.[0m
  .[4;35;1mPreference Load (0.000093).[0m   .[0mSELECT * FROM
`preferences` LIMIT 1.[0m
  .[4;36;1mAnalyzing Preference Load
.[0m   .[0;1mselect_type | key_len | type | Extra | id | possible_keys
| rows | table       | ref | key
 
------------------------------------------------------------------------------------------
   SIMPLE      |         | ALL  |       | 1  |               | 1    |
preferences |     |
.[0m
  .[4;35;1mPreference Columns (0.001182).[0m   .[0mSHOW FIELDS FROM
`preferences`.[0m
 
 
Processing SessionsController#new (for 76.14.127.218 at 2008-05-19
22:22:50) [GET]
  Session ID:
BAh7CDoOcmV0dXJuX3RvIhIvcGVvcGxlL2luZGV4IgpmbGFzaElDOidBY3Rp
%0Ab25Db250cm9sbGVyOjpGbGFzaDo6Rmxhc2hIYXNoewY6CmVycm9yIilZb3Ug
%0AbXVzdCBsb2cgaW4gdG8gYWNjZXNzIHRoaXMgcGFnZS4GOgpAdXNlZHsGOwdU
%0AOgxjc3JmX2lkIiUxZjg5M2U5MGIxNjhlMWU2ZWRkMzJkMGZlZjMxMTMwZg%3D
%3D--5787cfbf406386d3389d9a15546c2ab8872a244f
  Parameters: {"action"=>"new", "controller"=>"sessions"}
  .[4;36;1mPageView Columns (0.001036).[0m   .[0;1mSHOW FIELDS FROM
`page_views`.[0m
  .[4;35;1mSQL (0.000037).[0m   .[0mBEGIN.[0m
  .[4;36;1mPageView Create (0.000168).[0m   .[0;1mINSERT INTO
`page_views` (`updated_at`, `referer`, `user_agent`, `user_id`,
`request_url`, `created_at`, `ip_address`) VALUES('2008-05-19
22:22:50', NULL, 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:
1.8.1.14) Gecko/20080404 Firefox/2.0.0.14', NULL, '/login',
'2008-05-19 22:22:50', '76.14.127.218').[0m
  .[4;35;1mSQL (0.000240).[0m   .[0mCOMMIT.[0m
Rendering template within layouts/application
Rendering sessions/new
  .[4;36;1mSQL (0.000290).[0m   .[0;1mSHOW TABLES.[0m
  .[4;35;1mPerson Columns (0.001190).[0m   .[0mSHOW FIELDS FROM
`people`.[0m
Asked for a remote server ? true, ENV["FERRET_USE_LOCAL_INDEX"] is
nil, looks like we are not the server
Will use local index.
using index in /home/boaboxc/insoshi/index/development/person
default field list: [:description, :name]
  .[4;36;1mSQL (0.000249).[0m   .[0;1mSHOW TABLES.[0m
  .[4;35;1mForum Columns (0.000857).[0m   .[0mSHOW FIELDS FROM
`forums`.[0m
  .[4;36;1mSQL (0.000039).[0m   .[0;1mSELECT count(*) AS count_all
FROM `forums` .[0m
  .[4;35;1mAnalyzing
.[0m   .[0mselect_type | key_len | type  | Extra       | id |
possible_keys | rows | table  | ref | key
 
------------------------------------------------------------------------------------------------
   SIMPLE      | 4       | index | Using index | 1  |               |
1    | forums |     | PRIMARY
.[0m
  .[4;36;1mForum Load (0.000040).[0m   .[0;1mSELECT * FROM `forums`
LIMIT 1.[0m
  .[4;35;1mAnalyzing Forum Load
.[0m   .[0mselect_type | key_len | type | Extra | id | possible_keys |
rows | table  | ref | key
 
-------------------------------------------------------------------------------------
   SIMPLE      |         | ALL  |       | 1  |               | 1    |
forums |     |
.[0m
  .[4;36;1mPreference Load (0.000053).[0m   .[0;1mSELECT * FROM
`preferences` LIMIT 1.[0m
  .[4;35;1mAnalyzing Preference Load
.[0m   .[0mselect_type | key_len | type | Extra | id | possible_keys |
rows | table       | ref | key
 
------------------------------------------------------------------------------------------
   SIMPLE      |         | ALL  |       | 1  |               | 1    |
preferences |     |
.[0m
Completed in 0.03836 (26 reqs/sec) | Rendering: 0.02713 (70%) | DB:
0.00558 (14%) | 200 OK [http://www.boabox.com/login]
  .[4;36;1mSQL (0.000104).[0m   .[0;1mSET SQL_AUTO_IS_NULL=0.[0m
  .[4;35;1mPreference Load (0.000105).[0m   .[0mSELECT * FROM
`preferences` LIMIT 1.[0m
  .[4;36;1mAnalyzing Preference Load
.[0m   .[0;1mselect_type | key_len | type | Extra | id | possible_keys
| rows | table       | ref | key
 
------------------------------------------------------------------------------------------
   SIMPLE      |         | ALL  |       | 1  |               | 1    |
preferences |     |
.[0m
  .[4;35;1mPreference Columns (0.001174).[0m   .[0mSHOW FIELDS FROM
`preferences`.[0m
 
 
Processing PeopleController#index (for 76.14.127.218 at 2008-05-19
22:22:59) [GET]
  Session ID:
BAh7CDoOcmV0dXJuX3RvIhIvcGVvcGxlL2luZGV4IgpmbGFzaElDOidBY3Rp
%0Ab25Db250cm9sbGVyOjpGbGFzaDo6Rmxhc2hIYXNoewAGOgpAdXNlZHsAOgxj
%0Ac3JmX2lkIiUxZjg5M2U5MGIxNjhlMWU2ZWRkMzJkMGZlZjMxMTMwZg%3D
%3D--315c29037be04fcbf6ba05ea487711647741668f
  Parameters: {"action"=>"index", "controller"=>"people"}
  .[4;36;1mPageView Columns (0.000653).[0m   .[0;1mSHOW FIELDS FROM
`page_views`.[0m
  .[4;35;1mSQL (0.000035).[0m   .[0mBEGIN.[0m
  .[4;36;1mPageView Create (0.000155).[0m   .[0;1mINSERT INTO
`page_views` (`updated_at`, `referer`, `user_agent`, `user_id`,
`request_url`, `created_at`, `ip_address`) VALUES('2008-05-19
22:22:59', 'http://www.boabox.com/login', 'Mozilla/5.0 (Windows; U;
Windows NT 5.1; en-US; rv:1.8.1.14) Gecko/20080404 Firefox/2.0.0.14',
NULL, '/people', '2008-05-19 22:22:59', '76.14.127.218').[0m
  .[4;35;1mSQL (0.002222).[0m   .[0mCOMMIT.[0m
  .[4;36;1mSQL (0.000220).[0m   .[0;1mSHOW TABLES.[0m
  .[4;35;1mPerson Columns (0.001013).[0m   .[0mSHOW FIELDS FROM
`people`.[0m
Asked for a remote server ? true, ENV["FERRET_USE_LOCAL_INDEX"] is
nil, looks like we are not the server
Will use local index.
using index in /home/boaboxc/insoshi/index/development/person
default field list: [:description, :name]
  .[4;36;1mSQL (0.000198).[0m   .[0;1mSHOW TABLES.[0m
  .[4;35;1mPerson Load (0.000323).[0m   .[0mSELECT * FROM `people`
WHERE (deactivated = 0) LIMIT 0, 12.[0m
  .[4;36;1mAnalyzing Person Load
.[0m   .[0;1mselect_type | key_len | type | Extra | id |
possible_keys               | rows | table  | ref   |
key
 
-----------------------------------------------------------------------------------------------------------------------------
   SIMPLE      | 1       | ref  |       | 1  |
index_people_on_deactivated | 1    | people | const |
index_people_on_deactivated
.[0m
Rendering template within layouts/application
Rendering people/index
  .[4;35;1mPhoto Columns (0.000840).[0m   .[0mSHOW FIELDS FROM
`photos`.[0m
  .[4;36;1mPhoto Load (0.000055).[0m   .[0;1mSELECT * FROM `photos`
WHERE (photos.person_id = 1) AND (`photos`.`primary` = 1) ORDER BY
created_at.[0m
  .[4;35;1mAnalyzing Photo Load
.[0m   .[0mselect_type | key_len | type | Extra
| id | possible_keys             | rows | table  | ref   |
key
 
-----------------------------------------------------------------------------------------------------------------------------------------------
   SIMPLE      | 5       | ref  | Using where; Using filesort | 1  |
index_photos_on_person_id | 1    | photos | const |
index_photos_on_person_id
.[0m
Rendered people/_person (0.15589)
Rendered searches/_box (0.00136)
  .[4;36;1mActivity Load (0.000256).[0m   .[0;1mSELECT `activities`.*
FROM `activities` INNER JOIN people p ON activities.person_id = p.id
WHERE (p.deactivated = 0) ORDER BY activities.created_at DESC LIMIT 10.
[0m
  .[4;35;1mAnalyzing Activity Load
.[0m   .[0mselect_type | key_len | type |
Extra                                        | id |
possible_keys                       | rows | table      |
ref                             | key
 
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
   SIMPLE      | 1       | ref  | Using index; Using temporary; Using
filesort | 1  | PRIMARY,index_people_on_deactivated | 1    |
p          | const                           |
index_people_on_deactivated
   SIMPLE      | 5       | ref  | Using
where                                  | 1  |
index_activities_on_person_id       | 1    | activities |
boaboxc_insoshiDevelopment.p.id | index_activities_on_person_id
.[0m
Rendered shared/_minifeed (0.00606)
  .[4;36;1mForum Columns (0.000568).[0m   .[0;1mSHOW FIELDS FROM
`forums`.[0m
  .[4;35;1mSQL (0.000039).[0m   .[0mSELECT count(*) AS count_all FROM
`forums` .[0m
  .[4;36;1mAnalyzing
.[0m   .[0;1mselect_type | key_len | type  | Extra       | id |
possible_keys | rows | table  | ref | key
 
------------------------------------------------------------------------------------------------
   SIMPLE      | 4       | index | Using index | 1  |               |
1    | forums |     | PRIMARY
.[0m
  .[4;35;1mForum Load (0.000043).[0m   .[0mSELECT * FROM `forums`
LIMIT 1.[0m
  .[4;36;1mAnalyzing Forum Load
.[0m   .[0;1mselect_type | key_len | type | Extra | id | possible_keys
| rows | table  | ref | key
 
-------------------------------------------------------------------------------------
   SIMPLE      |         | ALL  |       | 1  |               | 1    |
forums |     |
.[0m
  .[4;35;1mPreference Load (0.000056).[0m   .[0mSELECT * FROM
`preferences` LIMIT 1.[0m
  .[4;36;1mAnalyzing Preference Load
.[0m   .[0;1mselect_type | key_len | type | Extra | id | possible_keys
| rows | table       | ref | key
 
------------------------------------------------------------------------------------------
   SIMPLE      |         | ALL  |       | 1  |               | 1    |
preferences |     |
.[0m
Completed in 0.20102 (4 reqs/sec) | Rendering: 0.17273 (85%) | DB:
0.00806 (4%) | 200 OK [http://www.boabox.com/people]
 
And here is my people controller:
class PeopleController < ApplicationController
 
  skip_before_filter :require_activation, :only => :verify
  skip_before_filter :admin_warning, :only => [ :show, :update ]
  before_filter :login_required, :only => [ :show, :edit, :update ]
  before_filter :correct_user_required, :only => [ :edit, :update ]
  before_filter :setup
 
  def index
    @people = Person.active(params[:page])
 
    respond_to do |format|
      format.html
    end
  end
 
  def show
    @person = Person.find(params[:id], :include => :activities)
    if @person.deactivated?
      flash[:error] = "That person is not activated"
      redirect_to home_url and return
    end
    if logged_in?
      @some_contacts = @person.some_contacts
      @common_connections =
current_person.common_connections_with(@person)
    end
    respond_to do |format|
      format.html
    end
  end
 
  def new
    @body = "register single-col"
    @person = Person.new
 
    respond_to do |format|
      format.html
    end
  end
 
  def create
    cookies.delete :auth_token
    @person = Person.new(params[:person])
    respond_to do |format|
      @person.deactivated = true if global_prefs.email_verifications?
      if @person.save
        if global_prefs.email_verifications?
          @person.email_verifications.create
          flash[:notice] = %(Thanks for signing up! A verification
email has
                             been sent to #{@person.email}.)
          format.html { redirect_to :controller => "people" }
        else
          self.current_person = @person
          flash[:notice] = "Thanks for signing up!"
          format.html { redirect_to :controller => "people" }
        end
      else
        @body = "register single-col"
        format.html { render :action => 'new' }
      end
    end
  end
 
  def verify
    verification = EmailVerification.find_by_code(params[:id])
    if verification.nil?
      flash[:error] = "Invalid email verification code"
      redirect_to home_url
    else
      verification.person.deactivated = false;
verification.person.save!
      flash[:success] = "Email verified. Your profile is active!"
      redirect_to verification.person
    end
  end
 
  def edit
    @person = Person.find(params[:id])
 
    respond_to do |format|
      format.html
    end
  end
 
  def update
    @person = Person.find(params[:id])
    respond_to do |format|
      case params[:type]
      when 'info_edit'
        if !preview? and @person.update_attributes(params[:person])
          flash[:success] = 'Profile updated!'
          format.html { redirect_to(@person) }
        else
          @preview = @person.description if preview?
          format.html { render :action => "edit" }
        end
      when 'password_edit'
        if @person.change_password?(params[:person])
          flash[:success] = 'Password changed.'
          format.html { redirect_to(@person) }
        else
          format.html { render :action => "edit" }
        end
      end
    end
  end
 
  def common_contacts
    @person = Person.find(params[:id])
    @common_connections =
@person.common_connections_with(current_person,
 
params[:page])
    respond_to do |format|
      format.html
    end
  end
[+][-]05.20.2008 at 07:30AM PDT, ID: 21606473

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: Ruby Scripting Language
Sign Up Now!
Solution Provided By: JESii
Participating Experts: 2
Solution Grade: B
 
 
[+][-]05.20.2008 at 09:27AM PDT, ID: 21607788

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]05.20.2008 at 09:33PM PDT, ID: 21612144

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.21.2008 at 02:24AM PDT, ID: 21613263

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.21.2008 at 11:23AM PDT, ID: 21617630

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.21.2008 at 03:10PM PDT, ID: 21619468

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.21.2008 at 03:11PM PDT, ID: 21619483

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.21.2008 at 09:20PM PDT, ID: 21620857

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628