Thread

Trying to Delete a site:

A Database Error Occurred
Error Number: 1054

Unknown column 'site_id' in 'where clause'

DELETE FROM `exp_file_dimensions` WHERE `site_id` = '2'

Filename: controllers/cp/sites.php

Line Number: 2077

Hi AirWatch,

Looks like the first issue you’re facing is fixed in the upcoming release of EE.

Regarding the second issue, could you run an SQL for me and post the results back here? Go to Tools > Data > SQL Manager, and click on Database Query Form. Then run this query:

DESCRIBE exp_file_dimensions`;

And paste the results back here! (You can take a screenshot of the results if you like.)

Attached file. Thanks!

Also, just before you replied I removed part one of my post since I wanted to keep this focused on the deleting part of the issue.. sorry about that.

Hi AirWatch,

What version of ExpressionEngine and MSM are you using?

Cheers,

EE 2.5.2 and MSM 2.1.3

Yep, definitely a field missing from your database that should be there.

When you were updating from a previous version, do you recall experiencing any errors during the update?

Be on the lookout for an email from me. I want to get a first-hand look at your database to check it’s integrity.

Just posting a note here to let onlookers know that we’re working with AirWatch privately on this for the time being. I’ll post an update back here once we have something to share!