While waiting for a response, I decided to try a manual way of transferring and entity of the database one by one by its table structure because the upgrade CLI and other methods did not proceed due to a database error. See below for the error from converting the database script.
UNKNOWN COLUMN Problem:
1. INSERT INTO authors (author_id, submission_id, seq, email, user_group_id, include_in_browse, publication_id) VALUES(1, 1, 1, ‘genarojapos@gmail.com’, 14, 1, 1);
MySQL said:
ERROR: #1054 - Unknown column ‘submission_id’ in ‘field list’
2. INSERT INTO author_settings (author_id, locale, setting_name, setting_value, setting_type) VALUES(1, ‘en_US’, ‘biography’, ‘’, ‘string’);
MySQL said:
ERROR: #1054 - Unknown column ‘setting_type’ in ‘field list’
3. INSERT INTO navigation_menu_items (navigation_menu_item_id, context_id, url, path, type) VALUES
(1, 16, NULL, NULL, ‘NMI_TYPE_USER_REGISTER’);
MySQL said:
ERROR: #1054 - Unknown column ‘url’ in ‘field list’
4. INSERT INTO publication_galleys (galley_id, locale, publication_id, label, file_id, seq, remote_url, is_approved, url_path) VALUES
(791, ‘en_US’, 20, ‘PDF’, 1258, 0, NULL, 1, NULL);
MySQL said:
ERRO: #1054 - Unknown column ‘file_id’ in ‘field list’
5. INSERT INTO review_round_files (submission_id, review_round_id, stage_id, file_id, revision) VALUES
(1, 1, 3, 2, 1);
MySQL said:
ERRO: #1054 - Unknown column ‘file_id’ in ‘field list’
6. INSERT INTO submissions (submission_id, locale, context_id, section_id, date_submitted, last_modified, status, submission_progress, stage_id, current_publication_id, date_last_activity, work_type) VALUES
(1, ‘en_US’, 9, 20, ‘2012-09-04 03:20:07’, ‘2014-09-27 06:55:44’, 3, 0, 4, 1, NULL, 0);
MySQL said:
ERRO: #1054 - Unknown column ‘section_id’ in ‘field list’
7. INSERT INTO submission_file_settings (file_id, locale, setting_name, setting_value, setting_type) VALUES
(2140, ‘en_US’, ‘name’, ‘FUNDAMENTAL SKILLS AND READINESS FOR COLLEGE ALGEBRA OF FIRST YEAR COLLEGE STUDENTS OF CAPIZ STATE UNIVERSITY, PONTEVEDRA CAMPUS, SY 2008-2009’, ‘string’),
(2140, ‘en_US’, ‘creator’, ‘Alex Buenafe’, ‘string’);
MySQL said:
ERRO: #1054 - Unknown column ‘file_id’ in ‘field list’
8. INSERT INTO submission_files (file_id, revision, source_file_id, source_revision, submission_id, file_type, file_size, original_file_name, file_stage, viewable, date_uploaded, date_modified, assoc_id, genre_id, direct_sales_price, sales_type, uploader_user_id, assoc_type) VALUES
(1, 1, NULL, NULL, 1, ‘application/pdf’, 502578, ‘321_342.pdf’, 2, 1, ‘2012-09-04 03:14:13’, ‘2012-09-04 03:14:13’, NULL, 1, NULL, NULL, 1, NULL);
MySQL said:
ERRO: #1054 - Unknown column ‘revision’ in ‘field list’
9. INSERT INTO submissions (submission_id, locale, context_id, section_id, date_submitted, last_modified, status, submission_progress, stage_id, current_publication_id, date_last_activity, work_type) VALUES
(1, ‘en_US’, 9, 20, ‘2012-09-04 03:20:07’, ‘2014-09-27 06:55:44’, 3, 0, 4, 1, NULL, 0);
MySQL said:
ERRO: #1054 - Unknown column ‘section_id’ in ‘field list’
on this error, I will double-check the \dbscripts\xml\upgrade. I will post again for any updates.
If everyone who knows this error problem kindly helps me to fix this error and share your knowledge.
Regards,
Darryl