 |
 |
|
 |
 |
|
 |
||
 |  | |
| Or if you registered using your facebook profile, login securely here: | ||
 |  |
Warning (512): SQL Error: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Haycock OR `Friend`.`friend_id` = James Haycock) AND (`Account`.`id` <> Jam' at line 5 [CORE/cake/libs/model/datasources/dbo_source.php, line 521]
Query: SELECT `Account`.`id` FROM `accounts` AS `Account` LEFT JOIN `friends` AS `Friend` ON (`Account`.`id` = `Friend`.`account_id` OR `Account`.`id` = `Friend`.`friend_id`) WHERE ((`Friend`.`account_id` = James Haycock OR `Friend`.`friend_id` = James Haycock) AND (`Account`.`id` <> James Haycock) AND (`Friend`.`approved` = 1));
Warning (2): Invalid argument supplied for foreach() [APP/models/account.php, line 280]
| | |
| Or if you registered using your facebook profile, login securely here: | ||
| |
Profile »
|
|
|
|
|
|
|
||
© copyright travelscoops.com 2008
0.9197
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | DESCRIBE `accounts` | 19 | 19 | 1 | |
| 2 | DESCRIBE `trip_destinations` | 15 | 15 | 1 | |
| 3 | DESCRIBE `trips` | 12 | 12 | 1 | |
| 4 | DESCRIBE `featured_trips` | 5 | 5 | 0 | |
| 5 | DESCRIBE `scoops` | 9 | 9 | 0 | |
| 6 | DESCRIBE `blogs` | 7 | 7 | 0 | |
| 7 | DESCRIBE `comments` | 7 | 7 | 0 | |
| 8 | DESCRIBE `ratings` | 7 | 7 | 1 | |
| 9 | DESCRIBE `friend_tags` | 7 | 7 | 0 | |
| 10 | DESCRIBE `photo_albums` | 5 | 5 | 0 | |
| 11 | DESCRIBE `photos` | 7 | 7 | 0 | |
| 12 | DESCRIBE `videos` | 9 | 9 | 1 | |
| 13 | DESCRIBE `trip_members` | 6 | 6 | 0 | |
| 14 | DESCRIBE `trip_followers` | 4 | 4 | 0 | |
| 15 | DESCRIBE `trip_invites` | 9 | 9 | 0 | |
| 16 | DESCRIBE `trip_join_requests` | 5 | 5 | 0 | |
| 17 | DESCRIBE `user_locations` | 9 | 9 | 0 | |
| 18 | DESCRIBE `friends` | 7 | 7 | 0 | |
| 19 | DESCRIBE `friend_invites` | 9 | 9 | 0 | |
| 20 | DESCRIBE `wish_lists` | 10 | 10 | 0 | |
| 21 | DESCRIBE `friend_groups` | 4 | 4 | 0 | |
| 22 | DESCRIBE `friend_group_links` | 4 | 4 | 0 | |
| 23 | DESCRIBE `messages` | 8 | 8 | 0 | |
| 24 | SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'e72e664cd5eada79310a4c2acbf2c224' | 1 | 1 | 0 | |
| 25 | SELECT `Account`.`id`, `Account`.`forename`, `Account`.`surname`, `Account`.`nickname`, `Account`.`email`, `Account`.`password`, `Account`.`dob`, `Account`.`gender`, `Account`.`privacy_level`, `Account`.`nationality`, `Account`.`photo_filename`, `Account`.`fb_uid`, `Account`.`use_fb`, `Account`.`email_hash`, `Account`.`permission_group_id`, `Account`.`status`, `Account`.`disabled`, `Account`.`created`, `Account`.`modified`, `TripLocation`.`id`, `TripLocation`.`trip_id`, `TripLocation`.`start_date`, `TripLocation`.`end_date`, `TripLocation`.`name`, `TripLocation`.`country`, `TripLocation`.`country_code`, `TripLocation`.`geoname_id`, `TripLocation`.`longitude`, `TripLocation`.`latitude`, `UserLocation`.`id`, `UserLocation`.`account_id`, `UserLocation`.`name`, `UserLocation`.`country`, `UserLocation`.`country_code`, `UserLocation`.`geoname_id`, `UserLocation`.`longitude`, `UserLocation`.`latitude`, `UserLocation`.`created` FROM `accounts` AS `Account` LEFT JOIN `trip_destinations` AS `TripLocation` ON (`TripLocation`.`start_date` <= NOW() AND `TripLocation`.`end_date` >= NOW() AND `TripLocation`.`trip_id` IN (SELECT `TM`.`trip_id` FROM trip_members AS TM WHERE `TM`.`account_id` = `Account`.`id`)) LEFT JOIN `user_locations` AS `UserLocation` ON (`UserLocation`.`account_id` = `Account`.`id`) WHERE `Account`.`id` = 'James Haycock' GROUP BY `Account`.`id` LIMIT 1 | 0 | 0 | 0 | |
| 26 | SELECT `Friend`.`id`, `Friend`.`account_id`, `Friend`.`friend_id`, `Friend`.`approved`, `Friend`.`id_hash`, `Friend`.`created`, `Friend`.`modified`, `Friend1`.`id`, `Friend1`.`forename`, `Friend1`.`surname`, `Friend1`.`nickname`, `Friend1`.`email`, `Friend1`.`password`, `Friend1`.`dob`, `Friend1`.`gender`, `Friend1`.`privacy_level`, `Friend1`.`nationality`, `Friend1`.`photo_filename`, `Friend1`.`fb_uid`, `Friend1`.`use_fb`, `Friend1`.`email_hash`, `Friend1`.`permission_group_id`, `Friend1`.`status`, `Friend1`.`disabled`, `Friend1`.`created`, `Friend1`.`modified`, `Friend2`.`id`, `Friend2`.`forename`, `Friend2`.`surname`, `Friend2`.`nickname`, `Friend2`.`email`, `Friend2`.`password`, `Friend2`.`dob`, `Friend2`.`gender`, `Friend2`.`privacy_level`, `Friend2`.`nationality`, `Friend2`.`photo_filename`, `Friend2`.`fb_uid`, `Friend2`.`use_fb`, `Friend2`.`email_hash`, `Friend2`.`permission_group_id`, `Friend2`.`status`, `Friend2`.`disabled`, `Friend2`.`created`, `Friend2`.`modified` FROM `friends` AS `Friend` LEFT JOIN `accounts` AS `Friend1` ON (`Friend`.`account_id` = `Friend1`.`id`) LEFT JOIN `accounts` AS `Friend2` ON (`Friend`.`friend_id` = `Friend2`.`id`) WHERE ((((`Friend`.`account_id` IS NULL) AND (`Friend`.`friend_id` = 'James Haycock'))) OR (((`Friend`.`account_id` = 'James Haycock') AND (`Friend`.`friend_id` IS NULL)))) AND `Friend`.`approved` = 1 LIMIT 1 | 0 | 0 | 0 | |
| 27 | SELECT `Friend`.`id`, `Friend`.`account_id`, `Friend`.`friend_id`, `Friend`.`approved`, `Friend`.`id_hash`, `Friend`.`created`, `Friend`.`modified`, `Friend1`.`id`, `Friend1`.`forename`, `Friend1`.`surname`, `Friend1`.`nickname`, `Friend1`.`email`, `Friend1`.`password`, `Friend1`.`dob`, `Friend1`.`gender`, `Friend1`.`privacy_level`, `Friend1`.`nationality`, `Friend1`.`photo_filename`, `Friend1`.`fb_uid`, `Friend1`.`use_fb`, `Friend1`.`email_hash`, `Friend1`.`permission_group_id`, `Friend1`.`status`, `Friend1`.`disabled`, `Friend1`.`created`, `Friend1`.`modified`, `Friend2`.`id`, `Friend2`.`forename`, `Friend2`.`surname`, `Friend2`.`nickname`, `Friend2`.`email`, `Friend2`.`password`, `Friend2`.`dob`, `Friend2`.`gender`, `Friend2`.`privacy_level`, `Friend2`.`nationality`, `Friend2`.`photo_filename`, `Friend2`.`fb_uid`, `Friend2`.`use_fb`, `Friend2`.`email_hash`, `Friend2`.`permission_group_id`, `Friend2`.`status`, `Friend2`.`disabled`, `Friend2`.`created`, `Friend2`.`modified` FROM `friends` AS `Friend` LEFT JOIN `accounts` AS `Friend1` ON (`Friend`.`account_id` = `Friend1`.`id`) LEFT JOIN `accounts` AS `Friend2` ON (`Friend`.`friend_id` = `Friend2`.`id`) WHERE ((((`Friend`.`account_id` IS NULL) AND (`Friend`.`friend_id` = 'James Haycock'))) OR (((`Friend`.`account_id` = 'James Haycock') AND (`Friend`.`friend_id` IS NULL)))) AND `Friend`.`approved` = 0 LIMIT 1 | 0 | 0 | 0 | |
| 28 | SELECT `Account`.`id` FROM `accounts` AS `Account` LEFT JOIN `friends` AS `Friend` ON (`Account`.`id` = `Friend`.`account_id` OR `Account`.`id` = `Friend`.`friend_id`) WHERE ((`Friend`.`account_id` = James Haycock OR `Friend`.`friend_id` = James Haycock) AND (`Account`.`id` <> James Haycock) AND (`Friend`.`approved` = 1)); | 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Haycock OR `Friend`.`friend_id` = James Haycock) AND (`Account`.`id` <> Jam' at line 5 | 0 | ||
| 29 | SELECT `Account`.`id`, `Account`.`forename`, `Account`.`surname`, `Account`.`nickname`, `Account`.`email`, `Account`.`password`, `Account`.`dob`, `Account`.`gender`, `Account`.`privacy_level`, `Account`.`nationality`, `Account`.`photo_filename`, `Account`.`fb_uid`, `Account`.`use_fb`, `Account`.`email_hash`, `Account`.`permission_group_id`, `Account`.`status`, `Account`.`disabled`, `Account`.`created`, `Account`.`modified`, `TripLocation`.`id`, `TripLocation`.`trip_id`, `TripLocation`.`start_date`, `TripLocation`.`end_date`, `TripLocation`.`name`, `TripLocation`.`country`, `TripLocation`.`country_code`, `TripLocation`.`geoname_id`, `TripLocation`.`longitude`, `TripLocation`.`latitude`, `UserLocation`.`id`, `UserLocation`.`account_id`, `UserLocation`.`name`, `UserLocation`.`country`, `UserLocation`.`country_code`, `UserLocation`.`geoname_id`, `UserLocation`.`longitude`, `UserLocation`.`latitude`, `UserLocation`.`created` FROM `accounts` AS `Account` LEFT JOIN `trip_destinations` AS `TripLocation` ON (`TripLocation`.`start_date` <= NOW() AND `TripLocation`.`end_date` >= NOW() AND `TripLocation`.`trip_id` IN (SELECT `TM`.`trip_id` FROM trip_members AS TM WHERE `TM`.`account_id` = `Account`.`id`)) LEFT JOIN `user_locations` AS `UserLocation` ON (`UserLocation`.`account_id` = `Account`.`id`) WHERE `Account`.`id` IS NULL GROUP BY `Account`.`id` ORDER BY rand() ASC | 0 | 0 | 0 | |
| 30 | SELECT `WishList`.`id`, `WishList`.`account_id`, `WishList`.`name`, `WishList`.`country`, `WishList`.`country_code`, `WishList`.`geoname_id`, `WishList`.`longitude`, `WishList`.`latitude`, `WishList`.`description`, `WishList`.`created` FROM `wish_lists` AS `WishList` WHERE `WishList`.`account_id` = 'James Haycock' | 0 | 0 | 0 | |
| 31 | SELECT `TripMember`.`id`, `TripMember`.`trip_id` FROM `trip_members` AS `TripMember` WHERE `TripMember`.`account_id` = 'James Haycock' AND `TripMember`.`status` = 0 | 0 | 0 | 4 | |
| 32 | SELECT `Trip`.`id`, `Trip`.`title`, `Trip`.`description`, `Trip`.`start_date`, `Trip`.`end_date`, `Trip`.`access_level`, `Trip`.`privacy_level`, `Trip`.`photo_filename`, `Trip`.`account_id`, `Trip`.`email`, `Trip`.`created`, `Trip`.`modified` FROM `trips` AS `Trip` WHERE `Trip`.`id` IS NULL AND ((`Trip`.`start_date` <= NOW()) AND (`Trip`.`end_date` >= NOW())) ORDER BY `Trip`.`created` DESC LIMIT 1 | 0 | 0 | 0 | |
| 33 | SELECT `Trip`.`id`, `Trip`.`title`, `Trip`.`description`, `Trip`.`start_date`, `Trip`.`end_date`, `Trip`.`access_level`, `Trip`.`privacy_level`, `Trip`.`photo_filename`, `Trip`.`account_id`, `Trip`.`email`, `Trip`.`created`, `Trip`.`modified` FROM `trips` AS `Trip` WHERE `Trip`.`id` IS NULL ORDER BY `Trip`.`start_date` DESC LIMIT 1 | 0 | 0 | 0 | |
| 34 | SELECT `Trip`.`id`, `Trip`.`title` FROM `trips` AS `Trip` WHERE `Trip`.`id` IS NULL ORDER BY `Trip`.`start_date` DESC | 0 | 0 | 3 | |
| 35 | SELECT `TripMember`.`id`, `TripMember`.`trip_id` FROM `trip_members` AS `TripMember` WHERE `TripMember`.`account_id` = 'James Haycock' AND `TripMember`.`status` = 0 | 0 | 0 | 0 | |
| 36 | SELECT `Trip`.`id`, `Trip`.`title`, `Trip`.`description`, `Trip`.`start_date`, `Trip`.`end_date`, `Trip`.`access_level`, `Trip`.`privacy_level`, `Trip`.`photo_filename`, `Trip`.`account_id`, `Trip`.`email`, `Trip`.`created`, `Trip`.`modified`, `Account`.`id`, `Account`.`forename`, `Account`.`surname`, `Account`.`nickname`, `Account`.`email`, `Account`.`password`, `Account`.`dob`, `Account`.`gender`, `Account`.`privacy_level`, `Account`.`nationality`, `Account`.`photo_filename`, `Account`.`fb_uid`, `Account`.`use_fb`, `Account`.`email_hash`, `Account`.`permission_group_id`, `Account`.`status`, `Account`.`disabled`, `Account`.`created`, `Account`.`modified`, `FeaturedTrip`.`id`, `FeaturedTrip`.`account_id`, `FeaturedTrip`.`trip_id`, `FeaturedTrip`.`created`, `FeaturedTrip`.`modified` FROM `trips` AS `Trip` LEFT JOIN `accounts` AS `Account` ON (`Trip`.`account_id` = `Account`.`id`) LEFT JOIN `featured_trips` AS `FeaturedTrip` ON (`FeaturedTrip`.`trip_id` = `Trip`.`id`) WHERE `Trip`.`id` IS NULL ORDER BY `Trip`.`start_date` DESC | 0 | 0 | 0 | |
| 37 | SELECT `Blog`.`id`, `Blog`.`scoop_id`, `Blog`.`title`, `Blog`.`content`, `Blog`.`photo_filename`, `Blog`.`views`, `Blog`.`rating`, `Scoop`.`id`, `Scoop`.`account_id`, `Scoop`.`trip_id`, `Scoop`.`trip_destination_id`, `Scoop`.`foreign_id`, `Scoop`.`class`, `Scoop`.`pub_date`, `Scoop`.`created`, `Scoop`.`modified` FROM `blogs` AS `Blog` LEFT JOIN `scoops` AS `Scoop` ON (`Blog`.`scoop_id` = `Scoop`.`id`) WHERE `Scoop`.`class` = 'Blog' AND `Scoop`.`account_id` = 'James Haycock' ORDER BY rand() ASC LIMIT 4 | 0 | 0 | 1 | |
| 38 | SELECT `Photo`.`id`, `Photo`.`photo_album_id`, `Photo`.`scoop_id`, `Photo`.`title`, `Photo`.`filename`, `Photo`.`views`, `Photo`.`rating`, `Scoop`.`id`, `Scoop`.`account_id`, `Scoop`.`trip_id`, `Scoop`.`trip_destination_id`, `Scoop`.`foreign_id`, `Scoop`.`class`, `Scoop`.`pub_date`, `Scoop`.`created`, `Scoop`.`modified` FROM `photos` AS `Photo` LEFT JOIN `scoops` AS `Scoop` ON (`Photo`.`scoop_id` = `Scoop`.`id`) WHERE `Scoop`.`class` = 'PhotoAlbum' AND `Scoop`.`account_id` = 'James Haycock' ORDER BY rand() ASC LIMIT 4 | 0 | 0 | 0 | |
| 39 | SELECT `Video`.`id`, `Video`.`scoop_id`, `Video`.`filename`, `Video`.`title`, `Video`.`description`, `Video`.`length`, `Video`.`thumbnail_url`, `Video`.`views`, `Video`.`rating`, `Scoop`.`id`, `Scoop`.`account_id`, `Scoop`.`trip_id`, `Scoop`.`trip_destination_id`, `Scoop`.`foreign_id`, `Scoop`.`class`, `Scoop`.`pub_date`, `Scoop`.`created`, `Scoop`.`modified` FROM `videos` AS `Video` LEFT JOIN `scoops` AS `Scoop` ON (`Scoop`.`foreign_id` = `Video`.`id` AND `Scoop`.`class` = 'Video') WHERE `Scoop`.`class` = 'Video' AND `Scoop`.`account_id` = 'James Haycock' ORDER BY rand() ASC LIMIT 4 | 0 | 0 | 0 | |
| 40 | SELECT COUNT(*) AS `count` FROM `messages` AS `Message` LEFT JOIN `accounts` AS `Author` ON (`Message`.`author_id` = `Author`.`id` AND `Author`.`status` <> 0) LEFT JOIN `accounts` AS `Recipient` ON (`Message`.`recipient_id` = `Recipient`.`id`) WHERE `Message`.`recipient_id` IS NULL AND `Message`.`viewed` = 0 | 1 | 1 | 0 | |
| 41 | SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'e72e664cd5eada79310a4c2acbf2c224' | 1 | 1 | 0 | |
| 42 | UPDATE `cake_sessions` SET `data` = 'Config|a:4:{s:9:\"userAgent\";s:0:\"\";s:4:\"time\";i:1337517641;s:4:\"rand\";i:293028519;s:7:\"timeout\";i:10;}Message|a:0:{}Auth|a:1:{s:7:\"Account\";N;}', `expires` = 1337517641 WHERE `id` = 'e72e664cd5eada79310a4c2acbf2c224' | 1 | 0 |
