Skip to content

Instantly share code, notes, and snippets.

@jraddaoui
Created February 29, 2016 23:19
Show Gist options
  • Save jraddaoui/32abee1040f793464291 to your computer and use it in GitHub Desktop.
Save jraddaoui/32abee1040f793464291 to your computer and use it in GitHub Desktop.
IO creation with fix. Forcing a timeout in the middle of the nested set update.
131 Connect root@localhost on atom_2
131 Query SET NAMES 'utf8'
131 Query SELECT COUNT(*) FROM `setting` WHERE setting.NAME='plugins'
131 Query SELECT setting.NAME, setting.SCOPE, setting.EDITABLE, setting.DELETEABLE, setting.SOURCE_CULTURE, setting.ID, setting.SERIAL_NUMBER FROM `setting` WHERE setting.NAME='plugins'
131 Query SELECT setting_i18n.VALUE, setting_i18n.ID, setting_i18n.CULTURE FROM `setting_i18n` WHERE setting_i18n.ID='1'
131 Query SELECT value
FROM setting JOIN setting_i18n ON setting.id = setting_i18n.id
WHERE scope = "default_template" AND name = 'informationobject'
131 Query SELECT COUNT(*) FROM `user`, `actor`, `object` WHERE user.ID='115215' AND actor.ID=object.ID AND user.ID=actor.ID
131 Query SELECT object.CLASS_NAME, object.CREATED_AT, object.UPDATED_AT, object.ID, object.SERIAL_NUMBER, actor.ID, actor.CORPORATE_BODY_IDENTIFIERS, actor.ENTITY_TYPE_ID, actor.DESCRIPTION_STATUS_ID, actor.DESCRIPTION_DETAIL_ID, actor.DESCRIPTION_IDENTIFIER, actor.SOURCE_STANDARD, actor.PARENT_ID, actor.LFT, actor.RGT, actor.SOURCE_CULTURE, user.ID, user.USERNAME, user.EMAIL, user.SHA1_PASSWORD, user.SALT, user.ACTIVE FROM `object`, `actor`, `user` WHERE user.ID='115215' AND actor.ID=object.ID AND user.ID=actor.ID
131 Query START TRANSACTION
131 Query SELECT COUNT(*) FROM `information_object`, `object` WHERE information_object.ID=1 AND information_object.ID=object.ID
131 Query SELECT object.CLASS_NAME, object.CREATED_AT, object.UPDATED_AT, object.ID, object.SERIAL_NUMBER, information_object.ID, information_object.IDENTIFIER, information_object.OAI_LOCAL_IDENTIFIER, information_object.LEVEL_OF_DESCRIPTION_ID, information_object.COLLECTION_TYPE_ID, information_object.REPOSITORY_ID, information_object.PARENT_ID, information_object.DESCRIPTION_STATUS_ID, information_object.DESCRIPTION_DETAIL_ID, information_object.DESCRIPTION_IDENTIFIER, information_object.SOURCE_STANDARD, information_object.DISPLAY_STANDARD_ID, information_object.LFT, information_object.RGT, information_object.SOURCE_CULTURE FROM `object`, `information_object` WHERE information_object.ID=1 AND information_object.ID=object.ID
131 Query SELECT information_object_i18n.TITLE, information_object_i18n.ALTERNATE_TITLE, information_object_i18n.EDITION, information_object_i18n.EXTENT_AND_MEDIUM, information_object_i18n.ARCHIVAL_HISTORY, information_object_i18n.ACQUISITION, information_object_i18n.SCOPE_AND_CONTENT, information_object_i18n.APPRAISAL, information_object_i18n.ACCRUALS, information_object_i18n.ARRANGEMENT, information_object_i18n.ACCESS_CONDITIONS, information_object_i18n.REPRODUCTION_CONDITIONS, information_object_i18n.PHYSICAL_CHARACTERISTICS, information_object_i18n.FINDING_AIDS, information_object_i18n.LOCATION_OF_ORIGINALS, information_object_i18n.LOCATION_OF_COPIES, information_object_i18n.RELATED_UNITS_OF_DESCRIPTION, information_object_i18n.INSTITUTION_RESPONSIBLE_IDENTIFIER, information_object_i18n.RULES, information_object_i18n.SOURCES, information_object_i18n.REVISION_HISTORY, information_object_i18n.ID, information_object_i18n.CULTURE FROM `information_object_i18n` WHERE information_object_i18n.ID='1'
131 Query SELECT slug.SLUG
FROM slug
WHERE '1' = slug.OBJECT_ID
131 Query SELECT COUNT(*) FROM `acl_group` WHERE acl_group.ID=99
131 Query SELECT acl_group.ID, acl_group.PARENT_ID, acl_group.LFT, acl_group.RGT, acl_group.CREATED_AT, acl_group.UPDATED_AT, acl_group.SOURCE_CULTURE, acl_group.SERIAL_NUMBER FROM `acl_group` WHERE acl_group.ID=99
131 Query SELECT actor_i18n.AUTHORIZED_FORM_OF_NAME, actor_i18n.DATES_OF_EXISTENCE, actor_i18n.HISTORY, actor_i18n.PLACES, actor_i18n.LEGAL_STATUS, actor_i18n.FUNCTIONS, actor_i18n.MANDATES, actor_i18n.INTERNAL_STRUCTURES, actor_i18n.GENERAL_CONTEXT, actor_i18n.INSTITUTION_RESPONSIBLE_IDENTIFIER, actor_i18n.RULES, actor_i18n.SOURCES, actor_i18n.REVISION_HISTORY, actor_i18n.ID, actor_i18n.CULTURE FROM `actor_i18n` WHERE actor_i18n.ID='115215'
131 Query SELECT COUNT(*) FROM `acl_user_group` WHERE acl_user_group.USER_ID='115215'
131 Query SELECT acl_user_group.ID, acl_user_group.USER_ID, acl_user_group.GROUP_ID, acl_user_group.SERIAL_NUMBER FROM `acl_user_group` WHERE acl_user_group.USER_ID='115215'
131 Query SELECT COUNT(*) FROM `acl_group` WHERE acl_group.ID='100'
131 Query SELECT acl_group.ID, acl_group.PARENT_ID, acl_group.LFT, acl_group.RGT, acl_group.CREATED_AT, acl_group.UPDATED_AT, acl_group.SOURCE_CULTURE, acl_group.SERIAL_NUMBER FROM `acl_group` WHERE acl_group.ID='100'
131 Query SELECT COUNT(*) FROM `acl_group` WHERE acl_group.ID='99'
131 Query SELECT acl_group.ID, acl_group.PARENT_ID, acl_group.LFT, acl_group.RGT, acl_group.CREATED_AT, acl_group.UPDATED_AT, acl_group.SOURCE_CULTURE, acl_group.SERIAL_NUMBER FROM `acl_group` WHERE acl_group.ID='99'
131 Query SELECT COUNT(*) FROM `information_object`, `object` WHERE information_object.LFT<'1' AND information_object.RGT>'962' AND information_object.ID=object.ID
131 Query SELECT object.CLASS_NAME, object.CREATED_AT, object.UPDATED_AT, object.ID, object.SERIAL_NUMBER, information_object.ID, information_object.IDENTIFIER, information_object.OAI_LOCAL_IDENTIFIER, information_object.LEVEL_OF_DESCRIPTION_ID, information_object.COLLECTION_TYPE_ID, information_object.REPOSITORY_ID, information_object.PARENT_ID, information_object.DESCRIPTION_STATUS_ID, information_object.DESCRIPTION_DETAIL_ID, information_object.DESCRIPTION_IDENTIFIER, information_object.SOURCE_STANDARD, information_object.DISPLAY_STANDARD_ID, information_object.LFT, information_object.RGT, information_object.SOURCE_CULTURE FROM `object`, `information_object` WHERE information_object.LFT<'1' AND information_object.RGT>'962' AND information_object.ID=object.ID ORDER BY information_object.LFT ASC,information_object.LFT ASC
131 Query SELECT COUNT(*) FROM `acl_permission` WHERE ((acl_permission.GROUP_ID IN (99,'100','115215') OR acl_permission.USER_ID='115215') AND (acl_permission.OBJECT_ID IN ('1') OR acl_permission.OBJECT_ID IS NULL ))
131 Query SELECT acl_permission.ID, acl_permission.USER_ID, acl_permission.GROUP_ID, acl_permission.OBJECT_ID, acl_permission.ACTION, acl_permission.GRANT_DENY, acl_permission.CONDITIONAL, acl_permission.CONSTANTS, acl_permission.CREATED_AT, acl_permission.UPDATED_AT, acl_permission.SERIAL_NUMBER FROM `acl_permission` WHERE ((acl_permission.GROUP_ID IN (99,'100','115215') OR acl_permission.USER_ID='115215') AND (acl_permission.OBJECT_ID IN ('1') OR acl_permission.OBJECT_ID IS NULL ))
131 Query SELECT COUNT(*) FROM `term`, `object` WHERE term.ID=111 AND term.ID=object.ID
131 Query SELECT object.CLASS_NAME, object.CREATED_AT, object.UPDATED_AT, object.ID, object.SERIAL_NUMBER, term.ID, term.TAXONOMY_ID, term.CODE, term.PARENT_ID, term.LFT, term.RGT, term.SOURCE_CULTURE FROM `object`, `term` WHERE term.ID=111 AND term.ID=object.ID
131 Query SELECT COUNT(*) FROM `term`, `object` WHERE term.ID=118 AND term.ID=object.ID
131 Query SELECT object.CLASS_NAME, object.CREATED_AT, object.UPDATED_AT, object.ID, object.SERIAL_NUMBER, term.ID, term.TAXONOMY_ID, term.CODE, term.PARENT_ID, term.LFT, term.RGT, term.SOURCE_CULTURE FROM `object`, `term` WHERE term.ID=118 AND term.ID=object.ID
131 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='111'
131 Query SELECT slug.SLUG
FROM slug
WHERE '111' = slug.OBJECT_ID
131 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='118'
131 Query SELECT slug.SLUG
FROM slug
WHERE '118' = slug.OBJECT_ID
131 Query SELECT note.OBJECT_ID, note.TYPE_ID, note.SCOPE, note.USER_ID, note.SOURCE_CULTURE, note.ID, note.SERIAL_NUMBER FROM `note`, `term` WHERE note.OBJECT_ID IS NULL AND note.TYPE_ID=120 AND note.TYPE_ID=term.ID
131 Query SELECT note.OBJECT_ID, note.TYPE_ID, note.SCOPE, note.USER_ID, note.SOURCE_CULTURE, note.ID, note.SERIAL_NUMBER FROM `note`, `term` WHERE note.OBJECT_ID IS NULL AND note.TYPE_ID=125 AND note.TYPE_ID=term.ID
131 Query SELECT note.OBJECT_ID, note.TYPE_ID, note.SCOPE, note.USER_ID, note.SOURCE_CULTURE, note.ID, note.SERIAL_NUMBER FROM `note`, `term` WHERE note.OBJECT_ID IS NULL AND note.TYPE_ID=124 AND note.TYPE_ID=term.ID
131 Query SELECT object.CLASS_NAME, object.CREATED_AT, object.UPDATED_AT, object.ID, object.SERIAL_NUMBER, event.ID, event.START_DATE, event.START_TIME, event.END_DATE, event.END_TIME, event.TYPE_ID, event.OBJECT_ID, event.ACTOR_ID, event.SOURCE_CULTURE FROM `object`, `event` WHERE event.OBJECT_ID IS NULL AND event.ACTOR_ID IS NOT NULL AND event.TYPE_ID=111 AND event.ID=object.ID
131 Query SELECT COUNT(*) FROM `term`, `object` WHERE term.ID IS NULL AND term.ID=object.ID
131 Query SELECT object.CLASS_NAME, object.CREATED_AT, object.UPDATED_AT, object.ID, object.SERIAL_NUMBER, term.ID, term.TAXONOMY_ID, term.CODE, term.PARENT_ID, term.LFT, term.RGT, term.SOURCE_CULTURE FROM `object`, `term` WHERE term.TAXONOMY_ID=31 AND term.ID=object.ID
131 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='189'
131 Query SELECT slug.SLUG
FROM slug
WHERE '189' = slug.OBJECT_ID
131 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='190'
131 Query SELECT slug.SLUG
FROM slug
WHERE '190' = slug.OBJECT_ID
131 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='191'
131 Query SELECT slug.SLUG
FROM slug
WHERE '191' = slug.OBJECT_ID
131 Query SELECT COUNT(*) FROM `property` WHERE property.OBJECT_ID IS NULL AND property.NAME='language'
131 Query SELECT note.OBJECT_ID, note.TYPE_ID, note.SCOPE, note.USER_ID, note.SOURCE_CULTURE, note.ID, note.SERIAL_NUMBER FROM `note`, `term` WHERE note.OBJECT_ID IS NULL AND note.TYPE_ID=174 AND note.TYPE_ID=term.ID
131 Query SELECT COUNT(*) FROM `property` WHERE property.OBJECT_ID IS NULL AND property.NAME='languageOfDescription'
131 Query SELECT COUNT(*) FROM `term`, `object` WHERE term.ID IS NULL AND term.ID=object.ID
131 Query SELECT object.CLASS_NAME, object.CREATED_AT, object.UPDATED_AT, object.ID, object.SERIAL_NUMBER, term.ID, term.TAXONOMY_ID, term.CODE, term.PARENT_ID, term.LFT, term.RGT, term.SOURCE_CULTURE, (CASE WHEN (current.NAME IS NOT NULL AND current.NAME <> '') THEN current.NAME ELSE source.NAME END) AS NAME, (CASE WHEN (current.ID IS NOT NULL AND current.ID <> '') THEN current.ID ELSE source.ID END) AS ID, (CASE WHEN (current.CULTURE IS NOT NULL AND current.CULTURE <> '') THEN current.CULTURE ELSE source.CULTURE END) AS CULTURE FROM `object` CROSS JOIN `term` LEFT JOIN term_i18n current ON (term.ID=current.id AND current.CULTURE='en') LEFT JOIN term_i18n source ON (term.ID=source.id AND source.CULTURE=term.SOURCE_CULTURE AND source.CULTURE <> 'en') WHERE term.TAXONOMY_ID=34 AND term.ID=object.ID ORDER BY name ASC
131 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='194'
131 Query SELECT slug.SLUG
FROM slug
WHERE '194' = slug.OBJECT_ID
131 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='197'
131 Query SELECT slug.SLUG
FROM slug
WHERE '197' = slug.OBJECT_ID
131 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='192'
131 Query SELECT slug.SLUG
FROM slug
WHERE '192' = slug.OBJECT_ID
131 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='198'
131 Query SELECT slug.SLUG
FROM slug
WHERE '198' = slug.OBJECT_ID
131 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='2000004'
131 Query SELECT slug.SLUG
FROM slug
WHERE '2000004' = slug.OBJECT_ID
131 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='69884'
131 Query SELECT slug.SLUG
FROM slug
WHERE '69884' = slug.OBJECT_ID
131 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='195'
131 Query SELECT slug.SLUG
FROM slug
WHERE '195' = slug.OBJECT_ID
131 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='193'
131 Query SELECT slug.SLUG
FROM slug
WHERE '193' = slug.OBJECT_ID
131 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='196'
131 Query SELECT slug.SLUG
FROM slug
WHERE '196' = slug.OBJECT_ID
131 Query SELECT object.CLASS_NAME, object.CREATED_AT, object.UPDATED_AT, object.ID, object.SERIAL_NUMBER, relation.ID, relation.SUBJECT_ID, relation.OBJECT_ID, relation.TYPE_ID, relation.START_DATE, relation.END_DATE, relation.SOURCE_CULTURE FROM `object`, `relation` WHERE relation.SUBJECT_ID IS NULL AND relation.TYPE_ID=161 AND relation.ID=object.ID
131 Query SELECT object.CLASS_NAME, object.CREATED_AT, object.UPDATED_AT, object.ID, object.SERIAL_NUMBER, object_term_relation.ID, object_term_relation.OBJECT_ID, object_term_relation.TERM_ID, object_term_relation.START_DATE, object_term_relation.END_DATE FROM `object`, `object_term_relation`, `term` WHERE object_term_relation.OBJECT_ID IS NULL AND term.TAXONOMY_ID=78 AND object_term_relation.TERM_ID=term.ID AND object_term_relation.ID=object.ID
131 Query SELECT object.CLASS_NAME, object.CREATED_AT, object.UPDATED_AT, object.ID, object.SERIAL_NUMBER, object_term_relation.ID, object_term_relation.OBJECT_ID, object_term_relation.TERM_ID, object_term_relation.START_DATE, object_term_relation.END_DATE FROM `object`, `object_term_relation`, `term` WHERE object_term_relation.OBJECT_ID IS NULL AND term.TAXONOMY_ID=42 AND object_term_relation.TERM_ID=term.ID AND object_term_relation.ID=object.ID
131 Query SELECT object.CLASS_NAME, object.CREATED_AT, object.UPDATED_AT, object.ID, object.SERIAL_NUMBER, relation.ID, relation.SUBJECT_ID, relation.OBJECT_ID, relation.TYPE_ID, relation.START_DATE, relation.END_DATE, relation.SOURCE_CULTURE FROM `object`, `relation` WHERE relation.SUBJECT_ID IS NULL AND relation.TYPE_ID=176 AND relation.ID=object.ID
131 Query SELECT object.CLASS_NAME, object.CREATED_AT, object.UPDATED_AT, object.ID, object.SERIAL_NUMBER, relation.ID, relation.SUBJECT_ID, relation.OBJECT_ID, relation.TYPE_ID, relation.START_DATE, relation.END_DATE, relation.SOURCE_CULTURE FROM `object`, `relation` WHERE relation.OBJECT_ID IS NULL AND relation.TYPE_ID=176 AND relation.ID=object.ID
131 Query SELECT COUNT(*) FROM `repository`, `actor`, `object` WHERE repository.ID IS NULL AND actor.ID=object.ID AND repository.ID=actor.ID
131 Query SELECT COUNT(*) FROM `property` WHERE property.OBJECT_ID IS NULL AND property.NAME='scriptOfDescription'
131 Query SELECT COUNT(*) FROM `property` WHERE property.OBJECT_ID IS NULL AND property.NAME='script'
131 Query SELECT object.CLASS_NAME, object.CREATED_AT, object.UPDATED_AT, object.ID, object.SERIAL_NUMBER, object_term_relation.ID, object_term_relation.OBJECT_ID, object_term_relation.TERM_ID, object_term_relation.START_DATE, object_term_relation.END_DATE FROM `object`, `object_term_relation`, `term` WHERE object_term_relation.OBJECT_ID IS NULL AND term.TAXONOMY_ID=35 AND object_term_relation.TERM_ID=term.ID AND object_term_relation.ID=object.ID
131 Query SELECT COUNT(*) FROM `term`, `object` WHERE term.ID IS NULL AND term.ID=object.ID
131 Query SELECT object.CLASS_NAME, object.CREATED_AT, object.UPDATED_AT, object.ID, object.SERIAL_NUMBER, term.ID, term.TAXONOMY_ID, term.CODE, term.PARENT_ID, term.LFT, term.RGT, term.SOURCE_CULTURE FROM `object`, `term` WHERE term.TAXONOMY_ID=33 AND term.ID=object.ID
131 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='186'
131 Query SELECT slug.SLUG
FROM slug
WHERE '186' = slug.OBJECT_ID
131 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='187'
131 Query SELECT slug.SLUG
FROM slug
WHERE '187' = slug.OBJECT_ID
131 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='188'
131 Query SELECT slug.SLUG
FROM slug
WHERE '188' = slug.OBJECT_ID
131 Query SELECT object.CLASS_NAME, object.CREATED_AT, object.UPDATED_AT, object.ID, object.SERIAL_NUMBER, term.ID, term.TAXONOMY_ID, term.CODE, term.PARENT_ID, term.LFT, term.RGT, term.SOURCE_CULTURE FROM `object`, `term` WHERE term.TAXONOMY_ID=70 AND term.ID=object.ID
131 Query SELECT property.OBJECT_ID, property.SCOPE, property.NAME, property.SOURCE_CULTURE, property.ID, property.SERIAL_NUMBER FROM `property` WHERE property.OBJECT_ID IS NULL AND property.SCOPE='alternativeIdentifiers'
131 Query SELECT object.CLASS_NAME, object.CREATED_AT, object.UPDATED_AT, object.ID, object.SERIAL_NUMBER, event.ID, event.START_DATE, event.START_TIME, event.END_DATE, event.END_TIME, event.TYPE_ID, event.OBJECT_ID, event.ACTOR_ID, event.SOURCE_CULTURE FROM `object` CROSS JOIN `event` LEFT JOIN event_i18n ON (event.ID=event_i18n.ID AND event.SOURCE_CULTURE=event_i18n.CULTURE) WHERE event.OBJECT_ID IS NULL AND ((event.END_DATE IS NOT NULL OR event.START_DATE IS NOT NULL ) OR event_i18n.DATE IS NOT NULL ) AND event.ID=object.ID ORDER BY event.START_DATE DESC
131 Query SELECT object.CLASS_NAME, object.CREATED_AT, object.UPDATED_AT, object.ID, object.SERIAL_NUMBER FROM `object`, `slug` WHERE slug.SLUG='v5gxo' AND slug.OBJECT_ID=object.ID
131 Query SELECT value
FROM setting JOIN setting_i18n ON setting.id = setting_i18n.id
WHERE scope = "default_template" AND name = 'informationobject'
131 Query SELECT code
FROM information_object JOIN term ON information_object.display_standard_id = term.id
WHERE information_object.id = '1' AND taxonomy_id = '70'
131 Query SELECT COUNT(*) FROM `property` WHERE property.OBJECT_ID IS NULL AND property.NAME='language'
131 Query SELECT COUNT(*) FROM `property` WHERE property.OBJECT_ID IS NULL AND property.NAME='languageOfDescription'
131 Query SELECT COUNT(*) FROM `property` WHERE property.OBJECT_ID IS NULL AND property.NAME='scriptOfDescription'
131 Query SELECT COUNT(*) FROM `property` WHERE property.OBJECT_ID IS NULL AND property.NAME='script'
131 Query SELECT status.OBJECT_ID, status.TYPE_ID, status.STATUS_ID, status.ID, status.SERIAL_NUMBER FROM `status` WHERE status.OBJECT_ID IS NULL AND status.TYPE_ID=158 LIMIT 1
131 Query SELECT status.OBJECT_ID, status.TYPE_ID, status.STATUS_ID, status.ID, status.SERIAL_NUMBER FROM `status` WHERE status.OBJECT_ID IS NULL AND status.TYPE_ID=158 LIMIT 1
131 Query SELECT slug.SLUG
FROM slug
WHERE NULL = slug.OBJECT_ID
131 Query SELECT setting.NAME, setting.SCOPE, setting.EDITABLE, setting.DELETEABLE, setting.SOURCE_CULTURE, setting.ID, setting.SERIAL_NUMBER FROM `setting` WHERE setting.NAME='slug_basis_informationobject' LIMIT 1
131 Query SELECT setting_i18n.VALUE, setting_i18n.ID, setting_i18n.CULTURE FROM `setting_i18n` WHERE setting_i18n.ID='133'
131 Query SELECT COUNT(*) FROM `information_object`, `object` WHERE information_object.ID='1' AND information_object.ID=object.ID
131 Query SELECT object.CLASS_NAME, object.CREATED_AT, object.UPDATED_AT, object.ID, object.SERIAL_NUMBER, information_object.ID, information_object.IDENTIFIER, information_object.OAI_LOCAL_IDENTIFIER, information_object.LEVEL_OF_DESCRIPTION_ID, information_object.COLLECTION_TYPE_ID, information_object.REPOSITORY_ID, information_object.PARENT_ID, information_object.DESCRIPTION_STATUS_ID, information_object.DESCRIPTION_DETAIL_ID, information_object.DESCRIPTION_IDENTIFIER, information_object.SOURCE_STANDARD, information_object.DISPLAY_STANDARD_ID, information_object.LFT, information_object.RGT, information_object.SOURCE_CULTURE FROM `object`, `information_object` WHERE information_object.ID='1' AND information_object.ID=object.ID
131 Query SELECT object.CLASS_NAME, object.CREATED_AT, object.UPDATED_AT, object.ID, object.SERIAL_NUMBER, information_object.ID, information_object.IDENTIFIER, information_object.OAI_LOCAL_IDENTIFIER, information_object.LEVEL_OF_DESCRIPTION_ID, information_object.COLLECTION_TYPE_ID, information_object.REPOSITORY_ID, information_object.PARENT_ID, information_object.DESCRIPTION_STATUS_ID, information_object.DESCRIPTION_DETAIL_ID, information_object.DESCRIPTION_IDENTIFIER, information_object.SOURCE_STANDARD, information_object.DISPLAY_STANDARD_ID, information_object.LFT, information_object.RGT, information_object.SOURCE_CULTURE FROM `object`, `information_object` WHERE object.ID='1' AND information_object.ID=object.ID
131 Query UPDATE information_object
SET information_object.LFT = information_object.LFT + '2'
WHERE information_object.LFT >= '962'
131 Query rollback
131 Quit
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment