Skip to content

Instantly share code, notes, and snippets.

@EGreg

EGreg/interests.log

Created April 6, 2015 10:49
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save EGreg/871defa6396546826c0e to your computer and use it in GitHub Desktop.
Save EGreg/871defa6396546826c0e to your computer and use it in GitHub Desktop.
Download ZIP
Adding and removing interests
Raw
interests.log
-----
[2015-04-03 11:16:10] (gmba.local) Groups: DELETE slots: (publisherId,streamName) from url: http://gmba.local/Groups/action.php/Streams/interest?Q.ajax=json&Q.slotNames=publisherId%2CstreamName&Q.method=DELETE&Q.nonce=d454a3454f9a29f2cf2c18d376183325
[2015-04-03 11:16:10] (gmba.local) Groups:
SELECT *
FROM Groups.users_user
WHERE `id` = 'ohrxqrzb'
LIMIT 1
[2015-04-03 11:16:10] (gmba.local) Groups:
SELECT *
FROM Groups.streams_stream
WHERE `publisherId` = 'Groups' AND name IN ('Streams/interest/adventure_asia')
LIMIT 1
[2015-04-03 11:16:10] (gmba.local) Groups:
SELECT *
FROM Groups.streams_access
WHERE `publisherId` = 'Groups' AND streamName IN ('Streams/interest/adventure_asia','Streams/interest/') AND ofUserId IN ('','ohrxqrzb')
[2015-04-03 11:16:10] (gmba.local) Groups:
SELECT *
FROM Groups.streams_stream
WHERE `publisherId` = 'ohrxqrzb' AND name IN ('Streams/user/interests')
LIMIT 1
[2015-04-03 11:16:10] (gmba.local) Groups:
SELECT *
FROM Groups.streams_participant
WHERE `publisherId` = 'Groups' AND `streamName` = 'Streams/interest/adventure_asia' AND `userId` = 'ohrxqrzb'
LIMIT 1
[2015-04-03 11:16:10] (gmba.local) Groups:
SELECT *
FROM Groups.streams_related_to
WHERE `toPublisherId` = 'ohrxqrzb' AND `toStreamName` = 'Streams/user/interests' AND `type` = 'Streams/interest' AND `fromPublisherId` = 'Groups' AND `fromStreamName` = 'Streams/interest/adventure_asia'
LIMIT 1
[2015-04-03 11:16:10] (gmba.local) Groups:
SELECT *
FROM Groups.streams_related_from
WHERE `fromPublisherId` = 'Groups' AND `fromStreamName` = 'Streams/interest/adventure_asia' AND `type` = 'Streams/interest' AND `toPublisherId` = 'ohrxqrzb' AND `toStreamName` = 'Streams/user/interests'
LIMIT 1
[2015-04-03 11:16:10] (gmba.local) Groups:
SELECT *
FROM Groups.streams_stream
WHERE `publisherId` = 'ohrxqrzb' AND name IN ('Places/user/location')
LIMIT 1
[2015-04-03 11:16:21] (gmba.local) Groups:
SELECT *
FROM Groups.streams_stream
WHERE `publisherId` = 'Groups' AND name IN ('Places/interest/stwuzw/100/adventure_asia','Places/interest/sv9kuy/100/adventure_asia','Places/interest/stzm5m/100/adventure_asia','Places/interest/svbt4v/100/adventure_asia')
[2015-04-03 11:16:22] (gmba.local) Groups:
SELECT *
FROM Groups.streams_participant
WHERE `publisherId` = 'Groups' AND streamName IN ('Places/nearby/stwuzw/100','Places/nearby/sv9kuy/100','Places/nearby/stzm5m/100','Places/nearby/svbt4v/100') AND `userId` = 'ohrxqrzb'
(gmba.local) Groups: PHP Error(8):
Undefined index: publisherId
in /projects/qbix/Q/platform/plugins/Places/handlers/Places/after/Streams_interest_delete.php (11)
$ => <Array>(2)
(
['params'] => <Array>(0)
(
)
['location']<Object>[Streams_Stream]
(
publisherId = <String(8)> ohrxqrzb
name = <String(20)> Places/user/location
insertedTime = <String(19)> 2015-03-31 13:18:31
updatedTime = <String(19)> 2015-04-03 03:12:21
type = <String(15)> Places/location
title = <String(13)> User location
icon = <String(7)> default
content = <String(0)>
attributes = <String(147)> {"accuracy":"60","latitude":"32.0034057","longitude":"34.770357499999996","miles":"100","timezone":"-3","zipcode":"","placeName":null,"state":null}
readLevel = <String(2)> 40
writeLevel = <String(2)> 10
adminLevel = <String(2)> 20
inheritAccess = NULL
messageCount = <String(1)> 7
participantCount = <String(1)> 0
closedTime = NULL
)
)
(gmba.local) Groups: PHP Error(8):
Undefined index: title
in /projects/qbix/Q/platform/plugins/Places/handlers/Places/after/Streams_interest_delete.php (14)
$ => <Array>(2)
(
['params'] => <Array>(0)
(
)
['location']<Object>[Streams_Stream]
(
publisherId = <String(8)> ohrxqrzb
name = <String(20)> Places/user/location
insertedTime = <String(19)> 2015-03-31 13:18:31
updatedTime = <String(19)> 2015-04-03 03:12:21
type = <String(15)> Places/location
title = <String(13)> User location
icon = <String(7)> default
content = <String(0)>
attributes = <String(147)> {"accuracy":"60","latitude":"32.0034057","longitude":"34.770357499999996","miles":"100","timezone":"-3","zipcode":"","placeName":null,"state":null}
readLevel = <String(2)> 40
writeLevel = <String(2)> 10
adminLevel = <String(2)> 20
inheritAccess = NULL
messageCount = <String(1)> 7
participantCount = <String(1)> 0
closedTime = NULL
)
)
[2015-04-03 11:16:42] (gmba.local) Groups:
SELECT *
FROM Groups.streams_stream
WHERE `publisherId` = 'Groups' AND name IN ('Places/interest/stwuzw/100/','Places/interest/sv9kuy/100/','Places/interest/stzm5m/100/','Places/interest/svbt4v/100/')
[2015-04-03 11:16:42] (gmba.local) Groups:
SELECT *
FROM Groups.streams_participant
WHERE `publisherId` = 'Groups' AND streamName IN ('Places/nearby/stwuzw/100','Places/nearby/sv9kuy/100','Places/nearby/stzm5m/100','Places/nearby/svbt4v/100') AND `userId` = 'ohrxqrzb'
[2015-04-03 11:16:42] (gmba.local) Groups: ~32646ms+6648kb. Served response for Streams/interest (publisherId,streamName)
[2015-04-03 11:16:42] (gmba.local) Groups:
UPDATE Groups.users_session
SET `content` = '{\"Q\":{\"nonce\":\"d454a3454f9a29f2cf2c18d376183325\"},\"Users\":{\"loggedInUser\":{\"id\":\"ohrxqrzb\"},\"hinted\":{\"0\":\"Groups/location\",\"1\":\"Groups/newGroup\",\"2\":\"Groups/picture\",\"3\":\"Groups/interests\",\"4\":\"Groups/closeColumn\",\"5\":\"Groups/invite\",\"6\":\"Groups/group/going\",\"7\":\"Groups/chat/open\",\"8\":\"Groups/chat/close\",\"9\":\"Groups/group/close\"}}}',
`php` = 'Q|a:1:{s:5:\"nonce\";s:32:\"d454a3454f9a29f2cf2c18d376183325\";}Users|a:2:{s:12:\"loggedInUser\";a:1:{s:2:\"id\";s:8:\"ohrxqrzb\";}s:6:\"hinted\";a:10:{i:0;s:15:\"Groups/location\";i:1;s:15:\"Groups/newGroup\";i:2;s:14:\"Groups/picture\";i:3;s:16:\"Groups/interests\";i:4;s:18:\"Groups/closeColumn\";i:5;s:13:\"Groups/invite\";i:6;s:18:\"Groups/group/going\";i:7;s:16:\"Groups/chat/open\";i:8;s:17:\"Groups/chat/close\";i:9;s:18:\"Groups/group/close\";}}',
`deviceId` = '',
`timeout` = '0',
`duration` = '86400',
`updatedTime` = CURRENT_TIMESTAMP
WH
[2015-04-03 11:16:45] (gmba.local) Groups:
-----
[2015-04-03 11:16:45] (gmba.local) Groups: POST slots: (publisherId,streamName) from url: http://gmba.local/Groups/action.php/Streams/interest?Q.ajax=json&Q.slotNames=publisherId%2CstreamName&Q.method=POST&Q.nonce=d454a3454f9a29f2cf2c18d376183325
[2015-04-03 11:16:45] (gmba.local) Groups:
SELECT *
FROM Groups.users_user
WHERE `id` = 'ohrxqrzb'
LIMIT 1
[2015-04-03 11:16:45] (gmba.local) Groups:
SELECT *
FROM Groups.streams_stream
WHERE `publisherId` = 'Groups' AND name IN ('Streams/interest/adventure_asia')
LIMIT 1
[2015-04-03 11:16:45] (gmba.local) Groups:
SELECT *
FROM Groups.streams_access
WHERE `publisherId` = 'Groups' AND streamName IN ('Streams/interest/adventure_asia','Streams/interest/') AND ofUserId IN ('','ohrxqrzb')
[2015-04-03 11:16:45] (gmba.local) Groups:
SELECT *
FROM Groups.streams_participant
WHERE `publisherId` = 'Groups' AND `streamName` = 'Streams/interest/adventure_asia' AND `userId` = 'ohrxqrzb'
LIMIT 1
[2015-04-03 11:16:45] (gmba.local) Groups:
INSERT INTO Groups.streams_participating (`userId`, `publisherId`, `streamName`, `state`, `extra`, `updatedTime`)
VALUES ( 'ohrxqrzb', 'Groups', 'Streams/interest/adventure_asia', 'participating', '{}', CURRENT_TIMESTAMP )
ON DUPLICATE KEY UPDATE `userId` = 'ohrxqrzb', `publisherId` = 'Groups', `streamName` = 'Streams/interest/adventure_asia', `state` = 'participating', `extra` = '{}', `updatedTime` = CURRENT_TIMESTAMP
[2015-04-03 11:16:45] (gmba.local) Groups:
UPDATE Groups.streams_participant
SET `updatedTime` = CURRENT_TIMESTAMP,
`state` = 'participating',
`subscribed` = 'yes'
WHERE `publisherId` = 'Groups' AND `streamName` = 'Streams/interest/adventure_asia' AND `userId` = 'ohrxqrzb'
[2015-04-03 11:16:45] (gmba.local) Groups: BEGIN
[2015-04-03 11:16:45] (gmba.local) Groups:
SELECT *
FROM Groups.streams_stream
WHERE `publisherId` = 'Groups' AND name IN ('Streams/interest/adventure_asia')
LIMIT 1
FOR UPDATE
[2015-04-03 11:16:45] (gmba.local) Groups:
SELECT *
FROM Groups.streams_access
WHERE `publisherId` = 'Groups' AND streamName IN ('Streams/interest/adventure_asia','Streams/interest/') AND ofUserId IN ('','ohrxqrzb')
[2015-04-03 11:16:45] (gmba.local) Groups:
UPDATE Groups.streams_stream
SET `updatedTime` = CURRENT_TIMESTAMP,
`messageCount` = '9'
WHERE `publisherId` = 'Groups' AND `name` = 'Streams/interest/adventure_asia'
[2015-04-03 11:16:45] (gmba.local) Groups:
INSERT INTO Groups.streams_total (`publisherId`, `streamName`, `messageType`, `messageCount`)
VALUES ( 'Groups', 'Streams/interest/adventure_asia', 'Streams/join', '1' )
ON DUPLICATE KEY UPDATE `publisherId` = 'Groups', `streamName` = 'Streams/interest/adventure_asia', `messageType` = 'Streams/join', `messageCount` = messageCount+1
[2015-04-03 11:16:45] (gmba.local) Groups:
INSERT INTO Groups.streams_message (`publisherId`, `streamName`, `sentTime`, `byUserId`, `byClientId`, `type`, `content`, `instructions`, `weight`, `ordinal`)
VALUES ( 'Groups', 'Streams/interest/adventure_asia', CURRENT_TIMESTAMP, 'ohrxqrzb', '', 'Streams/join', '', '{\"extra\":\"{}\"}', '1', '9' )
[2015-04-03 11:16:45] (gmba.local) Groups: COMMIT
[2015-04-03 11:16:46] (gmba.local) Groups:
SELECT *
FROM Groups.streams_stream
WHERE `publisherId` = 'ohrxqrzb' AND name IN ('Streams/participating')
[2015-04-03 11:16:46] (gmba.local) Groups: BEGIN
[2015-04-03 11:16:46] (gmba.local) Groups:
SELECT *
FROM Groups.streams_stream
WHERE `publisherId` = 'ohrxqrzb' AND name IN ('Streams/participating')
LIMIT 1
FOR UPDATE
[2015-04-03 11:16:46] (gmba.local) Groups:
UPDATE Groups.streams_stream
SET `updatedTime` = CURRENT_TIMESTAMP,
`messageCount` = '123'
WHERE `publisherId` = 'ohrxqrzb' AND `name` = 'Streams/participating'
[2015-04-03 11:16:46] (gmba.local) Groups:
INSERT INTO Groups.streams_total (`publisherId`, `streamName`, `messageType`, `messageCount`)
VALUES ( 'ohrxqrzb', 'Streams/participating', 'Streams/joined', '1' )
ON DUPLICATE KEY UPDATE `publisherId` = 'ohrxqrzb', `streamName` = 'Streams/participating', `messageType` = 'Streams/joined', `messageCount` = messageCount+1
[2015-04-03 11:16:46] (gmba.local) Groups:
INSERT INTO Groups.streams_message (`publisherId`, `streamName`, `sentTime`, `byUserId`, `byClientId`, `type`, `content`, `instructions`, `weight`, `ordinal`)
VALUES ( 'ohrxqrzb', 'Streams/participating', CURRENT_TIMESTAMP, 'ohrxqrzb', '', 'Streams/joined', '', '{\"publisherId\":\"Groups\",\"streamName\":\"Streams/interest/adventure_asia\"}', '1', '123' )
[2015-04-03 11:16:46] (gmba.local) Groups: COMMIT
[2015-04-03 11:16:46] (gmba.local) Groups:
SELECT *
FROM Groups.streams_subscription
WHERE `publisherId` = 'Groups' AND `streamName` = 'Streams/interest/adventure_asia' AND `ofUserId` = 'ohrxqrzb'
LIMIT 1
[2015-04-03 11:16:46] (gmba.local) Groups:
SELECT *
FROM Groups.streams_subscription
WHERE `publisherId` = 'Groups' AND `streamName` = 'Streams/interest/' AND ofUserId IN ('','ohrxqrzb')
[2015-04-03 11:16:46] (gmba.local) Groups:
UPDATE Groups.streams_subscription
SET `updatedTime` = CURRENT_TIMESTAMP,
`filter` = '{\"types\":[],\"notifications\":0}'
WHERE `publisherId` = 'Groups' AND `streamName` = 'Streams/interest/adventure_asia' AND `ofUserId` = 'ohrxqrzb'
[2015-04-03 11:16:46] (gmba.local) Groups:
SELECT *
FROM Groups.streams_rule
WHERE `publisherId` = 'Groups' AND `streamName` = 'Streams/interest/' AND ofUserId IN ('','ohrxqrzb')
[2015-04-03 11:16:46] (gmba.local) Groups:
SELECT *
FROM Groups.streams_rule
WHERE `ofUserId` = 'ohrxqrzb' AND `publisherId` = 'Groups' AND `streamName` = 'Streams/interest/adventure_asia'
LIMIT 1
[2015-04-03 11:16:46] (gmba.local) Groups: BEGIN
[2015-04-03 11:16:46] (gmba.local) Groups:
SELECT *
FROM Groups.streams_stream
WHERE `publisherId` = 'Groups' AND name IN ('Streams/interest/adventure_asia')
LIMIT 1
FOR UPDATE
[2015-04-03 11:16:46] (gmba.local) Groups:
SELECT *
FROM Groups.streams_access
WHERE `publisherId` = 'Groups' AND streamName IN ('Streams/interest/adventure_asia','Streams/interest/') AND ofUserId IN ('','ohrxqrzb')
[2015-04-03 11:16:46] (gmba.local) Groups:
UPDATE Groups.streams_stream
SET `updatedTime` = CURRENT_TIMESTAMP,
`messageCount` = '10'
WHERE `publisherId` = 'Groups' AND `name` = 'Streams/interest/adventure_asia'
[2015-04-03 11:16:46] (gmba.local) Groups:
INSERT INTO Groups.streams_total (`publisherId`, `streamName`, `messageType`, `messageCount`)
VALUES ( 'Groups', 'Streams/interest/adventure_asia', 'Streams/subscribe', '1' )
ON DUPLICATE KEY UPDATE `publisherId` = 'Groups', `streamName` = 'Streams/interest/adventure_asia', `messageType` = 'Streams/subscribe', `messageCount` = messageCount+1
[2015-04-03 11:16:46] (gmba.local) Groups:
INSERT INTO Groups.streams_message (`publisherId`, `streamName`, `sentTime`, `byUserId`, `byClientId`, `type`, `content`, `instructions`, `weight`, `ordinal`)
VALUES ( 'Groups', 'Streams/interest/adventure_asia', CURRENT_TIMESTAMP, 'ohrxqrzb', '', 'Streams/subscribe', '', '', '1', '10' )
[2015-04-03 11:16:46] (gmba.local) Groups: COMMIT
[2015-04-03 11:16:46] (gmba.local) Groups: BEGIN
[2015-04-03 11:16:46] (gmba.local) Groups:
SELECT *
FROM Groups.streams_stream
WHERE `publisherId` = 'ohrxqrzb' AND name IN ('Streams/participating')
LIMIT 1
FOR UPDATE
[2015-04-03 11:16:46] (gmba.local) Groups:
UPDATE Groups.streams_stream
SET `updatedTime` = CURRENT_TIMESTAMP,
`messageCount` = '124'
WHERE `publisherId` = 'ohrxqrzb' AND `name` = 'Streams/participating'
[2015-04-03 11:16:46] (gmba.local) Groups:
INSERT INTO Groups.streams_total (`publisherId`, `streamName`, `messageType`, `messageCount`)
VALUES ( 'ohrxqrzb', 'Streams/participating', 'Streams/subscribed', '1' )
ON DUPLICATE KEY UPDATE `publisherId` = 'ohrxqrzb', `streamName` = 'Streams/participating', `messageType` = 'Streams/subscribed', `messageCount` = messageCount+1
[2015-04-03 11:16:46] (gmba.local) Groups:
INSERT INTO Groups.streams_message (`publisherId`, `streamName`, `sentTime`, `byUserId`, `byClientId`, `type`, `content`, `instructions`, `weight`, `ordinal`)
VALUES ( 'ohrxqrzb', 'Streams/participating', CURRENT_TIMESTAMP, 'ohrxqrzb', '', 'Streams/subscribed', '', '{\"publisherId\":\"Groups\",\"streamName\":\"Streams/interest/adventure_asia\"}', '1', '124' )
[2015-04-03 11:16:46] (gmba.local) Groups: COMMIT
[2015-04-03 11:16:46] (gmba.local) Groups:
SELECT *
FROM Groups.streams_stream
WHERE `publisherId` = 'ohrxqrzb' AND name IN ('Streams/user/interests')
LIMIT 1
[2015-04-03 11:16:46] (gmba.local) Groups:
SELECT *
FROM Groups.streams_related_to
WHERE `toPublisherId` = 'ohrxqrzb' AND `toStreamName` = 'Streams/user/interests' AND `type` = 'Streams/interest' AND `fromPublisherId` = 'Groups' AND `fromStreamName` = 'Streams/interest/adventure_asia'
LIMIT 1
[2015-04-03 11:16:46] (gmba.local) Groups:
SELECT *
FROM Groups.streams_related_from
WHERE `fromPublisherId` = 'Groups' AND `fromStreamName` = 'Streams/interest/adventure_asia' AND `type` = 'Streams/interest' AND `toPublisherId` = 'ohrxqrzb' AND `toStreamName` = 'Streams/user/interests'
LIMIT 1
[2015-04-03 11:16:46] (gmba.local) Groups: SELECT MAX(weight)
FROM Groups.streams_related_to
WHERE `toPublisherId` = 'ohrxqrzb' AND `toStreamName` = 'Streams/user/interests' AND `type` = 'Streams/interest'
[2015-04-03 11:16:46] (gmba.local) Groups:
SELECT MAX(weight)
FROM Groups.streams_related_to
WHERE `toPublisherId` = 'ohrxqrzb' AND `toStreamName` = 'Streams/user/interests' AND `type` = 'Streams/interest'
[2015-04-03 11:16:46] (gmba.local) Groups:
INSERT INTO Groups.streams_related_to (`toPublisherId`, `toStreamName`, `type`, `fromPublisherId`, `fromStreamName`, `weight`)
VALUES ( 'ohrxqrzb', 'Streams/user/interests', 'Streams/interest', 'Groups', 'Streams/interest/adventure_asia', '13' )
[2015-04-03 11:16:46] (gmba.local) Groups: BEGIN
[2015-04-03 11:16:46] (gmba.local) Groups:
SELECT *
FROM Groups.streams_stream
WHERE `publisherId` = 'ohrxqrzb' AND name IN ('Streams/user/interests')
LIMIT 1
FOR UPDATE
[2015-04-03 11:16:46] (gmba.local) Groups:
UPDATE Groups.streams_stream
SET `updatedTime` = CURRENT_TIMESTAMP,
`messageCount` = '24'
WHERE `publisherId` = 'ohrxqrzb' AND `name` = 'Streams/user/interests'
[2015-04-03 11:16:46] (gmba.local) Groups:
INSERT INTO Groups.streams_total (`publisherId`, `streamName`, `messageType`, `messageCount`)
VALUES ( 'ohrxqrzb', 'Streams/user/interests', 'Streams/relatedTo', '1' )
ON DUPLICATE KEY UPDATE `publisherId` = 'ohrxqrzb', `streamName` = 'Streams/user/interests', `messageType` = 'Streams/relatedTo', `messageCount` = messageCount+1
[2015-04-03 11:16:46] (gmba.local) Groups:
INSERT INTO Groups.streams_message (`publisherId`, `streamName`, `sentTime`, `byUserId`, `byClientId`, `type`, `content`, `instructions`, `weight`, `ordinal`)
VALUES ( 'ohrxqrzb', 'Streams/user/interests', CURRENT_TIMESTAMP, 'ohrxqrzb', '', 'Streams/relatedTo', '', '{\"fromPublisherId\":\"Groups\",\"fromStreamName\":\"Streams/interest/adventure_asia\",\"type\":\"Streams/interest\",\"weight\":13}', '1', '24' )
[2015-04-03 11:16:46] (gmba.local) Groups: COMMIT
[2015-04-03 11:16:46] (gmba.local) Groups:
SELECT *
FROM Groups.streams_category
WHERE `publisherId` = 'ohrxqrzb' AND `streamName` = 'Streams/user/interests'
LIMIT 1
[2015-04-03 11:16:46] (gmba.local) Groups:
UPDATE Groups.streams_category
SET `updatedTime` = CURRENT_TIMESTAMP,
`relatedTo` = '{\"Streams/interest\":{\"1\":[\"Groups\",\"Streams/interest/adventure_africa\",\"Adventure: Africa\",\"Streams/interest/adventure_africa\"],\"2\":[\"Groups\",\"Streams/interest/adventure_cruises\",\"Adventure: Cruises\",\"Streams/interest/adventure_cruises\"],\"3\":[\"Groups\",\"Streams/interest/adventure_australia\",\"Adventure: Australia\",\"Streams/interest/adventure_australia\"],\"4\":[\"Groups\",\"Streams/interest/adventure_europe_north_\",\"Adventure: Europe (North)\",\"Streams/interest/adventure_europe_north_\"],\"5\":[\"Groups\",\"Streams/interest/dining_diets\",\"Dining: Diets\",\"Streams/interest/dining_diets\"],\"6\":[\"Groups\",\"Streams/interest/dining_french\",\"Dining: French\",\"Streams/interest/dining_french\"],\"7\":[\"Groups\",\"Streams/interest/dining_american\",\"Dining: American\",\"Streams/interest/dining_american\"],\"8\":[\"Groups\",\"Streams/interest/dining_chinese\",\"Dining:
[2015-04-03 11:16:46] (gmba.local) Groups:
INSERT INTO Groups.streams_related_from (`fromPublisherId`, `fromStreamName`, `type`, `toPublisherId`, `toStreamName`)
VALUES ( 'Groups', 'Streams/interest/adventure_asia', 'Streams/interest', 'ohrxqrzb', 'Streams/user/interests' )
[2015-04-03 11:16:46] (gmba.local) Groups: BEGIN
[2015-04-03 11:16:46] (gmba.local) Groups:
SELECT *
FROM Groups.streams_stream
WHERE `publisherId` = 'Groups' AND name IN ('Streams/interest/adventure_asia')
LIMIT 1
FOR UPDATE
[2015-04-03 11:16:46] (gmba.local) Groups:
SELECT *
FROM Groups.streams_access
WHERE `publisherId` = 'Groups' AND streamName IN ('Streams/interest/adventure_asia','Streams/interest/') AND ofUserId IN ('','ohrxqrzb')
[2015-04-03 11:16:46] (gmba.local) Groups:
UPDATE Groups.streams_stream
SET `updatedTime` = CURRENT_TIMESTAMP,
`messageCount` = '11'
WHERE `publisherId` = 'Groups' AND `name` = 'Streams/interest/adventure_asia'
[2015-04-03 11:16:46] (gmba.local) Groups:
INSERT INTO Groups.streams_total (`publisherId`, `streamName`, `messageType`, `messageCount`)
VALUES ( 'Groups', 'Streams/interest/adventure_asia', 'Streams/relatedFrom', '1' )
ON DUPLICATE KEY UPDATE `publisherId` = 'Groups', `streamName` = 'Streams/interest/adventure_asia', `messageType` = 'Streams/relatedFrom', `messageCount` = messageCount+1
[2015-04-03 11:16:46] (gmba.local) Groups:
INSERT INTO Groups.streams_message (`publisherId`, `streamName`, `sentTime`, `byUserId`, `byClientId`, `type`, `content`, `instructions`, `weight`, `ordinal`)
VALUES ( 'Groups', 'Streams/interest/adventure_asia', CURRENT_TIMESTAMP, 'ohrxqrzb', '', 'Streams/relatedFrom', '', '{\"toPublisherId\":\"ohrxqrzb\",\"toStreamName\":\"Streams/user/interests\",\"type\":\"Streams/interest\",\"weight\":13}', '1', '11' )
[2015-04-03 11:16:46] (gmba.local) Groups: COMMIT
[2015-04-03 11:16:46] (gmba.local) Groups:
SELECT *
FROM Groups.streams_stream
WHERE `publisherId` = 'ohrxqrzb' AND name IN ('Places/user/location')
LIMIT 1
[2015-04-03 11:16:51] (gmba.local) Groups:
SELECT *
FROM Groups.streams_stream
WHERE `publisherId` = 'Groups' AND name IN ('Places/interest/stwuzw/100/adventure_asia','Places/interest/sv9kuy/100/adventure_asia','Places/interest/stzm5m/100/adventure_asia','Places/interest/svbt4v/100/adventure_asia')
[2015-04-03 11:16:51] (gmba.local) Groups:
SELECT *
FROM Groups.streams_participant
WHERE `publisherId` = 'Groups' AND streamName IN ('Places/nearby/stwuzw/100','Places/nearby/sv9kuy/100','Places/nearby/stzm5m/100','Places/nearby/svbt4v/100') AND `userId` = 'ohrxqrzb'
[2015-04-03 11:17:03] (gmba.local) Groups:
SELECT *
FROM Groups.streams_stream
WHERE `publisherId` = 'Groups' AND `name` = 'Places/interest/' AND `type` = 'Streams/template'
LIMIT 1
[2015-04-03 11:17:03] (gmba.local) Groups:
SELECT *
FROM Groups.streams_stream
WHERE `publisherId` = '' AND `name` = 'Places/interest/' AND `type` = 'Streams/template'
LIMIT 1
[2015-04-03 11:17:03] (gmba.local) Groups:
SELECT *
FROM Groups.streams_stream
WHERE publisherId IN ('','Groups') AND `name` = 'Places/interest/'
[2015-04-03 11:17:03] (gmba.local) Groups:
SELECT *
FROM Groups.streams_access
WHERE publisherId IN ('','Groups') AND `streamName` = 'Places/interest/'
[2015-04-03 11:17:03] (gmba.local) Groups:
INSERT INTO Groups.streams_stream (`publisherId`, `name`, `updatedTime`, `type`, `title`, `icon`, `content`, `attributes`, `readLevel`, `writeLevel`, `adminLevel`, `inheritAccess`, `messageCount`, `participantCount`, `closedTime`)
VALUES ( 'Groups', 'Places/interest/stwuzw/100/Adventure: Asia', CURRENT_TIMESTAMP, 'Places/interest', 'Adventure: Asia', 'default', '', '{}', '40', '10', '20', NULL, '0', '0', NULL )
[2015-04-03 11:17:03] (gmba.local) Groups: ~17594ms+7757kb. Exception occurred:
DbQuery Exception: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'Groups-Places/interest/stwuzw/100/Adventure: Asia' for key 'PRIMARY' ... Query was: INSERT INTO Groups.streams_stream (`publisherId`, `name`, `updatedTime`, `type`, `title`, `icon`, `content`, `attributes`, `readLevel`, `writeLevel`, `adminLevel`, `inheritAccess`, `messageCount`, `participantCount`, `closedTime`)
VALUES ( 'Groups', 'Places/interest/stwuzw/100/Adventure: Asia', CURRENT_TIMESTAMP, 'Places/interest', 'Adventure: Asia', 'default', '', '{}', '40', '10', '20', NULL, '0', '0', NULL )
in /projects/qbix/Q/platform/classes/Db/Query/Mysql.php (619)
#0 /projects/qbix/Q/platform/classes/Db/Row.php(1836): Db_Query_Mysql->execute()
#1 /projects/qbix/Q/platform/plugins/Streams/classes/Streams.php(806): Db_Row->save()
#2 /projects/qbix/Q/platform/plugins/Places/classes/Places.php(738): Streams::create(NULL, 'Groups', 'Places/interest
[2015-04-03 11:17:03] (gmba.local) Groups:
UPDATE Groups.users_session
SET `content` = '{\"Q\":{\"nonce\":\"d454a3454f9a29f2cf2c18d376183325\"},\"Users\":{\"loggedInUser\":{\"id\":\"ohrxqrzb\"},\"hinted\":{\"0\":\"Groups/location\",\"1\":\"Groups/newGroup\",\"2\":\"Groups/picture\",\"3\":\"Groups/interests\",\"4\":\"Groups/closeColumn\",\"5\":\"Groups/invite\",\"6\":\"Groups/group/going\",\"7\":\"Groups/chat/open\",\"8\":\"Groups/chat/close\",\"9\":\"Groups/group/close\"}}}',
`php` = 'Q|a:1:{s:5:\"nonce\";s:32:\"d454a3454f9a29f2cf2c18d376183325\";}Users|a:2:{s:12:\"loggedInUser\";a:1:{s:2:\"id\";s:8:\"ohrxqrzb\";}s:6:\"hinted\";a:10:{i:0;s:15:\"Groups/location\";i:1;s:15:\"Groups/newGroup\";i:2;s:14:\"Groups/picture\";i:3;s:16:\"Groups/interests\";i:4;s:18:\"Groups/closeColumn\";i:5;s:13:\"Groups/invite\";i:6;s:18:\"Groups/group/going\";i:7;s:16:\"Groups/chat/open\";i:8;s:17:\"Groups/chat/close\";i:9;s:18:\"Groups/group/close\";}}',
`deviceId` = '',
`timeout` = '0',
`duration` = '86400',
`updatedTime` = CURRENT_TIMESTAMP
WH
[2015-04-03 11:17:49] (gmba.local) Groups:
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment