| Author |
 Topic  |
|
|
Mickey28
Starting Member
3 Posts |
 Posted - 07 May 2011 : 11:45:23
|
Hi,
as I still have the problem and got no answer in the Information thread I raise it as a bug.
I have a 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?
Thanks a lot for your help.
regards
Michael |
|
|
techdls
Starting Member
27 Posts |
Posted - 07 May 2011 : 14:40:38
|
I'm having the same problem, and have a thread a couple posts down, I tried:
`Premiered` varchar(250) DEFAULT NULL,
`Movie3D` bit(1) DEFAULT NULL,
`CharacterInfo` varchar(250) DEFAULT NULL,
`SerieStatus` varchar(250) DEFAULT NULL,
`Original` bit(1) 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,
`ActorRole` varchar(250) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8";
and it does import the movies but everywhere there is a space it replaces it with this character: "Â"
if you put the new fields into the create table if not exist it doesn't import.
I don't think I changed anything in the config.inc file that would cause this problem, try it yourself and see if you have the same results. |
 |
|
|
Mickey28
Starting Member
3 Posts |
Posted - 07 May 2011 : 20:41:05
|
Hi,
thanks a lot for your help.
I changed the script and run it and the data was inserted in the table. So it really seems that the problem is with the wrong table attributes in import.php.
I have also a problem with all öäüÄÖÜ , as soon there is one in the name the name is truncated at the first appereance of that char. e.g. "Zwölf Männer für ein Jahr" is imported as "Zw". I have no problems with spaces.
Not useable!
I don't understand why the developer is not helping us, it is definitly a bug and it would be much easier for him to solve the problem than for us.
So I still have no working solution for seeing my Movies on my intranet.
P.S. have you played around with the symbol set of the database?
regards
Michael |
Edited by - Mickey28 on 07 May 2011 20:42:44 |
|
|
|
techdls
Starting Member
27 Posts |
Posted - 10 May 2011 : 15:45:46
|
| You can try to take out the offending characters in the restricted characters and put them into the accepted characters list in config.inc but I'm not sure, I would love this bug to be fixed though, thank you! |
|
|
| |
Topic |
|
|
|
Onex, no movies visible