| Author |
 Topic  |
|
|
Relax
Starting Member
Germany
3 Posts |
 Posted - 01 Apr 2011 : 21:13:18
|
Hello all,
your onex tool is very nice and I did install it on my own mini webserver. This is an Qnap NAS TS-459.
With this installation I dont want to play movies via the server. With the XMM I only manage my DVD-Collection and I would be able to publish these collection with friends over the internet.
After the installation I have following problem:
After modifying of the files like ternot wrote befor the export of my XMM movie-database to an XML-file works fine. But when I look at the correspondent Web-Site I see only a few words from the field of the description of my movies. The most of the text is not imported.
If I look at my mysql-database the text of the field "Plot" is also cropped. But every time the text is cropped at the first letter of german umlaut.
So I tried to change the setting of the "ReplaceCharacters". If I do this my movie-description-text shows letters like "รค" or similar letters.
Now I dont know what I can do for changing this and I hope for your help.
Best regards
Klaus
|
 |
|
|
Salomons
Starting Member
4 Posts |
Posted - 02 Apr 2011 : 09:05:07
|
| I had the same problem. Only with Polish characters. Errors "bushes"appear in the list of movies when exported to an XML file. Therefore, prior to export office opened database access. search for all the regional trade and turned more to them universal. For example, "๓"to "o ". Stalked. I think that such a solution is good. Mainly related to changes in the field "plot". Only the names of the actors did not change. The change resulted in the identification of bad photos. I hope that helped. Sorry for my english |
Edited by - Salomons on 02 Apr 2011 09:06:00 |
|
|
|
babutsa
Starting Member
21 Posts |
Posted - 21 Apr 2011 : 18:56:38
|
Hi trenot,
I have exactly same problem with mouh_stach007 and i don't use directories also.
But i dont get what is your solution, what can i do for this problem?
my database is working and import creates directories also.
roles and genres tables is ok but movies table is 0..
when i enter index.php 0/0 movies appear.
by the way which version is your script coming with new XMM? isnt that 0.2d?? |
B@BuTs@ |
|
|
|
yehudili
Starting Member
China
1 Posts |
|
|
klint01
Starting Member
19 Posts |
Posted - 24 May 2012 : 01:47:50
|
Trenot, I am experiencing some identical issues to others I have seen on this board. Essentially, everything is exported correctly and moved to my webserver (hosted), but when I run the import.php the movies are not writing to the database. The genre is populated and so is the roles table but movies is blank. Upon looking at the logfile, I found the following error:
Error: Unknown column 'MOVIE3D' in 'field list'
I have not found an occurrence of MOVIE3D in the import.php script yet, so find this very odd. I am assuming, it is meant to be MOVIEID but looking for some guidance to resolve the issue so the movies import correctly.
Thanks! |
|
|
|
klint01
Starting Member
19 Posts |
Posted - 24 May 2012 : 05:14:25
|
quote:
Originally posted by klint01
Error: Unknown column 'MOVIE3D' in 'field list'
I found the issue. The XML creation includes four additional fields that are not created by the Import.php file while building the tables.
The fields are <Movie3D>, <CharacterInfo>, <SerieStatus>, and <Original>.
I could add the fields to the table, but I am not sure what the expected character value should be for these fields. Any feedback would be great. |
|
|
|
klint01
Starting Member
19 Posts |
Posted - 24 May 2012 : 05:40:49
|
quote:
Originally posted by klint01
quote:
Originally posted by klint01
Error: Unknown column 'MOVIE3D' in 'field list'
I found the issue. The XML creation includes four additional fields that are not created by the Import.php file while building the tables.
The fields are <Movie3D>, <CharacterInfo>, <SerieStatus>, and <Original>.
I could add the fields to the table, but I am not sure what the expected character value should be for these fields. Any feedback would be great.
In looking at the code and the database I was able to uncover three of the four field lengths. The one I could not find was CharacterInfo, so I set it to VARCHAR(250). Now all is good with the world.
Great application, but you may want to look at updating the import.php file. |
|
|
|
klint01
Starting Member
19 Posts |
Posted - 26 May 2012 : 03:00:35
|
| Is there a way to import the XML-Export file into a new XMM database? I tried a couple of the Import XML but they are looking for a specific layout, so it does not work. |
|
|
|
Alessio Viti
Forum Admin
Italy
9171 Posts |
|
|
JDommi
Administrator
Germany
4656 Posts |
Posted - 30 May 2012 : 10:52:01
|
Ale, what about the import from file?
With that function you would be able to import from .nfo as well as from .xml. |
In order to achieve what is possible, you have to try the impossible over and over again.
Hermann Hesse |
|
|
|
Topic |
|
|
XMM Online database: onex
