data truncated in Sessions table

[rainbowskydancer]

While screwing around in Radegast, all at once I stopped being able to TP from one sim to another - whereas I was able to before, using the same client (and others). Today, I was unable to until just now. Spent a good bunch of hours trying to debug it, then browsing the table data, after feeling frustrated, I stumble on some truncated entry in the Sessions; the SceneLocation and SceneLookAt column entries were both truncated. I look at the definition, and the data size, and obviously something wrong there, as x alone for both some something like 0.5435098729707234 - easily that long. So I increased it from the VARCHAR(45) to VARCHAR(90) (giving some leeway), and now it works. I guess one could truncate down x, y, and z a bit and restore the 45, but one could also do a schema change to accommodate future data.

[rainbowskydancer]

I was going to close it but I suppose you folks could as you probably want to consider your options regarding this.