No inventory!

[msulli1355]

I'm running revision 1581 on a Linux box. I haven't booted into DS in a couple of weeks (family crises), but when I logged in this morning, my inventory did not load at all. I tried to buy from Neigepance in Bastok Mines, but got no message saying that my purchase was added to my inventory. I did not notice if money was subtracted from my purse. Here is what the server output to my terminal window:
michael@carter /home/work/trunk $ ./dsgame
[Status] Memory manager initialised: log/DSP.leaks
[Info] DarkStar - onetimexi - SVN Revision: Unknown.
[Status] do_init: begin server initialization...
[10:15:05][Info] Console Silent Setting: 0 - [OK]
[10:15:05][Status] do_init: map_config is reading - [OK]
[10:15:05][Status] luautils::init:lua initializing... - [OK]
[10:15:05][Status] cmdhandler::init: initializing... - [OK]
[10:15:05][Status] do_init: sqlhandle is allocating - [OK]
[10:15:06][Status] do_init: zlib is reading - [OK]
[10:15:06][Status] do_init: loading items[10:15:06][SQL] DB error - Unknown column 'u.aoe' in 'field list'
- [OK]
[10:15:06][Status] do_init: loading spells[10:15:06][SQL] DB error - Unknown column 'magicBurstMessage' in 'field list'
- [OK]
[10:15:06][Status] do_init: loading zones - [OK]
[10:15:27][Status] do_init: server is binding with port 54230 - [OK]
[10:15:27][Status] The map-server is ready to work...
=======================================================================
[10:17:37][Info] mapsession:192.168.2.100:54090 is coming to world...
[10:17:37][SQL] DB error - Unknown column 'subpower' in 'field list'
[10:17:37][Info] parse: 00A | 0001 0000 2E from user: Michael
[10:17:37][Info] parse: 011 | 0002 0001 04 from user: Michael
[10:17:39][Info] parse: 00C | 0003 0002 06 from user: Michael
[10:17:39][Info] parse: 061 | 0003 0002 02 from user: Michael
[10:17:39][Info] parse: 04B | 0003 0002 0C from user: Michael
[10:17:39][Info] parse: 0E0 | 0003 0002 4C from user: Michael
[10:17:39][Info] parse: 00F | 0003 0002 12 from user: Michael
[10:17:39][Info] parse: 0DB | 0003 0002 14 from user: Michael
[10:17:39][Info] parse: 05A | 0003 0002 02 from user: Michael
[10:17:39][Info] parse: 01A | 0003 0002 08 from user: Michael
[10:17:39][Debug] CLIENT Michael PERFORMING ACTION 14
[10:17:39][Info] parse: 061 | 0003 0002 02 from user: Michael
[10:18:02][Info] parse: 05E | 003B 003A 0C from user: Michael
[10:18:02][Info] Zoning from zone 0 to zone 234: Michael
[10:18:03][Info] parse: 00D | 003C 003B 04 from user: Michael
[10:18:03][Debug] CZone:: Residential_Area DecreaseZoneCounter <0> Michael
[10:18:05][Info] parse: 00A | 0001 0000 2E from user: Michael
[10:18:05][Debug] CZone:: Bastok_Mines IncreaseZoneCounter <1> Michael
[10:18:05][Info] parse: 011 | 0002 0001 04 from user: Michael
[10:18:07][Info] parse: 00C | 0003 0002 06 from user: Michael
[10:18:07][Info] parse: 061 | 0003 0002 02 from user: Michael
[10:18:07][Info] parse: 01A | 0003 0002 08 from user: Michael
[10:18:07][Debug] CLIENT Michael PERFORMING ACTION 14
[10:18:07][Info] parse: 0E0 | 0003 0002 4C from user: Michael
[10:18:07][Info] parse: 00F | 0003 0002 12 from user: Michael
[10:18:07][Info] parse: 0DB | 0003 0002 14 from user: Michael
[10:18:07][Info] parse: 05A | 0003 0002 02 from user: Michael
[10:18:34][Info] parse: 0F2 | 0043 0042 04 from user: Michael
[10:18:37][Info] parse: 01A | 0049 0048 08 from user: Michael
[10:18:37][Error] luautils::OnTrigger: cannot open scripts/zones/Bastok_Mines/npcs/_6ib.lua: No such file or directory
[10:18:37][Debug] CLIENT Michael PERFORMING ACTION 00
[10:18:47][Info] parse: 01A | 005F 005E 08 from user: Michael
[10:18:47][Debug] CLIENT Michael PERFORMING ACTION 00
[10:18:53][Info] parse: 083 | 006C 006B 08 from user: Michael
[10:18:53][Warning] charplugin::AddItem: Item <17307> is not found in a database
[10:19:12][Info] parse: 01A | 0098 0097 08 from user: Michael
[10:19:12][Error] luautils::OnTrigger: cannot open scripts/zones/Bastok_Mines/npcs/_6ib.lua: No such file or directory
[10:19:12][Debug] CLIENT Michael PERFORMING ACTION 00
[10:19:39][Info] parse: 05E | 00D8 00D7 0C from user: Michael
[10:19:39][Info] Zoning from zone 234 to zone 0: Michael
[10:19:39][Info] parse: 00D | 00D9 00D8 04 from user: Michael
[10:19:39][Debug] CZone:: Bastok_Mines DecreaseZoneCounter <0> Michael
[10:19:43][Info] parse: 00A | 0001 0000 2E from user: Michael
[10:19:43][Info] parse: 011 | 0002 0001 04 from user: Michael
[10:19:44][Info] parse: 00C | 0003 0002 06 from user: Michael
[10:19:44][Info] parse: 061 | 0003 0002 02 from user: Michael
[10:19:44][Info] parse: 0E0 | 0003 0002 4C from user: Michael
[10:19:44][Info] parse: 00F | 0003 0002 12 from user: Michael
[10:19:44][Info] parse: 0DB | 0003 0002 14 from user: Michael
[10:19:44][Info] parse: 05A | 0003 0002 02 from user: Michael
[10:19:44][Info] parse: 01A | 0003 0002 08 from user: Michael
[10:19:44][Debug] CLIENT Michael PERFORMING ACTION 14
[10:19:44][Info] parse: 061 | 0003 0002 02 from user: Michael
[10:19:48][Info] parse: 0E7 | 0009 0008 04 from user: Michael
[10:19:49][Info] parse: 00D | 000A 0009 04 from user: Michael
[10:19:49][Debug] CZone:: Residential_Area DecreaseZoneCounter <0> Michael
[10:19:51][Debug] map_close_session: session closed

