Problem - Table: vb_post have a problem

[onezure]

Hi! I'm a italian! Excuse me for the languages not a very good.

I'm have a problem for the TABLE vb_post! (vb_ -> is a table imposted to config.php) , the table vb_post have a problem , i'm create a new discussion or reply on the discussion , look a problem:

Database error in vBulletin 4.0.3:

Invalid SQL:
INSERT INTO vb_post
	(showsignature, allowsmilie, htmlstate, username, userid, title, pagetext, iconid, visible, parentid, threadid, dateline, ipaddress, attach)
VALUES
	(0, 1, 'on_nl2br', '~Privacy', 1, '', 'Ciao', 0, 1, 4237, 1358, 1273694170, 'censured my ip', 0);

MySQL Error   : Unknown column 'htmlstate' in 'field list'
Error Number  : 1054
Request Date  : Wednesday, May 12th 2010 @ 09:56:10 PM
Error Date    : Wednesday, May 12th 2010 @ 09:56:10 PM
Script        : http://www.onezure.info/forum/newreply.php?do=postreply&t=1358
Referrer      : http://www.onezure.info/forum/showthread.php/1358-PC?p=4237
IP Address    : Censured my ip
Username      : ~Privacy
Classname     : vB_Database
MySQL Version : 5.0.90-community

What's the problem? ?_?

Thank's for the reply

[Lynne]

It looks like your post table is missing the field htmlstate. This is from mysql-schema.php for v/b4.0.3:

htmlstate ENUM('off', 'on', 'on_nl2br') NOT NULL DEFAULT 'on_nl2br',

[onezure]

The html state ? Ok...

mmm... I'm a create a new table?

[borbole]

Originally Posted by onezure

The html state ? Ok...

mmm... I'm a create a new table?

Nope, you will need to readd that into your existing post table. You can do it with the ALTER TABLE {table name} ADD..... sql query command.

[onezure]

mmmm... ok , the Alter table is a :

ALTER TABLE {htmlstate ENUM('off', 'on', 'on_nl2br') NOT NULL DEFAULT 'on_nl2br',}

it's ok? :S

[Lynne]

Do you not have phpMyAdmin? I've always found it easier to just add a field that way when it's just a single field like this.

[onezure]

I'm have a phpmyadmin is a logic xD , in the phpmyadmin what should i do? what can i say?

[Lynne]

I just go to the table and then click down where it says "Add *blank* fields and I add them there. If you have never done this, I strongly suggest googling adding fields in phpMyAdmin and getting a good idea of what you are going to do. I'd also suggest making a database backup prior to doing anything in your database.

[SBoards]

If this person is having the same issue as me, that's not going to work. The problem is that the post table just won't update. Wether it's the upgrade script, vB's sql tools or phpmyadmin. This just plain ain't good. lol

[onezure]

And a table that breaks down a bit, I feel what he said Lynne and I say

--------------- Added [DATE]1273971927[/DATE] at [TIME]1273971927[/TIME] ---------------

Excuse me for double post , i'm a resolve the problem , install the new vBulletin! Thank's