1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

XF 1.3 SQL - Duplicate Key Update - xf_bb_code_parse_cache

Discussion in 'Troubleshooting and Problems' started by Mouth, Mar 2, 2014.

  1. Mouth

    Mouth Well-Known Member

    Using xf v1.3RC1 and getting the following in mysql-error.log for each post (and post read/view?) ...

    Code:
    2014-03-03 08:41:06 52412 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. INSERT... ON DUPLICATE KEY UPDATE  on a table with more than one UNIQUE KEY is unsafe Statement: INSERT INTO xf_bb_code_parse_cache
                                    (content_type, content_id, parse_tree, cache_version, cache_date)
                                VALUES ('post', '2698546', 'a:1:{i:0;s:100:\"\"I\'m a motorcyclist too.  I take my 50cc scooter to tennis lessons every second Thursday in summer!\"\";}', '1393791318', '1393796465')
                                ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
                                    cache_version = VALUES(cache_version),
                                    cache_date = VALUES(cache_date)
    Code:
    mysql> DESCRIBE `xf_bb_code_parse_cache`;
    
    +------------------------+------------------+------+-----+---------+----------------+
    
    | Field                  | Type             | Null | Key | Default | Extra          |
    
    +------------------------+------------------+------+-----+---------+----------------+
    
    | bb_code_parse_cache_id | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
    
    | content_type           | varbinary(25)    | NO   | MUL | NULL    |                |
    
    | content_id             | int(10) unsigned | NO   |     | NULL    |                |
    
    | parse_tree             | mediumblob       | NO   |     | NULL    |                |
    
    | cache_version          | int(10) unsigned | NO   | MUL | NULL    |                |
    
    | cache_date             | int(10) unsigned | NO   | MUL | 0       |                |
    
    +------------------------+------------------+------+-----+---------+----------------+
    
    6 rows in set (0.00 sec)
    
    


    Code:
    mysql> SHOW INDEX FROM  `xf_bb_code_parse_cache`;
    
    +------------------------+------------+-----------------+--------------+------------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
    
    | Table                  | Non_unique | Key_name        | Seq_in_index | Column_name            | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
    
    +------------------------+------------+-----------------+--------------+------------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
    
    | xf_bb_code_parse_cache |          0 | PRIMARY         |            1 | bb_code_parse_cache_id | A         |        2752 |     NULL | NULL   |      | BTREE      |         |               |
    
    | xf_bb_code_parse_cache |          0 | content_type_id |            1 | content_type           | A         |           9 |     NULL | NULL   |      | BTREE      |         |               |
    
    | xf_bb_code_parse_cache |          0 | content_type_id |            2 | content_id             | A         |        2752 |     NULL | NULL   |      | BTREE      |         |               |
    
    | xf_bb_code_parse_cache |          1 | cache_version   |            1 | cache_version          | A         |           4 |     NULL | NULL   |      | BTREE      |         |               |
    
    | xf_bb_code_parse_cache |          1 | cache_date      |            1 | cache_date             | A         |         275 |     NULL | NULL   |      | BTREE      |         |               |
    
    +------------------------+------------+-----------------+--------------+------------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
    
    5 rows in set (0.00 sec)
    
     
  2. Mike

    Mike XenForo Developer Staff Member

Share This Page