Jump to content

Ошибка при открытии тестового форума

Decired
Decired
in Техническая поддержка IP.Board

Featured Replies

Posted
comment_24145

ставил много версий ипб всегда 1 и то же

сегодня скачал ваш релиз и то же самое

при открытии тестового форума пишет ошибка в базе данных

вот

excalia.ru/index.php?/forum/2-forum/

сам форум

excalia.ru 

искал ответы на данный вопрос так и не нашёл,писал в тп хостинга сказали ошибка не у них

надеюсь получить решение данной проблемы

Спасибо

Edited by WzGeee
Какого ссылки активные?

  • Цитата
    • Link to comment
    https://ipbmafia.ru/topic/3398-oshibka-pri-otkrytii-testovogo-foruma/
    Share on other sites
    comment_24148

    Помоему это ошибка в базе данных надо поменять! вроде так!

    Сперва смените кодировку на UTF-8, для этого зайдите в cPanel - phpmyadmin - выберите базу - операции - снизу страницы смените кодировку на UTF-8_general_ci. После, попробуйте установить.

  • Цитата
    • Link to comment
    https://ipbmafia.ru/topic/3398-oshibka-pri-otkrytii-testovogo-foruma/?&do=findComment&comment=24148
    Share on other sites
    comment_24158

    mitek534, если он форум ещё установить не может, дак проще сразу новую в UTF8 создать  :10:

  • Цитата
    • Link to comment
    https://ipbmafia.ru/topic/3398-oshibka-pri-otkrytii-testovogo-foruma/?&do=findComment&comment=24158
    Share on other sites
    • Author
    comment_24159

    mitek534, если он форум ещё установить не может, дак проще сразу новую в UTF8 создать  :10:

    форум то создан :hi:

    попробую то что выше написали

  • Цитата
    • Link to comment
    https://ipbmafia.ru/topic/3398-oshibka-pri-otkrytii-testovogo-foruma/?&do=findComment&comment=24159
    Share on other sites
    comment_24161

    нет у меня просто было такое ну в конце установки вылазило

  • Цитата
    • Link to comment
    https://ipbmafia.ru/topic/3398-oshibka-pri-otkrytii-testovogo-foruma/?&do=findComment&comment=24161
    Share on other sites
    • Author
    comment_24163

    нет у меня просто было такое ну в конце установки вылазило

    у меня вылазит уже после установки

    то есть в тестовой теме которую установка сама создаёт

     

    данная кодировка у меня стоит, есть ещё варианты?

    Edited by Decired

  • Цитата
    • Link to comment
    https://ipbmafia.ru/topic/3398-oshibka-pri-otkrytii-testovogo-foruma/?&do=findComment&comment=24163
    Share on other sites
    comment_24170

    Дайте ваши логи с cache/sql_error

  • Цитата
    • Link to comment
    https://ipbmafia.ru/topic/3398-oshibka-pri-otkrytii-testovogo-foruma/?&do=findComment&comment=24170
    Share on other sites
    • Author
    comment_24173

    Дайте ваши логи с cache/sql_error

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

     Date: Mon, 18 Mar 2013 16:34:09 +0000

     Error: 1267 - Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='

     IP Address: 217.159.179.163 - /index.php?/topic/1-dobro-pojalovat/

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

     mySQL query error: SELECT t.*,xxx.* FROM topics t  LEFT JOIN core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('forums',';','topics',';',t.tid)) )   WHERE t.tid=1

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

     | File                                                                       | Function                                                                      | Line No.          |

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

     | admin/sources/base/ipsRegistry.php                                         | [app_class_forums].__construct                                                | 1377              |

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

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

     Date: Mon, 18 Mar 2013 17:07:02 +0000

     Error: 1267 - Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='

     IP Address: 217.159.179.163 - /index.php?/forum/2-forum/

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

     mySQL query error: SELECT t.*,xxx.* FROM topics t  LEFT JOIN core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('forums',';','topics',';',t.tid)) )   WHERE t.forum_id=2 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: Mon, 18 Mar 2013 17:12:11 +0000

     Error: 1267 - Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='

     IP Address: 176.212.79.65 - /index.php?/forum/2-forum/

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

     mySQL query error: SELECT t.*,xxx.* FROM topics t  LEFT JOIN core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('forums',';','topics',';',t.tid)) )   WHERE t.forum_id=2 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: Mon, 18 Mar 2013 17:31:38 +0000

     Error: 1267 - Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='

     IP Address: 176.15.195.204 - /index.php?/forum/2-forum/

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

     mySQL query error: SELECT t.*,xxx.* FROM topics t  LEFT JOIN core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('forums',';','topics',';',t.tid)) )   WHERE t.forum_id=2 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: Mon, 18 Mar 2013 17:53:05 +0000

     Error: 1267 - Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='

     IP Address: 185.11.80.23 - /index.php?/forum/2-forum/

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

     mySQL query error: SELECT t.*,xxx.* FROM topics t  LEFT JOIN core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('forums',';','topics',';',t.tid)) )   WHERE t.forum_id=2 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               |

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

    этот?

  • Цитата
    • Link to comment
    https://ipbmafia.ru/topic/3398-oshibka-pri-otkrytii-testovogo-foruma/?&do=findComment&comment=24173
    Share on other sites
    comment_24180

     Error: 1267 - Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='

    У вас смесь кодировок в базе.

     

     

     mySQL query error: SELECT t.*,xxx.* FROM topics t  LEFT JOIN core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('forums',';','topics',';',t.tid)) )   WHERE t.forum_id=2 AND t.pinned IN (0,1) AND ( t.approved=1 ) ORDER BY t.pinned DESC,  t.last_post DESC LIMIT 0,30

    Какая кодировка у вас на core_tags_cache ?

  • Цитата
    • Link to comment
    https://ipbmafia.ru/topic/3398-oshibka-pri-otkrytii-testovogo-foruma/?&do=findComment&comment=24180
    Share on other sites
    • Author
    comment_24182

    У вас смесь кодировок в базе.

     

     

     

    Какая кодировка у вас на core_tags_cache ?

    где это узнать можно? а то по 0 чтото:D

  • Цитата
    • Link to comment
    https://ipbmafia.ru/topic/3398-oshibka-pri-otkrytii-testovogo-foruma/?&do=findComment&comment=24182
    Share on other sites
    comment_24187

    phpmyadmin

    А проще попросить хостера переделать всю базу в utf-8 

    Я бы так сделал.

  • Цитата
    • Link to comment
    https://ipbmafia.ru/topic/3398-oshibka-pri-otkrytii-testovogo-foruma/?&do=findComment&comment=24187
    Share on other sites
    comment_24188

    Вот смотри где у тебя должна быть кодировка utf8:

     

  • Цитата
    • Link to comment
    https://ipbmafia.ru/topic/3398-oshibka-pri-otkrytii-testovogo-foruma/?&do=findComment&comment=24188
    Share on other sites
    • Author
    comment_24290

    отписал хостеру чтобы сменил всю базу в utf8

    буду ждать

    всем спасибо :good:

  • Цитата
    • Link to comment
    https://ipbmafia.ru/topic/3398-oshibka-pri-otkrytii-testovogo-foruma/?&do=findComment&comment=24290
    Share on other sites

    Join the conversation

    You can post now and register later. If you have an account, sign in now to post with your account.
    Note: Your post will require moderator approval before it will be visible.

    Guest
    Ответить в этой теме...
    Go to topic listing

    Последние посетители 0

    • No registered users viewing this page.