Jump to content

Psyz

Members
  • Content Count

    48
  • Joined

  • Last visited


Reputation Activity

  1. Upvote
    Psyz reacted to 4144 in chatlog error special characters   
    try change charset in database property, in table propery and each columns
     
    also probably better set some good charset in mysql.conf or mariadb.conf (depend what sql software you using)
     
    If you not sure what charset to set, try utf8mb4 or utf8mb4_general_ci. it should support any languages
     
  2. Upvote
    Psyz reacted to AnnieRuru in Crash map-server   
    /** * Loads persistent NPC Barter Data from SQL **/ static void npc_barter_fromsql(void) { struct SqlStmt *stmt = SQL->StmtMalloc(map->mysql_handle); char name[NAME_LENGTH + 1]; int itemid; int amount; int removeId; int removeAmount; if (SQL_ERROR == SQL->StmtPrepare(stmt, "SELECT `name`, `itemId`, `amount`, `priceId`, `priceAmount` FROM `%s`", map->npc_barter_data_db) || SQL_ERROR == SQL->StmtExecute(stmt) ) { SqlStmt_ShowDebug(stmt); SQL->StmtFree(stmt); return; } npc_barter_data_db is
    https://github.com/HerculesWS/Hercules/blob/stable/conf/common/inter-server.conf#L120
    npc_barter_data_db: "npc_barter_data"  
    means you are missing a table name `npc_barter_data`
    https://github.com/HerculesWS/Hercules/blob/stable/sql-files/upgrades/2018-12-29--07-51.sql
     
    how can you ignore the SQL update file ?
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.