Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
  #1  
Old 12-03-2006, 09:28 PM
RaistliN RaistliN is offline
 
Join Date: May 2006
Posts: 4
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default 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
Reply With Quote
  #2  
Old 12-03-2006, 09:45 PM
MrPHD's Avatar
MrPHD MrPHD is offline
 
Join Date: Feb 2006
Location: Portugal
Posts: 385
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #3  
Old 12-03-2006, 09:56 PM
RaistliN RaistliN is offline
 
Join Date: May 2006
Posts: 4
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

i did these operation but still it gives error when sending a message or post
Reply With Quote
  #4  
Old 12-03-2006, 09:58 PM
MrPHD's Avatar
MrPHD MrPHD is offline
 
Join Date: Feb 2006
Location: Portugal
Posts: 385
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Well, check if any Hack is conflit whit DB and confirm when this error appear.
Reply With Quote
  #5  
Old 12-03-2006, 10:17 PM
RaistliN RaistliN is offline
 
Join Date: May 2006
Posts: 4
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

we moved forum's files to site.com from site.com/forum. and then it started to give this error
Reply With Quote
  #6  
Old 12-03-2006, 10:41 PM
MrPHD's Avatar
MrPHD MrPHD is offline
 
Join Date: Feb 2006
Location: Portugal
Posts: 385
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #7  
Old 02-09-2007, 03:00 PM
workRelated workRelated is offline
 
Join Date: Jul 2006
Posts: 4
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

running all the counter updates and repairing the tables still didnt fix the issue for me
Reply With Quote
  #8  
Old 02-09-2007, 03:07 PM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


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


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04145 seconds
  • Memory Usage 2,222KB
  • Queries Executed 13 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)bbcode_code
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (8)post_thanks_box
  • (8)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (8)post_thanks_postbit_info
  • (8)postbit
  • (8)postbit_onlinestatus
  • (8)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete