Lesson 15 - Moralis Database Events not updating

[CodeLikeLisa]

Hi - I have successfully synced my hardhat to my moralis server. Upon running node addEvents.js my database shows _EventSyncStatus with a value of 3 and my contract events show up in the database... However when running mint-and-list.js - although I get a successful listing message in my terminal - it fails to populate my ItemListed table in my moralis database.

[CodeLikeLisa]

@alymurtazamemon @PatrickAlphaC I'd appreciate any assistance

[iangechuki]

This happened to me too.Ensure in your cloud function there are no spelling errors .Some of those may not be logged on moralis and might be hard to find .If not reset everything in your development evironment.If doesn't work upload the file with the cloud functions here.

[CodeLikeLisa]

Do you have specifics regarding the reset? I have started and stopped the the hardhat node a couple of times

[CodeLikeLisa]

Added note - I did not see _EthAddress table... and my user table does not update when I log in with metamask on my frontend site

[CodeLikeLisa]

cloudFunctions is the following step in the tutorial... So the only things I have relevant to this is my addEvents.js and mint-and-list.js

[CodeLikeLisa]

`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
const contractAddressArray = contractAddresses[chainId]["NftMarketplace"]
const contractAddress = contractAddressArray[contractAddressArray.length - 1]

const serverUrl = process.env.NEXT_PUBLIC_SERVER_URL
const appId = process.env.NEXT_PUBLIC_APP_ID
const masterKey = process.env.masterKey

async function main() {
await Moralis.start({ serverUrl, appId, masterKey })
console.log(Working with contract address ${contractAddress})

let itemListedOptions = {
    // Moralis understands a local chain is 1337
    chainId: moralisChainId,
    sync_historical: true,
    topic: "ItemListed(address,address,uint256,uint256)",
    address: contractAddress,
    abi: {
        anonymous: false,
        inputs: [
            {
                indexed: true,
                internalType: "address",
                name: "seller",
                type: "address",
            },
            {
                indexed: true,
                internalType: "address",
                name: "nftAddress",
                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: "nftAddress",
                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 itemCanceledOptions = {
    chainId: moralisChainId,
    address: contractAddress,
    topic: "ItemCanceled(address,address,uint256)",
    sync_historical: true,
    abi: {
        anonymous: false,
        inputs: [
            {
                indexed: true,
                internalType: "address",
                name: "seller",
                type: "address",
            },
            {
                indexed: true,
                internalType: "address",
                name: "nftAddress",
                type: "address",
            },
            {
                indexed: true,
                internalType: "uint256",
                name: "tokenId",
                type: "uint256",
            },
        ],
        name: "ItemCanceled",
        type: "event",
    },
    tableName: "ItemCanceled",
}

const listedResponse = await Moralis.Cloud.run("watchContractEvent", itemListedOptions, {
    useMasterKey: true,
})
const boughtResponse = await Moralis.Cloud.run("watchContractEvent", itemBoughtOptions, {
    useMasterKey: true,
})
const canceledResponse = await Moralis.Cloud.run("watchContractEvent", itemCanceledOptions, {
    useMasterKey: true,
})
if (listedResponse.success && canceledResponse.success && boughtResponse.success) {
    console.log("Success! Database Updated with watching events")
} else {
    console.log("Something went wrong...")
}

}

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

[DEFIdaniel1]

Try changing
const contractAddress = contractAddressArray[contractAddressArray.length - 1]
to
const contractAddress = contractAddressArray[chainId]['NFTMarketplace'][0]

Also, I needed to declare chainId, moralisChainId, and the marketplaceAddress, and contract address inside the main() function.