[Solved]ConvoCC Issue

[KenquinnTheInsaneOne]

Code: [Select]

[Thu Jun 10 12:05:18] SLS :print /FirstName;print ' ';print /LastName;
[Thu Jun 10 12:05:18] SCRIPT >: %LETOTEST = q{/opt/nwn/ken/servervault/Kenquinn/rodorgeigerlson.bic}; print /FirstName;print ' ';print /LastName;close %LETOTEST;
[Thu Jun 10 12:05:18] SCRIPT <: Rodor Geigerlson
[Thu Jun 10 12:05:38] SELECT rowid, data FROM prc_cached2da WHERE file = 'gender' AND columnid = 'name' AND  rowid <= 1
[Thu Jun 10 12:05:38] NWNX_ODBC_FETCH row: 0¬156
[Thu Jun 10 12:05:38] SQL: RowID = 0
[Thu Jun 10 12:05:38] SQL: Data =
[Thu Jun 10 12:05:38] NWNX_ODBC_FETCH row: 1¬157
[Thu Jun 10 12:05:38] SQL: RowID = 1
[Thu Jun 10 12:05:38] SQL: Data =


Interesting it is not fetching the second field. I run "SELECT rowid, data FROM prc_cached2da WHERE file = 'gender' AND columnid = 'name' AND  rowid <= 1" manually into MySQL and it has the save behavior.

I do a second fetch to see if the gender data is missing entirely with

Code: [Select]

SELECT  data FROM prc_cached2da WHERE file = 'gender'

I get this output

Code: [Select]

+---------------+
| data          |
+---------------+
| GENDER_MALE   |
| GENDER_FEMALE |
| GENDER_BOTH   |
| GENDER_OTHER  |
| GENDER_NONE   |
| M             |
| F             |
| B             |
| O             |
| N             |
| ****          |
| ****          |
| ****          |
| ****          |
| ****          |
| 156           |
| 157           |
| 4771          |
| 201           |
| 202           |
+---------------+


That is every field from the gender.2da file so the data is their.

The server is Fedora 10 64 bit.

[xwarren]

Now, there is nothing wrong with your NWNX, but...

My log:

Code: [Select]

[Thu Jun 10 15:19:58] NWNX_ODBC_FETCH row: 0¬156
[Thu Jun 10 15:19:58] SQL: RowID = 0
[Thu Jun 10 15:19:58] SQL: Data = Male

Your log:

Code: [Select]

[Thu Jun 10 12:05:38] NWNX_ODBC_FETCH row: 0¬156
[Thu Jun 10 12:05:38] SQL: RowID = 0
[Thu Jun 10 12:05:38] SQL: Data =

you did get the data from database, but the game can't convert that data to a text string. Now, i see two reasons why this would happen:
1. GetStringByStrRef() function doesn't work for some reason (engine function, can't help you if this is the case)
2. you've edited the default dialog.tlk file

Just to make it 100% sure, could you test the file i've attached, that's probably the last one...

[KenquinnTheInsaneOne]

Its alive its alive!!!!!

I found the issue when you mentioned a modified dialog.tlk file being able to cause the issue. I took a quick look at the directory I run the server out of it has no dialog.tlk file. I put one in and it works.

Thank you very much for all your time an effort on this issue. I apologize for not noticing this earlier.

[xwarren]

Its alive its alive!!!!!

I found the issue when you mentioned a modified dialog.tlk file being able to cause the issue. I took a quick look at the directory I run the server out of it has no dialog.tlk file. I put one in and it works.

Thank you very much for all your time an effort on this issue. I apologize for not noticing this earlier.

Great!!!

I'm happy I could help

[DM Heatstroke]

Its alive its alive!!!!!

I found the issue when you mentioned a modified dialog.tlk file being able to cause the issue. I took a quick look at the directory I run the server out of it has no dialog.tlk file. I put one in and it works.

Thank you very much for all your time an effort on this issue. I apologize for not noticing this earlier.

Heh, so you were missing custom content after all!

[KenquinnTheInsaneOne]

Its alive its alive!!!!!

I found the issue when you mentioned a modified dialog.tlk file being able to cause the issue. I took a quick look at the directory I run the server out of it has no dialog.tlk file. I put one in and it works.

Thank you very much for all your time an effort on this issue. I apologize for not noticing this earlier.

Heh, so you were missing custom content after all!

That is not custom content its a stock game file.

[DM Heatstroke]

Its alive its alive!!!!!

I found the issue when you mentioned a modified dialog.tlk file being able to cause the issue. I took a quick look at the directory I run the server out of it has no dialog.tlk file. I put one in and it works.

Thank you very much for all your time an effort on this issue. I apologize for not noticing this earlier.

Heh, so you were missing custom content after all!

That is not custom content its a stock game file.

Oh I didn't catch that, you were missing the dialog.tlk, not the PRC tlk.

[KenquinnTheInsaneOne]

A module wont even start without the tlk a module needs.

[DM Heatstroke]

A module wont even start without the tlk a module needs.

Well I'm glad you got it figured out.  Have you been able to make a PC yet?

[KenquinnTheInsaneOne]

Yes I have why do you ask?

[DM Heatstroke]

Yes I have why do you ask?

Just checking really.  Going to post the server here when it's done?

[KenquinnTheInsaneOne]

If I ever get it ready