Raised This Month: $12 Target: $400
 3% 

Ubuntu 10.10 (xampp-lampp 1.7.4) and W3FT SaveXP by NAME


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
xakintosh
I run no-steam servers!
Join Date: Feb 2010
Location: Edge of nowhere
Old 03-17-2011 , 07:32   Ubuntu 10.10 (xampp-lampp 1.7.4) and W3FT SaveXP by NAME
Reply With Quote #1

Hello to everyone.
I have made a linux hlds core with plugins and everything but....
Here is my log from HLDS:
Code:
[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:
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

I have using this not public version but when i was to windows with vertrigo serv everything working fine but now something is a mess.
http://svn.alliedmods.net/viewvc.cgi.../?root=wc3mods

I'am sorry if i post in a wrong section this thread, please correct me if i'am wrong!

Maybe this will be nice to be post (i think this is all tables created by w3mod)
PHP Code:
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:
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
__________________
As soon as possible.

Last edited by xakintosh; 03-17-2011 at 10:48.
xakintosh is offline
Send a message via Yahoo to xakintosh Send a message via Skype™ to xakintosh
Seta00
The Seta00 user has crashed.
Join Date: Jan 2010
Location: Berlin
Old 03-17-2011 , 17:57   Re: Ubuntu 10.10 (xampp-lampp 1.7.4) and W3FT SaveXP by NAME
Reply With Quote #2

Quote:
Originally Posted by xakintosh View Post
timestamp(14)
What is that even supposed to mean? Apparently an old version of MySQL supported that syntax. MySQL 5.5+ doesn't.
Seta00 is offline
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 10:19.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode