Video album deleted when friendship requested

I know this is crazy, but I have been chasing down this bug for over two months now.

I have tested this on my live server, and two development servers.  On the Development servers I downloaded the latest 7.0.2 installer and setup a totally new copy of a dolphin 7.0.2 site following Boonex's directions.  I have confirmed that this issue happens with a 'virgin' dolphin 7.0.2 install. The only module that is enabled is Boonex's Videos. There are NOT any changes to the code or other modules running. This is 100% Boonex code and defaults.

I am using Ubuntu 9.10 and 10.4 server addition for my test servers with the basic LAMP and SSH options during install. I also install php5-cli php5-gd php5-dev and use this guide to install imagemagick http://www.theatons.com/install-imagemagick-imagick-for-php-on-ubuntu.

 

How to reproduce:

MrTester uploads a video.  Everything related to uploading and processing the video works. MrTester and others can view the video.

MrsTester friend requests MrTester.  Now MrTester's video album is missing.

 

 

I am posting an SQL log in the next post that shows what Dolphin did to the database before and after the album was deleted. Do a search on this page for DELETE FROM `sys_albums` WHERE `ID`='2' to find the database action the removed the album, then work your way up. You  will see that the actions that proceed this are related to the friend requests and site actions.

 

I would be grateful if others can test this and confirm the issue. Thanks.

Light man a fire keep him warm for a night, light him ON fire & he will be warm the rest of his life
Quote · 4 Sep 2010

 

Rows: 341

