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

XF 1.1 Upgrade failing

Discussion in 'Installation, Upgrade, and Import Support' started by John, Mar 26, 2013.

  1. John

    John Well-Known Member

    I'm upgrading my localhost install which is running 1.1.3 and the upgrade is failing with this error message:

    Thanks for any pointers. :)
     
  2. Chris D

    Chris D XenForo Developer Staff Member

    That's a pretty odd error...

    You could try setting a default value... let me try and find the table.
     
  3. Brogan

    Brogan XenForo Moderator Staff Member

    Can you check your xf_style_property_group table and check there is a value in property_group_id for all records?
     
    Chris D likes this.
  4. Digital Doctor

    Digital Doctor Well-Known Member

  5. John

    John Well-Known Member

    Yes, see screen grab:

    Screen Shot 2013-03-26 at 6.39.20 PM.png
     
  6. Dodgeboard

    Dodgeboard Well-Known Member

    Host upgraded SQL.
     
  7. Brogan

    Brogan XenForo Moderator Staff Member

    It's localhost.
     
  8. Dodgeboard

    Dodgeboard Well-Known Member

    Then you probably wont get it when you upgrade your live site. Go for it! :D
     
  9. Chris D

    Chris D XenForo Developer Staff Member

    I think there might be more records there than is being shown...

    If Brogan is on the right track - and I have no idea what else it could be - then this query might reveal a record without a group_id number:

    Code:
    SELECT * FROM xf_style_property_group WHERE property_group_id = NULL
    Or

    Code:
    SELECT * FROM xf_style_property_group WHERE property_group_id = ''
    Or

    Code:
    SELECT * FROM xf_style_property_group WHERE property_group_id = 0
     
    Adam Howard and Brogan like this.
  10. Biker

    Biker Well-Known Member

    John uses his localhost to develop and update themes. He MUST get this fixed as I'm waiting for updates. :D
     
    Dodgeboard and John like this.
  11. Brogan

    Brogan XenForo Moderator Staff Member

    That's all I can think of really.

    Where's Mike?
    MIKE?
    MIIIIIKE?
     
    Chris D likes this.
  12. John

    John Well-Known Member

    Thanks Chris and Paul, I'll do some more digging. All else fails, I'll wipe the DB and do a clean install...it was just phantom data from an old install that I used simply for convenience.
     
  13. Brogan

    Brogan XenForo Moderator Staff Member

    Do a sort on the table by property_group_id - just click the column header.
     
    John and Chris D like this.
  14. Chris D

    Chris D XenForo Developer Staff Member

    That's slightly easier... hehe :oops:
     
    Brogan likes this.
  15. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    This error would seem to indicate that xf_style_property_group.property_group_id is missing the AUTO_INCREMENT attribute. Did you recently perform any db maintenance such as restoring a backup or changing servers? Corruption may have occurred during such maintenance. If you can revert or reinstall that should fix it.

    Or you can try running this query to restore the primary key:

    Code:
    ALTER TABLE xf_style_property_group CHANGE property_group_id property_group_id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY;
    
    Otherwise I can take a look if you give me access.
     
    Walter likes this.
  16. Mike

    Mike XenForo Developer Staff Member

    Jake's analysis is the only way I can see this happening.
     

Share This Page