Database version?

Discussion in 'BF2Statistics discussion' started by LevAnni, May 26, 2019.

  1. LevAnni

    LevAnni Member

    Hi.

    After successful installation, admin page says "The current database version is higher than the expected database version!!!". What does this means? Installation PASSed everything with just warning on this database version.


    Thanks!
     
    kjhedges likes this.
  2. kjhedges

    kjhedges Member

    I have found that if you go into the database, under the table called version and delete the ones above version 3.3 this worked for me
     
  3. LevAnni

    LevAnni Member

    I have following rows

    updated version
    30,000 3.0.0
    30,010 3.0.1
    30,020 3.0.2
    30,030 3.0.3
    30,040 3.0.4
    30,050 3.0.5


    you say leave this way?
    30,030 3.0.3
    30,040 3.0.4
    30,050 3.0.5
     
  4. kjhedges

    kjhedges Member

    Nope, leave

    30,000 3.0.0
    30,010 3.0.1
    30,020 3.0.2
    30,030 3.0.3

    so the last version is 3.0.3 that worked for me anyways.

    Not sure why the version mis-match
     
  5. LevAnni

    LevAnni Member

    ok thanks!
     
  6. LevAnni

    LevAnni Member

    look, I've changed that and now I'm able to see some pages.. and at the stats admin page, I see there is a field "Ranked Status" which says NOT AUTHORIZED. Do you know what does it means?
     
  7. LevAnni

    LevAnni Member

    Ogh god, I think I had to change DB version earlier during testing... and also click AUTHORIZE. Because now it's green. Is this means that the stats were not recording because of this?
     
  8. kjhedges

    kjhedges Member

    There are other reason that stats are not stored aswell. So while it could have been a cause, its not for sure.

    Have you checked the stats log files.
     
  9. LevAnni

    LevAnni Member

    There were a lot of snapshots waiting for authorization. Good news is that I was able to import them successfully. So now BFHQ shows them very well. I hope snapshots will move automatically now
     
  10. kjhedges

    kjhedges Member

    Glad to hear that you are now making some better progress
     
    LevAnni likes this.
  11. LevAnni

    LevAnni Member

    kj, I'm trying to change BF2.exe directly, to avoid gamespy redirector program to be involved, players are complain it's hard to fill out with ip addresses and so on.

    I have changed in HEX editor all domains pointing to gamespy, but so far, I'm able to just login with player to our stats sever, but BFHQ is empty. So I wonder what is wrong.

    If I go to address which BF2.exe needs to get player info:

    https://bf2.load.ge/ASP/getplayerinfo.aspx?pid=2900000

    I'm getting this error:

    E 107
    H asof err
    D 1559723344 Invalid Syntax!
    $ 38 $


    any ideas?
     
  12. LevAnni

    LevAnni Member

    oghhh. it was my faulf, it need additional parameters to be passed. but why is BFHQ empty??....
     
  13. kjhedges

    kjhedges Member

    You can edit the server exe file to do redirects. this will be server backend so to speak.

    You also edit bf2.exe for clients with all relevant redirects.

    This should then bypass all gamespy and other redirects and stats on web and in BFHQ should work
     
  14. LevAnni

    LevAnni Member

    ok, I've done redirect in client exe file.

    very strange thing is happening....


    I'd like my server backend to be HTTPS. So I've configured my IIS server to redirect all HTTP requests to HTTPS. (https://bf2.load.ge/ASP instead of http://bf2.load.ge) This works great if I use Gamespy redirector, BUT doesn't work when I'm launching game with changed BF.exe to point to my server. If I remove HTTPS redirect in IIS - all starting to work.
     
  15. LevAnni

    LevAnni Member

    also, BF2.exe doesn't like when I'm pointing to HTTPS protocol at all
     
  16. kjhedges

    kjhedges Member

    Im not familiar with editing exe files with https. Never ventured into it, as we dont have issues with basic http.

    I think a new topic with regards the https and IIS as we sliding off topic here.

    Sorry I couldnt help more in the https
     
  17. LevAnni

    LevAnni Member

    in case you'll face same thing....

    Seems like BF client doesn't like communication with https protocol. So what was gappening:

    My IIS server listens both by its IP address and host name.

    So in case of Gamespy redirector - the requests was made by IP address. Since I have configured IIS to allow HTTPS communication only for domain names, it was working.

    When I have changed BF2.exe itself, and put there domain name, of course it was trying to get aspx files with HTTPS protocol.

    So now I made rules to let ASP directory work without HTTPS protocol and now everything is working.

    I just wonder why BF client does't like secure connections....
     
    kjhedges likes this.
  18. LevAnni

    LevAnni Member

    kj, how did you managed to join my server, with redirector of course, right?
     
  19. kjhedges

    kjhedges Member

    I did use the redirector from bf2statistics, yes
     
  20. LevAnni

    LevAnni Member

    Look, seems like stats doesn't automatically process snapshots, I have to manually authenticate them in "Snapshots Awaiting Authorization" page :/ do you know why it might be happening?
     

Share This Page