1 Topic by JanC (edited by JanC 2022-04-14 18:15:55)

  • JanC
  • New member
  • Offline
  • Registered: 2022-04-11
  • Posts: 8

Topic: Duplicated tables with X suffix

Hi,
I installed a fresh new version of LuxCal 5.2.0M and restored a database which was also created using 5.2.0M

All seems to work but I noticed that all my db tables are duplicated:

SHOW TABLES;

lux_categories
lux_categoriesX
lux_events
lux_eventsX
lux_groups
lux_groupsX
lux_settings
lux_settingsX
lux_styles
lux_stylesX
lux_users
lux_usersX

Any idea what could be the reason for this? It seems the `X` are temporary tables.

When I inspect my original sql backup file, I don't see them. So it looks like they were created after.

Can I delete them?

cheers
Jan

Quote Post 1

  • JanC
  • New member
  • Offline
  • Registered: 2022-04-11
  • Posts: 8

Re: Duplicated tables with X suffix

I believe it was cause by somehow starting the upgrade process on an already upgraded calendar. I drop the temp X tables and all seems to work.

Quote Post 2

  • Roel
  • Roel
  • Administrator
  • Offline
  • Registered: 2018-02-26
  • Posts: 565

Re: Duplicated tables with X suffix

You've done the right thing Jan! The X tables are temporary tables and will normally be dropped at the end of the upgrade process.

Roel

Quote Post 3

  • JanC
  • New member
  • Offline
  • Registered: 2022-04-11
  • Posts: 8

Re: Duplicated tables with X suffix

thanks!

Quote Post 4