Object Not Found on Update

Technical Issue Reporting
#3

you can try .save(null,{useMasterKey:true});

https://docs.moralis.io/moralis-server/cloud-code/cloud-functions#using-the-master-key-in-cloud-code

#4

@cryptokid Thank you for your reply.

This does not fix the issue. Is there anything else i can try?

#5

you can try await for that .save

#6

Yup. Tried that already…

  const queryResult = await query.first();
  queryResult.set("theUpdateValue", request.params.canClaim);
  return await queryResult.save(null,{useMasterKey:true})
#7

you can try .find instead of .first and then to get the first element, it shouldn’t be a difference

#8

That was the first approach that i tried. Then i found Moralis: Updating Objects which used .first()

The table has many rows. Like 23k, could that be related?

#9

what is the server url?
it shouldn’t be a problem with 23k rows

#10

https://7bom7bqipiks.usemoralis.com:2053/server

#11

does it work with other tables or it never worked?

#12

I have not needed to update other tables. I can try i guess.

It has never worked, this is my first time implementing it.

List/Get/Create all seem to work fine. It is only the update that is letting me down.

#13

This table was populated with Direct Database access. That could be another difference.

https://docs.moralis.io/moralis-server/database/direct_access

#14 

import json
import pymongo

MONGO_HOST = "2342"
MONGO_PORT = 56728

con = pymongo.MongoClient(MONGO_HOST, MONGO_PORT)
qualifier_table = con['parse']['AirdropQualifier']

with open(f"qualifier_data.json","r") as json_file:
    white_list = json.load(json_file)

qualifier_table.insert_many(white_list)

The createdAt and updatedAt fields are (undefined)

Screenshot 2022-03-24 at 12.02.33 am
Screenshot 2022-03-24 at 12.02.33 am2980×112 15.2 KB

#15

I saw that the table seems to have strange data, like no createdAt or updatedAt, and the objectId seems strange, maybe that is the problem

#16

I’ll try adding those fields when i populate the database. This is starting to make sense!

#17

It’s looking better in the tables, but still the same error.

Screenshot 2022-03-24 at 12.12.02 am
Screenshot 2022-03-24 at 12.12.02 am2742×248 46.1 KB

#18

can you try not to set the objectId and maybe it creates automatically an object id?

#19

That’s what we did originally.

I tried again, setting only createdAt and updatedAt and it now has duplicated ids.

I’ll try doing it manually via the Moralis SDK but with 23k rows it is not ideal.

#20

where is bulk write too

createdAt and updatedAt shouldn’t be the problem, but that ID didn’t look like an id with the same format as in the other tables

#21

BulkWrite only works from cloudfunctions.

This is going to take awhile.

#22

can you test first if it works fine with few rows?