| View previous topic :: View next topic |
| Author |
Message |
MacLir
Joined: 13 Jan 2005
Posts: 22
|
 Posted: Thu Jan 13, 2005 22:46 Post subject: I don't know what I've done wrong... |
 |
|
Quick Setup Reference:
- Win2k SP4 + current hotfixes
- MySQL 4.1.8
- MyODBC 3.51
- MySQL Administrator 1.0.19
- NWNx 2.60
- NWNx ODBC 0.91*
- NWNx Profiler 1.60*
* same results occured with 0.90 & 1.50 respectively
I'm posting all the relavent logs/ini's and the error log from DrWatson32. The only thing I've done was to; load the 'aps_demo' module, log in and use the signs. I've not modified a single thing. On trying to 'retrieve' the objects the server crashes. Any clues to what I've done wrong are greatly appreciated.
nwnx.ini
| Code: | ; NWNX2 configuration file
; These are the default values for NWNX2. Values specified on the command
; line take precedence.
[NWNX]
ServerPort = 5121
ModuleName = "aps_demo"
WatchdogProcess = yes
UpdateIntervalProcess = 5
WatchdogGamespy = yes
UpdateIntervalGamespy = 20
GamespyRetries = 5
OldGamespyProtocol = no
[ODBC2]
; Log file
MaxLogSize = 512 ; in KByte
LogLevel = 2 ; 0=nothing, 1=only errors, 2=everything
; Use these two settings for ODBC connections
source = odbc
dsn = nwn
; Use these five settings for MySQL connections
;source = mysql
;server = localhost
;user = nwn
;pwd = nwn
;db = nwn
; Set hookscorco to false if you want to disable hooking of
; StoreCampaignObject and RetrieveCampaignObject entirely
hookscorco = true
[PROFILER]
MaxLogSize = 512 ; in KByte
LogLevel = 2 ; 1=overall statistics, 2=full script callstack
|
nwnx.txt
| Code: | NWN Extender V.2.6.0
(c) 2004 by Ingmar Stieger (Papillon) and Jeroen Broekhuizen
visit us at http://www.nwnx.org
* Loading plugins...
* Plugin odbc is loaded.
* Plugin profiler is loaded.
* NWNX2 activated.
|
nwnx_odbc.txt
| Code: | NWNX ODBC2 plugin V.0.9.1.0
(c) 2005 by Ingmar Stieger (Papillon) and Jeroen Broekhuizen
visit us at http://www.nwnx.org
o Logfile maximum size limit is: 524288 bytes
o Log level: Everything will be logged.
o Using ODBC connection.
o Hooking SCO....hooked at 5c4320
o Hooking RCO....hooked at 5c4200
o Connect successful.
o Got request: DROP TABLE pwdata
! SQL Error: [MySQL][ODBC 3.51 Driver][mysqld-4.1.8-nt]Unknown table 'pwdata'
o Got request: CREATE TABLE pwdata (player varchar(64) NOT NULL default '~',tag varchar(64) NOT NULL default '~',name varchar(64) NOT NULL default '~',val text,expire int(11) default NULL,last timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,PRIMARY KEY (player,tag,name)) ENGINE=MyISAM DEFAULT CHARSET=latin1;
o Got request: SELECT player FROM pwdata WHERE player='MacLir' AND tag='Gwydion MacLir' AND name='demoName'
o Empty set
o Got request: INSERT INTO pwdata (player,tag,name,val,expire) VALUES('MacLir','Gwydion MacLir','demoName','testValue',0)
o Got request: SELECT val FROM pwdata WHERE player='MacLir' AND tag='Gwydion MacLir' AND name='demoName'
o Sent response (9 bytes): testValue
o Got request: DROP TABLE pwobjdata
! SQL Error: [MySQL][ODBC 3.51 Driver][mysqld-4.1.8-nt]Unknown table 'pwobjdata'
o Got request: CREATE TABLE pwobjdata (player varchar(64) NOT NULL default '~',tag varchar(64) NOT NULL default '~',name varchar(64) NOT NULL default '~',val blob,expire int(11) default NULL,last timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,PRIMARY KEY (player,tag,name)) ENGINE=MyISAM DEFAULT CHARSET=latin1;
o Got request: SELECT player FROM pwobjdata WHERE player='~' AND tag='Chest1' AND name='Item_0'
o Empty set
o Got request (scorco): INSERT INTO pwobjdata (player,tag,name,val,expire) VALUES('~','Chest1','Item_0',~s,0)
o Got request: SELECT player FROM pwobjdata WHERE player='~' AND tag='Chest1' AND name='Item_1'
o Empty set
o Got request (scorco): INSERT INTO pwobjdata (player,tag,name,val,expire) VALUES('~','Chest1','Item_1',~s,0)
o Got request: SELECT player FROM pwobjdata WHERE player='~' AND tag='Chest1' AND name='Item_2'
o Empty set
o Got request (scorco): INSERT INTO pwobjdata (player,tag,name,val,expire) VALUES('~','Chest1','Item_2',~s,0)
o Got request (scorco): SELECT val FROM pwobjdata WHERE player='~' AND tag='Chest1' AND name='Item_0'
o Got request (scorco): SELECT val FROM pwobjdata WHERE player='~' AND tag='Chest1' AND name='Item_1'
o Got request (scorco): SELECT val FROM pwobjdata WHERE player='~' AND tag='Chest1' AND name='Item_2'
|
nwnx_profiler.txt
| Code: | NWNX Profiler V.1.60
(c) 2005 by Ingmar Stieger (papillon@nwnx.org)
visit us at http://www.nwnx.org
* Updated entries are marked with a * symbol
* Logfile maximum size limit is: 524288 bytes
* Log level: Script callstack will be logged.
* RunScript hooked (symbol: >).
* Cross area pathfinding hooked (symbol: @)
* Tile pathfinding hooked (symbol: $)
aps_onload (calldepth 0)
demo_createtable (calldepth 0)
Current statistics
-----------------------------------------------------------------------------------------------
aps_onload 0 msec 1 calls *| demo_createtable 29 msec 1 calls *|
-----------------------------------------------------------------------------------------------
Elapsed time : 58042 msec
Runtime delta : 29 msec
Total cumulative runtime : 29 msec
Total number of scriptcalls : 2
demo_storevalue (calldepth 0)
demo_loadvalue (calldepth 0)
demo_obj_create (calldepth 0)
Current statistics
-----------------------------------------------------------------------------------------------
demo_obj_create 27 msec 1 calls *| aps_onload 0 msec 1 calls |
demo_storevalue 2 msec 1 calls *| demo_loadvalue 1 msec 1 calls *|
demo_createtable 29 msec 1 calls |
-----------------------------------------------------------------------------------------------
Elapsed time : 17443 msec
Runtime delta : 30 msec
Total cumulative runtime : 59 msec
Total number of scriptcalls : 5
demo_obj_storval (calldepth 0)
demo_obj_loadval (calldepth 0)
|
DrWatson32 Error Log
| Code: | Application exception occurred:
App: (pid=852)
When: 1/13/2005 @ 15:17:58.336
Exception number: c0000005 (access violation)
*----> System Information <----*
Computer Name: THE-TOWER
User Name: M
Number of Processors: 1
Processor Type: x86 Family 6 Model 4 Stepping 4
Windows 2000 Version: 5.0
Current Build: 2195
Service Pack: 4
Current Type: Uniprocessor Free
Registered Organization: M
Registered Owner: M
*----> Task List <----*
0 Idle.exe
8 System.exe
144 smss.exe
168 csrss.exe
188 WINLOGON.exe
216 services.exe
228 LSASS.exe
400 svchost.exe
432 SPOOLSV.exe
476 svchost.exe
508 nvsvc32.exe
568 regsvc.exe
616 mstask.exe
664 winmgmt.exe
696 svchost.exe
780 explorer.exe
952 remoterm.exe
968 iTouch.exe
1004 hpcmpmgr.exe
884 hpztsb10.exe
816 hpwuSchd2.exe
924 PCLEScheduler.e.exe
1076 mysqld-nt.exe
792 NWNX2.exe
852 nwserver.exe
756 nwmain.exe
844 drwtsn32.exe
304 rundll32.exe
0 _Total.exe
(00400000 - 05EDD000)
(77F80000 - 77FFD000)
(75030000 - 75044000)
(78000000 - 78045000)
(7C570000 - 7C623000)
(7C2D0000 - 7C332000)
(77D30000 - 77DA1000)
(75020000 - 75028000)
(77E10000 - 77E75000)
(77F40000 - 77F7B000)
(77A50000 - 77B3F000)
(75050000 - 75058000)
(77820000 - 77827000)
(759B0000 - 759B6000)
(75E60000 - 75E7A000)
(10000000 - 10011000)
(44400000 - 4441F000)
(779B0000 - 77A4B000)
(06990000 - 069B5000)
(1F7F0000 - 1F825000)
(76B30000 - 76B6E000)
(77C70000 - 77CB9000)
(77B50000 - 77BD9000)
(782F0000 - 78535000)
(069C0000 - 06AC8000)
(1F8E0000 - 1F8F6000)
(782C0000 - 782CC000)
(77980000 - 779A4000)
(77340000 - 77353000)
(77520000 - 77525000)
(77320000 - 77337000)
(75150000 - 7515F000)
(75170000 - 751BF000)
(7C340000 - 7C34F000)
(77BF0000 - 77C01000)
(77950000 - 7797A000)
(751C0000 - 751C6000)
(773B0000 - 773DF000)
(77380000 - 773A3000)
(77830000 - 7783E000)
(77880000 - 7790E000)
(7C0F0000 - 7C151000)
(774E0000 - 77513000)
(774C0000 - 774D1000)
(77530000 - 77552000)
(77360000 - 77379000)
(06EA0000 - 06FB2000)
(06FC0000 - 07016000)
(1F840000 - 1F85A000)
(777E0000 - 777E8000)
(777F0000 - 777F5000)
(74FD0000 - 74FEE000)
(75010000 - 75017000)
(07030000 - 07055000)
State Dump for Thread Id 0x404
eax=00000000 ebx=06780000 ecx=00000000 edx=06be6558 esi=06be4c78 edi=06be6558
eip=77fcc8e1 esp=0012fa54 ebp=0012fa60 iopl=0 nv up ei pl zr na po nc
cs=001b ss=0023 ds=0023 es=0023 fs=0038 gs=0000 efl=00000246
function: RtlFreeHeap
77fcc8c9 2410 and al,0x10
77fcc8cb a810 test al,0x10
77fcc8cd 884605 mov [esi+0x5],al ds:076deb5e=??
77fcc8d0 7547 jnz 77fd2019
77fcc8d2 57 push edi
77fcc8d3 53 push ebx
77fcc8d4 e8ca5bfbff call RtlConsoleMultiByteToUnicodeN+0x362 (77f824a3)
77fcc8d9 8b4f0c mov ecx,[edi+0xc] ds:076e043e=????????
77fcc8dc 8b4708 mov eax,[edi+0x8] ds:076e043e=????????
77fcc8df 3bc1 cmp eax,ecx
FAULT ->77fcc8e1 8901 mov [ecx],eax ds:00000000=????????
77fcc8e3 894804 mov [eax+0x4],ecx ds:00af9ee6=00000000
77fcc8e6 7457 jz 77fd533f
77fcc8e8 8a4705 mov al,[edi+0x5] ds:076e043e=??
77fcc8eb a804 test al,0x4
77fcc8ed 0f85a4350000 jne RtlZeroHeap+0x512 (77fcfe97)
77fcc8f3 0fb70f movzx ecx,word ptr [edi] ds:06be6558=0000
77fcc8f6 8b4510 mov eax,[ebp+0x10] ss:00c29946=00000000
77fcc8f9 0108 add [eax],ecx ds:00000000=????????
77fcc8fb 0fb70f movzx ecx,word ptr [edi] ds:06be6558=0000
77fcc8fe 294b28 sub [ebx+0x28],ecx ds:07279ee6=00000190
77fcc901 668b08 mov cx,[eax] ds:00000000=????
*----> Stack Back Trace <----*
FramePtr ReturnAd Param#1 Param#2 Param#3 Param#4 Function Name
0012FA60 77FCC774 06780000 06BE5330 0012FAD8 00000000 ntdll!RtlFreeHeap
0012FB0C 005F1112 06780000 00000000 06BE5338 07B5FE60 ntdll!RtlFreeHeap
0012FB54 005F070A 06BE5338 00583366 06BE5338 07B5B978 !<nosymbols>
00000022 00000000 00000000 00000000 00000000 00000000 !<nosymbols>
*----> Raw Stack Dump <----*
0012fa54 00 00 78 06 30 53 be 06 - 38 53 be 06 0c fb 12 00 ..x.0S..8S......
0012fa64 74 c7 fc 77 00 00 78 06 - 30 53 be 06 d8 fa 12 00 t..w..x.0S......
0012fa74 00 00 00 00 60 fe b5 07 - 38 53 be 06 05 00 00 00 ....`...8S......
0012fa84 28 7c b5 07 60 7b b7 07 - f8 53 b7 07 f8 53 b7 07 (|..`{...S...S..
0012fa94 00 00 78 06 09 00 00 00 - 00 00 00 00 01 06 00 00 ..x.............
0012faa4 01 01 00 00 01 02 00 00 - 01 ca b5 07 01 5a b5 07 .............Z..
0012fab4 38 fa 12 00 50 ca b5 07 - 04 fb 12 00 55 1f f8 77 8...P.......U..w
0012fac4 28 25 f8 77 00 00 78 06 - 17 00 00 00 00 11 5f 00 (%.w..x......._.
0012fad4 00 00 78 06 1c 03 00 00 - 01 8d b5 07 01 00 00 00 ..x.............
0012fae4 60 fe b5 07 6c fa 12 00 - 01 fc 12 00 38 fb 12 00 `...l.......8...
0012faf4 78 fa 12 00 a0 f6 12 00 - 44 fb 12 00 55 1f f8 77 x.......D...U..w
0012fb04 28 25 f8 77 01 00 00 00 - 54 fb 12 00 12 11 5f 00 (%.w....T....._.
0012fb14 00 00 78 06 00 00 00 00 - 38 53 be 06 60 fe b5 07 ..x.....8S..`...
0012fb24 38 53 be 06 05 00 00 00 - 00 00 00 00 60 fe b5 07 8S..........`...
0012fb34 05 00 00 00 00 fc 12 00 - 4c 6f 5f 00 a0 f6 12 00 ........Lo_.....
0012fb44 00 fc 12 00 4c 6f 5f 00 - c8 4d 62 00 ff ff ff ff ....Lo_..Mb.....
0012fb54 22 00 00 00 0a 07 5f 00 - 38 53 be 06 66 33 58 00 "....._.8S..f3X.
0012fb64 38 53 be 06 78 b9 b5 07 - 05 00 00 00 64 fd 12 00 8S..x.......d...
0012fb74 60 8c b7 07 10 5f 9e 07 - 20 8f b0 07 e8 0f b6 07 `...._.. .......
0012fb84 05 00 00 00 bc a4 9f 07 - 00 00 00 00 00 00 00 00 ................
State Dump for Thread Id 0x49c
eax=005f21cd ebx=067836a8 ecx=01020102 edx=01020102 esi=01020101 edi=01010101
eip=7c57b700 esp=0688fffc ebp=01020102 iopl=0 nv up ei pl nz na pe nc
cs=001b ss=0023 ds=0023 es=0023 fs=0038 gs=0000 efl=00000200
function: MulDiv
7c57b6eb d1f9 sar ecx,1
7c57b6ed 03c1 add eax,ecx
7c57b6ef 83d200 adc edx,0x0
7c57b6f2 59 pop ecx
7c57b6f3 3bd1 cmp edx,ecx
7c57b6f5 73d3 jnb PrivCopyFileExW+0x10f5 (7c58aeca)
7c57b6f7 f7f1 div ecx
7c57b6f9 f7d8 neg eax
7c57b6fb 7fcd jg MoveFileWithProgressA+0x196 (7c5879ca)
7c57b6fd c20c00 ret 0xc
7c57b700 33ed xor ebp,ebp
7c57b702 53 push ebx
7c57b703 50 push eax
7c57b704 6a00 push 0x0
7c57b706 e92bfcffff jmp lstrcmpiW+0x65 (7c57b336)
7c57b70b 90 nop
7c57b70c 33ed xor ebp,ebp
7c57b70e 50 push eax
7c57b70f 6a00 push 0x0
7c57b711 e9ead10100 jmp ProcessIdToSessionId+0x140 (7c598900)
7c57b716 8bff mov edi,edi
7c57b718 8b5c240c mov ebx,[esp+0xc] ss:07389ee3=00000000
*----> Stack Back Trace <----*
FramePtr ReturnAd Param#1 Param#2 Param#3 Param#4 Function Name
01020102 00000000 00000000 00000000 00000000 00000000 kernel32!MulDiv
*----> Raw Stack Dump <----*
0688fffc 00 00 00 00 9c 09 89 06 - 8c 02 89 06 bc 00 00 00 ................
0689000c 50 72 6f 63 65 73 73 33 - 32 4e 65 78 74 00 00 00 Process32Next...
0689001c 1c 00 89 06 1c 00 89 06 - a0 00 00 00 45 6e 75 6d ............Enum
0689002c 53 65 72 76 69 63 65 73 - 53 74 61 74 75 73 41 00 ServicesStatusA.
0689003c 3c 00 89 06 3c 00 89 06 - 80 00 00 00 45 6e 75 6d <...<.......Enum
0689004c 53 65 72 76 69 63 65 73 - 53 74 61 74 75 73 57 00 ServicesStatusW.
0689005c 5c 00 89 06 5c 00 89 06 - 60 00 00 00 4e 74 51 75 \...\...`...NtQu
0689006c 65 72 79 53 79 73 74 65 - 6d 49 6e 66 6f 72 6d 61 erySystemInforma
0689007c 74 69 6f 6e 00 00 00 00 - 84 00 89 06 84 00 89 06 tion............
0689008c 38 00 00 00 45 3a 5c 4e - 65 76 65 72 77 69 6e 74 8...E:\Neverwint
0689009c 65 72 4e 69 67 68 74 73 - 5c 53 65 72 76 65 72 5c erNights\Server\
068900ac 6e 77 73 65 72 76 65 72 - 2e 65 78 65 bc 00 00 00 nwserver.exe....
068900bc 3b 00 00 00 b8 e3 40 44 - 01 01 00 00 f0 1f 59 00 ;.....@D......Y.
068900cc 00 00 00 00 5a 0f 04 5f - c0 cf 00 10 00 00 00 00 ....Z.._........
068900dc 00 00 00 00 00 00 04 5f - 00 00 00 00 0a 00 04 5f ......._......._
068900ec 00 00 00 00 00 00 40 00 - f4 00 89 06 f4 00 89 06 ......@.........
068900fc 34 00 00 00 6d 41 48 2c - 20 50 72 6f 63 65 73 73 4...mAH, Process
0689010c 20 24 30 30 30 30 30 33 - 35 34 2c 20 41 50 49 20 $00000354, API
0689011c 24 30 30 35 35 30 65 36 - 34 00 00 00 13 00 00 00 $00550e64.......
0689012c 01 00 00 00 02 00 00 00 - 00 00 00 00 38 01 89 06 ............8...
State Dump for Thread Id 0x450
eax=778321fe ebx=00000004 ecx=0012e600 edx=00000000 esi=77f82873 edi=00000004
eip=77f8287e esp=06d8fd24 ebp=06d8fd70 iopl=0 nv up ei pl zr na po nc
cs=001b ss=0023 ds=0023 es=0023 fs=0038 gs=0000 efl=00000246
function: NtWaitForMultipleObjects
77f82873 b8e9000000 mov eax,0xe9
77f82878 8d542404 lea edx,[esp+0x4] ss:07889c0b=8a3ec000
77f8287c cd2e int 2e
77f8287e c21400 ret 0x14
*----> Stack Back Trace <----*
FramePtr ReturnAd Param#1 Param#2 Param#3 Param#4 Function Name
06D8FD70 7C59A0C2 06D8FD48 00000001 00000000 00000000 ntdll!NtWaitForMultipleObjects
06D8FFB4 7C57B388 00000005 77F8884E 00132B18 0015B710 kernel32!WaitForMultipleObjects
06D8FFEC 00000000 778321FE 0015B710 00000000 000000C8 kernel32!lstrcmpiW
*----> Raw Stack Dump <----*
06d8fd24 af a1 59 7c 04 00 00 00 - 48 fd d8 06 01 00 00 00 ..Y|....H.......
06d8fd34 00 00 00 00 00 00 00 00 - 01 00 00 00 10 b7 15 00 ................
06d8fd44 01 00 00 00 04 01 00 00 - 08 01 00 00 18 01 00 00 ................
06d8fd54 7c 01 00 00 40 cf 8c f8 - ac 32 05 f8 a8 32 05 f8 |...@....2...2..
06d8fd64 78 01 00 00 11 00 00 00 - 02 00 00 00 b4 ff d8 06 x...............
06d8fd74 c2 a0 59 7c 48 fd d8 06 - 01 00 00 00 00 00 00 00 ..Y|H...........
06d8fd84 00 00 00 00 00 00 00 00 - b2 22 83 77 04 00 00 00 .........".w....
06d8fd94 b0 fe d8 06 00 00 00 00 - ff ff ff ff 10 b7 15 00 ................
06d8fda4 18 2b 13 00 4e 88 f8 77 - 00 04 00 00 9c 6c 05 bd .+..N..w.....l..
06d8fdb4 00 00 00 00 00 00 00 00 - 01 00 00 00 38 00 00 00 ............8...
06d8fdc4 23 00 00 00 23 00 00 00 - 4e 88 f8 77 18 2b 13 00 #...#...N..w.+..
06d8fdd4 10 b7 15 00 00 00 00 00 - 00 e6 12 00 fe 21 83 77 .............!.w
06d8fde4 0c 00 0d 00 00 b7 57 7c - 1b 00 00 00 00 02 00 00 ......W|........
06d8fdf4 fc ff d8 06 23 00 00 00 - 9c d8 48 80 05 df 48 80 ....#.....H...H.
06d8fe04 a8 1e 04 f8 e9 de 48 80 - 00 04 00 00 9c 6c 05 bd ......H......l..
06d8fe14 00 00 00 00 40 cf 8c f8 - 3c 6d 05 bd 20 89 f8 e1 ....@...<m.. ...
06d8fe24 90 00 00 00 3c 6d 05 bd - 3c 6d 05 bd 3c 6d 05 bd ....<m..<m..<m..
06d8fe34 c0 eb 45 80 00 09 40 80 - ff ff ff ff 7c 6b 05 bd ..E...@.....|k..
06d8fe44 10 53 4d 80 a8 1e 04 f8 - 68 6b 05 bd c0 32 05 f8 .SM.....hk...2..
06d8fe54 00 00 00 00 00 00 00 00 - 6c a6 01 c0 00 a0 c7 18 ........l.......
State Dump for Thread Id 0x430
eax=74fd6311 ebx=001488e8 ecx=004e0049 edx=00000000 esi=74fea3a0 edi=00000000
eip=77f8289c esp=0772ff84 ebp=0772ffb4 iopl=0 nv up ei pl nz na pe nc
cs=001b ss=0023 ds=0023 es=0023 fs=0038 gs=0000 efl=00000202
function: ZwRemoveIoCompletion
77f82891 b8a8000000 mov eax,0xa8
77f82896 8d542404 lea edx,[esp+0x4] ss:08229e6b=????????
77f8289a cd2e int 2e
77f8289c c21400 ret 0x14
*----> Stack Back Trace <----*
FramePtr ReturnAd Param#1 Param#2 Param#3 Param#4 Function Name
0772FFB4 7C57B388 74FDA505 FFFFFFFF 0012FA80 001488E8 ntdll!ZwRemoveIoCompletion
0772FFEC 00000000 00000000 00000000 00000000 00000000 kernel32!lstrcmpiW
State Dump for Thread Id 0x2ac
eax=000007a8 ebx=00000000 ecx=00000173 edx=00000000 esi=77f82865 edi=000001b0
eip=77f82870 esp=0782ff64 ebp=0782ff88 iopl=0 nv up ei pl zr na po nc
cs=001b ss=0023 ds=0023 es=0023 fs=0038 gs=0000 efl=00000246
function: NtWaitForSingleObject
77f82865 b8ea000000 mov eax,0xea
77f8286a 8d542404 lea edx,[esp+0x4] ss:08329e4b=????????
77f8286e cd2e int 2e
77f82870 c20c00 ret 0xc
*----> Stack Back Trace <----*
FramePtr ReturnAd Param#1 Param#2 Param#3 Param#4 Function Name
0782FF88 7C57B3DB 000001B0 FFFFFFFF 00000000 75034D2A ntdll!NtWaitForSingleObject
77F82060 8B000000 83042454 0F00147A 017B9C85 42FF9000 kernel32!WaitForSingleObject
180D8B64 00000000 00000000 00000000 00000000 00000000 <nosymbols>
*----> Raw Stack Dump <----*
0782ff64 e4 9f 59 7c b0 01 00 00 - 00 00 00 00 00 00 00 00 ..Y|............
0782ff74 80 8c 14 00 80 8c 14 00 - d0 17 04 75 00 a0 fd 7f ...........u....
0782ff84 00 a0 fd 7f 60 20 f8 77 - db b3 57 7c b0 01 00 00 ....` .w..W|....
0782ff94 ff ff ff ff 00 00 00 00 - 2a 4d 03 75 b0 01 00 00 ........*M.u....
0782ffa4 ff ff ff ff ff ff ff ff - f8 fa 12 00 ec ff 82 07 ................
0782ffb4 80 8c 14 00 88 b3 57 7c - b0 01 00 00 ff ff ff ff ......W|........
0782ffc4 f8 fa 12 00 80 8c 14 00 - 00 a0 fd 7f 49 00 4e 00 ............I.N.
0782ffd4 c0 ff 82 07 49 00 4e 00 - ff ff ff ff 44 1f 5c 7c ....I.N.....D.\|
0782ffe4 08 2b 57 7c 00 00 00 00 - 00 00 00 00 00 00 00 00 .+W|............
0782fff4 fa 4c 03 75 80 8c 14 00 - 00 00 00 00 08 00 00 00 .L.u............
07830004 03 01 00 00 ee ff ee ff - 00 00 00 00 00 00 78 06 ..............x.
07830014 00 70 0b 00 00 00 83 07 - 00 04 00 00 40 00 83 07 .p..........@...
07830024 00 00 c3 07 b7 00 00 00 - 01 00 00 00 98 05 78 06 ..............x.
07830034 00 00 00 00 a8 8f b7 07 - 00 00 00 00 a3 2b 08 00 .............+..
07830044 03 01 08 00 32 44 41 20 - 56 32 2e 30 20 20 20 20 ....2DA V2.0
07830054 20 20 20 20 20 20 20 20 - 20 20 20 20 20 20 20 20
07830064 20 20 20 20 20 20 20 20 - 20 20 20 20 20 20 20 20
07830074 20 20 20 20 20 20 20 20 - 20 20 20 20 20 20 20 20
07830084 20 20 20 20 20 20 20 20 - 20 20 20 20 20 20 20 20
07830094 20 20 20 20 20 20 20 20 - 20 20 20 20 20 20 20 20
|
|
|
| Back to top |
|
 |
Papillon
x-man
Joined: 28 Dec 2004
Posts: 1060
Location: Germany
|
| Posted: Thu Jan 13, 2005 23:39 Post subject: |
|
|
Hmm, strange. I think you did nothing wrong. Could you do me a favour and modify the demo_obj_loadval script so that it tries to load only 1 or 2 items (try "method 1" for example). Does it still crash ?
_________________
Papillon |
|
| Back to top |
|
|
dguntner
Joined: 31 Dec 2004
Posts: 116
|
| Posted: Fri Jan 14, 2005 1:20 Post subject: |
|
|
| Hey Pap, I noticed in his printout that it did a DROP TABLE pwobject and then a CREATE TABLE. Why is it doing that? And how do you keep it from dropping the table every single time? |
|
| Back to top |
|
|
Manuel
Joined: 30 Dec 2004
Posts: 51
|
| Posted: Fri Jan 14, 2005 4:44 Post subject: |
|
|
The demo mod is suppoesed to create the pwdata table for you as a final part of the installation. Comon convention is to do a drop bfore a create. Likewise, there are deletes before inserts in the subsequent SQL statements. So, this is correct behavior. You really only need to touch that sign once.
_________________
I only know enough to be dangerous. |
|
| Back to top |
|
|
MacLir
Joined: 13 Jan 2005
Posts: 22
|
| Posted: Fri Jan 14, 2005 8:50 Post subject: |
|
|
Each item retrieved without a crash when done individually...
I even tried setting a 'for' loop; no go, it still crashed...
Now I'm completely lost...  |
|
| Back to top |
|
|
Asmodae
Joined: 07 Jan 2005
Posts: 55
|
| Posted: Fri Jan 14, 2005 10:59 Post subject: |
|
|
Have you noticed any other problems with your PC in general? Strange crashes or memory errors? Its possible that the problem is systemic rather than with NWNX, especially if you've changed nothing. Lets not forget the possibility of spyware/virii doing strange things in memory, anything like that could be possible.
_________________
Nepenthe - An NWN2 Persistant World, coming to a planet near you. http://www.nepentheonline.com |
|
| Back to top |
|
|
Papillon
x-man
Joined: 28 Dec 2004
Posts: 1060
Location: Germany
|
| Posted: Fri Jan 14, 2005 14:01 Post subject: |
|
|
MacLir, does that mean you can not retrieve two objects after another without a crash ? I suspect a bug there, but I am not able to reproduce the crash on my development machine. Is anyone else experiencing this problem ?
_________________
Papillon |
|
| Back to top |
|
|
MacLir
Joined: 13 Jan 2005
Posts: 22
|
| Posted: Fri Jan 14, 2005 14:17 Post subject: |
|
|
| Papillon wrote: | | MacLir, does that mean you can not retrieve two objects after another without a crash? I suspect a bug there, but I am not able to reproduce the crash on my development machine. Is anyone else experiencing this problem? |
Correct. It retrieves all of the items individually but the moment I set it back to retrieve all of them... crash...
| Asmodae wrote: | | Have you noticed any other problems with your PC in general? Strange crashes or memory errors? Its possible that the problem is systemic rather than with NWNX, especially if you've changed nothing. |
No; no funny happenings, odd app crashs, system quirks, etc. If there were I'd have already formatted the machine and started fresh... Not that this installation is more than a month old; I build-my-own so all quirks are gone. 
| Asmodae wrote: | | Lets not forget the possibility of spyware/virii doing strange things in memory, anything like that could be possible. |
Just checked prior to posting to ensure it wasn't something of that nature, 3 spyware and 3 anti-virii apps all reported all is well... My process list has the correct stuff in it with nothing new listed, I keep close tabs on that.
Just recently wiped the prior MySQL installation out, it was the 'recommended' essentials install. I downloaded the 'full' version and reinstalled. Started NWNx went in and repeated the process and still getting the crash on retrieval...
I'm completely at a loss at this point. >.< |
|
| Back to top |
|
|
MacLir
Joined: 13 Jan 2005
Posts: 22
|
| Posted: Sat Jan 15, 2005 1:01 Post subject: |
|
|
After testing some, I've discovered that should I set it to retrieve each item individually, I have no problems. <--(mentioned previously) If I set it to retrieve 'Item_0' and 'Item_1' consecutively, it retrieves them. But, when I set it to retrieve 'Item_0', 'Item_1', and 'Item_2' consecutively; it crashes. So, a single item will retrieve as well as two consecutively, but 3 consecutively is where I crash...
Basically, my next idea will take me a bit to come up with... Essentially what I'm thinking is: I count all objects to be stored, then save the count along with the items to be stored, and finally on retrieval pull the number first then execute the successive calls individually in an external manner, ie. a secondary script that is set to only create a single item at a time...
I haven't the time to put it together this weekend, but if it works I'll let you all know. Thanks for all the help so far, its greatly appreciated.  |
|
| Back to top |
|
|
MacLir
Joined: 13 Jan 2005
Posts: 22
|
| Posted: Sun Jan 16, 2005 18:17 Post subject: |
|
|
Ok, I sleep very little last night...
At the suggestion that it might be a systemic problem, I thought "No, nothing's wrong." Then I got to thinking about it and figured I might as well rule that out also. So, late last evening I formatted and reinstalled Win2k. After that I put the game back in, then NWNX & MySQL. I still got the same errors.
This morning I noticed that there's a new version. So, I download and set it up. Now I have an error from NWNx when I tell it to use MySQL and change the scripts. The log stated that there was an OnCreate error and could not initialise the odbc plugin... So, I set it back to default in the ini and put the aps_demo from the zip back in the server's modules directory. Now that the whole thing is fully default I can use the SQLite db. But it still shares the 3 item error... Where MySQL showed all 3 retrieve calls to it, SQLite only shows the first 2.
Any ideas what is happening? It seems to me that I'm not doing something correct, but I've followed the instructions for MySQL and even just left everything plain for SQLite but I'm still crashing... |
|
| Back to top |
|
|
Acrodania
Joined: 02 Jan 2005
Posts: 208
|
| Posted: Sun Jan 16, 2005 19:48 Post subject: |
|
|
I have a suggestion....
Try stepping back (uninstalling then re-installing) MySQL to one of the 4.0X versions instead of 4.1X
I loaded a new machine last night with version 4.16 and several of my "normal" utilities, including MySQL Front, wouldn't work with it. Went back to 4.0.18 and it worked fine. I didn't get a chance to try NWNX (since I couldn't even manipulate the database) but it almost looks like they altered something in how MySQL handles its connections.
Luck! |
|
| Back to top |
|
|
Papillon
x-man
Joined: 28 Dec 2004
Posts: 1060
Location: Germany
|
| Posted: Sun Jan 16, 2005 20:09 Post subject: |
|
|
That is probably not the problem, I am on 4.1 as well and still are not able to reproduce these crashes. MacLir, I have been thinking about this problem, but I do not have any idea yet. Could this be related to the ODBC2 fetchmode, where no SQL statement is executed but the cursor just advances to the next row ?
_________________
Papillon |
|
| Back to top |
|
|
Papillon
x-man
Joined: 28 Dec 2004
Posts: 1060
Location: Germany
|
| Posted: Sun Jan 16, 2005 20:11 Post subject: |
|
|
Another thing to try: Do you crash on the third object, or on the _last_ object ? Please try it with five or six item in the chest.
_________________
Papillon |
|
| Back to top |
|
|
Blayde Windwalker
Joined: 02 Jan 2005
Posts: 18
|
| Posted: Sun Jan 16, 2005 20:55 Post subject: MySQL 4.0.23 |
|
|
I couild not get things to work with the latest MySQL 4.1.xx either.
Once I reverted to 4.0.23 things came up fine. You might try using this release and see if it solves your problems. |
|
| Back to top |
|
|
MacLir
Joined: 13 Jan 2005
Posts: 22
|
| Posted: Mon Jan 17, 2005 2:55 Post subject: |
|
|
| Acrodania wrote: | | Try stepping back (uninstalling then re-installing) MySQL to one of the 4.0X versions instead of 4.1X |
| Blayde Windwalker wrote: | | Once I reverted to 4.0.23 things came up fine. You might try using this release and see if it solves your problems. |
4.0.23 gave me the same problems. 
| Papillon wrote: | | Could this be related to the ODBC2 fetchmode, where no SQL statement is executed but the cursor just advances to the next row ? |
You're asking the village SQL idiot... I'm trying to learn how to use SQL as I'm going here... Getting this working is what will hopefully *crosses fingers* help speed that process. I understand 'generally' what that question is, but I've not the knowledge to answer it...
Sorry. 
| Papillon wrote: | | Another thing to try: Do you crash on the third object, or on the _last_ object ? Please try it with five or six item in the chest. |
Did what you asked, results:
MySQL - 3 items - Log shows all 3 retrieve requests
SQLite - 3 items - Log only shows 2 retrieve requests
SQLite - 5 items - Log shows retrieve requests for a total of 6 items
SQLite - 6 items - Log only shows 3 retrieve requests
I've noticed that the newer either app or odbc plugin now shows RtlFreeHeap as the error in DrWatson32 instead of <nosymbols>. I'm not a programmer, so I don't know how helpful that is. If you'd like I can repost one of the newer DrWatson32 error logs...
Thanks for all of the help so far.
If anyone has any other ideas, I'm willing to try them...  |
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
Powered by phpBB © 2001, 2005 phpBB Group
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
