Video Tutorial Clone Rarible part 8: the columns for the cloud function do not appear

dipi5 · December 26, 2022, 1:22pm

Hi guys

I am following the tutorial to clone Rarible and until it was necessary to work with the Cloud Functions everything was fine and everything worked perfectly as from the videos.

In practice, the columns on the left do not appear in the database and specifically: EthNFTTokenOwners rather than EthTokenBalance.

Having said that, the columns inside the table do not even appear such as: token_uri, symbol, id and all the others necessary to perform the cloud function.

I attach here the screen that I see in the database.

Would anyone know how to help me?

DavisX · January 12, 2022, 1:51pm

Hi dipi5 !
In your cloud function, you must replace “EthNFTTokenOwners” now by “EthNFTOwners” :

const query = new Moralis.Query("EthNFTOwners");

Moralis is fantastic but this is the main problem i have noticed so far : the syntax/labels/keywords spelling is reformed way too often making headaches and burnout for a lot of people.
If it doesn’t work, you should share your entire cloud function code.
(I deleted my previous post because my comment formating was not OK. I’m new too on this forum)

dipi5 · January 12, 2022, 3:04pm

Thanks a lot for reply. However I think problem is before cloud function due database doesn’t display EthTokenOwner and on any table I don’t see strings as: symbol, token_uri, token_address and others

I read somewhere that this variables appear automatically when I mint an NFT but It’s not so to me

However this is cloud function code:

Moralis.Cloud.define("getUserItems", async (request) => {

    const query = new Moralis.Query("EthNFTOwners");
    query.equalTo("contract_type", "ERC721");
    query.containedIn("owner_of", request.user.attributes.accounts);
    const queryResults = await query.find();
    const results = [];
    for (let i = 0; i < queryResults.length; ++i) {
      results.push({
        "tokenObjectId": queryResults[i].id,
        "tokenId": queryResults[i].attributes.token_id,
        "tokenAddress": queryResults[i].attributes.token_address,
        "symbol": queryResults[i].attributes.symbol,
        "tokenUri": queryResults[i].attributes.token_uri,
      });
    }
    return results;
  });

DavisX · January 13, 2022, 12:52pm

dipi5,
you have a mistake in your cloud function code, under results.push(). Instead of :
"tokenObjectId": queryResults[i].id,
… you must write :
"id": queryResults[i].attributes.objectId,

You can verify it on the video part 8 at minute 12’30".

Try to mint a new NFT and let met know if this time it works. If not, i would like to know if you use ganache as a local blockchain.
(sorry for not answering earlier, i have a job beside this Moralis hobby ahahahah)

DavisX · January 13, 2022, 1:06pm

I have also found a mini-mistake but i think it is not relevant for the code to work properly. Always in the results.push() function, you wrote :
"tokenId": queryResults[i].attributes.token_id,
… but if you really want to respect the code as displayed in the video, you should write :
"tokenid": queryResults[i].attributes.token_id,

