Database Error when clicking on posts

[Guest C0pyRyte]

So for some reason, when I click on a post, I get a driver error...

 

If you are seeing this page, it means there was a problem communicating with our database. Sometimes this error is temporary and will go away when you refresh the page. Sometimes the error will need to be fixed by an administrator before the site will become accessible again.

 

Does it on every single post, but the rest of the forum is fine. It just started doing it today.

I went to ACP > Support > Diagnostics > Database checker. It found the following problems....

 

• [*]ALTER TABLE posts ADD pid int(10) NOT NULL auto_increment, ADD PRIMARY KEY( pid); [*]ALTER TABLE posts ADD append_edit tinyint(1) default 0; [*]ALTER TABLE posts ADD edit_time int(10) default NULL; [*]ALTER TABLE posts ADD author_id mediumint(8) NOT NULL default 0; [*]ALTER TABLE posts ADD author_name varchar(255) default NULL; [*]ALTER TABLE posts ADD use_sig tinyint(1) NOT NULL default 0; [*]ALTER TABLE posts ADD use_emo tinyint(1) NOT NULL default 0; [*]ALTER TABLE posts ADD ip_address varchar(46) NOT NULL default ''; [*]ALTER TABLE posts ADD post_date int(10) default NULL; [*]ALTER TABLE posts ADD post mediumtext; [*]ALTER TABLE posts ADD queued tinyint(1) NOT NULL default 0; [*]ALTER TABLE posts ADD topic_id int(10) NOT NULL default 0; [*]ALTER TABLE posts ADD new_topic tinyint(1) default 0; [*]ALTER TABLE posts ADD edit_name varchar(255) default NULL; [*]ALTER TABLE posts ADD post_key varchar(32) NOT NULL default '0'; [*]ALTER TABLE posts ADD post_htmlstate smallint(1) NOT NULL default 0; [*]ALTER TABLE posts ADD post_edit_reason varchar(255) NOT NULL default ''; [*]ALTER TABLE posts ADD post_bwoptions INT(10) UNSIGNED NOT NULL DEFAULT 0; [*]ALTER TABLE posts ADD pdelete_time INT NOT NULL DEFAULT 0; [*]ALTER TABLE posts ADD post_field_int INT(10) NOT NULL DEFAULT 0; [*]ALTER TABLE posts ADD post_field_t1 TEXT NULL DEFAULT NULL; [*]ALTER TABLE posts ADD post_field_t2 TEXT NULL DEFAULT NULL;
  

 

 

 

I then clicked on "Would you like us to attempt to fix them for you?" and then all of the queries fail...

I haven't touched my forum since yesterday.. and it was working fine then, so I have no idea whats wrong with it...

 

Any Idea's?

[Guest C0pyRyte]

solved by repairing and optimizing structure in phpmyadmin

 

Thanks all

[Phun]

Is there an addon or modification you're using that has to do with posts, shows in posts or does something after posting something? If yes: Disable it and see if that helps. If it does please post the name of the modification here.

[Guest C0pyRyte]

I disabled all of my modifications and hooks and the problem is still there...

 

hmmmm

[Lock Down]

Could be several reasons. Might be a new version of Mysql was installed on the server. Might be timing out trying to fix the errors.

 

Take your ipb offline and then use your phpmyadmin to try and repair the posts table.