Local MySQL insert to tables

We setup a local server to host Xibo and starting to test inserts to the various tables to programmatically add rows. (layout, region, playlist, etc)

I am currently getting an error trying to insert a region:
1 row(s) affected, 1 warning(s): 1364 Field ‘left’ doesn’t have a default value

my insert statement:
set @layId = (select layoutId from layout where layout = ‘sql layout’ limit 1);
insert into region (layoutId, ownerId, name, width, height, duration, top, zIndex)
values (@layId, 1, ‘sql region’, 1920, 1080, 60, 0, 0);

but if i add ‘left’ to the fields i get a different error:
Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘left) values (@layId, 1, ‘sql region’, 1920, 1080, 60, 0, 0, 0)’ at line 1

my insert statement:
set @layId = (select layoutId from layout where layout = ‘sql layout’ limit 1);
insert into region (layoutId, ownerId, name, width, height, duration, top, zIndex, left)
values (@layId, 1, ‘sql region’, 1920, 1080, 60, 0, 0, 0);

The last thing I noticed is for rows that insert correctly they show in the database but not on the UI side?

any thoughts would be appreciated.