vb.org Archive - Database Error

Page 2 of 2

Show 40 post(s) from this thread on one page

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

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

- - Database Error - regimage (https://vborg.vbsupport.ru/showthread.php?t=255900)

SVTCobraLTD

12-29-2010 02:06 PM

I am thinking while trying to install a copy of 3.6 in another MySQL database the current sites database may have been affected somehow causing this issue. Since under Products it says vb 3.8.6. However AdminCP says 3.6.11 and the error says 3.8.6. So I believe the database got messed up while attempting to setup my temporary 3.8 board for testing.

Digital Jedi

12-29-2010 02:11 PM

Quote:

Originally Posted by BirdOPrey5 (Post 2140696)

They might be right... It's possible a mod installed a scheduled task to run every hour at 20 after, the same as HourlyCleanup 2... I hope the OP figures it out either way and returns to post whatever worked.

True. But ultimately it seems to stem from his failed upgrade. Correct me if I'm wrong, but wouldn't even some of the default scheduled tasks still trigger the error?

SVTCobraLTD

12-29-2010 06:01 PM

Quote:

Originally Posted by Digital Jedi (Post 2140735)

True. But ultimately it seems to stem from his failed upgrade.

It is, since I am getting this when opening AdminCP...

Quote:

Database error in vBulletin 3.8.6:

Invalid SQL:

SELECT COUNT(*) AS count
FROM moderation AS moderation
INNER JOIN post AS post USING (postid)
WHERE moderation.type='reply';

MySQL Error : Unknown column 'postid' in 'from clause'
Error Number : 1054
Date : Wednesday, December 29th 2010 @ 01:59:29 PM
Script : http://www.xxxxxxxxxx.com/forums/adm...ex.php?do=home
Referrer : http://www.xxxxxx.com/forums/admincp/
IP Address :
Username :
Classname : vB_Database

All times are GMT. The time now is 01:31 PM.

Page 2 of 2

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01076 seconds Memory Usage 1,717KB 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_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (3)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 pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: