BinaryWorks.it Official Forum
BinaryWorks.it Official Forum
Home | Profile | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
 All Forums
 eXtreme Movie Manager (Rel. 7), No More Updates
 Information
 MySQL Import doesn't work (Bug found ?)
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

martinweil
Starting Member

16 Posts

Posted - 11 Mar 2011 :  15:30:48  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
Hi,

I tried to export my DB to Onex & XML. After I uploaded all the files to my ftp account I opened "www.domain.tld/import.php", set the marker for "XML-Export.xml", typed in the password (same as in the config.inc) and pressed "Start".

Unfortunately the Import won't "start". When I open the "www.domain.tld/index.php" it shows the correct page but has no data in it. Also, in PhpMyAdmin my DB is emtpy.

I doublechecked my DB name ("xmm"), my user ("xmm_user") and my password. I tried both the real IP adress from the server and also "localhost".

Any ideas why this is not working or what I did wrong?

Thanks

Edited by - martinweil on 12 Mar 2011 23:43:34

martinweil
Starting Member

16 Posts

Posted - 11 Mar 2011 :  17:24:51  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
I solved the problem with this post:

http://www.binaryworks.it/forum/topic.asp?TOPIC_ID=5734

The key was to set the "HDD = 1" entry to "HDD = 0". Explained in the post... hope this helps someone else, too :-)
Go to Top of Page

martinweil
Starting Member

16 Posts

Posted - 11 Mar 2011 :  18:01:46  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Unfortunately, that did not solve my problem entirely, just a little bit:

Now, the import script seems to be stuck in a loop without writing anything in my DB. In Firefox I get displayed a black box with a rotating sign and the page seems to reload 2-3 times per second.
In Internet Explorer nearly the same. At the beginning you can read "Bereite XML Datei vor" and thats it.

The adress is http://www.domain.tld/import.php?visual=&task=4&counter=0&incremental=off

My config.inc is as follows:


<?php
# -------------------------------------------------------------------------
# Database connection
# -------------------------------------------------------------------------
#
# $host: 					name of your mysql server
# $user: 					your username for the mysql server
# $pass: 					your password for the mysql server
# $database: 				the name of the database
# -------------------------------------------------------------------------
#
$host = "localhost"; #I also tried the IP Adress of my server
$user = "xmm_user";
$pass = "XXXXXX";    #my password in plaintext
$database = "xmm";


# -------------------------------------------------------------------------
# General settings
# -------------------------------------------------------------------------
# Language:			Language in the GUI (see directory "lang/" for choices)
#
# InputDateFormat:	Format for dates in the source XML file of XMM
# OutputDateFormat:	Format of date you want to have displayed in the interface
#
# AllowedCharacters:Allowed characters in cleaned picture filenames
# AdminPassword:	Password needed for the xml import
#
# ReplaceCharacters:Define pairs of strings (string to replace¦new string)
#					seperated with "|"
# -------------------------------------------------------------------------
#
$setting["Language"] = "german";

$setting["InputDateFormat"] = "%d.%m.%Y";
$setting["OutputDateFormat"] = "%d.%m.%Y";

$setting["AllowedCharacters"] = "¦0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz-";
$setting["AdminPassword"] = "password";

$setting["ReplaceCharacters"] = "%C2%A0¦|#160;¦|¦|ä¦ä|ö¦ö|ü¦ü|ĦÄ|ܦÜ|ߦß";

# -------------------------------------------------------------------------
# Startup
# -------------------------------------------------------------------------
#
# pagetitle:		The title of your page
# theme:			the name of the theme you want to use
# template:			HTML template for the main layout
# hdd:				Show only movies on hdd (1) or all movies (0)
# limit:			Movies per page
# criteria:			Default filter criteria
#					Available values are all column names
# mode:				Default mode for filtering
#					Available values:
#					begins, contains, containsnot, equal, smaller, bigger
# value:			Default filter value (like "A", or "lastest" for DateInsert
# -------------------------------------------------------------------------
#
$setting["pagetitle"] = "My Movies";
$setting["theme"] = "carbon";
$setting["template"] = "body_2";
$setting["hdd"] = 0;
$setting["limit"] = 100;
$setting["criteria"] = "title";
$setting["mode"] = "begins";
$setting["value"] = "A";

# -------------------------------------------------------------------------
# Paths
# -------------------------------------------------------------------------
#
# The are currently three movie locations maintained
# The PC PATHs are the paths of the movie files while you imported the
# files into the eXtreme Movie Manager database. Please use double
# backslashs ("\\") instead of single backslashs. PC PATHs have to end
# with "\\".
#
# NMT PATHs are the internal paths of your Networked Multimedia
# player and have to end with "/"
# -------------------------------------------------------------------------
#
$setting["PCPath1"] = "P:\\Video\\";
$setting["NMTPath1"] = "file:///opt/sybhttpd/localhost.drives/HARD_DISK/Video/";

$setting["PCPath2"] = "Q:\\Filme\\";
$setting["NMTPath2"] = "file:///opt/sybhttpd/localhost.drives/NETWORK_SHARE/qnap/Filme/";

$setting["PCPath3"] = "N:\\Video\\";
$setting["NMTPath3"] = "file:///opt/sybhttpd/localhost.drives/HARD_DISK/Video/";
?>
Go to Top of Page

martinweil
Starting Member

16 Posts

Posted - 12 Mar 2011 :  23:12:14  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Some Problems solved - Now NEW Problems :-)


First, I switched to a free provider for my PHP / DB-Hosting and now the Import is working ! (so far so good)

But, the table "movies" is completely empty (all the fields are correctly entered by the script but no movie is listed). The tables "genre" and "roles" are completely fine and they seem to have everything in it.

When I open the "index.php" it shows 0/0 movies.

What did I do wrong this time ?

Edited by - martinweil on 12 Mar 2011 23:13:18
Go to Top of Page

martinweil
Starting Member

16 Posts

Posted - 12 Mar 2011 :  23:40:32  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
*** UPDATE ***

I may have discovered a bug in the XML / OnEx export process:

I checked every field in the DB table "movies" according to the XML file and I found one discrepancy:

In the XML File the last <> on every <Movie> entry is <Movie3D>. But in my "movie" table it says DBId.

When I change it manually to "Movie3D" and do an incremental Import I can see the movies.

I still don't know why there are only a few movies imported and the "index.php" won't show any description or covers... but maybe I can figure it out before anyone here will reply to my post :-(

Edited by - martinweil on 12 Mar 2011 23:43:02
Go to Top of Page

ternot
Junior Member

126 Posts

Posted - 14 Mar 2011 :  19:58:08  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi Martin,

thank you very much for your patience :-)

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,


Best regards
ternot
Go to Top of Page

martinweil
Starting Member

16 Posts

Posted - 14 Mar 2011 :  21:42:16  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Thank you for your support. If I hadn't been so lazy (and know so little about PHP) maybe I would have found that myself ;-)

Now I have another problem:

It seems that only those movies are listed that don't have covers. I am not so sure about that now, but I will look into that with more detail on tuesday afternoon and then post the results here.
Go to Top of Page

martinweil
Starting Member

16 Posts

Posted - 14 Mar 2011 :  21:55:11  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
I have to correct the above post:

ONLY those movies with NO "data import" (via XMM-Script, for example IMDB or some other service) are listed in the DB. Or in other words: only fresh entered movies :-(

Every other movie is not listed and not included in the DB.

I justed checked the XML file (all the movies are correctly in that file). If you like I will provide you with some sample data for analyzing ... :-)
Go to Top of Page

ternot
Junior Member

126 Posts

Posted - 15 Mar 2011 :  08:20:18  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
I think a mandatory information is missing... Can you send me a mail with a link, where I can download your xml file as zip?

Best regards
ternot
Go to Top of Page

martinweil
Starting Member

16 Posts

Posted - 17 Mar 2011 :  23:21:01  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Did you receive my XML file?
Go to Top of Page

ternot
Junior Member

126 Posts

Posted - 21 Mar 2011 :  07:50:17  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi Martin,

no, I didn't get anything...
Go to Top of Page

mouh_stach007
Starting Member

13 Posts

Posted - 21 Mar 2011 :  12:04:46  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi I'm joining this thread after the help of ternot who directed me to this subject about movie3D fix (sorry I didn't correctly found your posts with the recent post search of the forum).

