DB Schema opened

[FriedCircuits]

IMPORTANT

Read and tick the following checkbox after you have created the issue or place an x inside the brackets ;)

• [x ] I have read the CONTRIBUTING.md and followed the provided tips

Explain the Problem

What problem did you encounter?
I am trying to migrate the tables for the News app using OwnBackup. I see in the structure.xml in my existing backup that the field opened is of type integer but in my new install that field is of type Boolean in a backup. I checked the database. xml and it seems to always have been of type Boolean so doesn't make sense.

I am unable to restore those types to the new database.

Note old DB is postgres converted from MySQL, new DB is MySQL installed with NextCloud snap.

https://github.com/nextcloud/news/blob/master/appinfo/database.xml

I just checked the table in the source Postgres table and opened is Boolean, so that is strange that is being exported as integer.

Any ideas?

The reason for migrating the tables is seems importing unread/stared doesn't do anything. So I was thinking it would be more reliable to just migrate the tables.

Steps to Reproduce

Explain what you did to encounter the issue

1. Run backup from one install of NC
2. Copy owncloud backup
3. Restore oc_news_folders

System Information

• News app version: 13.1.6
• Nextcloud version: Docker Image 15.0.8
• Cron type: system
• PHP version: What is included in Docker image
• Database and version: Postgres 10 and Mysql 5.7.26
• Browser and version: Chrome 74
• Distribution and version: Windows 10 Pro

Contents of nextcloud/data/nextcloud.log

No data generated in log when error occured

Contents of Browser Error Console

Read http://ggnome.com/wiki/Using_The_Browser_Error_Console if you are unsure what to put here

Paste output here

[SMillerDev]

If I understand your issue correctly you wonder how booleans became integers? Booleans don't exist in mysql, they're just tinyints

[FriedCircuits]

So maybe it is a bug in ownbackup since it fails to import the news tables. It uses the NC API so the DB engine shouldn't matter.

[stale]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs.