Lesson 15: Moralis database is not updating with the event details

[sanjayojha]

I can see there are already couple of question related to this and I also confirm this problem. I have reset the local chain as suggested by @PatrickAlphaC . But still running yarn hardhat run ./scripts/mint-and-list-item.ts --network localhost is not populating rows in ItemListed table. I have restarted the server and reset the local chain on Moralis. I have also cross checked the addEvents.js script carefully for any typos.

My addEvents.js file

const Moralis = require("moralis/node");
require("dotenv").config();
const contractAddresses = require("./constants/networkMapping.json");
let chainId = process.env.chainId || "31337";
let moralisChainId = chainId == "31337" ? "1337" : chainId; // Moralis consider localchain at 1337.

/* Moralis init code */
const serverUrl = process.env.NEXT_PUBLIC_MORALIS_SERVER_URL;
const appId = process.env.NEXT_PUBLIC_MORALIS_APP_ID;
const masterKey = process.env.moralisMasterKey;

async function main() {
    await Moralis.start({ serverUrl, appId, masterKey });
    const contractAddress = contractAddresses[chainId]["NftMarketplace"][0];
    console.log(`Working with contract address: ${contractAddress}`);

    //events logging
    let itemListedOptions = {
        chainId: moralisChainId,
        address: contractAddress,
        sync_historical: true,
        topic: "ItemListed(address,address,uint256,uint256)",
        abi: {
            anonymous: false,
            inputs: [
                {
                    indexed: true,
                    internalType: "address",
                    name: "seller",
                    type: "address",
                },
                {
                    indexed: true,
                    internalType: "address",
                    name: "marketplaceAddress",
                    type: "address",
                },
                {
                    indexed: true,
                    internalType: "uint256",
                    name: "tokenId",
                    type: "uint256",
                },
                {
                    indexed: false,
                    internalType: "uint256",
                    name: "price",
                    type: "uint256",
                },
            ],
            name: "ItemListed",
            type: "event",
        },
        tableName: "ItemListed",
    };

    let itemBoughtOptions = {
        chainId: moralisChainId,
        address: contractAddress,
        sync_historical: true,
        topic: "ItemBought(address,address,uint256,uint256)",
        abi: {
            anonymous: false,
            inputs: [
                {
                    indexed: true,
                    internalType: "address",
                    name: "buyer",
                    type: "address",
                },
                {
                    indexed: true,
                    internalType: "address",
                    name: "marketplaceAddress",
                    type: "address",
                },
                {
                    indexed: true,
                    internalType: "uint256",
                    name: "tokenId",
                    type: "uint256",
                },
                {
                    indexed: false,
                    internalType: "uint256",
                    name: "price",
                    type: "uint256",
                },
            ],
            name: "ItemBought",
            type: "event",
        },
        tableName: "ItemBought",
    };

    let listingCancelledOptions = {
        chainId: moralisChainId,
        address: contractAddress,
        sync_historical: true,
        topic: "ListingCancelled(address,uint256,address)",
        abi: {
            anonymous: false,
            inputs: [
                {
                    indexed: true,
                    internalType: "address",
                    name: "marketplaceAddress",
                    type: "address",
                },
                {
                    indexed: true,
                    internalType: "uint256",
                    name: "tokenId",
                    type: "uint256",
                },
                {
                    indexed: false,
                    internalType: "address",
                    name: "seller",
                    type: "address",
                },
            ],
            name: "ListingCancelled",
            type: "event",
        },
        tableName: "ListingCacelled",
    };

    let itemUpdatedOptions = {
        chainId: moralisChainId,
        address: contractAddress,
        sync_historical: true,
        topic: "ItemUpdated(address,address,uint256,uint256)",
        abi: {
            anonymous: false,
            inputs: [
                {
                    indexed: true,
                    internalType: "address",
                    name: "seller",
                    type: "address",
                },
                {
                    indexed: true,
                    internalType: "address",
                    name: "marketplaceAddress",
                    type: "address",
                },
                {
                    indexed: true,
                    internalType: "uint256",
                    name: "tokenId",
                    type: "uint256",
                },
                {
                    indexed: false,
                    internalType: "uint256",
                    name: "newPrice",
                    type: "uint256",
                },
            ],
            name: "ItemUpdated",
            type: "event",
        },
        tableName: "ItemUpdated",
    };

    const listedRespo = await Moralis.Cloud.run("watchContractEvent", itemListedOptions, {
        useMasterKey: true,
    });
    const boughtRespo = await Moralis.Cloud.run("watchContractEvent", itemBoughtOptions, {
        useMasterKey: true,
    });
    const cancelledRespo = await Moralis.Cloud.run(
        "watchContractEvent",
        listingCancelledOptions,
        { useMasterKey: true }
    );
    const updateRespo = await Moralis.Cloud.run("watchContractEvent", itemUpdatedOptions, {
        useMasterKey: true,
    });

    if (
        listedRespo.success &&
        boughtRespo.success &&
        cancelledRespo.success &&
        updateRespo.success
    ) {
        console.log(
            "Updated! You should now be able to see these tables in your database. \n Note: You won't be able to see the events on the `sync` tab of the UI though."
        );
    } else {
        console.log(
            "Something went wrong uploading events... Try manually importing for a better error code. "
        );
    }
}

