1 azarober Nov 07, 2007 14:46
3 azarober Nov 07, 2007 15:07
Thanks a lot for the quick reply....
I am in problems... because my server "pages garden" is crashing and does not give support...
How can I do it ?
4 azarober Nov 07, 2007 15:18
WHAT I need to delete? This what I found in the table evo_hitlog
-- phpMyAdmin SQL Dump
-- version 2.11.0
-- http://www.phpmyadmin.net
--
-- Servidor: localhost
-- Tiempo de generación: 07-11-2007 a las 08:07:28
-- Versión del servidor: 5.0.27
-- Versión de PHP: 5.2.3
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- Base de datos: `ebaxst03_bvlt1`
--
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `evo_hitlog`
--
CREATE TABLE `evo_hitlog` (
`hit_ID` int(11) NOT NULL auto_increment,
`hit_sess_ID` int(10) unsigned default NULL,
`hit_datetime` datetime NOT NULL default '0000-00-00 00:00:00',
`hit_uri` varchar(250) default NULL,
`hit_referer_type` enum('search','blacklist','spam','referer','direct','self','admin') NOT NULL,
`hit_referer` varchar(250) default NULL,
`hit_referer_dom_ID` int(10) unsigned default NULL,
`hit_blog_ID` int(11) unsigned default NULL,
`hit_remote_addr` varchar(40) default NULL,
`hit_agnt_ID` int(10) unsigned default NULL,
PRIMARY KEY (`hit_ID`),
KEY `hit_agnt_ID` (`hit_agnt_ID`),
KEY `hit_blog_ID` (`hit_blog_ID`),
KEY `hit_uri` (`hit_uri`),
KEY `hit_referer_dom_ID` (`hit_referer_dom_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=148925 ;
--
-- Volcar la base de datos para la tabla `evo_hitlog`
--
5 afwas Nov 07, 2007 15:35
Do not remove the table. Find the table evo_hitlogs in the left bar and select it. In the right bar select hit_ID and hit "Browse".
If all goes well a list with entries shows. Here you need to find the number (hit_Id) 148925. It's probably on top and probably twice in the row. Delete one of them.
That's about it. I'm on IRC now (http://www.hemminga.net/cgi-bin/irc.cgi) if you want a live chat.
Good luck
6 azarober Nov 07, 2007 20:11
Thank you a lot for your work.... only I clicked in some place of the place you sent me... " Repair the table" and that's all !
Thank you again !
Roberto
http://www.eba-stats.com
7 afwas Nov 07, 2007 20:17
Well done.
Happy blogging
Hi Ronerto,
Ask somebody with experience to dive into phpMyadmin and delete the enrty (record) 148925 from the table evo_hitlog. The number of the record that gives the problem is the one mentioned in the error. You find phpMyAdmin in the cPanel or user panel from your host.
Good luck