XF 1.2 Unknown column 'user.is_staff' in 'where clause'

Chris D

XenForo developer
Staff member
How peculiar... Because according to your list of add-ons in the other thread, you DO have WDB Extra Stats installed. I presumed (wrongly) that the library/ExtraStats files belonged to that.
 

Mike

XenForo developer
Staff member
Is it still on the to-do list for a fix?
I would expect any upgrade making table changes, would first test for the changes already existing before making the change and causing an SQL stop and impacting the remainder of its SQL. But I can see how this can be considered an add-ons cause for not prefixing it's DB changes, but hoping it doesn't result in finger pointing and no action :)
It's still something to be considered. It, however, creates the opposite problem: the upgrade completes as expected and you then remove the add-on (as in many cases, the conflicts come from add-ons that provide functionality similar to core features). That add-on cleans up its schema changes (as it should) and now you're missing the fields in question. That said, that's something that can theoretically happen right now as well.

The other potential issue (and yes, this can happen now as well in situations) is when add-ons add tables/fields with the same name but store different content/values.

The whole thing can consistently be avoided by add-ons prefixing their schema changes.
 

Mouth

Well-known member
How peculiar... Because according to your list of add-ons in the other thread, you DO have WDB Extra Stats installed. I presumed (wrongly) that the library/ExtraStats files belonged to that.
I've looked closer, and it's an add-on called "User Statistics", with an id of ExtraStats, and version 0.9.1 I've searched threads and resources, but cannot narrow down an add-on by this name. It's disabled on my production server, so I'll uninstall it and check if it removes it's added index to xf_user, so that I don't have the same issue when upgrading production to 1.2

Thanks.
 

Mouth

Well-known member
For reference of anyone else that finds this thread with the same/similar issue, un-install of the "User Statistics" ( ExtraStats ) add-on didn't remove it's db schema changes. I ran " drop index register_date on xf_user;" on my XF 1.1 database to fix the issue, so that my 1.2 upgrade won't fail.
 
Top