VPS error hit me last night, I can backup the containers but I am unsure how to do so..

can't find anything on attempts to handle DB storage transfers

TL;DR

The user encountered an error while updating card art URLs on their VPS. They attempted to restore from a backup but are unsure how to do so. They suspect it may be a bug and mentioned the specific error they received. The user shared code snippets showing the update process. They mentioned exhaustion and lack of sleep. Another user suggested watching a YouTube video on backing up and restoring servers. There is no solution mentioned in the thread.

if anyone replies please @ me

Sorry to hear about your VPS disaster 😕

I would backup from the old server and restore to the new:

https://www.youtube.com/watch?v=lM5yZEPtlvg&ab_channel=Appwrite

thank you, still at it, going to check this out now

so, I managed to salvage everything but there is this really odd thing going on

TypeScript

    def updateCardArtURLAttributes(self, collectionID):# payload will have the documentID
      url = self.ENDPOINT + "/databases/" + self.DATABASE_ID + "/collections/" + collectionID + "/documents?queries[0]=limit(100)"
      self.log.info(url)
      jsonResponse = requests.request("GET", url, headers={'X-Appwrite-Project': str(self.PROJECT)} , data = {}).json()
      self.log.info("\n jsonResponse : \n" + str(jsonResponse) + "\n \n \n")
      cardArtURLList = []
      totalDocuments = int(jsonResponse['total'])      
      if totalDocuments >= 100:
        totalDocuments = 100
      for index in range(0,totalDocuments - 1):
        print(index)
        databases = Databases(self.CLIENT)
        documentID = str(jsonResponse['documents'][index]['$id'])
        cardName = str(jsonResponse['documents'][index]['cardName'])
        cardArtFileSaveName = str(jsonResponse['documents'][index]['cardName']).replace(" ", "-") +'.png'
        cardArtURL = str(self.HOST_URL) + "/cardArt/" + str(cardArtFileSaveName)
        # self.log.info("updating " + str(jsonResponse['documents'][index]['cardName']) + "'s cardArt URL to : " + cardArtURL + " \n ")
        # print(str(self.DATABASE_ID) + ' ' + str(collectionID) + ' ' + str(documentID)) 
        print(str(jsonResponse['documents'][index]))

TypeScript

      
        self.log.info(str(self.DATABASE_ID) + ' ' + str(collectionID) + ' ' + str(documentID))
        cardArtURLList.append({ "documentID" : str(documentID), "cardName" : str(cardName), "cardArt" : str(cardArtURL) })
        try:
          data ={ "cardURL" : str(cardArtURL) } 
          print(data)
          result = databases.update_document( self.DATABASE_ID, collectionID, documentID, data ={ "cardArt" : str(cardArtURL) } )
        except Exception as e:
          self.log.error("\n================================================\nerror while attempting to update cardArt links \nIOError :\n" + str(e) )
          print("\n================================================\nerror while attempting to update cardArt links \nIOError :\n" + str(e) )
      return cardArtURLList

honestly, I am exhausted

have not slept for about 2 days and have been on this after being awake long enough to not be tired again, about to call it here but I think I should mention what is going on

as it is strange

the above didn't have any issues until the importing of the backed up DB data

there are two services that engage this method

they both have the same attributes and schema

and the payloads, everything comes out the same

but for some reason one of the two was throwing this error

I haver to update the card art urls because the endpoint they were using has changed as I have changed servers

at first the prompt said that there was no "cardArt" attribute, and there is and should be... but it was so odd I decided to remove it

and now I am receiving the same error but for the next top line item in the schema

but I am doing a update

and my payload doesn't have anything other than the contents needing to be updated

I think this might actually be a bug

I am going to update as I see a prompt

but wanted to give the feedback

What error?

How exactly did you restore?

Reply

Reply to this thread by joining our Discord

Reply on Discord

Need support?

Join our Discord

Get premium support

VPS error hit me last night, I can backup the containers but I am unsure how to do so..

Recommended threads

Need support?

Join our Discord

Get premium support