Zikula Community

• teniemi
  
  

  • Rank: Registered User
  • Registered: Jun 03, 2004
  • Last visit: Feb 25, 2010
  • Posts: 22

  Posted: Feb 25, 2010 - 09:06 PM

  Hi!
  
  I'm using Reviews 2.3 on my site. On the modules start page it displays most popular and most recent reviews. However, most recent reviews are actually the oldest ones. Not the newest ones. How can this be fixed?

  • 
  •  
• slam
  
  

  • Rank: Team Member
  • Registered: May 03, 2004
  • Last visit: May 31, 2010
  • Posts: 511

  Posted: Feb 26, 2010 - 05:26 AM

  Bug confirmed.
  Greetings,
  Chris
  
  --
  an operating system must operate
  development is life
  my repo

  • 
  •  
• daddysupa
  
  

  • Rank: Softmore
  • Registered: Dec 23, 2003
  • Last visit: May 05, 2010
  • Posts: 351

  Posted: Mar 11, 2010 - 12:46 PM

  This looks pretty nasty. The problem appears to be in the upgrade script that get's rid of pn_date and creates a column pn_cr_date
  
  Look in pninit.php file:
  
  

  Code

  case '2.2':
              // Move the creation date
              $table = DBUtil::getLimitedTablename('reviews');
              $sql   = "UPDATE $table SET pn_cr_date = pn_date";
              DBUtil::dropColumn('reviews', array('pn_date'));

  
  
  In my DB that essentially zapped my pn_date column and left all pn_cr_date entries the same: 1970-01-01 00:00:00
  
  I am wondering if simply restoring the table and renaming the pn_date will work.
  
  This is not very good.
  
  supa
  
  --
  
  Caribbean News
  Online Shopping from USA, Canada, UK, France, Germany
  On Facebook

  • 
  •  
• craigh
  
  

  • Rank: Developer
  • Registered: Jun 16, 2003
  • Last visit: May 29, 2010
  • Posts: 1966

  Posted: Mar 11, 2010 - 12:53 PM

  I have never used review, but I'll guess that someone was converting it to categories. Categories has that pn_cr_date col. My guess is the col isn't yet created when that SQL is run and thus it doesn't actually move the data.

  • 
  •  
• daddysupa
  
  

  • Rank: Softmore
  • Registered: Dec 23, 2003
  • Last visit: May 05, 2010
  • Posts: 351

  Posted: Mar 12, 2010 - 09:13 AM

  Any idea how it can be fixed? I have the old backup before 2.2 which has the right pn_date....Guess i can edit the DB directly and get past this.
  
  supa
  
  --
  
  Caribbean News
  Online Shopping from USA, Canada, UK, France, Germany
  On Facebook

  • 
  •  
•  
•  

Users on-line

• eledril

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