Project

General

Profile

Bug #2461

My Articles page doesn't work

Added by Andrew Gorshechnikov over 2 years ago. Updated about 2 years ago.

Status:
Resolved
Priority:
Normal
Assignee:
-
Target version:
Start date:
July 18, 2016
Due date:
% Done:

100%

Estimated time:

Description

My articles page (../profile/articles/) doesn't work as it has incorrect SQL query:

User Warning: Unknown column 't4.date' in 'field list' SELECT SQL_CALC_FOUND_ROWS t1.*, t2.`title` `category_title`, t2.`title_alias` `category_alias`, t2.`parent_id` `category_parent`, t2.`parents` `category_parents`, t2.`locked` `category_locked`, t3.`username` `account_username`, IF('' != t3.`fullname`, t3.`fullname`, t3.`username`) `account_fullname`, SUBSTRING(GROUP_CONCAT(t4.`sec_key` ORDER BY t4.`date`) FROM -14) `transaction_id`FROM sbr405_articles t1 LEFT JOIN `sbr405_articles_categories` t2 ON (t1.`category_id` = t2.`id`) LEFT JOIN `sbr405_members` t3 ON (t1.`member_id` = t3.`id`) LEFT JOIN `sbr405_payment_transactions` t4 ON (t4.`status` = 'pending' AND t4.`member_id` = t1.`member_id` AND t4.`item` = 'articles' AND t4.`item_id` = t1.`id`) WHERE t2.`status` = 'active' AND t1.`member_id` = 1 GROUP BY t1.`id` ORDER BY t1. `date_added` asc LIMIT 0, 10 

date should be replaced with date_added field in this query.

History

#1

Updated by Daiyrbek Artelov about 2 years ago

  • Status changed from New to Resolved
  • % Done changed from 0 to 100

Fixed in 2ef68141

Also available in: Atom PDF