Just for some background, I've been using SQLYog for a few weeks to successfully import from local to remote, with very few issues showing up. I already have a job created from previous version of SQLYog. The job is designed to dump & recreate the SQL tables, and import all rows.
This morning, I installed Beta 9 to fix an issue that I was having with version 5.15 (the issue that occurs where you open an existing job file, and no tables are selected). In Beta 9, I open the existing job, all tables are selected appropriately. I ensured all tables are set to MyISAM, and proceed with the import procedure. I then encounter these errors:
QUOTE
Job started at Fri Jul 21 09:44:06 2006
DBMS Information: MICROSOFT SQL SERVER
Importing table schema: product_upc... Successful...
Importing table schema: product_line... Successful...
Importing table schema: person... Successful...
Importing table schema: product...
ERROR: 1064, You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Unlocked, `LockStatus` int(10) NULL DEFAULT 0, `Description` varchar(50) NULL ' at line 1
Table:tblProduct
Sql:CREATE TABLE `soundch_repo`.`product`( `ProductID` int(10) UNSIGNED NOT NULL , `ProductType` varchar(50) NULL , `ProductName` varchar(255) NULL , `Company` varchar(50) NULL , `StockID` varchar(50) NULL , `LookupAs` varchar(255) NULL , `Status` varchar(50) NULL DEFAULT Unlocked, `LockStatus` int(10) NULL DEFAULT 0, `Description` varchar(50) NULL , `Note` varchar(255) NULL , `Price` decimal(19,4) NULL DEFAULT 0, `Frequent` smallint(5) UNSIGNED NOT NULL DEFAULT 1, `Inactive` smallint(5) UNSIGNED NOT NULL DEFAULT 0, `Deleted` smallint(5) NOT NULL DEFAULT 0, `QtyOnHand` int(10) NULL DEFAULT 0, `MinOrder` int(10) NULL DEFAULT 1, `LotSize` int(10) NULL DEFAULT 1, `AcctPartID` varchar(50) NULL , `PopupNote` varchar(255) NULL , `Genre` varchar(50) NULL , `SubGenre` varchar(50) NULL , `Format` varchar(50) NULL , `LineID` varchar(100) NULL , `SubLineID` varchar(100) NULL , `ProductImage` varchar(255) NULL , `SongSample` varchar(255) NULL , `ProductCategory` int(10) NULL , `Terms` varchar(50) NULL , `ReleaseDate` timestamp(23) NULL , `TermDate` timestamp(23) NULL , `SellOffDate` timestamp(23) NULL , `CustProductCode` varchar(50) NULL , `ConvertedID` varchar(50) NULL , `ConvertedTable` varchar(50) NULL , `CreateDate` timestamp(23) NULL DEFAULT getdate(), `CreateUser` varchar(50) NULL , `UpdateDate` timestamp(23) NULL DEFAULT getdate(), `UpdateUser` varchar(50) NULL , `SendToWeb` int(10) NULL DEFAULT -1, `iTemporary` int(10) NULL DEFAULT 0, `NotForSellOnWeb` int(10) NULL DEFAULT 0, `Artwork` varchar(50) NULL , PRIMARY KEY ( `ProductID` ) , UNIQUE KEY `aaaaatblProduct2_PK` (`ProductID` ASC ),KEY `AcctPartID` (`AcctPartID` ASC ),KEY `Deleted` (`Deleted` ASC ),KEY `Format` (`Format` ASC ),KEY `Genre` (`Genre` ASC ),KEY `Inactive` (`Inactive` ASC ),KEY `IX_tblProduct_iTemporary` (`iTemporary` ASC ),KEY `IX_tblProduct_NotForSellOnWeb` (`NotForSellOnWeb` ASC ),KEY `IX_tblProduct_SendToWeb` (`SendToWeb` ASC ),KEY `LineID` (`LineID` ASC ),KEY `LookupAs` (`LookupAs` ASC ),KEY `ProductName` (`ProductName` ASC ),KEY `ProductType` (`ProductType` ASC ),KEY `ReleaseDate` (`ReleaseDate` ASC ),KEY `SellOffDate` (`SellOffDate` ASC ),KEY `Status` (`Status` ASC ),KEY `TermDate` (`TermDate` ASC ) )Engine=MyISAM
Check C:\Program Files\SQLyog Enterprise\sja_initial_import.log for complete error details.
Importing table schema: product_license...
ERROR: 1064, You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'getdate(), `StartDate` timestamp(23) NULL , `EndDate` timestamp(23) NULL , `Se' at line 1
Table:tblProductLicense
Sql:CREATE TABLE `soundch_repo`.`product_license`( `ProductLicenseID` int(10) UNSIGNED NOT NULL , `ProductSongID` int(10) UNSIGNED NULL , `Region` varchar(255) NULL , `LicenseType` varchar(10) NULL , `PersonID` int(10) NULL , `InCareOfID` int(10) UNSIGNED NULL , `Accept` smallint(5) NULL DEFAULT -1, `Rate` decimal(19,4) NULL , `Multiplier` int(10) NULL DEFAULT 1, `AdminFee` decimal(19,4) NULL DEFAULT 0, `Advance` decimal(19,4) NULL , `AdvanceQty` float UNSIGNED NULL , `Terms` varchar(50) NULL , `CreateDate` timestamp(23) NULL DEFAULT getdate(), `StartDate` timestamp(23) NULL , `EndDate` timestamp(23) NULL , `SellOffDate` timestamp(23) NULL , `Status` varchar(50) NULL DEFAULT Pending, `LicenseNum` varchar(50) NULL , `PercentOwned` float NULL , `OriginalAdvance` decimal(19,4) NULL , `ExecuteDate` timestamp(23) NULL , `ExecuteBy` varchar(50) NULL , `ChangeUser` varchar(50) NULL , `ChangeDate` timestamp(23) NULL , PRIMARY KEY ( `ProductLicenseID` ) , UNIQUE KEY `PK_tblProductLicenseRestore$` (`ProductLicenseID` ASC ) )Engine=MyISAM
Check C:\Program Files\SQLyog Enterprise\sja_initial_import.log for complete error details.
Importing table schema: product_link... Successful...
Importing table schema: product_song... Successful...
Importing table schema: song...
ERROR: 1064, You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Unlocked, `LockStatus` int(10) UNSIGNED NULL DEFAULT 0, `Description` varchar(' at line 1
Table:tblSong
Sql:CREATE TABLE `soundch_repo`.`song`( `SongID` int(10) UNSIGNED NOT NULL , `SCSongNum` varchar(50) NULL , `SongName` varchar(80) NULL , `LookupAs` varchar(255) NULL , `CatalogName` varchar(255) NULL , `ID4D` int(10) UNSIGNED NULL , `Artist` varchar(80) NULL , `ArtistCatalog` varchar(255) NULL , `Writer` varchar(255) NULL , `Publisher` varchar(255) NULL , `Status` varchar(50) NULL DEFAULT Unlocked, `LockStatus` int(10) UNSIGNED NULL DEFAULT 0, `Description` varchar(50) NULL , `Note` varchar(255) NULL , `Price` decimal(19,4) NULL DEFAULT 0, `Frequent` smallint(5) NOT NULL DEFAULT -1, `Inactive` smallint(5) NOT NULL DEFAULT 0, `Deleted` smallint(5) UNSIGNED NOT NULL DEFAULT 0, `PopupNote` varchar(255) NULL , `Genre` varchar(50) NULL , `SubGenre` varchar(50) NULL , `Format` varchar(50) NULL , `ReleaseDate` timestamp(23) NULL , `TermDate` timestamp(23) NULL , `SellOffDate` timestamp(23) NULL , `ConvertedID` varchar(50) NULL , `ConvertedTable` varchar(50) NULL , `CreateDate` timestamp(23) NULL DEFAULT getdate(), `CreateUser` varchar(50) NULL , `UpdateDate` timestamp(23) NULL DEFAULT getdate(), `UpdateUser` varchar(50) NULL , `LibrarySongID` int(10) NULL , `ParentalAdvisory` int(10) NULL DEFAULT 0, `RestrictedOnInternet` int(10) NULL DEFAULT 0, `SongSample` varchar(50) NULL , `SendToWeb` int(10) NULL DEFAULT -1, `YearReleased` int(10) NULL , `MovieShowTitle` varchar(50) NULL , `Category` varchar(50) NULL , `NoCatalog` int(10) NULL , `A_Mix_On_Server` bit(1) NULL , `B_Mix_On_Server` bit(1) NULL , `C_Mix_On_Server` bit(1) NULL , `D_Mix_On_Server` bit(1) NULL , `Stereo_Mix_Ringtone_On_Server` bit(1) NULL , `Music_Mix_Ringtone_On_Server` bit(1) NULL , `BackgroundVocal` varchar(1) NULL , `KeyChanges` varchar(80) NULL , `MasterNum` int(10) NULL , `StereoVolume` int(10) NULL , `Tempo` int(10) NULL , `SongTime` varchar(20) NULL , `Date_Mixed` varchar(20) NULL , `SongKey` varchar(3) NULL , `PickDate` timestamp(23) NULL , `CDGCustomAvailable` varchar(50) NULL , PRIMARY KEY ( `SongID` ) , UNIQUE KEY `PK_tblSong` (`SongID` ASC ),KEY `IX_tblSong_Artist` (`Artist` ASC ),KEY `IX_tblSong_Deleted` (`Deleted` ASC ),KEY `IX_tblSong_Format` (`Format` ASC ),KEY `IX_tblSong_Genre` (`Genre` ASC ),KEY `IX_tblSong_ID4D` (`ID4D` ASC ),KEY `IX_tblSong_Inactive` (`Inactive` ASC ),KEY `IX_tblSong_LibrarySongID` (`LibrarySongID` ASC ),KEY `IX_tblSong_LookupAs` (`LookupAs` ASC ),KEY `IX_tblSong_MovieShowTitle` (`MovieShowTitle` ASC ),KEY `IX_tblSong_ParentalAdvisory` (`ParentalAdvisory` ASC ),KEY `IX_tblSong_RestrictedOnInternet` (`RestrictedOnInternet` ASC ),KEY `IX_tblSong_SCSongNum` (`SCSongNum` ASC ),KEY `IX_tblSong_SendToWeb` (`SendToWeb` ASC ),KEY `IX_tblSong_SongName` (`SongName` ASC ),KEY `IX_tblSong_Status` (`Status` ASC ) )Engine=MyISAM
Check C:\Program Files\SQLyog Enterprise\sja_initial_import.log for complete error details.
Importing table schema: song_engineering... Successful...
Importing table schema: song_relationship...
ERROR: 1064, You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Pending, `PubSongNum` varchar(50) NULL , PRIMARY KEY ( `SongRelationshipID` ) ,' at line 1
Table:tblSongRelationship
Sql:CREATE TABLE `soundch_repo`.`song_relationship`( `SongRelationshipID` int(10) UNSIGNED NOT NULL , `SongID` int(10) UNSIGNED NOT NULL , `PersonID` int(10) UNSIGNED NOT NULL , `DisplayName` varchar(255) NULL , `RelationshipType` varchar(50) NULL , `PercentOwned` float UNSIGNED NULL , `Limits` varchar(255) NULL , `Status` varchar(50) NULL DEFAULT Pending, `PubSongNum` varchar(50) NULL , PRIMARY KEY ( `SongRelationshipID` ) , UNIQUE KEY `PK_tblProductRelationship` (`SongRelationshipID` ASC ),KEY `IX_tblSongRelationship_DisplayName` (`DisplayName` ASC ),KEY `IX_tblSongRelationship_PersonID` (`PersonID` ASC ),KEY `IX_tblSongRelationship_RelationshipType` (`RelationshipType` ASC ),KEY `IX_tblSongRelationship_SongID` (`SongID` ASC ),KEY `Status` (`Status` ASC ) )Engine=MyISAM
Check C:\Program Files\SQLyog Enterprise\sja_initial_import.log for complete error details.
Importing table data: product_upc...
DBMS Information: MICROSOFT SQL SERVER
Importing table schema: product_upc... Successful...
Importing table schema: product_line... Successful...
Importing table schema: person... Successful...
Importing table schema: product...
ERROR: 1064, You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Unlocked, `LockStatus` int(10) NULL DEFAULT 0, `Description` varchar(50) NULL ' at line 1
Table:tblProduct
Sql:CREATE TABLE `soundch_repo`.`product`( `ProductID` int(10) UNSIGNED NOT NULL , `ProductType` varchar(50) NULL , `ProductName` varchar(255) NULL , `Company` varchar(50) NULL , `StockID` varchar(50) NULL , `LookupAs` varchar(255) NULL , `Status` varchar(50) NULL DEFAULT Unlocked, `LockStatus` int(10) NULL DEFAULT 0, `Description` varchar(50) NULL , `Note` varchar(255) NULL , `Price` decimal(19,4) NULL DEFAULT 0, `Frequent` smallint(5) UNSIGNED NOT NULL DEFAULT 1, `Inactive` smallint(5) UNSIGNED NOT NULL DEFAULT 0, `Deleted` smallint(5) NOT NULL DEFAULT 0, `QtyOnHand` int(10) NULL DEFAULT 0, `MinOrder` int(10) NULL DEFAULT 1, `LotSize` int(10) NULL DEFAULT 1, `AcctPartID` varchar(50) NULL , `PopupNote` varchar(255) NULL , `Genre` varchar(50) NULL , `SubGenre` varchar(50) NULL , `Format` varchar(50) NULL , `LineID` varchar(100) NULL , `SubLineID` varchar(100) NULL , `ProductImage` varchar(255) NULL , `SongSample` varchar(255) NULL , `ProductCategory` int(10) NULL , `Terms` varchar(50) NULL , `ReleaseDate` timestamp(23) NULL , `TermDate` timestamp(23) NULL , `SellOffDate` timestamp(23) NULL , `CustProductCode` varchar(50) NULL , `ConvertedID` varchar(50) NULL , `ConvertedTable` varchar(50) NULL , `CreateDate` timestamp(23) NULL DEFAULT getdate(), `CreateUser` varchar(50) NULL , `UpdateDate` timestamp(23) NULL DEFAULT getdate(), `UpdateUser` varchar(50) NULL , `SendToWeb` int(10) NULL DEFAULT -1, `iTemporary` int(10) NULL DEFAULT 0, `NotForSellOnWeb` int(10) NULL DEFAULT 0, `Artwork` varchar(50) NULL , PRIMARY KEY ( `ProductID` ) , UNIQUE KEY `aaaaatblProduct2_PK` (`ProductID` ASC ),KEY `AcctPartID` (`AcctPartID` ASC ),KEY `Deleted` (`Deleted` ASC ),KEY `Format` (`Format` ASC ),KEY `Genre` (`Genre` ASC ),KEY `Inactive` (`Inactive` ASC ),KEY `IX_tblProduct_iTemporary` (`iTemporary` ASC ),KEY `IX_tblProduct_NotForSellOnWeb` (`NotForSellOnWeb` ASC ),KEY `IX_tblProduct_SendToWeb` (`SendToWeb` ASC ),KEY `LineID` (`LineID` ASC ),KEY `LookupAs` (`LookupAs` ASC ),KEY `ProductName` (`ProductName` ASC ),KEY `ProductType` (`ProductType` ASC ),KEY `ReleaseDate` (`ReleaseDate` ASC ),KEY `SellOffDate` (`SellOffDate` ASC ),KEY `Status` (`Status` ASC ),KEY `TermDate` (`TermDate` ASC ) )Engine=MyISAM
Check C:\Program Files\SQLyog Enterprise\sja_initial_import.log for complete error details.
Importing table schema: product_license...
ERROR: 1064, You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'getdate(), `StartDate` timestamp(23) NULL , `EndDate` timestamp(23) NULL , `Se' at line 1
Table:tblProductLicense
Sql:CREATE TABLE `soundch_repo`.`product_license`( `ProductLicenseID` int(10) UNSIGNED NOT NULL , `ProductSongID` int(10) UNSIGNED NULL , `Region` varchar(255) NULL , `LicenseType` varchar(10) NULL , `PersonID` int(10) NULL , `InCareOfID` int(10) UNSIGNED NULL , `Accept` smallint(5) NULL DEFAULT -1, `Rate` decimal(19,4) NULL , `Multiplier` int(10) NULL DEFAULT 1, `AdminFee` decimal(19,4) NULL DEFAULT 0, `Advance` decimal(19,4) NULL , `AdvanceQty` float UNSIGNED NULL , `Terms` varchar(50) NULL , `CreateDate` timestamp(23) NULL DEFAULT getdate(), `StartDate` timestamp(23) NULL , `EndDate` timestamp(23) NULL , `SellOffDate` timestamp(23) NULL , `Status` varchar(50) NULL DEFAULT Pending, `LicenseNum` varchar(50) NULL , `PercentOwned` float NULL , `OriginalAdvance` decimal(19,4) NULL , `ExecuteDate` timestamp(23) NULL , `ExecuteBy` varchar(50) NULL , `ChangeUser` varchar(50) NULL , `ChangeDate` timestamp(23) NULL , PRIMARY KEY ( `ProductLicenseID` ) , UNIQUE KEY `PK_tblProductLicenseRestore$` (`ProductLicenseID` ASC ) )Engine=MyISAM
Check C:\Program Files\SQLyog Enterprise\sja_initial_import.log for complete error details.
Importing table schema: product_link... Successful...
Importing table schema: product_song... Successful...
Importing table schema: song...
ERROR: 1064, You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Unlocked, `LockStatus` int(10) UNSIGNED NULL DEFAULT 0, `Description` varchar(' at line 1
Table:tblSong
Sql:CREATE TABLE `soundch_repo`.`song`( `SongID` int(10) UNSIGNED NOT NULL , `SCSongNum` varchar(50) NULL , `SongName` varchar(80) NULL , `LookupAs` varchar(255) NULL , `CatalogName` varchar(255) NULL , `ID4D` int(10) UNSIGNED NULL , `Artist` varchar(80) NULL , `ArtistCatalog` varchar(255) NULL , `Writer` varchar(255) NULL , `Publisher` varchar(255) NULL , `Status` varchar(50) NULL DEFAULT Unlocked, `LockStatus` int(10) UNSIGNED NULL DEFAULT 0, `Description` varchar(50) NULL , `Note` varchar(255) NULL , `Price` decimal(19,4) NULL DEFAULT 0, `Frequent` smallint(5) NOT NULL DEFAULT -1, `Inactive` smallint(5) NOT NULL DEFAULT 0, `Deleted` smallint(5) UNSIGNED NOT NULL DEFAULT 0, `PopupNote` varchar(255) NULL , `Genre` varchar(50) NULL , `SubGenre` varchar(50) NULL , `Format` varchar(50) NULL , `ReleaseDate` timestamp(23) NULL , `TermDate` timestamp(23) NULL , `SellOffDate` timestamp(23) NULL , `ConvertedID` varchar(50) NULL , `ConvertedTable` varchar(50) NULL , `CreateDate` timestamp(23) NULL DEFAULT getdate(), `CreateUser` varchar(50) NULL , `UpdateDate` timestamp(23) NULL DEFAULT getdate(), `UpdateUser` varchar(50) NULL , `LibrarySongID` int(10) NULL , `ParentalAdvisory` int(10) NULL DEFAULT 0, `RestrictedOnInternet` int(10) NULL DEFAULT 0, `SongSample` varchar(50) NULL , `SendToWeb` int(10) NULL DEFAULT -1, `YearReleased` int(10) NULL , `MovieShowTitle` varchar(50) NULL , `Category` varchar(50) NULL , `NoCatalog` int(10) NULL , `A_Mix_On_Server` bit(1) NULL , `B_Mix_On_Server` bit(1) NULL , `C_Mix_On_Server` bit(1) NULL , `D_Mix_On_Server` bit(1) NULL , `Stereo_Mix_Ringtone_On_Server` bit(1) NULL , `Music_Mix_Ringtone_On_Server` bit(1) NULL , `BackgroundVocal` varchar(1) NULL , `KeyChanges` varchar(80) NULL , `MasterNum` int(10) NULL , `StereoVolume` int(10) NULL , `Tempo` int(10) NULL , `SongTime` varchar(20) NULL , `Date_Mixed` varchar(20) NULL , `SongKey` varchar(3) NULL , `PickDate` timestamp(23) NULL , `CDGCustomAvailable` varchar(50) NULL , PRIMARY KEY ( `SongID` ) , UNIQUE KEY `PK_tblSong` (`SongID` ASC ),KEY `IX_tblSong_Artist` (`Artist` ASC ),KEY `IX_tblSong_Deleted` (`Deleted` ASC ),KEY `IX_tblSong_Format` (`Format` ASC ),KEY `IX_tblSong_Genre` (`Genre` ASC ),KEY `IX_tblSong_ID4D` (`ID4D` ASC ),KEY `IX_tblSong_Inactive` (`Inactive` ASC ),KEY `IX_tblSong_LibrarySongID` (`LibrarySongID` ASC ),KEY `IX_tblSong_LookupAs` (`LookupAs` ASC ),KEY `IX_tblSong_MovieShowTitle` (`MovieShowTitle` ASC ),KEY `IX_tblSong_ParentalAdvisory` (`ParentalAdvisory` ASC ),KEY `IX_tblSong_RestrictedOnInternet` (`RestrictedOnInternet` ASC ),KEY `IX_tblSong_SCSongNum` (`SCSongNum` ASC ),KEY `IX_tblSong_SendToWeb` (`SendToWeb` ASC ),KEY `IX_tblSong_SongName` (`SongName` ASC ),KEY `IX_tblSong_Status` (`Status` ASC ) )Engine=MyISAM
Check C:\Program Files\SQLyog Enterprise\sja_initial_import.log for complete error details.
Importing table schema: song_engineering... Successful...
Importing table schema: song_relationship...
ERROR: 1064, You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Pending, `PubSongNum` varchar(50) NULL , PRIMARY KEY ( `SongRelationshipID` ) ,' at line 1
Table:tblSongRelationship
Sql:CREATE TABLE `soundch_repo`.`song_relationship`( `SongRelationshipID` int(10) UNSIGNED NOT NULL , `SongID` int(10) UNSIGNED NOT NULL , `PersonID` int(10) UNSIGNED NOT NULL , `DisplayName` varchar(255) NULL , `RelationshipType` varchar(50) NULL , `PercentOwned` float UNSIGNED NULL , `Limits` varchar(255) NULL , `Status` varchar(50) NULL DEFAULT Pending, `PubSongNum` varchar(50) NULL , PRIMARY KEY ( `SongRelationshipID` ) , UNIQUE KEY `PK_tblProductRelationship` (`SongRelationshipID` ASC ),KEY `IX_tblSongRelationship_DisplayName` (`DisplayName` ASC ),KEY `IX_tblSongRelationship_PersonID` (`PersonID` ASC ),KEY `IX_tblSongRelationship_RelationshipType` (`RelationshipType` ASC ),KEY `IX_tblSongRelationship_SongID` (`SongID` ASC ),KEY `Status` (`Status` ASC ) )Engine=MyISAM
Check C:\Program Files\SQLyog Enterprise\sja_initial_import.log for complete error details.
Importing table data: product_upc...
At this point, I Terminate the process, since the errors should not be there. I close the wizard, Open the wizard, create a brand new job file, performing the same tasks. I don't change any settings per-table other than specifying MyISAM.
I begin the import process, and again encounter errors:
QUOTE
SQLyog Job Agent Version 5.16
Copyright © Webyog Softworks Pvt. Ltd.. All Rights Reserved.
Job started at Fri Jul 21 09:51:24 2006
DBMS Information: MICROSOFT SQL SERVER
Importing table schema: product_upc... Successful...
Importing table schema: product_line... Successful...
Importing table schema: person... Successful...
Importing table schema: product...
ERROR: 1064, You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'getdate(), `CreateUser` varchar(50) NULL , `UpdateDate` timestamp(23) NULL DEF' at line 1
Table:tblProduct
Sql:CREATE TABLE `soundch_repo`.`product`( `ProductID` int(10) UNSIGNED NOT NULL , `ProductType` varchar(50) NULL , `ProductName` varchar(255) NULL , `Company` varchar(50) NULL , `StockID` varchar(50) NULL , `LookupAs` varchar(255) NULL , `Status` varchar(50) NULL DEFAULT 'Unlocked', `LockStatus` int(10) NULL DEFAULT 0, `Description` varchar(50) NULL , `Note` varchar(255) NULL , `Price` decimal(19,4) NULL DEFAULT 0, `Frequent` smallint(5) UNSIGNED NOT NULL DEFAULT 1, `Inactive` smallint(5) UNSIGNED NOT NULL DEFAULT 0, `Deleted` smallint(5) NOT NULL DEFAULT 0, `QtyOnHand` int(10) NULL DEFAULT 0, `MinOrder` int(10) NULL DEFAULT 1, `LotSize` int(10) NULL DEFAULT 1, `AcctPartID` varchar(50) NULL , `PopupNote` varchar(255) NULL , `Genre` varchar(50) NULL , `SubGenre` varchar(50) NULL , `Format` varchar(50) NULL , `LineID` varchar(100) NULL , `SubLineID` varchar(100) NULL , `ProductImage` varchar(255) NULL , `SongSample` varchar(255) NULL , `ProductCategory` int(10) NULL , `Terms` varchar(50) NULL , `ReleaseDate` timestamp(23) NULL , `TermDate` timestamp(23) NULL , `SellOffDate` timestamp(23) NULL , `CustProductCode` varchar(50) NULL , `ConvertedID` varchar(50) NULL , `ConvertedTable` varchar(50) NULL , `CreateDate` timestamp(23) NULL DEFAULT getdate(), `CreateUser` varchar(50) NULL , `UpdateDate` timestamp(23) NULL DEFAULT getdate(), `UpdateUser` varchar(50) NULL , `SendToWeb` int(10) NULL DEFAULT -1, `iTemporary` int(10) NULL DEFAULT 0, `NotForSellOnWeb` int(10) NULL DEFAULT 0, `Artwork` varchar(50) NULL , PRIMARY KEY ( `ProductID` ) , UNIQUE KEY `aaaaatblProduct2_PK` (`ProductID` ASC ),KEY `AcctPartID` (`AcctPartID` ASC ),KEY `Deleted` (`Deleted` ASC ),KEY `Format` (`Format` ASC ),KEY `Genre` (`Genre` ASC ),KEY `Inactive` (`Inactive` ASC ),KEY `IX_tblProduct_iTemporary` (`iTemporary` ASC ),KEY `IX_tblProduct_NotForSellOnWeb` (`NotForSellOnWeb` ASC ),KEY `IX_tblProduct_SendToWeb` (`SendToWeb` ASC ),KEY `LineID` (`LineID` ASC ),KEY `LookupAs` (`LookupAs` ASC ),KEY `ProductName` (`ProductName` ASC ),KEY `ProductType` (`ProductType` ASC ),KEY `ReleaseDate` (`ReleaseDate` ASC ),KEY `SellOffDate` (`SellOffDate` ASC ),KEY `Status` (`Status` ASC ),KEY `TermDate` (`TermDate` ASC ) )Engine=MyISAM
Check C:\Program Files\SQLyog Enterprise\sja_initial_import.log for complete error details.
Importing table schema: product_license...
ERROR: 1064, You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'getdate(), `StartDate` timestamp(23) NULL , `EndDate` timestamp(23) NULL , `Se' at line 1
Table:tblProductLicense
Sql:CREATE TABLE `soundch_repo`.`product_license`( `ProductLicenseID` int(10) UNSIGNED NOT NULL , `ProductSongID` int(10) UNSIGNED NULL , `Region` varchar(255) NULL , `LicenseType` varchar(10) NULL , `PersonID` int(10) NULL , `InCareOfID` int(10) UNSIGNED NULL , `Accept` smallint(5) NULL DEFAULT -1, `Rate` decimal(19,4) NULL , `Multiplier` int(10) NULL DEFAULT 1, `AdminFee` decimal(19,4) NULL DEFAULT 0, `Advance` decimal(19,4) NULL , `AdvanceQty` float UNSIGNED NULL , `Terms` varchar(50) NULL , `CreateDate` timestamp(23) NULL DEFAULT getdate(), `StartDate` timestamp(23) NULL , `EndDate` timestamp(23) NULL , `SellOffDate` timestamp(23) NULL , `Status` varchar(50) NULL DEFAULT 'Pending', `LicenseNum` varchar(50) NULL , `PercentOwned` float NULL , `OriginalAdvance` decimal(19,4) NULL , `ExecuteDate` timestamp(23) NULL , `ExecuteBy` varchar(50) NULL , `ChangeUser` varchar(50) NULL , `ChangeDate` timestamp(23) NULL , PRIMARY KEY ( `ProductLicenseID` ) , UNIQUE KEY `PK_tblProductLicenseRestore$` (`ProductLicenseID` ASC ) )Engine=MyISAM
Check C:\Program Files\SQLyog Enterprise\sja_initial_import.log for complete error details.
Importing table schema: product_link... Successful...
Importing table schema: product_song... Successful...
Importing table schema: song...
ERROR: 1064, You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'getdate(), `CreateUser` varchar(50) NULL , `UpdateDate` timestamp(23) NULL DEF' at line 1
Table:tblSong
Sql:CREATE TABLE `soundch_repo`.`song`( `SongID` int(10) UNSIGNED NOT NULL , `SCSongNum` varchar(50) NULL , `SongName` varchar(80) NULL , `LookupAs` varchar(255) NULL , `CatalogName` varchar(255) NULL , `ID4D` int(10) UNSIGNED NULL , `Artist` varchar(80) NULL , `ArtistCatalog` varchar(255) NULL , `Writer` varchar(255) NULL , `Publisher` varchar(255) NULL , `Status` varchar(50) NULL DEFAULT 'Unlocked', `LockStatus` int(10) UNSIGNED NULL DEFAULT 0, `Description` varchar(50) NULL , `Note` varchar(255) NULL , `Price` decimal(19,4) NULL DEFAULT 0, `Frequent` smallint(5) NOT NULL DEFAULT -1, `Inactive` smallint(5) NOT NULL DEFAULT 0, `Deleted` smallint(5) UNSIGNED NOT NULL DEFAULT 0, `PopupNote` varchar(255) NULL , `Genre` varchar(50) NULL , `SubGenre` varchar(50) NULL , `Format` varchar(50) NULL , `ReleaseDate` timestamp(23) NULL , `TermDate` timestamp(23) NULL , `SellOffDate` timestamp(23) NULL , `ConvertedID` varchar(50) NULL , `ConvertedTable` varchar(50) NULL , `CreateDate` timestamp(23) NULL DEFAULT getdate(), `CreateUser` varchar(50) NULL , `UpdateDate` timestamp(23) NULL DEFAULT getdate(), `UpdateUser` varchar(50) NULL , `LibrarySongID` int(10) NULL , `ParentalAdvisory` int(10) NULL DEFAULT 0, `RestrictedOnInternet` int(10) NULL DEFAULT 0, `SongSample` varchar(50) NULL , `SendToWeb` int(10) NULL DEFAULT -1, `YearReleased` int(10) NULL , `MovieShowTitle` varchar(50) NULL , `Category` varchar(50) NULL , `NoCatalog` int(10) NULL , `A_Mix_On_Server` bit(1) NULL , `B_Mix_On_Server` bit(1) NULL , `C_Mix_On_Server` bit(1) NULL , `D_Mix_On_Server` bit(1) NULL , `Stereo_Mix_Ringtone_On_Server` bit(1) NULL , `Music_Mix_Ringtone_On_Server` bit(1) NULL , `BackgroundVocal` varchar(1) NULL , `KeyChanges` varchar(80) NULL , `MasterNum` int(10) NULL , `StereoVolume` int(10) NULL , `Tempo` int(10) NULL , `SongTime` varchar(20) NULL , `Date_Mixed` varchar(20) NULL , `SongKey` varchar(3) NULL , `PickDate` timestamp(23) NULL , `CDGCustomAvailable` varchar(50) NULL , PRIMARY KEY ( `SongID` ) , UNIQUE KEY `PK_tblSong` (`SongID` ASC ),KEY `IX_tblSong_Artist` (`Artist` ASC ),KEY `IX_tblSong_Deleted` (`Deleted` ASC ),KEY `IX_tblSong_Format` (`Format` ASC ),KEY `IX_tblSong_Genre` (`Genre` ASC ),KEY `IX_tblSong_ID4D` (`ID4D` ASC ),KEY `IX_tblSong_Inactive` (`Inactive` ASC ),KEY `IX_tblSong_LibrarySongID` (`LibrarySongID` ASC ),KEY `IX_tblSong_LookupAs` (`LookupAs` ASC ),KEY `IX_tblSong_MovieShowTitle` (`MovieShowTitle` ASC ),KEY `IX_tblSong_ParentalAdvisory` (`ParentalAdvisory` ASC ),KEY `IX_tblSong_RestrictedOnInternet` (`RestrictedOnInternet` ASC ),KEY `IX_tblSong_SCSongNum` (`SCSongNum` ASC ),KEY `IX_tblSong_SendToWeb` (`SendToWeb` ASC ),KEY `IX_tblSong_SongName` (`SongName` ASC ),KEY `IX_tblSong_Status` (`Status` ASC ) )Engine=MyISAM
Check C:\Program Files\SQLyog Enterprise\sja_initial_import.log for complete error details.
Importing table schema: song_engineering... Successful...
Importing table schema: song_relationship... Successful...
Importing table foreign keys: product_line... Successful...
Importing table data: product_upc...
Copyright © Webyog Softworks Pvt. Ltd.. All Rights Reserved.
Job started at Fri Jul 21 09:51:24 2006
DBMS Information: MICROSOFT SQL SERVER
Importing table schema: product_upc... Successful...
Importing table schema: product_line... Successful...
Importing table schema: person... Successful...
Importing table schema: product...
ERROR: 1064, You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'getdate(), `CreateUser` varchar(50) NULL , `UpdateDate` timestamp(23) NULL DEF' at line 1
Table:tblProduct
Sql:CREATE TABLE `soundch_repo`.`product`( `ProductID` int(10) UNSIGNED NOT NULL , `ProductType` varchar(50) NULL , `ProductName` varchar(255) NULL , `Company` varchar(50) NULL , `StockID` varchar(50) NULL , `LookupAs` varchar(255) NULL , `Status` varchar(50) NULL DEFAULT 'Unlocked', `LockStatus` int(10) NULL DEFAULT 0, `Description` varchar(50) NULL , `Note` varchar(255) NULL , `Price` decimal(19,4) NULL DEFAULT 0, `Frequent` smallint(5) UNSIGNED NOT NULL DEFAULT 1, `Inactive` smallint(5) UNSIGNED NOT NULL DEFAULT 0, `Deleted` smallint(5) NOT NULL DEFAULT 0, `QtyOnHand` int(10) NULL DEFAULT 0, `MinOrder` int(10) NULL DEFAULT 1, `LotSize` int(10) NULL DEFAULT 1, `AcctPartID` varchar(50) NULL , `PopupNote` varchar(255) NULL , `Genre` varchar(50) NULL , `SubGenre` varchar(50) NULL , `Format` varchar(50) NULL , `LineID` varchar(100) NULL , `SubLineID` varchar(100) NULL , `ProductImage` varchar(255) NULL , `SongSample` varchar(255) NULL , `ProductCategory` int(10) NULL , `Terms` varchar(50) NULL , `ReleaseDate` timestamp(23) NULL , `TermDate` timestamp(23) NULL , `SellOffDate` timestamp(23) NULL , `CustProductCode` varchar(50) NULL , `ConvertedID` varchar(50) NULL , `ConvertedTable` varchar(50) NULL , `CreateDate` timestamp(23) NULL DEFAULT getdate(), `CreateUser` varchar(50) NULL , `UpdateDate` timestamp(23) NULL DEFAULT getdate(), `UpdateUser` varchar(50) NULL , `SendToWeb` int(10) NULL DEFAULT -1, `iTemporary` int(10) NULL DEFAULT 0, `NotForSellOnWeb` int(10) NULL DEFAULT 0, `Artwork` varchar(50) NULL , PRIMARY KEY ( `ProductID` ) , UNIQUE KEY `aaaaatblProduct2_PK` (`ProductID` ASC ),KEY `AcctPartID` (`AcctPartID` ASC ),KEY `Deleted` (`Deleted` ASC ),KEY `Format` (`Format` ASC ),KEY `Genre` (`Genre` ASC ),KEY `Inactive` (`Inactive` ASC ),KEY `IX_tblProduct_iTemporary` (`iTemporary` ASC ),KEY `IX_tblProduct_NotForSellOnWeb` (`NotForSellOnWeb` ASC ),KEY `IX_tblProduct_SendToWeb` (`SendToWeb` ASC ),KEY `LineID` (`LineID` ASC ),KEY `LookupAs` (`LookupAs` ASC ),KEY `ProductName` (`ProductName` ASC ),KEY `ProductType` (`ProductType` ASC ),KEY `ReleaseDate` (`ReleaseDate` ASC ),KEY `SellOffDate` (`SellOffDate` ASC ),KEY `Status` (`Status` ASC ),KEY `TermDate` (`TermDate` ASC ) )Engine=MyISAM
Check C:\Program Files\SQLyog Enterprise\sja_initial_import.log for complete error details.
Importing table schema: product_license...
ERROR: 1064, You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'getdate(), `StartDate` timestamp(23) NULL , `EndDate` timestamp(23) NULL , `Se' at line 1
Table:tblProductLicense
Sql:CREATE TABLE `soundch_repo`.`product_license`( `ProductLicenseID` int(10) UNSIGNED NOT NULL , `ProductSongID` int(10) UNSIGNED NULL , `Region` varchar(255) NULL , `LicenseType` varchar(10) NULL , `PersonID` int(10) NULL , `InCareOfID` int(10) UNSIGNED NULL , `Accept` smallint(5) NULL DEFAULT -1, `Rate` decimal(19,4) NULL , `Multiplier` int(10) NULL DEFAULT 1, `AdminFee` decimal(19,4) NULL DEFAULT 0, `Advance` decimal(19,4) NULL , `AdvanceQty` float UNSIGNED NULL , `Terms` varchar(50) NULL , `CreateDate` timestamp(23) NULL DEFAULT getdate(), `StartDate` timestamp(23) NULL , `EndDate` timestamp(23) NULL , `SellOffDate` timestamp(23) NULL , `Status` varchar(50) NULL DEFAULT 'Pending', `LicenseNum` varchar(50) NULL , `PercentOwned` float NULL , `OriginalAdvance` decimal(19,4) NULL , `ExecuteDate` timestamp(23) NULL , `ExecuteBy` varchar(50) NULL , `ChangeUser` varchar(50) NULL , `ChangeDate` timestamp(23) NULL , PRIMARY KEY ( `ProductLicenseID` ) , UNIQUE KEY `PK_tblProductLicenseRestore$` (`ProductLicenseID` ASC ) )Engine=MyISAM
Check C:\Program Files\SQLyog Enterprise\sja_initial_import.log for complete error details.
Importing table schema: product_link... Successful...
Importing table schema: product_song... Successful...
Importing table schema: song...
ERROR: 1064, You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'getdate(), `CreateUser` varchar(50) NULL , `UpdateDate` timestamp(23) NULL DEF' at line 1
Table:tblSong
Sql:CREATE TABLE `soundch_repo`.`song`( `SongID` int(10) UNSIGNED NOT NULL , `SCSongNum` varchar(50) NULL , `SongName` varchar(80) NULL , `LookupAs` varchar(255) NULL , `CatalogName` varchar(255) NULL , `ID4D` int(10) UNSIGNED NULL , `Artist` varchar(80) NULL , `ArtistCatalog` varchar(255) NULL , `Writer` varchar(255) NULL , `Publisher` varchar(255) NULL , `Status` varchar(50) NULL DEFAULT 'Unlocked', `LockStatus` int(10) UNSIGNED NULL DEFAULT 0, `Description` varchar(50) NULL , `Note` varchar(255) NULL , `Price` decimal(19,4) NULL DEFAULT 0, `Frequent` smallint(5) NOT NULL DEFAULT -1, `Inactive` smallint(5) NOT NULL DEFAULT 0, `Deleted` smallint(5) UNSIGNED NOT NULL DEFAULT 0, `PopupNote` varchar(255) NULL , `Genre` varchar(50) NULL , `SubGenre` varchar(50) NULL , `Format` varchar(50) NULL , `ReleaseDate` timestamp(23) NULL , `TermDate` timestamp(23) NULL , `SellOffDate` timestamp(23) NULL , `ConvertedID` varchar(50) NULL , `ConvertedTable` varchar(50) NULL , `CreateDate` timestamp(23) NULL DEFAULT getdate(), `CreateUser` varchar(50) NULL , `UpdateDate` timestamp(23) NULL DEFAULT getdate(), `UpdateUser` varchar(50) NULL , `LibrarySongID` int(10) NULL , `ParentalAdvisory` int(10) NULL DEFAULT 0, `RestrictedOnInternet` int(10) NULL DEFAULT 0, `SongSample` varchar(50) NULL , `SendToWeb` int(10) NULL DEFAULT -1, `YearReleased` int(10) NULL , `MovieShowTitle` varchar(50) NULL , `Category` varchar(50) NULL , `NoCatalog` int(10) NULL , `A_Mix_On_Server` bit(1) NULL , `B_Mix_On_Server` bit(1) NULL , `C_Mix_On_Server` bit(1) NULL , `D_Mix_On_Server` bit(1) NULL , `Stereo_Mix_Ringtone_On_Server` bit(1) NULL , `Music_Mix_Ringtone_On_Server` bit(1) NULL , `BackgroundVocal` varchar(1) NULL , `KeyChanges` varchar(80) NULL , `MasterNum` int(10) NULL , `StereoVolume` int(10) NULL , `Tempo` int(10) NULL , `SongTime` varchar(20) NULL , `Date_Mixed` varchar(20) NULL , `SongKey` varchar(3) NULL , `PickDate` timestamp(23) NULL , `CDGCustomAvailable` varchar(50) NULL , PRIMARY KEY ( `SongID` ) , UNIQUE KEY `PK_tblSong` (`SongID` ASC ),KEY `IX_tblSong_Artist` (`Artist` ASC ),KEY `IX_tblSong_Deleted` (`Deleted` ASC ),KEY `IX_tblSong_Format` (`Format` ASC ),KEY `IX_tblSong_Genre` (`Genre` ASC ),KEY `IX_tblSong_ID4D` (`ID4D` ASC ),KEY `IX_tblSong_Inactive` (`Inactive` ASC ),KEY `IX_tblSong_LibrarySongID` (`LibrarySongID` ASC ),KEY `IX_tblSong_LookupAs` (`LookupAs` ASC ),KEY `IX_tblSong_MovieShowTitle` (`MovieShowTitle` ASC ),KEY `IX_tblSong_ParentalAdvisory` (`ParentalAdvisory` ASC ),KEY `IX_tblSong_RestrictedOnInternet` (`RestrictedOnInternet` ASC ),KEY `IX_tblSong_SCSongNum` (`SCSongNum` ASC ),KEY `IX_tblSong_SendToWeb` (`SendToWeb` ASC ),KEY `IX_tblSong_SongName` (`SongName` ASC ),KEY `IX_tblSong_Status` (`Status` ASC ) )Engine=MyISAM
Check C:\Program Files\SQLyog Enterprise\sja_initial_import.log for complete error details.
Importing table schema: song_engineering... Successful...
Importing table schema: song_relationship... Successful...
Importing table foreign keys: product_line... Successful...
Importing table data: product_upc...
I terminate again, and created this thread...
Any help would be great. Thanks