WitpStaff questions and suggestions here please (read the first post!)

[n01487477]

ORIGINAL: andrea

Dear all,

excuse for my english (I'm italian) , each time i running wipt staf I have the sequent message :

Could not create or initialize the databasejava.sql.SQLException: Tipo di dato errato: java.lang.IllegalArgumentException in statement [CREATE MEMORY TABLE "Turn2Date" ( "date" DATE default '0000-00-00']
java.sql.SQLException: Tipo di dato errato: java.lang.IllegalArgumentException in statement [CREATE MEMORY TABLE "Turn2Date" ( "date" DATE default '0000-00-00']

someone could kindly help me ?
thank you very much

I try to read all the post in the thread but I don't find nothing about this kind of error

You need to check your Java version. The latest version 18 is not compatible, version 17 is ...
Download the old version and use Michaels advice a few posts above yours ... or uninstall 18 and reinstall v.17

For those with a bit of PC savvy, you can download the JAVA JRE for u17 (jre-6u17-windows-i586.exe from SUN Java) and install it as a separate installation by selecting "Change Destination Folder" in the lower left of the Java install screen.
Click 'Install' and continue with the installation and it will install this version of JAVA in C:\Program Files\Java\jre1.6.0_17 on your PC.

Then go to the Witpstaff directory in AE and edit the file 'witpStaff.bat' and change the java line to:
C:\"Program Files"\Java\jre1.6.0_17\bin\java -Djava.library.path=. -jar witpdecoder2.jar
and save it. The ""s are needed because of the space between Program and Files.

Clicking on this will now run with java version 17 and you wont get the 'DATE' error.

Any programs that use JAVA will still work with the latest version (18).

[andrea]

Hy Damian
thank you very much for your kindless
Andrea

[hbrsvl]

Hi-I have not used WitpStaff up to now, but would like to know more about it. So, some questions-
1. Where do you find this? Is this another name for the AE editor? If not how do you access it?
2.Is there an AAR or some other reading I can do rather than go through all the posts? That will give me the basics to try and get started?
3. It appears this is a tool for collecting data from game play.Correct? Or, if not, what is it?
4. In the first post there are instructions to do this and that and the other. At this time, I don't feel confident I can execute all of the steps. Is there a place for me to go to learn?

More questions later, after I know a bit(yes, I know how a little knowledge can be very harmfull).

Thanks, Hugh Browne

[michaelm75au]

Under the game directory, there is one called 'tools'.

Look in there..

There is some basic information in a pdf.

[hbrsvl]

michaelm-Hi, I'm sorry to be so dumb, but what is the "game directory" and where is it? Is it the file you get if you go to Start, then Programs and open the AE folder? There is a File called WITP AE Staff.

Also, where is the pdf you mentioned?

Thanks, HB

[hbrsvl]

michaelm-Re my last, found the directory, tools, etc.

Still haven't found the pdf file.

Thanks, HB

[n01487477]

Should be in this folder, go directly to it and you'll see "witpStaff-docs.pdf"

c:\Matrix Games\War In The Pacific Admiral's Edition\tools\witpstaff

[hbrsvl]

Damian-Thanks.HB

[PresterJohn001]

Suggestion, in my ignorance it shouldn't be too hard to do:

Allow players to alter the number of days per turn cycle (PBEM)

[n01487477]

ORIGINAL: PresterJohn

Suggestion, in my ignorance it shouldn't be too hard to do:

Allow players to alter the number of days per turn cycle (PBEM)

Except you've asked in the wrong forum ... [;)]

[PresterJohn001]

lol, just saw the questions and suggestions bit. need to improve my reading and comprehension skillzzz

[findmeifyoucan]

Is there a newer patch available than 1.0.3.1101b?

[n01487477]

ORIGINAL: findmeifyoucan

Is there a newer patch available than 1.0.3.1101b?

Once again asking in the wrong forum thread ... 1102a I think is the latest here

[straggler13]

I'm a nube, so consider the source.

But, since this post is the "MUST READ FIRST" one, I would need some definitions to understand it.

What is a "WitPStaff"?

I do understand that many or most folks using these forums have no need to start at the beginning.
But in order to get new 'blood' into any game it seems some consideration for the newness aspect may be necessary.
My apologies, in advance.
If there is a glossary for folks like me, it would save everyone much time.

[n01487477]

ORIGINAL: straggler13

I'm a nube, so consider the source.

But, since this post is the "MUST READ FIRST" one, I would need some definitions to understand it.

What is a "WitPStaff"?

I do understand that many or most folks using these forums have no need to start at the beginning.
But in order to get new 'blood' into any game it seems some consideration for the newness aspect may be necessary.
My apologies, in advance.
If there is a glossary for folks like me, it would save everyone much time.

WitpStaff is a management tool which reads the save file and primarily displays economic data as well as some other goodies. It is a 3rd Party tool, so matrix doesn't directly support it.

There is a "witpStaff-docs.pdf" in c:\Matrix Games\War In The Pacific Admiral's Edition\tools\witpstaff
which will tell you more.

Good luck and make sure to upgrade to the latest Staff version and have Java V17 not 18.

[straggler13]

[font="arial"]v

Thanks for the quick  reply. I'll look into it.

PS It is so nice to be dealing with grownups again>;0)



[/font]

[andrea]

I now get the following error message
Someone could kindly help me ?
Many thanks

java.lang.ClassNotFoundException: de.retsiemuab.witpDecoder.gui.mapviewPlugins.UPGTestPlugin
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClassInternal(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at de.retsiemuab.witpDecoder.gui.bs.<init>(Unknown Source)
at de.retsiemuab.witpDecoder.gui.aR.a(Unknown Source)
at de.retsiemuab.witpDecoder.Main.main(Unknown Source)
Not loading one/all plugins.
For unknown reasons C:\Matrix Games\War in the Pacific Admiral's Edition\SCEN\witploadAE.exe failed
Could not read the files necessary for DB initialization.java.io.IOException: Can't read the required file db\WITPtabs.csv
java.io.IOException: Can't read the required file db\WITPtabs.csv
at de.retsiemuab.witpDecoder.a.c(Unknown Source)
at de.retsiemuab.witpDecoder.gui.c.run(Unknown Source)
at org.eclipse.swt.custom.BusyIndicator.showWhile(Unknown Source)
at de.retsiemuab.witpDecoder.gui.V.widgetSelected(Unknown Source)
at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
at de.retsiemuab.witpDecoder.gui.aR.a(Unknown Source)
at de.retsiemuab.witpDecoder.Main.main(Unknown Source)
Couldn't set up a working DB template. Bad, Bad.
Couldn't execute the following command:
DROP TABLE "LeaderPrefs";
DROP TABLE "ACFactors";
Couldn't shutdown DB.
java.sql.SQLException: Tabella non trovata: LeaderPrefs in statement [DROP TABLE "LeaderPrefs"]
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source)
at de.retsiemuab.witpDecoder.a.b(Unknown Source)
at de.retsiemuab.witpDecoder.a.g(Unknown Source)
at de.retsiemuab.witpDecoder.gui.bt.c(Unknown Source)
at de.retsiemuab.witpDecoder.gui.ao.run(Unknown Source)
at org.eclipse.swt.custom.BusyIndicator.showWhile(Unknown Source)
at de.retsiemuab.witpDecoder.gui.bt.d(Unknown Source)
at de.retsiemuab.witpDecoder.gui.Z.widgetSelected(Unknown Source)
at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
at de.retsiemuab.witpDecoder.gui.aR.a(Unknown Source)
at de.retsiemuab.witpDecoder.Main.main(Unknown Source)

[JamesM]

I recently had to rebuild my system. After installing the latest version of Java, I try to initiate a new DB and get the following error message:



Can anyone recommend a fix for this?

[n01487477]

ORIGINAL: jamesm

I recently had to rebuild my system. After installing the latest version of Java, I try to initiate a new DB and get the following error message:



Can anyone recommend a fix for this?

What version of staff and java are you using ? The latest iirc is 0.8 & it CAN'T use 6.18 java

[JamesM]

ORIGINAL: n01487477

ORIGINAL: jamesm

I recently had to rebuild my system. After installing the latest version of Java, I try to initiate a new DB and get the following error message:



Can anyone recommend a fix for this?

What version of staff and java are you using ? The latest iirc is 0.8 & it CAN'T use 6.18 java

0.8

Where can I get the older version of Java?