• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

Change log?

#1
Where can i find changelog for version 1.1.0 ?

I want to know what changes have been made in db structure in 1.1.0 as compared to version 1.0.4?
 

Brogan

XenForo moderator
Staff member
#4
Here's a list of db schema differences from 1.0 to 1.1 Beta 4 (thanks to Mike for the script and instructions :))

This has been run in a 1.0 environment, comparing to 1.1; clipthea_xf10 is the name of the 1.0 database.

Code:
* Table xf_admin_log missing from DB clipthea_xf10.
* Table xf_admin_search_type missing from DB clipthea_xf10.
* Column xf_bb_code_media_site.addon_id missing from DB clipthea_xf10.xf_bb_code_media_site.
* Column xf_bb_code_media_site.embed_html_callback_class missing from DB clipthea_xf10.xf_bb_code_media_site.
* Column xf_bb_code_media_site.embed_html_callback_method missing from DB clipthea_xf10.xf_bb_code_media_site.
* Column xf_bb_code_media_site.match_callback_class missing from DB clipthea_xf10.xf_bb_code_media_site.
* Column xf_bb_code_media_site.match_callback_method missing from DB clipthea_xf10.xf_bb_code_media_site.
* Column xf_bb_code_media_site.match_is_regex missing from DB clipthea_xf10.xf_bb_code_media_site.
* Column xf_conversation_message.attach_count missing from DB clipthea_xf10.xf_conversation_message.
* Column xf_conversation_message.ip_id missing from DB clipthea_xf10.xf_conversation_message.
* Column xf_feed.prefix_id missing from DB clipthea_xf10.xf_feed.
* Column xf_forum.count_messages missing from DB clipthea_xf10.xf_forum.
* Column xf_forum.default_prefix_id missing from DB clipthea_xf10.xf_forum.
* Column xf_forum.find_new missing from DB clipthea_xf10.xf_forum.
* Column xf_forum.prefix_cache missing from DB clipthea_xf10.xf_forum.
* Table xf_forum_prefix missing from DB clipthea_xf10.
* Table xf_identity_service missing from DB clipthea_xf11.
* Column xf_language.text_direction missing from DB clipthea_xf10.xf_language.
* Table xf_moderator_log missing from DB clipthea_xf10.
* Column xf_node.display_in_list differs in COLUMN_KEY value ( vs MUL).
* Table xf_notice missing from DB clipthea_xf10.
* Table xf_notice_dismissed missing from DB clipthea_xf10.
* Column xf_post.user_id differs in COLUMN_KEY value ( vs MUL).
* Column xf_post.warning_id missing from DB clipthea_xf10.xf_post.
* Column xf_post.warning_message missing from DB clipthea_xf10.xf_post.
* Column xf_profile_post.user_id differs in COLUMN_KEY value ( vs MUL).
* Column xf_profile_post.warning_id missing from DB clipthea_xf10.xf_profile_post.
* Column xf_profile_post.warning_message missing from DB clipthea_xf10.xf_profile_post.
* Column xf_profile_post_comment.ip_id missing from DB clipthea_xf10.xf_profile_post_comment.
* Column xf_search.user_results missing from DB clipthea_xf10.xf_search.
* Column xf_smilie.sprite_mode missing from DB clipthea_xf10.xf_smilie.
* Column xf_smilie.sprite_params missing from DB clipthea_xf10.xf_smilie.
* Table xf_stats_daily missing from DB clipthea_xf10.
* Column xf_thread.prefix_id missing from DB clipthea_xf10.xf_thread.
* Table xf_thread_prefix missing from DB clipthea_xf10.
* Table xf_thread_prefix_group missing from DB clipthea_xf10.
* Column xf_trophy.criteria missing from DB clipthea_xf11.xf_trophy.
* Column xf_trophy.user_criteria missing from DB clipthea_xf10.xf_trophy.
* Column xf_user.warning_points missing from DB clipthea_xf10.xf_user.
* Table xf_user_field missing from DB clipthea_xf10.
* Table xf_user_field_value missing from DB clipthea_xf10.
* Table xf_user_group_promotion missing from DB clipthea_xf10.
* Table xf_user_group_promotion_log missing from DB clipthea_xf10.
* Table xf_user_identity missing from DB clipthea_xf11.
* Table xf_user_ignored missing from DB clipthea_xf10.
* Column xf_user_profile.custom_fields missing from DB clipthea_xf10.xf_user_profile.
* Column xf_user_profile.identities missing from DB clipthea_xf11.xf_user_profile.
* Column xf_user_profile.ignored missing from DB clipthea_xf10.xf_user_profile.
 * Table xf_warning missing from DB clipthea_xf10.
* Table xf_warning_action missing from DB clipthea_xf10.
* Table xf_warning_action_trigger missing from DB clipthea_xf10.
* Table xf_warning_definition missing from DB clipthea_xf10.
 
R

ragtek

Guest
#6
Use a database compare tool (e.g. phpstorm have one)
dbcomparingtool.PNG
or compare XenForo_Install_Data_MySql from the newest build with the previous
OR

last but not least=> check the upgrade scripts (IMO most comfortable ;) if you need only the xf data without any add-ons)
 
#7
Well thats a good plan.

I will sure try that. Because the data provided by Brogan is incomplete(it is one sided).
 

Robbo

Well-known member
#10
I highly recommend SQLyog. If you work on a daily basis with databases then it will save you a lot of time.

I also highly recommend PhpStorm. So do what ragtek said as well. Tried a lot of things and these 2 programs make me a lot more efficient.