The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
||||
|
||||
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) --------------- Added [DATE]1261135089[/DATE] at [TIME]1261135089[/TIME] --------------- I deleted strikes table and restore the most, but not understand what happened |
#2
|
|||
|
|||
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. |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|