[FIXED] Mass CSV SQL error

Coscast · 2011-09-03 16:40:07

Query: UPDATE video SET ext = 'flv', size = , duration = 120.21, thumb = 1, thumbs = 20, server = 0, status = 1 WHERE video_id = 579 LIMIT 1
Error Message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' duration = 120.21, thumb = 1, ' at line 3
Error Number: 1064

Settings:

phpinfo: http://dev.mypornow.com/info.php

http://hot.famehosted.com/D/D0/D02C05AB5F/6/67/6771/c6d6d42f14/6771_04/01/6771_04_120sec_00.flv|Anal Acrobats #03|Hot babes licking and toying their large horny ass holes !|Lesbian,Hardcore,Toys,Cunilingus,Rimming,Straight Porn
http://hot.famehosted.com/D/D0/D02C05AB5F/6/67/6771/c6d6d42f14/6771_03/01/6771_03_120sec_00.flv|Anal Acrobats #03|Very hot horny girls getting hammered in their big assholes!|Threesome,Toys,Blowjob,Blonde,Tattoo/Piercing,Dark Hair
http://hot.famehosted.com/D/D0/D02C05AB5F/6/67/6771/c6d6d42f14/6771_01/01/6771_01_120sec_00.flv|Anal Acrobats #03|Super hot couple of lesbian girls licking their horny asses!|Lesbian,Brunette,Tattoo/Piercing,Bubble Butt,Cunilingus,Rimming

Tested with setting "Copy Videos" this runs through but without any Thumbs, and says "imported 0 Videos".

The normal single upload incl. conversion works without problems. So i exclude server problems, i.e. missing modules.

EDITH SAYS: Hmm, mentioned now that the size field is empty

Last edited by Coscast (2011-09-03 17:08:34)

symtab · 2011-09-03 18:00:18

I tested this on my box and it works, however i discovered a new bug: the duplicate detect function is not accurate, thats why it only added 1 video (all 3 videos have the same tile). I will change the video duplicate system to work like this: save the video url (from the csv) in a separate table and this way no duplicates, even if the title is the same. Hope it makes sense, kinda tired.

Coscast · 2011-09-03 18:01:52

Ok nailed it down, checked via commandline and i got an error while creating thumbs:

/usr/local/bin/ffmpeg -ss 20 -i '/opt/lampp/htdocs/asp/media/videos/vid/579.flv' -f image2 -s 160x120 -an -vframes 2 -y /opt/lampp/htdocs/asp/tmp/thumbs/579/%03d.jpg
ffmpeg version N-32290-g6fc1299, Copyright (c) 2000-2011 the FFmpeg developers
  built on Sep  2 2011 10:45:30 with gcc 4.4.5
  configuration: --prefix=/usr/local --enable-shared --enable-gpl --enable-version3 --enable-nonfree --enable-postproc --enable-libfaac --enable-libmp3lame --enable-libopencore-amrnb --enable-libopencore-amrwb --enable-libvpx --enable-libx264 --enable-libxvid
  libavutil    51. 14. 0 / 51. 14. 0
  libavcodec   53. 12. 0 / 53. 12. 0
  libavformat  53. 10. 0 / 53. 10. 0
  libavdevice  53.  3. 0 / 53.  3. 0
  libavfilter   2. 37. 0 /  2. 37. 0
  libswscale    2.  0. 0 /  2.  0. 0
  libpostproc  51.  2. 0 / 51.  2. 0
[flv @ 0xa48420] Estimating duration from bitrate, this may be inaccurate

