Deleting Communities - SQL error

[Kent]

BigAce version: 2.7 (downloaded and installed 2010-01-03). installed in public_html/bigace

• I added a community: behrends.me, with alias n6roq.us.
• As add-on domains, I set their document directories to public_html/bigace
• I added an admin user for the new community.

When I access http://behrends.me from firefox v3.5.5, the pages appear to come up - but without any styles.

So I tried to delete the community to start again. I receive the following error when using: Community->Remove

Code:

Problems executing SQL statement: DELETE FROM cms_statistics_history WHERE cid='3'

Problems when performing SQLs from file: /home/behrcons/public_html/bigace/consumer/cid3/uninstall/delete_data_cid.sql

The Community Data was successfully removed from the Filesystem.

Community and Alias entries were not removed, because of previous errors.

From System->Logging:

Code:

Table does not exist (1146: Table 'behrcons_bigace.cms_statistics_history' doesn't exist) for [ DELETE FROM cms_statistics_history WHERE cid='3']

Any other information I can provide?

[Kevin]

Hi!

Thanks for the feedback, I can verify that.

I removed that table with 2.7 and forgot to remove the delete statement.

The missing styles are normally a problem, when yuo define a wrong base path for the community.

Could you fix it by now?

Regards
Kevin

[Kent]

I edited the consumer.ini file and manually removed the community references. I was then able to re-create the community.

[Kevin]

Good to hear. Let me know when you need further help