12
« on: 2011-05-28 02:27:30 »
Error log from the conversion tool - see post above. I've marked in red where I think at least some of the errors are - seems to trying to drop tables that are views and create tables that haven't been dropped!
Opening database for conversion.
Identifying database...
Database server type is Microsoft SQL Server.
Mappings: {'TEXT': 'ntext', 'COUNTER': 'int identity primary key clustered', 'FLAG': 'bit', 'INT64': 'bigint', 'DATE': 'varchar(32)', 'ID': 'int', 'INT32': 'int', 'INT16': 'smallint', 'BIN64': 'binary(64)', 'BLOB': 'image', 'WCHAR': 'nvarchar'}
Removing pre-v7 cruft.
Exec (nocheck): drop table [ActiveUsers]
Exec (nocheck): drop table [CurrentUsers]
[3701-42S02] [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot drop the table 'CurrentUsers', because it does not exist or you do not have permission
Exec (nocheck): drop table [Logins]
[3701-42S02] [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot drop the table 'Logins', because it does not exist or you do not have permission
Exec (nocheck): drop table [DoesPathHaveThumbs]
[3701-42S02] [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot drop the table 'DoesPathHaveThumbs', because it does not exist or you do not have permission
Exec (nocheck): drop table [GalleryThumbStart]
[3705-42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot use DROP TABLE with 'GalleryThumbStart' because 'GalleryThumbStart' is a view. Use DROP VIEW
Exec (nocheck): drop table [GetThumbnail]
[3701-42S02] [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot drop the table 'GetThumbnail', because it does not exist or you do not have permission
Exec (nocheck): drop table [KeywordByFile]
[3705-42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot use DROP TABLE with 'KeywordByFile' because 'KeywordByFile' is a view. Use DROP VIEW
Exec (nocheck): drop table [KeywordGroupCount]
[3701-42S02] [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot drop the table 'KeywordGroupCount', because it does not exist or you do not have permission
Exec (nocheck): drop table [ThumbnailGallery]
[3705-42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot use DROP TABLE with 'ThumbnailGallery' because 'ThumbnailGallery' is a view. Use DROP VIEW
Exec (nocheck): drop table [ThumbnailPath]
[3705-42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot use DROP TABLE with 'ThumbnailPath' because 'ThumbnailPath' is a view. Use DROP VIEW
Exec (nocheck): drop table [ThumbnailUDF]
[3705-42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot use DROP TABLE with 'ThumbnailUDF' because 'ThumbnailUDF' is a view. Use DROP VIEW
Exec (nocheck): drop table [UpdatePathNames]
[3701-42S02] [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot drop the table 'UpdatePathNames', because it does not exist or you do not have permission
Creating new tables.
Exec (nocheck): create table [ThumbsPlusDatabase] (
[attribute] nvarchar(50) not null primary key,
[value] nvarchar(255) not null
)
[2714-42S01] [Microsoft][ODBC SQL Server Driver][SQL Server]There is already an object named 'ThumbsPlusDatabase' in the database
Exec (nocheck): create table [FoundLists] (
[idList" int not null primary key,
[ListName] nvarchar(255) not null,
[TableName] nvarchar(255) not null,
[SQLText] ntext,
)
[2714-42S01] [Microsoft][ODBC SQL Server Driver][SQL Server]There is already an object named 'FoundLists' in the database
Exec (nocheck): alter table [FoundLists] add constraint [U_FoundListName] unique ([ListName])
[1750-42000] [Microsoft][ODBC SQL Server Driver][SQL Server]There is already an object named 'U_FoundListName' in the database.
[Microsoft][ODBC SQL Server Driver][SQL Server]Could not create constraint. See previous errors
Exec (nocheck): create table [FoundThumbs] (
[idList] int not null,
[idThumb] int not null,
[flags] int not null,
)
[2714-42S01] [Microsoft][ODBC SQL Server Driver][SQL Server]There is already an object named 'FoundThumbs' in the database
Exec (nocheck): alter table [FoundThumbs] add constraint [PK_FoundThumbs] primary key ([idList], idThumb])
[8180-42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Unclosed quotation mark after the character string ')'.
[Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared
Setting database attributes.
setting attribute 'thumbnail_width' = '100'.
[3621-01000] [Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY constraint 'PK__ThumbsPlusDataba__4D94879B'. Cannot insert duplicate key in object 'dbo.ThumbsPlusDatabase'.
[Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated
Upgrade failed at: 'select * from [DatabaseInfo]'.
Conversion failed!