1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice

hlds setup error

Discussion in 'Plesk for Linux - 8.x and Older' started by PHATWCINFRCR, Feb 10, 2005.

  1. PHATWCINFRCR

    PHATWCINFRCR Guest

    0
     
    After going into the modules and setting up HLDS and CStrike, I got the following error.

    ERROR
    Up LevelUp Level
    Unable to query: Unknown column 'begin_period_date' in 'field list'
    0: /usr/local/psa/admin/plib/common_func.php3:177 psaerror(string "Unable to query: Unknown column 'begin_period_date' in 'field list'")
    1: /usr/local/psa/admin/plib/modules/cs-gs/ServersList.php:49 db_query(string "SELECT id, game, name, ip_address, port, max_players, if(@fromdate <= begin_period_date, period_traffic, 0) FROM module_cs_gs_servers;")
    2: /usr/local/psa/admin/plib/class.cList.php3:77 serverslist->fetchserverslist()
    3: /usr/local/psa/admin/plib/class.cList.php3:96 serverslist->fetchlist()
    4: /usr/local/psa/admin/htdocs/modules/cs-gs/servers.php:158 serverslist->init()

    rebooted the server, still the sabe thing. IAny idea's?

    Using PLESK 7.5.2 reloaded.
     
  2. AlanSanders

    AlanSanders Guest

    0
     
    You can fix the errors by adding 4 field names to the Table module_cs_gs_servers in database psa. I use Webmin to easily access the MySQL server.
    The fields are

    begin_period_date
    period_traffic
    total_traffic
    end_period_date

    I used int as type. You may have to play with this database and you MUST backup the psa database before starting.

    I was then able to start the server, but more problems which may be the result of my adding the 4 fields incorrectly.

    Good luck
     
Loading...