XF 1.2 Error when trying to require prefix

[onthefly]

Anyone come across this?

 

[Andrej]

Error trying to save require prefixes

 

[onthefly]

Error trying to save require prefixes

Saw it, did you notice the date of the last reply ??

 

[Paul B]

My resource explains how to resolve it: http://xenforo.com/community/resources/how-to-upgrade-to-1-2.2397/

 

[onthefly]

My resource explains how to resolve it: http://xenforo.com/community/resources/how-to-upgrade-to-1-2.2397/

Hey Brogan, I have done everything in the thread.....

 

[onthefly]

My resource explains how to resolve it: http://xenforo.com/community/resources/how-to-upgrade-to-1-2.2397/

I also get this error when running one of the commands...

 

[Jeremy]

Remove the 3rd line of that query.

 

[Paul B]

Can you run this query and post the output?

select *
from INFORMATION_SCHEMA.COLUMNS
where TABLE_NAME='xf_forum'

 

[onthefly]

Can you run this query and post the output?

select *
from INFORMATION_SCHEMA.COLUMNS
where TABLE_NAME='xf_forum'

after doing that, I tried to adjust the prefixes and got this,

 

[onthefly]

Can you run this query and post the output?

select *
from INFORMATION_SCHEMA.COLUMNS
where TABLE_NAME='xf_forum'

 

[onthefly]

Remove the 3rd line of that query.

Tried that too, same error....

 

[Paul B]

That screenshot doesn't show the complete table structure.

 

[onthefly]

That screenshot doesn't show the complete table structure.

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

 

[onthefly]

That screenshot doesn't show the complete table structure.

Is that what you mean?

 

[Paul B]

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]

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.

Thats everything that is displayed after doing what you requested. http://xenforo.com/community/threads/error-when-trying-to-require-prefix.62569/#post-663993

This is what happens http://xenforo.com/community/threads/error-when-trying-to-require-prefix.62569/#post-663997

 

[onthefly]

So now what?

 

[onthefly]

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]

Run this:

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]

Run this:

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.