XF 1.5 xf_user_option Database

[MagicalMidge]

Again...

I am sorry to keep asking you questions about the database that you would prefer users to not delve into too much, however I dont necessarily need your instruction, I just need to understand why or how a certain field is being created in the xf_user_option table.

In one of my local test versions of xenforo I have these fields;

user_id int(10) UN PK
show_dob_year tinyint(3) UN
show_dob_date tinyint(3) UN
content_show_signature tinyint(3) UN
receive_admin_email tinyint(3) UN
email_on_conversation tinyint(3) UN
is_discouraged tinyint(3) UN
default_watch_state enum('','watch_no_email','watch_email')                                                   
alert_optout text
enable_rte tinyint(3) UN
enable_flash_uploader tinyint(3) UN
use_tfa tinyint(3) UN
custom_messages

However, in another instance...

user_id int(10) UN PK
show_dob_year tinyint(3) UN
show_dob_date tinyint(3) UN
content_show_signature tinyint(3) UN
receive_admin_email tinyint(3) UN
email_on_conversation tinyint(3) UN
is_discouraged tinyint(3) UN
default_watch_state enum('','watch_no_email','watch_email')                                                   
alert_optout text
enable_rte tinyint(3) UN
enable_flash_uploader tinyint(3) UN
use_tfa tinyint(3) UN

I dont have the "custom_messages" field, how, why or when is this created?

 

[Liam W]

It's almost certainly from an addon. If the addon was uninstalled, it should've reversed the database changes, but it is up to the developer to implement that.

 

[MagicalMidge]

It's almost certainly from an addon. If the addon was uninstalled, it should've reversed the database changes, but it is up to the developer to implement that.

So you've never seen that column before, and dont believe its needed?

I had installed one or two addons on the instance that it's appearing on, swiftly removed them and forgot what theyre called... which is handy...