| View previous topic :: View next topic |
| Author |
Message |
ShadowDragon311007
Joined: 15 Jul 2009
Posts: 12
|
 Posted: Fri Sep 11, 2009 18:44 Post subject: xp_mysql log error with pc tools save location... |
 |
|
| Code: |
* Executing: SELECT player FROM pwdata WHERE player='taylor die 87' AND tag='Eluldor Di\'ren170559' AND name='HSS_PCTOOLS_PC_LOCATION'
* Executing: UPDATE pwdata SET val='#AREA#Xiliz#POSITION_X# 19.184942245#POSITION_Y# 19.184942245#POSITION_Z# 19.184942245#ORIENTATION# 232.941192627#END#',expire=0 WHERE player='taylor die 87' AND tag='Eluldor Di\'ren170559' AND name='HSS_PCTOOLS_PC_LOCATION'
! SQL Error: Data too long for column 'val' at row 1 (1406).
|
Anyone know how I can fix this error? |
|
| Back to top |
|
 |
Zebranky
Joined: 04 Jun 2006
Posts: 415
|
| Posted: Fri Sep 11, 2009 19:41 Post subject: |
|
|
This might be obvious from the error message, but the problem is that the value you're trying to put in the val field is too long for whatever type val currently has. If it isn't TEXT, you'll want to change it to that.
_________________
Win32 SVN builds: http://www.mercuric.net/nwn/nwnx/
<Fluffy-Kooshy> NWNx plugin is to this as nuclear warheads are to getting rid of fire ants.
<ThriWork> whenever I hear nwn extender, I think what does NWN need a penis extender for? |
|
| Back to top |
|
|
maddogfargo
Joined: 03 Nov 2009
Posts: 49
|
| Posted: Tue Dec 22, 2009 0:05 Post subject: |
|
|
When you get the float for X Y Z and Ori you may want to trim the length and number of decimal places. I seem to recall learning how to do it by examining both NBDE location conversion functions and APS location conversion functions in the respective includes.
* EDIT *
It's in the FloatToString() function.
_________________
* illegible scribble * |
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
