Internal database error: Issue deleting data base rows!

What I’m trying to do:
call delete() on a database row.

What I’ve tried and what’s not working:

Code Sample:

def delete_media(media,order):
  media = check_table_obj(media,app_tables.media) # Grabs row from media table
  order = check_table_obj(order,app_tables.orders) # Grabs row from order table
  if order:
    delete_required_link(media,order)
  media.delete() # line with error

Here is the error message:

anvil.tables.TableError: Internal database error: 
ERROR: function get_lo_size(integer) does not exist 
Hint: No function matches the given name and argument types. You might need to add explicit type casts. 
Position: 34

I never had issue with this method before which leads me to believe it is a result of an update from anvil.

Please help!

Same here. “function get_lo_size(integer) does not exist”

Edit: Crazy, five minutes later… and it’s working again. :man_shrugging:

1 Like

Hi folks

Sorry about that - it’s working again because we spotted the problem and fixed it. Apologies for the interruption!

2 Likes

We’re still seeing this error - with a slight variation in the error name from the earlier posts. The latest occurrence was a few minutes ago, so I don’t think it’s fixed:

anvil.tables.TableError: Internal database error: ERROR: function get_lo_size(bigint) does not exist
  Hint: No function matches the given name and argument types. You might need to add explicit type casts.
  Position: 8
<running on the server>