User statistics not working using Denora-1.4.5.411 with charybdis-3.4.2

[ghost]

Using Denora-1.4.5.411 with charybdis-3.4.2 no user statistics parts are working with MagIRC.

For e.g. 'Top 10 Users Today' user statistics at http://stats.allchatnetwork.net/ and per-channel user statistics at http://stats.allchatnetwork.net/index.php/channel/%23Games_Trivia/profile#activity.

The IRCd protocol is correct. Is this a known issue and is there a solution?

[fgrosswig]

i can confirm this on here but i found a solution. i guess the error is not magirc related! denora alters the table and there is a row missing on creation table script by ./mydbgen the "ADD mode_uz enum('Y','N') NOT NULL default 'N'," is not created somehow. so first create the table with ./mybgen and add the missing row seperate. after that start with a celan fresh stat server the stat services ./stats adding the channels to the statbot and wait a bit or make some activity. then it will work. so i resolved the glitch.

[ghost]

@fgrosswig This fixed the issue, however when looking at the source I can see that "ADD mode_uz enum('Y','N') NOT NULL default 'N'," is present in charybdis.sql, so any idea how it goes missing somewhere along the process?

[h9k]

closing as this issue is not magirc-related