ExpressionEngine® Answers is a question and answer site for administrators, end users, developers and designers for ExpressionEngine® CMS. It only takes a minute to sign up.
Sign up to join this community
I've been getting errors related to the exp_security_hashes table and it's always this statement:
Unknown column 'ip_address' in 'where clause'
Normally I would be looking at the add-on but this same issue/error has happened while using different add-ons.
Can I create the ip_address column in the exp_security_hashes?
The 2.5.4 release changed the exp_security_hashes table structure. Any addons that were attempting to manually create an XID hash (EE uses them for secure form processing) are likely to have been caught out by this.
In your case it looks as though the Rating module is the culprit. It doesn't look as though Solspace have released a patch yet so you'd need to request one in case they're not already aware of the problem.
This will probably affect quite a few addons, so that would explain why you're seeing errors relating to more than just the Ratings module.
[If you're using Missing Link I posted a fix for this yesterday.]
It looks like some sort of upgrade process didn't complete all the way. Did you run the updater and ever get an error during the process?
What you could do is do a full new local install, look at the local table in phpmyadmin, find the format and length etc of the field, then add it to the remote version that is looking for it.
I don't know if this will keep the error from happening, you just might push it on to a different error, but it could work as well. In the end if it doesn't work, you could always remove the field again.
** Although saying all of that, isn't the addon builder part of some of solspace's offering - At least some older versions?
