problem with persian version
-
hello
we have problem with Persian version. when we make a quiz characters changed to ???s and we dont know how to fix it
we use enfold themeThe page I need help with: [log in to see the link]
-
It’s your DB charset issue. Show the database tables details from plugin’s “Support” page.
Technical details
Browser Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/72.0.3626.119 Safari/537.36
PHP version 7.1.26
PHP extensions bcmath, calendar, Core, ctype, curl, date, dom, exif, fileinfo, filter, ftp, gd, gettext, hash, iconv, imap, intl, ionCube Loader, json, libxml, litespeed, mbstring, mcrypt, mysqli, mysqlnd, openssl, pcre, PDO, pdo_mysql, pdo_sqlite, Phar, posix, Reflection, session, SimpleXML, soap, sockets, SourceGuardian, SPL, sqlite3, standard, timezonedb, tokenizer, wddx, xml, xmlreader, xmlrpc, xmlwriter, xsl, zip, zlib
PHP settings
disable_functions: show_source, system, shell_exec, passthru, exec, popen, proc_open, mailerror_log: error_log
error_reporting: 4983
log_errors: 1
max_execution_time: 3000
max_input_time: 6000
max_input_vars: 10000
memory_limit: 1280M
MySQL client version mysqlnd 5.0.12-dev – 20150407 – $Id: 38fea24f2847fa7519001be390c98ae0acafe387 $
MySQL server version 5.7.25
MySQL engines
YES: InnoDB, MRG_MYISAM, MEMORY, BLACKHOLE, CSV, ARCHIVE, PERFORMANCE_SCHEMADEFAULT: MyISAM
NO: FEDERATED
MySQL table status
MyISAM@10, utf8mb4_unicode_ci, Dynamic
wp_commentmeta: 0 rowswp_comments: 2 rows
wp_layerslider: 1 rows
wp_layerslider_revisions: 0 rows
wp_links: 0 rows
wp_options: 464 rows
wp_postmeta: 3641 rows
wp_posts: 1011 rows
wp_term_taxonomy: 36 rows
wp_termmeta: 0 rows
wp_terms: 36 rows
wp_usermeta: 110 rows
wp_users: 4 rows
MyISAM@10, latin1_swedish_ci, Dynamic
wp_duplicator_packages: 1 rowswp_t_answers: 134 rows
wp_t_computed_variables: 0 rows
wp_t_field_values: 0 rows
wp_t_fields: 0 rows
wp_t_formulas: 4 rows
wp_t_passings: 0 rows
wp_t_questions: 148 rows
wp_t_sections: 0 rows
MyISAM@10, latin1_swedish_ci, Fixed
wp_t_passing_answers: 0 rowswp_t_scores: 57 rows
MyISAM@10, utf8_general_ci, Dynamic
wp_t_schema_migrations: 36 rowsMyISAM@10, utf8mb4_unicode_ci, Fixed
wp_term_relationships: 39 rowsInnoDB@10, utf8_general_ci, Dynamic
wp_wp_quiz_emails: 0 rowswp_wp_quiz_fb_plays: 0 rows
wp_wp_quiz_fb_users: 0 rows
wp_wp_quiz_players: 0 rows
wp_wplc_chat_msgs: 31 rows
wp_wplc_chat_sessions: 11 rows
wp_wplc_offline_messages: 0 rows
wp_wplc_webhooks: 0 rows
MyISAM@10, utf8mb4_unicode_520_ci, Dynamic
wp_wp_quiz_play_data: 0 rowswp_yoast_seo_links: 217 rows
MyISAM@10, utf8mb4_unicode_520_ci, Fixed
wp_yoast_seo_meta: 239 rowsWordPress version 4.9.9
Plugins
Advanced noCaptcha & invisible Captcha: 4.2Async JavaScript: 2.18.12.10
Duplicator: 1.2.52
Easy WP SMTP: 1.3.8
HC Custom WP-Admin URL: 1.4
Interact Quiz Embed: 3.0.7
LayerSlider WP: 6.7.6
WordPress Font Uploader: 2.0
wp-jalali: 5.0.1
Wp-testing: 0.21.15
WP Colorbox: 1.1.2
WP Live Chat Support: 8.0.23
WP Quiz Pro: 1.2.21
Yoast SEO Premium: 9.3
What is in your config value for DB_CHARSET?
hi its latin1_swedish_ci and we find out that we should change it to utf8mb4_unicode_ci
are we most change all the settings for all plugin tables?Change it in config, unsinstall plugin then install again. It will remove all plugin’s tables and the recreate with correct encoding.
The topic ‘problem with persian version’ is closed to new replies.