app/models/content.rb in typo-5.1.2 vs app/models/content.rb in typo-5.1.3
- old
+ new
@@ -100,10 +100,10 @@
find_published(what, options)
end
end
def find_by_published_at(column_name = :published_at)
- from_where = "FROM #{self.table_name} WHERE #{column_name} > 0 AND type='#{self.name}'"
+ from_where = "FROM #{self.table_name} WHERE #{column_name} is not NULL AND type='#{self.name}'"
# Implement adapter-specific groupings below, or allow us to fall through to the generic ruby-side grouping
if defined?(ActiveRecord::ConnectionAdapters::MysqlAdapter) && self.connection.is_a?(ActiveRecord::ConnectionAdapters::MysqlAdapter)
# MySQL uses date_format