new post error [3.6.4]

[RaistliN]

when we send a new post or new messager..Database give errors and sending a mail about this report



Database error in vBulletin 3.6.4:

Invalid SQL:
UPDATE session SET newposts = newposts+1 WHERE NOT ISNULL(newposts);

MySQL Error : Unknown column 'newposts' in 'where clause'
Error Number : 1054
Date : Sunday, December 3rd 2006 @ 04:20:35 PM
Script : http://www.yolgecenhani.net/newreply.php?do=postreply&t=42399
Referrer : http://www.yolgecenhani.net/merhaba-t42399.html
IP Address :
Username : aciidjxi
Classname : vb_database

[MrPHD]

Please can you Edit this post becouse your IP is visible. i´m gona your site to check out.

Ups...it´s a language i can´t understand...

But you can go on Admin Cp - Maintenance - Repair / Optimize Tables

then Go: Counters Update and update all counters.

If for whatever reason the UNIQUE indexes in your database have been lost (usually this happens after importing an incomplete or corrupt SQL dump) you may find strange behavior, particularly when using the language and template systems.

This system will attempt to correct the problem and rebuild your UNIQUE indexes.

Please ensure that the mysql-schema.php file is present in the install folder on your web server before continuing.

[RaistliN]

i did these operation but still it gives error when sending a message or post

[MrPHD]

Well, check if any Hack is conflit whit DB and confirm when this error appear.

[RaistliN]

we moved forum's files to site.com from site.com/forum. and then it started to give this error

[MrPHD]

Ok, go in your Admin Cp - vBulletin Options - Site Name / URL / Contact Details and made changes on, after that you made again But you can go on Admin Cp - Maintenance - Repair / Optimize Tables

then Go: Counters Update and update all counters.

[workRelated]

running all the counter updates and repairing the tables still didnt fix the issue for me

[Marco van Herwaarden]

There is no 'newposts' column in the default session table. This is caused by a modification you have installed.

To troubleshoot this, please remove any hacks and disable your plugins, then see if you still have this problem.
Note: To temporarily disable the plugin system, edit config.php and add this line right under <?php

define('DISABLE_HOOKS', true);

If so, reupload all the original vB non-image files (except install.php). Make sure you upload these in ASCII format and overwrite the ones on the server.