Whenever I try to signup on my insoshi installation, 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.
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"=>"[EMAIL PROTECTED]"}}
.[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 = '[EMAIL PROTECTED]') 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',
'[EMAIL PROTECTED]').[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 <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
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 PROTECTED]>
To: [EMAIL PROTECTED]
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 [EMAIL PROTECTED])
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
private
def setup
@body = "person"
end
def correct_user_required
redirect_to home_url unless Person.find(params[:id]) ==
current_person
end
def preview?
params["commit"] == "Preview"
end
end
Any help would be appreciated,
Thanks,
Mikael
--~--~---------~--~----~------------~-------~--~----~
Insoshi developer site: http://dogfood.insoshi.com/
Insoshi documentation: http://docs.insoshi.com/
You received this message because you are subscribed to the Google
Groups "Insoshi" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/insoshi?hl=en
-~----------~----~----~----~------~----~------~--~---
