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

Import Bazy Danych

szewun

Przez szewun
w Ogólny support IPS4

 Udostępnij

Rekomendowane odpowiedzi

BeZiCoVeR Wschodząca gwiazda

BeZiCoVeR

Opublikowano
Opublikowano

ACP -> Użytkownicy -> Pobierz listę użytkowników (ew. *_core_members*, oraz core_reputation_index, core_groups)

 

Reszta:

*_forums*

 

Oczywiście jest to tylko część do poprawnego działania forum opartego na tylko tych rzeczach musisz jeszcze wgrać chociażby folder uploads (dla avatarów na przykład)

Odnośnik do komentarza
Udostępnij na innych stronach
szewun Nowicjusz

szewun

Opublikowano
  • Autor
Opublikowano (edytowane)

wgrałem całą baze danych i całe ftp, wszystko fajnie pokazuje forum tak jak wcześniej, tylko jak wchodzę w jakiś dział lub temat to wyswietla

;There appears to be an error with the database.;

strona to http://rsko-game.pl

ktoś ma pomysł?

nawet jak zrobie nowy dział i wejde w niego to ten sam error

Edytowane przez szewun
Odnośnik do komentarza
Udostępnij na innych stronach
szewun Nowicjusz

szewun

Opublikowano
  • Autor