I made the same mistake than you the first time because i wanted to respect the spelling logic (ex: in the video, it is “tokenAddress” and not “tokenaddress”. But, i don’t know why, Niklas wrote “tokenid” instead of “tokenId”. I suggest you to reproduce this same “”“mistake”"" in order to be sure all your scripts work perfect all together.

dipi5 · January 13, 2022, 2:17pm

Don’t worry, I know ahaha

However I’ve just tried but I have the same problem

DavisX · January 13, 2022, 3:47pm

OK, if it does not work yet, no problem. I think it’s normal :
if you have made some errors during typing your code, video after video, it is most likely normal the Moralis database does not respond properly yet. I’m going to give you an advice i found and that worked great for me. It is a bit annoying to do it but this is the only solution.

First, i wanted to know if you work on a local blockchain such as Ganache ?
If you use ganache, like me, and if you are now 100% sure there is no mistake in your website* (folders “frontend” + "contracts), then do as following :
1- don’t do any change for now in your website’s scripts.
2- empty your ganache server (delete any existing server you may have) and re-create a new ganache server for this tutorial.
3- delete your Moralis server and recreate it.
4- when you have a brand new ganache server + a brand new Moralis server, launch your website, connect your wallet and mint an NFT.

It really worked for me. It looks like if you have made some errors in your websites’ script (and/or your Moralis server), then some database tables (on Moralis) may have been created and populated properly but some other tables didn’t (remember your could function mistake). IF you reload with brand new servers, then your tables should all be properly created and populated.

Also, another advice i have readen on this forum :
when you develop such a project, it is highly recommanded to have only 1 server created in ganache for your project. Because if you have several servers, this can create problems. For example, in my ganache, i had 3 servers : “sam_demo_1”, “sam_demo_2”, etc… But sometimes, when restarting a ganache server (to refresh new blocks i could not see), i was clicking on a wrong server and then starting to interact with moralis. This kind of error can start to store data on Moralis but ending with an error due to no response from ganache… and then we go again for new problems. I have readen that some database tables on Moralis can be “corrupted” due to this wrong manipulation. Believe me: one day i was totally sure my code was clean but i could not see a good reaction on Moralis. When i restarted ganache and Moralis from scratch, everything was working fine for me

If it does not work, then i think you have a problem in your website’s script. Then you should post your main.js + contracts script here. I hope a Moralis moderator can take a look on it. I will stay online to keep up with you.

Success ! (and Happy new year, by the way !!)

xavierx · January 13, 2022, 4:48pm

The issue is Moralis made a new upgrade and those tables have disappeared, that tutorial is no longer valid and you need to report in the discord on how to use the API instead

DavisX · January 13, 2022, 6:18pm

Lots of upgrades, yes, but i succeeded to go till part 14. I can create NFTs, get them listed in Moralis. I can even post an NFT in my marketplace. I think this tutorial still doable even if outdated, dont’ you think?

dipi5 · January 13, 2022, 8:48pm

Thanks so much. So I tried to delete Ganache, deleted all Moralis servers and created a new one.

Now I have connected the new server on main.js. Then I created a new Ganache server, ran everything in the Moralis Devchain Proxy Server section and ran “frpc.exe -c frpc.ini”.

So far everything okay so I start the first procedure, to internderci “truffle migrate” and I have these problems:

-Devchain Proxy Server doesn’t make me change status in Connecting
-The terminal then reports me these errors:> Compiled successfully using:

solc: 0.8.11 + commit.d7f03943.Emscripten.clang

Something went wrong while attempting to connect to the network at http://127.0.0.1:7545. Check your network configuration.

Could not connect to your Ethereum client with the following parameters:
- host> 127.0.0.1
- port> 7545
- network_id> 5777
Please check that your Ethereum client:
- is running
- is accepting RPC connections (i.e., “–rpc” or “–http” option is used in geth)
- is accessible over the network
- is properly configured in your Truffle configuration file (truffle-config.js)

Truffle v5.4.28 (core: 5.4.28)
Node v16.13.1

At this point Ganache disconnects.

I really don’t know what to do

dipi5 · January 17, 2022, 3:01pm

Hi Davis

So, I answer here so it might help other people here in the community as well.

I did exactly as you said:

Eliminated all Ganache servers
Eliminated all Moralis servers
Created a new Moralis server and connected inside main.js
Created a new Ganache server and started
Run “Truffle migrate” again and create a new NFT for testing

Everything went perfectly and it seems to have also solved the problem now with the Clou Fuction to call up the display of items in “my items”.

Thank you very much, you have been very helpful to me!

DavisX · February 1, 2022, 12:18am

@dipi5 + everyone [UPDATE !!!] :
Be carefull with your cloud functions if you decide to stop deploying on local ganache to deploy on a public TestNet or public MainNet : you must update your cloud functions with new table name(s) from your Moralis server !!

For example, in your cloud functions, if for ganache, you used “EthNFTOwners” when you migrate to Avalanche blockchain, you must use “AvaxNFTOwners”.

I have found this quite huge issue when migrating to AVAX. All my client/server scripts were working good, except the listing of NFTs for each user + for the marketplace. There was indeed no “item” table created. When i changed the table names in my Cloud function, then everything worked fine! If my memory is good, this remark has not been mentioned by Niklas in the video tutorial.

I guess that it is exactely the same logic to use for other blockchains, but i’m not sure yet as i haven’t deployed yet on Fantom (FTM) or Polygon (MATIC).
I guess that if you deploy on Fantom, you should replace “EthNFTOwners” by “FtmNFTOwners” or something similar. Just create a public test server on Moralis with the blockchain you like and you will immediately see the special names for some tables in the database.

DavisX · January 31, 2022, 4:11pm

Here some screenshots to clarify my just previous post.

If you use your local ganache, this is how look your table names in your Moralis server :

If you use the Avalance TestNet, this is how look your table names in your Moralis server :`

This means you must replace :
const query = new Moralis.Query("EthNFTOwners");

… by :
const query = new Moralis.Query("AvaxNFTOwners");