[Tool] GD Stash

delete, save, then refresh and then this appears

for deleting I just press the red cross right to mastery’s name in the Char Editor tab.

if I delete and then refresh w/o saving, nothing happens and masteries return to which ones were chosen.

when I do that, it works just as expected. Can you send my your save file so I can see where the load fails (won’t answer where the save failed, unfortunately, but maybe I can glean something from its content)

here you go.

EDIT: apparently the problem appears if I mess up with masteries on any char, not only this one.

EDIT #2: looks like @Superfluff has a very similar issue.

EDIT #3: another problem appeared when I tried to add an old char and toss some items into their stash. I didn’t remove any masteris or skillpoints or w/e, just added some augs and potions to the stash and saved it. When I went to Char Editor tab and renewed it, this happened

and char went null. here’s the save.

_Harra, Blade of the Night-20241226T180637Z-001.zip (1.3 MB)

Hello,

i get the following error message when i try to put items from the tool into the stash.

Version 1.8.0.c

Sounds like you did not import the GD data, which it should ask you to do at the startup. Go to the config page and do that

I have already done that a couple times and i have tried it again but the error is still there.
During the import should it show something Fangs of Asterkarn related?
I only get FG, AoM and base game text.
GDSTASHERROR1

Unlikely, but does anyone know why in the world I’m having such a hard time making live-edits? It didn’t used to be this way a couple years ago… I am unable to have any saves I make to Character specific stash or inventory take into effect without making the changes on the main menu. I make sure I don’t push a save in GDStash with any inventories open.

The shared stash is a bit more reliable for live-editing, but even then sometimes it’ll fail. I’ll transfer an item from stash DB into shared stash, push the save, reload just to be sure it’s there, go into shared stash in-game and the item sometimes won’t be there (and never is for Character specific stashes). If I hit reload after, the item I transferred over in GDStash will disappear.

It’s honestly maddening. I’ve taken ownership of all files, check to make sure nothing’s read-only, disabled cloud save in Steam and in-game. All steps taken properly, as can be evident by GDStash being able to always succeed when on main menu, and live reload/read properly with no issues.

do you happen to use /nocommit launch command? :thinking:

If this is related to my problem; no (to my knowledge). I simply run the GDStash.exe and launch the game through Steam with no launch commands. I am running the DPS overlay plugin, though I don’t believe that should interfere with it.

The inconsistency with the failure is what really baffles me, honestly.

is it still there after the image above? It should not, as part of the update the items should be moved to a table with those fields.

If you still get the error, can you give me the full text of the second error message (copy & paste)?

Only if you have FoA installed

you cannot do that while you play the char in game, you never could

that always works for me reliably. Make sure you are not using cloud save in GD and do not have the stash open when doing so however

Yes, the error is still appearing.

This is the second error:

