Adult Script Pro Community Forums
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.
- Topics: Active | Unanswered
#1 2011-10-11 04:33:21
[NOT A BUG / PARTIAL FIX NEEDED] CVS Import Duration Issue
For all clips that are imported as embedded and hotlinked are 2:00 duration shown and not the real time of 3 mins or 5 mins etc.
If i start "Regenerate Duration" i get the following error
Query: UPDATE video SET duration = WHERE video_id = 4608 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 'WHERE video_id = 4608 LIMIT 1' at line 1
Error Number: 1064Ben
Offline
#2 2011-10-11 05:16:10
Re: [NOT A BUG / PARTIAL FIX NEEDED] CVS Import Duration Issue
For the hotlinked and embedded videos does the CSV contain a duration field? If there is no field is the duration set to 0?
Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds
Offline
#3 2011-10-11 07:24:50
Re: [NOT A BUG / PARTIAL FIX NEEDED] CVS Import Duration Issue
Yes it does. And like i said 2 mins is shown for all and not the real duration.
Offline
#4 2011-10-11 08:11:25
Re: [NOT A BUG / PARTIAL FIX NEEDED] CVS Import Duration Issue
Can you please email me or post the CSV here?
Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds
Offline
#5 2011-10-11 08:20:10
Re: [NOT A BUG / PARTIAL FIX NEEDED] CVS Import Duration Issue
Will email the cvs 
Offline
#6 2011-10-11 09:01:31
Re: [NOT A BUG / PARTIAL FIX NEEDED] CVS Import Duration Issue
I've checked like 30 videos in the CSV and then scrolled down. All videos have 120 seconds as the duration and thats why the CSV ads the video with 02:00 duration.
Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds
Offline
#7 2011-10-11 11:58:40
Re: [NOT A BUG / PARTIAL FIX NEEDED] CVS Import Duration Issue
Oohh then the cvs wasn´t generated correct by them 
Many thanks for checking !
How can this mysql error be fixed to regenerate the duration ?
Offline
#8 2011-10-11 12:02:09
Re: [NOT A BUG / PARTIAL FIX NEEDED] CVS Import Duration Issue
The SQL error appears because there is no video file (video is hotlinked/embedded), so there is no way to generate the duration. I can make that not show in the next version.
Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds
Offline
#9 2011-10-11 12:04:52
Re: [NOT A BUG / PARTIAL FIX NEEDED] CVS Import Duration Issue
I understand
Maybe you can make it possible too then that we can edit the duration too to change it manually for such cases 
Offline
#10 2011-10-11 12:23:07
Re: [NOT A BUG / PARTIAL FIX NEEDED] CVS Import Duration Issue
You can. Edit video and click on the Advanced button.
Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds
Offline
#11 2011-10-11 14:01:51
Re: [NOT A BUG / PARTIAL FIX NEEDED] CVS Import Duration Issue
Ooops i didn´t see this 
Many thanks Adrian
Offline