[Archive] Reloading Waypoints causes a worldserver crash(5.4.8)
[Archive] Reloading Waypoints causes a worldserver crash(5.4.8)
Original source
Hello everyone,
Recently I tried to make a NPC walk along a certain path following this guide. The first step in said guide is to add waypoint nodes based on the NPC's DBGUID.
I faithfully followed these instructions with the following NPC's:
-Imp Minion(Entry 2)
-Tournament Supervisor(Entry 4)
- Drywallow Daggermaw(Entry 4345)
Everything was going smoothly up to this point.
The moment I tried to reload the waypoint however the worldserver crashed outputting the following error(It occurs consistently with any NPC):
Code:
E:\EmucoachMoPRepack\TICore\src\server\database\Database\PreparedStatement.cpp:283 in MySQLPreparedStatement::CheckValidIndex ASSERTION FAILED:
index < m_paramCount || ParamenterIndexAssertFail(m_stmt->m_index, index, m_paramCount)
INFO [commands.gm] Command: .wp reload 500763 [Player: Admin (GUID Full: 0x0180000000000007 Type: Player Low: 7) (Account: 1) X: 9954.308594 Y: 2433.430664 Z: 1324.737427 Map: 1 (Kalimdor) Area: 1657 (Darnassus) Zone: Unknown Selected: Drywallow Daggermaw (GUID Full: 0xF13010F90000043E Type: Creature Entry: 4345 Low: 1086)]
ERROR [sql.driver] Attempted to bind parameter 1nd on a PreparedStatement 74 (statement has only 0 parameters)
Afterwards the worldserver becomes unresponsive and requires a reboot.
Initially I thought that this issue could be related to the fact that I was using Linux containers to host the worldserver, but I recreated the issue on a Windows machine as well.
Any thoughts or suggestions would be greatly appreciated!
rektbyfaith
11-04-2025, 05:12 PM #1Archived author: TreeOfLife • Posted: 2025-11-04T18:12:42.512454
Original source
Hello everyone,
Recently I tried to make a NPC walk along a certain path following this guide. The first step in said guide is to add waypoint nodes based on the NPC's DBGUID.
I faithfully followed these instructions with the following NPC's:
-Imp Minion(Entry 2)
-Tournament Supervisor(Entry 4)
- Drywallow Daggermaw(Entry 4345)
Everything was going smoothly up to this point.
The moment I tried to reload the waypoint however the worldserver crashed outputting the following error(It occurs consistently with any NPC):
Code:
E:\EmucoachMoPRepack\TICore\src\server\database\Database\PreparedStatement.cpp:283 in MySQLPreparedStatement::CheckValidIndex ASSERTION FAILED:
index < m_paramCount || ParamenterIndexAssertFail(m_stmt->m_index, index, m_paramCount)
INFO [commands.gm] Command: .wp reload 500763 [Player: Admin (GUID Full: 0x0180000000000007 Type: Player Low: 7) (Account: 1) X: 9954.308594 Y: 2433.430664 Z: 1324.737427 Map: 1 (Kalimdor) Area: 1657 (Darnassus) Zone: Unknown Selected: Drywallow Daggermaw (GUID Full: 0xF13010F90000043E Type: Creature Entry: 4345 Low: 1086)]
ERROR [sql.driver] Attempted to bind parameter 1nd on a PreparedStatement 74 (statement has only 0 parameters)
Afterwards the worldserver becomes unresponsive and requires a reboot.
Initially I thought that this issue could be related to the fact that I was using Linux containers to host the worldserver, but I recreated the issue on a Windows machine as well.
Any thoughts or suggestions would be greatly appreciated!
Original source
Since this Repack is not getting any updates, I would advise you to just insert the waypoints manually inside the database and restart the worldserver.
That's how I always do it when scripting Waypoint movement (SAI wise - not core wise).
rektbyfaith
11-04-2025, 05:12 PM #2Archived author: TreeOfLife • Posted: 2025-11-04T18:12:42.512454
Original source
Since this Repack is not getting any updates, I would advise you to just insert the waypoints manually inside the database and restart the worldserver.
That's how I always do it when scripting Waypoint movement (SAI wise - not core wise).
Original source
That's a bummer, but fair enough! Thanks for the advise
![[Image: 1f642.png]](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)
.I'm relatively new to private hosting and can't help but be curious, if you don't mind, could you explain the difference between SAI and core movement scripting?
rektbyfaith
11-04-2025, 05:12 PM #3Archived author: TreeOfLife • Posted: 2025-11-04T18:12:42.512454
Original source
That's a bummer, but fair enough! Thanks for the advise .
I'm relatively new to private hosting and can't help but be curious, if you don't mind, could you explain the difference between SAI and core movement scripting?
Original source
Well it's fairly easy, whenever I do movement scripts, I walk/fly the route that I want the npc to follow and from time to time I use .gps to get the coordinates and insert the waypoints inside the waypoints table inside the database.
Core movement would use another table for that, but since you are using a repack, you can't script movement coresided.
rektbyfaith
11-04-2025, 05:12 PM #4Archived author: TreeOfLife • Posted: 2025-11-04T18:12:42.512454
Original source
Well it's fairly easy, whenever I do movement scripts, I walk/fly the route that I want the npc to follow and from time to time I use .gps to get the coordinates and insert the waypoints inside the waypoints table inside the database.
Core movement would use another table for that, but since you are using a repack, you can't script movement coresided.
Original source
Oh I see, that clarifies.
Thank you for the heads up!
rektbyfaith
11-04-2025, 05:12 PM #5Archived author: TreeOfLife • Posted: 2025-11-04T18:12:42.512454
Original source
Oh I see, that clarifies.
Thank you for the heads up!
Original source
If you need any help scripting SAI movement or any kind of database stuff (since you can't modify your source) make sure to contact me, anytime.
rektbyfaith
11-04-2025, 05:12 PM #6Archived author: TreeOfLife • Posted: 2025-11-04T18:12:42.512454
Original source
If you need any help scripting SAI movement or any kind of database stuff (since you can't modify your source) make sure to contact me, anytime.
Original source
Will do, thank you kindly!
rektbyfaith
11-04-2025, 05:12 PM #7Archived author: TreeOfLife • Posted: 2025-11-04T18:12:42.512454
Original source
Will do, thank you kindly!
1 Guest(s)
1 Guest(s)