Opublikowano 
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
 | File                                                                       | Function                                                                      | Line No.          |
 |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
 | admin/applications/forums/modules_public/forums/forums.php                 | [public_forums_forums_forums].renderForum                                     | 457               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/applications/forums/modules_public/forums/forums.php                 | [public_forums_forums_forums].showForum                                       | 147               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/sources/base/ipsController.php                                       | [public_forums_forums_forums].doExecute                                       | 306               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Date: Sat, 01 Apr 2017 08:54:56 +0000
 Error: 1267 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin2_general_ci,COERCIBLE) for operation '='
 IP Address: 162.158.102.248 - /index.php?/forum/20-lol-off-topic/
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 mySQL query error: SELECT t.*,xxx.* FROM ipbtopics t  LEFT JOIN ipbcore_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('forums',';','topics',';',t.tid)) )   WHERE t.forum_id=20 AND t.pinned IN (0,1) AND ( t.approved IN (1,0,-1) ) ORDER BY t.pinned DESC,  t.last_post DESC LIMIT 0,30
 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
 | File                                                                       | Function                                                                      | Line No.          |
 |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
 | admin/applications/forums/modules_public/forums/forums.php                 | [public_forums_forums_forums].renderForum                                     | 457               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/applications/forums/modules_public/forums/forums.php                 | [public_forums_forums_forums].showForum                                       | 147               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/sources/base/ipsController.php                                       | [public_forums_forums_forums].doExecute                                       | 306               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Date: Sat, 01 Apr 2017 08:55:03 +0000
 Error: 1267 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin2_general_ci,COERCIBLE) for operation '='
 IP Address: 162.158.102.248 - /index.php?/topic/36-nick-pozycja-ranga/?view=getnewpost
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 mySQL query error: SELECT t.*,xxx.* FROM ipbtopics t  LEFT JOIN ipbcore_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('forums',';','topics',';',t.tid)) )   WHERE t.tid=36
 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
 | File                                                                       | Function                                                                      | Line No.          |
 |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
 | admin/sources/base/ipsRegistry.php                                         | [app_class_forums].__construct                                                | 1389              |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Date: Sat, 01 Apr 2017 08:55:18 +0000
 Error: 1267 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin2_general_ci,COERCIBLE) for operation '='
 IP Address: 162.158.102.248 - /index.php?/forum/40-2-rezerwacje-serwera/
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 mySQL query error: SELECT t.*,xxx.* FROM ipbtopics t  LEFT JOIN ipbcore_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('forums',';','topics',';',t.tid)) )   WHERE t.forum_id=40 AND t.pinned IN (0,1) AND ( t.approved IN (1,0,-1) ) ORDER BY t.pinned DESC,  t.last_post DESC LIMIT 0,30
 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
 | File                                                                       | Function                                                                      | Line No.          |
 |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
 | admin/applications/forums/modules_public/forums/forums.php                 | [public_forums_forums_forums].renderForum                                     | 457               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/applications/forums/modules_public/forums/forums.php                 | [public_forums_forums_forums].showForum                                       | 147               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/sources/base/ipsController.php                                       | [public_forums_forums_forums].doExecute                                       | 306               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Date: Sat, 01 Apr 2017 08:56:20 +0000
 Error: 1267 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin2_general_ci,COERCIBLE) for operation '='
 IP Address: 162.158.102.248 - /index.php?/topic/42-los-vatos-locos/?view=getnewpost
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 mySQL query error: SELECT t.*,xxx.* FROM ipbtopics t  LEFT JOIN ipbcore_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('forums',';','topics',';',t.tid)) )   WHERE t.tid=42
 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
 | File                                                                       | Function                                                                      | Line No.          |
 |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
 | admin/sources/base/ipsRegistry.php                                         | [app_class_forums].__construct                                                | 1389              |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Date: Sat, 01 Apr 2017 08:56:58 +0000
 Error: 1267 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin2_general_ci,COERCIBLE) for operation '='
 IP Address: 162.158.102.248 - /index.php?/topic/190-swiezaki-vs-okocim-team-cwier%C4%87-fina%C5%82/
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 mySQL query error: SELECT t.*,xxx.* FROM ipbtopics t  LEFT JOIN ipbcore_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('forums',';','topics',';',t.tid)) )   WHERE t.tid=190
 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
 | File                                                                       | Function                                                                      | Line No.          |
 |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
 | admin/sources/base/ipsRegistry.php                                         | [app_class_forums].__construct                                                | 1389              |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Date: Sat, 01 Apr 2017 08:57:02 +0000
 Error: 1267 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin2_general_ci,COERCIBLE) for operation '='
 IP Address: 162.158.102.248 - /index.php?/topic/20-csgo-ruletki-darmowe-dolary-na-start/?view=getnewpost
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 mySQL query error: SELECT t.*,xxx.* FROM ipbtopics t  LEFT JOIN ipbcore_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('forums',';','topics',';',t.tid)) )   WHERE t.tid=20
 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
 | File                                                                       | Function                                                                      | Line No.          |
 |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
 | admin/sources/base/ipsRegistry.php                                         | [app_class_forums].__construct                                                | 1389              |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Date: Sat, 01 Apr 2017 08:57:55 +0000
 Error: 1267 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin2_general_ci,COERCIBLE) for operation '='
 IP Address: 162.158.102.248 - /index.php?/forum/49-forum-chwilowo-niedost%C4%99pne/
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 mySQL query error: SELECT t.*,xxx.* FROM ipbtopics t  LEFT JOIN ipbcore_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('forums',';','topics',';',t.tid)) )   WHERE t.forum_id=49 AND t.pinned IN (0,1) AND ( t.approved IN (1,0,-1) ) ORDER BY t.pinned DESC,  t.last_post DESC LIMIT 0,30
 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
 | File                                                                       | Function                                                                      | Line No.          |
 |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
 | admin/applications/forums/modules_public/forums/forums.php                 | [public_forums_forums_forums].renderForum                                     | 457               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/applications/forums/modules_public/forums/forums.php                 | [public_forums_forums_forums].showForum                                       | 147               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/sources/base/ipsController.php                                       | [public_forums_forums_forums].doExecute                                       | 306               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Date: Sat, 01 Apr 2017 08:58:00 +0000
 Error: 1267 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin2_general_ci,COERCIBLE) for operation '='
 IP Address: 162.158.102.248 - /index.php?/forum/49-forum-chwilowo-niedost%C4%99pne/
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 mySQL query error: SELECT t.*,xxx.* FROM ipbtopics t  LEFT JOIN ipbcore_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('forums',';','topics',';',t.tid)) )   WHERE t.forum_id=49 AND t.pinned IN (0,1) AND ( t.approved IN (1,0,-1) ) ORDER BY t.pinned DESC,  t.last_post DESC LIMIT 0,30
 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
 | File                                                                       | Function                                                                      | Line No.          |
 |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
 | admin/applications/forums/modules_public/forums/forums.php                 | [public_forums_forums_forums].renderForum                                     | 457               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/applications/forums/modules_public/forums/forums.php                 | [public_forums_forums_forums].showForum                                       | 147               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/sources/base/ipsController.php                                       | [public_forums_forums_forums].doExecute                                       | 306               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Date: Sat, 01 Apr 2017 09:00:38 +0000
 Error: 1267 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin2_general_ci,COERCIBLE) for operation '='
 IP Address: 162.158.102.248 - /index.php?/forum/15-csgo-off-topic/
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 mySQL query error: SELECT t.*,xxx.* FROM ipbtopics t  LEFT JOIN ipbcore_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('forums',';','topics',';',t.tid)) )   WHERE t.forum_id=15 AND t.pinned IN (0,1) AND ( t.approved IN (1,0,-1) ) ORDER BY t.pinned DESC,  t.last_post DESC LIMIT 0,30
 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
 | File                                                                       | Function                                                                      | Line No.          |
 |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
 | admin/applications/forums/modules_public/forums/forums.php                 | [public_forums_forums_forums].renderForum                                     | 457               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/applications/forums/modules_public/forums/forums.php                 | [public_forums_forums_forums].showForum                                       | 147               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/sources/base/ipsController.php                                       | [public_forums_forums_forums].doExecute                                       | 306               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Date: Sat, 01 Apr 2017 09:00:42 +0000
 Error: 1267 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin2_general_ci,COERCIBLE) for operation '='
 IP Address: 162.158.102.248 - /index.php?/forum/15-csgo-off-topic/
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 mySQL query error: SELECT t.*,xxx.* FROM ipbtopics t  LEFT JOIN ipbcore_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('forums',';','topics',';',t.tid)) )   WHERE t.forum_id=15 AND t.pinned IN (0,1) AND ( t.approved IN (1,0,-1) ) ORDER BY t.pinned DESC,  t.last_post DESC LIMIT 0,30
 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
 | File                                                                       | Function                                                                      | Line No.          |
 |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
 | admin/applications/forums/modules_public/forums/forums.php                 | [public_forums_forums_forums].renderForum                                     | 457               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/applications/forums/modules_public/forums/forums.php                 | [public_forums_forums_forums].showForum                                       | 147               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/sources/base/ipsController.php                                       | [public_forums_forums_forums].doExecute                                       | 306               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Date: Sat, 01 Apr 2017 09:00:44 +0000
 Error: 1267 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin2_general_ci,COERCIBLE) for operation '='
 IP Address: 162.158.102.248 - /index.php?/forum/15-csgo-off-topic/
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 mySQL query error: SELECT t.*,xxx.* FROM ipbtopics t  LEFT JOIN ipbcore_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('forums',';','topics',';',t.tid)) )   WHERE t.forum_id=15 AND t.pinned IN (0,1) AND ( t.approved IN (1,0,-1) ) ORDER BY t.pinned DESC,  t.last_post DESC LIMIT 0,30
 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
 | File                                                                       | Function                                                                      | Line No.          |
 |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
 | admin/applications/forums/modules_public/forums/forums.php                 | [public_forums_forums_forums].renderForum                                     | 457               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/applications/forums/modules_public/forums/forums.php                 | [public_forums_forums_forums].showForum                                       | 147               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/sources/base/ipsController.php                                       | [public_forums_forums_forums].doExecute                                       | 306               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Date: Sat, 01 Apr 2017 09:02:22 +0000
 Error: 1267 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin2_general_ci,COERCIBLE) for operation '='
 IP Address: 162.158.102.248 - /index.php?/forum/15-csgo-off-topic/
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 mySQL query error: SELECT t.*,xxx.* FROM ipbtopics t  LEFT JOIN ipbcore_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('forums',';','topics',';',t.tid)) )   WHERE t.forum_id=15 AND t.pinned IN (0,1) AND ( t.approved IN (1,0,-1) ) ORDER BY t.pinned DESC,  t.last_post DESC LIMIT 0,30
 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
 | File                                                                       | Function                                                                      | Line No.          |
 |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
 | admin/applications/forums/modules_public/forums/forums.php                 | [public_forums_forums_forums].renderForum                                     | 457               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/applications/forums/modules_public/forums/forums.php                 | [public_forums_forums_forums].showForum                                       | 147               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/sources/base/ipsController.php                                       | [public_forums_forums_forums].doExecute                                       | 306               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Date: Sat, 01 Apr 2017 09:02:30 +0000
 Error: 1267 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin2_general_ci,COERCIBLE) for operation '='
 IP Address: 162.158.102.248 - /index.php?/topic/78-wa%C5%BCne-komendy-serwera/?view=getnewpost
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 mySQL query error: SELECT t.*,xxx.* FROM ipbtopics t  LEFT JOIN ipbcore_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('forums',';','topics',';',t.tid)) )   WHERE t.tid=78
 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
 | File                                                                       | Function                                                                      | Line No.          |
 |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
 | admin/sources/base/ipsRegistry.php                                         | [app_class_forums].__construct                                                | 1389              |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Date: Sat, 01 Apr 2017 09:03:17 +0000
 Error: 1267 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin2_general_ci,COERCIBLE) for operation '='
 IP Address: 162.158.102.248 - /index.php?/forum/15-csgo-off-topic/
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 mySQL query error: SELECT t.*,xxx.* FROM ipbtopics t  LEFT JOIN ipbcore_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('forums',';','topics',';',t.tid)) )   WHERE t.forum_id=15 AND t.pinned IN (0,1) AND ( t.approved IN (1,0,-1) ) ORDER BY t.pinned DESC,  t.last_post DESC LIMIT 0,30
 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
 | File                                                                       | Function                                                                      | Line No.          |
 |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
 | admin/applications/forums/modules_public/forums/forums.php                 | [public_forums_forums_forums].renderForum                                     | 457               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/applications/forums/modules_public/forums/forums.php                 | [public_forums_forums_forums].showForum                                       | 147               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/sources/base/ipsController.php                                       | [public_forums_forums_forums].doExecute                                       | 306               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Date: Sat, 01 Apr 2017 09:03:33 +0000
 Error: 1267 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin2_general_ci,COERCIBLE) for operation '='
 IP Address: 162.158.102.248 - /index.php?/topic/78-wa%C5%BCne-komendy-serwera/?view=getnewpost
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 mySQL query error: SELECT t.*,xxx.* FROM ipbtopics t  LEFT JOIN ipbcore_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('forums',';','topics',';',t.tid)) )   WHERE t.tid=78
 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
 | File                                                                       | Function                                                                      | Line No.          |
 |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
 | admin/sources/base/ipsRegistry.php                                         | [app_class_forums].__construct                                                | 1389              |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Date: Sat, 01 Apr 2017 09:03:37 +0000
 Error: 1267 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin2_general_ci,COERCIBLE) for operation '='
 IP Address: 162.158.102.248 - /index.php?/forum/49-forum-chwilowo-niedost%C4%99pne/
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 mySQL query error: SELECT t.*,xxx.* FROM ipbtopics t  LEFT JOIN ipbcore_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('forums',';','topics',';',t.tid)) )   WHERE t.forum_id=49 AND t.pinned IN (0,1) AND ( t.approved IN (1,0,-1) ) ORDER BY t.pinned DESC,  t.last_post DESC LIMIT 0,30
 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
 | File                                                                       | Function                                                                      | Line No.          |
 |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
 | admin/applications/forums/modules_public/forums/forums.php                 | [public_forums_forums_forums].renderForum                                     | 457               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/applications/forums/modules_public/forums/forums.php                 | [public_forums_forums_forums].showForum                                       | 147               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/sources/base/ipsController.php                                       | [public_forums_forums_forums].doExecute                                       | 306               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Date: Sat, 01 Apr 2017 09:04:36 +0000
 Error: 1267 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin2_general_ci,COERCIBLE) for operation '='
 IP Address: 162.158.102.248 - /index.php?/forum/49-forum-chwilowo-niedost%C4%99pne/
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 mySQL query error: SELECT t.*,xxx.* FROM ipbtopics t  LEFT JOIN ipbcore_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('forums',';','topics',';',t.tid)) )   WHERE t.forum_id=49 AND t.pinned IN (0,1) AND ( t.approved IN (1,0,-1) ) ORDER BY t.pinned DESC,  t.last_post DESC LIMIT 0,30
 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
 | File                                                                       | Function                                                                      | Line No.          |
 |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
 | admin/applications/forums/modules_public/forums/forums.php                 | [public_forums_forums_forums].renderForum                                     | 457               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/applications/forums/modules_public/forums/forums.php                 | [public_forums_forums_forums].showForum                                       | 147               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/sources/base/ipsController.php                                       | [public_forums_forums_forums].doExecute                                       | 306               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Date: Sat, 01 Apr 2017 09:10:48 +0000
 Error: 1267 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin2_general_ci,COERCIBLE) for operation '='
 IP Address: 162.158.103.15 - /index.php?/forum/47-zapisz-swoj-druyn/
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 mySQL query error: SELECT t.*,xxx.* FROM ipbtopics t  LEFT JOIN ipbcore_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('forums',';','topics',';',t.tid)) )   WHERE t.forum_id=47 AND t.pinned IN (0,1) AND ( t.approved=1 ) ORDER BY t.pinned DESC,  t.last_post DESC LIMIT 0,30
 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
 | File                                                                       | Function                                                                      | Line No.          |
 |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
 | admin/applications/forums/modules_public/forums/forums.php                 | [public_forums_forums_forums].renderForum                                     | 457               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/applications/forums/modules_public/forums/forums.php                 | [public_forums_forums_forums].showForum                                       | 147               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/sources/base/ipsController.php                                       | [public_forums_forums_forums].doExecute                                       | 306               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Date: Sat, 01 Apr 2017 09:12:00 +0000
 Error: 1267 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin2_general_ci,COERCIBLE) for operation '='
 IP Address: 162.158.103.15 - /index.php?/forum/47-zapisz-swoj-druyn/
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 mySQL query error: SELECT t.*,xxx.* FROM ipbtopics t  LEFT JOIN ipbcore_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('forums',';','topics',';',t.tid)) )   WHERE t.forum_id=47 AND t.pinned IN (0,1) AND ( t.approved=1 ) ORDER BY t.pinned DESC,  t.last_post DESC LIMIT 0,30
 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
 | File                                                                       | Function                                                                      | Line No.          |
 |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
 | admin/applications/forums/modules_public/forums/forums.php                 | [public_forums_forums_forums].renderForum                                     | 457               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/applications/forums/modules_public/forums/forums.php                 | [public_forums_forums_forums].showForum                                       | 147               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/sources/base/ipsController.php                                       | [public_forums_forums_forums].doExecute                                       | 306               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Date: Sat, 01 Apr 2017 09:12:08 +0000
 Error: 1267 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin2_general_ci,COERCIBLE) for operation '='
 IP Address: 162.158.103.15 - /index.php?/forum/46-sprawy-organizacyjne/
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 mySQL query error: SELECT t.*,xxx.* FROM ipbtopics t  LEFT JOIN ipbcore_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('forums',';','topics',';',t.tid)) )   WHERE t.forum_id=46 AND t.pinned IN (0,1) AND ( t.approved=1 ) ORDER BY t.pinned DESC,  t.last_post DESC LIMIT 0,30
 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
 | File                                                                       | Function                                                                      | Line No.          |
 |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
 | admin/applications/forums/modules_public/forums/forums.php                 | [public_forums_forums_forums].renderForum                                     | 457               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/applications/forums/modules_public/forums/forums.php                 | [public_forums_forums_forums].showForum                                       | 147               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/sources/base/ipsController.php                                       | [public_forums_forums_forums].doExecute                                       | 306               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Date: Sat, 01 Apr 2017 09:26:51 +0000
 Error: 1267 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin2_general_ci,COERCIBLE) for operation '='
 IP Address: 162.158.102.248 - /index.php?/forum/33-sprawy-organizacyjne/
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 mySQL query error: SELECT t.*,xxx.* FROM ipbtopics t  LEFT JOIN ipbcore_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('forums',';','topics',';',t.tid)) )   WHERE t.forum_id=33 AND t.pinned IN (0,1) AND ( t.approved IN (1,0,-1) ) ORDER BY t.pinned DESC,  t.last_post DESC LIMIT 0,30
 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
 | File                                                                       | Function                                                                      | Line No.          |
 |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
 | admin/applications/forums/modules_public/forums/forums.php                 | [public_forums_forums_forums].renderForum                                     | 457               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/applications/forums/modules_public/forums/forums.php                 | [public_forums_forums_forums].showForum                                       | 147               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/sources/base/ipsController.php                                       | [public_forums_forums_forums].doExecute                                       | 306               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

 