event_time user_host thread_id server_id command_type argument
2010-09-03 19:46:50 d702[d702] @ localhost [] 1 0 Connect d702@localhost on
2010-09-03 19:46:50 d702[d702] @ localhost [] 1 0 Init DB d702
2010-09-03 19:46:50 d702[d702] @ localhost [] 1 0 Query SET NAMES 'utf8'
2010-09-03 19:46:50 d702[d702] @ localhost [] 1 0 Query SET sql_mode = ''
2010-09-03 19:46:50 d702[d702] @ localhost [] 1 0 Query SELECT `ID` FROM `sys_localization_languages` WHERE `Name`='en' LIMIT 1
2010-09-03 19:46:50 d702[d702] @ localhost [] 1 0 Query SELECT 
`id` AS `id`,
`unit` AS `unit`,
`action` AS `action`,
`template` AS `template`,
`params` AS `params`
FROM `sys_sbs_types`
WHERE `unit`='system' AND `action`='begin'
LIMIT 1
2010-09-03 19:46:50 d702[d702] @ localhost [] 1 0 Query SELECT `id` AS `subscription_id`, `subscriber_id` AS `id`, `subscriber_type` AS `type` FROM `sys_sbs_entries` WHERE `subscription_id`=''
2010-09-03 19:46:50 d702[d702] @ localhost [] 1 0 Query SELECT * 
FROM `sys_admin_ban_list` 
WHERE `ProfID`='3'
2010-09-03 19:46:50 d702[d702] @ localhost [] 1 0 Query UPDATE `Profiles` SET `DateLastNav` = NOW() WHERE `ID` = '3'
2010-09-03 19:46:50 d702[d702] @ localhost [] 1 0 Query SELECT 
`ID`, `Sender`, `Type`
FROM 
`sys_messages` 
WHERE 
(
`Recipient` = 3
AND
NOT FIND_IN_SET('Recipient', `Trash`)
)
AND
`New` = '1'
ORDER BY
`Date`
2010-09-03 19:46:50 d702[d702] @ localhost [] 1 0 Query SELECT 
p.`ID`
FROM 
`Profiles` AS p
LEFT JOIN 
`sys_friend_list` AS f1 
ON 
(
f1.`ID` = p.`ID` AND f1.`Profile` =3
AND 
`f1`.`Check` = 1
)
LEFT JOIN 
`sys_friend_list` AS f2 
ON 
(
f2.`Profile` = p.`ID` 
AND 
f2.`ID` =3
AND 
`f2`.`Check` = 1
)
WHERE 1
AND 
(
f1.`ID` IS NOT NULL OR f2.`ID` IS NOT NULL
)
AND 
(
p.`DateLastNav` > SUBDATE(NOW(), INTERVAL 1 MINUTE)
)
2010-09-03 19:46:56 d702[d702] @ localhost [] 1 0 Init DB d702
2010-09-03 19:46:56 d702[d702] @ localhost [] 1 0 Query SET NAMES 'utf8'
2010-09-03 19:46:56 d702[d702] @ localhost [] 1 0 Query SET sql_mode = ''
2010-09-03 19:46:56 d702[d702] @ localhost [] 1 0 Query SELECT `ID` FROM `sys_localization_languages` WHERE `Name`='en' LIMIT 1
2010-09-03 19:46:56 d702[d702] @ localhost [] 1 0 Query SELECT 
`id` AS `id`,
`unit` AS `unit`,
`action` AS `action`,
`template` AS `template`,
`params` AS `params`
FROM `sys_sbs_types`
WHERE `unit`='system' AND `action`='begin'
LIMIT 1
2010-09-03 19:46:56 d702[d702] @ localhost [] 1 0 Query SELECT `id` AS `subscription_id`, `subscriber_id` AS `id`, `subscriber_type` AS `type` FROM `sys_sbs_entries` WHERE `subscription_id`=''
2010-09-03 19:46:56 d702[d702] @ localhost [] 1 0 Query SELECT * 
FROM `sys_admin_ban_list` 
WHERE `ProfID`='3'
2010-09-03 19:46:56 d702[d702] @ localhost [] 1 0 Query UPDATE `Profiles` SET `DateLastNav` = NOW() WHERE `ID` = '3'
2010-09-03 19:46:56 d702[d702] @ localhost [] 1 0 Query SELECT 
`ID`, `Sender`, `Type`
FROM 
`sys_messages` 
WHERE 
(
`Recipient` = 3
AND
NOT FIND_IN_SET('Recipient', `Trash`)
)
AND
`New` = '1'
ORDER BY
`Date`
2010-09-03 19:46:56 d702[d702] @ localhost [] 1 0 Query SELECT 
p.`ID`
FROM 
`Profiles` AS p
LEFT JOIN 
`sys_friend_list` AS f1 
ON 
(
f1.`ID` = p.`ID` AND f1.`Profile` =3
AND 
`f1`.`Check` = 1
)
LEFT JOIN 
`sys_friend_list` AS f2 
ON 
(
f2.`Profile` = p.`ID` 
AND 
f2.`ID` =3
AND 
`f2`.`Check` = 1
)
WHERE 1
AND 
(
f1.`ID` IS NOT NULL OR f2.`ID` IS NOT NULL
)
AND 
(
p.`DateLastNav` > SUBDATE(NOW(), INTERVAL 1 MINUTE)
)
2010-09-03 19:47:02 d702[d702] @ localhost [] 1 0 Init DB d702
2010-09-03 19:47:02 d702[d702] @ localhost [] 1 0 Query SET NAMES 'utf8'
2010-09-03 19:47:02 d702[d702] @ localhost [] 1 0 Query SET sql_mode = ''
2010-09-03 19:47:02 d702[d702] @ localhost [] 1 0 Query SELECT `ID` FROM `sys_localization_languages` WHERE `Name`='en' LIMIT 1
2010-09-03 19:47:02 d702[d702] @ localhost [] 1 0 Query SELECT 
`id` AS `id`,
`unit` AS `unit`,
`action` AS `action`,
`template` AS `template`,
`params` AS `params`
FROM `sys_sbs_types`
WHERE `unit`='system' AND `action`='begin'
LIMIT 1
2010-09-03 19:47:02 d702[d702] @ localhost [] 1 0 Query SELECT `id` AS `subscription_id`, `subscriber_id` AS `id`, `subscriber_type` AS `type` FROM `sys_sbs_entries` WHERE `subscription_id`=''
2010-09-03 19:47:02 d702[d702] @ localhost [] 1 0 Query SELECT * 
FROM `sys_admin_ban_list` 
WHERE `ProfID`='3'
2010-09-03 19:47:02 d702[d702] @ localhost [] 1 0 Query UPDATE `Profiles` SET `DateLastNav` = NOW() WHERE `ID` = '3'
2010-09-03 19:47:02 d702[d702] @ localhost [] 1 0 Query SELECT 
`ID`, `Sender`, `Type`
FROM 
`sys_messages` 
WHERE 
(
`Recipient` = 3
AND
NOT FIND_IN_SET('Recipient', `Trash`)
)
AND
`New` = '1'
ORDER BY
`Date`
2010-09-03 19:47:02 d702[d702] @ localhost [] 1 0 Query SELECT 
p.`ID`
FROM 
`Profiles` AS p
LEFT JOIN 
`sys_friend_list` AS f1 
ON 
(
f1.`ID` = p.`ID` AND f1.`Profile` =3
AND 
`f1`.`Check` = 1
)
LEFT JOIN 
`sys_friend_list` AS f2 
ON 
(
f2.`Profile` = p.`ID` 
AND 
f2.`ID` =3
AND 
`f2`.`Check` = 1
)
WHERE 1
AND 
(
f1.`ID` IS NOT NULL OR f2.`ID` IS NOT NULL
)
AND 
(
p.`DateLastNav` > SUBDATE(NOW(), INTERVAL 1 MINUTE)
)
2010-09-03 19:47:08 d702[d702] @ localhost [] 1 0 Init DB d702
2010-09-03 19:47:08 d702[d702] @ localhost [] 1 0 Query SET NAMES 'utf8'
2010-09-03 19:47:08 d702[d702] @ localhost [] 1 0 Query SET sql_mode = ''
2010-09-03 19:47:08 d702[d702] @ localhost [] 1 0 Query SELECT `ID` FROM `sys_localization_languages` WHERE `Name`='en' LIMIT 1
2010-09-03 19:47:08 d702[d702] @ localhost [] 1 0 Query SELECT 
`id` AS `id`,
`unit` AS `unit`,
`action` AS `action`,
`template` AS `template`,
`params` AS `params`
FROM `sys_sbs_types`
WHERE `unit`='system' AND `action`='begin'
LIMIT 1
2010-09-03 19:47:08 d702[d702] @ localhost [] 1 0 Query SELECT `id` AS `subscription_id`, `subscriber_id` AS `id`, `subscriber_type` AS `type` FROM `sys_sbs_entries` WHERE `subscription_id`=''
2010-09-03 19:47:08 d702[d702] @ localhost [] 1 0 Query SELECT * 
FROM `sys_admin_ban_list` 
WHERE `ProfID`='3'
2010-09-03 19:47:08 d702[d702] @ localhost [] 1 0 Query SELECT `id`, `title`, `vendor`, `version`, `update_url`, `path`, `uri`, `class_prefix`, `db_prefix`, `date` FROM `sys_modules` WHERE `uri`='videos' LIMIT 1
2010-09-03 19:47:08 d702[d702] @ localhost [] 1 0 Query SELECT * 
FROM `sys_admin_ban_list` 
WHERE `ProfID`='3'
2010-09-03 19:47:08 d702[d702] @ localhost [] 1 0 Query SELECT `sys_albums`.`ID`, `sys_albums`.`Caption`, `sys_albums`.`Uri`, `sys_albums`.`Location`, `sys_albums`.`Description`, `sys_albums`.`Type`, `sys_albums`.`Owner`, `sys_albums`.`Status`, `sys_albums`.`Date`, `sys_albums`.`AllowAlbumView`, `sys_albums`.`ObjCount`, `sys_albums`.`LastObjId` FROM `sys_albums` WHERE `sys_albums`.`Type`='bx_videos' AND `sys_albums`.`Uri`='msTester-s-videos' AND `sys_albums`.`Owner`='3' LIMIT 1
2010-09-03 19:47:08 d702[d702] @ localhost [] 1 0 Query INSERT INTO  `sys_albums` SET `Caption` = 'msTester's videos', `Uri` = 'msTester-s-videos', `Location` = 'Undefined', `AllowAlbumView` = '3', `Type` = 'bx_videos', `Owner` = '3', `Status` = 'active', `Date` = '1283568428', `LastObjId` = '0'
2010-09-03 19:47:08 d702[d702] @ localhost [] 1 0 Query SELECT COUNT(`ID`) FROM `sys_albums` WHERE `Type` = 'bx_videos' AND `Status` = 'active' AND `Owner` = '3'
2010-09-03 19:47:08 d702[d702] @ localhost [] 1 0 Query SELECT COUNT(`ID`) FROM `sys_albums` WHERE `Type` = 'bx_videos' AND `Status` = 'active' AND `Owner` = '3'
2010-09-03 19:47:08 d702[d702] @ localhost [] 1 0 Query SELECT `ID`, `Caption`, `Uri`, `Owner`, `Status`, `Date`, `ObjCount`, `AllowAlbumView`, `LastObjId` FROM `sys_albums` WHERE `Type` = 'bx_videos' AND `Status` = 'active' AND `Owner` = '3'   ORDER BY `Date` DESC LIMIT 0, 4
2010-09-03 19:47:08 d702[d702] @ localhost [] 1 0 Query SELECT `Owner` AS `owner_id`, `AllowAlbumView` AS `group_id` FROM `sys_albums` WHERE `ID`='2' LIMIT 1
2010-09-03 19:47:08 d702[d702] @ localhost [] 1 0 Query SELECT `id`, `user_id`, `data` FROM `sys_sessions` WHERE `id`='4DuaUVyF.5Aud7.dMLK=zziC=L8yZTed' LIMIT 1
2010-09-03 19:47:08 d702[d702] @ localhost [] 1 0 Query SELECT * FROM `sys_banners` WHERE `Active` <> 0 AND `campaign_start` <= NOW() AND `campaign_end` >= NOW()  AND `Position` LIKE '%2%' ORDER BY RAND() LIMIT 1
2010-09-03 19:47:08 d702[d702] @ localhost [] 1 0 Query SELECT * FROM `sys_banners` WHERE `Active` <> 0 AND `campaign_start` <= NOW() AND `campaign_end` >= NOW()  AND `Position` LIKE '%3%' ORDER BY RAND() LIMIT 1
2010-09-03 19:47:08 d702[d702] @ localhost [] 1 0 Query SELECT count(ID) as count_id FROM Profiles WHERE DateLastNav > SUBDATE(NOW(), INTERVAL 1 MINUTE) AND ID=3
2010-09-03 19:47:08 d702[d702] @ localhost [] 1 0 Query SELECT `UserStatus` FROM `Profiles` WHERE `ID` = 3
2010-09-03 19:47:08 d702[d702] @ localhost [] 1 0 Query SELECT count(ID) as count_id FROM Profiles WHERE DateLastNav > SUBDATE(NOW(), INTERVAL 1 MINUTE) AND ID=3
2010-09-03 19:47:08 d702[d702] @ localhost [] 1 0 Query SELECT `UserStatus` FROM `Profiles` WHERE `ID` = 3
2010-09-03 19:47:08 d702[d702] @ localhost [] 1 0 Query SELECT * FROM `sys_localization_languages` ORDER BY `Title` ASC
2010-09-03 19:47:08 d702[d702] @ localhost [] 1 0 Query SELECT 
`ID`, `Sender`, `Type`
FROM 
`sys_messages` 
WHERE 
(
`Recipient` = 3
AND
NOT FIND_IN_SET('Recipient', `Trash`)
)
AND
`New` = '1'
ORDER BY
`Date`
2010-09-03 19:47:08 d702[d702] @ localhost [] 1 0 Query SELECT 
p.`ID`
FROM 
`Profiles` AS p
LEFT JOIN 
`sys_friend_list` AS f1 
ON 
(
f1.`ID` = p.`ID` AND f1.`Profile` =3
AND 
`f1`.`Check` = 1
)
LEFT JOIN 
`sys_friend_list` AS f2 
ON 
(
f2.`Profile` = p.`ID` 
AND 
f2.`ID` =3
AND 
`f2`.`Check` = 1
)
WHERE 1
AND 
(
f1.`ID` IS NOT NULL OR f2.`ID` IS NOT NULL
)
AND 
(
p.`DateLastNav` > SUBDATE(NOW(), INTERVAL 1 MINUTE)
)
2010-09-03 19:47:08 d702[d702] @ localhost [] 1 0 Query SELECT * FROM `sys_banners` WHERE `Active` <> 0 AND `campaign_start` <= NOW() AND `campaign_end` >= NOW()  AND `Position` LIKE '%1%' ORDER BY RAND() LIMIT 1
2010-09-03 19:47:08 d702[d702] @ localhost [] 1 0 Query SELECT * FROM `sys_localization_languages` ORDER BY `Title` ASC
2010-09-03 19:47:08 d702[d702] @ localhost [] 1 0 Query SELECT count(ID) as count_id FROM Profiles WHERE DateLastNav > SUBDATE(NOW(), INTERVAL 1 MINUTE) AND ID=3
2010-09-03 19:47:08 d702[d702] @ localhost [] 1 0 Query SELECT `UserStatus` FROM `Profiles` WHERE `ID` = 3
2010-09-03 19:47:08 d702[d702] @ localhost [] 1 0 Query SELECT count(ID) as count_id FROM Profiles WHERE DateLastNav > SUBDATE(NOW(), INTERVAL 1 MINUTE) AND ID=3
2010-09-03 19:47:08 d702[d702] @ localhost [] 1 0 Query SELECT `UserStatus` FROM `Profiles` WHERE `ID` = 3
2010-09-03 19:47:08 d702[d702] @ localhost [] 1 0 Query SELECT * FROM `sys_banners` WHERE `Active` <> 0 AND `campaign_start` <= NOW() AND `campaign_end` >= NOW()  AND `Position` LIKE '%4%' ORDER BY RAND() LIMIT 1
2010-09-03 19:48:02 d702[d702] @ localhost [] 1 0 Init DB d702
2010-09-03 19:48:02 d702[d702] @ localhost [] 1 0 Query SET NAMES 'utf8'
2010-09-03 19:48:02 d702[d702] @ localhost [] 1 0 Query SET sql_mode = ''
2010-09-03 19:48:02 d702[d702] @ localhost [] 1 0 Query SELECT `ID` FROM `sys_localization_languages` WHERE `Name`='en' LIMIT 1
2010-09-03 19:48:02 d702[d702] @ localhost [] 1 0 Query SELECT 
`id` AS `id`,
`unit` AS `unit`,
`action` AS `action`,
`template` AS `template`,
`params` AS `params`
FROM `sys_sbs_types`
WHERE `unit`='system' AND `action`='begin'
LIMIT 1
2010-09-03 19:48:02 d702[d702] @ localhost [] 1 0 Query SELECT `id` AS `subscription_id`, `subscriber_id` AS `id`, `subscriber_type` AS `type` FROM `sys_sbs_entries` WHERE `subscription_id`=''
2010-09-03 19:48:02 d702[d702] @ localhost [] 1 0 Query SELECT COUNT(*) FROM `Profiles` WHERE `NickName` = 'BabyTester'
2010-09-03 19:48:02 d702[d702] @ localhost [] 1 0 Query SELECT COUNT(*) FROM `Profiles` WHERE `Email` = 'baby@localhost.net'
2010-09-03 19:48:02 d702[d702] @ localhost [] 1 0 Init DB d702
2010-09-03 19:48:02 d702[d702] @ localhost [] 1 0 Query SET NAMES 'utf8'
2010-09-03 19:48:02 d702[d702] @ localhost [] 1 0 Query SET sql_mode = ''
2010-09-03 19:48:02 d702[d702] @ localhost [] 1 0 Query SELECT `ID` FROM `sys_localization_languages` WHERE `Name`='en' LIMIT 1
2010-09-03 19:48:02 d702[d702] @ localhost [] 1 0 Query SELECT 
`id` AS `id`,
`unit` AS `unit`,
`action` AS `action`,
`template` AS `template`,
`params` AS `params`
FROM `sys_sbs_types`
WHERE `unit`='system' AND `action`='begin'
LIMIT 1
2010-09-03 19:48:02 d702[d702] @ localhost [] 1 0 Query SELECT `id` AS `subscription_id`, `subscriber_id` AS `id`, `subscriber_type` AS `type` FROM `sys_sbs_entries` WHERE `subscription_id`=''
2010-09-03 19:48:02 d702[d702] @ localhost [] 1 0 Query SELECT COUNT(*) FROM `Profiles` WHERE `NickName` = 'BabyTester'
2010-09-03 19:48:02 d702[d702] @ localhost [] 1 0 Query SELECT COUNT(*) FROM `Profiles` WHERE `Email` = 'baby@worldtribes.net'
2010-09-03 19:48:02 d702[d702] @ localhost [] 1 0 Query SELECT `ID` FROM `sys_localization_languages` WHERE `Name`='en' LIMIT 1
2010-09-03 19:48:02 d702[d702] @ localhost [] 1 0 Query SELECT `ID` FROM `sys_localization_languages` WHERE `Name`='en' LIMIT 1
2010-09-03 19:48:02 d702[d702] @ localhost [] 1 0 Query SELECT 
`id` AS `id`,
`unit` AS `unit`,
`action` AS `action`,
`template` AS `template`,
`params` AS `params`
FROM `sys_sbs_types`
WHERE `unit`='profile' AND `action`='before_join'
LIMIT 1
2010-09-03 19:48:02 d702[d702] @ localhost [] 1 0 Query SELECT `id` AS `subscription_id`, `subscriber_id` AS `id`, `subscriber_type` AS `type` FROM `sys_sbs_entries` WHERE `subscription_id`=''
2010-09-03 19:48:02 d702[d702] @ localhost [] 1 0 Query INSERT INTO `Profiles` SET 
`NickName` = 'BabyTester',
`Password` = 'password',
`Email` = 'baby@worldtribes.net',
`DateReg` = '2010-09-03 19:48:02',
`DateLastEdit` = '0000-00-00',
`Status` = 'Active',
`DateLastLogin` = '0000-00-00',
`Featured` = 0,
`Sex` = 'male',
`LookingFor` = '',
`DescriptionMe` = '',
`DateOfBirth` = '',
`Headline` = '',
`Country` = 'US',
`City` = '',
`Couple` = 0,
`Tags` = '',
`zip` = '',
`EmailNotify` = 1,
`Height` = '',
`Weight` = '',
`Income` = '',
`Occupation` = '',
`Religion` = '',
`Education` = '',
`RelationshipStatus` = '',
`Hobbies` = '',
`Interests` = '',
`Ethnicity` = '',
`FavoriteSites` = '',
`FavoriteMusic` = '',
`FavoriteFilms` = '',
`FavoriteBooks` = '',
`FirstName` = '',
`LastName` = ''
2010-09-03 19:48:02 d702[d702] @ localhost [] 1 0 Query SELECT * FROM `Profiles` WHERE `ID`='4' LIMIT 1
2010-09-03 19:48:02 d702[d702] @ localhost [] 1 0 Query SELECT * FROM `Profiles` WHERE `ID` = 4
2010-09-03 19:48:02 d702[d702] @ localhost [] 1 0 Query SELECT `Subject`, `Body` FROM `sys_email_templates` WHERE `Name`='t_Activation' AND (`LangID` = '1' OR `LangID` = '0') ORDER BY `LangID` DESC LIMIT 1
2010-09-03 19:48:02 d702[d702] @ localhost [] 1 0 Query SELECT `ID` FROM `sys_localization_languages` WHERE `Name`='en' LIMIT 1
2010-09-03 19:48:02 d702[d702] @ localhost [] 1 0 Query SELECT `ID` FROM `sys_localization_languages` WHERE `Name`='en' LIMIT 1
2010-09-03 19:48:02 d702[d702] @ localhost [] 1 0 Query SELECT 
`id` AS `id`,
`unit` AS `unit`,
`action` AS `action`,
`template` AS `template`,
`params` AS `params`
FROM `sys_sbs_types`
WHERE `unit`='profile' AND `action`='send_mail'
LIMIT 1
2010-09-03 19:48:02 d702[d702] @ localhost [] 1 0 Query SELECT `id` AS `subscription_id`, `subscriber_id` AS `id`, `subscriber_type` AS `type` FROM `sys_sbs_entries` WHERE `subscription_id`='' AND `object_id`='4'
2010-09-03 19:48:02 d702[d702] @ localhost [] 1 0 Query UPDATE `Profiles` SET `Password` = '66effae0d54a12b25af88fb240323a58468657f9',
`Salt` = 'V9d/=4.q',
`UpdateMatch` = 0 WHERE `ID` = 4
2010-09-03 19:48:02 d702[d702] @ localhost [] 1 0 Query SELECT * FROM `Profiles` WHERE `ID`='4' LIMIT 1
2010-09-03 19:48:02 d702[d702] @ localhost [] 1 0 Query SELECT `ID` FROM `sys_localization_languages` WHERE `Name`='en' LIMIT 1
2010-09-03 19:48:02 d702[d702] @ localhost [] 1 0 Query SELECT 
`id` AS `id`,
`unit` AS `unit`,
`action` AS `action`,
`template` AS `template`,
`params` AS `params`
FROM `sys_sbs_types`
WHERE `unit`='profile' AND `action`='join'
LIMIT 1
2010-09-03 19:48:02 d702[d702] @ localhost [] 1 0 Query SELECT `id` AS `subscription_id`, `subscriber_id` AS `id`, `subscriber_type` AS `type` FROM `sys_sbs_entries` WHERE `subscription_id`='' AND `object_id`='4'
2010-09-03 19:48:02 d702[d702] @ localhost [] 1 0 Query SELECT `ID` FROM `sys_localization_languages` WHERE `Name`='en' LIMIT 1
2010-09-03 19:48:02 d702[d702] @ localhost [] 1 0 Query DELETE FROM `sys_tags` WHERE `ObjID` = 4 AND `Type` = 'profile'
2010-09-03 19:48:02 d702[d702] @ localhost [] 1 0 Query SELECT `Tags` FROM `Profiles` WHERE `ID` = 4 AND `Status` = 'Active'
2010-09-03 19:48:02 d702[d702] @ localhost [] 1 0 Query SELECT * FROM `Profiles` WHERE `ID` = 4
event_time user_host thread_id server_id command_type argument
2010-09-03 19:48:02 d702[d702] @ localhost [] 1 0 Query SELECT `ID` FROM `sys_localization_languages` WHERE `Name`='en' LIMIT 1
2010-09-03 19:48:02 d702[d702] @ localhost [] 1 0 Query SELECT `Subject`, `Body` FROM `sys_email_templates` WHERE `Name`='t_UserJoined' AND (`LangID` = '1' OR `LangID` = '0') ORDER BY `LangID` DESC LIMIT 1
2010-09-03 19:48:02 d702[d702] @ localhost [] 1 0 Query SELECT `ID` FROM `sys_localization_languages` WHERE `Name`='en' LIMIT 1
2010-09-03 19:48:02 d702[d702] @ localhost [] 1 0 Query SELECT `ID` FROM `sys_localization_languages` WHERE `Name`='en' LIMIT 1
2010-09-03 19:48:02 d702[d702] @ localhost [] 1 0 Query SELECT 
`id` AS `id`,
`unit` AS `unit`,
`action` AS `action`,
`template` AS `template`,
`params` AS `params`
FROM `sys_sbs_types`
WHERE `unit`='profile' AND `action`='send_mail'
LIMIT 1
2010-09-03 19:48:02 d702[d702] @ localhost [] 1 0 Query SELECT `id` AS `subscription_id`, `subscriber_id` AS `id`, `subscriber_type` AS `type` FROM `sys_sbs_entries` WHERE `subscription_id`='' AND `object_id`='4'
2010-09-03 19:48:02 d702[d702] @ localhost [] 1 0 Query SELECT COUNT(ID) FROM Profiles WHERE ID = 4
2010-09-03 19:48:02 d702[d702] @ localhost [] 1 0 Query SELECT COUNT(ID) FROM `sys_acl_levels` WHERE ID = 3
2010-09-03 19:48:02 d702[d702] @ localhost [] 1 0 Query SELECT    `sys_acl_levels_members`.IDLevel as ID,
`sys_acl_levels`.Name as Name,
UNIX_TIMESTAMP(`sys_acl_levels_members`.DateStarts) as DateStarts,
UNIX_TIMESTAMP(`sys_acl_levels_members`.DateExpires) as DateExpires,
`sys_acl_levels_members`.`TransactionID` AS `TransactionID`
FROM    `sys_acl_levels_members`
RIGHT JOIN Profiles
ON `sys_acl_levels_members`.IDMember = Profiles.ID
AND    (`sys_acl_levels_members`.DateStarts IS NULL
OR `sys_acl_levels_members`.DateStarts <= FROM_UNIXTIME(1283568482))
AND    (`sys_acl_levels_members`.DateExpires IS NULL
OR `sys_acl_levels_members`.DateExpires > FROM_UNIXTIME(1283568482))
LEFT JOIN `sys_acl_levels`
ON `sys_acl_levels_members`.IDLevel = `sys_acl_levels`.ID

