Thread

Some of our commenters get the following error when posting:

A Database Error Occurred

Error Number: 1054

Unknown column 'Array' in 'field list'

UPDATE `exp_stats` SET `total_comments` = '251522', `last_comment_date` = Array WHERE `site_id` = '1'

Filename: libraries/Stats.php

Line Number: 508

the table exp_stats doesn’t actually have ANYTHING in it at the moment, so nothing is getting updated there at all. Comments do actually post, but it’s behavior that’s confusing a bunch of people.

This is a bog-standard EE install, there were no addons before the upgrade and there’s only a couple of anti-spam addons now.

Hi, Adrienne.

Let’s have you do a DESC exp_stats from the Tools > Data > SQL Manager > Database Query Form.

Do you have the same number of fields as I do?

Sue, Yeah, my table looks just like yours.

Hi, Adrienne. Did you turn off the stats module? Can you double check that it’s installed?

It is. I also fixed the issue by creating an entry in the exp_stats table for site 1 (just left everything else blank). After i did that, EE apparently figured out what it was supposed to be doing. 😊

Hmmm.. I’m going to resolve this for now.. but do re-open it if needed.