I just build my server and set all settings to connection but when my counter-strike server try to create tables in phpmyadmin i get error syntax.
The first official thread for help i have posted here: http://forums.alliedmods.net/showthread.php?t=152989
Here is my log from HLDS (CS SERVER):
- Code: Select all
[WAR3FT] MySQL X database connection successful
L 03/17/2011 - 13:07:32: [MYSQLX] Error in querying database, location: 1
L 03/17/2011 - 13:07:32: [MYSQLX] Message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(14) NOT NULL, PRIMARY KEY (`player_id`), KEY `player_name` (`player_name`), KE' at line 1 (1064)
L 03/17/2011 - 13:07:32: [MYSQLX] Query statement: CREATE TABLE IF NOT EXISTS `wc3_player` ( `player_id` int(8) unsigned NOT NULL auto_increment, `player_steamid` varchar(25) NOT NULL default '', `player_ip` varchar(20) NOT NULL default '', `player_name` varchar(35) NOT NULL default '', `time` timestamp(14) NOT NULL, PRIMARY KEY (`player_id`), KEY `player_name` (`player_name`), L 03/17/2011 - 13:07:32: [MYSQLX] Error in querying database, location: 7
L 03/17/2011 - 13:07:32: [MYSQLX] Message: Table 'xdrone_w3.wc3_config' doesn't exist (1146)
L 03/17/2011 - 13:07:32: [MYSQLX] Query statement: REPLACE INTO `wc3_config` ( `config_id`, `config_value` ) VALUES ( 'level0_xp', '0' );
I have try to find where is the error and i stuck here.
- Code: Select all
CREATE TABLE IF NOT EXISTS `wc3_player` (
`player_id` int( 8 ) unsigned NOT NULL AUTO_INCREMENT ,
`player_steamid` varchar( 25 ) NOT NULL default '',
`player_ip` varchar( 20 ) NOT NULL default '',
`player_name` varchar( 35 ) NOT NULL default '',
`time` timestamp( 14 ) NOT NULL ,
PRIMARY KEY ( `player_id` ) ,
KEY `player_name` ( `player_name` ) ,
KEY `player_ip` ( `player_ip` ) ,
KEY `player_steamid` ( `player_steamid` )
) TYPE = MYISAM ;
SCREENSHOT
Maybe this will be nice to be post (i think this is all tables created by server)
- Code: Select all
new const szTables[TOTAL_TABLES][] =
{
"CREATE TABLE IF NOT EXISTS `wc3_player` ( `player_id` int(8) unsigned NOT NULL auto_increment, `player_steamid` varchar(25) NOT NULL default '', `player_ip` varchar(20) NOT NULL default '', `player_name` varchar(35) NOT NULL default '', `time` timestamp(14) NOT NULL, PRIMARY KEY (`player_id`), KEY `player_name` (`player_name`), KEY `player_ip` (`player_ip`), KEY `player_steamid` (`player_steamid`) ) TYPE=MyISAM;",
"CREATE TABLE IF NOT EXISTS `wc3_player_extra` ( `player_id` INT( 8 ) UNSIGNED NOT NULL , `player_steamid` VARCHAR( 25 ) NOT NULL , `player_ip` VARCHAR( 20 ) NOT NULL , `player_name` VARCHAR( 35 ) NOT NULL , PRIMARY KEY ( `player_id` )) TYPE=MyISAM ;",
"CREATE TABLE IF NOT EXISTS `wc3_player_race` ( `player_id` int(8) unsigned NOT NULL default '0', `race_id` tinyint(4) unsigned NOT NULL default '0', `race_xp` int(8) default NULL, PRIMARY KEY (`player_id`,`race_id`) ) TYPE=MyISAM;",
"CREATE TABLE IF NOT EXISTS `wc3_player_skill` ( `player_id` int(8) unsigned NOT NULL default '0', `skill_id` tinyint(4) unsigned NOT NULL default '0', `skill_level` tinyint(4) unsigned NOT NULL default '0', PRIMARY KEY (`player_id`,`skill_id`) ) TYPE=MyISAM;",
"CREATE TABLE IF NOT EXISTS `wc3_web_race` ( `race_id` tinyint(4) unsigned NOT NULL default '0', `race_lang` char(2) NOT NULL default '', `race_name` varchar(100) default NULL, `race_description` text NOT NULL, PRIMARY KEY (`race_id`,`race_lang`) ) TYPE=MyISAM;",
"CREATE TABLE IF NOT EXISTS `wc3_web_skill` ( `skill_id` tinyint(4) unsigned NOT NULL default '0', `skill_lang` char(2) NOT NULL default '', `skill_name` varchar(100) default NULL, `skill_description` text NOT NULL, `skill_type` tinyint(4) unsigned NOT NULL default '0', `skill_owner` tinyint(4) unsigned NOT NULL default '0', PRIMARY KEY (`skill_id`,`skill_lang`) ) TYPE=MyISAM;",
"CREATE TABLE IF NOT EXISTS `wc3_config` ( `config_id` varchar(50) NOT NULL, `config_value` varchar(255) NOT NULL, PRIMARY KEY (`config_id`) ) TYPE=MyISAM;"
};
If this will help i think maybe something is old.
Xampp-Lampp 1.7.4
- Code: Select all
Apache 2.2.17, MySQL 5.5.8, PHP 5.3.5 & PEAR + SQLite 2.8.17/3.6.16 + multibyte (mbstring) support, Perl 5.10.1, ProFTPD 1.3.3d, phpMyAdmin 3.3.8, OpenSSL 1.0.0c, GD 2.0.1, Freetype2 2.1.7, libjpeg 6b, libpng 1.2.12, gdbm 1.8.0, zlib 1.2.3, expat 1.2, Sablotron 1.0, libxml 2.7.6, Ming 0.4.2, Webalizer 2.21-02, pdf class 009e, ncurses 5.7, mod_perl 2.0.4, FreeTDS 0.63, gettext 0.17, IMAP C-Client 2007e, OpenLDAP (client) 2.4.21, mcrypt 2.5.7, mhash 0.8.18, eAccelerator 0.9.6.1, cURL 7.21.0, libxslt 1.1.26, libapreq 2.12, FPDF 1.6, XAMPP Control Panel 0.8, bzip 1.0.5, PBXT 1.0.11-6-pre-ga (temporarily disabled), PBMS 0.5.15 (temporarily disabled), PBMSlib 0.5.15, ICU4C Library 4.2.1