The forum is here for legacy reasons. No new posts will be created. User registration is disabled! If you have any questions, please email us or check https://www.adultscriptpro.com for more details!
You are not logged in.
Pages: 1
I have disabled the flv convertion. I have convert to mp4 enabled and the other option where it says to leave mp4 as they are. I have also mobile mp4 enabled. Now i have uploaded videos through ftp and i get this error
Query: UPDATE aspvideo SET ext = 'mp4', size = , duration = 1302.15, thumbs = 10, mobile = '0', server = 0, s3 = 0, status = 1 WHERE video_id = 38 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 = 1302.15, ' at line 3
Error Number: 1064
this clearly has to do something with the duration
So what happens next is:
1. the video stays into converting forever
2. the original file remains at the temp/upload file
3. into the videos mp4 folder there is a file like 84.nomov.avi
4. at the video details there is no duration
5. there is no mobile mp4 created.
So what i am doing next is
1. Manualy change from converting to active
2. Manually delete the original file
3. Manualy rename the file from 84.nomov.avi to 84.avi
4. Manually enter the duration
5. Still i did not manage to convert to mobile mp4
So this is not acceptable and i need a solution as soon as possible.
Offline
Send me a email with ssh root access to the server. I will check and fix.
Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds
Offline
I'm working on finding the problem. I will let you know once its fixed.
Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds
Offline
Hi there,
I have upgraded my fmpeeg to the last version (actually my hoster did) but still i get this error
Query: UPDATE aspvideo SET ext = 'mp4', size = , duration = 1144.84, thumbs = 19, mobile = '0', server = 0, s3 = 0, status = 1 WHERE video_id = 156 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 = 1144.84, ' at line 3
Error Number: 1064
So please can you again fix that so i can finally work with my site?
With Regards,
Offline
Please email me ssh root access and i will check the conversion log. I can also fix by adding a default size.
Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds
Offline
Not yet. Checking now.
Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds
Offline
Its because you dont have qt-faststart installed or the installed qt-faststart is not working.
Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds
Offline
Offline
Just for informational purposes, mines was working real fine until i suddenly got that error. The video that gives that error delete it, sometimes it's corrupted and cannot be converted. But this is only if you get the error after everything works fine before.
Offline
Pages: 1