[MySQL R33] Loading businesses problem
#1

Fixed!
Reply
#2

Show us how the table created, and btw add a line bizid++ in for (new i)
Reply
#3

Quote:
Originally Posted by Shinja
Посмотреть сообщение
Show us how the table created, and btw add a line bizid++ in for (new i)
Reply
#4

X, Y, Z, EX, EY and EZ should be floats
Reply
#5

Quote:
Originally Posted by Shinja
Посмотреть сообщение
X, Y, Z, EX, EY and EZ should be floats
Yep! my bad... I fixed this, but nothing is loaded in game.
Reply
#6

DOUBLE and FLOAT are both floating-point types. The problem is that field IDs start from 0 instead of 1 so you most likely get errors (in mysql log) for wrong data types.
Reply
#7

Quote:
Originally Posted by Konstantinos
Посмотреть сообщение
DOUBLE and FLOAT are both floating-point types. The problem is that field IDs start from 0 instead of 1 so you most likely get errors (in mysql log) for wrong data types.
So what should I do to fix?
Reply
#8

You need to subtract the field id by 1 so:

1 becomes 0
10 becomes 9
and so on.
Reply
#9

Quote:
Originally Posted by Konstantinos
Посмотреть сообщение
You need to subtract the field id by 1 so:

1 becomes 0
10 becomes 9
and so on.
Thank you! I solved the problem
Reply


Forum Jump:


Users browsing this thread: 3 Guest(s)