Devart Forums

I am trying to create an archive table in MariaDB using dbForge and I'm getting the following error when I save the table.

Unexpected Symbol 'NONE'

dbForge automatically changes the following line from:

PRIMARY KEY (ArchiveSupplierID)

PRIMARY KEY USING NONE (ArchiveSupplierID)

Below is my table definition
Also, the 'ARCHIVE' engine doesn't appear in the engine list by default, but I have created the table through entity framework and it has set the engine type to 'ARCHIVE'

Thanks.

Could you please provide us the version of MariaDB and the link to the MariaDB documentation where the syntax "PRIMARY KEY USING NONE" described?

Hello,

Mariadb version: 5.5.5-10.1.11-MariaDB

I do not know of any documentation which mentions 'PRIMARY KEY USING NONE', I DbForge adds that in by itself when I save the the table.

Steps to reproduce:

1. Create a table,
2. Run ALTER TABLE supplier2 ENGINE=ARCHIVE
3. Reopen the table in DbForge
4. Add a primary key,
5. Save by pressing ctrl+s
6. The 'Primary key using none' is automatically added.

I have attached a gif to show the process.



Let me know if you need any other information.]

Thanks.

Thank you for clarifying this. We will fix this issue in the next product build and will notify you once it's available for downloading.

We would like to let you know that we have released dbForge Studio for MySQL, v7.2.50 where the issue you reported is fixed https://www.devart.com/dbforge/mysql/st ... nload.html

Thank you for your help in improving dbForge Studio for MySQL.