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