WHERE    Profiles.ID = 4

ORDER BY `sys_acl_levels_members`.DateStarts DESC

LIMIT 0, 1
2010-09-03 19:48:02 d702[d702] @ localhost [] 1 0 Query INSERT `sys_acl_levels_members` (IDMember, IDLevel, DateStarts, DateExpires, TransactionID)
VALUES (4, 3, FROM_UNIXTIME(1283568482), FROM_UNIXTIME(1284173282), 'NULL')
2010-09-03 19:48:02 d702[d702] @ localhost [] 1 0 Query SELECT 
`Status` 
FROM 
`Profiles`
WHERE 
`ID` = 4
2010-09-03 19:48:02 d702[d702] @ localhost [] 1 0 Query UPDATE `Profiles` SET `UpdateMatch` = 0 WHERE `ID`= 4
2010-09-03 19:48:02 d702[d702] @ localhost [] 1 0 Query DELETE FROM `sys_profiles_match`
2010-09-03 19:48:02 d702[d702] @ localhost [] 1 0 Query SELECT `profiles_match` FROM `sys_profiles_match_mails` WHERE `profile_id` = 4
2010-09-03 19:48:02 d702[d702] @ localhost [] 1 0 Query SELECT `profiles_match` FROM `sys_profiles_match` WHERE `profile_id` = 4 AND `sort` = 'none'
2010-09-03 19:48:02 d702[d702] @ localhost [] 1 0 Query SELECT DATE_FORMAT(FROM_DAYS(DATEDIFF(NOW(), '0000-00-00')), '%Y') + 0 AS age
2010-09-03 19:48:02 d702[d702] @ localhost [] 1 0 Query SELECT `ID` FROM `Profiles` WHERE `Status` = 'Active' AND `ID` != 4 AND `LookingFor` = 'male'
2010-09-03 19:48:02 d702[d702] @ localhost [] 1 0 Query SELECT `ID` FROM `Profiles` WHERE `Status` = 'Active' AND `ID` != 4 AND `Country` = 'US'
2010-09-03 19:48:02 d702[d702] @ localhost [] 1 0 Query SELECT `ID` FROM `Profiles` WHERE `Status` = 'Active' AND `ID` != 4
2010-09-03 19:48:02 d702[d702] @ localhost [] 1 0 Query INSERT INTO `sys_profiles_match`(`profile_id`, `sort`, `profiles_match`) VALUES(4, 'none', 'a:0:{}')
2010-09-03 19:48:02 d702[d702] @ localhost [] 1 0 Query INSERT INTO `sys_profiles_match_mails`(`profile_id`, `profiles_match`) VALUES(4, 'a:0:{}')
2010-09-03 19:48:02 d702[d702] @ localhost [] 1 0 Query SELECT `id`, `title`, `vendor`, `version`, `update_url`, `path`, `uri`, `class_prefix`, `db_prefix`, `date` FROM `sys_modules` WHERE `uri`='avatar' LIMIT 1
2010-09-03 19:48:02 d702[d702] @ localhost [] 1 0 Query SELECT `id`, `user_id`, `data` FROM `sys_sessions` WHERE `id`='4DuaUVyF.5Aud7.dMLK=zziC=L8yZTed' LIMIT 1
2010-09-03 19:48:02 d702[d702] @ localhost [] 1 0 Query SELECT `ID` FROM `sys_localization_languages` WHERE `Name`='en' LIMIT 1
2010-09-03 19:48:02 d702[d702] @ localhost [] 1 0 Query SELECT 
`id` AS `id`,
`unit` AS `unit`,
`action` AS `action`,
`template` AS `template`,
`params` AS `params`
FROM `sys_sbs_types`
WHERE `unit`='profile' AND `action`='show_login_form'
LIMIT 1
2010-09-03 19:48:02 d702[d702] @ localhost [] 1 0 Query SELECT `id` AS `subscription_id`, `subscriber_id` AS `id`, `subscriber_type` AS `type` FROM `sys_sbs_entries` WHERE `subscription_id`=''
2010-09-03 19:48:02 d702[d702] @ localhost [] 1 0 Query SELECT * FROM `sys_banners` WHERE `Active` <> 0 AND `campaign_start` <= NOW() AND `campaign_end` >= NOW()  AND `Position` LIKE '%2%' ORDER BY RAND() LIMIT 1
2010-09-03 19:48:02 d702[d702] @ localhost [] 1 0 Query SELECT * FROM `sys_banners` WHERE `Active` <> 0 AND `campaign_start` <= NOW() AND `campaign_end` >= NOW()  AND `Position` LIKE '%3%' ORDER BY RAND() LIMIT 1
2010-09-03 19:48:02 d702[d702] @ localhost [] 1 0 Query SELECT * FROM `sys_banners` WHERE `Active` <> 0 AND `campaign_start` <= NOW() AND `campaign_end` >= NOW()  AND `Position` LIKE '%1%' ORDER BY RAND() LIMIT 1
2010-09-03 19:48:02 d702[d702] @ localhost [] 1 0 Query SELECT * FROM `sys_localization_languages` ORDER BY `Title` ASC
2010-09-03 19:48:02 d702[d702] @ localhost [] 1 0 Query SELECT * FROM `sys_banners` WHERE `Active` <> 0 AND `campaign_start` <= NOW() AND `campaign_end` >= NOW()  AND `Position` LIKE '%4%' ORDER BY RAND() LIMIT 1
2010-09-03 19:57:52 d702[d702] @ localhost [] 1 0 Init DB d702
2010-09-03 19:57:52 d702[d702] @ localhost [] 1 0 Query SET NAMES 'utf8'
2010-09-03 19:57:52 d702[d702] @ localhost [] 1 0 Query SET sql_mode = ''
2010-09-03 19:57:52 d702[d702] @ localhost [] 1 0 Query SELECT `ID` FROM `sys_localization_languages` WHERE `Name`='en' LIMIT 1
2010-09-03 19:57:52 d702[d702] @ localhost [] 1 0 Query SELECT 
`id` AS `id`,
`unit` AS `unit`,
`action` AS `action`,
`template` AS `template`,
`params` AS `params`
FROM `sys_sbs_types`
WHERE `unit`='system' AND `action`='begin'
LIMIT 1
2010-09-03 19:57:52 d702[d702] @ localhost [] 1 0 Query SELECT `id` AS `subscription_id`, `subscriber_id` AS `id`, `subscriber_type` AS `type` FROM `sys_sbs_entries` WHERE `subscription_id`=''
2010-09-03 19:57:52 d702[d702] @ localhost [] 1 0 Query SELECT * 
FROM `sys_admin_ban_list` 
WHERE `ProfID`='4'
2010-09-03 19:57:52 d702[d702] @ localhost [] 1 0 Query UPDATE `Profiles` SET `DateLastNav` = NOW() WHERE `ID` = '4'
2010-09-03 19:57:52 d702[d702] @ localhost [] 1 0 Query SELECT 
`ID`, `Sender`, `Type`
FROM 
`sys_messages` 
WHERE 
(
`Recipient` = 4
AND
NOT FIND_IN_SET('Recipient', `Trash`)
)
AND
`New` = '1'
ORDER BY
`Date`
2010-09-03 19:57:52 d702[d702] @ localhost [] 1 0 Query SELECT 
p.`ID`
FROM 
`Profiles` AS p
LEFT JOIN 
`sys_friend_list` AS f1 
ON 
(
f1.`ID` = p.`ID` AND f1.`Profile` =4
AND 
`f1`.`Check` = 1
)
LEFT JOIN 
`sys_friend_list` AS f2 
ON 
(
f2.`Profile` = p.`ID` 
AND 
f2.`ID` =4
AND 
`f2`.`Check` = 1
)
WHERE 1
AND 
(
f1.`ID` IS NOT NULL OR f2.`ID` IS NOT NULL
)
AND 
(
p.`DateLastNav` > SUBDATE(NOW(), INTERVAL 1 MINUTE)
)
2010-09-03 19:57:55 d702[d702] @ localhost [] 1 0 Init DB d702
2010-09-03 19:57:55 d702[d702] @ localhost [] 1 0 Query SET NAMES 'utf8'
2010-09-03 19:57:55 d702[d702] @ localhost [] 1 0 Query SET sql_mode = ''
2010-09-03 19:57:55 d702[d702] @ localhost [] 1 0 Query SELECT `ID` FROM `sys_localization_languages` WHERE `Name`='en' LIMIT 1
2010-09-03 19:57:55 d702[d702] @ localhost [] 1 0 Query SELECT 
`id` AS `id`,
`unit` AS `unit`,
`action` AS `action`,
`template` AS `template`,
`params` AS `params`
FROM `sys_sbs_types`
WHERE `unit`='system' AND `action`='begin'
LIMIT 1
2010-09-03 19:57:55 d702[d702] @ localhost [] 1 0 Query SELECT `id` AS `subscription_id`, `subscriber_id` AS `id`, `subscriber_type` AS `type` FROM `sys_sbs_entries` WHERE `subscription_id`=''
2010-09-03 19:57:55 d702[d702] @ localhost [] 1 0 Query SELECT * 
FROM `sys_admin_ban_list` 
WHERE `ProfID`='4'
2010-09-03 19:57:55 d702[d702] @ localhost [] 1 0 Query SELECT `id`, `title`, `vendor`, `version`, `update_url`, `path`, `uri`, `class_prefix`, `db_prefix`, `date` FROM `sys_modules` WHERE `uri`='videos' LIMIT 1
2010-09-03 19:57:55 d702[d702] @ localhost [] 1 0 Query SELECT * 
FROM `sys_admin_ban_list` 
WHERE `ProfID`='4'
2010-09-03 19:57:55 d702[d702] @ localhost [] 1 0 Query SELECT COUNT(`ID`) FROM `sys_albums` WHERE `Type` = 'bx_videos' AND `Status` = 'active'  AND `AllowAlbumView` IN (3,4)  AND `ObjCount` > 0
2010-09-03 19:57:55 d702[d702] @ localhost [] 1 0 Query SELECT `ID`, `Caption`, `Uri`, `Owner`, `Status`, `Date`, `ObjCount`, `AllowAlbumView`, `LastObjId` FROM `sys_albums` WHERE `Type` = 'bx_videos' AND `Status` = 'active'  AND `AllowAlbumView` IN (3,4)  AND `ObjCount` > 0 ORDER BY `Date` DESC LIMIT 0, 4
2010-09-03 19:57:55 d702[d702] @ localhost [] 1 0 Query SELECT `id_object`  FROM `sys_albums_objects` INNER JOIN `RayVideoFiles` ON `RayVideoFiles`.`ID`=`sys_albums_objects`.`id_object` WHERE `id_album`='2' AND `RayVideoFiles`.`Status`='approved' ORDER BY `obj_order`, `id_object` DESC LIMIT 4
2010-09-03 19:57:55 d702[d702] @ localhost [] 1 0 Query SELECT COUNT(*) FROM `RayVideoFiles`  left JOIN `sys_albums_objects` ON `sys_albums_objects`.`id_object`=`RayVideoFiles`.`ID` left JOIN `sys_albums` ON `sys_albums`.`ID`=`sys_albums_objects`.`id_album` left JOIN `Profiles` ON `Profiles`.`ID`=`RayVideoFiles`.`Owner` WHERE 1 AND `RayVideoFiles`.`Status` ='approved' AND `sys_albums`.`AllowAlbumView` IN('3','4') AND `sys_albums`.`Status` ='active' AND `sys_albums`.`Type` ='bx_videos' AND `RayVideoFiles`.`Featured` ='1'
2010-09-03 19:57:55 d702[d702] @ localhost [] 1 0 Query SELECT COUNT(*) FROM `RayVideoFiles`  left JOIN `sys_albums_objects` ON `sys_albums_objects`.`id_object`=`RayVideoFiles`.`ID` left JOIN `sys_albums` ON `sys_albums`.`ID`=`sys_albums_objects`.`id_album` left JOIN `Profiles` ON `Profiles`.`ID`=`RayVideoFiles`.`Owner` inner JOIN `bx_videos_favorites` ON `bx_videos_favorites`.`ID`=`RayVideoFiles`.`ID` WHERE 1 AND `RayVideoFiles`.`Status` ='approved' AND `sys_albums`.`AllowAlbumView` IN('3','4') AND `sys_albums`.`Status` ='active' AND `sys_albums`.`Type` ='bx_videos' AND `bx_videos_favorites`.`Profile` ='4'
2010-09-03 19:57:55 d702[d702] @ localhost [] 1 0 Query SELECT COUNT(*) FROM `RayVideoFiles`  left JOIN `sys_albums_objects` ON `sys_albums_objects`.`id_object`=`RayVideoFiles`.`ID` left JOIN `sys_albums` ON `sys_albums`.`ID`=`sys_albums_objects`.`id_album` left JOIN `Profiles` ON `Profiles`.`ID`=`RayVideoFiles`.`Owner` WHERE 1 AND `RayVideoFiles`.`Status` ='approved' AND `sys_albums`.`AllowAlbumView` IN('3','4') AND `sys_albums`.`Status` ='active' AND `sys_albums`.`Type` ='bx_videos' AND `RayVideoFiles`.`Featured` ='1'
2010-09-03 19:57:55 d702[d702] @ localhost [] 1 0 Query SELECT `RayVideoFiles`.`ID` as `ID` FROM `RayVideoFiles` LEFT JOIN `sys_albums_objects` ON `sys_albums_objects`.`id_object`=`RayVideoFiles`.`ID`
LEFT JOIN `sys_albums` ON `sys_albums_objects`.`id_album`=`sys_albums`.`ID`
WHERE 1 AND `AllowAlbumView` IN(3, 4) AND `RayVideoFiles`.`Featured` = '1' AND `RayVideoFiles`.`Status`= 'approved' ORDER BY `ID` DESC LIMIT 1
2010-09-03 19:57:55 d702[d702] @ localhost [] 1 0 Query SELECT COUNT(*) FROM `RayVideoFiles`  left JOIN `sys_albums_objects` ON `sys_albums_objects`.`id_object`=`RayVideoFiles`.`ID` left JOIN `sys_albums` ON `sys_albums`.`ID`=`sys_albums_objects`.`id_album` left JOIN `Profiles` ON `Profiles`.`ID`=`RayVideoFiles`.`Owner` WHERE 1 AND `RayVideoFiles`.`Status` ='approved' AND `sys_albums`.`AllowAlbumView` IN('3','4') AND `sys_albums`.`Status` ='active' AND `sys_albums`.`Type` ='bx_videos'
2010-09-03 19:57:55 d702[d702] @ localhost [] 1 0 Query SELECT `RayVideoFiles`.`ID` as `id`, `RayVideoFiles`.`Title` as `title`, `RayVideoFiles`.`Uri` as `uri`, `RayVideoFiles`.`Date` as `date`, `RayVideoFiles`.`Time` as `size`, `RayVideoFiles`.`Rate`, `RayVideoFiles`.`RateCount`, `RayVideoFiles`.`Views` as `view`, `RayVideoFiles`.`Source` as `source`, `RayVideoFiles`.`Video` as `video`, `RayVideoFiles`.`ID`, `sys_albums_objects`.`id_album`, `RayVideoFiles`.`Owner` as `ownerId`,  `sys_albums`.`AllowAlbumView`, `Profiles`.`NickName` as `ownerName`  FROM `RayVideoFiles`  left JOIN `sys_albums_objects` ON `sys_albums_objects`.`id_object`=`RayVideoFiles`.`ID` left JOIN `sys_albums` ON `sys_albums`.`ID`=`sys_albums_objects`.`id_album` left JOIN `Profiles` ON `Profiles`.`ID`=`RayVideoFiles`.`Owner` WHERE 1 AND `RayVideoFiles`.`Status` ='approved' AND `sys_albums`.`AllowAlbumView` IN('3','4') AND `sys_albums`.`Status` ='active' AND `sys_albums`.`Type` ='bx_videos'  ORDER BY `date` DESC LIMIT 0, 12
2010-09-03 19:57:55 d702[d702] @ localhost [] 1 0 Query SELECT `id`, `user_id`, `data` FROM `sys_sessions` WHERE `id`='4DuaUVyF.5Aud7.dMLK=zziC=L8yZTed' LIMIT 1
2010-09-03 19:57:55 d702[d702] @ localhost [] 1 0 Query SELECT * FROM `sys_banners` WHERE `Active` <> 0 AND `campaign_start` <= NOW() AND `campaign_end` >= NOW()  AND `Position` LIKE '%2%' ORDER BY RAND() LIMIT 1
2010-09-03 19:57:55 d702[d702] @ localhost [] 1 0 Query SELECT * FROM `sys_banners` WHERE `Active` <> 0 AND `campaign_start` <= NOW() AND `campaign_end` >= NOW()  AND `Position` LIKE '%3%' ORDER BY RAND() LIMIT 1
2010-09-03 19:57:55 d702[d702] @ localhost [] 1 0 Query SELECT count(ID) as count_id FROM Profiles WHERE DateLastNav > SUBDATE(NOW(), INTERVAL 1 MINUTE) AND ID=4
2010-09-03 19:57:55 d702[d702] @ localhost [] 1 0 Query SELECT `UserStatus` FROM `Profiles` WHERE `ID` = 4
2010-09-03 19:57:55 d702[d702] @ localhost [] 1 0 Query SELECT count(ID) as count_id FROM Profiles WHERE DateLastNav > SUBDATE(NOW(), INTERVAL 1 MINUTE) AND ID=4
2010-09-03 19:57:55 d702[d702] @ localhost [] 1 0 Query SELECT `UserStatus` FROM `Profiles` WHERE `ID` = 4
2010-09-03 19:57:55 d702[d702] @ localhost [] 1 0 Query SELECT * FROM `sys_localization_languages` ORDER BY `Title` ASC
2010-09-03 19:57:55 d702[d702] @ localhost [] 1 0 Query SELECT 
`ID`, `Sender`, `Type`
FROM 
`sys_messages` 
WHERE 
(
`Recipient` = 4
AND
NOT FIND_IN_SET('Recipient', `Trash`)
)
AND
`New` = '1'
ORDER BY
`Date`
2010-09-03 19:57:55 d702[d702] @ localhost [] 1 0 Query SELECT 
p.`ID`
FROM 
`Profiles` AS p
LEFT JOIN 
`sys_friend_list` AS f1 
ON 
(
f1.`ID` = p.`ID` AND f1.`Profile` =4
AND 
`f1`.`Check` = 1
)
LEFT JOIN 
`sys_friend_list` AS f2 
ON 
(
f2.`Profile` = p.`ID` 
AND 
f2.`ID` =4
AND 
`f2`.`Check` = 1
)
WHERE 1
AND 
(
f1.`ID` IS NOT NULL OR f2.`ID` IS NOT NULL
)
AND 
(
p.`DateLastNav` > SUBDATE(NOW(), INTERVAL 1 MINUTE)
)
2010-09-03 19:57:55 d702[d702] @ localhost [] 1 0 Query SELECT * FROM `sys_banners` WHERE `Active` <> 0 AND `campaign_start` <= NOW() AND `campaign_end` >= NOW()  AND `Position` LIKE '%1%' ORDER BY RAND() LIMIT 1
2010-09-03 19:57:55 d702[d702] @ localhost [] 1 0 Query SELECT * FROM `sys_localization_languages` ORDER BY `Title` ASC
2010-09-03 19:57:55 d702[d702] @ localhost [] 1 0 Query SELECT * FROM `sys_banners` WHERE `Active` <> 0 AND `campaign_start` <= NOW() AND `campaign_end` >= NOW()  AND `Position` LIKE '%4%' ORDER BY RAND() LIMIT 1
2010-09-03 19:57:56 d702[d702] @ localhost [] 1 0 Init DB d702
2010-09-03 19:57:56 d702[d702] @ localhost [] 1 0 Query SET NAMES 'utf8'
2010-09-03 19:57:56 d702[d702] @ localhost [] 1 0 Query SET sql_mode = ''
2010-09-03 19:57:56 d702[d702] @ localhost [] 1 0 Query SELECT `ID` FROM `sys_localization_languages` WHERE `Name`='en' LIMIT 1
2010-09-03 19:57:56 d702[d702] @ localhost [] 1 0 Query SELECT 
`id` AS `id`,
`unit` AS `unit`,
`action` AS `action`,
`template` AS `template`,
`params` AS `params`
FROM `sys_sbs_types`
WHERE `unit`='system' AND `action`='begin'
LIMIT 1
2010-09-03 19:57:56 d702[d702] @ localhost [] 1 0 Query SELECT `id` AS `subscription_id`, `subscriber_id` AS `id`, `subscriber_type` AS `type` FROM `sys_sbs_entries` WHERE `subscription_id`=''
2010-09-03 19:57:56 d702[d702] @ localhost [] 1 0 Query SELECT * 
FROM `sys_admin_ban_list` 
WHERE `ProfID`='4'
2010-09-03 19:57:56 d702[d702] @ localhost [] 1 0 Query UPDATE `Profiles` SET `DateLastNav` = NOW() WHERE `ID` = '4'
2010-09-03 19:57:56 d702[d702] @ localhost [] 1 0 Query SELECT 
`ID`, `Sender`, `Type`
FROM 
`sys_messages` 
WHERE 
(
`Recipient` = 4
AND
NOT FIND_IN_SET('Recipient', `Trash`)
)
AND
`New` = '1'
ORDER BY
`Date`
2010-09-03 19:57:56 d702[d702] @ localhost [] 1 0 Query SELECT 
p.`ID`
FROM 
`Profiles` AS p
LEFT JOIN 
`sys_friend_list` AS f1 
ON 
(
f1.`ID` = p.`ID` AND f1.`Profile` =4
AND 
`f1`.`Check` = 1
)
LEFT JOIN 
`sys_friend_list` AS f2 
ON 
(
f2.`Profile` = p.`ID` 
AND 
f2.`ID` =4
AND 
`f2`.`Check` = 1
)
WHERE 1
AND 
(
f1.`ID` IS NOT NULL OR f2.`ID` IS NOT NULL
)
AND 
(
p.`DateLastNav` > SUBDATE(NOW(), INTERVAL 1 MINUTE)
)
2010-09-03 19:58:01 d702[d702] @ localhost [] 1 0 Init DB d702
2010-09-03 19:58:01 d702[d702] @ localhost [] 1 0 Query SET NAMES 'utf8'
2010-09-03 19:58:01 d702[d702] @ localhost [] 1 0 Query SET sql_mode = ''
2010-09-03 19:58:01 d702[d702] @ localhost [] 1 0 Query SELECT `ID` FROM `sys_localization_languages` WHERE `Name`='en' LIMIT 1
2010-09-03 19:58:01 d702[d702] @ localhost [] 1 0 Query SELECT 
`id` AS `id`,
`unit` AS `unit`,
`action` AS `action`,
`template` AS `template`,
`params` AS `params`
FROM `sys_sbs_types`
WHERE `unit`='system' AND `action`='begin'
LIMIT 1
2010-09-03 19:58:01 d702[d702] @ localhost [] 1 0 Query SELECT `id` AS `subscription_id`, `subscriber_id` AS `id`, `subscriber_type` AS `type` FROM `sys_sbs_entries` WHERE `subscription_id`=''
2010-09-03 19:58:01 d702[d702] @ localhost [] 1 0 Query SELECT * 
FROM `sys_admin_ban_list` 
WHERE `ProfID`='4'
2010-09-03 19:58:01 d702[d702] @ localhost [] 1 0 Query SELECT `ID` FROM `Profiles` WHERE `NickName` = 'msTester'
2010-09-03 19:58:01 d702[d702] @ localhost [] 1 0 Query SELECT    `sys_acl_levels_members`.IDLevel as ID,
`sys_acl_levels`.Name as Name,
UNIX_TIMESTAMP(`sys_acl_levels_members`.DateStarts) as DateStarts,
UNIX_TIMESTAMP(`sys_acl_levels_members`.DateExpires) as DateExpires,
`sys_acl_levels_members`.`TransactionID` AS `TransactionID`
FROM    `sys_acl_levels_members`
RIGHT JOIN Profiles
ON `sys_acl_levels_members`.IDMember = Profiles.ID
AND    (`sys_acl_levels_members`.DateStarts IS NULL
OR `sys_acl_levels_members`.DateStarts <= FROM_UNIXTIME(1283569081))
AND    (`sys_acl_levels_members`.DateExpires IS NULL
OR `sys_acl_levels_members`.DateExpires > FROM_UNIXTIME(1283569081))
LEFT JOIN `sys_acl_levels`
ON `sys_acl_levels_members`.IDLevel = `sys_acl_levels`.ID

