Unknown column 'subpower' in 'field list'

Bug reports go here: https://github.com/DarkstarProject/darkstar/issues

Just talk about them here please.
Forum rules
POST BUG REPORTS HERE: https://github.com/DarkstarProject/darkstar/issues

Try to keep the noise down on the reports on github, emails go out for every post on a bug report. :-)
Post Reply
doghusky1990
Posts: 56
Joined: Wed Aug 01, 2012 2:26 pm

Unknown column 'subpower' in 'field list'

Post by doghusky1990 » Fri Aug 10, 2012 4:17 pm

[18:14:21][1;35m[SQL][0m DB error - Unknown column 'subpower' in 'field list'

This appears in my game server every once in a while and also at start up, is this normal?

Demonium
Posts: 24
Joined: Thu Jul 26, 2012 12:00 pm

Re: Unknown column 'subpower' in 'field list'

Post by Demonium » Fri Aug 10, 2012 7:35 pm

Can be anything. Can you provide more from your log file? Like the line before and after the message, for example. It could help.
Thanks!

doghusky1990
Posts: 56
Joined: Wed Aug 01, 2012 2:26 pm

Re: Unknown column 'subpower' in 'field list'

Post by doghusky1990 » Fri Aug 10, 2012 8:39 pm

Code: Select all

[0m[1;32m[Status][0m Memory manager initialised: [1;37mlog/DSP.leaks[0m
[1;37m[Info][0m DarkStar - onetimexi - SVN Revision: [1;37mUnknown[0m.
[1;32m[Status][0m do_init: begin server initialization...
[18:12:46][1;37m[Info][0m Console Silent Setting: 0 			 - [1;32m[OK][0m
[18:12:46][1;32m[Status][0m do_init: map_config is reading 		 - [1;32m[OK][0m
[18:12:46][1;32m[Status][0m luautils::init:lua initializing... 		 - [1;32m[OK][0m
[18:12:46][1;32m[Status][0m cmdhandler::init: initializing...		 - [1;32m[OK][0m
[18:12:46][1;32m[Status][0m do_init: sqlhandle is allocating 		 - [1;32m[OK][0m
[18:12:46][1;32m[Status][0m do_init: zlib is reading 			 - [1;32m[OK][0m
[18:12:46][1;32m[Status][0m do_init: loading items 			 - [1;32m[OK][0m
[18:12:47][1;32m[Status][0m do_init: loading spells 			 - [1;32m[OK][0m
[18:12:47][1;32m[Status][0m do_init: loading zones 			 - [1;32m[OK][0m
[18:13:18][1;32m[Status][0m do_init: server is binding with port 54230 	 - [1;32m[OK][0m
[18:13:18][1;32m[Status][0m The map-server is [1;32mready[0m to work...
 =======================================================================
[18:13:20][1;36m[Debug][0m [1;36mUpdateWeather Finished
[0m[18:14:21][1;37m[Info][0m [1;37mmapsession[0m:[1;37m192.168.2.3[0m:[1;37m54090[0m is coming to world...
[18:14:21][1;35m[SQL][0m DB error - Unknown column 'subpower' in 'field list'
[18:14:21][1;37m[Info][0m parse: 00A | 0001 0000 2E from user: Thetester
[18:14:21][1;36m[Debug][0m [1;36mCZone:: Windurst_Woods IncreaseZoneCounter <1> Thetester 
[0m[18:14:21][1;37m[Info][0m parse: 011 | 0002 0001 04 from user: Thetester
[18:14:23][1;37m[Info][0m parse: 00C | 0003 0002 06 from user: Thetester
[18:14:23][1;37m[Info][0m parse: 061 | 0003 0002 02 from user: Thetester
[18:14:23][1;37m[Info][0m parse: 01A | 0003 0002 08 from user: Thetester
[18:14:23][1;36m[Debug][0m [1;36mCLIENT Thetester PERFORMING ACTION 14
[0m[18:14:23][1;37m[Info][0m parse: 04B | 0003 0002 0C from user: Thetester
[18:14:23][1;37m[Info][0m parse: 0E0 | 0003 0002 4C from user: Thetester
[18:14:23][1;37m[Info][0m parse: 00F | 0003 0002 12 from user: Thetester
[18:14:23][1;37m[Info][0m parse: 0DB | 0003 0002 14 from user: Thetester
[18:14:23][1;37m[Info][0m parse: 05A | 0003 0002 02 from user: Thetester
[18:14:32][1;37m[Info][0m parse: 0E7 | 0018 0017 04 from user: Thetester
[18:14:33][1;37m[Info][0m parse: 00D | 0019 0018 04 from user: Thetester
[18:14:33][1;36m[Debug][0m [1;36mCZone:: Windurst_Woods DecreaseZoneCounter <0> Thetester
[0m[18:14:35][1;36m[Debug][0m [1;36mmap_close_session: session closed
[0m[1;32m[Status][0m Memory manager initialised: [1;37mlog/DSP.leaks[0m
[1;37m[Info][0m DarkStar - onetimexi - SVN Revision: [1;37mUnknown[0m.
[1;32m[Status][0m do_init: begin server initialization...
[18:16:09][1;37m[Info][0m Console Silent Setting: 0 			 - [1;32m[OK][0m
[18:16:09][1;32m[Status][0m do_init: map_config is reading 		 - [1;32m[OK][0m
[18:16:09][1;32m[Status][0m luautils::init:lua initializing... 		 - [1;32m[OK][0m
[18:16:09][1;32m[Status][0m cmdhandler::init: initializing...		 - [1;32m[OK][0m
[18:16:09][1;32m[Status][0m do_init: sqlhandle is allocating 		 - [1;32m[OK][0m
[18:16:09][1;32m[Status][0m do_init: zlib is reading 			 - [1;32m[OK][0m
[18:16:09][1;32m[Status][0m do_init: loading items 			 - [1;32m[OK][0m
[18:16:09][1;32m[Status][0m do_init: loading spells 			 - [1;32m[OK][0m
[18:16:09][1;32m[Status][0m do_init: loading zones 			 - [1;32m[OK][0m
[18:16:41][1;32m[Status][0m do_init: server is binding with port 54230 	 - [1;32m[OK][0m
[18:16:41][1;32m[Status][0m The map-server is [1;32mready[0m to work...
 =======================================================================
[18:16:42][1;36m[Debug][0m [1;36mUpdateWeather Finished
[0m[18:17:39][1;37m[Info][0m [1;37mmapsession[0m:[1;37m192.168.2.3[0m:[1;37m54090[0m is coming to world...
[18:17:39][1;35m[SQL][0m DB error - Unknown column 'subpower' in 'field list'
[18:17:39][1;37m[Info][0m parse: 00A | 0001 0000 2E from user: Doggers
[18:17:39][1;36m[Debug][0m [1;36mCZone:: Selbina IncreaseZoneCounter <1> Doggers 
[0m[18:17:39][1;37m[Info][0m parse: 011 | 0002 0001 04 from user: Doggers
[18:17:41][1;37m[Info][0m parse: 00C | 0003 0002 06 from user: Doggers
[18:17:41][1;37m[Info][0m parse: 061 | 0003 0002 02 from user: Doggers
[18:17:41][1;37m[Info][0m parse: 01A | 0003 0002 08 from user: Doggers
[18:17:41][1;36m[Debug][0m [1;36mCLIENT Doggers PERFORMING ACTION 14
[0m[18:17:41][1;37m[Info][0m parse: 04B | 0003 0002 0C from user: Doggers
[18:17:41][1;37m[Info][0m parse: 0E0 | 0003 0002 4C from user: Doggers
[18:17:41][1;37m[Info][0m parse: 00F | 0003 0002 12 from user: Doggers
[18:17:41][1;37m[Info][0m parse: 0DB | 0003 0002 14 from user: Doggers
[18:17:41][1;37m[Info][0m parse: 05A | 0003 0002 02 from user: Doggers
[18:17:46][1;37m[Info][0m parse: 0E7 | 000C 000B 04 from user: Doggers
[18:17:46][1;37m[Info][0m parse: 00D | 000D 000C 04 from user: Doggers
[18:17:46][1;36m[Debug][0m [1;36mCZone:: Selbina DecreaseZoneCounter <0> Doggers
[0m[18:17:49][1;36m[Debug][0m [1;36mmap_close_session: session closed
[0m[18:18:04][1;37m[Info][0m [1;37mmapsession[0m:[1;37m192.168.2.3[0m:[1;37m54090[0m is coming to world...
[18:18:04][1;35m[SQL][0m DB error - Unknown column 'subpower' in 'field list'
[18:18:04][1;37m[Info][0m parse: 00A | 0001 0000 2E from user: Thetester
[18:18:04][1;36m[Debug][0m [1;36mCZone:: Windurst_Woods IncreaseZoneCounter <1> Thetester 
[0m[18:18:04][1;37m[Info][0m parse: 011 | 0002 0001 04 from user: Thetester
[18:18:05][1;37m[Info][0m parse: 00C | 0003 0002 06 from user: Thetester
[18:18:05][1;37m[Info][0m parse: 061 | 0003 0002 02 from user: Thetester
[18:18:05][1;37m[Info][0m parse: 01A | 0003 0002 08 from user: Thetester
[18:18:05][1;36m[Debug][0m [1;36mCLIENT Thetester PERFORMING ACTION 14
[0m[18:18:05][1;37m[Info][0m parse: 04B | 0003 0002 0C from user: Thetester
[18:18:05][1;37m[Info][0m parse: 0E0 | 0003 0002 4C from user: Thetester
[18:18:05][1;37m[Info][0m parse: 00F | 0003 0002 12 from user: Thetester
[18:18:05][1;37m[Info][0m parse: 0DB | 0003 0002 14 from user: Thetester
[18:18:05][1;37m[Info][0m parse: 05A | 0003 0002 02 from user: Thetester
[18:18:50][1;37m[Info][0m parse: 0B5 | 006E 006D 0C from user: Thetester
[18:18:50][1;36m[LUA Script][0m Weather Change Requested
[18:19:04][1;37m[Info][0m parse: 0B5 | 0092 0091 0C from user: Thetester
[18:19:04][1;36m[LUA Script][0m Weather Change Requested
[18:19:30][1;37m[Info][0m parse: 05E | 00CE 00CD 0C from user: Thetester
[18:19:30][1;37m[Info][0m [1;37mZoning from zone 241 to zone 240: Thetester
[0m[18:19:30][1;37m[Info][0m parse: 00D | 00CF 00CE 04 from user: Thetester
[18:19:30][1;36m[Debug][0m [1;36mCZone:: Windurst_Woods DecreaseZoneCounter <0> Thetester
[0m[18:19:33][1;37m[Info][0m parse: 00A | 0001 0000 2E from user: Thetester
[18:19:33][1;36m[Debug][0m [1;36mCZone:: Port_Windurst IncreaseZoneCounter <1> Thetester 
[0m[18:19:33][1;37m[Info][0m parse: 011 | 0002 0001 04 from user: Thetester
[18:19:35][1;37m[Info][0m parse: 00C | 0003 0002 06 from user: Thetester
[18:19:35][1;37m[Info][0m parse: 061 | 0003 0002 02 from user: Thetester
[18:19:35][1;37m[Info][0m parse: 01A | 0003 0002 08 from user: Thetester
[18:19:35][1;36m[Debug][0m [1;36mCLIENT Thetester PERFORMING ACTION 14
[0m[18:19:35][1;37m[Info][0m parse: 0E0 | 0003 0002 4C from user: Thetester
[18:19:35][1;37m[Info][0m parse: 00F | 0003 0002 12 from user: Thetester
[18:19:35][1;37m[Info][0m parse: 0DB | 0003 0002 14 from user: Thetester
[18:19:35][1;37m[Info][0m parse: 05A | 0003 0002 02 from user: Thetester
[18:19:49][1;37m[Info][0m parse: 0B5 | 0024 0023 0A from user: Thetester
[18:20:17][1;37m[Info][0m parse: 0F2 | 0069 0068 04 from user: Thetester
[18:20:32][1;37m[Info][0m parse: 01A | 008E 008D 08 from user: Thetester
[18:20:32][1;36m[Debug][0m [1;36mCLIENT Thetester PERFORMING ACTION 00
[0m[18:20:37][1;37m[Info][0m parse: 083 | 009A 0099 08 from user: Thetester
[18:20:44][1;37m[Info][0m parse: 061 | 00AB 00AA 02 from user: Thetester
[18:20:46][1;37m[Info][0m parse: 050 | 00B1 00B0 04 from user: Thetester
[18:20:46][1;37m[Info][0m parse: 061 | 00B1 00B0 02 from user: Thetester
[18:21:35][1;37m[Info][0m parse: 037 | 0126 0125 0A from user: Thetester
[18:21:43][1;37m[Info][0m parse: 05E | 013B 013A 0C from user: Thetester
[18:21:43][1;37m[Info][0m [1;37mZoning from zone 240 to zone 115: Thetester
[0m[18:21:43][1;37m[Info][0m parse: 00D | 013C 013B 04 from user: Thetester
[18:21:43][1;36m[Debug][0m [1;36mCZone:: Port_Windurst DecreaseZoneCounter <0> Thetester
[0m[18:21:46][1;37m[Info][0m parse: 00A | 0001 0000 2E from user: Thetester
[18:21:46][1;36m[Debug][0m [1;36mCZone:: West_Sarutabaruta IncreaseZoneCounter <1> Thetester 
[0m[18:21:46][1;37m[Info][0m parse: 011 | 0002 0001 04 from user: Thetester
[18:21:48][1;37m[Info][0m parse: 00C | 0003 0002 06 from user: Thetester
[18:21:48][1;37m[Info][0m parse: 061 | 0003 0002 02 from user: Thetester
[18:21:48][1;37m[Info][0m parse: 01A | 0003 0002 08 from user: Thetester
[18:21:48][1;36m[Debug][0m [1;36mCLIENT Thetester PERFORMING ACTION 14
[0m[18:21:48][1;37m[Info][0m parse: 0E0 | 0003 0002 4C from user: Thetester
[18:21:48][1;37m[Info][0m parse: 00F | 0003 0002 12 from user: Thetester
[18:21:48][1;37m[Info][0m parse: 0DB | 0003 0002 14 from user: Thetester
[18:21:48][1;37m[Info][0m parse: 05A | 0003 0002 02 from user: Thetester
[18:21:53][1;37m[Info][0m parse: 037 | 000C 000B 0A from user: Thetester
[18:21:57][1;37m[Info][0m parse: 037 | 0016 0015 0A from user: Thetester
[18:22:19][1;37m[Info][0m parse: 037 | 004E 004D 0A from user: Thetester
[18:22:22][1;37m[Info][0m parse: 037 | 0054 0053 0A from user: Thetester
[18:22:38][1;37m[Info][0m parse: 0B5 | 007C 007B 0C from user: Thetester
[18:22:42][1;37m[Info][0m parse: 037 | 0086 0085 0A from user: Thetester
[18:22:50][1;35m[SQL][0m DB error - Unknown column 'subpower' in 'field list'
[18:23:00][1;37m[Info][0m parse: 01A | 00B3 00B2 08 from user: Thetester
[18:23:00][1;36m[Debug][0m [1;36mCLIENT Thetester PERFORMING ACTION 12
[0m[18:23:11][1;37m[Info][0m parse: 0B5 | 00CF 00CE 0C from user: Thetester
[18:23:11][1;36m[LUA Script][0m Weather Change Requested
[18:23:23][1;37m[Info][0m parse: 0B5 | 00EB 00EA 0C from user: Thetester
[18:23:23][1;36m[LUA Script][0m Weather Change Requested
[18:23:28][1;37m[Info][0m parse: 0B5 | 00F7 00F6 0C from user: Thetester
[18:23:28][1;36m[LUA Script][0m Weather Change Requested
[18:23:34][1;37m[Info][0m parse: 0E7 | 0107 0106 04 from user: Thetester
[18:23:34][1;37m[Info][0m parse: 00D | 0108 0107 04 from user: Thetester
[18:23:34][1;36m[Debug][0m [1;36mCZone:: West_Sarutabaruta DecreaseZoneCounter <0> Thetester
[0m[18:23:37][1;36m[Debug][0m [1;36mmap_close_session: session closed
[0m

PrBlahBlahtson
Developer
Posts: 539
Joined: Sun Jul 22, 2012 12:17 am

Re: Unknown column 'subpower' in 'field list'

Post by PrBlahBlahtson » Fri Aug 10, 2012 8:51 pm

It seems that for some reason, your database doesn't contain the full table for char_effects. Re-run char_effects.sql in Navicat. This will wipe all your buffs out though, so make sure you won't lose anything important at an inconvenient time.

Post Reply