ZeroK-RTS / Zero-K-Infrastructure

Website, lobby launcher and server, steam deployment, .NET based tools and other vital parts of Zero-K infrastructure
GNU General Public License v3.0
53 stars 52 forks source link

forum crashes with sql error #2693

Open mojjj opened 4 years ago

mojjj commented 4 years ago

replying with the single word stocks results in an sql error

https://i.imgur.com/hxK6x2U.png

http://zero-k.info/Forum/Thread/31711

https://paste.ubuntu.com/p/w8MGSsZmy8/

Legomenon-gh commented 4 years ago

This doesn't repro on the test server with an older database (or locally obviously) even after using the word stocks in multiple posts.

The stacktrace is hit from https://github.com/ZeroK-RTS/Zero-K-Infrastructure/blob/master/Zero-K.info/AppCode/ForumPostIndexer.cs#L64 so I guess there's something weird in the live database in the ForumPostWords table for stocks?

I'll troubleshoot this more if someone can give me a current dump of that table, this looks pretty funny