WHERE    Profiles.ID = 4

ORDER BY `sys_acl_levels_members`.DateStarts DESC

LIMIT 0, 1
2010-09-03 19:58:01 d702[d702] @ localhost [] 1 0 Query SELECT    `sys_acl_levels_members`.IDLevel as ID,
`sys_acl_levels`.Name as Name,
UNIX_TIMESTAMP(`sys_acl_levels_members`.DateStarts) as DateStarts,
UNIX_TIMESTAMP(`sys_acl_levels_members`.DateExpires) as DateExpires,
`sys_acl_levels_members`.`TransactionID` AS `TransactionID`
FROM    `sys_acl_levels_members`
RIGHT JOIN Profiles
ON `sys_acl_levels_members`.IDMember = Profiles.ID
AND    (`sys_acl_levels_members`.DateStarts IS NULL
OR `sys_acl_levels_members`.DateStarts <= FROM_UNIXTIME(1283568481))
AND    (`sys_acl_levels_members`.DateExpires IS NULL
OR `sys_acl_levels_members`.DateExpires > FROM_UNIXTIME(1283568481))
LEFT JOIN `sys_acl_levels`
ON `sys_acl_levels_members`.IDLevel = `sys_acl_levels`.ID

WHERE    Profiles.ID = 4

ORDER BY `sys_acl_levels_members`.DateStarts DESC

