| Debug Message - Perch 3.1.6 |
| [25] SELECT DISTINCT settingID, settingValue FROM perch2_settings WHERE userID=0 |
| [1] SELECT * FROM perch2_pages WHERE pagePath='/news.php' LIMIT 1 |
| Using template: /templates/pages/attributes/seo.html |
| [9] SELECT regionKey, regionHTML FROM perch2_content_regions
WHERE regionPage='/news.php' OR regionPage='*' ORDER BY regionPage DESC |
| Fetching from cache: perch_blog_date_archive_months47f0230bc83963524100659d171b9345 |
| [6] SELECT year(postDateTime) as year, COUNT(*) AS year_qty
FROM perch2_blog_posts
WHERE postStatus='Published'
AND postDateTime<='2020-10-25 07:11:00' GROUP BY year
ORDER BY year DESC |
| Using template: /templates/blog/months_month_link_news.html |
| [7] SELECT DISTINCT
year(postDateTime) AS year,
month(postDateTime) AS month,
CONCAT(year(postDateTime),"-",month(postDateTime),"-01") AS grouped_date,
COUNT(*) AS month_qty
FROM perch2_blog_posts p
WHERE year(postDateTime) = '2020'
AND p.postStatus='Published'
AND p.postDateTime<='2020-10-25 07:11:00' GROUP BY year, month, grouped_date
ORDER BY month DESC |
| [12] SELECT DISTINCT
year(postDateTime) AS year,
month(postDateTime) AS month,
CONCAT(year(postDateTime),"-",month(postDateTime),"-01") AS grouped_date,
COUNT(*) AS month_qty
FROM perch2_blog_posts p
WHERE year(postDateTime) = '2019'
AND p.postStatus='Published'
AND p.postDateTime<='2020-10-25 07:11:00' GROUP BY year, month, grouped_date
ORDER BY month DESC |
| [12] SELECT DISTINCT
year(postDateTime) AS year,
month(postDateTime) AS month,
CONCAT(year(postDateTime),"-",month(postDateTime),"-01") AS grouped_date,
COUNT(*) AS month_qty
FROM perch2_blog_posts p
WHERE year(postDateTime) = '2018'
AND p.postStatus='Published'
AND p.postDateTime<='2020-10-25 07:11:00' GROUP BY year, month, grouped_date
ORDER BY month DESC |
| [12] SELECT DISTINCT
year(postDateTime) AS year,
month(postDateTime) AS month,
CONCAT(year(postDateTime),"-",month(postDateTime),"-01") AS grouped_date,
COUNT(*) AS month_qty
FROM perch2_blog_posts p
WHERE year(postDateTime) = '2017'
AND p.postStatus='Published'
AND p.postDateTime<='2020-10-25 07:11:00' GROUP BY year, month, grouped_date
ORDER BY month DESC |
| [12] SELECT DISTINCT
year(postDateTime) AS year,
month(postDateTime) AS month,
CONCAT(year(postDateTime),"-",month(postDateTime),"-01") AS grouped_date,
COUNT(*) AS month_qty
FROM perch2_blog_posts p
WHERE year(postDateTime) = '2016'
AND p.postStatus='Published'
AND p.postDateTime<='2020-10-25 07:11:00' GROUP BY year, month, grouped_date
ORDER BY month DESC |
| [11] SELECT DISTINCT
year(postDateTime) AS year,
month(postDateTime) AS month,
CONCAT(year(postDateTime),"-",month(postDateTime),"-01") AS grouped_date,
COUNT(*) AS month_qty
FROM perch2_blog_posts p
WHERE year(postDateTime) = '2015'
AND p.postStatus='Published'
AND p.postDateTime<='2020-10-25 07:11:00' GROUP BY year, month, grouped_date
ORDER BY month DESC |
| [6] Using template: /templates/blog/months_year_link_news.html |
| Caching: perch_blog_date_archive_months47f0230bc83963524100659d171b9345 |
| [10] SELECT SQL_CALC_FOUND_ROWS DISTINCT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM perch2_blog_index idx
JOIN perch2_blog_posts main ON idx.itemID=main.postID AND idx.itemKey='postID'
JOIN perch2_blog_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='postID' AND idx2.indexKey='postDateTime' WHERE 1=1 AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, postID ) as tbl WHERE (postStatus='Published' AND postDateTime<='2020-10-25 07:11:00' ) GROUP BY itemID, sortval ORDER BY sortval DESC LIMIT 0, 10 |
| [1] SELECT FOUND_ROWS() AS `count` |
| [10] Using template: /templates/blog/news_article_list.html |
| [1] SELECT *
FROM perch2_blog_sections ORDER BY sectionTitle ASC |
| [1] SELECT *
FROM perch2_blogs ORDER BY blogTitle ASC |
| Using template: /templates/forms/contact_footer.html |
| [2] SELECT SQL_CALC_FOUND_ROWS DISTINCT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM perch2_blog_index idx
JOIN perch2_blog_posts main ON idx.itemID=main.postID AND idx.itemKey='postID'
JOIN perch2_blog_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='postID' AND idx2.indexKey='postDateTime' WHERE 1=1 AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, postID ) as tbl WHERE (postStatus='Published' AND postDateTime<='2020-10-25 07:11:00' ) GROUP BY itemID, sortval ORDER BY sortval DESC LIMIT 0, 2 |
| [1] SELECT FOUND_ROWS() AS `count` |
| [2] Using template: /templates/blog/news_article_list_footer.html |
Array
(
[type] => 8
[message] => Undefined variable: year
[file] => /home/haystackdryers/public_html/news.php
[line] => 20
)
|