javax.swing.ImageIcon@4ec8e22a Column ‘ROW_FOA_ASCENDANT_ID’ is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement then ‘ROW_FOA_ASCENDANT_ID’ is not a column in the target table.
java.sql.SQLSyntaxErrorException: Column ‘ROW_FOA_ASCENDANT_ID’ is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement then ‘ROW_FOA_ASCENDANT_ID’ is not a column in the target table.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement42.(Unknown Source)
at org.apache.derby.jdbc.Driver42.newEmbedPreparedStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
at org.gdstash.db.DBStashItem.deleteNonStack(DBStashItem.java:1877)
at org.gdstash.db.DBStashItem.delete(DBStashItem.java:1774)
at org.gdstash.db.DBStashItem.delete(DBStashItem.java:1767)
at org.gdstash.ui.GDTransferPane.transferSelectedItem(GDTransferPane.java:1101)
at org.gdstash.ui.GDTransferPane.transferSelectedItem(GDTransferPane.java:1089)
at org.gdstash.ui.stash.GDContainerPane$GDContainerPageMouseListener.selectItem(GDContainerPane.java:200)
at org.gdstash.ui.stash.GDContainerPane$GDContainerPageMouseListener.mousePressed(GDContainerPane.java:38)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at org.gdstash.ui.stash.GDContainerMapPane.notifyPages(GDContainerMapPane.java:135)
at org.gdstash.ui.stash.GDContainerMapPane.access$300(GDContainerMapPane.java:27)
at org.gdstash.ui.stash.GDContainerMapPane$GDMouseListener.mousePressed(GDContainerMapPane.java:39)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
at java.awt.EventQueue.access$500(Unknown Source)
at java.awt.EventQueue$3.run(Unknown Source)
at java.awt.EventQueue$3.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue$4.run(Unknown Source)
at java.awt.EventQueue$4.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
Caused by: ERROR 42X04: Column ‘ROW_FOA_ASCENDANT_ID’ is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement then ‘ROW_FOA_ASCENDANT_ID’ is not a column in the target table.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.impl.sql.compile.ColumnReference.bindExpression(Unknown Source)
at org.apache.derby.impl.sql.compile.ColumnReference.bindExpression(Unknown Source)
at org.apache.derby.impl.sql.compile.BinaryOperatorNode.bindExpression(Unknown Source)
at org.apache.derby.impl.sql.compile.BinaryComparisonOperatorNode.bindExpression(Unknown Source)
at org.apache.derby.impl.sql.compile.BinaryOperatorNode.bindExpression(Unknown Source)
at org.apache.derby.impl.sql.compile.BinaryLogicalOperatorNode.bindExpression(Unknown Source)
at org.apache.derby.impl.sql.compile.AndNode.bindExpression(Unknown Source)
at org.apache.derby.impl.sql.compile.BinaryOperatorNode.bindExpression(Unknown Source)
at org.apache.derby.impl.sql.compile.BinaryLogicalOperatorNode.bindExpression(Unknown Source)
at org.apache.derby.impl.sql.compile.AndNode.bindExpression(Unknown Source)
at org.apache.derby.impl.sql.compile.BinaryOperatorNode.bindExpression(Unknown Source)
at org.apache.derby.impl.sql.compile.BinaryLogicalOperatorNode.bindExpression(Unknown Source)
at org.apache.derby.impl.sql.compile.AndNode.bindExpression(Unknown Source)
at org.apache.derby.impl.sql.compile.BinaryOperatorNode.bindExpression(Unknown Source)
at org.apache.derby.impl.sql.compile.BinaryLogicalOperatorNode.bindExpression(Unknown Source)
at org.apache.derby.impl.sql.compile.AndNode.bindExpression(Unknown Source)
at org.apache.derby.impl.sql.compile.BinaryOperatorNode.bindExpression(Unknown Source)
at org.apache.derby.impl.sql.compile.BinaryLogicalOperatorNode.bindExpression(Unknown Source)
at org.apache.derby.impl.sql.compile.AndNode.bindExpression(Unknown Source)
at org.apache.derby.impl.sql.compile.BinaryOperatorNode.bindExpression(Unknown Source)
at org.apache.derby.impl.sql.compile.BinaryLogicalOperatorNode.bindExpression(Unknown Source)
at org.apache.derby.impl.sql.compile.AndNode.bindExpression(Unknown Source)
at org.apache.derby.impl.sql.compile.BinaryOperatorNode.bindExpression(Unknown Source)
at org.apache.derby.impl.sql.compile.BinaryLogicalOperatorNode.bindExpression(Unknown Source)
at org.apache.derby.impl.sql.compile.AndNode.bindExpression(Unknown Source)
at org.apache.derby.impl.sql.compile.SelectNode.bindExpressions(Unknown Source)
at org.apache.derby.impl.sql.compile.DMLStatementNode.bindExpressions(Unknown Source)
at org.apache.derby.impl.sql.compile.DeleteNode.bindStatement(Unknown Source)
at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source)
at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)
at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown Source)
… 53 more

Version 1.8.0d released

should fix the ROW_FOA_ASCENDANT_ID issue

thanks, it works now

Hi, i get the following errors when importing my database. Afterwards i can see my full stash of my characters and smuggler, and also interact with it in GD-Stash.
But im not able to sync my GD-stash file with my GD-saves.

I turned cloudsaves of, in Grim Dawn and in Steam.

Welcome to the forum. :slightly_smiling_face:

Don’t just turn off cloud saving, you need to move your cloud saves to local ones. Follow the instructions here.

1 Like

I tried this, but i dont have a folder here
" The local save location for GD is ALWAYS here:
C:\Users\YOUR USERNAME HERE\Documents\My Games\Grim Dawn"
and i also dont get a folder there.
When i create this folder by myself, it also doesnt save in there.
So i dont know where i does download the cloudsave to.

do a system search for your char name, should pop up with a results you can click/see the folder from

Thanks, it was in onedrive, i found it after reading the OG-post and some follow up posts over there.

The dreaded OneDrive again. :rage: That thing is a menace.