Read log files for errors! If this fails, come here for help
Moderator: Forum Moderator
-
headbuster
- Peon
- Posts: 16
- Joined: Sat Jun 23, 2007 12:35 pm
Post
by headbuster » Sat Jun 23, 2007 12:52 pm
--- Please enter the following information for support ---
War3ft Version: war3ft_v2.3.1
Amxmodx Version: 1.79d
Metamod Version:
amxx list:
amxx modules:
meta list:
I am installing xp statistics on an free hosting server with mysql and everything I need (can I do that)
Please tell me what I have to do because I have to be sure I am doing it right
when i enter the adress of the webstats (
http://headbusterrer.hyperphp.com/webstats/ ) It show this
Code: Select all
Query failed : Table 'hp_658030_webstats.war3users' doesn't exist
Please help me
-
YamiKaitou
- Forum Moderator
- Posts: 1925
- Joined: Wed Feb 01, 2006 4:33 pm
-
Contact:
Post
by YamiKaitou » Sat Jun 23, 2007 12:57 pm
1) There is no 1.79d version of AmxModX
2) Are you saving your xp to MySQL?
No support via PM or Email
-
headbuster
- Peon
- Posts: 16
- Joined: Sat Jun 23, 2007 12:35 pm
Post
by headbuster » Sat Jun 23, 2007 1:02 pm
sorry 1.76d!
Sorry for the stupid question but what do you mean by saving xp to mysql
-
YamiKaitou
- Forum Moderator
- Posts: 1925
- Joined: Wed Feb 01, 2006 4:33 pm
-
Contact:
Post
by YamiKaitou » Sat Jun 23, 2007 1:07 pm
Are you saving your xp to MySQL, SQLite, or Vault? If you are unsure, post the first 10 lines of your war3ft.cfg file
No support via PM or Email
-
headbuster
- Peon
- Posts: 16
- Joined: Sat Jun 23, 2007 12:35 pm
Post
by headbuster » Sat Jun 23, 2007 1:19 pm
mp_savexp 0 // Enables saving of experience (uses a vault, default is 0)
sv_sql 1 // Save using a SQL module (a module needs to be turned on, note: to use this mp_savexp must also be 1, default is 0)
FT_saveby 2 // What should I save this as? steam id = 0, IP = 1, name = 2 (default is 0)
------------
WILL you help me!
Please
-
headbuster
- Peon
- Posts: 16
- Joined: Sat Jun 23, 2007 12:35 pm
Post
by headbuster » Sat Jun 23, 2007 1:54 pm
What should I do please tell me!?
-
YamiKaitou
- Forum Moderator
- Posts: 1925
- Joined: Wed Feb 01, 2006 4:33 pm
-
Contact:
Post
by YamiKaitou » Sat Jun 23, 2007 3:12 pm
You don't even have it set to save xp. Change mp_savexp to 1. Then, make sure you have the SQL cvars configured correctly.
No support via PM or Email
-
headbuster
- Peon
- Posts: 16
- Joined: Sat Jun 23, 2007 12:35 pm
Post
by headbuster » Sun Jun 24, 2007 12:23 am
1OK about the svae xp (does this mean that the xs ois saved and every time you connect you are the highest level you reacherd)
2 What are the sql Cvas
sorry but I don't know much zbout sql
-
headbuster
- Peon
- Posts: 16
- Joined: Sat Jun 23, 2007 12:35 pm
Post
by headbuster » Sun Jun 24, 2007 12:31 am
I don't think the problem is there! I may understand little about sql but I know english
Query failed : Table 'hp_658030_webstats.war3users' doesn't exist
-
DesasterUK
- WC3Mods Donor
- Posts: 223
- Joined: Thu Mar 09, 2006 6:05 pm
- Location: Germany
-
Contact:
Post
by DesasterUK » Sun Jun 24, 2007 3:44 am
@headbuster:
He can't use the statistics website until he is saving the XP to a mysql database.
He is running wc3ft in short term mode, so the plugin hasn't created the needed tables in the database.
Yami is on the right way to help him.
-
headbuster
- Peon
- Posts: 16
- Joined: Sat Jun 23, 2007 12:35 pm
Post
by headbuster » Sun Jun 24, 2007 3:56 am
I just have to make the server SAVE XP? Is that all
-
headbuster
- Peon
- Posts: 16
- Joined: Sat Jun 23, 2007 12:35 pm
Post
by headbuster » Sun Jun 24, 2007 4:20 am
I have made mp_savexp 1 and still
Code: Select all
Query failed : Table 'hp_658030_webstats.war3users' doesn't exist
please tell me where the problem could be
-
YamiKaitou
- Forum Moderator
- Posts: 1925
- Joined: Wed Feb 01, 2006 4:33 pm
-
Contact:
Post
by YamiKaitou » Sun Jun 24, 2007 9:19 am
You need to tell the plugin to save the xp to that MySQL database. So, you need to set the cvars to the info that you are using on the stats page
No support via PM or Email
-
headbuster
- Peon
- Posts: 16
- Joined: Sat Jun 23, 2007 12:35 pm
Post
by headbuster » Sun Jun 24, 2007 9:23 am
Come again? i have set everything DB Username Passs everything but still.!
Please tell me because I am a noob SORRY
-
YamiKaitou
- Forum Moderator
- Posts: 1925
- Joined: Wed Feb 01, 2006 4:33 pm
-
Contact:
Post
by YamiKaitou » Sun Jun 24, 2007 10:01 am
You need to set these cvars in the war3ft.cfg file before it can start saving to MySQL. Then you have to make sure that you have the mysql module enabled
FT_sql_host "127.0.0.1" // Host Name
FT_sql_user "root" // User Name
FT_sql_pass "" // Password
FT_sql_db "" // Database Name
No support via PM or Email
-
headbuster
- Peon
- Posts: 16
- Joined: Sat Jun 23, 2007 12:35 pm
Post
by headbuster » Sun Jun 24, 2007 10:23 am
I have done that and still no result
-
YamiKaitou
- Forum Moderator
- Posts: 1925
- Joined: Wed Feb 01, 2006 4:33 pm
-
Contact:
Post
by YamiKaitou » Sun Jun 24, 2007 10:32 am
Look in the logs, see if there is any errors
No support via PM or Email
-
headbuster
- Peon
- Posts: 16
- Joined: Sat Jun 23, 2007 12:35 pm
Post
by headbuster » Sun Jun 24, 2007 12:20 pm
what should i look for there
-
YamiKaitou
- Forum Moderator
- Posts: 1925
- Joined: Wed Feb 01, 2006 4:33 pm
-
Contact:
Post
by YamiKaitou » Sun Jun 24, 2007 12:47 pm
something dealing with warcraft3FT.amxx or failing to connect to mysql
No support via PM or Email
-
headbuster
- Peon
- Posts: 16
- Joined: Sat Jun 23, 2007 12:35 pm
Post
by headbuster » Sun Jun 24, 2007 12:57 pm
Code: Select all
L 06/24/2007 - 10:35:21: -------- Mapchange to fy_snow --------
L 06/24/2007 - 10:35:21: [AMXX] Plugin file open error (plugin "restmenu.amxx")
L 06/24/2007 - 10:35:21: [AMXX] Plugin file open error (plugin "statsx.amxx")
L 06/24/2007 - 10:35:21: [AMXX] Plugin file open error (plugin "miscstats.amxx")
L 06/24/2007 - 10:35:21: [AMXX] Plugin file open error (plugin "stats_logging.amxx")
L 06/24/2007 - 10:35:23: [warcraft3FT.amxx] Connection to SQLite database successful
L 06/24/2007 - 10:36:43: [sqlstats.amxx] [sqlStats] gets_user_stats ||A.C.A.B||Pr[]*F.3.A.R, STEAM_ID_LAN
L 06/24/2007 - 10:39:35: [sqlstats.amxx] [sqlStats] gets_user_stats -[pWneD]-, STEAM_ID_LAN
L 06/24/2007 - 10:43:00: [warcraft3FT.amxx] Error in querying database, location: 0
L 06/24/2007 - 10:43:00: [warcraft3FT.amxx] Message: unrecognized token: "')" (1)
L 06/24/2007 - 10:43:00: [warcraft3FT.amxx] Query statement: SELECT `xp`, `race` FROM `war3users` WHERE (`playerid` = '~ HaKer40o ~ |\' _ -|')
EDIT by Yami: Condensing the code to make it easier
-
YamiKaitou
- Forum Moderator
- Posts: 1925
- Joined: Wed Feb 01, 2006 4:33 pm
-
Contact:
Post
by YamiKaitou » Sun Jun 24, 2007 1:02 pm
You are not saving the xp to MySQL. You are doing it to SQLite. With SQLite, you cannot use the stats page to display it.
And, the reason why you are unable to get xp is because in your name, you have this character '
If you want it to load/save your xp, you will have to remove it
No support via PM or Email
-
headbuster
- Peon
- Posts: 16
- Joined: Sat Jun 23, 2007 12:35 pm
Post
by headbuster » Mon Jun 25, 2007 12:31 am
That's my friends name
I don't have a problem
So to sum up:
1What do I have to do to save the stats to Mysql(i have just spotted a thing wwhich might be the problem
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
;; SQL Modules usually need to be enabled manually ;;
;; You can have any number on at a time. Use ;;
;; amx_sql_type in sql.cfg to specify the default ;;
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
mysql //I have removed both ;
sqlite
)
-
headbuster
- Peon
- Posts: 16
- Joined: Sat Jun 23, 2007 12:35 pm
Post
by headbuster » Mon Jun 25, 2007 8:26 am
This is what I have done
! used byethost.com
2created a database
3Configured the cfg
// Warcraft 3 Frozen Throne Configuration File
mp_savexp 1 // Enables saving of experience (uses a vault, default is 0)
sv_sql 1 // Save using a SQL module (a module needs to be turned on, note: to use this mp_savexp must also be 1, default is 0)
FT_saveby 2 // What should I save this as? steam id = 0, IP = 1, name = 2 (default is 0)
// SQL configuration
FT_sql_host "sql1.hyperphp.com" // Host Name
FT_sql_user "hp_658030" // User Name
FT_sql_pass "*******" // Password
FT_sql_db "hp_658030_webstats" // Database Name
4uploaded the files configured the config.php
Could someone post the steps
thanks
-
headbuster
- Peon
- Posts: 16
- Joined: Sat Jun 23, 2007 12:35 pm
Post
by headbuster » Mon Jun 25, 2007 12:43 pm
Thats new
L 06/25/2007 - 21:41:03: [warcraft3FT.amxx] Database connection failed, attempting to reconnect in 5 seconds
L 06/25/2007 - 21:41:03: [warcraft3FT.amxx] Error: Can't connect to MySQL server on 'sql1.hyperphp.com' (10060)
-
YamiKaitou
- Forum Moderator
- Posts: 1925
- Joined: Wed Feb 01, 2006 4:33 pm
-
Contact:
Post
by YamiKaitou » Mon Jun 25, 2007 4:47 pm
Your server doesn't have access to connect to that sql server. Contact your provider about it
No support via PM or Email