Reloading Waypoints causes a worldserver crash(5.4.8)

[TreeOfLife]

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):

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!

 

[Damieninabox]

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).

 

[TreeOfLife]

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?

 

[Damieninabox]

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.

 

[TreeOfLife]

Oh I see, that clarifies.
Thank you for the heads up!

 

[Damieninabox]

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.

 

[TreeOfLife]

Will do, thank you kindly!