Schema sync bug: Update column failed. Unknown column 'listingId2' in 'udt.flaggedListings' (Error 1145)

Data Service
1

Hello Backendless Team,

I am experiencing an issue where my database schema has fallen out of sync with the Backendless Console UI.

I have a ghost column header named listingId2 in my flaggedListings data table that I cannot delete. When I try to drop or remove it via the console UI, the server returns a 400 Bad Request error.

App Details:

Application ID: 164B1AF3-FA53-458D-BC59-E793AA35CBCE
Table Name: flaggedListings
Target Ghost Column: listingId2

Steps Taken:

  1. My first attempt to delete the column yielded Error Code 1091: “Can’t DROP ‘listingId2’; check that column/key exists”.
  2. Subsequent attempts to delete or interact with the column now consistently throw Error Code 1145: “Update column failed. Unknown column ‘listingId2’ in ‘udt.flaggedListings’”.

It appears the physical column was deleted from the underlying MySQL layer, but the Backendless metadata layer still caches the header, preventing it from clearing in my dashboard. [1]

Could a support engineer please trigger a backend schema synchronization or manually purge this column mapping from my app metadata?

Thank you for your assistance!

2

Hi @Olga_Hanelt

We can see the problem. I have created an internal ticket to investigate and fix the issue. We will let you know about any update here in the topic.

Regards,
Vlad

4

Your app has been fixed, could you please check and confirm that?

5

It’s fixed, thanks so much, Vlad!

1 Like