LIMIT 0, 1
2010-09-03 19:58:01 d702[d702] @ localhost [] 1 0 Query SELECT    `sys_acl_levels_members`.IDLevel as ID,
`sys_acl_levels`.Name as Name,
UNIX_TIMESTAMP(`sys_acl_levels_members`.DateStarts) as DateStarts,
UNIX_TIMESTAMP(`sys_acl_levels_members`.DateExpires) as DateExpires,
`sys_acl_levels_members`.`TransactionID` AS `TransactionID`
FROM    `sys_acl_levels_members`
RIGHT JOIN Profiles
ON `sys_acl_levels_members`.IDMember = Profiles.ID
AND    (`sys_acl_levels_members`.DateStarts IS NULL
OR `sys_acl_levels_members`.DateStarts <= FROM_UNIXTIME(1284173282))
AND    (`sys_acl_levels_members`.DateExpires IS NULL
OR `sys_acl_levels_members`.DateExpires > FROM_UNIXTIME(1284173282))
LEFT JOIN `sys_acl_levels`
ON `sys_acl_levels_members`.IDLevel = `sys_acl_levels`.ID

WHERE    Profiles.ID = 4

ORDER BY `sys_acl_levels_members`.DateStarts DESC

LIMIT 0, 1
2010-09-03 19:58:01 d702[d702] @ localhost [] 1 0 Query SELECT    Name,
IDAction,
AllowedCount,
AllowedPeriodLen,
UNIX_TIMESTAMP(AllowedPeriodStart) as AllowedPeriodStart,
UNIX_TIMESTAMP(AllowedPeriodEnd) as AllowedPeriodEnd,
AdditionalParamValue
FROM    `sys_acl_actions`
LEFT JOIN `sys_acl_matrix`
ON    `sys_acl_matrix`.IDAction = `sys_acl_actions`.ID
AND `sys_acl_matrix`.IDLevel = 3
WHERE    `sys_acl_actions`.ID = 2
2010-09-03 19:58:01 d702[d702] @ localhost [] 1 0 Query SELECT `pr_rating_count` as `count`, (`pr_rating_sum` / `pr_rating_count`) AS `rate` FROM sys_profile_rating WHERE `pr_id` = '3' LIMIT 1
2010-09-03 19:58:01 d702[d702] @ localhost [] 1 0 Query SELECT COUNT(*) FROM `sys_cmts_profile` WHERE `cmt_object_id`='3' AND `cmt_parent_id`='0'
2010-09-03 19:58:01 d702[d702] @ localhost [] 1 0 Query SELECT COUNT(*)
FROM `Profiles` AS p
LEFT JOIN `sys_friend_list` AS f1 ON ( f1.`ID` = p.`ID` AND f1.`Profile` = '4' AND `f1`.`Check` =1 )
LEFT JOIN `sys_friend_list` AS f2 ON ( f2.`Profile` = p.`ID` AND f2.`ID` = '4' AND `f2`.`Check` =1 )
LEFT JOIN `sys_friend_list` AS f11 ON ( f11.`ID` = p.`ID` AND f11.`Profile` = '3' AND `f11`.`Check` =1 )
LEFT JOIN `sys_friend_list` AS f22 ON ( f22.`Profile` = p.`ID` AND f22.`ID` = '3' AND `f22`.`Check` =1 )
WHERE 1 AND (f1.`ID` IS NOT NULL OR f2.`ID` IS NOT NULL) AND (f11.`ID` IS NOT NULL OR f22.`ID` IS NOT NULL)
2010-09-03 19:58:01 d702[d702] @ localhost [] 1 0 Query SELECT `ID` AS `owner_id`, `allow_view_to` AS `group_id` FROM `Profiles` WHERE `ID`='3' LIMIT 1
2010-09-03 19:58:01 d702[d702] @ localhost [] 1 0 Query SELECT `id` FROM `sys_modules` WHERE `uri`='profile_customize' LIMIT 1
2010-09-03 19:58:01 d702[d702] @ localhost [] 1 0 Query SELECT `id` FROM `sys_page_compose_privacy` WHERE `user_id`='3' AND `block_id`='65' LIMIT 1
event_time user_host thread_id server_id command_type argument
2010-09-03 19:58:01 d702[d702] @ localhost [] 1 0 Query SELECT `id`, `user_id`, `data` FROM `sys_sessions` WHERE `id`='4DuaUVyF.5Aud7.dMLK=zziC=L8yZTed' LIMIT 1
2010-09-03 19:58:01 d702[d702] @ localhost [] 1 0 Query SELECT 
`tse`.`id` AS `id`
FROM `sys_sbs_entries` AS `tse`
LEFT JOIN `sys_sbs_types` AS `tst` ON `tse`.`subscription_id`=`tst`.`id`
WHERE
`tst`.`unit`='profile' AND 

