Skocz do zawartości
"Idzie nowe..." - o zmianach i nie tylko ×
Przeniesienie zakupów z IPS Marketplace / Moving bought items from IPS Marketplace ×
Hosting webh.pl - 20%

Dane bazy przy konwersji

poppe

Przez poppe
w Programowanie / tworzenie styli

 Udostępnij

Rekomendowane odpowiedzi

poppe Współtwórca

poppe

Opublikowano
Opublikowano (edytowane)

witam

przechodze z vb 3.8 na najnowsze IPB, instalacja skryptu przebiegla pomyslnie, teraz chce przeniesc baze z vb na ipb, za pomoc wzialem sobie ten tutek, http://forum.invisio...-do-ipboard-3x/ ale moje pytanie brzmi jestem w kroku w ktorym musze wpisac dane do bazy itd, czy to ma byc baza ipb czy baza vb tam podana?

ps. tez zatytulowelm watek "konwersacji" zamiast konwersji ;p

Edytowane przez DawPi
poppe Współtwórca

poppe

Opublikowano
  • Autor
Opublikowano (edytowane)

Dziekuje a czy Database Table Prefix musze wpisac jakies? tzn mam sprawdzic jak sie nazywaja tabele w mojej bazie vbulletin? czy mam wpisac to co podalem na poczatku kowersji tzn forum_vbulletin?

Edytowane przez poppe
  • Lubię to 1
poppe Współtwórca

poppe

Opublikowano
  • Autor
Opublikowano

Mam tak:

// ****** TABLE PREFIX ******

// Prefix that your vBulletin tables have in the database.

$config['Database']['tableprefix'] = '';

Czyli pusto, wiec i przy konwersji tez puste zostawiam to pole?

poppe Współtwórca

poppe

Opublikowano
  • Autor
Opublikowano

Hehe ostatnie pytanie,

Charset mam w konwertorze ustawione na UTF-8 a w config.php od vbulletin mam latin2, co mam tutaj zrobic? Aby krzakow nie bylo.

poppe Współtwórca

poppe

Opublikowano
  • Autor
Opublikowano

Wielkosc mojej bazy to Tematów: 36,980, Postów: 251,487, Użytkowników: 63,491, Aktywni użytkownicy: 1,845

wiec do malych nie nalezy, operacje na niej moga byc dosc trudnawe :P To co mam teraz zrobic? Baza vb to latin2.

poppe Współtwórca

poppe

Opublikowano
  • Autor
Opublikowano

No dobra, jestem przy konwertorowaniu, tzn po kolei naciskam guziczki aby konwertowac

no i jestem przy najwazniejszym bo Members, biore convert, pokazuje sie okienko gdzie mam wpisac "The path to the folder where custom profile pictures or avatars are saved (no trailing slash - usually /path_to_vb/customprofilepics or /path_to_vb/customavatars)" wklejam tutaj adres mojego starego forum ze sciezka do avatarow,

dalej biore wszystko skip, bo nie potrzebne mi MSN, skype, yahoo, ICQ, jedynie biore Avatars z The Member Photo type to convert? i biore continute i sypie errorem na caly ekran

There appears to be an error with the database.

If you are seeing this page, it means there was a problem communicating with our database. Sometimes this error is temporary and will go away when you refresh the page. Sometimes the error will need to be fixed by an administrator before the site will become accessible again.

You can try to refresh the page by clicking here

co jest grane? :/

poppe Współtwórca

poppe

Opublikowano
  • Autor
Opublikowano

converter_error_log_11_05_12.cgi

110: Contains one or more of these illegal characters: [ ] | ; , $ \ < > " with name ciapek[PL]. Member has still been created but with username as ciapek-PL-

to to?

  • Manager
DawPi Arcymistrz

DawPi

Opublikowano
  • Manager
Opublikowano

Wklej cały log.

The path to the folder where custom profile pictures or avatars are saved (no trailing slash - usually /path_to_vb/customprofilepics or /path_to_vb/customavatars)

Path to nie to samo, co adres URL.Miej to na uwadze.

intermedia - profesjonalne rozwiązania Invision Power Board

---

Chcesz uzyskać szybko i sprawnie pomoc? Uzupełnij wersję i adres w profilu.

poppe Współtwórca

poppe

Opublikowano
  • Autor
Opublikowano (edytowane)

chyba mi sie jednak nie udalo przekonwertorowanie ta grzegrzolka

