 |
oldguy2
Wizard
Joined: 17 Jun 2006
Posts: 1201
|
 Posted: Sat Sep 25, 2010 3:34 am
[3.29b] SQL Error: SQL logic error or missing database.
|
| Code: |
date/time : 2010-09-24, 22:31:29, 687ms
operating system : Windows XP Service Pack 3 build 2600
system language : English
system up time : 7 hours 51 minutes
program up time : 41 minutes 38 seconds
processor : AMD Athlon(tm) 64 Processor 3800+
physical memory : 1383/2047 MB (free/total)
free disk space : (C:) 124.37 GB
display mode : 1440x900, 32 bit
process id : $fb4
allocated memory : 67.20 MB
executable : cMUD.exe
exec. date/time : 2010-09-24 15:14
version : 3.29.0.2
compiled with : BCB 2006/07
madExcept version : 3.0k
callstack crc : $09cb2bc4, $2e745afe, $2e745afe
exception number : 1
exception class : EZSQLException
exception message : SQL Error: SQL logic error or missing database.
Main ($4dc):
008a7b28 +00f8 cMUD.exe ZDbcSqLiteUtils 229 +14 CheckSQLiteError
008b09fd +0085 cMUD.exe ZDbcSqLiteStatement 177 +8 TZSQLiteStatement.ExecuteQuery
008a25a2 +0036 cMUD.exe ZDbcStatement 1984 +1 TZEmulatedPreparedStatement.ExecuteQuery
008a26a3 +002f cMUD.exe ZDbcStatement 2025 +1 TZEmulatedPreparedStatement.ExecuteQueryPrepared
0090f5e4 +01a4 cMUD.exe ZAbstractRODataset 1564 +25 TZAbstractRODataset.CreateResultSet
0090f6e6 +00a2 cMUD.exe ZAbstractRODataset 1588 +12 TZAbstractRODataset.InternalOpen
00514b1d +0019 cMUD.exe DB TDataSet.DoInternalOpen
00514bd6 +001e cMUD.exe DB TDataSet.OpenCursor
00514a91 +0055 cMUD.exe DB TDataSet.SetActive
00514889 +0009 cMUD.exe DB TDataSet.Open
00a153d4 +00f8 cMUD.exe SQLiteUtils 285 +24 ExecSQLite
00dae790 +0194 cMUD.exe MapLoc3 865 +23 TMapLoc.FindRoomID
00daec72 +01ba cMUD.exe MapLoc3 933 +19 TMapLoc.ParseRoomNum
00daef25 +00b1 cMUD.exe MapLoc3 994 +9 TMapLoc.RoomFunc
00d422f2 +2f4e cMUD.exe MAIN 15943 +442 TMUDForm.ExecFunction
00df931b +010b cMUD.exe CodeExec 1015 +16 ExecMUDFunction
00dfe7f1 +05ed cMUD.exe CodeExec 2433 +91 HandleFunc
00dfe98d +0035 cMUD.exe CodeExec 2479 +5 HandleFuncRef
00e03a25 +0671 cMUD.exe CodeExec 3801 +114 TCodeExec.InternalExecute
00df8600 +0070 cMUD.exe CodeExec 612 +9 TCodeExec.Expression
00dfddcc +0014 cMUD.exe CodeExec 2215 +1 BoolExpression
00e00a30 +0254 cMUD.exe CodeExec 2971 +10 HandleCom
00e03a49 +0695 cMUD.exe CodeExec 3804 +117 TCodeExec.InternalExecute
00df8293 +0053 cMUD.exe CodeExec 524 +8 TCodeExec.Execute
00debffa +00c2 cMUD.exe PrefDat 11131 +9 TCacheNode.Execute
00de81e3 +035f cMUD.exe PrefDat 9532 +61 PrefRec.InternalExecute
00de844b +001f cMUD.exe PrefDat 9590 +2 PrefRec.Execute
00d24093 +0153 cMUD.exe MAIN 6837 +14 TMUDForm.ExecThread
00d2c794 +0530 cMUD.exe MAIN 9769 +101 TMUDForm.ExecTrig
00d296bc +13ec cMUD.exe MAIN 8791 +342 TMUDForm.HandleTrigger
00d27d9b +000f cMUD.exe MAIN 8271 +1 TMUDForm.UserOutNewLine
00a7c65b +0067 cMUD.exe term 9801 +6 TTerm.DoTriggerLine
00a7af8a +020e cMUD.exe term 9359 +34 HandleNewLine
00a7b7e9 +06e1 cMUD.exe term 9487 +104 TTerm.PutText
00a7bdcb +0053 cMUD.exe term 9594 +2 TTerm.Add
00d1170e +00b6 cMUD.exe MAIN 1887 +8 TMUDForm.OutputStr
00404dcc +0008 cMUD.exe System 28 +0 TObject.Free
00d11ac3 +01ab cMUD.exe MAIN 1986 +39 TMUDForm.NextMUDLine
00d11f96 +0022 cMUD.exe MAIN 2068 +4 TMUDForm.DoNextLine
004bc14b +02bb cMUD.exe Controls TControl.WndProc
004c014f +04fb cMUD.exe Controls TWinControl.WndProc
004a26af +0553 cMUD.exe Forms TCustomForm.WndProc
004bf878 +002c cMUD.exe Controls TWinControl.MainWndProc
0047d4dc +0014 cMUD.exe Classes StdWndProc
7e4196c2 +000a USER32.dll DispatchMessageA
004aa824 +00fc cMUD.exe Forms TApplication.ProcessMessage
004aa85e +000a cMUD.exe Forms TApplication.HandleMessage
004aab53 +00b3 cMUD.exe Forms TApplication.Run
00e93094 +0088 cMUD.exe CMUD 372 +20 initialization
7c912c21 +0069 ntdll.dll RtlUnicodeStringToAnsiString
error details:
Was simply walking. |
|
|
|
|
|
oldguy2
Wizard
Joined: 17 Jun 2006
Posts: 1201
|
Posted: Sat Sep 25, 2010 3:34 am
|
Also I do not use any SQL scripts or commands.
|
|
|
|
|
Tech
GURU
Joined: 18 Oct 2000
Posts: 2733
Location: Atlanta, USA
|
Posted: Sat Sep 25, 2010 6:19 am
|
This looks like a mapper look up for either vNum or roomID failed.
|
|
_________________
Asati di tempari! |
 |
