TP7 to TP9 MySQL conversion error : part 1

[wingfield]

hello,

in trying to convert a working v7 MySQL db to v9, I get the following errors.  any thoughts on this would be appreciated.

Opening database for conversion.
Identifying database...
Database server type is MySQL.
Mappings: {u'TEXT': u'longtext', u'COUNTER': u'int(11) not null primary key auto_increment', u'FLAG': u'bit', u'INT64': u'bigint(20)', u'DATE': u'varchar(32)', u'ID': u'int(11)', u'INT32': u'int(11)', u'INT16': u'smallint(5)', u'BIN64': u'tinyblob', u'BLOB': u'longblob', u'WCHAR': u'varchar'}
Removing pre-v7 cruft.
Exec (nocheck): drop table [ActiveUsers]
Exec (nocheck): drop table [CurrentUsers]

   [MySQL][ODBC 5.3(a) Driver][mysqld-5.6.24-log]Unknown table 'thumbs.currentusers'
<1051•42S02>
   [MySQL][ODBC 5.3(a) Driver][mysqld-5.6.24-log]Unknown table 'thumbs.currentusers'
Exec (nocheck): drop table [Logins]

   [MySQL][ODBC 5.3(a) Driver][mysqld-5.6.24-log]Unknown table 'thumbs.logins'
<1051•42S02>
   [MySQL][ODBC 5.3(a) Driver][mysqld-5.6.24-log]Unknown table 'thumbs.logins'
Exec (nocheck): drop table [DoesPathHaveThumbs]

   [MySQL][ODBC 5.3(a) Driver][mysqld-5.6.24-log]Unknown table 'thumbs.doespathhavethumbs'
<1051•42S02>
   [MySQL][ODBC 5.3(a) Driver][mysqld-5.6.24-log]Unknown table 'thumbs.doespathhavethumbs'
Exec (nocheck): drop table [GalleryThumbStart]

   [MySQL][ODBC 5.3(a) Driver][mysqld-5.6.24-log]Unknown table 'thumbs.gallerythumbstart'
<1051•42S02>
   [MySQL][ODBC 5.3(a) Driver][mysqld-5.6.24-log]Unknown table 'thumbs.gallerythumbstart'
Exec (nocheck): drop table [GetThumbnail]

   [MySQL][ODBC 5.3(a) Driver][mysqld-5.6.24-log]Unknown table 'thumbs.getthumbnail'
<1051•42S02>
   [MySQL][ODBC 5.3(a) Driver][mysqld-5.6.24-log]Unknown table 'thumbs.getthumbnail'
Exec (nocheck): drop table [KeywordByFile]

   [MySQL][ODBC 5.3(a) Driver][mysqld-5.6.24-log]Unknown table 'thumbs.keywordbyfile'
<1051•42S02>
   [MySQL][ODBC 5.3(a) Driver][mysqld-5.6.24-log]Unknown table 'thumbs.keywordbyfile'
Exec (nocheck): drop table [KeywordGroupCount]

   [MySQL][ODBC 5.3(a) Driver][mysqld-5.6.24-log]Unknown table 'thumbs.keywordgroupcount'
<1051•42S02>
   [MySQL][ODBC 5.3(a) Driver][mysqld-5.6.24-log]Unknown table 'thumbs.keywordgroupcount'
Exec (nocheck): drop table [ThumbnailGallery]

   [MySQL][ODBC 5.3(a) Driver][mysqld-5.6.24-log]Unknown table 'thumbs.thumbnailgallery'
<1051•42S02>
   [MySQL][ODBC 5.3(a) Driver][mysqld-5.6.24-log]Unknown table 'thumbs.thumbnailgallery'
Exec (nocheck): drop table [ThumbnailPath]

   [MySQL][ODBC 5.3(a) Driver][mysqld-5.6.24-log]Unknown table 'thumbs.thumbnailpath'
<1051•42S02>
   [MySQL][ODBC 5.3(a) Driver][mysqld-5.6.24-log]Unknown table 'thumbs.thumbnailpath'
