vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   DB Errors. (https://vborg.vbsupport.ru/showthread.php?t=186280)

Hex_legend 07-24-2008 09:31 PM
DB Errors.
 
I had a db error which said forum.forumdatastore does not exist.. So I created the table and I am now getting:

PHP Code:
vBulletin datastore error caused by one or more of the following:

   1. You may have uploaded vBulletin 3.6 files without also running the vBulletin upgrade script. If you have not run the upgrade script, do so now.
   2. The datastore cache may have been corrupted. Run Rebuild Bitfields from tools.php, which you can upload from the do_not_upload folder of the vBulletin package.


Fatal error: vBulletin datastore cache incomplete or corrupt in [path]/includes/init.php on line 214 
I have uploaded tools.php and run the bitfields script and I am getting this db error:

PHP Code:
<!--
Database error in vBulletin :

Invalid SQL:
DELETE FROM forumsettinggroup WHERE volatile = 1 AND (product = 'vbulletin' OR product = '');

MySQL Error   : Table 'forum.forumsettinggroup' doesn't exist
Error Number  : 1146
Request Date  : Thursday, July 24th 2008 @ 11:25:56 PM
Error Date    : Thursday, July 24th 2008 @ 11:25:56 PM
Script        : http://www.newmodifications.com/forum/install/tools.php?do=xml&amp;type=settings
Referrer      : http://www.newmodifications.com/forum/install/tools.php?do=login
IP Address    : 84.67.36.58
Username      : 
Classname     : vB_Database_MySQLi
MySQL Version : 
--> 
I do not know anything about phpmyadmin and don't know how I can sort any of this out.. Can someone help me sort this?

--------------- Added [DATE]1216938727[/DATE] at [TIME]1216938727[/TIME] ---------------

Additional Info

I am running 3.7.2

Lynne 07-24-2008 10:31 PM
Did you run the upgrade script when you upgraded to 3.7.2?

Hex_legend 07-24-2008 10:36 PM
No, it was a fresh install.

For some reason, the site has come back up on its own now - I've not done anything.

Can anyone explain this?

It's not to do with a host as its vps and they don't work at this time of night

Dismounted 07-25-2008 07:44 AM
"forumsettinggroup" is not a default vBulletin table.

Marco van Herwaarden 07-25-2008 12:53 PM
It is if you use the table prefix "forum". ;)

Hex_legend 07-25-2008 02:26 PM
Can anyone explain why it came back up on its own about 30 mins after the error?

Tools.php even caused errors...

Lynne 07-25-2008 02:42 PM
I have no idea. Have you tried asking your host if they were having problems around the time your forum was having problems?

Hex_legend 07-25-2008 03:01 PM
The server status showed fine. There was no lag or anything of that nature.
Like I said, I am on a vps, so I have access to everything that shows the running of the server

Opserty 07-25-2008 05:22 PM
It may have stemmed from this:
Quote:
I had a db error which said forum.forumdatastore does not exist.. So I created the table and I am now getting:
This table just wouldn't "disappear" something must have happened to it. Creating tables manually isn't really advised, you are just solving the symptoms not the problem itself.

I haven't seen anything like this happening, maybe it was a faulty modification or something, we can't really tell.


All times are GMT. The time now is 10:27 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01027 seconds
  • Memory Usage 1,736KB
  • 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
  • (2)bbcode_php_printable
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (9)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