Last active
March 1, 2016 00:48
-
-
Save jraddaoui/dd0493e118758fe6d7e7 to your computer and use it in GitHub Desktop.
IO creation with fix. Manually throwing exception, fatal error or timing out in the middle of the nested set update.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 104 Connect root@localhost on atom_2 | |
| 104 Query SET NAMES 'utf8' | |
| 104 Query SELECT COUNT(*) FROM `setting` WHERE setting.NAME='plugins' | |
| 104 Query SELECT setting.NAME, setting.SCOPE, setting.EDITABLE, setting.DELETEABLE, setting.SOURCE_CULTURE, setting.ID, setting.SERIAL_NUMBER FROM `setting` WHERE setting.NAME='plugins' | |
| 104 Query SELECT setting_i18n.VALUE, setting_i18n.ID, setting_i18n.CULTURE FROM `setting_i18n` WHERE setting_i18n.ID='1' | |
| 104 Query SELECT value | |
| FROM setting JOIN setting_i18n ON setting.id = setting_i18n.id | |
| WHERE scope = "default_template" AND name = 'informationobject' | |
| 104 Query SELECT COUNT(*) FROM `user`, `actor`, `object` WHERE user.ID='115215' AND actor.ID=object.ID AND user.ID=actor.ID | |
| 104 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 | |
| 104 Query START TRANSACTION | |
| 104 Query SELECT COUNT(*) FROM `information_object`, `object` WHERE information_object.ID=1 AND information_object.ID=object.ID | |
| 104 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 | |
| 104 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' | |
| 104 Query SELECT slug.SLUG | |
| FROM slug | |
| WHERE '1' = slug.OBJECT_ID | |
| 104 Query SELECT COUNT(*) FROM `acl_group` WHERE acl_group.ID=99 | |
| 104 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 | |
| 104 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' | |
| 104 Query SELECT COUNT(*) FROM `acl_user_group` WHERE acl_user_group.USER_ID='115215' | |
| 104 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' | |
| 104 Query SELECT COUNT(*) FROM `acl_group` WHERE acl_group.ID='100' | |
| 104 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' | |
| 104 Query SELECT COUNT(*) FROM `acl_group` WHERE acl_group.ID='99' | |
| 104 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' | |
| 104 Query SELECT COUNT(*) FROM `information_object`, `object` WHERE information_object.LFT<'1' AND information_object.RGT>'958' AND information_object.ID=object.ID | |
| 104 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>'958' AND information_object.ID=object.ID ORDER BY information_object.LFT ASC,information_object.LFT ASC | |
| 104 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 )) | |
| 104 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 )) | |
| 104 Query SELECT COUNT(*) FROM `term`, `object` WHERE term.ID=111 AND term.ID=object.ID | |
| 104 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 | |
| 104 Query SELECT COUNT(*) FROM `term`, `object` WHERE term.ID=118 AND term.ID=object.ID | |
| 104 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 | |
| 104 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='111' | |
| 104 Query SELECT slug.SLUG | |
| FROM slug | |
| WHERE '111' = slug.OBJECT_ID | |
| 104 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='118' | |
| 104 Query SELECT slug.SLUG | |
| FROM slug | |
| WHERE '118' = slug.OBJECT_ID | |
| 104 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 | |
| 104 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 | |
| 104 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 | |
| 104 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 | |
| 104 Query SELECT COUNT(*) FROM `term`, `object` WHERE term.ID IS NULL AND term.ID=object.ID | |
| 104 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 | |
| 104 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='189' | |
| 104 Query SELECT slug.SLUG | |
| FROM slug | |
| WHERE '189' = slug.OBJECT_ID | |
| 104 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='190' | |
| 104 Query SELECT slug.SLUG | |
| FROM slug | |
| WHERE '190' = slug.OBJECT_ID | |
| 104 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='191' | |
| 104 Query SELECT slug.SLUG | |
| FROM slug | |
| WHERE '191' = slug.OBJECT_ID | |
| 104 Query SELECT COUNT(*) FROM `property` WHERE property.OBJECT_ID IS NULL AND property.NAME='language' | |
| 104 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 | |
| 104 Query SELECT COUNT(*) FROM `property` WHERE property.OBJECT_ID IS NULL AND property.NAME='languageOfDescription' | |
| 104 Query SELECT COUNT(*) FROM `term`, `object` WHERE term.ID IS NULL AND term.ID=object.ID | |
| 104 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 | |
| 104 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='194' | |
| 104 Query SELECT slug.SLUG | |
| FROM slug | |
| WHERE '194' = slug.OBJECT_ID | |
| 104 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='197' | |
| 104 Query SELECT slug.SLUG | |
| FROM slug | |
| WHERE '197' = slug.OBJECT_ID | |
| 104 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='192' | |
| 104 Query SELECT slug.SLUG | |
| FROM slug | |
| WHERE '192' = slug.OBJECT_ID | |
| 104 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='198' | |
| 104 Query SELECT slug.SLUG | |
| FROM slug | |
| WHERE '198' = slug.OBJECT_ID | |
| 104 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='2000004' | |
| 104 Query SELECT slug.SLUG | |
| FROM slug | |
| WHERE '2000004' = slug.OBJECT_ID | |
| 104 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='69884' | |
| 104 Query SELECT slug.SLUG | |
| FROM slug | |
| WHERE '69884' = slug.OBJECT_ID | |
| 104 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='195' | |
| 104 Query SELECT slug.SLUG | |
| FROM slug | |
| WHERE '195' = slug.OBJECT_ID | |
| 104 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='193' | |
| 104 Query SELECT slug.SLUG | |
| FROM slug | |
| WHERE '193' = slug.OBJECT_ID | |
| 104 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='196' | |
| 104 Query SELECT slug.SLUG | |
| FROM slug | |
| WHERE '196' = slug.OBJECT_ID | |
| 104 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 | |
| 104 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 | |
| 104 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 | |
| 104 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 | |
| 104 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 | |
| 104 Query SELECT COUNT(*) FROM `repository`, `actor`, `object` WHERE repository.ID IS NULL AND actor.ID=object.ID AND repository.ID=actor.ID | |
| 104 Query SELECT COUNT(*) FROM `property` WHERE property.OBJECT_ID IS NULL AND property.NAME='scriptOfDescription' | |
| 104 Query SELECT COUNT(*) FROM `property` WHERE property.OBJECT_ID IS NULL AND property.NAME='script' | |
| 104 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 | |
| 104 Query SELECT COUNT(*) FROM `term`, `object` WHERE term.ID IS NULL AND term.ID=object.ID | |
| 104 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 | |
| 104 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='186' | |
| 104 Query SELECT slug.SLUG | |
| FROM slug | |
| WHERE '186' = slug.OBJECT_ID | |
| 104 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='187' | |
| 104 Query SELECT slug.SLUG | |
| FROM slug | |
| WHERE '187' = slug.OBJECT_ID | |
| 104 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='188' | |
| 104 Query SELECT slug.SLUG | |
| FROM slug | |
| WHERE '188' = slug.OBJECT_ID | |
| 104 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 | |
| 104 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' | |
| 104 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 | |
| 104 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 | |
| 104 Query SELECT value | |
| FROM setting JOIN setting_i18n ON setting.id = setting_i18n.id | |
| WHERE scope = "default_template" AND name = 'informationobject' | |
| 104 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' | |
| 104 Query SELECT COUNT(*) FROM `property` WHERE property.OBJECT_ID IS NULL AND property.NAME='language' | |
| 104 Query SELECT COUNT(*) FROM `property` WHERE property.OBJECT_ID IS NULL AND property.NAME='languageOfDescription' | |
| 104 Query SELECT object.CLASS_NAME, object.CREATED_AT, object.UPDATED_AT, object.ID, object.SERIAL_NUMBER FROM `object`, `slug` WHERE slug.SLUG='record-group' AND slug.OBJECT_ID=object.ID | |
| 104 Query SELECT COUNT(*) FROM `property` WHERE property.OBJECT_ID IS NULL AND property.NAME='scriptOfDescription' | |
| 104 Query SELECT COUNT(*) FROM `property` WHERE property.OBJECT_ID IS NULL AND property.NAME='script' | |
| 104 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 | |
| 104 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 | |
| 104 Query SELECT slug.SLUG | |
| FROM slug | |
| WHERE NULL = slug.OBJECT_ID | |
| 104 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 | |
| 104 Query SELECT setting_i18n.VALUE, setting_i18n.ID, setting_i18n.CULTURE FROM `setting_i18n` WHERE setting_i18n.ID='133' | |
| 104 Query SELECT COUNT(*) FROM `information_object`, `object` WHERE information_object.ID='1' AND information_object.ID=object.ID | |
| 104 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 | |
| 104 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 | |
| 104 Query UPDATE information_object | |
| SET information_object.LFT = information_object.LFT + '2' | |
| WHERE information_object.LFT >= '958' | |
| 104 Query rollback | |
| 104 Quit |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment