220 Query SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED 220 Query SET autocommit=0 220 Query select 1 from GROUP_USER_REF where GROUP_ID =3 and USER_ID =1 220 Query select acl_object_identity.object_id_identity, acl_entry.ace_order, acl_object_identity.id as acl_id, acl_object_identity.parent_object, acl_object_identity.entries_inheriting, acl_entry.id as ace_id, acl_entry.mask, acl_entry.granting, acl_entry.audit_success, acl_entry.audit_failure, acl_sid.principal as ace_principal, acl_sid.sid as ace_sid, acli_sid.principal as acl_principal, acli_sid.sid as acl_sid, acl_class.class from acl_object_identity left join acl_sid acli_sid on acli_sid.id = acl_object_identity.owner_sid left join acl_class on acl_class.id = acl_object_identity.object_id_class left join acl_entry on acl_object_identity.id = acl_entry.acl_object_identity left join acl_sid on acl_entry.sid = acl_sid.id where ( (acl_object_identity.object_id_identity = 4 and acl_class.class = 'GROUP')) order by acl_object_identity.object_id_identity asc, acl_entry.ace_order asc 220 Query select 1 from GROUP_USER_REF where GROUP_ID =2 and USER_ID =1 220 Query select this_.USER_ID as ID0_0_, this_1_.VERSION as VERSION0_0_, this_1_.UUID as UUID0_0_, this_1_.FIRST_NAME as FIRST4_0_0_, this_1_.LAST_NAME as LAST5_0_0_, this_1_.USERNAME as USERNAME0_0_, this_1_.ENCODED_USERNAME as ENCODED7_0_0_, this_1_.EMAIL as EMAIL0_0_, this_1_.PASSWORD as PASSWORD0_0_, this_1_.LAST_LOGIN as LAST10_0_0_, this_1_.AVATAR as AVATAR0_0_, this_1_.ENABLED as ENABLED0_0_, this_.SIGNATURE as SIGNATURE2_0_, this_.LANGUAGE as LANGUAGE2_0_, this_.PAGE_SIZE as PAGE4_2_0_, this_.LOCATION as LOCATION2_0_, this_.SEND_PM_NOTIFICATION as SEND6_2_0_, this_.REGISTRATION_DATE as REGISTRA7_2_0_, this_.POST_COUNT as POST8_2_0_, this_.AVATAR_LAST_MODIFICATION_TIME as AVATAR9_2_0_, this_.ALL_FORUM_MARKED_AS_READ_TIME as ALL10_2_0_, this_.AUTOSUBSCRIBE as AUTOSUB11_2_0_, this_.MENTIONING_NOTIFICATIONS_ENABLED as MENTIONING12_2_0_ from JC_USER_DETAILS this_ inner join USERS this_1_ on this_.USER_ID=this_1_.ID where lower(this_1_.USERNAME)='admin' 220 Query insert into TOPIC (UUID, TITLE, CREATION_DATE, MODIFICATION_DATE, STICKED, VIEWS, ANNOUNCEMENT, CLOSED, TOPIC_STARTER, BRANCH_ID, POLL_ID, CODE_REVIEW_ID) values ('1a73a3fb-5ff0-403e-916f-771e8eb9cd51', 'test', '2014-06-26 12:44:17', '2014-06-26 12:44:17', 0, 0, 0, 0, 1, 1, null, null) 220 Query insert into POST (UUID, POST_DATE, MODIFICATION_DATE, POST_CONTENT, USER_CREATED, TOPIC_ID) values ('fdfbf3ba-6425-49f4-ab35-3d092e1cba2d', '2014-06-26 12:44:17', null, 'eioed', 1, 5958) 220 Query update USERS set VERSION=6720, UUID='c311f8f6-ec8f-11e3-86da-001a4df7d4e5', FIRST_NAME=null, LAST_NAME=null, USERNAME='admin', ENCODED_USERNAME='admin', EMAIL='admin@jtalks.org', PASSWORD='21232f297a57a5a743894a0e4a801fc3', LAST_LOGIN='2014-06-26 12:44:07', AVATAR=x'', ENABLED=1 where ID=1 and VERSION=6719 220 Query update JC_USER_DETAILS set SIGNATURE=null, LANGUAGE='ENGLISH', PAGE_SIZE=15, LOCATION=null, SEND_PM_NOTIFICATION=1, REGISTRATION_DATE='2014-06-05 11:59:55', POST_COUNT=1810, AVATAR_LAST_MODIFICATION_TIME=null, ALL_FORUM_MARKED_AS_READ_TIME='2014-06-24 16:41:28', AUTOSUBSCRIBE=1, MENTIONING_NOTIFICATIONS_ENABLED=1 where USER_ID=1 220 Query update BRANCHES set UUID='bee7f440-ec8f-11e3-86da-001a4df7d4e5', NAME='Classical Mechanics', DESCRIPTION='Physical related to motion of bodies under the action of a system of forces', MODERATORS_GROUP_ID=1, SECTION_ID=1, LAST_POST=10306 where BRANCH_ID=1 220 Query select this_.USER_ID as ID0_0_, this_1_.VERSION as VERSION0_0_, this_1_.UUID as UUID0_0_, this_1_.FIRST_NAME as FIRST4_0_0_, this_1_.LAST_NAME as LAST5_0_0_, this_1_.USERNAME as USERNAME0_0_, this_1_.ENCODED_USERNAME as ENCODED7_0_0_, this_1_.EMAIL as EMAIL0_0_, this_1_.PASSWORD as PASSWORD0_0_, this_1_.LAST_LOGIN as LAST10_0_0_, this_1_.AVATAR as AVATAR0_0_, this_1_.ENABLED as ENABLED0_0_, this_.SIGNATURE as SIGNATURE2_0_, this_.LANGUAGE as LANGUAGE2_0_, this_.PAGE_SIZE as PAGE4_2_0_, this_.LOCATION as LOCATION2_0_, this_.SEND_PM_NOTIFICATION as SEND6_2_0_, this_.REGISTRATION_DATE as REGISTRA7_2_0_, this_.POST_COUNT as POST8_2_0_, this_.AVATAR_LAST_MODIFICATION_TIME as AVATAR9_2_0_, this_.ALL_FORUM_MARKED_AS_READ_TIME as ALL10_2_0_, this_.AUTOSUBSCRIBE as AUTOSUB11_2_0_, this_.MENTIONING_NOTIFICATIONS_ENABLED as MENTIONING12_2_0_ from JC_USER_DETAILS this_ inner join USERS this_1_ on this_.USER_ID=this_1_.ID where lower(this_1_.USERNAME)='admin' 220 Query select acl_object_identity.object_id_identity, acl_entry.ace_order, acl_object_identity.id as acl_id, acl_object_identity.parent_object, acl_object_identity.entries_inheriting, acl_entry.id as ace_id, acl_entry.mask, acl_entry.granting, acl_entry.audit_success, acl_entry.audit_failure, acl_sid.principal as ace_principal, acl_sid.sid as ace_sid, acli_sid.principal as acl_principal, acli_sid.sid as acl_sid, acl_class.class from acl_object_identity left join acl_sid acli_sid on acli_sid.id = acl_object_identity.owner_sid left join acl_class on acl_class.id = acl_object_identity.object_id_class left join acl_entry on acl_object_identity.id = acl_entry.acl_object_identity left join acl_sid on acl_entry.sid = acl_sid.id where ( (acl_object_identity.object_id_identity = 5958 and acl_class.class = 'TOPIC')) order by acl_object_identity.object_id_identity asc, acl_entry.ace_order asc 220 Query select acl_object_identity.id from acl_object_identity, acl_class where acl_object_identity.object_id_class = acl_class.id and acl_class.class='TOPIC' and acl_object_identity.object_id_identity = 5958 220 Query select id from acl_sid where principal=1 and sid='user:1' 220 Query select id from acl_class where class='TOPIC' 220 Query insert into acl_object_identity (object_id_class, object_id_identity, owner_sid, entries_inheriting) values (4, 5958, 7, 1) 220 Query select acl_object_identity.object_id_identity, acl_entry.ace_order, acl_object_identity.id as acl_id, acl_object_identity.parent_object, acl_object_identity.entries_inheriting, acl_entry.id as ace_id, acl_entry.mask, acl_entry.granting, acl_entry.audit_success, acl_entry.audit_failure, acl_sid.principal as ace_principal, acl_sid.sid as ace_sid, acli_sid.principal as acl_principal, acli_sid.sid as acl_sid, acl_class.class from acl_object_identity left join acl_sid acli_sid on acli_sid.id = acl_object_identity.owner_sid left join acl_class on acl_class.id = acl_object_identity.object_id_class left join acl_entry on acl_object_identity.id = acl_entry.acl_object_identity left join acl_sid on acl_entry.sid = acl_sid.id where ( (acl_object_identity.object_id_identity = 5958 and acl_class.class = 'TOPIC')) order by acl_object_identity.object_id_identity asc, acl_entry.ace_order asc 220 Query select acl_object_identity.id from acl_object_identity, acl_class where acl_object_identity.object_id_class = acl_class.id and acl_class.class='TOPIC' and acl_object_identity.object_id_identity = 5958 220 Query delete from acl_entry where acl_object_identity=10299 220 Query select id from acl_sid where principal=1 and sid='user:1' 220 Query insert into acl_entry (acl_object_identity, ace_order, sid, mask, granting, audit_success, audit_failure)values (10299, 0, 7, 4, 1, 0, 0) 220 Query select id from acl_sid where principal=1 and sid='user:1' 220 Query update acl_object_identity set parent_object = null, owner_sid = 7, entries_inheriting = 1 where id = 10299 220 Query select obj.object_id_identity as obj_id, class.class as class from acl_object_identity obj, acl_object_identity parent, acl_class class where obj.parent_object = parent.id and obj.object_id_class = class.id and parent.object_id_identity = 5958 and parent.object_id_class = (select id FROM acl_class where acl_class.class = 'TOPIC') 220 Query select acl_object_identity.object_id_identity, acl_entry.ace_order, acl_object_identity.id as acl_id, acl_object_identity.parent_object, acl_object_identity.entries_inheriting, acl_entry.id as ace_id, acl_entry.mask, acl_entry.granting, acl_entry.audit_success, acl_entry.audit_failure, acl_sid.principal as ace_principal, acl_sid.sid as ace_sid, acli_sid.principal as acl_principal, acli_sid.sid as acl_sid, acl_class.class from acl_object_identity left join acl_sid acli_sid on acli_sid.id = acl_object_identity.owner_sid left join acl_class on acl_class.id = acl_object_identity.object_id_class left join acl_entry on acl_object_identity.id = acl_entry.acl_object_identity left join acl_sid on acl_entry.sid = acl_sid.id where ( (acl_object_identity.object_id_identity = 5958 and acl_class.class = 'TOPIC')) order by acl_object_identity.object_id_identity asc, acl_entry.ace_order asc 220 Query select acl_object_identity.object_id_identity, acl_entry.ace_order, acl_object_identity.id as acl_id, acl_object_identity.parent_object, acl_object_identity.entries_inheriting, acl_entry.id as ace_id, acl_entry.mask, acl_entry.granting, acl_entry.audit_success, acl_entry.audit_failure, acl_sid.principal as ace_principal, acl_sid.sid as ace_sid, acli_sid.principal as acl_principal, acli_sid.sid as acl_sid, acl_class.class from acl_object_identity left join acl_sid acli_sid on acli_sid.id = acl_object_identity.owner_sid left join acl_class on acl_class.id = acl_object_identity.object_id_class left join acl_entry on acl_object_identity.id = acl_entry.acl_object_identity left join acl_sid on acl_entry.sid = acl_sid.id where ( (acl_object_identity.object_id_identity = 10306 and acl_class.class = 'POST')) order by acl_object_identity.object_id_identity asc, acl_entry.ace_order asc 220 Query select acl_object_identity.id from acl_object_identity, acl_class where acl_object_identity.object_id_class = acl_class.id and acl_class.class='POST' and acl_object_identity.object_id_identity = 10306 220 Query select id from acl_sid where principal=1 and sid='user:1' 220 Query select id from acl_class where class='POST' 220 Query insert into acl_object_identity (object_id_class, object_id_identity, owner_sid, entries_inheriting) values (5, 10306, 7, 1) 220 Query select acl_object_identity.object_id_identity, acl_entry.ace_order, acl_object_identity.id as acl_id, acl_object_identity.parent_object, acl_object_identity.entries_inheriting, acl_entry.id as ace_id, acl_entry.mask, acl_entry.granting, acl_entry.audit_success, acl_entry.audit_failure, acl_sid.principal as ace_principal, acl_sid.sid as ace_sid, acli_sid.principal as acl_principal, acli_sid.sid as acl_sid, acl_class.class from acl_object_identity left join acl_sid acli_sid on acli_sid.id = acl_object_identity.owner_sid left join acl_class on acl_class.id = acl_object_identity.object_id_class left join acl_entry on acl_object_identity.id = acl_entry.acl_object_identity left join acl_sid on acl_entry.sid = acl_sid.id where ( (acl_object_identity.object_id_identity = 10306 and acl_class.class = 'POST')) order by acl_object_identity.object_id_identity asc, acl_entry.ace_order asc 220 Query select acl_object_identity.id from acl_object_identity, acl_class where acl_object_identity.object_id_class = acl_class.id and acl_class.class='POST' and acl_object_identity.object_id_identity = 10306 220 Query delete from acl_entry where acl_object_identity=10300 220 Query select id from acl_sid where principal=1 and sid='user:1' 220 Query insert into acl_entry (acl_object_identity, ace_order, sid, mask, granting, audit_success, audit_failure)values (10300, 0, 7, 4, 1, 0, 0) 220 Query select id from acl_sid where principal=1 and sid='user:1' 220 Query update acl_object_identity set parent_object = null, owner_sid = 7, entries_inheriting = 1 where id = 10300 220 Query select obj.object_id_identity as obj_id, class.class as class from acl_object_identity obj, acl_object_identity parent, acl_class class where obj.parent_object = parent.id and obj.object_id_class = class.id and parent.object_id_identity = 10306 and parent.object_id_class = (select id FROM acl_class where acl_class.class = 'POST') 220 Query select acl_object_identity.object_id_identity, acl_entry.ace_order, acl_object_identity.id as acl_id, acl_object_identity.parent_object, acl_object_identity.entries_inheriting, acl_entry.id as ace_id, acl_entry.mask, acl_entry.granting, acl_entry.audit_success, acl_entry.audit_failure, acl_sid.principal as ace_principal, acl_sid.sid as ace_sid, acli_sid.principal as acl_principal, acli_sid.sid as acl_sid, acl_class.class from acl_object_identity left join acl_sid acli_sid on acli_sid.id = acl_object_identity.owner_sid left join acl_class on acl_class.id = acl_object_identity.object_id_class left join acl_entry on acl_object_identity.id = acl_entry.acl_object_identity left join acl_sid on acl_entry.sid = acl_sid.id where ( (acl_object_identity.object_id_identity = 10306 and acl_class.class = 'POST')) order by acl_object_identity.object_id_identity asc, acl_entry.ace_order asc 220 Query select jcuser2_.USER_ID as ID0_, jcuser2_1_.VERSION as VERSION0_, jcuser2_1_.UUID as UUID0_, jcuser2_1_.FIRST_NAME as FIRST4_0_, jcuser2_1_.LAST_NAME as LAST5_0_, jcuser2_1_.USERNAME as USERNAME0_, jcuser2_1_.ENCODED_USERNAME as ENCODED7_0_, jcuser2_1_.EMAIL as EMAIL0_, jcuser2_1_.PASSWORD as PASSWORD0_, jcuser2_1_.LAST_LOGIN as LAST10_0_, jcuser2_1_.AVATAR as AVATAR0_, jcuser2_1_.ENABLED as ENABLED0_, jcuser2_.SIGNATURE as SIGNATURE2_, jcuser2_.LANGUAGE as LANGUAGE2_, jcuser2_.PAGE_SIZE as PAGE4_2_, jcuser2_.LOCATION as LOCATION2_, jcuser2_.SEND_PM_NOTIFICATION as SEND6_2_, jcuser2_.REGISTRATION_DATE as REGISTRA7_2_, jcuser2_.POST_COUNT as POST8_2_, jcuser2_.AVATAR_LAST_MODIFICATION_TIME as AVATAR9_2_, jcuser2_.ALL_FORUM_MARKED_AS_READ_TIME as ALL10_2_, jcuser2_.AUTOSUBSCRIBE as AUTOSUB11_2_, jcuser2_.MENTIONING_NOTIFICATIONS_ENABLED as MENTIONING12_2_ from BRANCHES branch0_ inner join BRANCH_SUBSCRIPTIONS subscriber1_ on branch0_.BRANCH_ID=subscriber1_.BRANCH_ID inner join JC_USER_DETAILS jcuser2_ on subscriber1_.USER_ID=jcuser2_.USER_ID inner join USERS jcuser2_1_ on jcuser2_.USER_ID=jcuser2_1_.ID inner join GROUP_USER_REF groups3_ on jcuser2_.USER_ID=groups3_.USER_ID inner join GROUPS group4_ on groups3_.GROUP_ID=group4_.GROUP_ID where 'BRANCH'='BRANCH' and branch0_.BRANCH_ID=1 and (branch0_.BRANCH_ID not in (select viewtopics5_.BRANCH_ID from BRANCHES_VIEW_TOPICS viewtopics5_ where viewtopics5_.GRANTING=0 and (viewtopics5_.SID in (select group4_.GROUP_ID from GROUP_USER_REF groups3_, GROUPS group4_ where jcuser2_.USER_ID=groups3_.USER_ID and groups3_.GROUP_ID=group4_.GROUP_ID)))) and (branch0_.BRANCH_ID in (select viewtopics6_.BRANCH_ID from BRANCHES_VIEW_TOPICS viewtopics6_ where viewtopics6_.GRANTING=1 and (viewtopics6_.SID in (select group4_.GROUP_ID from GROUP_USER_REF groups3_, GROUPS group4_ where jcuser2_.USER_ID=groups3_.USER_ID and groups3_.GROUP_ID=group4_.GROUP_ID)))) 220 Query select this_.USER_ID as ID0_0_, this_1_.VERSION as VERSION0_0_, this_1_.UUID as UUID0_0_, this_1_.FIRST_NAME as FIRST4_0_0_, this_1_.LAST_NAME as LAST5_0_0_, this_1_.USERNAME as USERNAME0_0_, this_1_.ENCODED_USERNAME as ENCODED7_0_0_, this_1_.EMAIL as EMAIL0_0_, this_1_.PASSWORD as PASSWORD0_0_, this_1_.LAST_LOGIN as LAST10_0_0_, this_1_.AVATAR as AVATAR0_0_, this_1_.ENABLED as ENABLED0_0_, this_.SIGNATURE as SIGNATURE2_0_, this_.LANGUAGE as LANGUAGE2_0_, this_.PAGE_SIZE as PAGE4_2_0_, this_.LOCATION as LOCATION2_0_, this_.SEND_PM_NOTIFICATION as SEND6_2_0_, this_.REGISTRATION_DATE as REGISTRA7_2_0_, this_.POST_COUNT as POST8_2_0_, this_.AVATAR_LAST_MODIFICATION_TIME as AVATAR9_2_0_, this_.ALL_FORUM_MARKED_AS_READ_TIME as ALL10_2_0_, this_.AUTOSUBSCRIBE as AUTOSUB11_2_0_, this_.MENTIONING_NOTIFICATIONS_ENABLED as MENTIONING12_2_0_ from JC_USER_DETAILS this_ inner join USERS this_1_ on this_.USER_ID=this_1_.ID where lower(this_1_.USERNAME)='admin' 220 Query select this_.USER_ID as ID0_0_, this_1_.VERSION as VERSION0_0_, this_1_.UUID as UUID0_0_, this_1_.FIRST_NAME as FIRST4_0_0_, this_1_.LAST_NAME as LAST5_0_0_, this_1_.USERNAME as USERNAME0_0_, this_1_.ENCODED_USERNAME as ENCODED7_0_0_, this_1_.EMAIL as EMAIL0_0_, this_1_.PASSWORD as PASSWORD0_0_, this_1_.LAST_LOGIN as LAST10_0_0_, this_1_.AVATAR as AVATAR0_0_, this_1_.ENABLED as ENABLED0_0_, this_.SIGNATURE as SIGNATURE2_0_, this_.LANGUAGE as LANGUAGE2_0_, this_.PAGE_SIZE as PAGE4_2_0_, this_.LOCATION as LOCATION2_0_, this_.SEND_PM_NOTIFICATION as SEND6_2_0_, this_.REGISTRATION_DATE as REGISTRA7_2_0_, this_.POST_COUNT as POST8_2_0_, this_.AVATAR_LAST_MODIFICATION_TIME as AVATAR9_2_0_, this_.ALL_FORUM_MARKED_AS_READ_TIME as ALL10_2_0_, this_.AUTOSUBSCRIBE as AUTOSUB11_2_0_, this_.MENTIONING_NOTIFICATIONS_ENABLED as MENTIONING12_2_0_ from JC_USER_DETAILS this_ inner join USERS this_1_ on this_.USER_ID=this_1_.ID where lower(this_1_.USERNAME)='admin' 220 Query insert into TOPIC_SUBSCRIPTIONS (TOPIC_ID, USER_ID) values (5958, 1) 220 Query select acl_object_identity.object_id_identity, acl_entry.ace_order, acl_object_identity.id as acl_id, acl_object_identity.parent_object, acl_object_identity.entries_inheriting, acl_entry.id as ace_id, acl_entry.mask, acl_entry.granting, acl_entry.audit_success, acl_entry.audit_failure, acl_sid.principal as ace_principal, acl_sid.sid as ace_sid, acli_sid.principal as acl_principal, acli_sid.sid as acl_sid, acl_class.class from acl_object_identity left join acl_sid acli_sid on acli_sid.id = acl_object_identity.owner_sid left join acl_class on acl_class.id = acl_object_identity.object_id_class left join acl_entry on acl_object_identity.id = acl_entry.acl_object_identity left join acl_sid on acl_entry.sid = acl_sid.id where ( (acl_object_identity.object_id_identity = 4 and acl_class.class = 'GROUP')) order by acl_object_identity.object_id_identity asc, acl_entry.ace_order asc 220 Query select 1 from GROUP_USER_REF where GROUP_ID =2 and USER_ID =1 220 Query select this_.USER_ID as ID0_0_, this_1_.VERSION as VERSION0_0_, this_1_.UUID as UUID0_0_, this_1_.FIRST_NAME as FIRST4_0_0_, this_1_.LAST_NAME as LAST5_0_0_, this_1_.USERNAME as USERNAME0_0_, this_1_.ENCODED_USERNAME as ENCODED7_0_0_, this_1_.EMAIL as EMAIL0_0_, this_1_.PASSWORD as PASSWORD0_0_, this_1_.LAST_LOGIN as LAST10_0_0_, this_1_.AVATAR as AVATAR0_0_, this_1_.ENABLED as ENABLED0_0_, this_.SIGNATURE as SIGNATURE2_0_, this_.LANGUAGE as LANGUAGE2_0_, this_.PAGE_SIZE as PAGE4_2_0_, this_.LOCATION as LOCATION2_0_, this_.SEND_PM_NOTIFICATION as SEND6_2_0_, this_.REGISTRATION_DATE as REGISTRA7_2_0_, this_.POST_COUNT as POST8_2_0_, this_.AVATAR_LAST_MODIFICATION_TIME as AVATAR9_2_0_, this_.ALL_FORUM_MARKED_AS_READ_TIME as ALL10_2_0_, this_.AUTOSUBSCRIBE as AUTOSUB11_2_0_, this_.MENTIONING_NOTIFICATIONS_ENABLED as MENTIONING12_2_0_ from JC_USER_DETAILS this_ inner join USERS this_1_ on this_.USER_ID=this_1_.ID where lower(this_1_.USERNAME)='admin' 220 Query select lastreadpo0_.ID as ID13_, lastreadpo0_.UUID as UUID13_, lastreadpo0_.USER_ID as USER3_13_, lastreadpo0_.TOPIC_ID as TOPIC4_13_, lastreadpo0_.LAST_READ_POST_DATE as LAST5_13_ from LAST_READ_POSTS lastreadpo0_ where lastreadpo0_.TOPIC_ID=5958 and lastreadpo0_.USER_ID=1 220 Query insert into LAST_READ_POSTS (UUID, USER_ID, TOPIC_ID, LAST_READ_POST_DATE) values ('02b9ef46-f7c6-43fb-9fbf-c0ef83500b8f', 1, 5958, '2014-06-26 12:44:17') 220 Query commit