[sv1cec]

Originally Posted by DaveBeel

Okay I am nearly there now guys and I thank you all for your assistance.

I have two remaining little problems and I think you may be able to sort them quickly. I have obviously typed something incorrectly somewhere.

Firstly. On the posts I have two lots of Warn and View commands at the top of each thread. Obviously I have duplicated somewhere but I would appreciate knowing which file to look at.

The second one is when I issue someone a warning I get the following message...

Database error in vBulletin 3.0.7:

Invalid SQL: update vb3_user set warning_level='2', warnings='1' where userid='4'
mysql error: Unknown column 'warnings' in 'field list'

mysql error number: 1054

Not sure what the problem is here.

If you think you could fix it quickly for me John I would appreciate it. Whether that be you telling me where I should go, or whether i give you access I am willing to do that.

Many thanks.

For the second problem, run this query:

ALTER TABLE `".TABLE_PREFIX."user` add `warnings` int(5) default '0'

Remeber to change the ".TABLE_PREFIX." to your prefix, which I think is vb3_

For the first problem, check the mods in your postbit or postbit_legacy template. You have probably missed an <if> or some condition is not right.

Rgds