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.
Probably you forgot , \ after v.rating, v.total_views, v.duration, v.video_id AS video, \
Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds
Offline
Ahh...you have a old version of mysql? What version of mysql do you have? GROUP_CONCAT is only supported in 5.x i think.
Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds
Offline
In that version of MySQL GROUP_CONCAT is supported. What version of mysql is linked to the searchd and indexer binary? Please email me ssh access.
Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds
Offline
Its fixed. Is that config from our script? There were like 20 errors in the sphinx.conf file, and i've done tons of configurations, but those errors are not in our example file.
Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds
Offline
Offline
i now get this error if i enable sphinx
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, v.premium, u.username FROM aspvideo AS v LEFT JOIN aspuser AS u on (u.user_id = v.user_id) WHERE v.video_id IN (656,1103,479,1107,1372,660,82,375,853,523) ORDER BY FIELD (v.video_id, 656,1103,479,1107,1372,660,82,375,853,523)
Error Message: FUNCTION analtube_asp.FIELD does not exist
Error Number: 1305
Offline
Edit modules/video/components/view.php and remove the space between FIELD and (. No idea why this bug, probably something to do with mysql, because for me it works without this bug on several installations.
Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds
Offline
Go to Admin -> Config and enable debug. Once enabled try the search again, if a error appears, please paste it here (i will be gone for the weekend, so i will only reply on Monday,sorry for my delay).
Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds
Offline
That means that you need to increase the memory_limit in php.ini
Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds
Offline
Did the indexer run and searched started?
Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds
Offline
It searches through tags also, but the title is the most important.
Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds
Offline