Board Game Arena

Posted: **10 April 2020, 16:20**

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!

Posted: **10 April 2020, 16:34**

Hello and welcome !

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

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

Posted: **10 April 2020, 17:58**

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.

Posted: **11 April 2020, 05:06**

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.

Board Game Arena

Error during table creation

Error during table creation

Re: Error during table creation

Re: Error during table creation

Re: Error during table creation