phplist

NOTE:: Before reporting an issue, make sure you are running the latest version, currently 3.3.1


View Issue Details Jump to Notes ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0016815phplist applicationConfigurationpublic20-06-13 09:0320-06-13 17:21
Reporterduncanc 
PrioritynormalSeverityminorReproducibilityalways
StatusresolvedResolutionfixed 
PlatformOSOS Version
Product Version2.11.10 
Target Version2.11.11Fixed in Version2.11.11 
Summary0016815: The check for a new version is always performed
DescriptionUsing XDEBUG to profile the home page, I found that the check for a new version is always being performed.

The problem is the query:

  $query
  = ' select cast(value as date) + \'%d days\' < current_timestamp as needscheck'
  . ' from %s'
  . ' where item = ?';

The user of '+' to add 7 days gives a string of the format yyyymmdd instead of yyyy-mm-dd, so the comparison seems to always return true.

This revised query works:

  $query
  = ' select date_add(value, interval %d day) < current_timestamp as needscheck'
  . ' from %s'
  . ' where item = ?';
TagsNo tags attached.
Attached Files

- Relationships

-  Notes
There are no notes attached to this issue.


Copyright © 2000 - 2017 MantisBT Team
Powered by Mantis Bugtracker