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.

#1 2011-07-08 03:58:19

xsporntv
Member
Registered: 2011-04-20
Posts: 139
Website

Anybody got a fix for 'Error Number: 1064'

I embedded 1 video.  The only one and after clicking on the thumb it gives me this mesg:

Query: SELECT COUNT(*) AS total_related FROM video_tags AS t INNER JOIN video_category AS c ON (c.video_id = t.video_id AND c.cat_id IN ()) WHERE t.name IN ('quot pornstar quot') AND t.video_id != 2
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 t.name IN ('quot pornstar quot') ' at line 3
Error Number: 1064

What to do?

Offline

#2 2011-07-08 07:28:05

symtab
Administrator
Registered: 2010-08-23
Posts: 7,501
Website

Re: Anybody got a fix for 'Error Number: 1064'

You did not add your video to a category. I quess it would be better to force the user to select a category even in the admin panel. Go to Admin -> Tools -> Orphan Videos. Also your tags should be separated by commas, not spaces.


Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds

Offline

#3 2011-07-08 13:25:31

xsporntv
Member
Registered: 2011-04-20
Posts: 139
Website

Re: Anybody got a fix for 'Error Number: 1064'

Interesting!  ; )

Makes sense.

Cheers!

Offline

#4 2011-07-20 14:14:57

symtab
Administrator
Registered: 2010-08-23
Posts: 7,501
Website

Re: Anybody got a fix for 'Error Number: 1064'

Another fix would be to disable related by category in Admin -> Video -> Configure.


Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds

Offline

Board footer

Powered by FluxBB