# Upgrading to xibo v2 temporarily off-line
**URL:** https://community.xibo.org.uk/t/upgrading-to-xibo-v2-temporarily-off-line/18058
**Category:** Get Help
**Created:** [March 19, 2019, 10:40am UTC](https://community.xibo.org.uk/t/upgrading-to-xibo-v2-temporarily-off-line/18058 "2019-03-19T10:40:14Z")
**Posts on this page:** 12
**Page:** 2
### Author:  [@sgunther](https://community.xibo.org.uk/u/sgunther)
#### Post date: [March 21, 2019, 4:37pm UTC](https://community.xibo.org.uk/t/upgrading-to-xibo-v2-temporarily-off-line/18058/21 "2019-03-21T16:37:47Z")
So i would need to be in the cms-db container to get there?
---
### Author:  [@alex](https://community.xibo.org.uk/u/alex)
#### Post date: [March 21, 2019, 4:49pm UTC](https://community.xibo.org.uk/t/upgrading-to-xibo-v2-temporarily-off-line/18058/22 "2019-03-21T16:49:18Z")
Yes. From there run `mysql -u cms -p cms` to access the database, and then you can run repair commands from there
---
### Author:  [@sgunther](https://community.xibo.org.uk/u/sgunther)
#### Post date: [March 21, 2019, 5:29pm UTC](https://community.xibo.org.uk/t/upgrading-to-xibo-v2-temporarily-off-line/18058/23 "2019-03-21T17:29:16Z")
Thank you so much! There are two missing tables. I tried to autorepair with no luck. The tables are lktagdisplaygroup and upgrade. Can I drop these and then try to recreate them?
---
### Author:  [@sgunther](https://community.xibo.org.uk/u/sgunther)
#### Post date: [March 21, 2019, 6:48pm UTC](https://community.xibo.org.uk/t/upgrading-to-xibo-v2-temporarily-off-line/18058/24 "2019-03-21T18:48:06Z")
Or would i be able to delete the container and have it rebuilt? would it make a new database?
---
### Author:  [@alex](https://community.xibo.org.uk/u/alex)
#### Post date: [March 22, 2019, 8:36am UTC](https://community.xibo.org.uk/t/upgrading-to-xibo-v2-temporarily-off-line/18058/25 "2019-03-22T08:36:10Z")
You can delete the container but it won’t create a new database.
You can definitely drop and recreate the lktagdisplaygroup table based on the schema for the 1.8 version you are upgrading from.
>
Upgrade table I think you can just drop and it will be recreated if needed.
Make sure you have a good backup before you drop any tables.
---
### Author:  [@sgunther](https://community.xibo.org.uk/u/sgunther)
#### Post date: [March 22, 2019, 2:17pm UTC](https://community.xibo.org.uk/t/upgrading-to-xibo-v2-temporarily-off-line/18058/26 "2019-03-22T14:17:51Z")
I no longer get the missing table errors when upgrading. Now iI have an error saying Column already exists: 1060 duplicate column name ‘tagId’ which was similar to the previous error about isDisplayNotification. Is there a way to merge them? or can i just find the duplicate and remove it?
---
### Author:  [@alex](https://community.xibo.org.uk/u/alex)
#### Post date: [March 22, 2019, 2:46pm UTC](https://community.xibo.org.uk/t/upgrading-to-xibo-v2-temporarily-off-line/18058/27 "2019-03-22T14:46:49Z")
What version are you upgrading from? You said 1.8 but not specifically which version.
It’s trying to add a column `tagId` but its already there in 1.8.12, so I suspect you may be trying to upgrade from something earlier?
---
### Author:  [@sgunther](https://community.xibo.org.uk/u/sgunther)
#### Post date: [March 22, 2019, 3:32pm UTC](https://community.xibo.org.uk/t/upgrading-to-xibo-v2-temporarily-off-line/18058/28 "2019-03-22T15:32:55Z")
I had 1.8.12 on it, but when restored it i went back to 1.8.0.
---
### Author:  [@alex](https://community.xibo.org.uk/u/alex)
#### Post date: [March 22, 2019, 3:46pm UTC](https://community.xibo.org.uk/t/upgrading-to-xibo-v2-temporarily-off-line/18058/29 "2019-03-22T15:46:01Z")
I’m afraid I don’t know then. The structure for 1.8.10 is the same so it shouldn’t be trying to run that.
Your logs earlier showed it was trying to run upgrade step 134 which is for 1.8.3 so I think you may be mistaken about the versions you have there, or the database has underlying issues.
You could restore back, export your layouts and then do a fresh 2.0.0 install and import your layouts in to it so you get back to a known good state.
---
### Author:  [@sgunther](https://community.xibo.org.uk/u/sgunther)
#### Post date: [March 22, 2019, 6:37pm UTC](https://community.xibo.org.uk/t/upgrading-to-xibo-v2-temporarily-off-line/18058/30 "2019-03-22T18:37:06Z")
Would i need to re add all the content library? Or if i just add the layouts would it know to save that info?
---
### Author:  [@alex](https://community.xibo.org.uk/u/alex)
#### Post date: [March 25, 2019, 8:10am UTC](https://community.xibo.org.uk/t/upgrading-to-xibo-v2-temporarily-off-line/18058/31 "2019-03-25T08:10:22Z")
If you export the layouts it will bring any media used in those layouts with the export.
It won’t bring displays or scheduling, groups etc.
---
### Author:  [@system](https://community.xibo.org.uk/u/system)
#### Post date: [March 4, 2020, 5:13pm UTC](https://community.xibo.org.uk/t/upgrading-to-xibo-v2-temporarily-off-line/18058/32 "2020-03-04T17:13:26Z")
[Previous page](https://community.xibo.org.uk/t/upgrading-to-xibo-v2-temporarily-off-line/18058.md?page=1)