data base error

[Tony]

I sent out some emails to members, I check my email few hours later and i have this

Database error in vBulletin 2.3.0:

Invalid SQL: INSERT INTO useractivation VALUES (NULL,'71','1046654630','31609942',1)
mysql error: Column count doesn't match value count at row 1

mysql error number: 1136

Date: Sunday 02nd of March 2003 06:23:50 PM
Script: http://www.diabetesforums.com/member.php
Referer:

Thanks Tony

[Tony]

Also if this helps. I receviced this email from a user tring to log in. I goto look up this user in admin cp but I can't find him. I used the quick user finder to.

I guess he isn't a member and that is why i got error email. I don't know then how did he get the email I sent out.

I receive postings through my e-mail although I can not log in using my user name and my password – any clue? Thanks in advance,

Thanks Tony

[fury]

Column count doesn't match value count at row 1 - this error is usually caused by a hack (modification to vBulletin) not completely installed or an upgrade script not finished. If it's a hack that you were trying to install, see the support thread for that hack at vBulletin.org. If you upgraded from 2.2.9, try rerunning the last upgrade script. If neither of those apply, your database may have been corrupted. If you have repair.php, upload that to your forums/admin directory and run it.

[Tony]

We wouldn't know what file or template this hack is in. I had installed couple of hacks awhile back but forgot what I did. I just upgraded from 2.2.9 to 2.3.0 last night.

[Steve Machol]

There should be six columns in the useractivation table. Your error shows you only have 5. Are you sure you ran the appropriate upgrade scripts?

[Tony]

I have no idea. I thought I did. Do you know what one it is? How do I find out if I ran the right scripts?

[Matze0007]

Hiho =)

There should be six columns in the useractivation table. Your error shows you only have 5. Are you sure you ran the appropriate upgrade scripts?

No, I think the error shows that there are indeed six columns in the table but the query (which is in the php file) only hands over 5 values, so probably the new member.php hasn't been uploaded.

[Tony]

Thanks I didn't that and others in the right place, I uploaded the upload folder and that was it. So I thought I had uploaded it.

So this member would have to reregister then?

Thanks for the help!

[Matze0007]

Hiho =)

So this member would have to reregister then?

I don't see a reason for that but probably you have to manually change back the usergroup for the member using the Admin CP.

[Tony]

Hiho =)



I don't see a reason for that but probably you have to manually change back the usergroup for the member using the Admin CP.

Oh never mind he was using the wrong user name to login.

Thanks again Tony