After this correction the script accepted to create movie table with film but some of them was missing. I have investigated in both movie table and xmm to find what films have been skipped, and found that the ones with a filled price value wasn't working properly : the 0,0000 which is apparently automatically added by XMM for some of my films cause problem : indeed when you see that the price row wait a numerical value I think It doesn't work with 0,0000, but I will with 0.000. I'm a newbie and have no knowing about solving it...I have tried with google to find another type of value and change it in import.php by the character type (250) but it doesn't work either (I've compleatly erased database to let import.php create a new one)...
The solution I've found is actually to filter result with price = 0,0000, then use simultaneous multiple edit > replace string in a filed and replace 0,0000 by nothing
Since then all my movies are imported correctly and displayed properly ;)

Thanks a lot for ternot for this excellent script that makes me happier than ever with xmm and open new possibilities ;)
Go to Top of Page

martinweil
Starting Member

16 Posts

Posted - 21 Mar 2011 :  18:28:11  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Darn it...

I clicked on "Email Poster" and sent you the link to the XML File...

Anyway, here it is:
http://rapidshare.com/files/452624633/XML-Export.zip

Also, I can't seem to find the message I send you (or any email message I sent via Forum... strange; or maybe I'm just too stupid ;-)
Go to Top of Page

JDommi
Administrator

Germany
4686 Posts

Posted - 21 Mar 2011 :  18:33:55  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
@martinweil
I think messages containing links will not be sent...
I just have sent you 2 mails by the forum to check it.

In order to achieve what is possible, you have to try the impossible over and over again.
Hermann Hesse
Go to Top of Page

martinweil
Starting Member

16 Posts

Posted - 21 Mar 2011 :  18:35:11  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
@mouh_stach007:

I'm not sure I can confirm that for my problem. I checked the XML File and there isn't even a value included for "<price>".

My Database contains a "0" (zero) for every movie that was imported with the script.

@ ternot:

Would you like a DB dump?
Go to Top of Page

martinweil
Starting Member

16 Posts

Posted - 21 Mar 2011 :  18:35:45  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
@JDommi:

Thx, I will remind that for future messages :-)

And I just got both mails, one with the link. So I guess it is working after all...

I was just wondering why there is no icon or a popup when you login on the forum...

Edited by - martinweil on 21 Mar 2011 18:38:14
Go to Top of Page

martinweil
Starting Member

16 Posts

Posted - 25 Mar 2011 :  08:24:49  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Any News on our problems yet?
Go to Top of Page

Mickey28
Starting Member

3 Posts

Posted - 25 Apr 2011 :  23:13:26  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi,

hello to all, I am a new user of XMM and so far I am impressed by the software.

But I have the exact same problem with Onex: I get no movies in my MySQL database. The import.php runs through, it says done, but no movies in movies table. There is data in table genres and roles.

Maybe the problem ist similar, the fields of xml and import.php don't fit, my last lines of the movie in the XML-Export.xml are:

<BackCover />
<FanArt />
<Premiered />
<Movie3D>False</Movie3D>
<CharacterInfo />
<SerieStatus />
<Original>True</Original>
</Movie>

and the table definition:
`BackCover` varchar(250) DEFAULT NULL,
`FanArt` varchar(250) DEFAULT NULL,
`Premiered` varchar(250) DEFAULT NULL,
`DBId` int(11) DEFAULT NULL,
PRIMARY KEY (`MovieID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8";

$roletablesql = "
CREATE TABLE IF NOT EXISTS `roles` (
`MovieID` int(11) NOT NULL,
`ActorID` varchar(10) NOT NULL,
`ActorName` varchar(250) NOT NULL,
`Movie3D` bit(1) DEFAULT NULL,
`ActorRole` varchar(250) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8";

Can this be the problem?
Another thing I don't understand: why is Movie3D added to the role table, in my opinion this should be a movie attribut?

Thanks a lot for your help?
regards

Michael
Go to Top of Page
  Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
BinaryWorks.it Official Forum © Binaryworks.it Go To Top Of Page
Generated in 0.16 sec. Powered By: Snitz Forums 2000 Version 3.4.07