[GBABY420]

it wont install will export to database this is my error and nothing get installed

[Err] 144 - Table '.\hlstatsx\hlstats_actions' is marked as crashed and last (automatic?) repair failed
[Err] SET @VERSION="1.6.19";

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

--
-- Table structure for table `geoLiteCity_Blocks`
--

CREATE TABLE IF NOT EXISTS `geoLiteCity_Blocks` (
  `startIpNum` bigint(11) unsigned NOT NULL default '0',
  `endIpNum` bigint(11) unsigned NOT NULL default '0',
  `locId` bigint(11) unsigned NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `geoLiteCity_Location`
--

CREATE TABLE IF NOT EXISTS `geoLiteCity_Location` (
  `locId` bigint(11) unsigned NOT NULL default '0',
  `country` varchar(2) NOT NULL,
  `region` varchar(50) default NULL,
  `city` varchar(50) default NULL,
  `postalCode` varchar(10) default NULL,
  `latitude` decimal(14,4) default NULL,
  `longitude` decimal(14,4) default NULL,
  PRIMARY KEY  (`locId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `hlstats_Actions`
--

CREATE TABLE IF NOT EXISTS `hlstats_Actions` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `game` varchar(32) NOT NULL default 'valve',
  `code` varchar(64) NOT NULL default '',
  `reward_player` int(11) NOT NULL default '10',
  `reward_team` int(11) NOT NULL default '0',
  `team` varchar(64) NOT NULL default '',
  `description` varchar(128) default NULL,
  `for_PlayerActions` enum('0','1') NOT NULL default '0',
  `for_PlayerPlayerActions` enum('0','1') NOT NULL default '0',
  `for_TeamActions` enum('0','1') NOT NULL default '0',
  `for_WorldActions` enum('0','1') NOT NULL default '0',
  `count` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `gamecode` (`code`,`game`,`team`),
  KEY `code` (`code`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
-- Dumping data for table `hlstats_Actions`
--

INSERT INTO `hlstats_Actions` (`game`, `code`, `reward_player`, `reward_team`, `team`, `description`, `for_PlayerActions`, `for_PlayerPlayerActions`, `for_TeamActions`, `for_WorldActions`) VALUES
('tf', 'flagevent_defended', 1, 0, '', 'Defended the flag', '1', '', '', ''),
('tf', 'flagevent_captured', 5, 1, '', 'Captured the flag', '1', '', '', ''),
('tf', 'flagevent_dropped', -2, 0, '', 'Dropped the flag (while alive)', '1', '', '', ''),
('tf', 'flagevent_dropped_death', 0, 0, '', 'Dropped the flag (on death)', '1', '', '', ''),
('tf', 'flagevent_picked_up', 2, 0, '', 'Picked up the flag', '1', '', '', ''),
('tf', 'killedobject_obj_teleporter', 2, 0, '', 'Destroyed a teleporter', '1', '', '', ''),
('tf', 'killedobject_obj_dispenser', 3, 0, '', 'Destroyed a dispenser', '1', '', '', ''),
('tf', 'killedobject_obj_sentrygun', 4, 0, '', 'Destroyed a sentry gun', '1', '', '', ''),
('tf', 'killedobject_obj_sentrygun_mini', 4, 0, '', 'Destroyed a mini sentry gun', '1', '', '', ''),
('tf', 'builtobject_obj_teleporter', 2, 0, '', 'Built a teleporter', '1', '', '', ''),
('tf', 'builtobject_obj_dispenser', 3, 0, '', 'Built a dispenser', '1', '', '', ''),
('tf', 'builtobject_obj_sentrygun', 3, 0, '', 'Built a sentry gun', '1', '', '', ''),
('tf', 'builtobject_obj_sentrygun_mini', 3, 0, '', 'Built a mini sentry gun', '1', '', '', ''),
('tf', 'captureblocked', 1, 0, '', 'Capture Blocked', '1', '', '', ''),
('tf', 'pointcaptured', 5, 5, '', 'Point Captured', '1', '', '1', ''),
('tf', 'kill assist', 2, 0, '', 'Kill Assist', '1', '', '', ''),
('tf', 'builtobject_obj_attachment_sapper', 2, 0, '', 'Attached a Sapper', '1', '', '', ''),
('tf', 'killedobject_obj_attachment_sapper', 1, 0, '', 'Removed a Sapper', '1', '', '', ''),
('tf', 'chargedeployed', 1, 0, '', 'Ubercharge', '1', '', '', ''),
('tf', 'domination', 5, 0, '', 'Domination', '', '1', '', ''),
('tf', 'revenge', 3, 0, '', 'Revenge', '', '1', '', ''),
('tf', 'Round_Win', 0, 10, '', 'Round Win', '', '', '1', ''),
('tf', 'Mini_Round_Win', 0, 5, '', 'Mini-Round Win', '', '', '1', ''),
('tf', 'owner_killedobject_obj_sentrygun', -3, 0, '', 'Disassembled a sentry gun', '1', '', '', ''),
('tf', 'owner_killedobject_obj_sentrygun_mini', -3, 0, '', 'Disassembled
[Err] 1146 - Table 'hlstatsx.hlstats_ranks' doesn't exist
[Err] INSERT INTO `hlstats_Ranks` (`game`, `image`, `minKills`, `maxKills`, `rankName`) VALUES
('nd', 'nd_01', 0, 40, 'Survivor'),
('nd', 'nd_02', 41, 131, 'Private I'),
('nd', 'nd_03', 132, 272, 'Private II'),
('nd', 'nd_04', 273, 483, 'Private III'),
('nd', 'nd_05', 484, 764, 'Private First Class I'),
('nd', 'nd_06', 765, 1125, 'Private First Class II'),
('nd', 'nd_07', 1126, 1576, 'Private First Class III'),
('nd', 'nd_08', 1577, 2117, 'Lance Corporal I'),
('nd', 'nd_09', 2118, 2768, 'Lance Corporal II'),
('nd', 'nd_10', 2769, 3529, 'Lance Corporal III'),
('nd', 'nd_11', 3530, 4410, 'Corporal I'),
('nd', 'nd_12', 4411, 5421, 'Corporal II'),
('nd', 'nd_13', 5422, 6562, 'Corporal III'),
('nd', 'nd_14', 6563, 7853, 'Sergeant I'),
('nd', 'nd_15', 7854, 9294, 'Sergeant II'),
('nd', 'nd_16', 9295, 10895, 'Sergeant III'),
('nd', 'nd_17', 10896, 12666, 'Staff Sergeant I'),
('nd', 'nd_18', 12667, 14607, 'Staff Sergeant II'),
('nd', 'nd_19', 14608, 16738, 'Staff Sergeant III'),
('nd', 'nd_20', 16739, 19059, 'Gunnery Sergeant I'),
('nd', 'nd_21', 19060, 21580, 'Gunnery Sergeant II'),
('nd', 'nd_22', 21581, 24311, 'Gunnery Sergeant III'),
('nd', 'nd_23', 24312, 27252, 'Master Sergeant I'),
('nd', 'nd_24', 27253, 30423, 'Master Sergeant II'),
('nd', 'nd_25', 30424, 33824, 'Master Sergeant III'),
('nd', 'nd_26', 33825, 37465, 'First Sergeant I'),
('nd', 'nd_27', 37466, 41356, 'First Sergeant II'),
('nd', 'nd_28', 41357, 45497, 'First Sergeant III'),
('nd', 'nd_29', 45498, 49928, 'Master Gunnery Sergeant I'),
('nd', 'nd_30', 49929, 54669, 'Master Gunnery Sergeant II'),
('nd', 'nd_31', 54670, 59750, 'Master Gunnery Sergeant III'),
('nd', 'nd_32', 59751, 65201, 'Sergeant Major I'),
('nd', 'nd_33', 65202, 71062, 'Sergeant Major II'),
('nd', 'nd_34', 71063, 77343, 'Sergeant Major III'),
('nd', 'nd_35', 77344, 84054, 'Elite Sergeant Major'),
('nd', 'nd_36', 84055, 91215, 'Field Lieutenant'),
('nd', 'nd_37', 91216, 98826, 'Second Lieutenant'),
('nd', 'nd_38', 98827, 106907, 'First Lieutenant'),
('nd', 'nd_39', 106908, 115478, 'Field Captain'),
('nd', 'nd_40', 115479, 124549, 'Captain'),
('nd', 'nd_41', 124550, 134130, 'Vanguard Captain'),
('nd', 'nd_42', 134131, 144231, 'Field Major'),
('nd', 'nd_43', 144232, 154862, 'Major'),
('nd', 'nd_44', 154863, 166043, 'Lieutenant Colonel'),
('nd', 'nd_45', 166044, 177794, 'Colonel'),
('nd', 'nd_46', 177795, 190115, 'Vanguard Colonel'),
('nd', 'nd_47', 190116, 203026, 'Commander'),
('nd', 'nd_48', 203027, 216537, 'Vanguard Commander'),
('nd', 'nd_49', 216538, 230658, 'Elite Commander'),
('nd', 'nd_50', 230659, 245409, 'Brigadier General Third Class'),
('nd', 'nd_51', 245410, 260800, 'Brigadier General Second Class'),
('nd', 'nd_52', 260801, 276841, 'Brigadier General First Class'),
('nd', 'nd_53', 276842, 293552, 'Major General Third Class'),
('nd', 'nd_54', 293553, 310943, 'Major General Second Class'),
('nd', 'nd_55', 310944, 329024, 'Major General First Class'),
('nd', 'nd_56', 329025, 347815, 'Lieutenant General Third Class'),
('nd', 'nd_57', 347816, 367316, 'Lieutenant General Second Class'),
('nd', 'nd_58', 367317, 387547, 'Lieutenant General First Class'),
('nd', 'nd_59', 387548, 408528, 'General'),
('nd', 'nd_60', 408529, 9999999, 'Vanguard General');


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

--
-- Table structure for table `hlstats_Ribbons`
--

CREATE TABLE IF NOT EXISTS `hlstats_Ribbons` (
  `ribbonId` int(11) unsigned NOT NULL auto_increment,
  `awardCode` varchar(50) NOT NULL,
  `awardCount` int(11) NOT NULL default '0',
  `special` tinyint(3) NOT NULL default '0',
  `game` varchar(32) NOT NULL,
  `image` varchar(50) NOT NULL,
  `ribbonName` varchar(50) NOT NULL,
  PRIMARY KEY  (`ribbonId`),
  UNIQUE KEY `award` (`awardCode`,`awardCount`,`game`, `special`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
-- Dumping data for table `hlstats_Ribbons`
--

INSERT INTO `hlstats_Ribbons` (`awardCode`, `awardCount`, `special`, `game`, `image`, `ribbonName`) VALUES
('*Headshots*',2500,1,'css','ribbon_of_silver_star.gif','Sharpshooter'),
('*total connection hours*',25,2,'css','1_con
[Msg] Finished - Unsuccessfully
--------------------------------------------------

[Mavrick4283]

Have you to drop all the tables and try from scratch?

EDIT:

Also post the error in code tags...it is alot more easy to read

And do not go spamming me with help requests it just makes me want to help you less...

[GBABY420]

I even started a new bd .the very first sql file dose it to with this Upgrade 1.00 - 1.1 file, what is this folder called convert for it has 6 sql files in it..?????? and that was the the error log i posted can't get no other log from navicat "execute sql file" log

[Mavrick4283]

If it is a new DB then do not run the upgrade script you need to import the install.sql

[GBABY420]

Thats what i've been trying to do but it wont execute its gives err in sql file i posted that above. that install.sql file will not execute at all.. ive downloaded the hlstatsx like 6 times and it not a download issue...

[Mavrick4283]

Ok there is NO way that you are getting that error using the install.sql on a clean DB......that error is saying that their is alredy data in the DB and it can not overwrite it.

[GBABY420]

im telling ya man its fresh db and zero tables in the db that i created for the install.sql..
all the sql files in that folder do the same thing.. im just sayng if there was tables in that data base thay should over right any old sql files.. and i also have golbalban running and i executed them files to a new db with out and error, and my website witch is phpbb and that sql file executed fine also...
something is just not right mavrick its driving me nuts man

[Mavrick4283]

...Ok, First stop trying to run any other SQL files then the install.sql second put in code tags or PM me the tables in the DB you are trying to install to. NOT what is in them just the names

[GBABY420]

what do you mean by code tags????? and like i said i creat a new db and i execute the install db and it wont execute because of error in sql file,,

[Mavrick4283]

The error you posted is because there is already data in the database.....so unless you are getting a different error and showing me the wrong one there is 0 chance of that error....

And code tags are [code] [ /code] with out the extra space before the / it makes it easy to read long sections of code or errors.


EDIT:
I just took the install.sql file and imported it into a clean DB i got no errors so i know that it is not the problem