Convert error

[pornodelen]

Hello,

I have a problem, If have a convert error. If i run convert.php if got this message:

ERROR: Unable to execute query

SELECT * FROM `process_queue` AS v, `signup` as s WHERE
v.id= AND v.user=s.username
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 'AND v.user=s.username' at line 2


Who can help me with this problem?

Kind Regards

Daan

[bplex]

You cannot run convert.php manually. If you have a problem with something not converting correctly, you will need to run the convert process from the Admin section. Login to your admin section and view your Process Queue. There will be a link next to any failed converted items in which you can rerun the convert process.

[pornodelen]

Hello,

I have already done that, but the movi will not convert.

This is the message:

File: /var/www/vhosts/domain.com/httpdocs/video/trialerhdggvibo.wmv

################################################## ##

SELECT * FROM `video` WHERE `VID`=8

################################################## ##

Video id: 8

Find video duration - START

/usr/bin/ffmpeg -i /var/www/vhosts/domain.com/httpdocs/video/trialerhdggvibo.wmv

FFmpeg version SVN-r15173, Copyright (c) 2000-2008 Fabrice Bellard, et al.
configuration: --prefix=/usr --enable-shared --enable-libxvid --enable-libvorbis --enable-libmp3lame --enable-gpl --enable-libfaac --enable-libfaad --enable-liba52 --enable-libamr-nb --enable-libamr-wb --enable-nonfree
libavutil 49.10. 0 / 49.10. 0
libavcodec 51.71. 0 / 51.71. 0
libavformat 52.21. 0 / 52.21. 0
libavdevice 52. 1. 0 / 52. 1. 0
built on Sep 3 2008 15:25:56, gcc: 4.1.2 20071124 (Red Hat 4.1.2-42)
[wmv3 @ 0x97b8c80]Extra data: 8 bits left, value: 0

Seems stream 1 codec frame rate differs from container frame rate: 1000.00 (1000/1) -> 25.00 (25/1)
Input #0, asf, from '/var/www/vhosts/domain.com/httpdocs/video/trialerhdggvibo.wmv':
Duration: 00:00:34.27, start: 5.000000, bitrate: 3134 kb/s
Stream #0.0: Audio: wmav2, 48000 Hz, stereo, s16, 128 kb/s
Stream #0.1: Video: wmv3, yuv420p, 720x576, 3000 kb/s, 25.00 tb(r)
Must supply at least one output file
Duration (ffmpeg): 34


DURATION: 00:34

Create Thumbnail - START

Creating Thumbnail with ffmpeg
/var/www/vhosts/domain.com/httpdocs/thumb/8.jpg

/usr/bin/ffmpeg -i /var/www/vhosts/domain.com/httpdocs/video/trialerhdggvibo.wmv -ss 00:00:31 -t 00:00:01 -s 320x240 -r 1 -f mjpeg /var/www/vhosts/domain.com/httpdocs/thumb/8.jpg
/var/www/vhosts/domain.com/httpdocs/thumb/1_8.jpg

/usr/bin/ffmpeg -i /var/www/vhosts/domain.com/httpdocs/video/trialerhdggvibo.wmv -ss 00:00:24 -t 00:00:01 -s 120x90 -r 1 -f mjpeg /var/www/vhosts/domain.com/httpdocs/thumb/1_8.jpg
/var/www/vhosts/domain.com/httpdocs/thumb/2_8.jpg

/usr/bin/ffmpeg -i /var/www/vhosts/domain.com/httpdocs/video/trialerhdggvibo.wmv -ss 00:00:13 -t 00:00:01 -s 120x90 -r 1 -f mjpeg /var/www/vhosts/domain.com/httpdocs/thumb/2_8.jpg
/var/www/vhosts/domain.com/httpdocs/thumb/3_8.jpg

/usr/bin/ffmpeg -i /var/www/vhosts/domain.com/httpdocs/video/trialerhdggvibo.wmv -ss 00:00:19 -t 00:00:01 -s 120x90 -r 1 -f mjpeg /var/www/vhosts/domain.com/httpdocs/thumb/3_8.jpg
Create Thumbnail with ffmpeg - END

CONVERT COMMAND: /usr/bin/ffmpeg '/var/www/vhosts/domain.com/httpdocs/video/trialerhdggvibo.wmv' -o /var/www/vhosts/domain.com/httpdocs/flvideo/12213473261633271167.flv -of lavf -oac mp3lame -lameopts abr:br=56 -ovc lavc -lavcopts vcodec=flv:vbitrate=500:mbd=2:mv0:trell:v4mv:cbp:l ast_pred=3 -srate 22050 -ofps 24 -vf harddup

################################################## ##

Array
(
)

################################################## ##

Return value:

Running flvtool2: /usr/bin/flvtool2 -U /var/www/vhosts/domain.com/httpdocs/flvideo/12213473261633271167.flv

Back

Can someone help me please?

Thanks

[bplex]

There's your problem right there (well, here's your problem right here, lol):

CONVERT COMMAND: /usr/bin/ffmpeg '/var/www/vhosts/domain.com/httpdocs/video/trialerhdggvibo.wmv' -o /var/www/vhosts/domain.com/httpdocs/flvideo/12213473261633271167.flv -of lavf -oac mp3lame -lameopts abr:br=56 -ovc lavc -lavcopts vcodec=flv:vbitrate=500:mbd=2:mv0:trell:v4mv:cbp:last_pred=3 -srate 22050 -ofps 24 -vf harddup

The program that your convert command is executing is ffmpeg, but the flags that it is using is for mencoder.

1. Do you have mencoder and mplayer installed on your server (or does your webhost have it installed)?
2. Open up your config.php file (located in the includes directory). For the section that says $config['mencoder'], what is the part in the quotes ("") after that?

[pornodelen]

Hello,

Thanks for your answers. I have found the problem I have used at $config['mencoder'] /usr/bin/ffmpeg. Thats not ok and i have changed to /usr/bin/mencoder and the video are oke now.

Many thanks,

Greetings Daan