SQL/DB Error

Coksnuss · Post by **Coksnuss** » Fri Jun 08, 2007 4:48 pm

Are you using the correct version for your mod?
There are 2 versions...
1 for 2.3.2 and 1 for the actually 3.0 RC6

Nikol4u · Post by **Nikol4u** » Sat Jun 09, 2007 5:20 am

can u tell/give us the .sql dump for the stats? i use them 2 and i have errors...

SQL/DB Error -- [Table 'rstrike_board.wc3_web_race' doesn't exist]
SQL/DB Error -- [Table 'rstrike_board.wc3_player' doesn't exist]
SQL/DB Error -- [Table 'rstrike_board.wc3_player' doesn't exist]

Amx Mod X: 1.76d
Warcraft 3FT: 2.3.1
PHP: 5
Server: windows dedicated ...

Post by **YamiKaitou** » Sat Jun 09, 2007 10:36 am

If you are using War3ft 2.x, then you need to use 1.1.

If you are using War3ft 3.x, then you need to use 1.2.

Post by **YamiKaitou** » Sat Jun 09, 2007 11:26 am

You said that was the one you downloaded. What version of war3ft are you running?

Post by **YamiKaitou** » Sat Jun 09, 2007 12:13 pm

You need to enable saving of xp to a MySQL database. What version of war3ft are you running?

Post by **YamiKaitou** » Sat Jun 09, 2007 5:03 pm

Okay, you need to save the xp to a mysql database for the stats page to work. Then, you must configure the stats page to access that database

Nikol4u · Post by **Nikol4u** » Sun Jun 10, 2007 3:26 am

YamiKaitou wrote:If you are using War3ft 2.x, then you need to use 1.1.

If you are using War3ft 3.x, then you need to use 1.2.

yeah I tryied then with 1.1 and saw that i had made a mistake and now everything's fine .. thx

Nikol4u · Post by **Nikol4u** » Sun Jun 10, 2007 3:39 am

@fjollerik

Go in xxx\cstrike\addons\amxmodx\configs\war3ft then open war3FT.cfg and edit that:

Code: Select all

// Saving Options

wc3_save_xp		0		// Enables saving of experience (default is 0)
wc3_save_xp_db		0		// How should we save XP? (0 = SQLite, 1 = MySQL)

wc3_save_by		0		// What should I save this as?  steam id = 0, IP = 1, name = 2 (default is 0)
wc3_save_pruning	0		// Automatically prunes the database of old users at a mapchange (default is 0)
wc3_days_before_delete	31		// However many days before deleting XP or pruning from the database (default is 31)
wc3_save_end_round	1		// Save xp at the end of each round (may cause lag, default is 1)


// SQL Database Information

wc3_sql_dbhost		"localhost"	// Host Name
wc3_sql_dbuser		"root"		// User Name
wc3_sql_dbpass		""		// Password
wc3_sql_dbname		""		// Database Name

to

Code: Select all

// Saving Options

wc3_save_xp		1		// Enables saving of experience (default is 0)
wc3_save_xp_db		1		// How should we save XP? (0 = SQLite, 1 = MySQL)

wc3_save_by		2		// What should I save this as?  steam id = 0, IP = 1, name = 2 (default is 0)
wc3_save_pruning	0		// Automatically prunes the database of old users at a mapchange (default is 0)
wc3_days_before_delete	31		// However many days before deleting XP or pruning from the database (default is 31)
wc3_save_end_round	1		// Save xp at the end of each round (may cause lag, default is 1)


// SQL Database Information

wc3_sql_dbhost		"your host"	// Host Name
wc3_sql_dbuser		"your [my]sql user"		// User Name
wc3_sql_dbpass		"your pass"		// Password
wc3_sql_dbname		"your db"		// Database Name

Post by **YamiKaitou** » Wed Jun 13, 2007 12:05 am

Did you enter your details correctly? Are there any error messages being logged?

Post by **YamiKaitou** » Wed Jun 13, 2007 1:04 am

In addons/amxmodx/logs/

Manix · Post by **Manix** » Wed Jun 13, 2007 2:22 am

send me a small amount of cash and ill come get you all setup.

Manix · Post by **Manix** » Wed Jun 13, 2007 3:24 am

now why would i want to rip you off. Ive been a moderator here for over a year now, and I manage my own set of servers since 2003. I don't know you and I am pretty sure noone else here knows you. I'm not gonna do the work first and risk wasting my time and getting ripped off. http://central-cs.net if you're interested...or pm me here. $5.00 and I will get you all setup.

Manix · Post by **Manix** » Wed Jun 13, 2007 3:52 am

good point $5.00 USD. Only USD accepted

Post by **YamiKaitou** » Fri Jun 15, 2007 6:32 am

Core FIles means it is the core. You don't need both, just one or the other

Post by **YamiKaitou** » Fri Jun 15, 2007 4:31 pm

Okay, lets try this. Are you paying for the server? If so, would you like me to take a look at it? If you say yes, I will need access to log into the FTP of the server. Be wared, DO NOT give me the main account UNLESS your server provider doesn't allow for multiple users on one account.

If you say no to giving me access, then I will tell you what I need at that time.

Manix · Post by **Manix** » Mon Jun 18, 2007 5:05 am

read the instructions and FAQ's.. we aren't gonna hold your hand. This topic is going nowhere. You are complaining that something don't work but you don't want to allow anyone to help you. This topic is locked.