DB Error reading issues (Illegal mix of collations)

[Marc]

Hi all!

I'm newer with OJS 2.0.
After install it with any problem and configure it I've started trying to publish a new issue (all it's a test...)
After upload two files, done a new issue and publish it I've tried to see the current issue as a reader. But each time I try to read the last issue this error appears:

DB Error: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='

If I'm logged as administrator, editor,... the error also appears.

Somebody know why this query between different codifications (latin1_swedish_ci & utf8_general_ci)??

I attach my system information at the end of this mail.

Thanks a lot!

Marc

System Information
OJS Version
Current version

2.0.0.0 (July 8, 2005 - 08:24 AM)
Version history

Version Major Minor Revision Build Date installed

2.0.0.0 2 0 0 0 2005-07-08

OJS Configuration
Edit

OJS configuration settings from config.inc.php.
general
installed On
registry_dir registry
session_cookie_name OJSSID
session_lifetime 30
scheduled_tasks Off
date_format_trunc %m-%d
date_format_short %Y-%m-%d
date_format_long %B %e, %Y
datetime_format_short %Y-%m-%d %I:%M %p
datetime_format_long %B %e, %Y - %I:%M %p
email
allow_envelope_sender Off
database
driver mysql
host localhost
username ******
password ******
name ojs
pconnect On
debug Off
i18n
locale en_US
client_charset utf-8
connection_charset utf8
database_charset utf8
files
files_dir /tmp
public_files_dir public
security
force_ssl Off
force_login_ssl Off
session_check_ip On
encryption md5
dir_perm 493
search
min_word_length 3
results_per_keyword 500
result_cache_hours 1
oai
oai On
repository_id ******
interface
items_per_page 25
page_links 10
debug
show_stats Off
Server Information

Basic operating system and server software versions. Click on Extended PHP Information to view extended details of this server's PHP configuration.
OS platform Linux
PHP version 5.0.4
Apache version Apache/1.3.33 (Unix) PHP/5.0.4
Database driver mysql
Database server version 4.1.11-standard
Extended PHP Information

[kevin]

This issue was fixed in OJS 2.0.1.

See the note on this bug report to fix an existing OJS 2.0 installation.

[soj]

I'm getting the same error even though I have upgraded. However some major environmental changes have occurred because I'm in the process of migrating the entire site to a new server.

The previous DB Language is listed as english (en-iso-8859-1) in MySQL 4.0.27.

The new environment is MySQL 4.1.12 with a language of English (en-utf-8).
Additional parameters are
MySQL charset: UTF-8 Unicode (utf8) and
MySQL connection collation: uft_general_ci.
PHP_VERSION 4.3.9

Which of these solutions would you recommend, or is there another?

Solutions for existing installations:

1) If UTF-8 database support is not needed, change "connection_charset" and
"database_charset" from "utf8" to "Off" in config.inc.php

2) If UTF-8 database support is needed, alter the database tables to UTF-8:

ALTER DATABASE my_database DEFAULT CHARACTER SET 'utf8';
ALTER TABLE articles CONVERT TO CHARACTER SET 'utf8';
...etc. (altering each table)

TIA yet again

soj

[asmecher]

Hi Soj,

The best solution is full UTF-8 support; you'll probably be best off converting your database to UTF8. Of course, please do a full backup beforehand. If possible, please post back here once you've run through the conversion process; your experience will be valuable to other users who have undertaken the same sort of conversion.

Regards,
Alec Smecher
Open Journal Systems Team
---
Don't miss the First International PKP Scholarly Publishing Conference
July 11 - 13, 2007, Vancouver, BC, Canada
http://ocs.sfu.ca/pkp2007/

[soj]

Bingo - I believe that worked perfectly! I opened phpMyAdmin and entered the following SQL command (provided in full to save the next guy some typing) and now my articles are accessible.

