16
ThumbsPlus v7-v9 Questions / TP7 to TP9 MySQL conversion error : part 1
« on: 2015-04-15 22:08:01 »
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
)
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
)