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 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

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

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

#3 2016-05-05 19:29:32

ivatigoal
Member
Registered: 2013-06-07
Posts: 367
Website

Re: [FIXED IN 2.2.3] Mobile video error

Yes I get the same error we get a white page with sql syntax error


Analtube4u

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: 1064

Last edited by DuttyRock (2016-05-05 22:17:34)

Offline

#5 2016-05-06 06:03:14

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

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

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

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

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

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

Board footer

Powered by FluxBB