Posted 16 декабря, 201311 yr Здравствуйте! возникла такая проблема на 8 или 9 шаге установки 3.4.6 IPB. There appears to be an error with the database. mySQL query error: SELECT id FROM faq WHERE app='core' AND title = 'ПоиÑк' SQL error: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' SQL error code: 1267 Date: Monday 16th December 2013 07:18:47 PM ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Date: Mon, 16 Dec 2013 19:18:47 +0000 Error: 1267 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' IP Address: 127.0.0.1 - /forum/admin/install/index.php?app=install§ion=install&do=acphelp ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- mySQL query error: SELECT id FROM faq WHERE app='core' AND title = 'ПоиÑк' .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------. | File | Function | Line No. | |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------| | admin/setup/applications/install/sections/install.php | [admin_core_tools_help].helpFilesXMLImport_app | 1481 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admin/setup/applications/install/sections/install.php | [install_install].install_acphelp | 139 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admin/setup/sources/base/ipsController_setup.php | [install_install].doExecute | 258 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' Подскажите что делать? заранее всем спасибо!
17 декабря, 201311 yr SQL error: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' База должна быть в кодировке utf8_general_ci
17 декабря, 201311 yr Author SQL error: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' База должна быть в кодировке utf8_general_ci А как ее поменять? точнее где именно?
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.