Embeding causing temporary error

asko · 2011-09-03 13:53:39

When ever do run 'mass embed' always get error message for few initial hours for fresh embeds.
New thumbs appear immediately and good but do not play, instead get this error message which lasts
a few minutes, after few hours all is good. This bad from user perspective, gives errors.

Query: SELECT v.video_id, v.title, v.slug, v.rating, v.rated_by, v.duration, v.thumb, v.thumbs, v.total_views, v.add_time, v.ext, u.username FROM video AS v LEFT JOIN user AS u on (u.user_id = v.user_id) WHERE v.video_id IN ()
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 ')' at line 5
Error Number: 1064

At worst how can i display a "Video available in few minutes" message instead of getting an ugly error page

Last edited by asko (2011-09-03 14:36:10)

Coscast · 2011-09-03 15:08:13

Hmm, i never saw that error.

symtab · 2011-09-03 17:48:58

That actually is the code for related videos. Are you using sphinx?

asko · 2011-09-17 19:10:35

maybe i clicked a video under related, anyways it was giving an error also directly from category section and new videos section, yes using sphynx.

I think a solution--> IF it exists to set admin panel to approve videos before displaying them on site so i could give it some time before letting them show?

Last edited by asko (2011-09-17 19:13:00)

symtab · 2011-09-17 22:07:03

Hmm...on which page do you get this error? Set the mass embedder to set the videos to suspended, so the videos will only be loaded once you set them to approve.

asko · 2011-10-03 00:46:21

i get this when clicking thumbs to watch it. The video plays in the admin preview no problem.
I will try what you advised me.

Adult Script Pro Community Forums

#1 2011-09-03 13:53:39

Embeding causing temporary error

#2 2011-09-03 15:08:13

Re: Embeding causing temporary error

#3 2011-09-03 17:48:58

Re: Embeding causing temporary error

#4 2011-09-17 19:10:35

Re: Embeding causing temporary error

#5 2011-09-17 22:07:03

Re: Embeding causing temporary error

#6 2011-10-03 00:46:21

Re: Embeding causing temporary error

Board footer