PDA

View Full Version : Databese error with table strikes


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


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


-- 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 1261135089 at 1261135089 ---------------

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.