search

krowinski / php-mysql-replication

Pure PHP Implementation of MySQL replication protocol. This allow you to receive event like insert, update, delete with their data and raw SQL queries.
MIT License
323 stars 98 forks source link

How to fix exception about unknown row type 11 #41

Closed huangdijia closed 6 years ago

huangdijia commented 6 years ago

Please provide the following details.

Unknown row type: 11

krowinski commented 6 years ago

Row type 11 is a TIME column that is not supported, can you give me your create table with this column ? I will try to recreate this and add this column type.

huangdijia commented 6 years ago

MySQL version: 5.5.11-log - Source distribution

create table sql like this:

CREATE TABLE `t8_online_service_user_record` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `login_date` date NOT NULL DEFAULT '0000-00-00',
  `admin_uid` int(11) NOT NULL DEFAULT '0',
  `service_id` int(11) NOT NULL DEFAULT '0',
  `first_beat` time NOT NULL DEFAULT '00:00:00',
  `last_beat` time NOT NULL DEFAULT '00:00:00',
  PRIMARY KEY (`id`),
  UNIQUE KEY `ldausi` (`login_date`,`admin_uid`,`service_id`),
  KEY `ldau` (`login_date`,`admin_uid`)
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=latin1;
krowinski commented 6 years ago

Ok you have mysql 5.5 and its not fully supported but I added TIME = 11 in new branch so it should be soon in master.

huangdijia commented 6 years ago

@krowinski Thanks