Forums
| BF2Statistics.com :: Forums :: General :: Tech Support |
|
<< Previous thread | Next thread >> |
| Advice needed on a mysql syntax error | ||
| Go to page >> | |
|
Moderators: MrNiceGuy, Twhyman, Chump, hurr1k4ne, The Shadow, Wilson212
|
| Author | Post | ||
| rf40 |
| ||
  Registered Member #3988 Joined: Sun Oct 07 2007, 06:10PMPosts: 14 | 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 | ||
| Back to top | | ||
| musikmann |
| ||
 Registered Member #3972 Joined: Thu Oct 04 2007, 06:47PMLocation: Southern...NH Posts: 60 | 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 ] | ||
| Back to top |
| ||
| rf40 |
| ||
| Registered Member #3988 Joined: Sun Oct 07 2007, 06:10PMPosts: 14 | 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 ] | ||
| Back to top | | ||
| Seraphiel |
| ||
  Registered Member #4017 Joined: Sun Oct 14 2007, 01:18PMPosts: 60 | 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. =] | ||
| Back to top | | ||
| Pheps |
| ||
Pheps Registered Member #3855 Joined: Mon Sep 10 2007, 10:48AMLocation: Sweden Posts: 30 | 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 ] | ||
| Back to top |
| ||
| rf40 |
| ||
| Registered Member #3988 Joined: Sun Oct 07 2007, 06:10PMPosts: 14 | 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 ==  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 1Also, 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 | ||
| Back to top | | ||
| rf40 |
| ||
| Registered Member #3988 Joined: Sun Oct 07 2007, 06:10PMPosts: 14 | 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 | ||
| Back to top | | ||
| Seraphiel |
| ||
| Registered Member #4017 Joined: Sun Oct 14 2007, 01:18PMPosts: 60 | 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 : | ||
| Back to top | | ||
| rf40 |
| ||
| Registered Member #3988 Joined: Sun Oct 07 2007, 06:10PMPosts: 14 | 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! | ||
| Back to top | | ||
| rf40 |
| ||
| Registered Member #3988 Joined: Sun Oct 07 2007, 06:10PMPosts: 14 | 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. | ||
| Back to top | | ||
| Go to page >> | |
|
|
|
Powered by e107 Forum System
