Warning (512): SQL Error: 1054: Unknown column 'Person.user_id' in 'where clause' [CORE/cake/libs/model/datasources/dbo_source.php, line 514]

Query: SELECT `Person`.`id`, `Person`.`author_id`, `Person`.`name`, `Person`.`lastname`, `Person`.`lastname1`, `Person`.`lastname2`, `Person`.`alias`, `Person`.`show_as`, `Person`.`gender`, `Person`.`birthday`, `Person`.`notes`, `Person`.`host_address`, `Person`.`image`, `Person`.`position`, `Person`.`company_id`, `Person`.`country_id`, `Person`.`region_id`, `Person`.`zip`, `Person`.`city`, `Person`.`lead_level`, `Person`.`lead_score`, `Person`.`lead_source`, `Person`.`created`, `Person`.`created_by`, `Person`.`modified`, `Person`.`modified_by`, `Person`.`group_id`, `Person`.`is_protected`, `Person`.`view`, `Person`.`status` FROM `people` AS `Person` WHERE `Person`.`user_id` = 15090

site_name // site_tagline
Notice (8): Undefined index:  Meta [APP/views/layouts/default.ctp, line 32]
Notice (8): Undefined index:  Meta [APP/views/layouts/default.ctp, line 45]

Missing View

Error: The view for UsersController::profile() was not found.

Error: Confirm you have created the file: /home/pantxo/sinpiel.org/app/views/themed/sinpiel/users/profile.ctp

Notice: If you want to customize this error message, create app/views/errors/missing_view.ctp

