Error during table creation

[laedit]

Hi,

I have created a sandbox project (millesabords) to poke around, and I didn't know what I have done but when I try to create a table or run a test session I have this error:

Code: Select all

Error while processing SQL request: 
INSERT INTO w_table_option (table_option_table_id, table_option_id, table_option_value) 
VALUES ('75314','201','0'),('75314','200','17'),('75314','204','0'),('75314','206','0'),('75314','205','1'),('75314','100',''),('75314','101','')
Incorrect integer value: '' for column 'table_option_value' at row 6

I have checked the sql and error logs and search the database but haven't find anything.

Did I do something wrong?
How can I fix it?

Thanks!

[tchobello]

Hello and welcome !

('75314','100',''),
('75314','101','')

the last value for this two rows must be an integer and not ''.

[laedit]

Thanks for the answer!
I got that part, but I didn't made the sql request since I work in the sandbox, and it happens only during table creation and I haven't any control on that, or so I didn't find anything.
So I am stuck here and didn't know what I can do.

[laedit]

So it seems that if you define a game variant, you have to define at least one option too but it isn't enforced by the sandbox.
Thanks and sorry for the question.