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

XF 1.2 Error when trying to require prefix

Discussion in 'Troubleshooting and Problems' started by onthefly, Nov 3, 2013.

  1. onthefly

    onthefly Active Member

    prefixes.png
    Anyone come across this?
     
  2. Andrej

    Andrej Well-Known Member

  3. onthefly

    onthefly Active Member

  4. Brogan

    Brogan XenForo Moderator Staff Member

    Andrej likes this.
  5. onthefly

    onthefly Active Member

  6. onthefly

    onthefly Active Member

    Last edited: Nov 4, 2013
  7. Jeremy

    Jeremy XenForo Moderator Staff Member

    Remove the 3rd line of that query.
     
  8. Brogan

    Brogan XenForo Moderator Staff Member

    Can you run this query and post the output?
    Code:
    select *
    from INFORMATION_SCHEMA.COLUMNS
    where TABLE_NAME='xf_forum'
     
  9. onthefly

    onthefly Active Member

    after doing that, I tried to adjust the prefixes and got this,
    prefixes2.png
     
  10. onthefly

    onthefly Active Member

    mysql2.png
     
  11. onthefly

    onthefly Active Member

    Tried that too, same error.... :(
     
  12. Brogan

    Brogan XenForo Moderator Staff Member

    That screenshot doesn't show the complete table structure.
     
  13. onthefly

    onthefly Active Member

    was sure what you wanted, not up on all the lingo, might have to dumb it down alot......
    mysql3.png
     
  14. onthefly

    onthefly Active Member

    Is that what you mean?
     
  15. Brogan

    Brogan XenForo Moderator Staff Member

    That's still not the entire table but from what I can see, those four columns related to that add-on now look OK.

    What happens now when you try to require a prefix.
     
  16. onthefly

    onthefly Active Member

  17. onthefly

    onthefly Active Member

    So now what?
     
  18. onthefly

    onthefly Active Member

    Whatever it is you think I should be seeing/getting I dont. Im not seeing what I dont understand! I see those you are refering to but thats it do I delete them ? If so, How?
     
  19. Mike

    Mike XenForo Developer Staff Member

    Run this:
    Code:
    ALTER TABLE xf_forum ADD require_prefix TINYINT UNSIGNED NOT NULL DEFAULT '0';
    Presumably when you uninstalled the add-on, it re-removed the column (hence the importance of prefixing tables/columns).
     
    onthefly likes this.
  20. onthefly

    onthefly Active Member

    I think that did it, no more error when I require prefix, Thanks for your help Mike and everyone else that chipped in, cheers.
     

Share This Page