alva
Total posts: 58
21 Apr 2015 15:41

Пытаюсь изменить разделы вылазит ошибка ``` 1267 Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' SQL=SELECT a.id, a.title, a.alias, a.note, a.published, a.access, a.checked_out, a.checked_out_time, a.created_user_id, a.path, a.parent_id, a.level, a.lft, a.rgt, a.language, a.params,l.title AS language_title,uc.name AS editor,ag.title AS access_level,ua.name AS author_name FROM bsvnj_js_res_categories AS a LEFT JOIN bsvnj_languages AS l ON l.lang_code = a.language LEFT JOIN bsvnj_users AS uc ON uc.id=a.checked_out LEFT JOIN bsvnj_viewlevels AS ag ON ag.id = a.access LEFT JOIN bsvnj_users AS ua ON ua.id = a.created_user_id WHERE a.section_id = 1 AND (a.published IN (0, 1)) ORDER BY a.lft asc LIMIT 0, 20

```

Last Modified: 12 May 2015


Sergey
Total posts: 13,748
23 Apr 2015 03:17

Проверте collation в таблице языков какой?


alva
Total posts: 58
27 Apr 2015 16:28

Screenshot_1

collation это что? где смотреть?


alva
Total posts: 58
27 Apr 2015 16:31

Screenshot_2


Sergey
Total posts: 13,748
28 Apr 2015 04:55

Нужно не в данных а в структуре таблици смотреть.


alva
Total posts: 58
09 May 2015 01:44

в структуре не нашел


Sergey
Total posts: 13,748
12 May 2015 11:25

Где то тут

2015-05-12_17-16-19

Powered by Cobalt