OW Debug - Exception
Message: SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' File: /home3/monacowe/public_html/socialenjoy.com/ow_core/database.php Line: 331 Trace: #0 /home3/monacowe/public_html/socialenjoy.com/ow_core/database.php(331): PDOStatement->execute() #1 /home3/monacowe/public_html/socialenjoy.com/ow_core/database.php(498): OW_Database->execute(' SELECT DISTINC...', Array) #2 /home3/monacowe/public_html/socialenjoy.com/ow_system_plugins/base/bol/question_dao.php(314): OW_Database->queryForList(' SELECT DISTINC...', Array) #3 /home3/monacowe/public_html/socialenjoy.com/ow_system_plugins/base/bol/question_service.php(617): BOL_QuestionDao->findRequiredQuestionsForAccountType('290365aadde35a9...') #4 /home3/monacowe/public_html/socialenjoy.com/ow_system_plugins/base/bol/question_service.php(2232): BOL_QuestionService->findRequiredQuestionsForAccountType('290365aadde35a9...') #5 /home3/monacowe/public_html/socialenjoy.com/ow_system_plugins/base/classes/event_handler.php(235): BOL_QuestionService->getEmptyRequiredQuestionsList(1) #6 /home3/monacowe/public_html/socialenjoy.com/ow_core/event_manager.php(197): BASE_CLASS_EventHandler->onPluginsInitCheckUserStatus(Object(OW_Event)) #7 /home3/monacowe/public_html/socialenjoy.com/index.php(63): OW_EventManager->trigger(Array, Object(OW_Event)) #8 {main} Type: PDOExceptionWe build. You grow.
Get best community software hereStart a social network, a fan-site, an education project with oxwall - free opensource community software
after update can anyone help please [Solved] | Forum
bobby
Jul 10 '14
i just update core and plugins and themes now i get
The Forum post is edited by ross Jul 21 '14
Team
Team ross
Jul 11 '14
bobby, you need to locate a table which has different collation rather than utf8_general_ci, open it, then click on the Structure, you will see the third row for that table named Collation you will need to change it. Click on each row Change button and choose the utf8_general_ci collation in the drop down menu then save.
Team ross
Jul 11 '14
check the structure of ow_base_question_to_account_type table the rows are not general_ci
Pete
Jul 11 '14
Try this bobbi
there is an easier way to correct the collation of all tables:
Create a new php file on the server with the following and then run it:
<?php
$db = mysql_connect('localhost','myuser_mydbuser','mypassword');
if(!$db) echo "Cannot connect to the database - incorrect details";
mysql_select_db('myuser_mydbname'); $result=mysql_query('show tables');
while($tables = mysql_fetch_array($result)) {
foreach ($tables as $key => $value) {
mysql_query("ALTER TABLE $valueCOLLATE utf8_general_ci");
}}
echo "The collation of your database has been successfully changed!";
?>
Make sure to substitute in the above script:
- myuser_mydbname with your database name;
- myuser_mydbuser with your mysql username;
- mypassword with your password for the mysql user;
The Forum post is edited by Pete Jul 11 '14
Pete
Jul 12 '14
At least you can get your site back on now ,you might be better off asking oxwall how to fix this error in photos that you posted,cause I don't have a clue,it must be just something simple because my host only took about 5 mins to fix mine .
The Forum post is edited by Pete Jul 12 '14
Pete
Jul 12 '14
Your hosting account doesn't meet the following requirements:
- register_globals must be off (currently on) .
