vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Forum and Server Management (https://vborg.vbsupport.ru/forumdisplay.php?f=232)
-   -   Databese error with table strikes (https://vborg.vbsupport.ru/showthread.php?t=230459)

00skull00 12-18-2009 08:43 AM
Databese error with table strikes
 
I have a problem with the table strikes, error when I click on login admincp, modcp


Code:
Database error in vBulletin 3.8.3:

Invalid SQL:
DELETE FROM strikes WHERE striketime < 1261128853;

MySQL Error  : Table 'vuilachinh_forums.strikes' doesn't exist
Error Number  : 1146
Request Date  : Friday, December 18th 2009 @ 05:34:13 PM
Error Date    : Friday, December 18th 2009 @ 05:34:13 PM
Script        : http://forum.vuilachinh.org/login.php?do=login
Referrer      : http://forum.vuilachinh.org/modcp/
IP Address    : 115.75.25.112
Username      : 00skull00
Classname    : vB_Database
MySQL Version : 5.0.85-community

Now this is the table strikes


Code:
-- phpMyAdmin SQL Dump
-- version 3.2.4
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Dec 18, 2009 at 05:28 PM
-- Server version: 5.0.85
-- PHP Version: 5.2.6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `vuilachinh_forums`
--

-- --------------------------------------------------------

--
-- Table structure for table `strikes`
--
-- in use(#145 - Table './vuilachinh_forums/strikes' is marked as crashed and should be repaired)

--
-- Dumping data for table `strikes`
--
-- in use (#145 - Table './vuilachinh_forums/strikes' is marked as crashed and should be repaired)
thanks

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

I deleted strikes table and restore the most, but not understand what happened

snakes1100 12-18-2009 11:50 AM
Did you verify the table was actually gone using phpmyadmin or viewing the db via ssh?

The table states it was crashed, you should of repaired it using myisamchk via ssh or using phpmyadmin.


All times are GMT. The time now is 07:03 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.01680 seconds
  • Memory Usage 1,711KB
  • 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_code_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (2)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