Product page display problem

Joanne86 · March 30th, 2007, 01:56 PM

The product page was displaying fine and we'd uploaded quite a few new products without any problems. Then when we added another new product with photo, the display got messed up.
On the previous and next product film strip, instead of 5 pics being shown, there are now 7, with a blue column on the right side above one of the pics that shouldn't be there.
We made no changes to the software just before this happened.
Screen print attached to show the problem.

Thanks

Chuck S · March 30th, 2007, 02:00 PM

well you can try in showproduct.php changing the 6 to a 7

Code:

Content visible to verified customers only.

Joanne86 · March 30th, 2007, 03:03 PM

I've done that, and it's got rid of the solid blue column box on right side. But pages still aren't displaying correctly.

As shown in attached screen prints-
some pages are like #1 with 4 photo boxes on film strip, but arrows for next & previous not displaying right.
some pages are like #2 with 7 boxes on film strip

Chuck S · March 30th, 2007, 04:40 PM

That will display fine the number of photos shown depends on the queries issued and the variable dymnamics of the page by what photo your viewing how many photos in that cat what sort is used etc etc

Teck · November 14th, 2007, 12:48 PM

I have same problem.
With your code Chuck S the 7 products are inside the main table, but the "elegant solution" probably is limit it to 5.

Where we can find that setting? In PP this works perfect with 5 thumbs. Is not possible adapt the PP code to that filmstrip?

Chuck S · November 14th, 2007, 03:48 PM

PP is not limited to 5 sometimes I see 7 as their is no specific switch yet in the filmstrip currently in any product. We try to process only 5 but sometimes you can see 5 6 or 7 but if you want to display 5 just place a limit statement on the queries in showproduct.php

LIMIT 5

bpi007 · December 23rd, 2007, 02:50 AM

Same problem in one category. I've 3 products but next and previous only display two products.

bpi007 · December 23rd, 2007, 03:19 AM

Is it possible when we change sortid number in table rp_sort that program work in different way ?

Chuck S · December 23rd, 2007, 10:31 AM

Sort sorts the results does not control how many are pulled. Without more info I am unsure what your trying to ask. The next prev displays pull info depending on the information passed in a url. There are many different cases and queries depending on what is passed.

bpi007 · December 23rd, 2007, 11:28 AM

Easy to explain (and language won't be a problem) :

Click http://www.plouf.be/scuba-planet/showcat.php?cat=14 (3 products)

Choose the first of the list (http://www.plouf.be/scuba-planet/sho...oduct=5&cat=14) and it display only two products on the frame "next/previous"

All website is sorted on "manufacturer Name" ("Fabricant" in french)

Chuck S · December 23rd, 2007, 11:33 AM

How about this one only shows the one

http://www.plouf.be/scuba-planet/sho...oduct=1&cat=14

Are you running 3.33?

bpi007 · December 23rd, 2007, 11:41 AM

Quote:

Originally Posted by Chuck S

How about this one only shows the one

http://www.plouf.be/scuba-planet/sho...oduct=1&cat=14

I don't know why (it's the problem) !

Quote:

Originally Posted by Chuck S

Are you running 3.33?

ReviewPost v3.33
Build: 3/12/07 6:41 AM

Chuck S · December 23rd, 2007, 11:48 AM

Is anything unapproved under approve in admin?

Code:

Content visible to verified customers only.

The only restriction there is the product needs to be approved to show it.

bpi007 · December 23rd, 2007, 12:15 PM

Any products are unapproved. I don't leave choice for customer to upload product. All product are over there in Admin Mode.

Chuck S · December 23rd, 2007, 12:19 PM

http://www.reeftalk.com/reviews/show...hp?product=556

I think you would need to send explicit admin login and ftp info to support@photopost.com as well as phpmyadmin access if you have it. I would need to investigate why you have an issue. There is no other variables in the url and clearly not all products are not shown but they should be.

bpi007 · December 23rd, 2007, 12:44 PM

Do you want a dump of Mysql database ?
My system is linked to a phpnuke system.

Chuck S · December 23rd, 2007, 01:01 PM

No a dump is not necessary I was more interested in seeing the tables mysql and being able to run some test queries.

bpi007 · December 23rd, 2007, 01:13 PM

PhpMyAdmin is not accessible directly without supervisor access of my hosting. I can't provide them.
Ftp will be ok and admin access too. if you're ok, I can send it now.

I'm also a developpers, if you provide me the code where "prev and next" are generated, I can check too.

Chuck S · December 23rd, 2007, 05:08 PM

You can check in showproduct.php and the code is clearly marked the conditionals. i will check our helpdesk as well for your email.

bpi007 · December 23rd, 2007, 05:31 PM

Chuck, I'v found something strange :
when I click on this link http://www.plouf.be/scuba-planet/sho...oduct=5&cat=14 in showproduct.php the code found " elseif( !empty($date) )" and the select was running that :
SELECT id,bigimage,cat,userid,approved FROM {$Globals['rp_db_prefix']}products WHERE date >= $lowdate AND date < $highdate AND approved=1 $whichcat ORDER BY date DESC

This select only retrieve product by date and not by manufacturer.