MovieLib - Your movie database on web
Hello

I did a fresh install of the plugin and your script. Now i'm not able to sync. I always get the mysql error ERROR: MySQL - Incorrect integer value: '' for column 'hide' at row 1

The insert statement from the log shows INSERT INTO `movies` (`id`,`title`,`plot`,`rating`,`year`,`trailer`,`runtime`,`genre`,`director`,`originaltitle`,`country`,`cast`,`sets`,`v_codec`,`v_aspect`,`v_width`,`v_height`,`v_duration`,`a_codec`,`a_chan`,`play_count`,`last_played`,`date_added`,`hide`) VALUES ("134","Der Frühstücksclub","Fünf Schüler müssen wegen verschiedener Delikte am Wochenende nachsitzen. Keiner weiß vom anderen was er verbrochen hat, sie haben nichts gemeinsam und treffen das erste Mal zusammen: John, der Rebell (Judd Nelson); Claire, die Schöne (Molly Ringwald); Andy, der Athlet (Emilio Estevez); Allison, die Ausgeflippte (Ally Sheedy) und der Streber Brian (Anthony Michael Hall). Doch aus gegenseitiger Ablehnung wächst eine ungeahnte Gemeinschaft, die sie gegen alle Regeln verstoßen lässt. Es wird ein Tag, den sie nie vergessen werden...","8.3","1985","","97","Comedy / Drama","John Hughes","The Breakfast Club","United States of America","Judd Nelson / Molly Ringwald / Emilio Estevez / Anthony Michael Hall / Paul Gleason / Ally Sheedy","","h264","1.84615004063","1920","1040","97","dca","2","0","","2011-05-28 18:00:22","")

The field hide is void in your insert statement. I assume i need to be filled.

I redefined the field hide to a varchar(1) and null and the sync is now working. Please can you check why i get this error?

I addition i found the error ERROR: XFILE::CFile:Big Grinelete - Error deleting file C:/Program Files (x86)/XBMC13/portable_data/userdata/addon_data/script.movielib/temp_f after every query.

Found another error ERROR: MySQL - Data too long for column 'cast' at row 1

Any hints?
Reply
 
Thread Rating:
  • 8 Vote(s) - 4.63 Average


Messages In This Thread
RE: MovieLib - Your movie database on web - by _Andy_ - 2014-05-03, 23:13
Last Post - by Jeffreywat - 2017-09-03, 14:02


Logout Mark Read Team Forum Stats Members Help
MovieLib - Your movie database on web4.638