Jump to content
Дизайн и модификация IPS Community IPBSkinsBETA
Search In
  • More options...
Find results that contain...
Find results in...
Sign in to follow this  
Kos9078

Ошибка БД при внешней авторизации

Recommended Posts

код ошибки:

mySQL query error: SELECT * FROM dle__users WHERE name='тест' 

SQL error: Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation '='
SQL error code: 1267
Date: Friday 20th of August 2010 09:44:19 AM

 

IPB 3.1

Share this post


Link to post
Share on other sites

Смесь кодировок. Проверьте таблицы с dle__users

Наверное все надо к utf-8 приводить

Share this post


Link to post
Share on other sites

IPB 3.1

В какой кодировки стоит база данных форума. cp1251 или latin1

Share this post


Link to post
Share on other sites

сайт: cp1251_general_ci

форум: utf8_general_ci

 

P.S. сайт отказывается работать с таблицами в UTF-8

Edited by Kos9078

Share this post


Link to post
Share on other sites

сайт: cp1251_general_ci

форум: utf8_general_ci

ОК. Надо смотреть. А сама база данных в latin1_swedish_ci?

Share this post


Link to post
Share on other sites

MySQL-кодировка: UTF-8 Unicode (utf8)

Share this post


Link to post
Share on other sites

MySQL-кодировка: UTF-8 Unicode (utf8)

collation какой? general_ci?

Share this post


Link to post
Share on other sites

узнал у владельца сервера, что в настройках мускула по дефолту latin1_swedish_ci.

были ошибки с кодировкой отображения форума и сделал .htaccess с:

php_value mbstring.http_input pass
php_value mbstring.http_output pass
php_value mbstring.encoding_translation 0
php_value default_charset "UTF-8"
php_value mbstring.internal_encoding UTF-8
php_value mbstring.language Russian
AddDefaultCharset UTF-8

Edited by Kos9078

Share this post


Link to post
Share on other sites

latin1_swedish_ci.

Вы же сами написали причину.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...