Back

Collection - Attribute stuck

  • 0
  • Self Hosted
  • Databases
paulanerl
15 Mar, 2024, 11:20

Hi guys,

I have an attribute stuck in 2 of my collections, I logged into my mariadb to delete this attribute manually. But in the mariadb table I cannot find this specific attribute. I just found in another collection a number instead of an attribute name. Could this be that this is my "stuck" attribute somehow??

The "other" collection where I see this number was recreated because of the "stuck" attribute. In the console is here everything normal.

To understand this: I have 2 collections which have a attribute relationship called "connections" to a collection named "connections" - xD In this "connections" album I found the numbers in the mariadb. In the 2 collections is the "stuck" attribute showing up....

I hope you can understand this - thanks

TL;DR
Developers deleted an attribute using a command, but the collection still required the attribute, rendering it useless. After restoring a backup, they believe there may be remnants of the attribute in the database. They found more details on the issue and noted using Appwrite version 1.5.3. Solution: It's recommended to thoroughly search for fragments of the attribute in the database, as deleting attributes through a command may not fully remove all dependencies.
D5
16 Mar, 2024, 21:23

What's your appwrite version?

Steven
16 Mar, 2024, 21:28

What was the status before stuck?

Steven
16 Mar, 2024, 21:29

What do the Details say?

paulanerl
18 Mar, 2024, 06:47

sorry for late response - I have appwrite version 1.5.3

paulanerl
18 Mar, 2024, 06:48

actually I have no information about this - This did someone else - I cannot retrieve this info

paulanerl
18 Mar, 2024, 06:49

What details?

paulanerl
18 Mar, 2024, 06:53

Actually I made some progress - I found the attribute with the command you see in the picture(hope you can se this)

paulanerl
18 Mar, 2024, 06:54

you can see here the error "Attribute not found"

paulanerl
18 Mar, 2024, 07:00

I already deleted this attribute via command "delete from ...." but then actually I were not able to use this collection again, because if I wanted to create a new document - it still required this "connections" attribute but there was no field to fill in... so the whole collection was now useless. Also the entry in the attributes section of the collection was still there.... Luckily I made a backup before 😎 and then I just restored it.

So I think there must be more fragments of this attribute in the database - you have any idea where?

Thanks.

Reply

Reply to this thread by joining our Discord

Reply on Discord

Need support?

Join our Discord

Get community support by joining our Discord server.

Join Discord

Get premium support

Join Appwrite Pro and get email support from our team.

Learn more