vb.org Archive - new post error [3.6.4]

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)

- - new post error [3.6.4] (https://vborg.vbsupport.ru/showthread.php?t=133155)

RaistliN

12-03-2006 09:28 PM

new post error [3.6.4]

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

Code:

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

12-03-2006 09:45 PM

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

12-03-2006 09:56 PM

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

MrPHD

12-03-2006 09:58 PM

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

RaistliN

12-03-2006 10:17 PM

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

MrPHD

12-03-2006 10:41 PM

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

02-09-2007 03:00 PM

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

Marco van Herwaarden

02-09-2007 03:07 PM

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.

All times are GMT. The time now is 12:11 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01435 seconds Memory Usage 1,721KB 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 (1)bbcode_code_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (8)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
Messages: