14.11.2014, 21:11
Hi guys,
I have problem with SQLite load system. So, if I have 24 fields(eg.) and all fields aren't empty. And I add one- two or three fields(it isn't important how much) and that new fields I don't fill with some string or int/float value. With that empty field(s) I can't start server normally, server just crash when it load ''empty field(s)''.
So, my question is, how I can bypass/avoid empty field(s). If I have in users table 5000 users(eg.) and I add several fields, how server it can load without crash? I don't have a time to fill field(s) for every user.
I uses SqwliteBrowser for management the base. Below you can see the crash code. Thanks very much.
I have problem with SQLite load system. So, if I have 24 fields(eg.) and all fields aren't empty. And I add one- two or three fields(it isn't important how much) and that new fields I don't fill with some string or int/float value. With that empty field(s) I can't start server normally, server just crash when it load ''empty field(s)''.
So, my question is, how I can bypass/avoid empty field(s). If I have in users table 5000 users(eg.) and I add several fields, how server it can load without crash? I don't have a time to fill field(s) for every user.
I uses SqwliteBrowser for management the base. Below you can see the crash code. Thanks very much.
Код:
-------------------------- SA-MP Server: 0.3z-R4 Exception At Address: 0x0046ED61 Module: (samp-server.exe) Registers: EAX: 0x04799AD4 EBX: 0x0018F800 ECX: 0x03660020 EDX: 0x00000002 ESI: 0x00000000 EDI: 0x04799AD4 EBP: 0x0018F830 ESP: 0x0018F7E4 EFLAGS: 0x00010202 Stack: +0000: 0x02CB40D2 0x0000000E 0x0044DF16 0x0059A490 +0010: 0x010FCB18 0x00000000 0x00000002 0x656D6147 +0020: 0x7473614D 0x00007265 0x0059A490 0x0059A490 +0030: 0x036617B0 0x02CB5A84 0x0000000A 0x02CB40E0 +0040: 0x0000002C 0x0018F800 0x0478E310 0x036915D8 +0050: 0x004010B6 0x0059A490 0x04799AC0 0x0369CFBC +0060: 0x00402B63 0x0059A490 0x0000003A 0x0018F868 +0070: 0x04799AC0 0x0018FB5C 0x0059A490 0x00000000 +0080: 0x00000000 0x02CB40E0 0x010107E8 0x010FCB04 +0090: 0x010FCF34 0x010F8F54 0x010FCCD4 0x010F8F54 +00A0: 0x036617B0 0x0369CFBC 0x00000000 0x03660020 +00B0: 0x0003B80C 0x0046E161 0x0059A490 0x0018F8E8 +00C0: 0x0000001C 0x0059A490 0x00000000 0x0059A490 +00D0: 0x00000001 0x0059A490 0x00000001 0x0059A490 +00E0: 0xFFFFFFFF 0x0059A490 0x0018F904 0x0018F8EC +00F0: 0x0018FA40 0x04795EF4 0x00000000 0x0018FB41 +0100: 0x0059A490 0x00000000 0x04795EF4 0x0048E4C2 +0110: 0x0000001C 0x00000001 0x00000001 0xFFFFFFFF +0120: 0x010F8F38 0x005111E8 0x0018FB68 0x02CF9F01 +0130: 0x0018FB70 0x0106FC54 0x0051FFFF 0x00000001 -------------------------- Loaded Modules: samp-server.exe A: 0x00400000 - 0x004F6000 (E:\Silvio\Projekti\Pawno\GameModovi\Od nula\Haswell RolePlay\samp-server.exe) ntdll.dll A: 0x76F10000 - 0x77090000 (C:\Windows\SysWOW64\ntdll.dll) kernel32.dll A: 0x74E80000 - 0x74F90000 (C:\Windows\syswow64\kernel32.dll) KERNELBASE.dll A: 0x74D00000 - 0x74D47000 (C:\Windows\syswow64\KERNELBASE.dll) SHELL32.dll A: 0x75E80000 - 0x76ACA000 (C:\Windows\syswow64\SHELL32.dll) msvcrt.dll A: 0x75030000 - 0x750DC000 (C:\Windows\syswow64\msvcrt.dll) SHLWAPI.dll A: 0x74AD0000 - 0x74B27000 (C:\Windows\syswow64\SHLWAPI.dll) GDI32.dll A: 0x74DF0000 - 0x74E80000 (C:\Windows\syswow64\GDI32.dll) USER32.dll A: 0x750E0000 - 0x751E0000 (C:\Windows\syswow64\USER32.dll) ADVAPI32.dll A: 0x74F90000 - 0x75030000 (C:\Windows\syswow64\ADVAPI32.dll) sechost.dll A: 0x74B90000 - 0x74BA9000 (C:\Windows\SysWOW64\sechost.dll) RPCRT4.dll A: 0x75270000 - 0x75360000 (C:\Windows\syswow64\RPCRT4.dll) SspiCli.dll A: 0x74A70000 - 0x74AD0000 (C:\Windows\syswow64\SspiCli.dll) CRYPTBASE.dll A: 0x74A60000 - 0x74A6C000 (C:\Windows\syswow64\CRYPTBASE.dll) LPK.dll A: 0x74DE0000 - 0x74DEA000 (C:\Windows\syswow64\LPK.dll) USP10.dll A: 0x74C60000 - 0x74CFD000 (C:\Windows\syswow64\USP10.dll) WSOCK32.dll A: 0x73560000 - 0x73567000 (C:\Windows\system32\WSOCK32.dll) WS2_32.dll A: 0x76AD0000 - 0x76B05000 (C:\Windows\syswow64\WS2_32.dll) NSI.dll A: 0x75360000 - 0x75366000 (C:\Windows\syswow64\NSI.dll) WINMM.dll A: 0x71B60000 - 0x71B92000 (C:\Windows\system32\WINMM.dll) IMM32.DLL A: 0x74B30000 - 0x74B90000 (C:\Windows\system32\IMM32.DLL) MSCTF.dll A: 0x75BE0000 - 0x75CAC000 (C:\Windows\syswow64\MSCTF.dll) streamer.DLL A: 0x74110000 - 0x7414F000 (E:\Silvio\Projekti\Pawno\GameModovi\Od nula\Haswell RolePlay\plugins\streamer.DLL) MSVCP100.dll A: 0x740A0000 - 0x74109000 (C:\Windows\system32\MSVCP100.dll) MSVCR100.dll A: 0x73700000 - 0x737BF000 (E:\Silvio\Projekti\Pawno\GameModovi\Od nula\Haswell RolePlay\MSVCR100.dll) sscanf.DLL A: 0x10000000 - 0x1000D000 (E:\Silvio\Projekti\Pawno\GameModovi\Od nula\Haswell RolePlay\plugins\sscanf.DLL) whirlpool.DLL A: 0x002B0000 - 0x002BC000 (E:\Silvio\Projekti\Pawno\GameModovi\Od nula\Haswell RolePlay\plugins\whirlpool.DLL) MSVCR80.dll A: 0x714F0000 - 0x7158B000 (C:\Windows\WinSxS\x86_microsoft.vc80.crt_1fc8b3b9a1e18e3b_8.0.50727.4940_none_d08cc06a442b34fc\MSVCR80.dll) mswsock.dll A: 0x73460000 - 0x7349C000 (C:\Windows\system32\mswsock.dll) wshtcpip.dll A: 0x73450000 - 0x73455000 (C:\Windows\System32\wshtcpip.dll) NLAapi.dll A: 0x74490000 - 0x744A0000 (C:\Windows\system32\NLAapi.dll) napinsp.dll A: 0x70750000 - 0x70760000 (C:\Windows\system32\napinsp.dll) pnrpnsp.dll A: 0x70860000 - 0x70872000 (C:\Windows\system32\pnrpnsp.dll) DNSAPI.dll A: 0x749F0000 - 0x74A34000 (C:\Windows\system32\DNSAPI.dll) winrnr.dll A: 0x70840000 - 0x70848000 (C:\Windows\System32\winrnr.dll) IPHLPAPI.DLL A: 0x72D80000 - 0x72D9C000 (C:\Windows\system32\IPHLPAPI.DLL) WINNSI.DLL A: 0x72750000 - 0x72757000 (C:\Windows\system32\WINNSI.DLL) rasadhlp.dll A: 0x749E0000 - 0x749E6000 (C:\Windows\system32\rasadhlp.dll)