sql_error_log_11_05_12.cgi

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Mon, 05 Nov 2012 10:42:29 +0000
Error: 1267 - Illegal mix of collations (latin2_general_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation '='
IP Address: 83.9.96.253 - /admin/index.php?adsess=f23648dea2fa18dcfdb1a3b91a0479c1&app=convert&app=convert&module=board&section=vbulletin_legacy&do=groups&st=&cycle=100&total=20
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: SELECT * FROM groups WHERE g_title='Użytkownik'
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
| File																	 | Function																	 | Line No.		 |
|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
| admin/applications_addon/ips/convert/modules_admin/board/vbulletin_legacy.php| [lib_master].convertGroup													 | 498			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
|																		 | [admin_convert_board_vbulletin_legacy].convert_groups						 |				 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications_addon/ips/convert/modules_admin/board/vbulletin_legacy.php| [].call_user_func															 | 193			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/ipsController.php									 | [admin_convert_board_vbulletin_legacy].doExecute							 | 306			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Mon, 05 Nov 2012 10:42:40 +0000
Error: 1267 - Illegal mix of collations (latin2_general_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation '='
IP Address: 83.9.96.253 - /admin/index.php?adsess=f23648dea2fa18dcfdb1a3b91a0479c1&app=convert&app=convert&module=board&section=vbulletin_legacy&do=groups&st=&cycle=100&total=20
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: SELECT * FROM groups WHERE g_title='Użytkownik'
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
| File																	 | Function																	 | Line No.		 |
|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
| admin/applications_addon/ips/convert/modules_admin/board/vbulletin_legacy.php| [lib_master].convertGroup													 | 498			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
|																		 | [admin_convert_board_vbulletin_legacy].convert_groups						 |				 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications_addon/ips/convert/modules_admin/board/vbulletin_legacy.php| [].call_user_func															 | 193			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/ipsController.php									 | [admin_convert_board_vbulletin_legacy].doExecute							 | 306			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Mon, 05 Nov 2012 10:51:20 +0000
Error: 1267 - Illegal mix of collations (latin2_general_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation '='
IP Address: 83.9.96.253 - /admin/index.php?adsess=f23648dea2fa18dcfdb1a3b91a0479c1&app=convert&app=convert&module=board&section=vbulletin_legacy&do=members&st=&cycle=250&total=63491
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: SELECT name, member_id FROM members WHERE members_l_username='ÂŁukasz' 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/vbulletin_legacy.php| [lib_master].convertMember												 | 778			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
|																		 | [admin_convert_board_vbulletin_legacy].convert_members					 |				 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications_addon/ips/convert/modules_admin/board/vbulletin_legacy.php| [].call_user_func															 | 193			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/ipsController.php									 | [admin_convert_board_vbulletin_legacy].doExecute							 | 306			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Mon, 05 Nov 2012 10:51:27 +0000
Error: 1267 - Illegal mix of collations (latin2_general_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation '='
IP Address: 83.9.96.253 - /admin/index.php?adsess=f23648dea2fa18dcfdb1a3b91a0479c1&app=convert&app=convert&module=board&section=vbulletin_legacy&do=members&st=&cycle=250&total=63491
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: SELECT name, member_id FROM members WHERE members_l_username='ÂŁukasz' 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/vbulletin_legacy.php| [lib_master].convertMember												 | 778			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
|																		 | [admin_convert_board_vbulletin_legacy].convert_members					 |				 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications_addon/ips/convert/modules_admin/board/vbulletin_legacy.php| [].call_user_func															 | 193			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/ipsController.php									 | [admin_convert_board_vbulletin_legacy].doExecute							 | 306			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Mon, 05 Nov 2012 10:52:50 +0000
Error: 1267 - Illegal mix of collations (latin2_general_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation '='
IP Address: 83.9.96.253 - /admin/index.php?adsess=f23648dea2fa18dcfdb1a3b91a0479c1&app=convert&app=convert&module=board&section=vbulletin_legacy&do=members&st=&cycle=250&total=63491
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: SELECT name, member_id FROM members WHERE members_l_username='ÂŁukasz' 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/vbulletin_legacy.php| [lib_master].convertMember												 | 778			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
|																		 | [admin_convert_board_vbulletin_legacy].convert_members					 |				 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications_addon/ips/convert/modules_admin/board/vbulletin_legacy.php| [].call_user_func															 | 193			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/ipsController.php									 | [admin_convert_board_vbulletin_legacy].doExecute							 | 306			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Mon, 05 Nov 2012 10:53:09 +0000
Error: 1267 - Illegal mix of collations (latin2_general_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation '='
IP Address: 83.9.96.253 - /admin/index.php?adsess=f23648dea2fa18dcfdb1a3b91a0479c1&app=convert&app=convert&module=board&section=vbulletin_legacy&do=members&st=&cycle=250&total=63491
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: SELECT name, member_id FROM members WHERE members_l_username='ÂŁukasz' 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/vbulletin_legacy.php| [lib_master].convertMember												 | 778			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
|																		 | [admin_convert_board_vbulletin_legacy].convert_members					 |				 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications_addon/ips/convert/modules_admin/board/vbulletin_legacy.php| [].call_user_func															 | 193			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/ipsController.php									 | [admin_convert_board_vbulletin_legacy].doExecute							 | 306			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Mon, 05 Nov 2012 10:53:34 +0000
Error: 1267 - Illegal mix of collations (latin2_general_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation '='
IP Address: 83.9.96.253 - /admin/index.php?adsess=f23648dea2fa18dcfdb1a3b91a0479c1&app=convert&app=convert&module=board&section=vbulletin_legacy&do=members&st=&cycle=250&total=63491
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: SELECT name, member_id FROM members WHERE members_l_username='ÂŁukasz' 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/vbulletin_legacy.php| [lib_master].convertMember												 | 778			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
|																		 | [admin_convert_board_vbulletin_legacy].convert_members					 |				 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications_addon/ips/convert/modules_admin/board/vbulletin_legacy.php| [].call_user_func															 | 193			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/ipsController.php									 | [admin_convert_board_vbulletin_legacy].doExecute							 | 306			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Mon, 05 Nov 2012 10:53:43 +0000
Error: 1267 - Illegal mix of collations (latin2_general_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation '='
IP Address: 83.9.96.253 - /admin/index.php?adsess=f23648dea2fa18dcfdb1a3b91a0479c1&app=convert&app=convert&module=board&section=vbulletin_legacy&do=members&st=&cycle=250&total=63491
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: SELECT name, member_id FROM members WHERE members_l_username='ÂŁukasz' 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/vbulletin_legacy.php| [lib_master].convertMember												 | 778			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
|																		 | [admin_convert_board_vbulletin_legacy].convert_members					 |				 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications_addon/ips/convert/modules_admin/board/vbulletin_legacy.php| [].call_user_func															 | 193			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/ipsController.php									 | [admin_convert_board_vbulletin_legacy].doExecute							 | 306			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Mon, 05 Nov 2012 10:53:56 +0000
Error: 1267 - Illegal mix of collations (latin2_general_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation '='
IP Address: 83.9.96.253 - /admin/index.php?adsess=f23648dea2fa18dcfdb1a3b91a0479c1&app=convert&app=convert&module=board&section=vbulletin_legacy&do=members&st=&cycle=250&total=63491
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: SELECT name, member_id FROM members WHERE members_l_username='ÂŁukasz' 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/vbulletin_legacy.php| [lib_master].convertMember												 | 778			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
|																		 | [admin_convert_board_vbulletin_legacy].convert_members					 |				 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications_addon/ips/convert/modules_admin/board/vbulletin_legacy.php| [].call_user_func															 | 193			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/ipsController.php									 | [admin_convert_board_vbulletin_legacy].doExecute							 | 306			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Mon, 05 Nov 2012 10:54:01 +0000
Error: 1267 - Illegal mix of collations (latin2_general_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation '='
IP Address: 83.9.96.253 - /admin/index.php?adsess=f23648dea2fa18dcfdb1a3b91a0479c1&app=convert&app=convert&module=board&section=vbulletin_legacy&do=members&st=&cycle=250&total=63491
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: SELECT name, member_id FROM members WHERE members_l_username='ÂŁukasz' 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/vbulletin_legacy.php| [lib_master].convertMember												 | 778			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
|																		 | [admin_convert_board_vbulletin_legacy].convert_members					 |				 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications_addon/ips/convert/modules_admin/board/vbulletin_legacy.php| [].call_user_func															 | 193			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/ipsController.php									 | [admin_convert_board_vbulletin_legacy].doExecute							 | 306			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Mon, 05 Nov 2012 10:54:17 +0000
Error: 1267 - Illegal mix of collations (latin2_general_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation '='
IP Address: 83.9.96.253 - /admin/index.php?adsess=f23648dea2fa18dcfdb1a3b91a0479c1&app=convert&app=convert&module=board&section=vbulletin_legacy&do=members&st=&cycle=250&total=63491
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: SELECT name, member_id FROM members WHERE members_l_username='ÂŁukasz' 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/vbulletin_legacy.php| [lib_master].convertMember												 | 778			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
|																		 | [admin_convert_board_vbulletin_legacy].convert_members					 |				 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications_addon/ips/convert/modules_admin/board/vbulletin_legacy.php| [].call_user_func															 | 193			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/ipsController.php									 | [admin_convert_board_vbulletin_legacy].doExecute							 | 306			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Mon, 05 Nov 2012 10:59:48 +0000
Error: 1267 - Illegal mix of collations (latin2_general_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation '='
IP Address: 83.9.96.253 - /admin/index.php?adsess=f23648dea2fa18dcfdb1a3b91a0479c1&app=convert&app=convert&module=board&section=vbulletin_legacy&do=members&st=&cycle=250&total=63492
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: SELECT name, member_id FROM members WHERE members_l_username='ÂŁukasz' 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/vbulletin_legacy.php| [lib_master].convertMember												 | 778			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
|																		 | [admin_convert_board_vbulletin_legacy].convert_members					 |				 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications_addon/ips/convert/modules_admin/board/vbulletin_legacy.php| [].call_user_func															 | 193			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/ipsController.php									 | [admin_convert_board_vbulletin_legacy].doExecute							 | 306			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

i sql_error_latest.cgi

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Mon, 05 Nov 2012 10:59:48 +0000
Error: 1267 - Illegal mix of collations (latin2_general_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation '='
IP Address: 83.9.96.253 - /admin/index.php?adsess=f23648dea2fa18dcfdb1a3b91a0479c1&app=convert&app=convert&module=board&section=vbulletin_legacy&do=members&st=&cycle=250&total=63492
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: SELECT name, member_id FROM members WHERE members_l_username='ÂŁukasz' 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/vbulletin_legacy.php| [lib_master].convertMember												 | 778			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
|																		 | [admin_convert_board_vbulletin_legacy].convert_members					 |				 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications_addon/ips/convert/modules_admin/board/vbulletin_legacy.php| [].call_user_func															 | 193			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/ipsController.php									 | [admin_convert_board_vbulletin_legacy].doExecute							 | 306			 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

ale widze ze ze 127 uzytkownikow mi przenioslo juz z vb na ipb

@@ DawiPi, tak podalem taka sciezke /home/admin/domains/ADRESFORUMVBl/public_html/customavatars

Edytowane przez poppe
poppe Współtwórca

poppe

Opublikowano
  • Autor
Opublikowano (edytowane)

no tak robie podstawowa, w konwertorze daje charset na UTF-8 i wywala nadal ten error co wyzej podalem w logu.

nie rozumiem, jak to wygladaja? :P normalnie widac ogonki ^^ :D na latin2 kodowanie jest poprawne na vb.

ps. przekonwertowalo mi tych 127 userow, ale jak ich teraz usunac i zaczac wszystko od nowa? usuwalem cache, usuwalem konwersje i zakladalem nowa i ciagle mam tych userow z vb...

Edytowane przez poppe
poppe Współtwórca

poppe

Opublikowano
  • Autor
Opublikowano (edytowane)

charset zostawilem puste (tak jak bylo w tutku DawiPi), i teraz widze ze konwerutuje , troche czasu uplynie az przerzuci mi te 65tys osob.

Edytowane przez poppe
poppe Współtwórca

poppe

Opublikowano
  • Autor
Opublikowano

Po koleii konwertuje, na pewno nie mam polskich znaków ;/ są "?" zamiast ogonków itd. czyli wszystko daremne? Musze jednak zmienic kodowanie bazy vB na utf 8? i wtedy przy konwertowaniu charset tez na utf 8? ;/

Gość
Ten temat został zamknięty. Brak możliwości dodania odpowiedzi.
 Udostępnij
Tematy

  • Ostatnio przeglądający   0 użytkowników

    • Brak zarejestrowanych użytkowników przeglądających tę stronę.
×
×
  • Dodaj nową pozycję...

Powiadomienie o plikach cookie

Umieściliśmy na Twoim urządzeniu pliki cookie, aby pomóc Ci usprawnić przeglądanie strony. Możesz dostosować ustawienia plików cookie, w przeciwnym wypadku zakładamy, że wyrażasz na to zgodę.