[RESOLVED] anvil.tables.TableError

Anvil Q&A
1

My code just (in the last few minutes) started breaking on any app_tables access (e.g. app_tables.tablename.get()). This is the error, and it happens in all the apps that I tried including untouched production versions:

New session: 06/04/2022, 11:17:52

anvil.tables.TableError: Internal database error: ERROR: syntax error at or near "-" Position: 748
Learn more about Data tables  
<running on the server>
called from anvil-services/anvil/users/__init__.py:534
called from anvil-services/anvil/users/__init__.py:534
called from Authors.Utilities.AuthorNavigationBase, line 65
anvil.tables.TableError: Internal database error: ERROR: syntax error at or near "-" Position: 748
Learn more about Data tables  
<running on the server>
called from /downlink/anvil/_server.py:41
called from ServerModule1, line 2988
called from ServerModule1, line 3011
called from Utilities.ErrorAlert, line 39
12 Likes
2

We’re getting this too.

3

Same here !!

Maybe some maintenance from anvil?

4

Same for me:

anvil.tables.TableError: Internal database error: ERROR: syntax error at or near "-" Position: 748

5

yes same here.

TableError: Internal database error: ERROR: syntax error at or near "-" Position: 748

6

image
image812×182 8.67 KB

:flushed:

7

pls help Anvil staff:

TableError: Internal database error: ERROR: syntax error at or near "-" Position: 748

@ian @meredydd

8

Yep, picture from one of my users tablets:

image

… and I just got a phone call from the accounting department, a different app is down also.

9

Hello,

I have that same problem, all my applications are affected:

image

BR,

10

While I’m hoping someone is working on a fix for this in the background while we speak, I’ll add my voice that I am having the same issue.

1 Like
11

Hi all,

Thanks for raising this. We’re working on it and will update you as soon as it’s fixed.

Sorry for any inconvenience caused.

4 Likes
13

This should now be fixed. We’ll be keeping an eye on things but please let us know if you have any issues.

3 Likes
14

Hello,

I am getting the following error when running my applications:

image

All my applications are giving this error. what is going on?

I haven’t touched anything, it just started crashing now.

Thanks in advance!

15

This has been reported to Anvil Support, and in this thread: [RESOLVED] anvil.tables.TableError

2 Likes
16

Thank you for the information!

17

I can confirm that this is working for me, now. Thanks for the quick fix!

18

Yes it seems to be working now :dart: :racing_car:

19

My applications are already working. Thank you!