Database error in vBulletin 2.2.2:

Invalid SQL: UPDATE user SET forumviewset='' WHERE userid='1' mysql error: Unknown column 'forumviewset' in 'field list'

mysql error number: 1054

Getting this error and I followed the steps exact. I see something about installing twice, I think I did my accident so if this is the problem, how to I reverse it?

Using phpMyAdmin or a sql hack or even just mysql via the shell

run this query.
ALTER TABLE user ADD forumviewset varchar(250) NOT NULL default ':'

I have forums that are members of a category, which is beneath another category. So I have a structure like:

Category A
----Category C
---------Forum 1
----Category D
---------Forum 2
---------Forum 3

With this hack installed, BOTH Categories A, C, and D are collapsed on the forums home, and CANNOT be expanded. Clicking the little "+" does nothing. So, anything beneath category A can't be viewed. What template affects this? Is this a known bug? Are people able to have the above situation with no problems?

Thanks dabean that worked =)

jminiman: Tested it does work, subject to creating the relivant level3 vb templates (not to do with this hack but vB its self).

Any/all templates you want the expansion/contraction buttons to appear in must contain "$expandcontract".

Thanks worked great only thing I had was inside of whos online shows:

/vb/updateindex.php?&fid=45&val=0

As to where I am at. Did I miss something in the hack? Everything else seems to be working fine.

You can fix that manually (complex/difficult not going to explain how).

Or use this hack.
https://vborg.vbsupport.ru/showthrea...threadid=32849

dabean,

This is definitely one of my favorite hacks! Anyway, when I create the third tier templates, are they exact copies of the second-tier ones?

jminiman: When I tested third and infact fourth tier templates I just made exact copies of the level 2 templates. So in answer to your question yes :)

perhaps you can help me, i installed the hack and I have the forum/posts/threads hack, and I think I did everything properly, but now when I expand or contract it, all that happens is that the forum/posts/threads expands or contracts. What have i done wrong?

Here is my forum: http://www.ti-arts.com/forums/index.php