Moodlights wont place in room

[Nicholas]

Is their a logical reason why it says "you can not place this item here" messages on the side when i try to place the moodlight

 

[Joe]

Any error logs? What build of emulator?

 

[Jozh]

give this a shot.

Turn off mysql strict mode. Run this query in your database: SET@@global.sql_mode=''; but note that you'll need to run this query every time mysql restarts, to avoid this, you can turn strict mode off in your my.ini file in mysql.

if the problem pressits drop me a message :]

 

[Joe]

I thought it would be that @GIF but wasn't entirely sure if there were other things causing this.
Open my.ini in MySQL

Replace

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

with

sql_mode=""

restart MySQL

 

[Nicholas]

I fixed it it was the mysql strict mode. Thanks!