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

Change log?

Discussion in 'General XenForo Discussion and Feedback' started by Samar, Nov 4, 2011.

  1. Samar

    Samar Member

    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?
     
  2. Alluidh

    Alluidh Well-Known Member

    Until now there is no changelog for version 1.1.0
     
  3. Samar

    Samar Member

    Then is it possible for someone to tell me whats the difference in the database structure in both versions?
     
  4. Brogan

    Brogan XenForo Moderator Staff Member

    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.
     
  5. Samar

    Samar Member

    Oh great!

    Thanks for the info :)
     
  6. ragtek

    ragtek Guest

    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. Samar

    Samar Member

    Well thats a good plan.

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

    Brogan XenForo Moderator Staff Member

    Is it?

    Table xf_forum_prefix missing from DB clipthea_xf10.
    Table xf_identity_service missing from DB clipthea_xf11.
     
  9. Samar

    Samar Member

    Lol

    I didn`t saw that :p
     
  10. Robbo

    Robbo Well-Known Member

    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.
     

Share This Page