IgorBeefeater

Подскажите, как сменить кодировку базы.

Проблема с mysql решилась удалением юзеров с символом пики из бд. Проблема с тем что к именам пользователей добавляются цифры осталась.

Из лога ошибок mysql

:

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Date:

Sat, 01 Sep 2012 21:09:06 +0000

Error: 1267 - Illegal mix of collations

(cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation

'='

IP Address: 89.208.9.137 -

/ipb/admin/index.php?adsess=9d665ac1a76cbbb662875d1b41803963&app=convert&app=convert&module=board&section=phpbb&do=members&st=250&cycle=250&total=1469

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

mySQL

query error: SELECT name, member_id FROM ipb_members WHERE members_l_username='♣

hacker ♣' LIMIT

0,1

.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.

|

File																	

|

Function																	

| Line No.		

|

|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|

|

admin/sources/classes/member/memberFunctions.php						

|

[memberFunctions].checkNameExists											

| 249			

|

'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

|

admin/applications_addon/ips/convert/sources/lib_master.php				|

[memberFunctions].cleanAndCheckName										

| 1197			

|

'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

|

admin/applications_addon/ips/convert/modules_admin/board/phpbb.php		

|

[lib_master].convertMember													|

682			

|

'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

|																			|

[admin_convert_board_phpbb].convert_members								

|				

|

'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

|

admin/applications_addon/ips/convert/modules_admin/board/phpbb.php		

|

[].call_user_func															

|

94				|

'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

|

admin/sources/base/ipsController.php									

|

[admin_convert_board_phpbb].doExecute										

| 306			

|

'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'


Из

ошибок конвертера:

316: reg_error_username_taken with name: Олег. Member has

still been created but with username as Олег1346533746

317: Содержит

недопустимые символы: [ ] | ; , $ \ < >

" with name [...Bomzhik...]. Member has still been created but with

username as -...Bomzhik...-

318: reg_error_username_taken with name:

vladik_BomJeG. Member has still been created but with username as

vladik_BomJeG1346533746

319: reg_error_username_taken with name: BBK. Member

has still been created but with username as BBK1346533746

320:

reg_error_username_taken with name: SergioDeLuca. Member has still been created

but with username as SergioDeLuca1346533746

321: reg_error_username_taken

with name: Владимир. Member has still been created but with username as

Владимир1346533746

322: reg_error_username_taken with name: AMD. Member has

still been created but with username as AMD1346533746

323:

reg_error_username_taken with name: Danick. Member has still been created but

with username as Danick1346533746

324: reg_error_username_taken with name:

Mike. Member has still been created but with username as Mike1346533746

325:

reg_error_username_taken with name: Bod9. Member has still been created but with

username as Bod91346533746

326: reg_error_username_taken with name: interes.

Member has still been created but with username as interes1346533746

327:

reg_error_username_taken with name: SuckMyMember. Member has still been created

but with username as SuckMyMember1346533746

[/spoiler]

И так далее, куча пользователей со старой бд почему-то с цифрами.

Насколько я понял, причина скорее всего в том юзере из бд, который взял ник с символом пики ^

Здарова Dark!

Прошу помочь мне. При попытке конвертировать пользователей (members), вылетает окно "ошибка базы данных".

Конвертирую с phpbb 3.0 на ipb 3.3.3 (русская сборка с вашего сайта)

Подскажи пожалуйста как исправить.