|
frankbool
Starting Member
3 Posts |
 Posted - 29 Jan 2012 : 19:38:22
|
Hey..i have an ugly problem:
I want to Export meine Movie Collection and i want to display it via the PHP File on a webserver. But i got errors:
1) in the import.php some tables are missing:
`Movie3D` bit(1) DEFAULT NULL,
`CharacterInfo` varchar(250) DEFAULT NULL,
`SerieStatus` varchar(250) DEFAULT NULL,
`Original` bit(1) DEFAULT NULL,
2) after i add these a can import ca40 movies.
But got another error:
Error: Column count doesn't match value count at row 1
It seems that some movies have more columns than the Insert command would have:
Select SQL: 140
Error SQL: 144
I think it has to be solves soon..please:
++++
SQL:
INSERT INTO `movies` (`MovieID`, `Title`, `OriginalTitle`, `Media`, `Genre`, `Subgenre`, `Category`, `Edition`, `CatalogNo`, `Year`, `UPC`, `Country`, `OriginalLanguage`, `Language`, `Studio`, `Distributor`, `MPAA`, `URL`, `InternetID`, `ScriptUsed`, `WebLinkScript`, `DirectLinkScript`, `WebImported`, `Region`, `Length`, `VideoDVD`, `AudioDVD`, `MediaYear`, `Position`, `FreeTime`, `Mode`, `Packaging`, `VideoStandard`, `Chapter`, `Director`, `Producer`, `Musician`, `Writer`, `Photographer`, `Comments`, `Plot`, `TagLine`, `Notes`, `Cover`, `Review`, `Location`, `Owner`, `Status`, `DatePurchased`, `AquiredFrom`, `Price`, `Value`, `Rating`, `PersonalRating`, `FilmQuality`, `VideoQuality`, `AudioQuality`, `SeenWhen`, `SeenWhere`, `Loan`, `Loaner`, `DateLoan`, `DateDue`, `MediaLabel`, `Subtitles`, `Awards`, `Actors`, `Features`, `Color`, `DualSide`, `DualLayer`, `Seen`, `Marked`, `Modified`, `Codec`, `Resolution`, `Bitrate`, `AudioCodec`, `DolbyCodec`, `Filesize`, `SampleRate`, `AudioBitRate`, `Ripped`, `Channels`, `MovieFile1`, `MovieFile2`, `MovieFile3`, `MovieFile4`, `MovieFile5`, `MovieFile6`, `TrailerFile1`, `TrailerFile2`, `Player`, `VHSAdv`, `DateInsert`, `FPS`, `Custom1`, `Custom2`, `Custom3`, `Custom4`, `Custom5`, `Custom6`, `Custom7`, `Custom8`, `Custom9`, `Custom10`, `Custom11`, `ChainUsed`, `MovieMD51`, `MovieMD52`, `MovieMD53`, `MovieMD54`, `MovieMD55`, `MovieMD56`, `TrailerMD51`, `TrailerMD52`, `Disks`, `ScreenRatio`, `ScriptFields`, `xHtml`, `Wanted`, `BoxSetID`, `KeyWords`, `MCETitle`, `MovieFileLength1`, `MovieFileLength2`, `MovieFileLength3`, `MovieFileLength4`, `MovieFileLength5`, `MovieFileLength6`, `SimplyEmpty`, `TVShow`, `BackCover`, `FanArt`, `Premiered`, `Movie3D`, `CharacterInfo`, `SerieStatus`, `Original`, `DBId`) Values
Example with this error: eg. Column 124 (MCTitle would be false)
(245, 'Crank 2 - High Voltage (2009)', 'Crank 2 - High Voltage (2009)', '', 'Action', 'Komödie/ Krimi/ Thriller', '', '', '', 2009, '', '', '', '', 'Lionsgate| Lakeshore Entertainment| Radical Media', '20th Century Fox| Lions Gate Films| Lionsgate| Shaw Organisation| Sony Pictures Entertainment| Sony Pictures Releasing| Viva International Pictures| CN Entertainment| CN Entertainment| CatchPlay| Eagle Films| Empire| Hollydan Works| Lionsgate Home En', '', 'http://www.crank2.com/', '1121931', 'IMDB.de(beta).txt|', 'http://www.imdb.de/title/tt1121931', 'http://www.imdb.de/title/tt1121931|', True, '', '96 Min', '', '', 0, '', '', '', '', '', '', 'Mark Neveldine|Brian Taylor', 'Peter Block| Michael Davis| Gary Lucchesi| James McQuaide| Michael Paseornek| Eric Reid| Tom Rosenberg| Skip Williamson| Richard S. Wright', 'Mike Patton', 'Mark Neveldine| Brian Taylor', 'Brandon Trost', '', 'Von wegen tot: Nach seinem Sprung aus einem Hubschrauber landet Profikiller Chev Chelios (Jason Statham) auf dem OP-Tisch chinesischer Mafiosi. Die wollen Chevs Organe, vor allem sein gedoptes Herz. Sie pflanzen ihm statt dessen ein Elektroherz ein. Jetzt hat Chev nur ein Ziel: sein Originalorgan zurückzubekommen. Gar nicht so leicht, denn die neue Pumpe in seiner Brust hat verdammt schrottige Batterien. - Ein Agent unter Dauerstrom: Fortsetzung der total überdrehten Techno-Action.', '', '', '245-Crank-2---High-Voltage-1-.jpg', '', '', '', '', STR_TO_DATE('30.12.1899', '%d.%m.%Y'), '', 0, '', 6,2, 0, 0, 0, 0, STR_TO_DATE('30.12.1899', '%d.%m.%Y'), '', False, '', STR_TO_DATE('30.12.1899', '%d.%m.%Y'), STR_TO_DATE('30.12.1899', '%d.%m.%Y'), '', '', '', '', True, False, False, False, False, '29.1.2012', '', '', '', '', False, 0, '', '', '', 0, 'file:///volume2/MediaN1/Movies/HD/Crank 2 - High Voltage/Crank 2 - High Voltage (2009) (1).m2ts', 'file:///volume2/MediaN1/Movies/HD/Crank 2 - High Voltage/Crank 2 - High Voltage (2009) (2).m2ts', 'file:///volume2/MediaN1/Movies/HD/Crank 2 - High Voltage/Crank 2 - High Voltage (2009) (3).m2ts', '', '', '', '', '', '', False, STR_TO_DATE('29.1.2012', '%d.%m.%Y'), '', '', '', '', '', '', '', '', 'http://www.imdb.de/title/tt1121931', '', '', '', '', '', '', '', '', '', '', '', '', 0, '', '1''1''1''1''1''1''1''1''1''0''0''0''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''0''0''0''0''0''0''0''1''0''0''0''1''1''1''0''1''1''1''1|', 0, False, 0, '', 'Crank 2 - High Voltage (2009) (2009)', '', '', '', '', '', '', '', False, '', '', '', 'False', '', '', 'True')
Any Idea?
if have Version 7.2.1.6 |
Edited by - frankbool on 29 Jan 2012 19:39:07 |
|
Onex import Error - no movies
