CREATE TABLE `sphinx_auctions_2` (

  `id` bigint(20) unsigned NOT NULL DEFAULT '0',

  `weight` int(11) NOT NULL,

  `query` varchar(100) NOT NULL,

  `title` varchar(75) NOT NULL,

  PRIMARY KEY (`id`)

) ENGINE=SPHINX DEFAULT CHARSET=latin1 CONNECTION='sphinxql://192.168.179.103:9312/idx_oa_auctions'

index idx_oa_auctions

{

    type = rt

    path = /var/lib/sphinxsearch/data/mf_auctions

    morphology    = stem_en, soundex

    dict = keywords

    # should relate to index size

    # http://sphinxsearch.com/docs/2.1.7/rt-caveats.html

    # RAM chunk size limit

    # RT index will keep at most this much data in RAM, then flush to disk

    # optional, default is 32M

    #

    # rt_mem_limit              = 512M

    rt_field = title

}

MariaDB [opalauctions_com]> UPDATE sphinx_auctions_2 SET title='bananas' WHERE id=3;                                                                                                                 

ERROR 1661 (HY000): Cannot execute statement: impossible to write to binary log since both row-incapable engines and statement-incapable engines are involved.                                       

MariaDB [opalauctions_com]> SELECT @@binlog_format;

+-----------------+                                                                                                                                                                                  

| @@binlog_format |                                                                                                                                                                                  

+-----------------+                                                                                                                                                                                  

| MIXED           |                                                                                                                                                                                  

+-----------------+                                                                                                                                                                                  

1 row in set (0.00 sec)                                                                                                                                                                              

MariaDB [opalauctions_com]> set binlog_format = 'ROW';

Query OK, 0 rows affected (0.00 sec)                                                                                                                                                                 

> UPDATE sphinx_auctions_2 SET title='bananas' WHERE id=3;                                                                                                              

ERROR 1661 (HY000): Cannot execute statement: impossible to write to binary log since both row-incapable engines and statement-incapable engines are involved.                                       

> set binlog_format = 'STATEMENT';                                                                                                        

Query OK, 0 rows affected (0.00 sec)                                                                                                                                                                 

> UPDATE sphinx_auctions_2 SET title='bananas' WHERE id=3;                                                                                                                 

ERROR 1661 (HY000): Cannot execute statement: impossible to write to binary log since both row-incapable engines and statement-incapable engines are involved.