Accessory, Module

Community
Support

DevDemon does not actively monitor this forum
(but you can still get help from other EE users).

For official support, visit the official support site »

EE 1
EE 2
Hits

Back to this add-on's main page
View Other Add-ons From DevDemon

Hits  >  Thread
     

You must be logged in to post.

Database Error

Bug Report

Andrew L Philpott
Posted: 10 January 2012 12:21 PM
Andrew L Philpott

When I log into a site that has been using Hits for the past few months, I’m getting the following Database Error:

Error Number: 1054

Unknown column 'hs.d_9' in 'field list'

SELECT `ct`.`title`, `hs`.`entry_id`, hs.d_9 AS hits FROM (`exp_hits_stats` hs) LEFT JOIN `exp_channel_titles` ct ON `hs`.`entry_id` = `ct`.`entry_id` WHERE `hs`.`type` = 1 AND `hs`.`year` = '2012' ORDER BY `hs`.`d_9` DESC LIMIT 10

Filename: third_party/hits/acc.hits.php

Line Number: 124 

Nothing has changed apart from new entries that were created by my client, so I’m not sure what would have caused this problem.
 
Andrew L Philpott
Posted: 10 January 2012 12:33 PM # 1
Andrew L Philpott

Nevermind. Found the solution here: http://www.devdemon.com/forums/viewthread/1471/.