main()
    .then(() => process.exit(0))
    .catch((error) => {
        console.error(error);
        process.exit(1);
    });

and the events

// Events
    event ItemListed(
        address indexed seller,
        address indexed marketplaceAddress,
        uint256 indexed tokenId,
        uint256 price
    );
    event ItemBought(
        address indexed buyer,
        address indexed marketplaceAddress,
        uint256 indexed tokenId,
        uint256 price
    );
    event ListingCancelled(
        address indexed marketplaceAddress,
        uint256 indexed tokenId,
        address seller
    );
    event ItemUpdated(
        address indexed seller,
        address indexed marketplaceAddress,
        uint256 indexed tokenId,
        uint256 newPrice
    );

[krakxn]

Can you make a repo and link it here? I will look into it.

[opeseyi]

I'm also facing the same issue

[Rishi860]

Same issue.
If someone gets any answer please tag me.

[krakxn]

The OP does not seem to link their repo -- could any of you make a separate discussion, thank you.

[sanjayojha]

The OP does not seem to link their repo -- could any of you make a separate discussion, thank you.

The lesson is still incomplete. I can provide any other file if you need to see. I have also conversation with Moralis team and it look like issue is with their hardhat proxy server

[sanjayojha]

Ok, Issue is fixed. The issue was from Moralis side. They had some problem with hardhat. They have fixed it after my conversation with them. So to use it, you guys have to delete old server and create a new one.
Check the thread on Moralis forum
https://forum.moralis.io/t/event-is-not-logging-in-moralis-database-on-devchain/17848/14
@krakxn @CodeLikeLisa @opeseyi @Rishi860 @PatrickAlphaC

[Rishi860]

Thanks a lot man!

[BhaveshJoshi2000]

Thank you brother You saved lot of time!

[Rishi860]

I still got the same error, no updates on the events listed. After creating a fresh server in moralis.
But this time I went into the mongodb section of the dapp and there was a section of all the whitelisted IPs and I put my IP address there and then it worked.

I am not sure that it was needed to be done in order for it to work. But it does make sense, since we are updating or listing our nft in the database.
Can anyone tell the way I am thinking is right or not?
Any comments or suggestions are appreciated.

[sanjayojha]

Not sure why, but it worked for me as soon as I created a new server after the moralis team fixed it.

[yersel500]

@Rishi860 do you mean you put the IP public address or other Ip?. I'm facing the same issue

[shoaibshebi]

I was facing the same issue , now solved @yersel500

I was making the mistake in hardhat.config.js file

hardhat: {
      // forking: {
      //   url: MAINNET_RPC_URL
      // }
      chainId: 31337,
    },

I was forking the hardhat local chain , now i commented 😇

[dwhaynes]

Did you have to make a new server after fixing that? I made the same mistake but rerunning the script without forking still doesn't work.

[shoaibshebi]

just deployed the contracts again, reset metamask, and reset the chain on Morallis

[dwhaynes]

Clicking the "Reset Local Devchain" button doesn't appear to work. Is there a way to verify that it was reset?

[shoaibshebi]

Actually it do reset the local devchain on clicking button, but don't show any update
you can check in devtools->network tab. On clicking reset, it shows the successful request