Ruby Rep fails to replicate for some tables

25 views
Skip to first unread message

Vishnu V V

unread,
May 23, 2019, 9:23:49 AM5/23/19
to rub...@googlegroups.com
Hi devs,

+-------------------+--------------+------+-----+---------+-------+
| Field             | Type         | Null | Key | Default | Extra |
+-------------------+--------------+------+-----+---------+-------+
| ATTENDANCE_DATE   | datetime     | NO   |     | NULL    |       |
| STUDENT_ID        | int(10)      | NO   |     | NULL    |       |
| CLASS_ID          | int(10)      | NO   |     | NULL    |       |
| STAFF_ID          | int(10)      | NO   |     | NULL    |       |
| ATTENDANCE_STATUS | char(1)      | YES  |     | NULL    |       |
| LATE_STATUS       | char(1)      | YES  |     | NULL    |       |
| LATE_TIME         | varchar(7)   | YES  |     | NULL    |       |
| DROP_TIME         | time         | YES  |     | NULL    |       |
| PICK_TIME         | time         | YES  |     | NULL    |       |
| REMARKS           | varchar(200) | YES  |     | NULL    |       |
| SCHOOL_ID         | int(11)      | YES  |     | NULL    |       |
| CREATED_ON        | datetime     | NO   |     | NULL    |       |
| CREATED_BY        | varchar(15)  | NO   |     | NULL    |       |
| MODIFIED_ON       | datetime     | YES  |     | NULL    |       |
| MODIFIED_BY       | varchar(15)  | YES  |     | NULL    |       |
+-------------------+--------------+------+-----+---------+-------+

The above is the schema of the table I need to replicate.

The error message is:

Mysql2::Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '), null, 'I');

Did anyone face this issue before? Please help.

Thanks in advance
Reply all
Reply to author
Forward
0 new messages