Zikula Community

• lexscripta
  
  

  • Rank: Registered User
  • Registered: Jan 07, 2008
  • Last visit: Oct 21, 2009
  • Posts: 32

  Posted: Jan 17, 2008 - 02:50 PM

  Hello, Having the problem of ProdReviews - worked fine on another host (Am with BlueHost Now) And did a fresh install. Installed ProdReviews, EZComments,Rating and everything works ok - except for the "10 most popular reviews" and the "10 most recent reviews". Wonder if there is something I am overlooking? - LexScripta

  • 
  •  
• kaffeeringe.de
  
  

  • Rank: Software Foundation
  • Registered: Sep 03, 2002
  • Last visit: May 09, 2010
  • Posts: 909

  Posted: Jan 18, 2008 - 02:12 AM

  What happens instead? HTRB
  
  --
  best regards from Kiel, sailing city
  
  Steffen Voss
  
  Member of the Zikula Steering Committee
  Read The Zikulan's Blog "If you want people to RTFM, make a better FM!"

  • 
  •  
• lexscripta
  
  

  • Rank: Registered User
  • Registered: Jan 07, 2008
  • Last visit: Oct 21, 2009
  • Posts: 32

  Posted: Jan 20, 2008 - 09:06 AM

  It just shows the normal layout, but there are no recent reviews or popular ones to click on, even though I have created some products.
  
  LexScripta

  • 
  •  
• jmvedrine
  
  

  • Rank: Helper
  • Registered: Jan 12, 2004
  • Last visit: Jan 20, 2010
  • Posts: 590

  Posted: Jan 21, 2008 - 08:03 AM

  Well these old module doesn't have lot of error checking so the best I can suggest is to add some to see if any error message is displayed.
  Open ProdReviews/pnuser.php.
  Just after the line:
  

  Code

  $result_pop = $dbconn->SelectLimit($popquery, 10);

  
  Add some error checking:
  

  Code

  if ($dbconn->ErrorNo() != 0) {
          echo '<p>DB Error : '.$dbconn->ErrorMsg().' query : '.$popquery.'</p>';
      }

  
  And just after the line:
  

  Code

  $result_rec = $dbconn->SelectLimit($recquery, 10);

  
  Add:
  

  Code

  if ($dbconn->ErrorNo() != 0) {
          echo '<p>DB Error : '.$dbconn->ErrorMsg().' query : '.$recquery.'</p>';
      }

  
  And report any error displayed.
  
  
  
  edited by: jmvedrine, Jan 21, 2008 - 09:04 PM
  
  --
  Visit my live reef aquarium.
  
  My Amazon wish list.

  • 
  •  
• lexscripta
  
  

  • Rank: Registered User
  • Registered: Jan 07, 2008
  • Last visit: Oct 21, 2009
  • Posts: 32

  Posted: Jan 24, 2008 - 11:06 AM

  It was installed with fantastico. Once I uninstalled, then re-installed it manually, setting up my own database and what have you, it worked. I had this same issue on two different hosts, and on the other one I simply backed up from the working server and uploaded, and it also worked.
  
  I think its something to do with automated installs.
  
  Thanks for your help on this - I will surely need this error checking at a later date.
  
  By the way, I was wondering - does prodreviews work with .8? I am thinking about going that direction because I need nice URLs...
  
  LexScripta

  • 
  •  
•  
•  

Users on-line

• michiel

This list is based on users active over the last 60 minutes.