PlusEMU R63B Moodlight issue?

[SectionArmy]

It appears that moodlights cannot be placed inside our hotel, the old owner knew the fix but never told me and it was temporary anyway so when restarted it'd happen again, i've read the logs for PlusEmu and it tells me about truncated data in the enabled column of the moodlight table any help is appreciated cheers.

 

[Yadz]

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.

 

[SectionArmy]

I can't find the my.ini file? only the default file??

 

[Yadz]

I can't find the my.ini file? only the default file??

Follow this:

You must be registered for see links

Google is useful sometimes, you know.

 

[SectionArmy]

I attempted to google it and it didn't appear on there no need for sarcy comments either.

 

[Yadz]

I attempted to google it and it didn't appear on there no need for sarcy comments either.

That link was the first one that came up when I google'd "turn off mysql strict mode", so yeah whatever. I hope you found the answer you were seeking for.

 

[Central]

If you are still having a problem, there is a fix for this. Including other fixes such as Room Plan Editor, pet stuff and all that, also aswell as badges.

You must be registered for see links

This contains the following fixes:

*Display Badges
*Saving Pets
*Edit floor tiles
*Chatlog
*Remove Saddle From Horse
*Saving Saddle
*MassGiveCommand :massgive %TYPE% %AMOUNT%
*GlobalGiveCommand :globalgive %TYPE% %AMOUNT%
*Moodlights
*StringCharFilter
*Horse energy zero
*Moderation Ticket Category