|
|
Zugg
MASTER
Joined: 25 Sep 2000
Posts: 23379
Location: Colorado, USA
|
Posted: Sat Sep 25, 2010 4:33 pm
|
Looks like you have a trigger firing that is using a %room function when no map database is open. If you can find more details on your script, I can look at see if this is something I can fix. It certainly shouldn't crash when the mapper is closed, but I would need to know which %room function is being called.
Edited: Oh, actually it looks like maybe it is looking for a room by it's short name ID value and maybe there is a special character in the name that is messing up the SQL statement. If you can reproduce this in a certain room, that would be useful. |
|
|
|
|
oldguy2
Wizard
Joined: 17 Jun 2006
Posts: 1201
|
Posted: Sat Sep 25, 2010 6:02 pm
|
Actually the map was open. I don't have ANY scripts that work with the map other than two aliases (that were not executing) and the Room.Info GMCP trigger that simply pulls the name, area, exits, and number and assigns them to variables that I display in a toolbar.
I will look to see what the room name was that I was in when it crashed. But there is no special character I know that much.
Edit: Actually I had an old trigger that was disabled that set the room description. I used to use it with ATCP but I disabled it when I switched to GMCP. I'm not sure how it became enabled but that is the only thing that it could have been. |
|
|
|
|
oldguy2
Wizard
Joined: 17 Jun 2006
Posts: 1201
|
Posted: Sun Sep 26, 2010 7:08 am
|
Here is the only trigger that was active at the time that called any room function. I didn't realize it was enabled.
| Code: |
<trigger name="mapRoomDesc" priority="200" regex="true">
<pattern>^@roomName\.$</pattern>
<trigger type="Within Lines" param="1" regex="true">
<pattern>^(.+)</pattern>
<value>#call %roomdesc(%1)
roomDesc = %1</value>
</trigger>
</trigger> |
So if this did not cause it then it's a bug somewhere. |
|
|
|
|
Zugg
MASTER
Joined: 25 Sep 2000
Posts: 23379
Location: Colorado, USA
|
Posted: Mon Sep 27, 2010 7:04 pm
|
Yeah, I can see where that trigger might have possible problems. You are passing the entire line from the MUD as the Room Number to the %roomdesc function. So CMUD is trying to do a lookup of the room number using the line from the MUD. If the line from the MUD had some sort of character that the lookup routine doesn't like, that might cause a crash.
However, I just tried calling %roomdesc with all sorts of weird text lines with special characters and could not cause a crash. So I would need to see the line from the MUD that triggered the above trigger to really debug this any further. Definitely not something that most people are going to run into. But I'll be an error trap in the FindRoomID function to avoid getting a crash in the future. |
|
|
|
|
oldguy2
Wizard
Joined: 17 Jun 2006
Posts: 1201
|
Posted: Mon Sep 27, 2010 8:46 pm
|
What? I'm not passing anything as the room number. It's firing on the room name and then capturing the next line, which contains the room description, for the room description. I used this trigger with ATCP.
|
|
|
|
|
Rahab
Wizard
Joined: 22 Mar 2007
Posts: 2320
|
Posted: Tue Sep 28, 2010 12:48 pm
|
You _are_ passing the entire description as the room number. The syntax for %roomdesc is: %roomdesc(), %roomdesc(vnum), or %roomdesc(vnum,desc). In order to use the current room automatically as the vnum, you need to leave the vnum blank: %roomdesc(,desc).
|
|
|
|
|
oldguy2
Wizard
Joined: 17 Jun 2006
Posts: 1201
|
Posted: Wed Sep 29, 2010 2:22 am
|
Haha where did that darn comma go.
|
|
|
|
|
|
|
|
