ConvoCC... Or Database.. Well something is wrong

[VikingenTor]

So here is the deal.
After a looong time I actually managed to get this whole thing going, wich for a technically gifted man such as myself was nowhere near enough as easy as you made it seem. But enough about that *smiles*

Now I have one question and one problem (or that would mean two questions, cause I also like to know what I can do to help the problem)

The ConvoCC works, in a manner of speaking, but:
I can only choose male as sex, no matter what. And the reason for this is simple. When I created the out.sql (using mysql) it all went smooth, but when I restore the sql dump into the databse he suddenly gives me  a error message saying  
"Error occured at:2010-07-14 16:13:41
Line no.:666769
Error Code: 1146 - Table 'selune.prc_cached2da_item_to_ireq' doesn't exist

Query:
CREATE UNIQUE INDEX `refrindex`       ON `prc_cached2da_item_to_ireq` (`L_RESREF`, `rowid`)"

What can I do about that. Tried making new out.sql files, changes nothing. Tried manually creating the table to no avail.

Aslo I would like to know. Is there a way to instead of right when you log on to the server you have a "lever" people can use to start ConvoCC should they wish to?
And two, since I plan to use dolls to adjust looks, how would I do to change what things are asked in the ConvoCC? I want to remove all "looksrelated" questions in short.

Well there we go, that is pretty much what I would like help with, and since I am not really skilled at this probably more later.

Oh and since I have no idea what you have or have not done with the sequel, I am talking about NWN 1

[xwarren]

So here is the deal.
After a looong time I actually managed to get this whole thing going, wich for a technically gifted man such as myself was nowhere near enough as easy as you made it seem. But enough about that *smiles*

Now I have one question and one problem (or that would mean two questions, cause I also like to know what I can do to help the problem)

The ConvoCC works, in a manner of speaking, but:
I can only choose male as sex, no matter what. And the reason for this is simple. When I created the out.sql (using mysql) it all went smooth, but when I restore the sql dump into the databse he suddenly gives me a error message saying
"Error occured at:2010-07-14 16:13:41
Line no.:666769
Error Code: 1146 - Table 'selune.prc_cached2da_item_to_ireq' doesn't exist

Query:
CREATE UNIQUE INDEX `refrindex` ON `prc_cached2da_item_to_ireq` (`L_RESREF`, `rowid`)"

What can I do about that. Tried making new out.sql files, changes nothing. Tried manually creating the table to no avail.

Could you please paste here the contents of your nwnx_odbc.txt file (in NWN\logs.0 dir). This should tell us if there are any problems with database.

Aslo I would like to know. Is there a way to instead of right when you log on to the server you have a "lever" people can use to start ConvoCC should they wish to?
And two, since I plan to use dolls to adjust looks, how would I do to change what things are asked in the ConvoCC? I want to remove all "looksrelated" questions in short.

Do not set PRC_CONVOCC_ENABLE switch and add 'prc_ccc_main' script to OnUsed event of yor lever.
To remove all appearance related options from ConvoCC you will have to edit ccc_inc_convo.nss file (in prc_include.hak) and set the conversation stages in correct order. After that you have to recompile prc_ccc_main.nss script.

[VikingenTor]

That file was a rather long one. But I looked trough it, and it seems that it is just a load of got request and sent response. And looking trough it (wich I have never done before) it at least at no point say anything about any problems occuring.
So if that file is as nice as all the others I am assuming that there is no problem there.

I am curious if I may be missing some 2DA file, would that explain the problem? I am really at a loss here trying to figure it out. As I said I am new to all this so it is not like I changed any files so far (though I guess I am about to *smiles*) so shouldn't be that either, though who knows, might have fugded something up by misstake.

Anyway, thanks for a really speedy (and helpful of course) response, and if you still want to see the txt-file I can post it, just assuming it is not needed, cause as I said, it claims no faults

[xwarren]

I would like to take a look though - just to be sure. Could you use pastebin.com or sth and post a link here?

I'm don't know how important that 2da is. Well... I don't have that file and everything works so *shrugs*. Still, it could be MySql problem.

[DM Heatstroke]

Query:
CREATE UNIQUE INDEX `refrindex`       ON `prc_cached2da_item_to_ireq` (`L_RESREF`, `rowid`)"

Delete the last line of your out.sql before you import it.  It's not needed.

Aslo I would like to know. Is there a way to instead of right when you log on to the server you have a "lever" people can use to start ConvoCC should they wish to?

Yes.

