Moralis not storing gas in transaction tables

Technical Issue Reporting
#12

you could connect directly to mongo db, dump database and load some tables in the new server

cloud code you could copy it directly

#13

Hi @cryptokid. I finished setting up the new beta nitro server, although they do not appear to be working. The transaction history tables are not created at all. Is there any specific changes that need to be done on the new platform to get these transaction tables created and populated ?

#14

What you mean by transaction history tables?

#15

sure, attached. These tables are not auto generated on the new platform.

Screen Shot 2022-01-29 at 8.54.26 AM
Screen Shot 2022-01-29 at 8.54.26 AM486×680 59.8 KB

#16

The tables usually are not autogenerated and they only appear when there is data in those tables

#17

hmm, the same wallet produces these tables on the old servers.
It looks like some transaction tables are only partially populated(on new platform), on the old servers i have a complete history of my wallet. On the new nitro server i only have the last dozen or so transactions populated (from same wallet)
And whats also not showing are the Balance tables(ethBalance, PolygonBalance, ect) i definitely have wallet balances, so they should appear in Balance tables. As they do with same wallet on old servers.

#18

about transactions, yes, only last 50 transactions are synced, so that the server doesn’t get overwhelmed if lots of users are logging in, you can get all the transactions using watch address functionality

some tables will be missing, like that balance table

#19

thanks cryptokid. How do i get the balance tables back ? Those tables are called lots in my code.

And also can you confirm is the below code will enable syncing historical transactions on new servers ?
const results = await Moralis.Cloud.run(“watchBscAddress”, {address: “0x…”, sync_historical: true});

Its from the moralis docs, however I have just tried it and its returning invalid function errors.
{“code”:141,“error”:“Invalid function: “watchBscAddress””}

#20

I don’t know how you can get the balance tables back.

It should work to watch an address by code now, but it should ask for master key.

and you should get this message error for that code: Error: Validation failed. Master key is required to complete this request.

#21

Are you using beta?

In the new version there are no balance tables - don’t use them - read this Moralis Nitro Beta Testing

Watch this: https://youtu.be/Lc6vp-NTh0I

The syntax for syncing address programmatically is different now - let me get it

#22

Hello Sam,

The code you sent does look correct, can you confirm that BSC is the selected chain.

Thank you

#23

thanks CryptoKid, same error though.
{“code”:141,“error”:“Invalid function: “watchEthAddress””}

#24

Hi Ivan,
Yes on the beta.
Got it, looks like ill have to re-write things if balances are now gone :frowning:

#25

Thanks Ryan.
I did do a test connected to the right chain, however do i need to be connected to the chain ? Im writing a multichain app and need to pull data from the same wallet address across all chains, and cant be connected to all chains at same time.

#26

You need to have all chains you want selected in EVM Configuration

This is how you sync address in the new version (currently beta):

await Moralis.Cloud.run('coreservices_addAddressSync', {address: "0x704111eDBee29D79a92c4F21e70A5396AEDCc44a", chainId: "0x89", syncHistorical: true },
{useMasterKey:true})
}
#27

is this still a problem that you see now, with missing information about gas?

#28

yes, Moralis is always missing gas.

#29

on what chain you see that now?

#30

Ethereum, Polygon, Binance, Avalanche. I just re-ran same code, the amount of transactions not storing gas is even worse then last year.

#31

no urgency as our team has switched to another platform that captures transaction gas fees. Let me know if you can ever fix this and we can reconsider Moralis again in the future.