0001473: Exception list does not added to the SQL database (GIT-devel)

View Issue Details [ Jump to Notes ]

[ Issue History ] [ Print ]

Project

Category

View Status

Date Submitted

Last Update

0001473

Anope Development (1.9.x series)

Operserv

public

2013-01-25 17:15

2013-01-27 07:51

Reporter

Nita

Assigned To

Adam

Priority

high

Severity

major

Reproducibility

always

Status

resolved

Resolution

fixed

Platform

x64

Debian

OS Version

Squeeze

Product Version

Target Version

Fixed in Version

Summary

0001473: Exception list does not added to the SQL database (GIT-devel)

Description

I would like to add a session exception to services via OperServ. It looks like that exception is added but it is gone when I restart services.

Version: current devel, 1.9, origin/1.9, ed7c4dc2e17a4616b0242d79ad80466970889fa0
Using: SQL Live

Steps To Reproduce

/msg OperServ EXCEPTION LIST

/msg OperServ EXCEPTION ADD +0 0::1 8 Services
/msg OperServ EXCEPTION ADD +0 127.0.0.1 8 Services

/msg OperServ Update

Stop services process and restart it.

/msg OperServ EXCEPTION LIST

Additional Information

[Jan 25 15:00:04.777926 2013] Debug: Received: :001AAAAAQ PRIVMSG 002AAAAAG :exception list
[Jan 25 15:00:04.778467 2013] Debug: SQL-live got 0 rows for SELECT * FROM `svs_BotInfo` WHERE (`timestamp` > FROM_UNIXTIME(1359125996) OR `timestamp` IS NULL)
[Jan 25 15:00:04.778818 2013] Debug: SQL-live got 0 rows for SELECT * FROM `svs_NickCore` WHERE (`timestamp` > FROM_UNIXTIME(1359125996) OR `timestamp` IS NULL)
[Jan 25 15:00:04.779048 2013] Debug: Sent: :002AAAAAG NOTICE 001AAAAAQ :The session exception list is empty.
[Jan 25 15:00:46.832710 2013] Debug: Received: :001AAAAAQ PRIVMSG 002AAAAAG :EXCEPTION ADD +0 0::1 10 Services
[Jan 25 15:00:46.833242 2013] Debug: SQL-live got 0 rows for SELECT * FROM `svs_BotInfo` WHERE (`timestamp` > FROM_UNIXTIME(1359126004) OR `timestamp` IS NULL)
[Jan 25 15:00:46.833561 2013] Debug: SQL-live got 0 rows for SELECT * FROM `svs_NickCore` WHERE (`timestamp` > FROM_UNIXTIME(1359126004) OR `timestamp` IS NULL)
[Jan 25 15:00:46.833835 2013] Debug: Sent: :002AAAAAG NOTICE 001AAAAAQ :Session limit for 0::1 set to 10.
[Jan 25 15:00:46.834018 2013] Debug: m_mysql: Fetching columns for svs_Exception
[Jan 25 15:00:46.834683 2013] Debug: m_mysql: Column #0 for svs_Exception: id
[Jan 25 15:00:46.834722 2013] Debug: m_mysql: Column 0000001 for svs_Exception: timestamp
[Jan 25 15:00:46.834752 2013] Debug: m_mysql: Column 0000002 for svs_Exception: expires
[Jan 25 15:00:46.834779 2013] Debug: m_mysql: Column 0000003 for svs_Exception: limit
[Jan 25 15:00:46.834807 2013] Debug: m_mysql: Column 0000004 for svs_Exception: mask
[Jan 25 15:00:46.834835 2013] Debug: m_mysql: Column 0000005 for svs_Exception: reason
[Jan 25 15:00:46.834862 2013] Debug: m_mysql: Column 0000006 for svs_Exception: time
[Jan 25 15:00:46.834889 2013] Debug: m_mysql: Column 0000007 for svs_Exception: who
[Jan 25 15:00:46.841599 2013] Debug: SQL-live got 0 rows for INSERT INTO `svs_Exception` (`id`,`expires`,`limit`,`mask`,`reason`,`time`,`who`) VALUES (0,'0','10','0::1','Services','1359126046','Anita') ON DUPLICATE KEY UPDATE `expires`=VALUES(`expires`),`limit`=VALUES(`limit`),`mask`=VALUES(`mask`),`reason`=VALUES(`reason`),`time`=VALUES(`time`),`who`=VALUES(`who`)
[Jan 25 15:00:46.857724 2013] Debug: Received: :001AAAAAQ PRIVMSG 002AAAAAG :EXCEPTION ADD +0 127.0.0.1 10 Services
[Jan 25 15:00:46.858275 2013] Debug: Sent: :002AAAAAG NOTICE 001AAAAAQ :Session limit for 127.0.0.1 set to 10.
[Jan 25 15:00:46.858925 2013] Debug: SQL-live got 0 rows for INSERT INTO `svs_Exception` (`id`,`expires`,`limit`,`mask`,`reason`,`time`,`who`) VALUES (0,'0','10','127.0.0.1','Services','1359126046','Anita') ON DUPLICATE KEY UPDATE `expires`=VALUES(`expires`),`limit`=VALUES(`limit`),`mask`=VALUES(`mask`),`reason`=VALUES(`reason`),`time`=VALUES(`time`),`who`=VALUES(`who`)

RESTARTING SERVICES...

[Jan 25 15:02:27.851483 2013] Debug: Sent: :002AAAAAG NOTICE 001AAAAAQ :Password accepted.
[Jan 25 15:02:41.175975 2013] Debug: Received: :001AAAAAQ PRIVMSG 002AAAAAG :exception list
[Jan 25 15:02:41.176719 2013] Debug: SQL-live got 0 rows for SELECT * FROM `svs_BotInfo` WHERE (`timestamp` > FROM_UNIXTIME(1359126147) OR `timestamp` IS NULL)
[Jan 25 15:02:41.177182 2013] Debug: SQL-live got 0 rows for SELECT * FROM `svs_NickCore` WHERE (`timestamp` > FROM_UNIXTIME(1359126147) OR `timestamp` IS NULL)
[Jan 25 15:02:41.177535 2013] Debug: Sent: :002AAAAAG NOTICE 001AAAAAQ :The session exception list is empty.

Notes
(0006336) Adam (administrator) 2013-01-27 07:51	fixed in 50a42d2cbf2ff00ecab6bd432e88c8ca17a47219

Issue History
Date Modified	Username	Field	Change
2013-01-25 17:15	Nita	New Issue
2013-01-27 07:51	Adam	Note Added: 0006336
2013-01-27 07:51	Adam	Status	new => resolved
2013-01-27 07:51	Adam	Resolution	open => fixed
2013-01-27 07:51	Adam	Assigned To	=> Adam

Relationships