From prc_inc_switch.nss:
/**
 * When set, the convoCC NO LONGER STARTS AUTOMATICALLY on logging in. It must be called
 * by a script in the module. This allows the module builder to start the convoCC from a
 * particular area or trigger's On Enter event. The script should call the convoCC with
 * ExecuteScript("prc_ccc_main", oPC) where oPC is the PC. It's advisable to check the
 * entering object is a PC and not a NPC or DM.
 */

const string PRC_CONVOCC_CUSTOM_START_LOCATION       = "PRC_CONVOCC_CUSTOM_START_LOCATION";

/**
 * When set, this switch causes a custom script to be used to determine whether a PC should go
 * through the convoCC or not.
 * The script must:
 * - be called "ccc_custom_enter"
 * - set the local int "CONVOCC_LAST_STATUS" on the PC (OBJECT_SELF)
 * - include prc_ccc_const (for the constants the local int can be set to)
 * otherwise the PC will always be booted
 *
 * possible values for CONVOCC_LAST_STATUS:
 * CONVOCC_ENTER_BOOT_PC (causes the PC to get kicked)
 * CONVOCC_ENTER_NEW_PC (causes the PC to go through the convoCC)
 * CONVOCC_ENTER_RETURNING_PC (causes the PC to skip the convoCC)
 *
 * This switch will completely bypass the convoCC methods for determining whether to run the
 * convoCC on an entering PC, so if necessary, your custom marker for 'done' would be set
 * in 'ccc_custom_exit'
 * @see PRC_CONVOCC_CUSTOM_EXIT_SCRIPT
 */
const string PRC_CONVOCC_CUSTOM_ENTER_SCRIPT          = "PRC_CONVOCC_CUSTOM_ENTER_SCRIPT";

[VikingenTor]

Thanks, it worked fine just removing the last stuff

But the problem wich caused me to realise something is wrong (and I thought would sort itself once this was done) remains. I can only choose gender: Male

I have buttloads of classes and races, but I only get one sex... Enough for me but still *laughs* there is obviously something wrong there.

Again I like to thank you both for a suprisingly quick support on my noobiness

[DM Heatstroke]

Thanks, it worked fine just removing the last stuff

But the problem wich caused me to realise something is wrong (and I thought would sort itself once this was done) remains. I can only choose gender: Male

I have buttloads of classes and races, but I only get one sex... Enough for me but still *laughs* there is obviously something wrong there.

Again I like to thank you both for a suprisingly quick support on my noobiness

Make sure your gender.2da file isn't damaged.  It should be taken from bioware2da.7z file during precaching, so make sure it's not damaged & that you are using a recent version of the PRC Server Pack.

[VikingenTor]

So if we assume that is damaged, what do I do then? I tried dl'ing the 2DA's from Biowares site and put it in the 2DAsourse file, tried re-precaching them and then run it trough the db again (after removing that last line ) and exactly the same thing happens again.

[DM Heatstroke]

So if we assume that is damaged, what do I do then? I tried dl'ing the 2DA's from Biowares site and put it in the 2DAsourse file, tried re-precaching them and then run it trough the db again (after removing that last line ) and exactly the same thing happens again.

Then it's not damaged.  Are all the base classes showing up correctly?


p.s. you should post that log that xwarren wanted to see.

[VikingenTor]

Yeah, Xwarren, you shouldn't think I am ignoring your request. I just haven't spent more then a moment by the computer, so it was just that I didn't take the time to sort it... Untill now.

 Never used pastebin before but http://pastebin.com/kCeX5skr this should take you to it as far as I understood it all Otherwise yell at me and I will fix it

[xwarren]

For some reason FILE_END switch for gender.2da is not set correctly in your module. Try adding it manually. All you need to do is set in Toolset/Module Properties/Advanced Tab/Variables a local int called PRC_FILE_END_gender to 1. Hope this helps.

[VikingenTor]

*sighs* Nufink, tried that, still just male :´(

[DM Heatstroke]

*sighs* Nufink, tried that, still just male :´(

I *think* you need this one set too.

Code: [Select]

/**
 * If this is set it will disable the defaults and the module builder must set
 * the values manually.
 * Otherwise it will set the automatically, and will take the PRC companion
 * into account, including CEP if its the CEP/PRC companion.
 */
const string FILE_END_MANUAL                         = "FILE_END_MANUAL";

What I don't know is if you'll need to set a file_end for all of the other 2das that use them.

[VikingenTor]

Back again, had some RL to deal with *smiles*

Now does this mean I should put this in variables as a string? Cause I tried that and nothing. Using both with and without the "'s

Or should I change within some script, in this case, what script would that be?

[xwarren]

Could you try running ConvoCC on other module, ie Prelude (OC), first?

Maybe some scripts from your module are conflicting with PRC scripts?