Hadeszeus 15 Posted September 28, 2014 Got this error[SQL]: DB error - Incorrect table name ''[Debug]: at npc.c:1432 - SELECT `name`, `itemid`, `amount` FROM `` When I check that line I saw this void npc_market_fromsql(void) { SqlStmt* stmt = SQL->StmtMalloc(map->mysql_handle); char name[NAME_LENGTH+1]; int itemid; int amount; if ( SQL_ERROR == SQL->StmtPrepare(stmt, "SELECT `name`, `itemid`, `amount` FROM `%s`", map->npc_market_data_db) || SQL_ERROR == SQL->StmtExecute(stmt) ) { SqlStmt_ShowDebug(stmt); SQL->StmtFree(stmt); return; } I check my database and I have npc_market_data <-- table I also created npc_market_data_db but stil getting npc.c error on this line. Quote Share this post Link to post Share on other sites
0 AnnieRuru 957 Posted September 28, 2014 https://github.com/HerculesWS/Hercules/blob/master/conf/inter-server.conf#L130 https://github.com/HerculesWS/Hercules/blob/master/sql-files/main.sql#L588 Quote Share this post Link to post Share on other sites
0 Hadeszeus 15 Posted September 29, 2014 https://github.com/HerculesWS/Hercules/blob/master/conf/inter-server.conf#L130 https://github.com/HerculesWS/Hercules/blob/master/sql-files/main.sql#L588 Quote Share this post Link to post Share on other sites
I check my database and I have npc_market_data <-- table
I also created npc_market_data_db
but stil getting npc.c error on this line.
Share this post
Link to post
Share on other sites