Skip to content

Instantly share code, notes, and snippets.

@jraddaoui

jraddaoui/gist:7c6200c5be86f5ccb9b8

Last active February 29, 2016 22:22
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 jraddaoui/7c6200c5be86f5ccb9b8 to your computer and use it in GitHub Desktop.
Save jraddaoui/7c6200c5be86f5ccb9b8 to your computer and use it in GitHub Desktop.
Download ZIP
Accession creation without fix.
Raw
gistfile1.txt
92 Connect root@localhost on atom_2
92 Query SET NAMES 'utf8'
92 Query SELECT COUNT(*) FROM `setting` WHERE setting.NAME='plugins'
92 Query SELECT setting.NAME, setting.SCOPE, setting.EDITABLE, setting.DELETEABLE, setting.SOURCE_CULTURE, setting.ID, setting.SERIAL_NUMBER FROM `setting` WHERE setting.NAME='plugins'
92 Query SELECT setting_i18n.VALUE, setting_i18n.ID, setting_i18n.CULTURE FROM `setting_i18n` WHERE setting_i18n.ID='1'
92 Query SELECT COUNT(*) FROM `user`, `actor`, `object` WHERE user.ID='115215' AND actor.ID=object.ID AND user.ID=actor.ID
92 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
92 Query SELECT COUNT(*) FROM `term`, `object` WHERE term.ID=169 AND term.ID=object.ID
92 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=169 AND term.ID=object.ID
92 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='169'
92 Query SELECT slug.SLUG
FROM slug
WHERE '169' = slug.OBJECT_ID
92 Query SELECT slug.SLUG
FROM slug
WHERE NULL = slug.OBJECT_ID
92 Query SELECT COUNT(*) FROM `term`, `object` WHERE term.ID=111 AND term.ID=object.ID
92 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
92 Query SELECT COUNT(*) FROM `term`, `object` WHERE term.ID=118 AND term.ID=object.ID
92 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
92 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='111'
92 Query SELECT slug.SLUG
FROM slug
WHERE '111' = slug.OBJECT_ID
92 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='118'
92 Query SELECT slug.SLUG
FROM slug
WHERE '118' = slug.OBJECT_ID
92 Query SELECT COUNT(*) FROM `term`, `object` WHERE term.ID IS NULL AND term.ID=object.ID
92 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=63 AND term.ID=object.ID
92 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='287'
92 Query SELECT slug.SLUG
FROM slug
WHERE '287' = slug.OBJECT_ID
92 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='288'
92 Query SELECT slug.SLUG
FROM slug
WHERE '288' = slug.OBJECT_ID
92 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='289'
92 Query SELECT slug.SLUG
FROM slug
WHERE '289' = slug.OBJECT_ID
92 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='290'
92 Query SELECT slug.SLUG
FROM slug
WHERE '290' = slug.OBJECT_ID
92 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=111 AND relation.ID=object.ID
92 Query SELECT setting.NAME, setting.SCOPE, setting.EDITABLE, setting.DELETEABLE, setting.SOURCE_CULTURE, setting.ID, setting.SERIAL_NUMBER FROM `setting` WHERE setting.NAME='accession_counter' LIMIT 1
92 Query SELECT setting_i18n.VALUE, setting_i18n.ID, setting_i18n.CULTURE FROM `setting_i18n` WHERE setting_i18n.ID='43'
92 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=167 AND relation.ID=object.ID
92 Query SELECT COUNT(*) FROM `term`, `object` WHERE term.ID IS NULL AND term.ID=object.ID
92 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=62 AND term.ID=object.ID
92 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='285'
92 Query SELECT slug.SLUG
FROM slug
WHERE '285' = slug.OBJECT_ID
92 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='286'
92 Query SELECT slug.SLUG
FROM slug
WHERE '286' = slug.OBJECT_ID
92 Query SELECT COUNT(*) FROM `term`, `object` WHERE term.ID IS NULL AND term.ID=object.ID
92 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=64 AND term.ID=object.ID
92 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='291'
92 Query SELECT slug.SLUG
FROM slug
WHERE '291' = slug.OBJECT_ID
92 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='292'
92 Query SELECT slug.SLUG
FROM slug
WHERE '292' = slug.OBJECT_ID
92 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='293'
92 Query SELECT slug.SLUG
FROM slug
WHERE '293' = slug.OBJECT_ID
92 Query SELECT COUNT(*) FROM `term`, `object` WHERE term.ID IS NULL AND term.ID=object.ID
92 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=65 AND term.ID=object.ID
92 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='294'
92 Query SELECT slug.SLUG
FROM slug
WHERE '294' = slug.OBJECT_ID
92 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='295'
92 Query SELECT slug.SLUG
FROM slug
WHERE '295' = slug.OBJECT_ID
92 Query SELECT term_i18n.NAME, term_i18n.ID, term_i18n.CULTURE FROM `term_i18n` WHERE term_i18n.ID='296'
92 Query SELECT slug.SLUG
FROM slug
WHERE '296' = slug.OBJECT_ID
92 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
92 Query START TRANSACTION
92 Query SELECT setting.NAME, setting.SCOPE, setting.EDITABLE, setting.DELETEABLE, setting.SOURCE_CULTURE, setting.ID, setting.SERIAL_NUMBER FROM `setting` WHERE setting.NAME='accession_counter' LIMIT 1
92 Query UPDATE setting_i18n SET `VALUE`='8', `ID`='43' WHERE setting_i18n.ID='43' AND setting_i18n.CULTURE='en'
92 Query commit
92 Query INSERT INTO object (`CLASS_NAME`,`CREATED_AT`,`UPDATED_AT`) VALUES ('QubitAccession','2016-02-29 13:39:04','2016-02-29 13:39:04')
92 Query INSERT INTO accession (`ID`,`DATE`,`IDENTIFIER`,`CREATED_AT`,`UPDATED_AT`,`SOURCE_CULTURE`) VALUES ('2001245','2016-02-29','2016-02-29/8','2016-02-29 13:39:04','2016-02-29 13:39:04','en')
92 Query INSERT INTO slug (slug.OBJECT_ID, slug.SLUG)
VALUES ('2001245', '2016-02-29-8')
92 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` WHERE object_term_relation.OBJECT_ID='2001245' AND object_term_relation.ID=object.ID
92 Query SELECT note.OBJECT_ID, note.TYPE_ID, note.SCOPE, note.USER_ID, note.SOURCE_CULTURE, note.ID, note.SERIAL_NUMBER FROM `note` WHERE note.OBJECT_ID='2001245'
92 Query SELECT property.OBJECT_ID, property.SCOPE, property.NAME, property.SOURCE_CULTURE, property.ID, property.SERIAL_NUMBER FROM `property` WHERE property.OBJECT_ID='2001245'
92 Query SELECT other_name.OBJECT_ID, other_name.TYPE_ID, other_name.START_DATE, other_name.END_DATE, other_name.SOURCE_CULTURE, other_name.ID, other_name.SERIAL_NUMBER FROM `other_name` WHERE other_name.OBJECT_ID='2001245'
92 Query INSERT INTO accession_i18n (`LOCATION_INFORMATION`,`SOURCE_OF_ACQUISITION`,`ID`,`CULTURE`) VALUES ('test','test','2001245','en')
92 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='2001245' AND event.ID=object.ID
92 Query SELECT slug.SLUG
FROM slug
WHERE '2001245' = slug.OBJECT_ID
92 Query SELECT setting.NAME, setting.SCOPE, setting.EDITABLE, setting.DELETEABLE, setting.SOURCE_CULTURE, setting.ID, setting.SERIAL_NUMBER FROM `setting` WHERE setting.SCOPE='i18n_languages'
92 Query SELECT setting_i18n.VALUE, setting_i18n.ID, setting_i18n.CULTURE FROM `setting_i18n` WHERE setting_i18n.ID='27'
92 Query SELECT setting_i18n.VALUE, setting_i18n.ID, setting_i18n.CULTURE FROM `setting_i18n` WHERE setting_i18n.ID='28'
92 Query SELECT setting_i18n.VALUE, setting_i18n.ID, setting_i18n.CULTURE FROM `setting_i18n` WHERE setting_i18n.ID='29'
92 Query SELECT setting_i18n.VALUE, setting_i18n.ID, setting_i18n.CULTURE FROM `setting_i18n` WHERE setting_i18n.ID='30'
92 Query SELECT setting_i18n.VALUE, setting_i18n.ID, setting_i18n.CULTURE FROM `setting_i18n` WHERE setting_i18n.ID='31'
92 Query SELECT * FROM accession_i18n WHERE id = '2001245' ORDER BY culture ASC
92 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='2001245' AND relation.TYPE_ID=169 AND relation.ID=object.ID
92 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='2001245' AND relation.TYPE_ID=111 AND relation.ID=object.ID
92 Quit
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment