Anope IRC Services

Denora Stats (discontinued) => Denora 1.5.x Support (Read Only) => Topic started by: mike on June 25, 2014, 11:06:19 AM

Title: SQL Error
Post by: mike on June 25, 2014, 11:06:19 AM
Hey


Not having much luck with a clean install. I have mysql server running, and configured correctly, however, i get this (i would have used the FAQ, but alas not working):

[Jun 25 04:54:11.271000 2014] Running: ¨úiwö>
[Jun 25 04:54:11.271000 2014] Launching Denora into the background
[Jun 25 04:54:11.276000 2014] Module unreal32 compiled against current or newer Denora revision 755, this is 755
[Jun 25 04:54:11.276000 2014] Loading IRCD Protocol Module: [unreal32]
[Jun 25 04:54:11.276000 2014] IRCD Protocol Author: [Denora]
[Jun 25 04:54:11.276000 2014] IRCD Protocol Version: []
[Jun 25 04:54:11.277000 2014] Loading stats.db
[Jun 25 04:54:11.277000 2014] Loading tld.db
[Jun 25 04:54:11.277000 2014] Loading ChannelStats.db
[Jun 25 04:54:11.277000 2014] Loading server.db
[Jun 25 04:54:11.278000 2014] Loading ctcp.db
[Jun 25 04:54:11.278000 2014] Loading chan.db
[Jun 25 04:54:11.281000 2014] Loading exclude.db
[Jun 25 04:54:11.281000 2014] Loading admin.db
[Jun 25 04:54:11.281000 2014] Denora 1.5.0.755 (IRCd protocol: UnrealIRCd 3.2+) starting up (options: debug on)
[Jun 25 04:54:11.282000 2014] debug: existing Cron: (0x00561960), new msg (0x00561980) (cron_hourly)
[Jun 25 04:54:11.282000 2014] debug: existing Cron: (0x00561980), new msg (0x005619A0) (cron_hourly)
[Jun 25 04:54:11.282000 2014] MySQL not found while compiling, SQL queries are disabled
[Jun 25 04:54:11.282000 2014] trying to load [cron_chanstats]
[Jun 25 04:54:11.283000 2014] Runtime module location: C:\Program Files (x86)\Denora\data\core\runtime\cron_chanstats.dll.a53468
[Jun 25 04:54:11.284000 2014] Module cron_chanstats compiled against current or newer Denora revision 755, this is 755
[Jun 25 04:54:11.285000 2014] SQL not enabled unloading cron_chanstats
[Jun 25 04:54:11.285000 2014] cron_chanstats requested unload...
[Jun 25 04:54:11.285000 2014] status: [6][Module Error, Error during load time or module returned MOD_STOP]
Title: Re: SQL Error
Post by: mike on June 25, 2014, 03:42:15 PM
Fixed.

But now get this:

[Jun 25 09:34:35 2014] MYSQL reported Error Code 1264
[Jun 25 09:34:35 2014] MYSQL said Out of range value for column 'linkedto' at row 1
[Jun 25 09:34:35 2014] The field is to small, attempt to change the field from INT TO BIGINT
[Jun 25 09:34:35 2014] Until this is done Denora can not update this table
[Jun 25 09:34:35 2014] Report this to Denora Developers
[Jun 25 09:34:36 2014] MYSQL reported Error Code 1264
[Jun 25 09:34:36 2014] MYSQL said Out of range value for column 'servid' at row 1
[Jun 25 09:34:36 2014] The field is to small, attempt to change the field from INT TO BIGINT
[Jun 25 09:34:36 2014] Until this is done Denora can not update this table
[Jun 25 09:34:36 2014] Report this to Denora Developers
Title: Re: SQL Error
Post by: CrazyCat on June 26, 2014, 09:39:37 AM
Did you try emptying the server table and set its autoincrement to 0 ? Then, restart denora.