PhotoPost Photo Gallery Sales PhotoPost Sales Toll Free Phone Number
Mon-Fri 9am-4pm EST
  PhotoPost Photo Sharing Photo Gallery    Visualize community tm
| | | | | | | | |

Go Back   PhotoPost Community > PhotoPost Support > ReviewPost Pro Support Forums > ReviewPost Bug Reports

ReviewPost Bug Reports Let us know about any post installation problems you are having with ReviewPost.

Reply
 
LinkBack Thread Tools Rate Thread Display Modes
Old February 19th, 2005, 05:27 AM   #1 (permalink)
Member
Verified Customer
 
Join Date: Apr 2004
Location: Finland
Posts: 89
2.84 ... search is broken

It seems that at least all 2.8x's have several bugs in search.php - so search is practically useless.

The "only" thing that works is "Search all fields" because otherwise you'll end up having errors like:
---------
MySQL error reported!

Script: search

Query: SELECT c.id,c.username,c.userid,c.date,c.comment,c.cat,c.product,p.bigimage,p.cat,p.userid FROM comments c LEFT JOIN products p ON p.id=c.product WHERE c.comment != '' AND ((c.comment LIKE "% Garmin%") OR (c.comment LIKE "Garmin%"))

Result: Table 'viperalley.comments' doesn't exist

Database handle: Resource id #4
---

(those 'c.comment' should be 'c.review' and 'comments' should be 'reviews')

Then there are a couple of other lines in that script where 'comments' should be also 'reviews'.. and then there's also an extra space in 'AND ((c.comment LIKE \"% $key%\") )'

.. see that % $key% - it should be %$key%

Then there are wrong links like (this is twice...) :
$ucuser[$itemnum] = "<a href=\"{$Globals['maindir']}/showphoto.php?photo=$comphoto\">$cusername</a>";

SHOWPHOTO.PHP and ?photo..... ?

Then there are no functions what to do when "what=title" or "what=titledesc" so when those are used script jumps straight to the end where is this "forward" thing....

Last edited by Mikan; February 19th, 2005 at 05:59 AM.
Mikan is offline   Reply With Quote
Old February 19th, 2005, 09:09 AM   #2 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 66,795
The keys are seached in another file not the seach file for title desc etc but here is a cleaned up file without the photo or comment things.
Attached Files
File Type: txt search.txt (8.3 KB, 5 views)
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.

Last edited by Chuck S; February 19th, 2005 at 10:30 AM.
Chuck S is online now   Reply With Quote
Old February 19th, 2005, 10:02 AM   #3 (permalink)
Member
Verified Customer
 
Join Date: Apr 2004
Location: Finland
Posts: 89
Thanks, but it's still broken.

LEFT JOIN {$Globals['pp_db_prefix']}products p ON p.id=c.product WHERE c.comment != '' $catcheck

c.comment .. twice..

And there are still issues at least with "search title only" and probably with "search title and description".

By the way.... when you get those results from searches above it would be a lot better if the text under product would include also the name of the product and not only the name of the person who posted that product originally.
Mikan is offline   Reply With Quote
Old February 19th, 2005, 10:37 AM   #4 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 66,795
The above file has been fixed to remove the c.comments as your right however I dont follow you on your thinking as far as title and description not working.

They work just fine. I have one product with the title of "ecosystem" in the title on over 800 products and I do a search and that one product is returned.

If I follow the same logic and search for "ecosystem" in both title and desc it brings back 5 results which is correct as other descriptions have this word in it.

You can try it here and see it works fine

http://www.reeftalk.com/reviews/index.php
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is online now   Reply With Quote
Old February 19th, 2005, 12:20 PM   #5 (permalink)
Member
Verified Customer
 
Join Date: Apr 2004
Location: Finland
Posts: 89
Quote:
Originally Posted by omegatron
Ok, if you go there you'll see on "Recent Products" this:

SPECTRAPURE Liter Meter III

Ok, let's go to search and put this to "Keywords"

SPECTRAPURE

Check "search title only" & "All Categories" and hit Execute search ->
"This category does not contain any products."

Shouldn't that search find that " SPECTRAPURE Liter Meter III " product?
So it seems that "search title only" doesn't work.

Then... if you go back and check "search title and description" and hit Execute - now it works but I think that is because it is mentioned in description - but if that keyword exists only in title that search will come up empty - so that option searches description ok, but it doesn't search title even though it should - I think.. I'm not 100% sure about this.

Last edited by Mikan; February 19th, 2005 at 12:26 PM.
Mikan is offline   Reply With Quote
Old February 19th, 2005, 06:51 PM   #6 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 66,795
SPECTRAPURE IS NOT A TITLE

It is a manu or manufacturer. We never search for manufacturer or state that we do. It is title or description or keywords or comments
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is online now   Reply With Quote
Old February 20th, 2005, 03:12 AM   #7 (permalink)
Member
Verified Customer
 
Join Date: Apr 2004
Location: Finland
Posts: 89
Oh? Now I'm a little bit confused - what is actually that "title". For some reason I kind of thought that it's the manufacturer and model combined.

So if you go here:
http://www.reeftalk.com/reviews/show...p/product/1773
...what is the title?

Last edited by Mikan; February 20th, 2005 at 03:17 AM.
Mikan is offline   Reply With Quote
Old February 20th, 2005, 12:27 PM   #8 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 66,795
Liter Meter III

Nope the title is the title not the manufacturer.

Search works like it should as we dont presently search the manu field although its not a big deal to alter the file showcat.php to add the manu in there and I will pass along to Michael just so people dont get confused on it.
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is online now   Reply With Quote
Old March 18th, 2005, 10:58 PM   #9 (permalink)
Member
Verified Customer
 
Join Date: Sep 2003
Posts: 106
Does RP 2.9 search the manu field?
Tom1234 is offline   Reply With Quote
Old March 19th, 2005, 08:15 AM   #10 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 66,795
its in there yes
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is online now   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
uploading is broken plot Installs and Upgrade - vBulletin 3.5.X 3 November 15th, 2005 12:18 PM
5.13: Broken link on member search results(FIXED) kturby Photopost Pro Bug Reports 1 July 16th, 2005 10:25 AM
Problems with search page (search.php) JerryM Classifieds Bug Reports 8 August 27th, 2004 11:39 AM
Search: Option to choose category to search in slant213 Classifieds Installation & Upgrades 4 July 12th, 2004 09:53 AM


All times are GMT -5. The time now is 10:47 AM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0