ALTER DATABASE your_database DEFAULT CHARACTER SET 'utf8';
ALTER TABLE access_keys CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE announcements CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE announcement_types CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE articles CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE article_authors CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE article_comments CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE article_email_log CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE article_event_log CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE article_files CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE article_galleys CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE article_html_galley_images CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE article_notes CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE article_search_keyword_list CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE article_search_objects CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE article_search_object_keywords CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE article_supplementary_files CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE auth_sources CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE comments CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE copyed_assignments CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE currencies CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE custom_section_orders CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE edit_assignments CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE edit_decisions CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE email_templates CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE email_templates_data CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE email_templates_default CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE email_templates_default_data CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE groups CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE group_memberships CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE issues CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE journals CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE journal_settings CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE layouted_assignments CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE notification_status CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE oai_resumption_tokens CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE plugin_settings CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE proof_assignments CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE published_articles CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE review_assignments CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE review_rounds CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE roles CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE rt_contexts CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE rt_searches CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE rt_versions CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE scheduled_tasks CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE sections CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE section_editors CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE sessions CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE site CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE subscriptions CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE subscription_types CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE temporary_files CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE theses CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE users CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE user_settings CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE versions CONVERT TO CHARACTER SET 'utf8';

[jfreyes]

Wow! This is an old post, but it worked great for me too! I can access now those links that weren't working
Thx guys!

And, here are my SQL commands for the next guy (OJS 2.3.6.0)... just to save some time too!

Code: Select all

ALTER DATABASE your_database DEFAULT CHARACTER SET 'utf8';
ALTER TABLE access_keys CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE announcements CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE announcement_settings CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE announcement_types CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE announcement_type_settings CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE articles CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE article_author_settings CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE article_comments CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE article_email_log CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE article_event_log CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE article_files CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE article_galleys CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE article_html_galley_images CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE article_notes CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE article_search_keyword_list CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE article_search_objects CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE article_search_object_keywords CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE article_settings CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE article_supplementary_files CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE article_supp_file_settings CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE article_xml_galleys CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE authors CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE author_settings CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE auth_sources CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE books_for_review CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE books_for_review_authors CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE books_for_review_settings CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE captchas CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE citations CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE citation_settings CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE comments CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE completed_payments CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE controlled_vocabs CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE controlled_vocab_entries CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE controlled_vocab_entry_settings CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE counter_monthly_log CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE custom_issue_orders CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE custom_section_orders CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE edit_assignments CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE edit_decisions CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE email_templates CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE email_templates_data CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE email_templates_default CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE email_templates_default_data CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE external_feeds CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE external_feed_settings CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE filters CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE filter_settings CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE groups CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE group_memberships CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE group_settings CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE institutional_subscriptions CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE institutional_subscription_ip CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE issues CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE issue_settings CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE journals CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE journal_settings CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE metadata_descriptions CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE metadata_description_settings CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE notes CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE notifications CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE notification_settings CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE oai_resumption_tokens CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE paypal_transactions CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE plugin_settings CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE processes CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE published_articles CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE queued_payments CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE referrals CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE referral_settings CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE review_assignments CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE review_forms CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE review_form_elements CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE review_form_element_settings CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE review_form_responses CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE review_form_settings CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE review_rounds CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE roles CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE rt_contexts CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE rt_searches CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE rt_versions CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE scheduled_tasks CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE sections CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE section_editors CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE section_settings CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE sessions CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE signoffs CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE site CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE site_settings CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE static_pages CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE static_page_settings CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE subscriptions CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE subscription_types CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE subscription_type_settings CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE temporary_files CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE theses CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE users CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE user_settings CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE versions CONVERT TO CHARACTER SET 'utf8';

[mendesrocha]

And here are the SQL entry for OCS 2.3.x

Code: Select all

