SQLite setup for Talus problem

[hermyt]

Trying to setup Talus package for nwnx2 using sqlite but the create statements are giving me some problems. I've modified it so most of the tables create but I'm having some problems on one and figured I'd see if anyone knew a quick solution, here's my log for that create table statement.

o Got request: CREATE TABLE lds_resref_lookup ( name varchar(100) NOT NULL default '', resref varchar(17) NOT NULL default '', PRIMARY KEY (name), KEY idx_lds_resref_lookup (name) )
! SQL Error: near "KEY": syntax error

So from that I gather that the error is the KEY field type and I've checked the syntax on sqlite and didn't find a reference to it being used, should I be chucking it into primary key? and I'm not sure exactly how to do it, do I make it a primary key named idx_lds_resref_lookup? or what?

Any ideas?

[Lanthar D'Alton]

which version of the system are you using? Just making sure you know about newer versions available...

Version 3.05b

As for the statement... I'm not sure how SQLLite create syntax works... but that index isn't really that necessary. Just leave the index off if nothing else.

-Lanthar

[hermyt]

I did dl the newest ver (today went to your site and grabbed it)

But for a random quest generator I was working on I was monkeying with changin values in the db using their control center interface and man it sucks. I'm just gunna scrap it and setup mysql, thats what I get for being lazy and saving 1/2 hr.

Thanks for the help though Lanthar, appreciate it.

HerMyT

[darwinscusp]

Hmmm, link seems broken Lanthar.

[Lanthar D'Alton]

I always forget to set the file permission

-Lanthar