vBulletin 4.1.1 Forum Needs Fixing + Badge Additions

I recently applied a security patch to my forum and now it is very buggy and won't allow users to post!

Here is the error I get sent when somebody tries to post:


Database error in vBulletin [url removed, login to view]:

Invalid SQL:

INSERT INTO freedbforum_thread

(prefixid, postusername, postuserid, title, iconid, visible, forumid, dateline, open, attach, lastpost, lastposter, lastposterid, replycount, postercount, hiddencount, deletedcount, keywords)


('', 'James L', 216, 'Accountability Partner', 0, 1, 14, 1360181633, 1, 0, 1360181633, 'James L', 216, 0, 1, 0, 0, 'accountability, business, partner, kinda, learning, freedom, track, james, inbox, running, local, resistance, fighting, england, manchester, shout, mehanical, design, spare, engineer, snowboard, guitar, bands');

MySQL Error : Unknown column 'postercount' in 'field list'

Error Number : 1054

Request Date : Wednesday, February 6th 2013 @ 12:13:53 PM

Error Date : Wednesday, February 6th 2013 @ 12:13:54 PM

Script : [url removed, login to view]

Referrer : [url removed, login to view]

IP Address : [url removed, login to view]

Username : James L

Classname : vB_Database

MySQL Version :


I need an expert to

1. fix the bugs and make it stable and allow users to post freely again.

2. Setup and show me how to add "user badges" and allow administrators to give custom badges to users

(can explain more if that doesn't make sense).

Please put "APPLES" in your bid header so I know you have read and understood what I need.

I am looking for an expert with good track record for dealing with vbulletin. No new people.



Budget: $50 - $100

Skills: Forum Software, PHP, vBulletin

See more: unknown column postercount field list, what to get an engineer, vbulletin forum script, vbulletin 4.0 3, php forum script, new badges, looking for partner engineer, james list, how to setup vbulletin forum, freedom 54 com, freedom 54, fixing com, design your badge, design new england, design a patch, custom snowboard design, custom snowboard, 4 tries, error 1054 unknown column forumid field list, tim l, what is software engineer, learning software design, do you need a design engineer, design your snowboard, what is a badge

About the Employer:
( 35 reviews ) Lavington, Australia

Project ID: #4219442

Awarded to:


APPLES hello sir , iam ready to start , please see PMB

$75 USD in 1 day
(0 Reviews)

6 freelancers are bidding on average $71 for this job


Hello, please check the PMB, Immediate solution to this, Thanks.

$100 USD in 1 day
(123 Reviews)

APPLES - Dear sir. I'm ready.

$50 USD in 1 day
(12 Reviews)

Please see pmb

$100 USD in 1 day
(8 Reviews)

Hello Sir, Hope you are well and doing good!!! we are eager to work with [url removed, login to view] are ready to start the project right away. Codeware is a website development company providing professional website design, website develo More

$250 USD in 7 days
(10 Reviews)

When you applied the patch it didn't apply cleanly. The code was updated but it's looking for a column in the database that doesn't exist. It's trivial to fix. I estimate no longer than 1 hr.

$50 USD in 1 day
(0 Reviews)

Hi Sir, We are fast growing IT Firm having 25+ developers [url removed, login to view] are having experienced,expertise & professional developers who provide fast & quality work. For us client work satisfaction is more important ra More

$50 USD in 2 days
(0 Reviews)