`tse`.`subscriber_id`='4' AND 
`tse`.`subscriber_type`='1' AND `tse`.`object_id`='3'
2010-09-03 19:58:01 d702[d702] @ localhost [] 1 0 Query SELECT `id` FROM `sys_page_compose_privacy` WHERE `user_id`='3' AND `block_id`='66' LIMIT 1
2010-09-03 19:58:01 d702[d702] @ localhost [] 1 0 Query SELECT `Check` FROM `sys_friend_list` WHERE `ID`='3' AND `Profile`='4' LIMIT 1
2010-09-03 19:58:01 d702[d702] @ localhost [] 1 0 Query SELECT `id` FROM `sys_page_compose_privacy` WHERE `user_id`='3' AND `block_id`='208' LIMIT 1
2010-09-03 19:58:01 d702[d702] @ localhost [] 1 0 Query SELECT `id`, `title`, `vendor`, `version`, `update_url`, `path`, `uri`, `class_prefix`, `db_prefix`, `date` FROM `sys_modules` WHERE `uri`='videos' LIMIT 1
2010-09-03 19:58:01 d702[d702] @ localhost [] 1 0 Query SELECT * FROM `sys_modules` WHERE INSTR('BxVideosModule', `class_prefix`)=1 LIMIT 1
2010-09-03 19:58:01 d702[d702] @ localhost [] 1 0 Query SELECT COUNT(`ID`) FROM `sys_albums` WHERE `Type` = 'bx_videos' AND `Status` = 'active' AND `Owner` = '3'   AND `ObjCount` > 0
2010-09-03 19:58:01 d702[d702] @ localhost [] 1 0 Query SELECT `ID`, `Caption`, `Uri`, `Owner`, `Status`, `Date`, `ObjCount`, `AllowAlbumView`, `LastObjId` FROM `sys_albums` WHERE `Type` = 'bx_videos' AND `Status` = 'active' AND `Owner` = '3'   AND `ObjCount` > 0 ORDER BY `Date` DESC LIMIT 0, 4
2010-09-03 19:58:01 d702[d702] @ localhost [] 1 0 Query SELECT `Owner` AS `owner_id`, `AllowAlbumView` AS `group_id` FROM `sys_albums` WHERE `ID`='2' LIMIT 1
2010-09-03 19:58:01 d702[d702] @ localhost [] 1 0 Query SELECT `id_object`  FROM `sys_albums_objects` INNER JOIN `RayVideoFiles` ON `RayVideoFiles`.`ID`=`sys_albums_objects`.`id_object` WHERE `id_album`='2' AND `RayVideoFiles`.`Status`='approved' ORDER BY `obj_order`, `id_object` DESC LIMIT 4
2010-09-03 19:58:01 d702[d702] @ localhost [] 1 0 Query SELECT `id` FROM `sys_page_compose_privacy` WHERE `user_id`='3' AND `block_id`='82' LIMIT 1
2010-09-03 19:58:01 d702[d702] @ localhost [] 1 0 Query SELECT `id` FROM `sys_page_compose_privacy` WHERE `user_id`='3' AND `block_id`='80' LIMIT 1
2010-09-03 19:58:01 d702[d702] @ localhost [] 1 0 Query SELECT `id` FROM `sys_page_compose_privacy` WHERE `user_id`='3' AND `block_id`='172' LIMIT 1
2010-09-03 19:58:01 d702[d702] @ localhost [] 1 0 Query SELECT `id` FROM `sys_page_compose_privacy` WHERE `user_id`='3' AND `block_id`='67' LIMIT 1
2010-09-03 19:58:01 d702[d702] @ localhost [] 1 0 Query SELECT COUNT(*) FROM `sys_block_list` WHERE `ID` = 3 AND `Profile` = 4
2010-09-03 19:58:01 d702[d702] @ localhost [] 1 0 Query SELECT    Name,
IDAction,
AllowedCount,
AllowedPeriodLen,
UNIX_TIMESTAMP(AllowedPeriodStart) as AllowedPeriodStart,
UNIX_TIMESTAMP(AllowedPeriodEnd) as AllowedPeriodEnd,
AdditionalParamValue
FROM    `sys_acl_actions`
LEFT JOIN `sys_acl_matrix`
ON    `sys_acl_matrix`.IDAction = `sys_acl_actions`.ID
AND `sys_acl_matrix`.IDLevel = 3
WHERE    `sys_acl_actions`.ID = 3
2010-09-03 19:58:01 d702[d702] @ localhost [] 1 0 Query SELECT `id` FROM `sys_page_compose_privacy` WHERE `user_id`='3' AND `block_id`='68' LIMIT 1
2010-09-03 19:58:01 d702[d702] @ localhost [] 1 0 Query SELECT COUNT(p.`ID`)
FROM `Profiles` AS p
LEFT JOIN `sys_friend_list` AS f1 ON (f1.`ID` = p.`ID` AND f1.`Profile` ='3' AND `f1`.`Check` = 1)
LEFT JOIN `sys_friend_list` AS f2 ON (f2.`Profile` = p.`ID` AND f2.`ID` ='3' AND `f2`.`Check` = 1)
WHERE 1
AND (f1.`ID` IS NOT NULL OR f2.`ID` IS NOT NULL)
2010-09-03 19:58:01 d702[d702] @ localhost [] 1 0 Query SELECT `id` FROM `sys_page_compose_privacy` WHERE `user_id`='3' AND `block_id`='79' LIMIT 1
2010-09-03 19:58:01 d702[d702] @ localhost [] 1 0 Query SELECT `id` FROM `sys_page_compose_privacy` WHERE `user_id`='3' AND `block_id`='69' LIMIT 1
2010-09-03 19:58:01 d702[d702] @ localhost [] 1 0 Query SELECT COUNT(*) FROM `sys_block_list` WHERE `ID` = 3 AND `Profile` = 4
2010-09-03 19:58:01 d702[d702] @ localhost [] 1 0 Query SELECT 
`r`.`cmt_rate` AS `cmt_rated`,
`c`.`cmt_id`, 
`c`.`cmt_parent_id`, 
`c`.`cmt_object_id`, 
`c`.`cmt_author_id`, 
`c`.`cmt_text`, 
`c`.`cmt_mood`,
`c`.`cmt_rate`, 
`c`.`cmt_rate_count`, 
`c`.`cmt_replies`, 
(UNIX_TIMESTAMP() - UNIX_TIMESTAMP(`c`.`cmt_time`)) AS `cmt_secs_ago`,
`p`.`NickName` AS `cmt_author_name`                
FROM sys_cmts_profile AS `c`
LEFT JOIN `Profiles` AS `p` ON (`p`.`ID` = `c`.`cmt_author_id`)
LEFT JOIN sys_cmts_track AS `r` ON (`r`.`cmt_system_id` = 1 AND `r`.`cmt_id` = `c`.`cmt_id` AND `r`.`cmt_rate_author_id` = 4)
WHERE `c`.`cmt_object_id` = '3' AND `c`.`cmt_parent_id` = '0'
ORDER BY `c`.`cmt_time` DESC LIMIT 0, 5
2010-09-03 19:58:01 d702[d702] @ localhost [] 1 0 Query SELECT    Name,
IDAction,
AllowedCount,
AllowedPeriodLen,
UNIX_TIMESTAMP(AllowedPeriodStart) as AllowedPeriodStart,
UNIX_TIMESTAMP(AllowedPeriodEnd) as AllowedPeriodEnd,
AdditionalParamValue
FROM    `sys_acl_actions`
LEFT JOIN `sys_acl_matrix`
ON    `sys_acl_matrix`.IDAction = `sys_acl_actions`.ID
AND `sys_acl_matrix`.IDLevel = 3
WHERE    `sys_acl_actions`.ID = 6
2010-09-03 19:58:01 d702[d702] @ localhost [] 1 0 Query SELECT count(ID) as count_id FROM Profiles WHERE DateLastNav > SUBDATE(NOW(), INTERVAL 1 MINUTE) AND ID=4
2010-09-03 19:58:01 d702[d702] @ localhost [] 1 0 Query SELECT `UserStatus` FROM `Profiles` WHERE `ID` = 4
2010-09-03 19:58:01 d702[d702] @ localhost [] 1 0 Query SELECT count(ID) as count_id FROM Profiles WHERE DateLastNav > SUBDATE(NOW(), INTERVAL 1 MINUTE) AND ID=4
2010-09-03 19:58:01 d702[d702] @ localhost [] 1 0 Query SELECT `UserStatus` FROM `Profiles` WHERE `ID` = 4
2010-09-03 19:58:01 d702[d702] @ localhost [] 1 0 Query SELECT    Name,
IDAction,
AllowedCount,
AllowedPeriodLen,
UNIX_TIMESTAMP(AllowedPeriodStart) as AllowedPeriodStart,
UNIX_TIMESTAMP(AllowedPeriodEnd) as AllowedPeriodEnd,
AdditionalParamValue
FROM    `sys_acl_actions`
LEFT JOIN `sys_acl_matrix`
ON    `sys_acl_matrix`.IDAction = `sys_acl_actions`.ID
AND `sys_acl_matrix`.IDLevel = 3
WHERE    `sys_acl_actions`.ID = 8
2010-09-03 19:58:01 d702[d702] @ localhost [] 1 0 Query SELECT    Name,
IDAction,
AllowedCount,
AllowedPeriodLen,
UNIX_TIMESTAMP(AllowedPeriodStart) as AllowedPeriodStart,
UNIX_TIMESTAMP(AllowedPeriodEnd) as AllowedPeriodEnd,
AdditionalParamValue
FROM    `sys_acl_actions`
LEFT JOIN `sys_acl_matrix`
ON    `sys_acl_matrix`.IDAction = `sys_acl_actions`.ID
AND `sys_acl_matrix`.IDLevel = 3
WHERE    `sys_acl_actions`.ID = 9
2010-09-03 19:58:01 d702[d702] @ localhost [] 1 0 Query SELECT `id` FROM `sys_page_compose_privacy` WHERE `user_id`='3' AND `block_id`='209' LIMIT 1
2010-09-03 19:58:01 d702[d702] @ localhost [] 1 0 Query SELECT `ID`, `Name` FROM `sys_acl_actions` WHERE `Name` IN('videos add','videos view','videos delete','videos approve','videos edit')
2010-09-03 19:58:01 d702[d702] @ localhost [] 1 0 Query SELECT    Name,
IDAction,
AllowedCount,
AllowedPeriodLen,
UNIX_TIMESTAMP(AllowedPeriodStart) as AllowedPeriodStart,
UNIX_TIMESTAMP(AllowedPeriodEnd) as AllowedPeriodEnd,
AdditionalParamValue
FROM    `sys_acl_actions`
LEFT JOIN `sys_acl_matrix`
ON    `sys_acl_matrix`.IDAction = `sys_acl_actions`.ID
AND `sys_acl_matrix`.IDLevel = 3
WHERE    `sys_acl_actions`.ID = 10
2010-09-03 19:58:01 d702[d702] @ localhost [] 1 0 Query SELECT COUNT(*) FROM `RayVideoFiles`  left JOIN `Profiles` ON `Profiles`.`ID`=`RayVideoFiles`.`Owner` left JOIN `sys_albums_objects` ON `sys_albums_objects`.`id_object`=`RayVideoFiles`.`ID` left JOIN `sys_albums` ON `sys_albums`.`ID`=`sys_albums_objects`.`id_album` WHERE 1 AND `RayVideoFiles`.`Status` ='approved' AND `sys_albums`.`Status` ='active' AND `sys_albums`.`Type` ='bx_videos' AND `sys_albums`.`Uri` ='msTester-s-videos'
2010-09-03 19:58:01 d702[d702] @ localhost [] 1 0 Query SELECT `RayVideoFiles`.`ID` as `id`, `RayVideoFiles`.`Title` as `title`, `RayVideoFiles`.`Uri` as `uri`, `RayVideoFiles`.`Date` as `date`, `RayVideoFiles`.`Time` as `size`, `RayVideoFiles`.`Rate`, `RayVideoFiles`.`RateCount`, `RayVideoFiles`.`Views` as `view`, `RayVideoFiles`.`Source` as `source`, `RayVideoFiles`.`Video` as `video`, `RayVideoFiles`.`Owner` as `ownerId`, `RayVideoFiles`.`ID`, `sys_albums_objects`.`id_album`,  `Profiles`.`NickName` as `ownerName`, `sys_albums`.`AllowAlbumView`  FROM `RayVideoFiles`  left JOIN `Profiles` ON `Profiles`.`ID`=`RayVideoFiles`.`Owner` left JOIN `sys_albums_objects` ON `sys_albums_objects`.`id_object`=`RayVideoFiles`.`ID` left JOIN `sys_albums` ON `sys_albums`.`ID`=`sys_albums_objects`.`id_album` WHERE 1 AND `RayVideoFiles`.`Status` ='approved' AND `sys_albums`.`Status` ='active' AND `sys_albums`.`Type` ='bx_videos' AND `sys_albums`.`Uri` ='msTester-s-videos'   ORDER BY `obj_order` ASC LIMIT 0, 4
2010-09-03 19:58:01 d702[d702] @ localhost [] 1 0 Query SELECT `ID` FROM `sys_localization_languages` WHERE `Name`='en' LIMIT 1
2010-09-03 19:58:01 d702[d702] @ localhost [] 1 0 Query SELECT 
`id` AS `id`,
`unit` AS `unit`,
`action` AS `action`,
`template` AS `template`,
`params` AS `params`
FROM `sys_sbs_types`
WHERE `unit`='profile' AND `action`='view'
LIMIT 1
2010-09-03 19:58:01 d702[d702] @ localhost [] 1 0 Query SELECT `id` AS `subscription_id`, `subscriber_id` AS `id`, `subscriber_type` AS `type` FROM `sys_sbs_entries` WHERE `subscription_id`='' AND `object_id`='3'
2010-09-03 19:58:01 d702[d702] @ localhost [] 1 0 Query SELECT `ts` FROM `sys_profile_views_track` WHERE `id` = '3'  AND `viewer` = '4'
2010-09-03 19:58:01 d702[d702] @ localhost [] 1 0 Query INSERT IGNORE INTO `sys_profile_views_track` SET `id` = '3', `viewer` = '4', `ip` = INET_ATON('172.26.0.132'), `ts` = 1283569081
2010-09-03 19:58:01 d702[d702] @ localhost [] 1 0 Query UPDATE `Profiles` SET `Views` = `Views` + 1 WHERE `ID` = '3'
2010-09-03 19:58:01 d702[d702] @ localhost [] 1 0 Query SELECT * FROM `sys_banners` WHERE `Active` <> 0 AND `campaign_start` <= NOW() AND `campaign_end` >= NOW()  AND `Position` LIKE '%2%' ORDER BY RAND() LIMIT 1
2010-09-03 19:58:01 d702[d702] @ localhost [] 1 0 Query SELECT * FROM `sys_banners` WHERE `Active` <> 0 AND `campaign_start` <= NOW() AND `campaign_end` >= NOW()  AND `Position` LIKE '%3%' ORDER BY RAND() LIMIT 1
2010-09-03 19:58:01 d702[d702] @ localhost [] 1 0 Query SELECT count(ID) as count_id FROM Profiles WHERE DateLastNav > SUBDATE(NOW(), INTERVAL 1 MINUTE) AND ID=4
2010-09-03 19:58:01 d702[d702] @ localhost [] 1 0 Query SELECT `UserStatus` FROM `Profiles` WHERE `ID` = 4
2010-09-03 19:58:01 d702[d702] @ localhost [] 1 0 Query SELECT count(ID) as count_id FROM Profiles WHERE DateLastNav > SUBDATE(NOW(), INTERVAL 1 MINUTE) AND ID=4
2010-09-03 19:58:01 d702[d702] @ localhost [] 1 0 Query SELECT `UserStatus` FROM `Profiles` WHERE `ID` = 4
2010-09-03 19:58:01 d702[d702] @ localhost [] 1 0 Query SELECT * FROM `sys_localization_languages` ORDER BY `Title` ASC
2010-09-03 19:58:01 d702[d702] @ localhost [] 1 0 Query SELECT 
`ID`, `Sender`, `Type`
FROM 
`sys_messages` 
WHERE 
(
`Recipient` = 4
AND
NOT FIND_IN_SET('Recipient', `Trash`)
)
AND
`New` = '1'
ORDER BY
`Date`
2010-09-03 19:58:02 d702[d702] @ localhost [] 1 0 Query SELECT 
p.`ID`
FROM 
`Profiles` AS p
LEFT JOIN 
`sys_friend_list` AS f1 
ON 
(
f1.`ID` = p.`ID` AND f1.`Profile` =4
AND 
`f1`.`Check` = 1
)
LEFT JOIN 
`sys_friend_list` AS f2 
ON 
(
f2.`Profile` = p.`ID` 
AND 
f2.`ID` =4
AND 
`f2`.`Check` = 1
)
WHERE 1
AND 
(
f1.`ID` IS NOT NULL OR f2.`ID` IS NOT NULL
)
AND 
(
p.`DateLastNav` > SUBDATE(NOW(), INTERVAL 1 MINUTE)
)
2010-09-03 19:58:02 d702[d702] @ localhost [] 1 0 Query SELECT * FROM `sys_banners` WHERE `Active` <> 0 AND `campaign_start` <= NOW() AND `campaign_end` >= NOW()  AND `Position` LIKE '%1%' ORDER BY RAND() LIMIT 1
2010-09-03 19:58:02 d702[d702] @ localhost [] 1 0 Query SELECT * FROM `sys_localization_languages` ORDER BY `Title` ASC
2010-09-03 19:58:02 d702[d702] @ localhost [] 1 0 Query SELECT count(ID) as count_id FROM Profiles WHERE DateLastNav > SUBDATE(NOW(), INTERVAL 1 MINUTE) AND ID=3
2010-09-03 19:58:02 d702[d702] @ localhost [] 1 0 Query SELECT count(ID) as count_id FROM Profiles WHERE DateLastNav > SUBDATE(NOW(), INTERVAL 1 MINUTE) AND ID=3
2010-09-03 19:58:02 d702[d702] @ localhost [] 1 0 Query SELECT * FROM `sys_banners` WHERE `Active` <> 0 AND `campaign_start` <= NOW() AND `campaign_end` >= NOW()  AND `Position` LIKE '%4%' ORDER BY RAND() LIMIT 1
2010-09-03 19:58:02 d702[d702] @ localhost [] 1 0 Init DB d702
2010-09-03 19:58:02 d702[d702] @ localhost [] 1 0 Query SET NAMES 'utf8'
2010-09-03 19:58:02 d702[d702] @ localhost [] 1 0 Query SET sql_mode = ''
2010-09-03 19:58:02 d702[d702] @ localhost [] 1 0 Query SELECT `ID` FROM `sys_localization_languages` WHERE `Name`='en' LIMIT 1
2010-09-03 19:58:02 d702[d702] @ localhost [] 1 0 Query SELECT 
`id` AS `id`,
`unit` AS `unit`,
`action` AS `action`,
`template` AS `template`,
`params` AS `params`
FROM `sys_sbs_types`
WHERE `unit`='system' AND `action`='begin'
LIMIT 1
2010-09-03 19:58:02 d702[d702] @ localhost [] 1 0 Query SELECT `id` AS `subscription_id`, `subscriber_id` AS `id`, `subscriber_type` AS `type` FROM `sys_sbs_entries` WHERE `subscription_id`=''
2010-09-03 19:58:02 d702[d702] @ localhost [] 1 0 Query SELECT * 
FROM `sys_admin_ban_list` 
WHERE `ProfID`='4'
2010-09-03 19:58:02 d702[d702] @ localhost [] 1 0 Query UPDATE `Profiles` SET `DateLastNav` = NOW() WHERE `ID` = '4'
2010-09-03 19:58:02 d702[d702] @ localhost [] 1 0 Query SELECT 
`ID`, `Sender`, `Type`
FROM 
`sys_messages` 
WHERE 
(
`Recipient` = 4
AND
NOT FIND_IN_SET('Recipient', `Trash`)
)
AND
`New` = '1'
ORDER BY
`Date`
2010-09-03 19:58:02 d702[d702] @ localhost [] 1 0 Query SELECT 
p.`ID`
FROM 
`Profiles` AS p
LEFT JOIN 
`sys_friend_list` AS f1 
ON 
(
f1.`ID` = p.`ID` AND f1.`Profile` =4
AND 
`f1`.`Check` = 1
)
LEFT JOIN 
`sys_friend_list` AS f2 
ON 
(
f2.`Profile` = p.`ID` 
AND 
f2.`ID` =4
AND 
`f2`.`Check` = 1
)
WHERE 1
AND 
(
f1.`ID` IS NOT NULL OR f2.`ID` IS NOT NULL
)
AND 
(
p.`DateLastNav` > SUBDATE(NOW(), INTERVAL 1 MINUTE)
)
2010-09-03 19:58:02 d702[d702] @ localhost [] 1 0 Init DB d702
2010-09-03 19:58:02 d702[d702] @ localhost [] 1 0 Query SET NAMES 'utf8'
2010-09-03 19:58:02 d702[d702] @ localhost [] 1 0 Query SET sql_mode = ''
2010-09-03 19:58:02 d702[d702] @ localhost [] 1 0 Query SELECT `ID` FROM `sys_localization_languages` WHERE `Name`='en' LIMIT 1
2010-09-03 19:58:02 d702[d702] @ localhost [] 1 0 Query SELECT 
`id` AS `id`,
`unit` AS `unit`,
`action` AS `action`,
`template` AS `template`,
`params` AS `params`
FROM `sys_sbs_types`
WHERE `unit`='system' AND `action`='begin'
LIMIT 1
2010-09-03 19:58:02 d702[d702] @ localhost [] 1 0 Query SELECT `id` AS `subscription_id`, `subscriber_id` AS `id`, `subscriber_type` AS `type` FROM `sys_sbs_entries` WHERE `subscription_id`=''
2010-09-03 19:58:02 d702[d702] @ localhost [] 1 0 Query SELECT * 
FROM `sys_admin_ban_list` 
WHERE `ProfID`='4'
2010-09-03 19:58:02 d702[d702] @ localhost [] 1 0 Init DB d702
2010-09-03 19:58:02 d702[d702] @ localhost [] 1 0 Query SET NAMES 'utf8'
2010-09-03 19:58:02 d702[d702] @ localhost [] 1 0 Query SET sql_mode = ''
2010-09-03 19:58:02 d702[d702] @ localhost [] 1 0 Query SELECT `ID` FROM `sys_localization_languages` WHERE `Name`='en' LIMIT 1
2010-09-03 19:58:02 d702[d702] @ localhost [] 1 0 Query SELECT 
`id` AS `id`,
`unit` AS `unit`,
`action` AS `action`,
`template` AS `template`,
`params` AS `params`
FROM `sys_sbs_types`
WHERE `unit`='system' AND `action`='begin'
LIMIT 1
2010-09-03 19:58:02 d702[d702] @ localhost [] 1 0 Query SELECT `id` AS `subscription_id`, `subscriber_id` AS `id`, `subscriber_type` AS `type` FROM `sys_sbs_entries` WHERE `subscription_id`=''
2010-09-03 19:58:02 d702[d702] @ localhost [] 1 0 Init DB d702
2010-09-03 19:58:02 d702[d702] @ localhost [] 1 0 Query SET NAMES 'utf8'
2010-09-03 19:58:02 d702[d702] @ localhost [] 1 0 Query SET sql_mode = ''
2010-09-03 19:58:02 d702[d702] @ localhost [] 1 0 Query SELECT `ID` FROM `sys_localization_languages` WHERE `Name`='en' LIMIT 1
2010-09-03 19:58:02 d702[d702] @ localhost [] 1 0 Query SELECT 
`id` AS `id`,
`unit` AS `unit`,
`action` AS `action`,
`template` AS `template`,
`params` AS `params`
FROM `sys_sbs_types`
WHERE `unit`='system' AND `action`='begin'
LIMIT 1
2010-09-03 19:58:02 d702[d702] @ localhost [] 1 0 Query SELECT `id` AS `subscription_id`, `subscriber_id` AS `id`, `subscriber_type` AS `type` FROM `sys_sbs_entries` WHERE `subscription_id`=''
2010-09-03 19:58:02 d702[d702] @ localhost [] 1 0 Query SELECT * 
FROM `sys_admin_ban_list` 
WHERE `ProfID`='4'
2010-09-03 19:58:03 d702[d702] @ localhost [] 1 0 Init DB d702
2010-09-03 19:58:03 d702[d702] @ localhost [] 1 0 Query SET NAMES 'utf8'
2010-09-03 19:58:03 d702[d702] @ localhost [] 1 0 Query SET sql_mode = ''
2010-09-03 19:58:03 d702[d702] @ localhost [] 1 0 Query SELECT `ID` FROM `sys_localization_languages` WHERE `Name`='en' LIMIT 1
2010-09-03 19:58:03 d702[d702] @ localhost [] 1 0 Query SELECT 
`id` AS `id`,
`unit` AS `unit`,
`action` AS `action`,
`template` AS `template`,
`params` AS `params`
FROM `sys_sbs_types`
WHERE `unit`='system' AND `action`='begin'
LIMIT 1
2010-09-03 19:58:03 d702[d702] @ localhost [] 1 0 Query SELECT `id` AS `subscription_id`, `subscriber_id` AS `id`, `subscriber_type` AS `type` FROM `sys_sbs_entries` WHERE `subscription_id`=''
2010-09-03 19:58:03 d702[d702] @ localhost [] 1 0 Query SELECT * 
FROM `sys_admin_ban_list` 
WHERE `ProfID`='4'
2010-09-03 19:58:03 d702[d702] @ localhost [] 1 0 Query SELECT * FROM `sys_modules` WHERE INSTR('BxVideosModule', `class_prefix`)=1 LIMIT 1
2010-09-03 19:58:03 d702[d702] @ localhost [] 1 0 Query SELECT COUNT(*) FROM `RayVideoFiles`  left JOIN `Profiles` ON `Profiles`.`ID`=`RayVideoFiles`.`Owner` left JOIN `sys_albums_objects` ON `sys_albums_objects`.`id_object`=`RayVideoFiles`.`ID` left JOIN `sys_albums` ON `sys_albums`.`ID`=`sys_albums_objects`.`id_album` WHERE 1 AND `RayVideoFiles`.`Status` ='approved' AND `RayVideoFiles`.`ID` <>'2' AND `sys_albums`.`Status` ='active' AND `sys_albums`.`Type` ='bx_videos'
2010-09-03 19:58:03 d702[d702] @ localhost [] 1 0 Init DB d702
2010-09-03 19:58:03 d702[d702] @ localhost [] 1 0 Query SET NAMES 'utf8'
2010-09-03 19:58:03 d702[d702] @ localhost [] 1 0 Query SET sql_mode = ''
2010-09-03 19:58:03 d702[d702] @ localhost [] 1 0 Query SELECT `ID` FROM `sys_localization_languages` WHERE `Name`='en' LIMIT 1
2010-09-03 19:58:03 d702[d702] @ localhost [] 1 0 Query SELECT 
`id` AS `id`,
`unit` AS `unit`,
`action` AS `action`,
`template` AS `template`,
`params` AS `params`
FROM `sys_sbs_types`
WHERE `unit`='system' AND `action`='begin'
LIMIT 1
2010-09-03 19:58:03 d702[d702] @ localhost [] 1 0 Query SELECT `id` AS `subscription_id`, `subscriber_id` AS `id`, `subscriber_type` AS `type` FROM `sys_sbs_entries` WHERE `subscription_id`=''
event_time user_host thread_id server_id command_type argument
2010-09-03 19:58:03 d702[d702] @ localhost [] 1 0 Query SELECT *
FROM `sys_admin_ban_list`
WHERE `ProfID`='4'
2010-09-03 19:58:03 d702[d702] @ localhost [] 1 0 Query SELECT *
FROM `sys_admin_ban_list`
WHERE `ProfID`='4'
2010-09-03 19:58:03 d702[d702] @ localhost [] 1 0 Query SELECT COUNT(*) FROM `sys_block_list` WHERE `ID` = 3 AND `Profile` = 4
2010-09-03 19:58:03 d702[d702] @ localhost [] 1 0 Query SELECT * FROM `sys_friend_list` WHERE (`ID`='4' AND `Profile`='3') OR (`ID`='3' AND `Profile` = '4')
2010-09-03 19:58:03 d702[d702] @ localhost [] 1 0 Query INSERT INTO `sys_friend_list` SET `ID` = '4', `Profile` = '3', `Check` = '0'
2010-09-03 19:58:03 d702[d702] @ localhost [] 1 0 Query SELECT `ID` FROM `sys_localization_languages` WHERE `Name`='en' LIMIT 1
2010-09-03 19:58:03 d702[d702] @ localhost [] 1 0 Query SELECT
`id` AS `id`,
`unit` AS `unit`,
`action` AS `action`,
`template` AS `template`,
`params` AS `params`
FROM `sys_sbs_types`
WHERE `unit`='friend' AND `action`='request'
LIMIT 1
2010-09-03 19:58:03 d702[d702] @ localhost [] 1 0 Query SELECT `id` AS `subscription_id`, `subscriber_id` AS `id`, `subscriber_type` AS `type` FROM `sys_sbs_entries` WHERE `subscription_id`='' AND `object_id`='3'
2010-09-03 19:58:03 d702[d702] @ localhost [] 1 0 Query SELECT `id`, `title`, `vendor`, `version`, `update_url`, `path`, `uri`, `class_prefix`, `db_prefix`, `date` FROM `sys_modules` WHERE `uri`='videos' LIMIT 1
2010-09-03 19:58:03 d702[d702] @ localhost [] 1 0 Query SELECT `ID` FROM `RayVideoFiles` WHERE `Owner`='3'
2010-09-03 19:58:03 d702[d702] @ localhost [] 1 0 Query SELECT `RayVideoFiles`.`ID` as `medID`, `RayVideoFiles`.`Owner` as `medProfId`, `RayVideoFiles`.`Video` as `medExt`, `RayVideoFiles`.`Date` as `medDate`, `RayVideoFiles`.`Status` as `Approved`
FROM `RayVideoFiles`


