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
Pages: 1
#1 2016-05-03 21:03:41
- DuttyRock
- Member
- Registered: 2011-11-05
- Posts: 740
[FIXED IN 2.2.3] Mobile video error
Any video with ' in title get error on mobile not on desktop.
Offline
#2 2016-05-04 04:53:15
Re: [FIXED IN 2.2.3] Mobile video error
What exact error will appear?
Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds
Offline
#4 2016-05-05 22:17:22
- DuttyRock
- Member
- Registered: 2011-11-05
- Posts: 740
Re: [FIXED IN 2.2.3] Mobile video error
You get this error once ' is in your title for mobile only.
Query: SELECT v.video_id, v.title, v.slug, v.likes, v.rating, v.rated_by, v.duration, v.thumb, v.thumbs, v.total_views, v.add_time, v.ext, v.hd, v.premium, v.type, u.username, MATCH (v.title) AGAINST ('Pawg dat pussy don't lie') AS relevance FROM video AS v LEFT JOIN user AS u ON (u.user_id = v.user_id) WHERE MATCH (v.title) AGAINST ('Pawg dat pussy don't lie') AND v.status = 1 AND v.video_id != 19760 AND v.mobile = 1 ORDER BY relevance DESC LIMIT 8
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 't lie') AS relevance FROM video AS v ' at line 3
Error Number: 1064Last edited by DuttyRock (2016-05-05 22:17:34)
Offline
#5 2016-05-06 06:03:14
Re: [FIXED IN 2.2.3] Mobile video error
Pff....edit mobile/components/video_view.php and find:
AGAINST ('".$this->db->escape($title)."')replace with:
AGAINST ('".$this->db->escape($title)."')Fixing in 2.2.2.
Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds
Offline
#6 2016-05-08 00:37:02
- DuttyRock
- Member
- Registered: 2011-11-05
- Posts: 740
Re: [FIXED IN 2.2.3] Mobile video error
Think you post the same code twice.
Offline
#7 2016-05-09 09:27:44
Re: [FIXED IN 2.2.3] Mobile video error
Erm:
AGAINST ('".$title."')replace with:
AGAINST ('".$this->db->escape($title)."')Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds
Offline
#8 2016-07-08 11:52:58
Re: [FIXED IN 2.2.3] Mobile video error
Fixed in 2.2.3
Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds
Offline
Pages: 1