• <small id='OTkXB'></small><noframes id='OTkXB'>

    • <bdo id='OTkXB'></bdo><ul id='OTkXB'></ul>
    <legend id='OTkXB'><style id='OTkXB'><dir id='OTkXB'><q id='OTkXB'></q></dir></style></legend>
    <i id='OTkXB'><tr id='OTkXB'><dt id='OTkXB'><q id='OTkXB'><span id='OTkXB'><b id='OTkXB'><form id='OTkXB'><ins id='OTkXB'></ins><ul id='OTkXB'></ul><sub id='OTkXB'></sub></form><legend id='OTkXB'></legend><bdo id='OTkXB'><pre id='OTkXB'><center id='OTkXB'></center></pre></bdo></b><th id='OTkXB'></th></span></q></dt></tr></i><div id='OTkXB'><tfoot id='OTkXB'></tfoot><dl id='OTkXB'><fieldset id='OTkXB'></fieldset></dl></div>

      <tfoot id='OTkXB'></tfoot>

      1. ejabberd 16.06 + mysql 5.5.50,不保存消息历史

        时间:2023-08-21

        <small id='4s7ZY'></small><noframes id='4s7ZY'>

          <tbody id='4s7ZY'></tbody>
        1. <legend id='4s7ZY'><style id='4s7ZY'><dir id='4s7ZY'><q id='4s7ZY'></q></dir></style></legend>

          • <i id='4s7ZY'><tr id='4s7ZY'><dt id='4s7ZY'><q id='4s7ZY'><span id='4s7ZY'><b id='4s7ZY'><form id='4s7ZY'><ins id='4s7ZY'></ins><ul id='4s7ZY'></ul><sub id='4s7ZY'></sub></form><legend id='4s7ZY'></legend><bdo id='4s7ZY'><pre id='4s7ZY'><center id='4s7ZY'></center></pre></bdo></b><th id='4s7ZY'></th></span></q></dt></tr></i><div id='4s7ZY'><tfoot id='4s7ZY'></tfoot><dl id='4s7ZY'><fieldset id='4s7ZY'></fieldset></dl></div>

              • <tfoot id='4s7ZY'></tfoot>
                • <bdo id='4s7ZY'></bdo><ul id='4s7ZY'></ul>
                  本文介绍了ejabberd 16.06 + mysql 5.5.50,不保存消息历史的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

                  问题描述

                  我用的是ejabberd 16.06 + mysql 5.5.50,消息历史没有保存.

                  I use ejabberd 16.06 + mysql 5.5.50, message history is not saved.

                  我的 ejabberd.yml:

                  My ejabberd.yml:

                  ## MySQL server:
                  
                  odbc_type: mysql 
                  odbc_server: "freldo"
                  odbc_port: 3306
                  odbc_database: "ejabberd"
                  odbc_username: "ejabberd" 
                  odbc_password: "ejabberd"
                  
                  modules: 
                  ... 
                  mod_mam: 
                     db_type: odbc 
                     default: always
                  

                  为了形成数据库结构,我使用了:mysql.sql

                  for the formation of the database structure, I used: mysql.sql

                  我收到一个错误:

                  @ejabberd_sql:check_error:1039 SQL 查询 'SELECT 时间戳,xml,peer,
                  kind, nick FROM (SELECT 时间戳, xml, peer, kind, nick FROM archive
                  WHERE username='test' 和bare_peer='misha@freldo' 按时间戳排序
                  DESC 限制 21) AS t ORDER BY 时间戳 ASC;'失败:#42S22Unknown
                  字段列表"中的种类"列"

                  @ejabberd_sql:check_error:1039 SQL query 'SELECT timestamp, xml, peer,
                  kind, nick FROM (SELECT timestamp, xml, peer, kind, nick FROM archive
                  WHERE username='test' and bare_peer='misha@freldo' ORDER BY timestamp
                  DESC limit 21) AS t ORDER BY timestamp ASC;' failed: "#42S22Unknown
                  column 'kind' in 'field list'"

                  我没有在数据库中保存消息历史.

                  I have not saved message history in database.

                  推荐答案

                  将您的 mysql 升级到 5.6+ 版本应该可以解决您的问题.

                  Upgrading your mysql to version 5.6+ should solve your problem.

                  ejabberd 在 InnoDB 中使用 FULLTEXT 索引.因此,你需要MySQL 5.6 或更高版本与 ejabberd 一起使用.

                  ejabberd make use of FULLTEXT indexes with InnoDB. Thus, you need MySQL 5.6 or greater to use with ejabberd.

                  注意:如果您不将消息存档存储在数据库中,则可以尝试使用较旧的 5.5 版本.您可能需要适配 MySQL 数据库架构以应对那些较旧的 MySQL 版本.

                  Note: If you do not store message archive in database however, you can try using older 5.5 version. You may need to adapt MySQL database schema to cope with those older MySQL versions.

                  MySQL 5.6.4 或更高版本是 推荐 如果您想存储消息历史记录.

                  MySQL version 5.6.4 or higher is recommended if you want to store message history.

                  这篇关于ejabberd 16.06 + mysql 5.5.50,不保存消息历史的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持html5模板网!

                  上一篇:将行从 TableA 移动到 Table-Archive 下一篇:SQL/Windows 操作系统释放未使用的空间

                  相关文章

                  最新文章

                  <i id='n8sQ9'><tr id='n8sQ9'><dt id='n8sQ9'><q id='n8sQ9'><span id='n8sQ9'><b id='n8sQ9'><form id='n8sQ9'><ins id='n8sQ9'></ins><ul id='n8sQ9'></ul><sub id='n8sQ9'></sub></form><legend id='n8sQ9'></legend><bdo id='n8sQ9'><pre id='n8sQ9'><center id='n8sQ9'></center></pre></bdo></b><th id='n8sQ9'></th></span></q></dt></tr></i><div id='n8sQ9'><tfoot id='n8sQ9'></tfoot><dl id='n8sQ9'><fieldset id='n8sQ9'></fieldset></dl></div>
                  <legend id='n8sQ9'><style id='n8sQ9'><dir id='n8sQ9'><q id='n8sQ9'></q></dir></style></legend>

                • <tfoot id='n8sQ9'></tfoot>

                  <small id='n8sQ9'></small><noframes id='n8sQ9'>

                        <bdo id='n8sQ9'></bdo><ul id='n8sQ9'></ul>