Help please. This is waaay beyond my expertise.
Starting with I have checked for errors, nils and everything else:
-
The years old program with the following code using REAL database works fine.
-
Same code with same REAL database after specifying SQLite works fine.
-
Create a new database with SQLite, code fails (on first record) after db.InsertRecord(“AntList”,r) statement and never gets to the db.Error statement.
..... (inp is a text file, r is a DatabaseRecord, AntList is a table) r.column("Manuf") = s r.column("LowMHz") = strip(inp.ReadLine) r.column("HiMHz") = strip(inp.ReadLine) r.column("MaxGaindBd") = strip(inp.ReadLine) r.column("AvailPol") = strip(inp.ReadLine) r.column("AntPol") = strip(inp.ReadLine) r.column("HhpbwDeg") = strip(inp.ReadLine) r.column("VhpbwDeg") = strip(inp.ReadLine) r.column("PatMHz") = strip(inp.ReadLine) db.InsertRecord("AntList",r) if db.Error then msgbox "Error GARALoop - Don't know what to do." quit end
Here is an excerpt of the error code.
Process: Obspat.debug [2232]
Path: /Obspat Security/Obspat.debug.app/Contents/MacOS/Obspat.debug
Identifier: ???
Version: ??? (16.0.3.0.0)
Code Type: X86 (Native)
Parent Process: launchd [145]
Responsible: Obspat.debug [2232]
User ID: 501
Date/Time: 2014-07-21 13:46:10.041 -0400
OS Version: Mac OS X 10.9.4 (13E28)
Report Version: 11
Anonymous UUID: 99294CED-C2AC-0BB5-6EBC-8B5D079557A9
Crashed Thread: 0 Dispatch queue: com.apple.main-thread
Exception Type: EXC_BAD_ACCESS (SIGBUS)
Exception Codes: KERN_PROTECTION_FAILURE at 0x0000000000000000
VM Regions Near 0:
–> __PAGEZERO 0000000000000000-0000000000001000 [ 4K] —/--- SM=NUL /Obspat Security/Obspat.debug.app/Contents/MacOS/Obspat.debug
__TEXT 0000000000001000-0000000000618000 [ 6236K] r-x/rwx SM=COW /Obspat Security/Obspat.debug.app/Contents/MacOS/Obspat.debug
Thread 0 Crashed:: Dispatch queue: com.apple.main-thread
0 RBSQLiteDatabase.xojo_plugin_0.dylib 0x05905d88 0x5900000 + 23944
1 rbframework.dylib 0x00727bd8 databaseInsertRecord + 72
2 Obspat.debug 0x00039555 Database.InsertRecord%%oso + 68
3 Obspat.debug 0x004806e0 wRebuild.wRebuild.GoAnt%%o<wRebuild.wRebuild> + 18601
4 Obspat.debug 0x0048841f wRebuild.wRebuild.init%b%o<wRebuild.wRebuild>o + 607
5 Obspat.debug 0x00576827 wBack.wBack.init%%o<wBack.wBack> + 139
6 Obspat.debug 0x00435d99 GlobalConstants_Methods.LoadContextMenu + 5573
7 Obspat.debug 0x00425020 GlobalConstants_Methods.GetPutPrefs%%b + 37865
8 Obspat.debug 0x001e0f82 App.Event_Open%%o + 481
9 rbframework.dylib 0x006ef2d5 0x69a000 + 348885
10 Obspat.debug 0x00009b5b Delegate.Invoke%% + 34
11 Obspat.debug 0x0008828a Application._CallFunctionWithExceptionHandling%%op + 248
12 rbframework.dylib 0x007227d4 0x69a000 + 559060
13 rbframework.dylib 0x006eda22 0x69a000 + 342562
14 Obspat.debug 0x0019bb6c REALbasic._RuntimeRegisterAppObject%%o + 48
15 Obspat.debug 0x000031fb _NewAppInstance + 264
16 Obspat.debug 0x000097f3 _EarlyStartup + 100
17 Obspat.debug 0x0000995e _Main + 153
18 Obspat.debug 0x0000253c % main + 36
19 Obspat.debug 0x005e10de _start + 116
20 Obspat.debug 0x005e1034 start + 43
Thread 1:: Dispatch queue: com.apple.libdispatch-manager
0 libsystem_kernel.dylib 0x99967992 kevent64 + 10
1 libdispatch.dylib 0x999e6899 _dispatch_mgr_invoke + 238
2 libdispatch.dylib 0x999e6532 _dispatch_mgr_thread + 52
Thread 0 crashed with X86 Thread State (32-bit):
eax: 0x0098fe30 ebx: 0x00000000 ecx: 0x00000000 edx: 0x05900fae
edi: 0x00000005 esi: 0x00000002 ebp: 0xbfffd398 esp: 0xbfffd310
ss: 0x00000023 efl: 0x00010282 eip: 0x05905d88 cs: 0x0000001b
ds: 0x00000023 es: 0x00000023 fs: 0x00000000 gs: 0x0000000f
cr2: 0x00000000
Logical CPU: 2
Error Code: 0x00000004
Trap Number: 14