Register to post in forums, or Log in to your existing account
 

Play RetroMUD
Post new topic  Reply to topic     Home » Forums » CMUD Beta Forum
oldguy2
Wizard


Joined: 17 Jun 2006
Posts: 1201

PostPosted: 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.
Reply with quote
oldguy2
Wizard


Joined: 17 Jun 2006
Posts: 1201

PostPosted: Sat Sep 25, 2010 3:34 am   
 
Also I do not use any SQL scripts or commands.
Reply with quote
Tech
GURU


Joined: 18 Oct 2000
Posts: 2733
Location: Atlanta, USA

PostPosted: Sat Sep 25, 2010 6:19 am   
 
This looks like a mapper look up for either vNum or roomID failed.
_________________
Asati di tempari!
Reply with quote
Zugg
MASTER


Joined: 25 Sep 2000
Posts: 23377
Location: Colorado, USA

PostPosted: 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.
Reply with quote
oldguy2
Wizard


Joined: 17 Jun 2006
Posts: 1201

PostPosted: 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.
Reply with quote
oldguy2
Wizard


Joined: 17 Jun 2006
Posts: 1201

PostPosted: 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.
Reply with quote
Zugg
MASTER


Joined: 25 Sep 2000
Posts: 23377
Location: Colorado, USA

PostPosted: 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.
Reply with quote
oldguy2
Wizard


Joined: 17 Jun 2006
Posts: 1201

PostPosted: 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.
Reply with quote
Rahab
Wizard


Joined: 22 Mar 2007
Posts: 2307

PostPosted: 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).
Reply with quote
oldguy2
Wizard


Joined: 17 Jun 2006
Posts: 1201

PostPosted: Wed Sep 29, 2010 2:22 am   
 
Haha where did that darn comma go.
Reply with quote
Display posts from previous:   
Post new topic   Reply to topic     Home » Forums » CMUD Beta Forum All times are GMT
Page 1 of 1

 
Jump to:  
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

© 2009 Zugg Software. Hosted by Wolfpaw.net