Anope Bug Tracker

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0001473Anope Development (1.9.x series)Operservpublic2013-01-25 17:152013-01-27 07:51
ReporterNita 
Assigned ToAdam 
PriorityhighSeveritymajorReproducibilityalways
StatusresolvedResolutionfixed 
Platformx64OSDebianOS VersionSqueeze
Product Version 
Target VersionFixed in Version 
Summary0001473: Exception list does not added to the SQL database (GIT-devel)
DescriptionI 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.
TagsNo tags attached.
Attached Files

- Relationships

-  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


Copyright © 2000 - 2019 MantisBT Team
Powered by Mantis Bugtracker