[Solved]Unable to load 2da cache object (CacheChest) from prc_datac2

[KenquinnTheInsaneOne]

Just started trying to get PRC running on my Fedora 10 server.

I run the MySQL precatcher then loaded up the out.sql file into a fresh MySQL database. I then wipe the database folder for the PRC Test module. Then I start up a instance of my PRC Test module with the correct variables set and I get the following error in the log file and the ConvoCC does not work but that is of course due to the database not working. The prc_data.* files are generate in the database folder.

Any idea what is going wrong and do you need any more information?

Code: [Select]

Loading Module: PRCTest
Removing old PRC version databases
Module 2da cache fingerprint: PRCTest_596_729092273
Starting to load 2da cache object from prc_data
WARNING: Unable to load 2da cache object (CacheChest) from prc_data

[xwarren]

ConvoCC doesn't use Bioware database - you need to configure MySql correctly (or use sqlite - it's much easier to setup). Stupid question, but did you used NWNX to start the NWServer with your module?

The warning message is obvious since you removed all database files ;p. Don't worry about that, new database will be created while using PRC.

[KenquinnTheInsaneOne]

Edit: I tried using the supplied .cdx/.fpt/.dbx files and it removed the error.
____________________________________________________________
I know how to setup a MySQL database as the current PW I help develop is running one. The PRC database is using a separate database on the MySQL server.

Tables have been generated and here is a copy of the table list and the contents of the first table. NWNX is properly configured and running and I have supplied a copy of my test module variables.

I have tried generating the database files several times and have tried starting the server up again several times after each time they are generated. I will try and use the stock database files and see if that helps.

Code: [Select]

+---------------------------+
| Tables_in_prcdatabase      |
+---------------------------+
| prc_cached2da             |
| prc_cached2da_appearance  |
| prc_cached2da_classes     |
| prc_cached2da_cls_feat    |
| prc_cached2da_feat        |
| prc_cached2da_portraits   |
| prc_cached2da_racialtypes |
| prc_cached2da_soundset    |
| prc_cached2da_spells      |
+---------------------------+


prc_cached2da format

Code: [Select]

+----------+--------------+------+-----+---------+-------+
| Field    | Type         | Null | Key | Default | Extra |
+----------+--------------+------+-----+---------+-------+
| file     | varchar(20)  | YES  | MUL | _       |       |
| columnid | varchar(255) | YES  |     | _       |       |
| rowid    | int(11)      | YES  |     | -1      |       |
| data     | varchar(255) | YES  |     | _       |       |
+----------+--------------+------+-----+---------+-------+


Module Variables

Code: [Select]

PRC_CONVOCC_ENABLE int 1
PRC_DB_MYSQL int 1
PRC_LETOSCRIPT_NWN_DIR string /opt/nwn/ken/
PRC_USE_DATABASE int 1
PRC_USE_LETOSCRIPT int 1

[alphadelphi]

I'm getting the same error though it seems everything else is working fine. What did you do exactly to correct the issue? It was said-

Edit: I tried using the supplied .cdx/.fpt/.dbx files and it removed the error.

I have those files but really, I don't know how to use them. Any assistance would be appreciated.

[xwarren]

I'm getting the same error though it seems everything else is working fine. What did you do exactly to correct the issue? It was said-

Edit: I tried using the supplied .cdx/.fpt/.dbx files and it removed the error.

I have those files but really, I don't know how to use them. Any assistance would be appreciated.

Just put them in your NWN\database directory

[alphadelphi]

Thanks for the fast response. Just started classes for the fall so I'm slower to reply Thank you, that's where they're currently stored. I'll look for an issue somewhere else.

[KenquinnTheInsaneOne]

Sometimes the copies of them can get bugged. Try getting a fresh copy of them and more importantly make a new thread.