Adult Script Pro Community Forums

Create, help and share your ideas with the community!

You are not logged in.

#1 2016-05-03 21:03:41

DuttyRock
Member
Registered: 2011-11-05
Posts: 736

[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,279
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 - PopAds

Offline

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

ivatigoal
Member
Registered: 2013-06-07
Posts: 366
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: 736

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,279
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 - PopAds

Offline

#6 2016-05-08 00:37:02

DuttyRock
Member
Registered: 2011-11-05
Posts: 736

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,279
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 - PopAds

Offline

#8 2016-07-08 11:52:58

symtab
Administrator
Registered: 2010-08-23
Posts: 7,279
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 - PopAds

Offline

Board footer

Powered by FluxBB