Forums

I've been interested in making my own bf2 unranked server and I'm in the process of learning how to install a server, webstats page, etc. I'm a total noob at this. I'm at the point now of installing the DB and when it finished, it came up with this error.

ERROR: Version Data *NOT* Loaded: 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 '.2, 1193328291)' at line 1

Do I need to edit a certain file to correct the syntax error?

Cheers,

rf40

No sir. Were you sucessful following the dorections in the readme.txt in the bf2statistics zip file?
Database Server (MySQL):
------------------------
1. Install MySQL 4 or MySQL 5
2. Create New Database (ie, bf2stats)
3. Create New DB User Account (ie, bf2statslogger)
4. Grant DBO (Database Owner) rights to new user account
5. Grant Global Right 'FILE ACCESS' (for database backups within Web Admin: OPTIONAL)

Is which step are you having problems on?
-or- Is the problem on installing the DB from the Private Stats Admin

hookt on foniks werked 4 mi

[ Edited Thu Oct 25 2007, 11:06AM ]

Sorry for not getting back to you sooner. I had a problem with the server. It was an older version and I had to download the latest server from EA. Oh well, live and learn. Well, I managed to create the DB and I got the redirect to work at this point. (started the server and pinged it). I came up with 192.168.1.2 @128 ms ttl.

Next, I ran the server with the karkand map in conquest mode. Everything worked at this point. However, I need to learn how to run the server in "coop" mode and see if the information is going into the game logs. I also need to add bots somehow to the map. I was surprised to find an entry in the server\python\gb2\log. It had the following in it:

Persistant stats module initialized.
Snapshot module not found.
Medal awarding module not found.
warning: couldn't read "admin/default.cfg": [Errno 2] No such file or directory: 'admin/default.cfg'
initializing default admin/rcon module
shutting down default admin/rcon module

Don't know if I'm getting closer but it has been fun trying.

rf40

[ Edited Thu Oct 25 2007, 05:10PM ]

If I'm not totally lost on this, it should be enough to change in the maplist.con in "X:\Program Files\EA GAMES\Battlefield 2 Server\mods\bf2\settings" (or whatever your installation path is.)

Delete the current Karkand entery and replace it with

MapList.append dalian_plant gpm_coop

Or whichever map you wish to play. Hope that solves it. =]

Dont' forget to add the map size
ex
MapList.append dalian_plant gpm_coop 16
MapList.append dalian_plant gpm_coop 32
MapList.append dalian_plant gpm_coop 64

You can get all BF2 maps for SP and Coop here all sizes
BF2 SP

[ Edited Fri Oct 26 2007, 12:18PM ]

Thank you both for your help. I'm having a problem with viewing the ranks,etc in the web browser. I have another error: ERRORS: LOG: MySQL table (stats) is ready to go. MySQL table (data) is ready to go. Leaderboard data was older than maximum limit(max=0)(age=38539). getData(): url == http://127.0.0.1/ASP/getleaderboard.aspx?type=score&id=overall&after=25 getData(): file() failed or disabled, trying CURL Retrieving leaderboard directly from website... ...successful. Leaderboard saved in the MySQL DB. QUERIES (0.0884461402893): Query(0.000473022460938): SHOW TABLES LIKE 'stats' Query(0.000380992889404): SHOW TABLES LIKE 'data' Query(0.087259054184): SELECT * FROM data WHERE stat = 'leader-board' Query(0.000333070755005): UPDATE data SET `update_time`=(1193440005), `data`=('eJzzswYAANkAig=='), `stat`=('leader-board') WHERE `stat`='leader-board' LIMIT 1

Also, I can see where my server has unlocks but when in the game, the locks are still in place. This has been a great learning experience so far.

Btw, I do have Windows XP pro x64 for my os. I have changed my host file and created a host.ics file as well. I'll be back soon.

Cheers

rf40

ok, I found another issue. Under localhost/asp, I was trying to type in my DB backup path and an error message popped up saying invalid characters. The path I need is

F:/Program Files (x86)/xampp/htdocs/ASP/_backups/

I did install bf2statistics 1.2 and copied the contents of the bf2statistics.sql file and created a new database called bf2stats2. The DB was installed and updated. So far, so good.

cheers

If you havn't already, download bf2statistics Web Beta and unpack it in X:/Program Files/xampp/htdocs/bf2statistics-web_Beta

After that you should be able to see your stats on :

http://127.0.0.1/bf2statistics-web_Beta/bf2statistics/index.php

Thx again. I copied everything over from program files (x86) to program files. The backup finally worked! However, the saga continues When starting the game server, the black box comes up, but in the corner it says "no game". DOH!

Hoot, hoot. finally got my webserver to work. I finished 3 rounds and viewed my stats on my webserver. However, the individual buttons above (ribbons, badges, medals, ect) do not work. When I click on one, I get another webpage saying Gibson has died etc.