Thread

Hi,

I upgrade an EE installation from 1.7.3 to 2.5.3 today. The site is part of MSM setup which I have upgraded. The old system had Matrix and FreeForm installed on it. After completing the entire upgrade process for the system, MSM, and those addons I’m getting the following error when try to view either of the 2 sites in the MSM install:

Error Number: 1054

Unknown column ‘wd.field_id_8NOT’ in ‘where clause’

SELECT t.entry_id FROM exp_channel_titles AS t LEFT JOIN exp_channels ON t.channel_id = exp_channels.channel_id LEFT JOIN exp_channel_data AS wd ON t.entry_id = wd.entry_id LEFT JOIN exp_members AS m ON m.member_id = t.author_id WHERE t.entry_id !=’’ AND t.site_id IN (‘1’) AND t.entry_date < 1349390593 AND (t.expiration_date = 0 OR t.expiration_date > 1349390593) AND t.status = ‘open’ AND ( (wd.site_id=1 AND wd.field_id_4 LIKE “%Yes%”) )AND ( (wd.site_id=1 AND wd.field_id_8NOT LIKE “%Yes%”) )ORDER BY t.sticky desc, wd.field_id_7 asc, t.entry_id asc LIMIT 0, 100

Filename: modules/channel/mod.channel.php

Line Number: 2736

The CP seems to be working fine though. How would I fix this?

Thanks,

Josh

After looking into the issue again I discovered this was already documented in a bug that’s already taken care (of pending next release) at https://support.ellislab.com/bugs/detail/18228

To fix the issue for now I changed “not” in my search parameters to “=not” as mentioned in http://ellislab.com/forums/viewthread/224217/

Thanks

Josh

Hi Josh,

Thanks for reporting back and I’m glad you found a solution!

If you need anything else, please let us know!

Cheers,