(users) 33 queries took 461 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `users`1011014
2DESCRIBE `groups`992
3DESCRIBE `permissions`441
4DESCRIBE `groups_permissions`221
5DESCRIBE `groups_users`331
6DESCRIBE `user_prefs`23232
7DESCRIBE `user_friends`551
8DESCRIBE `contacts`48483
9DESCRIBE `contact_nodes`18184
10DESCRIBE `contact_nodes_contacts`666
11DESCRIBE `members`22229
12DESCRIBE `user_comments`13133
13DESCRIBE `user_milestones`881
14DESCRIBE `user_images`18182
15DESCRIBE `user_temp_friends`553
16DESCRIBE `mail_lists`11114
17DESCRIBE `mail_lists_users`331
18DESCRIBE `user_interests`441
19DESCRIBE `user_interests_users`221
20SELECT `User`.`id`, `User`.`group_id`, `User`.`facebook_id`, `User`.`host_address`, `User`.`ghost`, `User`.`username`, `User`.`username_clean`, `User`.`pass`, `User`.`password_salt`, `User`.`password`, `User`.`passchg`, `User`.`email`, `User`.`birthday`, `User`.`avatar`, `User`.`image`, `User`.`is_admin`, `User`.`karma`, `User`.`visits`, `User`.`friends`, `User`.`comments`, `User`.`ratings`, `User`.`restaurant_comments`, `User`.`recipe_comments`, `User`.`user_comments`, `User`.`recipes`, `User`.`recipe_box`, `User`.`last_visit`, `User`.`last_mark`, `User`.`last_page`, `User`.`last_confirm_key`, `User`.`last_search`, `User`.`last_feedback`, `User`.`last_comments`, `User`.`last_recipe_reviews`, `User`.`last_restaurant_reviews`, `User`.`login_attempts`, `User`.`inactive_reason`, `User`.`inactive_time`, `User`.`lang_id`, `User`.`timezone`, `User`.`dateformat`, `User`.`rank_id`, `User`.`actkey`, `User`.`regsite`, `User`.`newpasswd`, `User`.`created`, `User`.`modified`, `User`.`published`, `User`.`status`, `User`.`view`, `User`.`name`, `User`.`lastname`, `User`.`gender`, `User`.`email1`, `User`.`email2`, `User`.`email3`, `User`.`im_aim`, `User`.`im_icq`, `User`.`im_msn`, `User`.`im_yahoo`, `User`.`im_google`, `User`.`im_skype`, `User`.`myspace`, `User`.`facebook`, `User`.`fotolog`, `User`.`msnspace`, `User`.`network`, `User`.`member`, `User`.`translator`, `User`.`newsletter`, `User`.`website`, `User`.`occupation`, `User`.`company`, `User`.`position`, `User`.`address`, `User`.`suburb`, `User`.`location`, `User`.`zip`, `User`.`state`, `User`.`region_id`, `User`.`country_id`, `User`.`phone1`, `User`.`phone2`, `User`.`mobile`, `User`.`fax`, `User`.`dni`, `User`.`lifestyle`, `User`.`political`, `User`.`religion`, `User`.`relationship`, `User`.`meeting_sex`, `User`.`meeting_for`, `User`.`about`, `User`.`interests`, `User`.`music`, `User`.`tv`, `User`.`movies`, `User`.`books`, `User`.`skills`, `User`.`languages`, `User`.`notes`, `UserPref`.`id`, `UserPref`.`user_id`, `UserPref`.`show_address`, `UserPref`.`show_email1`, `UserPref`.`show_email2`, `UserPref`.`show_email3`, `UserPref`.`show_im_aim`, `UserPref`.`show_im_icq`, `UserPref`.`show_im_msn`, `UserPref`.`show_im_yahoo`, `UserPref`.`show_im_google`, `UserPref`.`show_im_skype`, `UserPref`.`show_myspace`, `UserPref`.`show_facebook`, `UserPref`.`show_fotolog`, `UserPref`.`show_msnspace`, `UserPref`.`show_mobile`, `UserPref`.`show_phone1`, `UserPref`.`show_website`, `UserPref`.`show_birthday`, `UserPref`.`user_avatar_type`, `UserPref`.`user_avatar_width`, `UserPref`.`user_avatar_height`, `UserFriend`.`id`, `UserFriend`.`user_id`, `UserFriend`.`friends`, `UserFriend`.`created`, `UserFriend`.`modified`, `Contact`.`id`, `Contact`.`name`, `Contact`.`lastname`, `Contact`.`lastname1`, `Contact`.`lastname2`, `Contact`.`alias`, `Contact`.`username`, `Contact`.`show_as`, `Contact`.`gender`, `Contact`.`email1`, `Contact`.`email2`, `Contact`.`email3`, `Contact`.`web1`, `Contact`.`web2`, `Contact`.`web3`, `Contact`.`myspace`, `Contact`.`facebook`, `Contact`.`fotolog`, `Contact`.`msnspace`, `Contact`.`im_skype`, `Contact`.`im_msn`, `Contact`.`im_yahoo`, `Contact`.`im_google`, `Contact`.`im_aim`, `Contact`.`im_icq`, `Contact`.`birthday`, `Contact`.`company`, `Contact`.`position`, `Contact`.`address`, `Contact`.`suburb`, `Contact`.`location`, `Contact`.`zip`, `Contact`.`region_id`, `Contact`.`country_id`, `Contact`.`phone1`, `Contact`.`phone2`, `Contact`.`mobile`, `Contact`.`fax`, `Contact`.`notes`, `Contact`.`host_address`, `Contact`.`image`, `Contact`.`user_id`, `Contact`.`regsite`, `Contact`.`created`, `Contact`.`modified`, `Contact`.`newsletter`, `Contact`.`view`, `Contact`.`status`, `Member`.`id`, `Member`.`user_id`, `Member`.`name`, `Member`.`lastname`, `Member`.`email`, `Member`.`address`, `Member`.`zip`, `Member`.`location`, `Member`.`region`, `Member`.`region_id`, `Member`.`country_id`, `Member`.`phone`, `Member`.`mobile`, `Member`.`birthday`, `Member`.`occupation`, `Member`.`amount`, `Member`.`payment`, `Member`.`account`, `Member`.`host_address`, `Member`.`created`, `Member`.`modified`, `Member`.`status` FROM `users` AS `User` LEFT JOIN `user_prefs` AS `UserPref` ON (`UserPref`.`user_id` = `User`.`id`) LEFT JOIN `user_friends` AS `UserFriend` ON (`UserFriend`.`user_id` = `User`.`id`) LEFT JOIN `contacts` AS `Contact` ON (`Contact`.`user_id` = `User`.`id`) LEFT JOIN `members` AS `Member` ON (`Member`.`user_id` = `User`.`id`) WHERE ( `User`.`id` = "15090" OR `User`.`username_clean` = "15090" ) AND `User`.`status` = 1 LIMIT 111327
21SELECT `UserComment`.`id`, `UserComment`.`profile_id`, `UserComment`.`user_id`, `UserComment`.`user_name`, `UserComment`.`user_email`, `UserComment`.`content`, `UserComment`.`score`, `UserComment`.`votes`, `UserComment`.`created`, `UserComment`.`modified`, `UserComment`.`digg`, `UserComment`.`status`, `UserComment`.`flagged` FROM `user_comments` AS `UserComment` WHERE `UserComment`.`user_id` = (15090) ORDER BY `UserComment`.`digg` DESC, `UserComment`.`created` DESC LIMIT 3112
22SELECT DISTINCT `UserMilestone`.`action`, `UserMilestone`.`user_id` FROM `user_milestones` AS `UserMilestone` WHERE `UserMilestone`.`user_id` = (15090) ORDER BY `UserMilestone`.`created` DESC LIMIT 103339
23SELECT `UserImage`.`id`, `UserImage`.`ref`, `UserImage`.`user_id`, `UserImage`.`title`, `UserImage`.`image`, `UserImage`.`descr`, `UserImage`.`votes`, `UserImage`.`score`, `UserImage`.`comments`, `UserImage`.`mime`, `UserImage`.`width`, `UserImage`.`height`, `UserImage`.`created`, `UserImage`.`modified`, `UserImage`.`published`, `UserImage`.`hits`, `UserImage`.`status`, `UserImage`.`view` FROM `user_images` AS `UserImage` WHERE `UserImage`.`user_id` = (15090) 0018
24SELECT `UserTempFriend`.`id`, `UserTempFriend`.`friend_id`, `UserTempFriend`.`user_id`, `UserTempFriend`.`key`, `UserTempFriend`.`created` FROM `user_temp_friends` AS `UserTempFriend` WHERE `UserTempFriend`.`user_id` = (15090) 001
25SELECT `MailList`.`id`, `MailList`.`code`, `MailList`.`title`, `MailList`.`descr`, `MailList`.`from_email`, `MailList`.`reply_email`, `MailList`.`count`, `MailList`.`created`, `MailList`.`modify`, `MailList`.`status`, `MailList`.`view`, `MailListsUser`.`id`, `MailListsUser`.`user_id`, `MailListsUser`.`mail_list_id` FROM `mail_lists` AS `MailList` JOIN `mail_lists_users` AS `MailListsUser` ON (`MailListsUser`.`user_id` = 15090 AND `MailListsUser`.`mail_list_id` = `MailList`.`id`) WHERE 1 = 1 004
26SELECT `Group`.`id`, `Group`.`parentid`, `Group`.`name`, `Group`.`desc`, `Group`.`avatar`, `Group`.`rank`, `Group`.`created`, `Group`.`modified`, `Group`.`status`, `GroupsUser`.`id`, `GroupsUser`.`group_id`, `GroupsUser`.`user_id` FROM `groups` AS `Group` JOIN `groups_users` AS `GroupsUser` ON (`GroupsUser`.`user_id` = 15090 AND `GroupsUser`.`group_id` = `Group`.`id`) WHERE 1 = 1 002
27SELECT `UserInterest`.`id`, `UserInterest`.`set`, `UserInterest`.`title`, `UserInterest`.`status`, `UserInterestsUser`.`user_id`, `UserInterestsUser`.`user_interest_id` FROM `user_interests` AS `UserInterest` JOIN `user_interests_users` AS `UserInterestsUser` ON (`UserInterestsUser`.`user_id` = 15090 AND `UserInterestsUser`.`user_interest_id` = `UserInterest`.`id`) WHERE 1 = 1 001
28SELECT COUNT(*) AS `count` FROM `users` AS `User` WHERE `User`.`id` = 15090 111
29UPDATE `users` SET `modified` = '2012-05-18 00:15:38' WHERE `users`.`id` = 1509012
30SELECT `User`.`id`, `User`.`username`, `User`.`name`, `User`.`avatar`, `User`.`email` FROM `users` AS `User` WHERE `User`.`id` = 15090 114
31SELECT `User`.`id`, `User`.`username`, `User`.`name`, `User`.`avatar`, `User`.`email` FROM `users` AS `User` WHERE `User`.`id` = 15090 116
32SELECT `User`.`id`, `User`.`username`, `User`.`name`, `User`.`avatar`, `User`.`email` FROM `users` AS `User` WHERE `User`.`id` = 15090 112
33SELECT `User`.`id`, `User`.`username`, `User`.`name`, `User`.`avatar`, `User`.`email` FROM `users` AS `User` WHERE `User`.`id` = 15090 112
(default) 53 queries took 411 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `countries`12122
2DESCRIBE `regions`10101
3DESCRIBE `locations`10101
4DESCRIBE `homepages`16161
5DESCRIBE `tags`663
6DESCRIBE `downloads`19192
7DESCRIBE `download_files`14142
8DESCRIBE `download_comments`22222
9DESCRIBE `download_diggs`553
10DESCRIBE `download_nodes`17171
11DESCRIBE `download_nodes_downloads`441
12DESCRIBE `downloads_tags`221
13DESCRIBE `images`22222
14DESCRIBE `image_comments`12122
15DESCRIBE `image_diggs`553
16DESCRIBE `image_nodes`18182
17DESCRIBE `image_nodes_images`442
18DESCRIBE `images_tags`331
19DESCRIBE `pages`27272
20DESCRIBE `page_diggs`554
21DESCRIBE `page_nodes`20202
22DESCRIBE `post_nodes`20203
23DESCRIBE `posts`39395
24DESCRIBE `events`30302
25DESCRIBE `langs`552
26DESCRIBE `event_dates`884
27DESCRIBE `events_tags`445
28DESCRIBE `post_comments`22226
29DESCRIBE `post_diggs`552
30DESCRIBE `post_nodes_posts`441
31DESCRIBE `posts_tags`332
32DESCRIBE `video_nodes`18182
33DESCRIBE `videos`25259
34DESCRIBE `video_comments`22222
35DESCRIBE `video_diggs`552
36DESCRIBE `video_nodes_videos`448
37DESCRIBE `tags_videos`221
38DESCRIBE `page_nodes_pages`443
39DESCRIBE `pages_tags`443
40DESCRIBE `countries_homepages`441
41DESCRIBE `homepages_tags`221
42SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'n3g6j3n4nl0ojt9o6nt5rcilf3'111
43SELECT `Country`.`id`, `Country`.`parentid`, `Country`.`iso2`, `Country`.`iso3`, `Country`.`slug`, `Country`.`title`, `Country`.`official`, `Country`.`translated`, `Country`.`capital`, `Country`.`phone_code`, `Country`.`view`, `Country`.`status` FROM `countries` AS `Country` WHERE `Country`.`id` = 'CO' 112
44SELECT `Region`.`id`, `Region`.`country_id`, `Region`.`iso2`, `Region`.`iso3`, `Region`.`slug`, `Region`.`title`, `Region`.`official`, `Region`.`translated`, `Region`.`capital`, `Region`.`status` FROM `regions` AS `Region` WHERE `Region`.`id` = 362 112
45SELECT `PostComment`.`id`, `PostComment`.`user_id`, `PostComment`.`user_ip`, `PostComment`.`user_name`, `PostComment`.`user_email`, `PostComment`.`post_id`, `PostComment`.`download_id`, `PostComment`.`video_id`, `PostComment`.`content`, `PostComment`.`parent_id`, `PostComment`.`lft`, `PostComment`.`rght`, `PostComment`.`language`, `PostComment`.`score`, `PostComment`.`votes`, `PostComment`.`created`, `PostComment`.`modified`, `PostComment`.`points`, `PostComment`.`approved`, `PostComment`.`is_spam`, `PostComment`.`comment_type`, `PostComment`.`status` FROM `post_comments` AS `PostComment` WHERE `PostComment`.`user_id` = (15090) ORDER BY `PostComment`.`created` DESC LIMIT 3336
46SELECT `Country`.`id`, `Country`.`parentid`, `Country`.`iso2`, `Country`.`iso3`, `Country`.`slug`, `Country`.`title`, `Country`.`official`, `Country`.`translated`, `Country`.`capital`, `Country`.`phone_code`, `Country`.`view`, `Country`.`status` FROM `countries` AS `Country` WHERE `Country`.`id` = "CO" LIMIT 1112
47SELECT COUNT(*) AS `count` FROM `post_comments` AS `PostComment` LEFT JOIN `posts` AS `Post` ON (`PostComment`.`post_id` = `Post`.`id`) WHERE `PostComment`.`status` = 1 AND `PostComment`.`content` != "" AND `PostComment`.`user_id` = "15090" OR ( `PostComment`.`user_email` = "roro.pi@hotmail.com" AND `PostComment`.`user_ip` = "201.216.45.234" ) 11133
48SELECT `PostComment`.*, `Post`.`id`, `Post`.`title`, `Post`.`image` FROM `post_comments` AS `PostComment` LEFT JOIN `posts` AS `Post` ON (`PostComment`.`post_id` = `Post`.`id`) WHERE `PostComment`.`status` = 1 AND `PostComment`.`content` != "" AND `PostComment`.`user_id` = "15090" OR ( `PostComment`.`user_email` = "roro.pi@hotmail.com" AND `PostComment`.`user_ip` = "201.216.45.234" ) ORDER BY `PostComment`.`votes` DESC, `PostComment`.`created` DESC LIMIT 544151
49SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'n3g6j3n4nl0ojt9o6nt5rcilf3'112
50UPDATE `cake_sessions` SET `data` = 'Config|a:4:{s:9:\"userAgent\";s:32:\"a9f1b67aad93cf8fc1b60fef235000a6\";s:4:\"time\";i:1337361337;s:4:\"rand\";i:146441360;s:7:\"timeout\";i:10;}geoip|s:2:\"US\";', `expires` = 1337361339 WHERE `id` = 'n3g6j3n4nl0ojt9o6nt5rcilf3'12
51SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'n3g6j3n4nl0ojt9o6nt5rcilf3'111
52SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'n3g6j3n4nl0ojt9o6nt5rcilf3'114
53UPDATE `cake_sessions` SET `data` = 'Config|a:4:{s:9:\"userAgent\";s:32:\"a9f1b67aad93cf8fc1b60fef235000a6\";s:4:\"time\";i:1337361337;s:4:\"rand\";i:146441360;s:7:\"timeout\";i:10;}geoip|s:2:\"US\";', `expires` = 1337361339 WHERE `id` = 'n3g6j3n4nl0ojt9o6nt5rcilf3'01
(crm) 7 queries took 34 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `people`30304
2DESCRIBE `person_emails`666
3DESCRIBE `person_webs`666
4DESCRIBE `person_phones`666
5DESCRIBE `person_addresses`11115
6DESCRIBE `notes`14145
7SELECT `Person`.`id`, `Person`.`author_id`, `Person`.`name`, `Person`.`lastname`, `Person`.`lastname1`, `Person`.`lastname2`, `Person`.`alias`, `Person`.`show_as`, `Person`.`gender`, `Person`.`birthday`, `Person`.`notes`, `Person`.`host_address`, `Person`.`image`, `Person`.`position`, `Person`.`company_id`, `Person`.`country_id`, `Person`.`region_id`, `Person`.`zip`, `Person`.`city`, `Person`.`lead_level`, `Person`.`lead_score`, `Person`.`lead_source`, `Person`.`created`, `Person`.`created_by`, `Person`.`modified`, `Person`.`modified_by`, `Person`.`group_id`, `Person`.`is_protected`, `Person`.`view`, `Person`.`status` FROM `people` AS `Person` WHERE `Person`.`user_id` = 15090 1054: Unknown column 'Person.user_id' in 'where clause'2
(hztveg) 10 queries took 53 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `recipes`32325
2DESCRIBE `recipe_comments`20202
3DESCRIBE `recipe_images`771
4DESCRIBE `recipe_notes`771
5DESCRIBE `recipes_users`552
6DESCRIBE `recipe_nodes`16167
7DESCRIBE `recipe_nodes_recipes`448
8DESCRIBE `recipes_tags`228
9SELECT `Recipe`.`id`, `Recipe`.`ref`, `Recipe`.`title`, `Recipe`.`image`, `Recipe`.`created`, `Recipe`.`user_id` FROM `recipes` AS `Recipe` WHERE `Recipe`.`status` = 1 AND `Recipe`.`user_id` = (15090) LIMIT 6006
10SELECT COUNT(*) AS `count` FROM `recipes` AS `Recipe` WHERE `Recipe`.`user_id` = 15090 1113