1

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)

To

PRIMARY KEY USING NONE (ArchiveSupplierID)

Below is my table definition

CREATE TABLE supplierarchives (
    ArchiveSupplierID INT(11) NOT NULL AUTO_INCREMENT,
    PRIMARY KEY USING NONE (ArchiveSupplierID)
)
ENGINE = ARCHIVE
AUTO_INCREMENT = 31888
AVG_ROW_LENGTH = 148
CHARACTER SET utf8
COLLATE utf8_general_ci;

Thanks,

SkelDave
  • 1,176
  • 2
  • 9
  • 23
  • It does not look like the current version of dbForge (v7.2) does it, maybe it was a dbForge bug that was fixed. Still, what exactly is the statement that you run before dbForge converts it into a wrong syntax? What you've quoted as "my table definition" already has 'USING NONE'. – elenst Nov 23 '16 at 00:19

2 Answers2

0

I posted this question on the devart forums and it turns out it is a valid bug.

http://forums.devart.com/viewtopic.php?f=23&t=34602

SkelDave
  • 1,176
  • 2
  • 9
  • 23
0

This problem is fixed in the latest software version. Please upgrade your dbForge Studio for MySQL and get all the bug fixes and enhancements. To download the product, please follow the link https://www.devart.com/dbforge/mysql/studio/download.html

Devart
  • 119,203
  • 23
  • 166
  • 186