• 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

Mouth

Well-known member
#1
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)