Exec (nocheck): drop table [ThumbnailUDF]

   [MySQL][ODBC 5.3(a) Driver][mysqld-5.6.24-log]Unknown table 'thumbs.thumbnailudf'
<1051•42S02>
   [MySQL][ODBC 5.3(a) Driver][mysqld-5.6.24-log]Unknown table 'thumbs.thumbnailudf'
Exec (nocheck): drop table [UpdatePathNames]

   [MySQL][ODBC 5.3(a) Driver][mysqld-5.6.24-log]Unknown table 'thumbs.updatepathnames'
<1051•42S02>
   [MySQL][ODBC 5.3(a) Driver][mysqld-5.6.24-log]Unknown table 'thumbs.updatepathnames'
Creating new tables.
Exec (nocheck):

    create table [ThumbsPlusDatabase] (
        [attribute] varchar(50) not null primary key,
        [value]     varchar(255) not null
    )



   [MySQL][ODBC 5.3(a) Driver][mysqld-5.6.24-log]Table 'thumbsplusdatabase' already exists
<1050•42S01>
   [MySQL][ODBC 5.3(a) Driver][mysqld-5.6.24-log]Table 'thumbsplusdatabase' already exists
Exec (nocheck):

    create table [FoundLists] (
        [idList"     int(11) not null primary key,
        [ListName]   varchar(255) not null,
        [TableName]  varchar(255) not null,
        [SQLText]    longtext
    )

   [MySQL][ODBC 5.3(a) Driver][mysqld-5.6.24-log]Table 'foundlists' already exists
<1050•42S01>
   [MySQL][ODBC 5.3(a) Driver][mysqld-5.6.24-log]Table 'foundlists' already exists
Exec (nocheck): alter table [FoundLists] add constraint [U_FoundListName] unique ([ListName])

   [MySQL][ODBC 5.3(a) Driver][mysqld-5.6.24-log]Duplicate key name 'U_FoundListName'
<1061•HY000>
   [MySQL][ODBC 5.3(a) Driver][mysqld-5.6.24-log]Duplicate key name 'U_FoundListName'
Exec (nocheck):

    create table [FoundThumbs] (
        [idList]     int(11) not null,
        [idThumb]    int(11) not null,
        [flags]      int(11) not null
    )

[Pete Wieland]

The TP7 to TP9 client server conversion wasn't working 2 years ago, and as far as I can tell from the release notes, has never been fixed.

As far as I know this is because the MySQL keyword of TYPE has been changed in later versions to ENGINE when specifying the database engine as InnoDB. This is why the MySQL creation script for TP7 no longer works without editing (see pinned post at top of forum topic list).

It might be possible to export your TP7 database, then import it into a new, empty TP9 database, but I am not at my main machine at the moment and don't have MySQL installed so I can't test it.

[Daan van Rooijen]

(note from Daan: Part two of Wingfield's opening post had ended up as a separate post in the Announcements section, so I'll copy the contents below and remove them from there)


below is the remainder of the error message.


[MySQL][ODBC 5.3(a) Driver][mysqld-5.6.24-log]Table 'foundthumbs' already exists
<1050•42S01>
[MySQL][ODBC 5.3(a) Driver][mysqld-5.6.24-log]Table 'foundthumbs' already exists
Exec (nocheck): alter table [FoundThumbs] add constraint [PK_FoundThumbs] primary key ([idList], [idThumb])

[MySQL][ODBC 5.3(a) Driver][mysqld-5.6.24-log]Multiple primary key defined
<1068•HY000>
[MySQL][ODBC 5.3(a) Driver][mysqld-5.6.24-log]Multiple primary key defined
Setting database attributes.
setting attribute 'thumbnail_width' = '100'.

[MySQL][ODBC 5.3(a) Driver][mysqld-5.6.24-log]Duplicate entry 'thumbnail_width' for key 'PRIMARY'
<1062•23000>
[MySQL][ODBC 5.3(a) Driver][mysqld-5.6.24-log]Duplicate entry 'thumbnail_width' for key 'PRIMARY'
Upgrade failed at: 'select * from [DatabaseInfo]'.

Conversion failed!