6 replies to this topic

[jedi156]

I cant get version 8 to create all the tables, It makes some of the tables but nwnx_odbc.txt says:

4 like this:
o Got request: INSERT INTO bbs_boards (name,pageSize,maxItems,boardId) VALUES ('BBS','5','25','1')
! SQL Error: Table 'nwn.bbs_boards' doesn't exist

About 200+ like this one:
o Got request: SELECT val FROM cnr_misc WHERE player='~' AND tag='NordockCEPPRCPlagued' AND name='CnrRecipeRunFirstTime'
! SQL Error: Table 'nwn.cnr_misc' doesn't exist


About 20+ like this:
o Got request: SELECT merchant FROM cmd_misc WHERE merchant='' AND sVarName='vendor_deb_IsPersistent'
! SQL Error: Unknown column 'merchant' in 'field list'

I poked about in the toolset for about 2 hours looking for where cnr_misc get created but could not find it. I guess maybe it too much module for my poor old duel p3 600 server

thanks

[udoh]

I poked about in the toolset for about 2 hours looking for where cnr_misc get created but could not find it. I guess maybe it too much module for my poor old duel p3 600 server

The "cnr-misc" table is created in the routine "ff_buildtable" at line 35.

That table, along with a number of other tables are surround by a variable FF_USING_CNR. It maybe, for some reason on your pc that the variable is not being set correctly, and that none of the tables between line 33 and 117 are being created. You can check your tables using MySQLCC against teh ones shown in "ff_buildtable".

Hope that helps.
udoh

Edited by udoh, 16 March 2005 - 10:09 PM.

[horred the plague]

I poked about in the toolset for about 2 hours looking for where cnr_misc get created but could not find it. I guess maybe it too much module for my poor old duel p3 600 server

The "cnr-misc" table is created in the routine "ff_buildtable" at line 35.

That table, along with a number of other tables are surround by a variable FF_USING_CNR. It maybe, for some reason on your pc that the variable is not being set correctly, and that none of the tables between line 33 and 117 are being created. You can check your tables using MySQLCC against teh ones shown in "ff_buildtable".

Hope that helps.
udoh

Jedi--you might be right about it being too much module, unfortunately. My 512RAM 1.4 Celeron can barely handle it.

Take a look in ff_inc_options, and see what that variable (FF_USING_CNR) is set to. If it isn't set to 1, let me know. (& Set it to 1, of course).Can't remember if I checked these or not when I added the scripts back in. Then again, I thought I deleted that check from ff_buildtable in the first place, a couple versions back. (P.S: See why I needed the break guys? I can't remember which day it is half the time anymore, hehe )

Edited by horred the plague, 16 March 2005 - 10:34 PM.

[jedi156]

The "cnr-misc" table is created in the routine "ff_buildtable" at line 35.

Hope that helps.
udoh

Take a look in ff_inc_options, and see what that variable (FF_USING_CNR) is set to. If it isn't set to 1, let me know. (& Set it to 1, of course).Can't remember if I checked these or not when I added the scripts back in. Then again, I thought I deleted that check from ff_buildtable in the first place, a couple versions back. (P.S: See why I needed the break guys? I can't remember which day it is half the time anymore, hehe )

ok FF_USING_CNR was set to 0, builiding scripts as I type.
ff_buildtable at line 35 creates cnd_misc NOT cnr_misc, do I need both or is this a typo, its exactly the kind of typo I make all the time.

And If you dont know which day it is, its drink green beer day
thanks

Edited by jedi156, 17 March 2005 - 07:41 AM.

[GrapeApe]

cnr_misc and cmd_misc and cpv_misc are all different tables and are all needed for different things.

If you continue looking through that script you should see the others I assume.

[jedi156]

cnr_misc and cmd_misc and cpv_misc are all different tables and are all needed for different things.

If you continue looking through that script you should see the others I assume.

Well cmd_misc and cpv_misc are there and get created now that I set FF_USING_CNR = 1 in ff_inc_options, but there is no cnr_misc anywhere in ff_buildtable. I can tell from the nwnx_odbc.txt log that I need at least player,tag,name,val,expire feilds but have no idea what type & or size to make them or if I need others.

Could someone check their ff_buildtable for cnr_misc please to make sure I am not totally friggin insane!
thanks

[muaddib]

Along this same line i cannot find were the bbs_boards tables are being built. The script bbs_buildboard refrences this table and even adds entries if there not there, but i cannot find were the table is being created at. Ive looked over my database and there are no bbs_anything.

Can i either get a list of ALL the tables that are supposed to be there (you dont have to list all the bfeat, feat, savthr, skill, or race_feat tables).

These are what i have so far:

areatransition
cdkeys
classes
cls_atk_1
cls_atk_2
cls_atk_3
cls_bfeat_bard
cls_bfeat_brawl
cls_bfeat_cler
cls_bfeat_monk
cls_bfeat_pal
cls_bfeat_rang
cls_bfeat_samur
cls_bfeat_sorc
cls_bfeat_wiz
cls_bfeat_barb
cls_bfeat_brawl
cls_feat_cler
cls_feat_fight
cls_feat_monk
cls_feat_pal
cls_feat_rang
cls_feat_samur
cls_feat_sorc
cls_feat_wiz
cls_savthr_barb
cls_savthr_cler
cls_savthr_fight
cls_savthr_monk
cls_savthr_pal
cls_savthr_rang
cls_savthr_sorc
cls_savthr_wiz
cls_skill_barb
cls_skill_brawl
cls_skill_cler
cls_skill_fight
cls_skill_monk
cls_skill_pal
cls_skill_rang
cls_skill_samu
cls_skill_sorc
cls_skill_wiz
cls_spgn_sorc
cls_spkn_sorc
cmd_misc
cnr_components
cnr_devices
cnr_recipes
cnr_submenus
cpv_misc
domains
feat
gender
global
hen_familiar
idplayer
items
log
logactions
login
pcdata
playerdata
portraits
pwdata
race_feat_aqelf
race_feat_arcdw
race_feat_avar
race_feat_bugb
race_feat_drow
race_feat_elf
race_feat_half
race_feat_hfelf
race_feat_hogre
race_feat_human
race_feat_imask
race_feat_minot
race_feat_ogre
race_feat_pixie
race_feat_pyuan
race_feat_raks
race_feat_rgnome
race_feat_troll
race_feat_wemic
race_feat_wielf
racialtypes
restart
skills
soundset
spells
spellschools

Edited by muaddib, 20 March 2005 - 08:07 AM.