I am demonstrating this project to a couple of our friends who might be interested in helping with it on Friday. If this problem can't be dealt with by then, could someone please send me commands to revert to a version that doesn't have this problem? I swear DS worked the last time I used it...

[PrBlahBlahtson]

[10:18:53][Warning] charplugin::AddItem: Item <17307> is not found in a database

I'm not much use on core coding, but are your item tables intact?

[msulli1355]

I THINK so.:
mysql> select name from item_basic where itemid=17307;
+------+
| name |
+------+
| dart |
+------+
1 row in set (0.01 sec)

It was a dart I was trying to buy.

[PrBlahBlahtson]

[10:15:06][Status] do_init: loading items[10:15:06][SQL] DB error - Unknown column 'u.aoe' in 'field list'
- [OK]
[10:15:06][Status] do_init: loading spells[10:15:06][SQL] DB error - Unknown column 'magicBurstMessage' in 'field list'
- [OK]

There's your problem, imo. I'm assuming you've been updating the SQL tables when applicable, so the columns should be present. Seems like something about Item AoE effects (r1540) and magic burst (r???) isn't quite meshing with the Linux compiled version. I'll bet skillchains and/or magic bursts won't function properly for you, if you test them. Looks like bluekirby0 has been doing a bit this afternoon, so there's hope that he's seen this and can figure out what's going on, since the Linux version seems to be something he's been working on. I'm afraid it's over my head at that point.