Odnośnik do komentarza
Udostępnij na innych stronach
  • Manager
DawPi Arcymistrz

DawPi

Opublikowano
  • Manager
Opublikowano

Masz pomieszane kodowanie w bazie danych. Tak się kończą takie 'zabawy'.

  

Error: 1267 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin2_general_ci,COERCIBLE) for ope

 

intermedia - profesjonalne rozwiązania Invision Power Board

---

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

Odnośnik do komentarza
Udostępnij na innych stronach
Jurij Arcymistrz

Jurij

Opublikowano
Opublikowano

No ale sam sobie z tym nie poradzi :) Więc ma dwa wyjścia:

 

1. Jeśli połączył działające forum z nowo zainstalowanym forum - pozostaje skasować wszystko z ftp i wgrać na serwer backup działającego forum + bazy sql. Wtedy wszystko będzie działać i dostosujesz forum do swoich potrzeb.

 

2. Jeśli chcesz połączyć dwa działające fora, musisz użyć konwertera od IPS. Ale to też nie jest zabawa dla nowicjuszy, więc jeśli chcesz mieć to dobrze zrobione, zleć to komuś kto się na tym zna ;)

  • Lubię to 1
Odnośnik do komentarza
Udostępnij na innych stronach
szewun Nowicjusz

szewun

Opublikowano
  • Autor
Opublikowano (edytowane)

Zrobiłem wszystko tak jak powiedziałeś w punkcie 1.

Lecz mam problem bo nie mam domeny, którą wczytywała tamta baza i forum. Przez co forum nie chodzi tak jak powinno.

W sensie loguje się wpisuje passy klikam ok i przenosi mnie do strony glownej i nadal nie jestem zalogowany.

Co z tym zrobić? W których miejscach pozmieniać domene?

Edytowane przez szewun
Odnośnik do komentarza
Udostępnij na innych stronach

Jeśli chcesz dodać odpowiedź, zaloguj się lub zarejestruj nowe konto

Jedynie zarejestrowani użytkownicy mogą komentować zawartość tej strony.

Zarejestruj nowe konto

Załóż nowe konto. To bardzo proste!

Zarejestruj się

Zaloguj się

Posiadasz już konto? Zaloguj się poniżej.

Zaloguj się
 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ę.