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

XF 1.4 Mysql error when upgrading to 1.4.2 from 1.3.4

Discussion in 'Installation, Upgrade, and Import Support' started by rah350z, Nov 9, 2014.

  1. rah350z

    rah350z Member

    Getting this error when upgrading. I've tried to redownload the 1.4.2 upgrade package like 3 times and also re-uploading and overwriting the files several times.
    I've also tried putting this
    Code:
    $config['checkVersion'] = false;
    into the config.php to be able to get into control panel and disable all addons, but still not working. Any help would be much appreciated.

    This is the list of addons i have.

    Advanced Application Forms 1.1.6
    Display Staff Members 1.1.2
    Donation Manager 1.2.0
    Force Thread Read 1.0
    Nodes As Tabs 1.2.2
    Reset Password From ACP 1.0
    Steam Auth 1.4.4
    TaigaChat Pro 1.3.0
    Tapatalk 2.3.3
    [h] ShowMods 1.1b
    [RT] User Rank Ribbons (15) 2.3.5
     
  2. rainmotorsports

    rainmotorsports Well-Known Member

    Well the question is if xf_user_title_ladder exists or not. You would need to look in the database through a tool such as phpMyAdmin. If not it will need to be recreated. But is saying it doesn't exist I am willing to be it doesn't.

    I hope you also have a database backup from just before this upgrade. The contents of that table shouldn't be important and just running the query to recreate it should suffice if its the only one.
     
  3. rainmotorsports

    rainmotorsports Well-Known Member

    If the table is missing running this SQL should recreate it:
    Code:
    CREATE TABLE `xf_user_title_ladder` (
    `minimum_level` int(10) unsigned NOT NULL,
    `title` varchar(250) NOT NULL,
    PRIMARY KEY (`minimum_level`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8
    If other tables are missing I would refer to a backup first.
     
  4. rah350z

    rah350z Member

    I don't see xf_user_title ladder in phpmyadmin or in any previous backups of my db in the past 3 days. Do you think just manually adding that table will fix it?
     
  5. rainmotorsports

    rainmotorsports Well-Known Member

    If that is the only missing table then yes that should take care of it. Select the database and click on the SQL tab and run the above.
     
  6. rah350z

    rah350z Member

    Everything seems to be going through now. Will update once it's finished.
     
  7. rah350z

    rah350z Member

    After a few moments i've reached the end of it and get this.
     
  8. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    The "xf_user_title_ladder" table is created during the upgrade to 1.4. After uploading the files you visit /install to run the upgrade which will create that table.

    If for some reason that step was missed then you can run these queries to manually create that table:

    Code:
    RENAME TABLE xf_trophy_user_title TO xf_user_title_ladder;
    
    ALTER TABLE xf_user_title_ladder CHANGE minimum_points minimum_level INT UNSIGNED NOT NULL;
    
    These queries come from the upgrade script.

    Though this manual fix might not completely repair what might be a bad upgrade. If you continue to have problems then it might be a good idea to submit a ticket so we can more closely examine your database:

    https://xenforo.com/customers/
     
    rainmotorsports likes this.
  9. rainmotorsports

    rainmotorsports Well-Known Member

    Thanks Jake for coming in with that. But yeah it looks like he is having more problems than that.

    I would revert to the backup and try again. Submit a ticket if it doesn't go again. Thats depending on if you want to try from the backup.
     
  10. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    Yep, the schema changes from the upgrade are not being applied for some reason.

    If you have a backup then I suggest restoring it and dealing with your addons before upgrading again.
     
  11. rah350z

    rah350z Member

    What exactly should I be doing with my addons?
     
  12. rainmotorsports

    rainmotorsports Well-Known Member

    You could do a disable listeners in the config.
     
  13. rah350z

    rah350z Member

    How can I do a rerun of the upgrade script so that it can try to do the schema changes again?
     
  14. rah350z

    rah350z Member

    I've managed to fix it. Thanks for the help. Found the sql changes that were supposed to be ran in library/XenForo/Install folders and manually ran them in phpmyadmin. Did a rebuild master data after that and everything seems to be working perfectly.
     

Share This Page