WHERE `RayVideoFiles`.`ID`='2'  LIMIT 1
2010-09-03 19:58:03 d702[d702] @ localhost [] 1 0 Query SELECT `ID`, `Name` FROM `sys_acl_actions` WHERE `Name` IN('videos add','videos view','videos delete','videos approve','videos edit')
2010-09-03 19:58:03 d702[d702] @ localhost [] 1 0 Query SELECT    `sys_acl_levels_members`.IDLevel as ID,
`sys_acl_levels`.Name as Name,
UNIX_TIMESTAMP(`sys_acl_levels_members`.DateStarts) as DateStarts,
UNIX_TIMESTAMP(`sys_acl_levels_members`.DateExpires) as DateExpires,
`sys_acl_levels_members`.`TransactionID` AS `TransactionID`
FROM    `sys_acl_levels_members`
RIGHT JOIN Profiles
ON `sys_acl_levels_members`.IDMember = Profiles.ID
AND    (`sys_acl_levels_members`.DateStarts IS NULL
OR `sys_acl_levels_members`.DateStarts <= FROM_UNIXTIME(1283569083))
AND    (`sys_acl_levels_members`.DateExpires IS NULL
OR `sys_acl_levels_members`.DateExpires > FROM_UNIXTIME(1283569083))
LEFT JOIN `sys_acl_levels`
ON `sys_acl_levels_members`.IDLevel = `sys_acl_levels`.ID

WHERE    Profiles.ID = 4

ORDER BY `sys_acl_levels_members`.DateStarts DESC

