problum with install.sql

[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

[GBABY420]

ok mavrick heres what im gonna do is record a video and show you....

[GBABY420]

a video mavrick http://youtu.be/lR6xiMgeFOg

[Mavrick4283]

I do not understand..... http://www.youtube.com/watch?v=Uxxkp9Ir5Xk

.....If you want you can download teamviewer (7) and PM me or hop on IRC and i will help you live.

[GBABY420]

teamviwer is fine i also tryed to use navicat101 for mysql and that didint work ether..
be4 we go teamviewer were are you downloading it from let me get that link..
and will go from there maybe i have a bad download location or something

[YamiKaitou]

I just tried it myself from a fresh download, worked fine for me as well.

The download location is https://bitbucket.org/psychonic/hlstatsxce/downloads

[GBABY420]

hey mavrick i redownloaded it and dame it if it still dont wont to go in my db

we can do teamviewer if ya wont this is driveing me nuts , is there a script i have to run in the back ground or something??? hey yamikaitou you have your video and i have mine not working eather http://youtu.be/lR6xiMgeFOg. as that being said mavrick we can do teamviewer when ever you have free time...

[Mavrick4283]

I just sent you a PM

[Mavrick4283]

So we were able to get it fixed, adding a check to the new installer to fix this problem (has to do with the most updated version of mysql)

[GBABY420]

mavrick thank you for your help sql files is great now....... if you need anything just holla at me ..

[Mavrick4283]

what is this
http://rsshforums.imap01.com/hlstats/hlstatsimg/downarrow.gif Tools (http://rsshforums.imap01.com/hlstats/hlstats.php?mode=admin)
http://rsshforums.imap01.com/hlstats/hlstatsimg/spacer.gif
http://rsshforums.imap01.com/hlstats/hlstatsimg/downarrow.gif HLstatsX: CE Daemon Control Warning: You are connecting to a remote daemon and do not have a Proxy Key configured.
Please visit the HLstatsX:CE Settings page (http://rsshforums.imap01.com/hlstats/hlstats.php?mode=admin&task=options#options) and configure a Proxy Key. Once configured, manually restart your daemon. there in no proxy key there its blank how do i get one??

It just means that you have not set the proxy key, if i remember correct that setting is near the bottom of the page

[GBABY420]

YA MAVRICK its asking me for a proxy key witch i dont have, and i dont have a proxy either ,
this is for the deamon i need to restart it some how... i found a key but it wont restart the deamon..

[GBABY420]

wow i also have another problem i cant get it to work in the server i type in help and nothing happens

[Mavrick4283]

The proxy key is used by the web-server (php scripts) to talk to the daemon it is kind of a password so look at you daemons config file and make sure they mach, as for your server not working it is because of the proxy key not being the same so the daemon is not talking.

[GBABY420]

lol were is the deamon at ??