[HELP] SQLite empy field - Printable Version
+- SA-MP Forums Archive (
https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (
https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (
https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: [HELP] SQLite empy field (
/showthread.php?tid=546333)
[HELP] SQLite empy field -
vannesenn - 14.11.2014
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.
Код:
--------------------------
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)
Re: [HELP] SQLite empy field -
vannesenn - 15.11.2014
Sorry but I still don't understand how start server without crash