View Issue Details

IDProjectCategoryView StatusLast Update
0001705Anope Stable (2.0.x series)Generalpublic2022-01-10 18:30
ReporterKaj Assigned ToSadie  
Status resolvedResolutionfixed 
PlatformAnope 2.0.4OSUbuntu 
Summary0001705: m_irc2sql module not compatible with MySQL 5.7
DescriptionWhen using a MySQL database version 5.7, the m_irc2sql module will not work.
The services boot and operate successfully but the corresponding tables anope_chan and anope_user will stay empty.
Steps To Reproduce1. Configure m_mysql to use a MySQL database of version 5.7
2. Enable the m_irc2sql module
3. Start the services and pass on the --debug flag

After booting the services, the anope_chan and anope_user tables will remain empty and in the logfiles a lot of errors like the following are being logged:

[May 29 09:10:35.933274 2017] m_irc2sql: Error executing query INSERT INTO `anope_chan` (channel, topic, topicauthor, topictime, modes) VALUES ('#Chan','','','0','') ON DUPLICATE KEY UPDATE channel=VALUES(channel), topic=VALUES(topic),topicauthor=VALUES(topicauthor), topictime=VALUES(topictime), modes=VALUES(modes): Incorrect datetime value: '0' for column 'topictime' at row
Additional InformationWorks perfectly with MySQL 5.6 OR when disable sqlmode STRICT_TRANS_TABLES on MySQL 5.7

Since mysql version 5.7 - sqlmodes were introduced, including the mode STRICT_TRANS_TABLES which is enabled by default:

From MySQL 5.7.4 through 5.7.7, STRICT_TRANS_TABLES includes the effect of the ERROR_FOR_DIVISION_BY_ZERO, NO_ZERO_DATE, and NO_ZERO_IN_DATE modes

Anope forum post related to this issue:
TagsNo tags attached.



2022-01-10 18:30

manager   ~0006881

This was fixed in commit 76ea11198028b6a1ab4f739d239bf890ce6d937e.


2020-02-10 23:41

reporter   ~0006868

i'm pretty sure that this was fixed already.

i have v2.0.7, mysql v5.7 and irc2sql works fine.

ii mysql-server-5.7 5.7.29

Issue History

Date Modified Username Field Change
2017-05-30 07:12 Kaj New Issue
2020-02-10 23:41 Lord255 Note Added: 0006868
2022-01-10 18:30 Sadie Assigned To => Sadie
2022-01-10 18:30 Sadie Status new => resolved
2022-01-10 18:30 Sadie Resolution open => fixed
2022-01-10 18:30 Sadie Note Added: 0006881