• 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

Brogan

XenForo moderator
Staff member
#8
Can you run this query and post the output?
Code:
select *
from INFORMATION_SCHEMA.COLUMNS
where TABLE_NAME='xf_forum'
 

Brogan

XenForo moderator
Staff member
#15
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.
 

onthefly

Active member
#16

onthefly

Active member
#18
That's still not the entire table but from what I can see, those four columns related to that add-on now look OK.
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?
 

Mike

XenForo developer
Staff member
#19
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

Active member
#20
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).
I think that did it, no more error when I require prefix, Thanks for your help Mike and everyone else that chipped in, cheers.