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` = 29235

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) 31 queries took 397 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `users`1011014
2DESCRIBE `groups`991
3DESCRIBE `permissions`441
4DESCRIBE `groups_permissions`221
5DESCRIBE `groups_users`333
6DESCRIBE `user_prefs`23232
7DESCRIBE `user_friends`551
8DESCRIBE `contacts`48482
9DESCRIBE `contact_nodes`18183
10DESCRIBE `contact_nodes_contacts`662
11DESCRIBE `members`22221
12DESCRIBE `user_comments`13131
13DESCRIBE `user_milestones`884
14DESCRIBE `user_images`18185
15DESCRIBE `user_temp_friends`552
16DESCRIBE `mail_lists`11112
17DESCRIBE `mail_lists_users`332
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` = "29235" OR `User`.`username_clean` = "29235" ) AND `User`.`status` = 1 LIMIT 111245
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` = (29235) ORDER BY `UserComment`.`digg` DESC, `UserComment`.`created` DESC LIMIT 3001
22SELECT DISTINCT `UserMilestone`.`action`, `UserMilestone`.`user_id` FROM `user_milestones` AS `UserMilestone` WHERE `UserMilestone`.`user_id` = (29235) ORDER BY `UserMilestone`.`created` DESC LIMIT 10222
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` = (29235) 0010
24SELECT `UserTempFriend`.`id`, `UserTempFriend`.`friend_id`, `UserTempFriend`.`user_id`, `UserTempFriend`.`key`, `UserTempFriend`.`created` FROM `user_temp_friends` AS `UserTempFriend` WHERE `UserTempFriend`.`user_id` = (29235) 002
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` = 29235 AND `MailListsUser`.`mail_list_id` = `MailList`.`id`) WHERE 1 = 1 002
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` = 29235 AND `GroupsUser`.`group_id` = `Group`.`id`) WHERE 1 = 1 001
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` = 29235 AND `UserInterestsUser`.`user_interest_id` = `UserInterest`.`id`) WHERE 1 = 1 001
28SELECT COUNT(*) AS `count` FROM `users` AS `User` WHERE `User`.`id` = 29235 1115
29UPDATE `users` SET `modified` = '2012-05-18 00:25:40' WHERE `users`.`id` = 29235117
30SELECT COUNT(*) AS `count` FROM `user_comments` AS `UserComment` LEFT JOIN `users` AS `User` ON (`UserComment`.`user_id` = `User`.`id`) WHERE `UserComment`.`status` = 1 AND `UserComment`.`content` != "" AND `UserComment`.`profile_id` = "29235" 1134
31SELECT `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`, `User`.`id`, `User`.`name`, `User`.`lastname`, `User`.`email`, `User`.`avatar` FROM `user_comments` AS `UserComment` LEFT JOIN `users` AS `User` ON (`UserComment`.`user_id` = `User`.`id`) WHERE `UserComment`.`status` = 1 AND `UserComment`.`content` != "" AND `UserComment`.`profile_id` = "29235" ORDER BY `UserComment`.`created` DESC LIMIT 50028
(default) 51 queries took 189 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `countries`12122
2DESCRIBE `regions`10102
3DESCRIBE `locations`10109
4DESCRIBE `homepages`16161
5DESCRIBE `tags`664
6DESCRIBE `downloads`19195
7DESCRIBE `download_files`14142
8DESCRIBE `download_comments`22222
9DESCRIBE `download_diggs`555
10DESCRIBE `download_nodes`17173
11DESCRIBE `download_nodes_downloads`441
12DESCRIBE `downloads_tags`221
13DESCRIBE `images`22222
14DESCRIBE `image_comments`12121
15DESCRIBE `image_diggs`551
16DESCRIBE `image_nodes`18184
17DESCRIBE `image_nodes_images`441
18DESCRIBE `images_tags`331
19DESCRIBE `pages`27272
20DESCRIBE `page_diggs`552
21DESCRIBE `page_nodes`20202
22DESCRIBE `post_nodes`20204
23DESCRIBE `posts`39392
24DESCRIBE `events`30302
25DESCRIBE `langs`555
26DESCRIBE `event_dates`8810
27DESCRIBE `events_tags`441
28DESCRIBE `post_comments`22227
29DESCRIBE `post_diggs`551
30DESCRIBE `post_nodes_posts`441
31DESCRIBE `posts_tags`333
32DESCRIBE `video_nodes`18181
33DESCRIBE `videos`25251
34DESCRIBE `video_comments`22221
35DESCRIBE `video_diggs`551
36DESCRIBE `video_nodes_videos`441
37DESCRIBE `tags_videos`221
38DESCRIBE `page_nodes_pages`442
39DESCRIBE `pages_tags`441
40DESCRIBE `countries_homepages`441
41DESCRIBE `homepages_tags`221
42SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'n3g6j3n4nl0ojt9o6nt5rcilf3'112
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` = 'MX' 111
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` = 566 111
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` = (29235) ORDER BY `PostComment`.`created` DESC LIMIT 3112
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` = "MX" LIMIT 11127
47SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'n3g6j3n4nl0ojt9o6nt5rcilf3'116
48UPDATE `cake_sessions` SET `data` = 'Config|a:4:{s:9:\"userAgent\";s:32:\"a9f1b67aad93cf8fc1b60fef235000a6\";s:4:\"time\";i:1337361939;s:4:\"rand\";i:146441360;s:7:\"timeout\";i:10;}geoip|s:2:\"US\";', `expires` = 1337361940 WHERE `id` = 'n3g6j3n4nl0ojt9o6nt5rcilf3'18
49SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'n3g6j3n4nl0ojt9o6nt5rcilf3'118
50SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'n3g6j3n4nl0ojt9o6nt5rcilf3'1116
51UPDATE `cake_sessions` SET `data` = 'Config|a:4:{s:9:\"userAgent\";s:32:\"a9f1b67aad93cf8fc1b60fef235000a6\";s:4:\"time\";i:1337361939;s:4:\"rand\";i:146441360;s:7:\"timeout\";i:10;}geoip|s:2:\"US\";', `expires` = 1337361940 WHERE `id` = 'n3g6j3n4nl0ojt9o6nt5rcilf3'018
(crm) 7 queries took 11 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `people`30302
2DESCRIBE `person_emails`664
3DESCRIBE `person_webs`661
4DESCRIBE `person_phones`661
5DESCRIBE `person_addresses`11111
6DESCRIBE `notes`14141
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` = 29235 1054: Unknown column 'Person.user_id' in 'where clause'1
(hztveg) 10 queries took 59 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `recipes`323214
2DESCRIBE `recipe_comments`20203
3DESCRIBE `recipe_images`771
4DESCRIBE `recipe_notes`772
5DESCRIBE `recipes_users`552
6DESCRIBE `recipe_nodes`16161
7DESCRIBE `recipe_nodes_recipes`442
8DESCRIBE `recipes_tags`222
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` = (29235) LIMIT 60016
10SELECT COUNT(*) AS `count` FROM `recipes` AS `Recipe` WHERE `Recipe`.`user_id` = 29235 1116