vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB4 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=252)
-   -   Problem - Table: vb_post have a problem (https://vborg.vbsupport.ru/showthread.php?t=242382)

onezure 05-12-2010 06:58 PM
Problem - Table: vb_post have a problem
 
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:

Code:
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 05-12-2010 10:24 PM
It looks like your post table is missing the field htmlstate. This is from mysql-schema.php for v/b4.0.3:

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

onezure 05-13-2010 04:42 AM
The html state ? Ok...

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

borbole 05-13-2010 01:22 PM
Quote:
Originally Posted by onezure (Post 2036127)
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 05-14-2010 06:32 AM
mmmm... ok , the Alter table is a :

Code:
ALTER TABLE {htmlstate ENUM('off', 'on', 'on_nl2br') NOT NULL DEFAULT 'on_nl2br',}
it's ok? :S

Lynne 05-14-2010 01:40 PM
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 05-15-2010 06:25 AM
I'm have a phpmyadmin is a logic xD , in the phpmyadmin what should i do? what can i say?

Lynne 05-15-2010 03:17 PM
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 05-15-2010 06:02 PM
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 05-15-2010 11:16 PM
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 ;)


All times are GMT. The time now is 06:05 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02685 seconds
  • Memory Usage 1,731KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (3)bbcode_code_printable
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete