ID:1522185
 
Resolved
SQLite database files could not be created in a subdirectory.
BYOND Version:506
Operating System:Windows 8 64-bit
Web Browser:Firefox 27.0
Applies to:Dream Daemon
Status: Resolved (506.1239)

This issue has been resolved.
Descriptive Problem Summary:
When trying to create new database using the new SQLite functionality, it will not work properly if you try and create the file in a subdirectory.

Code Snippet (if applicable) to Reproduce Problem:
proc/SetupSQLite()
if(!fexists("Database/Logs.db"))
var/database/db=new("Database/Logs.db")
var/database/query/q=new
q.Add("CREATE TABLE 'Connection_Logs' (key TEXT, ip TEXT, comp_id TEXT, timestamp TEXT)")
q.Execute(db)


Expected Results:
Logs.db being created within the /Database folder.

Actual Results:
No database file is being created.

Does the problem occur:
Every time? Or how often?
Every time.
In other games?
I'd imagine so.
In other user accounts?
Yes.
On other computers?
Yes.

When does the problem NOT occur?
The problem does not occur when you create it in the root directory.

Maybe it's not supposed to work this way, I just imagined it would just like when any other file is created in DM.
Question: Did the subdir already exist? If not, that's probably the issue, and it's fixible.
In response to Lummox JR
Lummox JR wrote:
Question: Did the subdir already exist? If not, that's probably the issue, and it's fixible.

The sub directory did not exist. I just created it manually and it works as it should.
In response to Lummox JR
Probably not the place to do this but good job to you and Tom.
In response to Ssj4justdale
Ssj4justdale wrote:
Probably not the place to do this but good job to you and Tom.

I second this, thanks guys. I was really excited to see SQLite added to the building list of Byonds features.
Lummox JR resolved issue with message:
SQLite database files could not be created in a subdirectory.