LIMIT 0, 1
2010-09-03 19:58:03 d702[d702] @ localhost [] 1 0 Query SELECT    `sys_acl_levels_members`.IDLevel as ID,
`sys_acl_levels`.Name as Name,
UNIX_TIMESTAMP(`sys_acl_levels_members`.DateStarts) as DateStarts,
UNIX_TIMESTAMP(`sys_acl_levels_members`.DateExpires) as DateExpires,
`sys_acl_levels_members`.`TransactionID` AS `TransactionID`
FROM    `sys_acl_levels_members`
RIGHT JOIN Profiles
ON `sys_acl_levels_members`.IDMember = Profiles.ID
AND    (`sys_acl_levels_members`.DateStarts IS NULL
OR `sys_acl_levels_members`.DateStarts <= FROM_UNIXTIME(1283568481))
AND    (`sys_acl_levels_members`.DateExpires IS NULL
OR `sys_acl_levels_members`.DateExpires > FROM_UNIXTIME(1283568481))
LEFT JOIN `sys_acl_levels`
ON `sys_acl_levels_members`.IDLevel = `sys_acl_levels`.ID

WHERE    Profiles.ID = 4

ORDER BY `sys_acl_levels_members`.DateStarts DESC

LIMIT 0, 1
2010-09-03 19:58:03 d702[d702] @ localhost [] 1 0 Query SELECT    `sys_acl_levels_members`.IDLevel as ID,
`sys_acl_levels`.Name as Name,
UNIX_TIMESTAMP(`sys_acl_levels_members`.DateStarts) as DateStarts,
UNIX_TIMESTAMP(`sys_acl_levels_members`.DateExpires) as DateExpires,
`sys_acl_levels_members`.`TransactionID` AS `TransactionID`
FROM    `sys_acl_levels_members`
RIGHT JOIN Profiles
ON `sys_acl_levels_members`.IDMember = Profiles.ID
AND    (`sys_acl_levels_members`.DateStarts IS NULL
OR `sys_acl_levels_members`.DateStarts <= FROM_UNIXTIME(1284173282))
AND    (`sys_acl_levels_members`.DateExpires IS NULL
OR `sys_acl_levels_members`.DateExpires > FROM_UNIXTIME(1284173282))
LEFT JOIN `sys_acl_levels`
ON `sys_acl_levels_members`.IDLevel = `sys_acl_levels`.ID

WHERE    Profiles.ID = 4

ORDER BY `sys_acl_levels_members`.DateStarts DESC

LIMIT 0, 1
2010-09-03 19:58:03 d702[d702] @ localhost [] 1 0 Query SELECT    Name,
IDAction,
AllowedCount,
AllowedPeriodLen,
UNIX_TIMESTAMP(AllowedPeriodStart) as AllowedPeriodStart,
UNIX_TIMESTAMP(AllowedPeriodEnd) as AllowedPeriodEnd,
AdditionalParamValue
FROM    `sys_acl_actions`
LEFT JOIN `sys_acl_matrix`
ON    `sys_acl_matrix`.IDAction = `sys_acl_actions`.ID
AND `sys_acl_matrix`.IDLevel = 3
WHERE    `sys_acl_actions`.ID = 12
2010-09-03 19:58:03 d702[d702] @ localhost [] 1 0 Query SELECT `ID`, `Caption`, `Uri`, `Owner`, `Status`, `Date`, `ObjCount`, `AllowAlbumView`, `LastObjId` FROM `sys_albums` WHERE `Type` = 'bx_videos' AND `Owner` = '3'   ORDER BY `Date` DESC
2010-09-03 19:58:03 d702[d702] @ localhost [] 1 0 Query SELECT `id_object` FROM `sys_albums_objects`  WHERE `id_album`='2'
2010-09-03 19:58:03 d702[d702] @ localhost [] 1 0 Query SELECT `LastObjId` FROM `sys_albums` WHERE `ID`='2' AND `Type`='bx_videos'
2010-09-03 19:58:03 d702[d702] @ localhost [] 1 0 Query DELETE `sys_albums_objects`
FROM `sys_albums_objects`, `sys_albums`
WHERE `sys_albums_objects`.`id_album`=`sys_albums`.`ID`
AND `sys_albums`.`Type` = 'bx_videos' AND `sys_albums_objects`.`id_object` IN ('2')
2010-09-03 19:58:03 d702[d702] @ localhost [] 1 0 Query SELECT MAX(`id_object`) FROM `sys_albums_objects` WHERE `id_album` = '2'
2010-09-03 19:58:03 d702[d702] @ localhost [] 1 0 Query UPDATE `sys_albums` SET `LastObjId`='0' WHERE `ID`='2'
2010-09-03 19:58:03 d702[d702] @ localhost [] 1 0 Query UPDATE `sys_albums` SET `ObjCount`=`ObjCount` - 1 WHERE `ID`='2'
2010-09-03 19:58:03 d702[d702] @ localhost [] 1 0 Query DELETE FROM `sys_albums` WHERE `ID`='2'
2010-09-03 19:58:03 d702[d702] @ localhost [] 1 0 Query SELECT `ID` FROM `sys_localization_languages` WHERE `Name`='en' LIMIT 1
2010-09-03 19:58:03 d702[d702] @ localhost [] 1 0 Query SELECT `Subject`, `Body` FROM `sys_email_templates` WHERE `Name`='t_FriendRequest' AND (`LangID` = '1' OR `LangID` = '0') ORDER BY `LangID` DESC LIMIT 1
2010-09-03 19:58:03 d702[d702] @ localhost [] 1 0 Query SELECT `ID` FROM `sys_localization_languages` WHERE `Name`='en' LIMIT 1
2010-09-03 19:58:03 d702[d702] @ localhost [] 1 0 Query SELECT `ID` FROM `sys_localization_languages` WHERE `Name`='en' LIMIT 1
2010-09-03 19:58:03 d702[d702] @ localhost [] 1 0 Query SELECT 
`id` AS `id`,
`unit` AS `unit`,
`action` AS `action`,
`template` AS `template`,
`params` AS `params`
FROM `sys_sbs_types`
WHERE `unit`='profile' AND `action`='send_mail'
LIMIT 1
2010-09-03 19:58:03 d702[d702] @ localhost [] 1 0 Query SELECT `id` AS `subscription_id`, `subscriber_id` AS `id`, `subscriber_type` AS `type` FROM `sys_sbs_entries` WHERE `subscription_id`=''
2010-09-03 19:58:08 d702[d702] @ localhost [] 1 0 Init DB d702
2010-09-03 19:58:08 d702[d702] @ localhost [] 1 0 Query SET NAMES 'utf8'
2010-09-03 19:58:08 d702[d702] @ localhost [] 1 0 Query SET sql_mode = ''
2010-09-03 19:58:08 d702[d702] @ localhost [] 1 0 Query SELECT `ID` FROM `sys_localization_languages` WHERE `Name`='en' LIMIT 1
2010-09-03 19:58:08 d702[d702] @ localhost [] 1 0 Query SELECT 
`id` AS `id`,
`unit` AS `unit`,
`action` AS `action`,
`template` AS `template`,
`params` AS `params`
FROM `sys_sbs_types`
WHERE `unit`='system' AND `action`='begin'
LIMIT 1
2010-09-03 19:58:08 d702[d702] @ localhost [] 1 0 Query SELECT `id` AS `subscription_id`, `subscriber_id` AS `id`, `subscriber_type` AS `type` FROM `sys_sbs_entries` WHERE `subscription_id`=''
2010-09-03 19:58:08 d702[d702] @ localhost [] 1 0 Query SELECT * 
FROM `sys_admin_ban_list` 
WHERE `ProfID`='4'
2010-09-03 19:58:08 d702[d702] @ localhost [] 1 0 Query UPDATE `Profiles` SET `DateLastNav` = NOW() WHERE `ID` = '4'
2010-09-03 19:58:08 d702[d702] @ localhost [] 1 0 Query SELECT 
`ID`, `Sender`, `Type`
FROM 
`sys_messages` 
WHERE 
(
`Recipient` = 4
AND
NOT FIND_IN_SET('Recipient', `Trash`)
)
AND
`New` = '1'
ORDER BY
`Date`
2010-09-03 19:58:08 d702[d702] @ localhost [] 1 0 Query SELECT 
p.`ID`
FROM 
`Profiles` AS p
LEFT JOIN 
`sys_friend_list` AS f1 
ON 
(
f1.`ID` = p.`ID` AND f1.`Profile` =4
AND 
`f1`.`Check` = 1
)
LEFT JOIN 
`sys_friend_list` AS f2 
ON 
(
f2.`Profile` = p.`ID` 
AND 
f2.`ID` =4
AND 
`f2`.`Check` = 1
)
WHERE 1
AND 
(
f1.`ID` IS NOT NULL OR f2.`ID` IS NOT NULL
)
AND 
(
p.`DateLastNav` > SUBDATE(NOW(), INTERVAL 1 MINUTE)
)
2010-09-03 19:59:13 d702[d702] @ localhost [] 1 0 Quit
Light man a fire keep him warm for a night, light him ON fire & he will be warm the rest of his life
Quote · 4 Sep 2010

I am willing to pay someone to track down this bug and fix it.

http://www.boonex.com/unity/jobs/entry/Fix_friend_request_bug

Light man a fire keep him warm for a night, light him ON fire & he will be warm the rest of his life
Quote · 6 Sep 2010

does this happen on uploaded video or  embedded as well

Quote · 6 Sep 2010

My tests use an uploaded video.

The video is not actually deleted, it is still in the database.

It is the album and related objects that is deleted.

 

I have done more testing. 7.0.1 seems to me missing this bug (although there are others, like the video working but showing as failed).

I just got done with my first round of tests with 7.0.3 (svn build 14357) and so far I have not triggered the bug.

So this may be isolated to 7.0.2.

Light man a fire keep him warm for a night, light him ON fire & he will be warm the rest of his life
Quote · 6 Sep 2010

Execute this query in phpMyAdmin and post result here.

SELECT * FROM `sys_alerts` WHERE `unit` = 'friend';


There is a known avatar bug related to friend requests, i would like to see if you have any other unneeded friend alerts.

https://www.deanbassett.com
Quote · 6 Sep 2010

7.02 (upgrade) here  with one uploaded video  and few are embedded still couldn't reproduce the error

*EDIT*
SELECT * FROM `sys_alerts` WHERE `unit` = 'friend'; i never run this query

instead this is what i used



/modules/boonex/avatar/classes BxAvaModule.php
line ~406~ find

function serviceDeleteProfileAvatars ($iProfileId) {
if (!(int)$iProfileId)
return false;
$aDataEntries = $this->_oDb->getAvatarsByAuthor ((int)$iProfileId);
foreach ($aDataEntries as $iEntryId) {
if ($this->_oDb->deleteAvatarByIdAndOwner($iEntryId, (int)$iProfileId, $this->isAdmin())) {
@unlink (BX_AVA_DIR_USER_AVATARS . $iEntryId . BX_AVA_EXT);
@unlink (BX_AVA_DIR_USER_AVATARS . $iEntryId . 'i' . BX_AVA_EXT);

$this->onEventDeleted ($iEntryId);
}
}
return true;
}

change to

function serviceDeleteProfileAvatars ($iProfileId) {
if (!(int)$iProfileId)
return false;
$aDataEntries = $this->_oDb->getAvatarsByAuthor ((int)$iProfileId);
foreach ($aDataEntries as $iEntryId) {
if ($this->_oDb->deleteAvatarByIdAndOwner($iEntryId, (int)$iProfileId, $this->isAdmin()))
$this->onEventDeleted ($iEntryId);
}
return true;
}

Quote · 6 Sep 2010

SQL result

Host: localhost
Database: dolphin7
Generation Time: Sep 06, 2010 at 03:10 PM
Generated by: phpMyAdmin 3.2.2.1deb1 / MySQL 5.1.37-1ubuntu5.4-log
SQL query: SELECT * FROM `sys_alerts` WHERE `unit` = 'friend' LIMIT 0, 30 ;
Rows: 1

id unit action handler_id
114 friend request 5
Light man a fire keep him warm for a night, light him ON fire & he will be warm the rest of his life
Quote · 6 Sep 2010

Run these queries.

DELETE FROM `sys_alerts` WHERE `unit` = 'block' AND `action` = 'add' AND `handler_id` = 5;

DELETE FROM `sys_alerts` WHERE `unit` = 'friend' AND `action` = 'request' AND `handler_id` = 5;

This is the avatar bug fix which you did not seem to apply. http://www.boonex.com/trac/dolphin/ticket/2072

These queries will remove that entry that was found with the handler_id of 5 which is a temp fix for the bug. I have a feeling the 2 of them are related to each other. Fix this one and see if the video album problem goes away.

https://www.deanbassett.com
Quote · 6 Sep 2010

DELETE FROM `sys_alerts` WHERE `unit` = 'block' AND `action` = 'add' AND `handler_id` =5;# 1 row(s) affected.
DELETE FROM `sys_alerts` WHERE `unit` = 'friend' AND `action` = 'request' AND `handler_id` =5;# 1 row(s) affected.

 

Album still gets deleted after friend request. :(

 


Light man a fire keep him warm for a night, light him ON fire & he will be warm the rest of his life
Quote · 7 Sep 2010
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.