Zugg Software :: View topic - Access Violation and full crash possible %db("",Num)

Novice Joined: 26 Jan 2009 Posts: 32

If one adds a single item to a view on a database then deletes that item then calls %db("",Num) you will get a an access violation and in more severe circumstances a complete crash with options for dump close app etc.

It is easy to avoid of course a check of $Pram to see if it is null in %db($Pram,Num) and avoiding the function avoids the problem.

On another interesting note in other situations where you are are on a table with lots of data %db("",Num) returns the current record Number which I would guess to be unwanted functionality and no doubt housed somewhere close to the more serious crash problem.

I can provide a dump if needed, though it is easy to reproduce. Goodnight all.

Posted: Tue Jan 27, 2009 3:24 am

Keep in mind that the Database module is a direct port from zMUD and contains many bugs and problems (and the same bugs that are in zMUD). It is not a real database, and it is not fully integrated into the new CMUD scripting. It was ported to give *basic* functionality for people that needed it, rather than holding up all of CMUD for the vast majority of users who don't even use the database module.

Because the database module in CMUD is going to be replaced with a completely rewritten module with a real SQL database engine, I have no plans to currently work on the existing database module code. So reporting bugs in it at this point really isn't very efficient. Unfortunately, I'm just one person and have a lot of other stuff to work on, and the rewrite for the database module isn't planned for many months.

So for now, just try to workaround any problems in the database module as best you can.