Underscore in tablename possible? [Feb 04]

[NocoDB]

Anti asked

Hey guys, Do tables with underscores not work?

[NocoDB]

o1lab replied

Yes

[NocoDB]

o1lab replied

they should

[NocoDB]

Anti replied

i imported a database, No data is showing due to the underscores it seems

[NocoDB]

Anti replied

and in the names the underscores are also gone

[NocoDB]

Anti replied

Oh wait…I see just 1 table isn’t showing anything

[NocoDB]

o1lab replied

while creating project, you can see advanced options

set the inflection to none

[NocoDB]

o1lab replied

hmm ok

[NocoDB]

o1lab replied

so you are able to see other tables?

[NocoDB]

Anti replied

Yes, The other ones with underscores work, just 1 single table doesnt show anything

[NocoDB]

Anti replied

columns are there, records are not

[NocoDB]

o1lab replied

starts with a number or something>

[NocoDB]

o1lab replied

?

[NocoDB]

o1lab replied

paste the project info from right top menu

[NocoDB]

Anti replied

Node: v12.22.6

Arch: x64

Platform: linux

Docker: true

Database: mysql2

ProjectOnRootDB: false

RootDB: sqlite3

PackageVersion: 0.84.8

[NocoDB]

Anti replied

ah wait, i think i see

[NocoDB]

Anti replied

innodb crashes, this table is MyISAM

[NocoDB]

Anti replied

```

2022-01-31 2:29:00 0 [Note] InnoDB: Creating shared tablespace for temporary tables

2022-01-31 2:29:00 0 [Note] InnoDB: Setting file ‘./ibtmp1’ size to 12 MB. Physically writing the file full; Please wait …

2022-01-31 2:29:00 0 [Note] InnoDB: File ‘./ibtmp1’ size is now 12 MB.

2022-01-31 2:29:00 0 [Note] InnoDB: 10.6.4 started; log sequence number 42281; transaction id 14

2022-01-31 2:29:00 0 [Note] Plugin ‘FEEDBACK’ is disabled.

2022-01-31 2:29:00 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool

2022-01-31 2:29:01 0 [Warning] You need to use --log-bin to make --expire-logs-days or --binlog-expire-logs-seconds work.

2022-01-31 2:29:02 0 [Note] Server socket created on IP: ‘0.0.0.0’.

2022-01-31 2:29:02 0 [Note] Server socket created on IP: ‘::’.

2022-01-31 2:29:04 0 [Note] InnoDB: Buffer pool(s) load completed at 220131 2:29:04

2022-01-31 2:29:04 0 [Warning] ‘proxies_priv’ entry ‘@% root@c94141832cc6’ ignored in --skip-name-resolve mode.

2022-01-31 2:29:22 0 [Note] mysqld: ready for connections.

Version: ‘10.6.4-MariaDB-1:10.6.4+maria~focal’ socket: ‘/run/mysqld/mysqld.sock’ port: 3306 mariadb.org binary distribution

```

[NocoDB]

Anti replied

MariaDB is constantly crashing and restarting

[NocoDB]

o1lab replied

Ahok