ALTER DATABASE your_ocs_database DEFAULT CHARACTER SET 'utf8';
ALTER TABLE access_keys CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE announcements CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE announcement_settings CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE announcement_types CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE announcement_type_settings CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE auth_sources CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE buildings CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE building_settings CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE captchas CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE comments CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE conferences CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE conference_event_log CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE conference_settings CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE controlled_vocabs CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE controlled_vocab_entries CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE controlled_vocab_entry_settings CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE custom_track_orders CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE edit_assignments CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE edit_decisions CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE email_templates CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE email_template_data CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE email_template_default CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE email_template_default_data CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE groups CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE group_memberships CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE group_settings CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE notifications CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE notification_settings CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE notification_status CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE oai_resumption_tokens CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE papers CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE paper_authors CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE paper_author_settings CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE paper_comments CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE paper_email_log CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE paper_event_log CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE paper_files CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE paper_galleys CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE paper_html_galley_images CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE paper_notes CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE paper_presenters CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE paper_presenter_settings CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE paper_search_keyword_list CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE paper_search_objects CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE paper_search_object_keywords CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE paper_settings CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE paper_supplementary_files CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE paper_supp_file_settings CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE paypal_transactions CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE plugin_settings CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE published_papers CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE queued_payments CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE registrations CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE registration_options CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE registration_option_assoc CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE registration_option_costs CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE registration_option_settings CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE registration_types CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE registration_type_settings CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE review_assignments CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE review_forms CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE review_form_elements CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE review_form_element_settings CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE review_form_responses CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE review_form_settings CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE review_stages CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE roles CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE rooms CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE room_settings CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE rt_contexts CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE rt_searches CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE rt_versions CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE scheduled_tasks CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE sched_confs CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE sched_conf_settings CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE sessions CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE site CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE site_settings CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE special_events CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE special_event_settings CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE static_pages CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE static_page_settings CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE temporary_files CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE time_blocks CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE time_block_settings CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE tracks CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE track_directors CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE track_settings CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE users CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE user_settings CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE versions CONVERT TO CHARACTER SET 'utf8';


[fstuck]

And here are the SQL entry for OCS 2.4.2.0

Code: Select all

ALTER DATABASE ojs DEFAULT CHARACTER SET 'utf8';
ALTER TABLE    access_keys   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    announcements   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    announcement_settings   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    announcement_types   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    announcement_type_settings   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    articles   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    article_comments   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    article_files   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    article_galleys   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    article_galley_settings   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    article_html_galley_images   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    article_notes   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    article_search_keyword_list   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    article_search_objects   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    article_search_object_keywords   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    article_settings   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    article_supplementary_files   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    article_supp_file_settings   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    article_xml_galleys   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    authors   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    author_settings   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    auth_sources   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    books_for_review   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    books_for_review_authors   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    books_for_review_settings   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    captchas   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    citations   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    citation_settings   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    comments   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    completed_payments   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    controlled_vocabs   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    controlled_vocab_entries   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    controlled_vocab_entry_settings   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    counter_monthly_log   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    custom_issue_orders   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    custom_section_orders   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    data_object_tombstones   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    data_object_tombstone_oai_set_objects   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    data_object_tombstone_settings   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    edit_assignments   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    edit_decisions   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    email_log   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    email_log_users   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    email_templates   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    email_templates_data   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    email_templates_default   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    email_templates_default_data   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    event_log   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    event_log_settings   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    external_feeds   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    external_feed_settings   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    filters   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    filter_groups   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    filter_settings   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    gifts   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    groups   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    group_memberships   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    group_settings   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    institutional_subscriptions   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    institutional_subscription_ip   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    issues   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    issue_files   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    issue_galleys   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    issue_galley_settings   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    issue_settings   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    journals   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    journal_settings   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    metadata_descriptions   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    metadata_description_settings   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    mutex   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    notes   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    notifications   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    notification_mail_list   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    notification_settings   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    notification_subscription_settings   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    oai_resumption_tokens   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    paypal_transactions   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    plugin_settings   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    processes   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    published_articles   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    queued_payments   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    referrals   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    referral_settings   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    review_assignments   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    review_forms   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    review_form_elements   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    review_form_element_settings   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    review_form_responses   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    review_form_settings   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    review_rounds   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    roles   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    rt_contexts   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    rt_searches   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    rt_versions   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    scheduled_tasks   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    sections   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    section_editors   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    section_settings   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    sessions   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    signoffs   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    site   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    site_settings   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    static_pages   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    static_page_settings   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    subscriptions   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    subscription_types   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    subscription_type_settings   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    temporary_files   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    theses   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    timed_views_log   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    users   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    user_interests   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    user_settings   CONVERT TO CHARACTER SET 'utf8';
ALTER TABLE    versions   CONVERT TO CHARACTER SET 'utf8';