Thread

When deleting a member I get the following error in EE v2.5.2 (Build Date: 20120606):

A Database Error Occurred
Error Number: 1054

Unknown column 'channel_id' in 'field list'

SELECT DISTINCT(entry_id), `channel_id` FROM (`exp_comments`) WHERE `author_id` IN ('17')

Filename: models/member_model.php

Line Number: 687

The comments module is not installed.
Despite the error the member is successfully deleted. I remember several issues related to the comments module in the bug tracker (see https://support.ellislab.com/bugs/detail/17781 and https://support.ellislab.com/bugs/detail/17380 ) but their status is “fixed”.

Is there a solution to fix this without having to install the comments module?

Cheers,

Koen

Hey StudioKong,

I am sorry to hear you are running into this problem.

I am unable to reproduce this. I do not have comments installed and I removed a member without an error.

Can you tell me a little about what Add-Ons you have installed? Any accessories?

Please let me know!

Cheers,

Hi Shane,

I am only using Simple Registration to register new members (http://www.addonbakery.com/docs/expressionengine/Simple_Registration_for_ExpressionEngine.html).
The site was upgraded from EE1 and there is an empty comments table in my database. I’ll have a closer look to see if I can narrow down the issue.

Kind regards,

Koen

Hey StudioKong,

That sounds good. Please do keep me posted.

Cheers,

Hi Shane,

Appearantly the exp_comments table should not me present in my database when the comments module is not installed. Can you confirm this? If so, something has gone wrong during the update process I guess. I can reproduce the error on a clean install of EE v2.5.2 (comments module not enabled) when I manually create a exp_comments table.

Can I safely resolve the issue by installing and uninstalling the comments module in succession to remove the comments table or by deleting it manually?

Kind regards,

Koen

Hello Koen,

I agree, it sounds like the update process did not go smoothly.

You should be able to resolve this by removing the comments table.

Cheers,