Ubuntu 10.10 and Lampp 1.7.4

Problems with the Linux version of XAMPP, questions, comments, and anything related.

Ubuntu 10.10 and Lampp 1.7.4

Postby xkp » 18. March 2011 09:07

Hello i'am working with ubuntu and lampp, my system is simple i have linux and on it i run counter-strike servers with mysql connection to lampp.
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
xkp
 
Posts: 1
Joined: 18. March 2011 09:00

Return to XAMPP for Linux

Who is online

Users browsing this forum: No registered users and 7 guests