hotshoeshots shoe lovers communityHomeVoteForumsJoinBlogsFAQContactChatRules

Login

Forgotten Password

Shoe Shot Action

Select a category from the list above, then click on one of the buttons below

Statistics
Members Online4
Visitors Online577
Members chatting0
Registered Members17,119
Submitted Pictures250,766
Times Voted2,463,298
New Members Last Month With Pictures3
Members Birthdays3

Community

Shoe fetish sex topicsBlogs

Information

About UsF.A.Q.Contact Us
Top Couples
Click to see hellheel’s pichellheel9.70
Click to see stoffer’s picstoffer9.57
Click to see adorosaltos’s picadorosaltos9.50
Click to see adorosaltos’s picadorosaltos9.48
Click to see adorosaltos’s picadorosaltos9.43
View Top 50
Top Toe Cleavage shots
Click to see zuppolo’s piczuppolo9.47
Click to see zuppolo’s piczuppolo9.46
Click to see hhlvr’s pichhlvr9.45
Click to see zuppolo’s piczuppolo9.30
Click to see zuppolo’s piczuppolo9.25
View Top 50
Top Flat Shoes
Click to see adventure_cpl’s picadventure_cpl9.48
Click to see adventure_cpl’s picadventure_cpl9.33
Click to see kellyskollection’s pickellyskollection9.29
Click to see WhipAndHeels’s picWhipAndHeels9.25
Click to see FlatsFetish’s picFlatsFetish9.05
View Top 50
Top Sneakers
Click to see koolkylie’s pickoolkylie9.52
Click to see dieselfreak’s picdieselfreak9.13
Click to see hub27’s pichub279.00
Click to see hub27’s pichub278.96
Click to see IrishLincoln’s picIrishLincoln8.96
View Top 50
Top Shoe Fucking
Click to see Shoe_Lover’s picShoe_Lover9.67
Click to see lover88’s piclover889.50
Click to see Shoe_Lover’s picShoe_Lover9.50
Click to see Miss Rivers’s picMiss Rivers9.48
Click to see Naughtychristy’s picNaughtychristy9.44
View Top 50
Top Wedge Heels
Click to see slinkymel’s picslinkymel9.33
Click to see droid1959’s picdroid19599.28
Click to see adorosaltos’s picadorosaltos9.18
Click to see chakakan’s picchakakan9.18
Click to see lili’s piclili9.06
View Top 50
Top Found shoes
Click to see lili’s piclili9.26
Click to see WhipAndHeels’s picWhipAndHeels9.18
Click to see highheelfever’s pichighheelfever9.00
Click to see highheelfever’s pichighheelfever9.00
Click to see highheelfever’s pichighheelfever8.96
View Top 50
Top Flat Sandals
Click to see forest4422’s picforest44229.44
Click to see forest4422’s picforest44229.27
Click to see forest4422’s picforest44229.21
Click to see forest4422’s picforest44229.21
Click to see forest4422’s picforest44228.98
View Top 50
Top Bare foot shots
Click to see asos4’s picasos49.55
Click to see adventure_cpl’s picadventure_cpl9.27
Click to see kinkychuck’s pickinkychuck9.07
Click to see chickyd15’s picchickyd159.05
Click to see BassT’s picBassT9.00
View Top 50
Top Men in heels
Click to see KellysFeet’s picKellysFeet9.89
Click to see KellysFeet’s picKellysFeet9.47
Click to see Spikes’s picSpikes9.38
Click to see KellysFeet’s picKellysFeet9.33
Click to see Cindyschotte’s picCindyschotte9.31
View Top 50
Top Dangling Shots
Click to see Bbrode’s picBbrode9.67
Click to see zuppolo’s piczuppolo9.30
Click to see sasme99’s picsasme999.26
Click to see MistressBetty’s picMistressBetty9.09
Click to see stryker’s picstryker9.03
View Top 50

FAQs and the place to ask a question about the site: SQL Statement Bug


Forums > FAQs and the place to ask a question about the site > SQL Statement Bug (2 messages)

Post A Reply : Start A New Thread : New Posts : Search Forums

demand18



Member Profile
Posts: 		Wed, Jun 03, 2009 21:09:16
SQL Statement Bug
Hi,
if I use the "Seach Forum" Link and select the "Any Of The Words" radio button, an exception will be thrown by the MySQL server:
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 'BOOLEAN MODE OR MATCH (p_title) AGAINST ('test') IN BOOLEAN MODE) AND (t_forum =' at line 1
Failed query: SELECT DISTINCT p_thread FROM rate_forum_posts LEFT JOIN rate_forum_threads ON p_thread=t_id WHERE (MATCH (p_text) AGAINST ('test') IN BOOLEAN MODE OR MATCH (p_title) AGAINST ('test') IN BOOLEAN MODE) AND (t_forum = 2 OR t_forum = 4 OR t_forum = 11 OR t_forum = 5 OR t_forum = 9 OR t_forum = 10 OR t_forum = 12 OR t_forum = 23 OR t_forum = 44 OR t_forum = 16 OR t_forum = 22 OR t_forum = 19 OR t_forum = 21 OR t_forum = 25 OR t_forum = 26 OR t_forum = 29 OR t_forum = 34 OR t_forum = 35 OR t_forum = 36 OR t_forum = 37 OR t_forum = 38 OR t_forum = 39 OR t_forum = 40 OR t_forum = 42 OR t_forum = 43 OR t_forum = 45 OR t_forum = 46 OR t_forum = 47 OR t_forum = 48 OR t_forum = 49 OR t_forum = 50 OR t_forum = 52 OR t_forum = 54 OR t_forum = 55 OR t_forum = 56 OR t_forum = 57)

I think you need to include the modifier "IN BOOLEAN MODE" in the paranthesis belonging to the AGAINST predicate like this:
MATCH (p_text) AGAINST ('test' IN BOOLEAN MODE)
instead of
MATCH (p_text) AGAINST ('test') IN BOOLEAN MODE

At least that is what is says on http://dev.mysql.com/doc/refman/5.1/en/
fulltext-search.html#function_match

Hope that helps

Bob
shoejack
Captain

Click To View
Posts: 543		 Thu, Jun 04, 2009 05:29:04
Sure does Bob, many thanks I'll try the mod later today. Hadn't found that particular glitch so far so thanks again and welcome onboard.
Best regards
SJ

Post A Reply : Start A New Thread : New Posts : Search Forums
Hot Shoe Shots - everyone gets a kick out of sexy shoes. footer image

Hot Shoe Shots - everyone gets a kick out of sexy shoes. © 2007 - 2024