| T O P I C R E V I E W |
| mouh_stach007 |
Posted - 09 Aug 2011 : 19:19:03
Hi I've been using onex to export my XMM database to the onex mysql database in order to create webpages.
Until now (a few month ago) it was working quite properly with the ternot help
quote:
Originally posted by ternot
Hi there,
I know this error ;-)
The solution is described in another thread:
quote:
Currently the script will always hang, if a new field is added to the XMM DB. The DBId is the rest of a test I did with something like a real primary key, but I stopped that test...
Although your code should work, the correct text in line 372 in the import.php script should :-) be
`Movie3D` bit(1) DEFAULT NULL,
Additionally I would recommend to rename the config.inc to config.php and to change the import.php (line 5) and index.php (line 9) to point to this file...
Best regards
ternot
But there is apparently new changes to XMM Database : while importing with import.php it shows errors:
quote:
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,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) VALUES (5073,'(500) jours ensemble','(500) Days of Summer','V_MPEG4/ISO/AVC','Comédie','Drame/ Romance','','','',2009,'','américain','Eng','English','','','','http://www.allocine.fr/film/fichefilm-128377/sites-officiels-fans/','128377','ALLOCINE.FR(mowDED).txt|','http://www.allocine.fr/film/fichefilm_gen_cfilm=128377.html','http://www.allocine.fr/film/fichefilm_gen_cfilm=128377.html|',1,'',96,'','',0,'','','','','','','Marc Webb','','','','','','Tom croit encore en un amour qui transfigure, un amour à la destinée cosmique, un coup de foudre unique. Ce qui n\'\'est pas du tout le cas de Summer. Cela n\'\'empêche pourtant pas Tom de partir à sa conquête, armé de toute sa force et de tout son courage, tel un Don Quichotte des temps modernes. La foudre tombe le premier jour, quand Tom rencontre Summer la nouvelle secrétaire de son patron, une belle jeune fille enjouée. Au 31ème jour, les choses avancent, lentement. Le 32ème jour, Tom est irrémédiablement conquis, pris dans le tourbillon étourdissant d\'\'une vie avec Summer. 185 jours après leur rencontre, la situation est de plus en plus incertaine € mais pas sans espoir. Alors que l\'\'histoire fait des allers-retours au sein de la relation parfois heureuse, mais souvent tumultueuse de Tom et Summer, le récit couvre tout le spectre de la relation amoureuse, du premier coup de coeur aux rendez-vous, du sexe à la séparation, à la récrimination et à la rédemption et décrit toutes les raisons qui nous poussent à nous battre aussi ardemment pour arriver à trouver un sens à l\'\'amour... Et, avec un peu de chance, à en faire une réalité.','','','84-500-Days-of-Summer.jpg','','','','',STR_TO_DATE('30.12.1899', '%d.%m.%Y'),'',0,'',3,0,0,0,0,STR_TO_DATE('30.12.1899', '%d.%m.%Y'),'',0,'',STR_TO_DATE('30.12.1899', '%d.%m.%Y'),STR_TO_DATE('30.12.1899', '%d.%m.%Y'),'Disque Dur Externe Thomas 1.5To','','','',1,0,0,0,0,STR_TO_DATE('31.3.2011', '%d.%m.%Y'),'V_MPEG4/ISO/AVC','1280x534','4 992 Kbps','DTS',0,4477,'48.0 KHz','1 510 Kbps','',6,'','','','','','','','','',0,STR_TO_DATE('5.4.2010', '%d.%m.%Y'),'23.976','3,8','3567 notes','3,3','','http://www.allocine.fr/film/critiquepublic_gen_cfilm=128377.html','http://www.allocine.fr/video/player_gen_cmedia=18913608&cfilm=128377.html','http://www.allocine.fr/film/revuedepresse_gen_cfilm=128377.html','','','128377','','','','','','','','','','',1,'','',0,0,0,'','(500) jours ensemble','4695233660','','','','','','',0,'','','','False','','','False')
Error: Unknown column 'CHARACTERINFO' in 'field list'
It clearly refuses to import movies, while still creating the 3 tables roles, movies, genres in mysql database.
While looking directly to the xml file, I can see 3 new fields that are not in the import.php file : CHARACTERINFO,SERIESTATUS,ORIGINAL
just after MOVIE3D field.
It's clearly here thatr there is a problem, because import.php script doesn't create these new fields in mysql table "movies"
I've tried to add these lines directly in the import.php
quote:
`Movie3D` varchar(250) DEFAULT NULL,
'CharacterInfo' varchar(250) DEFAULT NULL,
'SerieStatus' varchar(250) DEFAULT NULL,
'Original' varchar(250) DEFAULT NULL,
because even if movie3D seems to be a bit (1), the value in xml file is "False"
Therefore I've changed it to varchar to be OK
But the 3 new fields i've added aren't created by import.php
It doesn't create movie table anymore.
I'm not a php master just a newbie trying to change it line by line...
There is apparently problem with the createtables()function, which is probably working recursively, and adding 3 more lines in the table is making all the rest of the process wrong...
Can someone look to this problem?
Maybe Ternot himself can change it, but I think that at this time of year there is lot's of people in vacation...
Thanks a lot ;) |
| 1 L A T E S T R E P L I E S (Newest First) |
| ternot |
Posted - 09 Aug 2011 : 21:41:07
Hi there,
unfortunately I'm not on vacation ;-)
I will have to take a closer look tommorrow, but for now I can see, that there might be a wrong char in your code:
`Movie3D` varchar(250) DEFAULT NULL,
'CharacterInfo' varchar(250) DEFAULT NULL,
'SerieStatus' varchar(250) DEFAULT NULL,
'Original' varchar(250) DEFAULT NULL,
should be
`Movie3D` varchar(250) DEFAULT NULL,
`CharacterInfo` varchar(250) DEFAULT NULL,
`SerieStatus` varchar(250) DEFAULT NULL,
`Original` varchar(250) DEFAULT NULL,
Please note the ` instead of the '
Does this resolve the problem?
Best regards
ternot
|
|
|
