How can I fix the register.php code?

When someone signs up, they see this after hitting submit:

There seems to have been a slight problem with the Groove-Salad Message Board database.
Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.

and I get this email:

Database error in vBulletin 2.3.0:

Invalid SQL: INSERT INTO useractivation VALUES (NULL,'2069','1055091411','88801190',0)
mysql error: Column count doesn't match value count at row 1

mysql error number: 1136

Date: Sunday 08th of June 2003 09:56:51 AM
Script: http://groove-salad.com/forum/forum/register.php
Referer: http://www.groove-salad.com/forum/register.php

[filburt1]

I believe this happens when you don't properly upgrade vB versions. Did you run the upgrade script in addition to modifying files?

(side note: although I know you didn't write the code, it's bad practice to not specify column names for this very reason, among others.)

[groovesalad]

I ran a hack that didn't work (can't remember which one)....is there any way to take this out of my database?

[groovesalad]

so no one on this board knows?

[MentaL]

reinstall?

[Steve Machol]

Assuming you upgraded to 2.3.0, you failed to run upgrade23.php. Run it and it will add this field.