Seems stream 0 codec frame rate differs from container frame rate: 1000.00 (1000/1) -> 29.97 (30000/1001)
Input #0, flv, from '/opt/lampp/htdocs/asp/media/videos/vid/579.flv':
  Metadata:
    hasKeyframes    : true
    audiodatarate   : 96
    hasVideo        : true
    stereo          : false
    canSeekToEnd    : true
    framerate       : 30
    audiosamplerate : 44000
    videocodecid    : 2
    datasize        : 13115146
    lasttimestamp   : 120
    audiosamplesize : 16
    audiosize       : 1495000
    hasAudio        : true
    audiodelay      : 0
    videosize       : 11618286
    metadatacreator : inlet media FLVTool2 v1.0.6 - http://www.inlet-media.de/flvtool2
    lastkeyframetimestamp: 120
    height          : 240
    filesize        : 13147979
    hasMetadata     : true
    audiocodecid    : 2
    videodatarate   : 771
    duration        : 120
    hasCuePoints    : false
    width           : 360
  Duration: 00:02:00.21, start: 0.000000, bitrate: 885 kb/s
    Stream #0.0: Video: flv1, yuv420p, 360x240, 789 kb/s, 29.97 tbr, 1k tbn, 1k tbc
    Stream #0.1: Audio: mp3, 44100 Hz, mono, s16, 96 kb/s
Incompatible pixel format 'yuv420p' for codec 'mjpeg', auto-selecting format 'yuvj420p'
[buffer @ 0xa49660] w:360 h:240 pixfmt:yuv420p tb:1/1000000 sar:0/1 sws_param:
[scale @ 0xa4fa80] w:360 h:240 fmt:yuv420p -> w:160 h:120 fmt:yuvj420p flags:0x4
Output #0, image2, to '/opt/lampp/htdocs/asp/tmp/thumbs/579/%03d.jpg':
  Metadata:
    hasKeyframes    : true
    audiodatarate   : 96
    hasVideo        : true
    stereo          : false
    canSeekToEnd    : true
    framerate       : 30
    audiosamplerate : 44000
    videocodecid    : 2
    datasize        : 13115146
    lasttimestamp   : 120
    audiosamplesize : 16
    audiosize       : 1495000
    hasAudio        : true
    audiodelay      : 0
    videosize       : 11618286
    metadatacreator : inlet media FLVTool2 v1.0.6 - http://www.inlet-media.de/flvtool2
    lastkeyframetimestamp: 120
    height          : 240
    filesize        : 13147979
    hasMetadata     : true
    audiocodecid    : 2
    videodatarate   : 771
    duration        : 120
    hasCuePoints    : false
    width           : 360
    encoder         : Lavf53.10.0
    Stream #0.0: Video: mjpeg, yuvj420p, 160x120, q=2-31, 200 kb/s, 90k tbn, 29.97 tbc
Stream mapping:
  Stream #0.0 -> #0.0 (flv -> mjpeg)
Press [q] to stop, [?] for help
[image2 @ 0xa49720] Could not open file : /opt/lampp/htdocs/asp/tmp/thumbs/579/001.jpg
av_interleaved_write_frame(): Input/output error

It seems that php cannot create an directory into thumbs. The whole thing works if ffmpeg creates the files directly in "thumbs" dir without subdir.

symtab · 2011-09-03 18:07:50

Hmm...make sure the /opt/lampp/htdocs/asp/tmp/thumbs is writable by the username that runs the web server (also special cases like selinux, app-armor, grsecurity could influence this, chattr also).

Coscast · 2011-09-03 18:20:57

It is writeable because the normal single upload via video/upload works without problems and it creates the thumbs. I think this method will create tmp thumbs too, or is this not correct ?

symtab · 2011-09-04 06:49:04

This is correct. Hmm...there is no difference between the thumb creation function for normal upload and the thumb creation function for mass csv importing (same frunction from libraries/framework/video.php).

Adult Script Pro Community Forums

#1 2011-09-03 16:40:07

[FIXED] Mass CSV SQL error

#2 2011-09-03 18:00:18

Re: [FIXED] Mass CSV SQL error

#3 2011-09-03 18:01:52

Re: [FIXED] Mass CSV SQL error

#4 2011-09-03 18:07:50

Re: [FIXED] Mass CSV SQL error

#5 2011-09-03 18:20:57

Re: [FIXED] Mass CSV SQL error

#6 2011-09-04 06:49:04

Re: [FIXED] Mass CSV SQL error

Board footer