For some reason, when I'm using my vpn, I get this error. Is this a games issue or do I need to do something to MySQL to increase the field size?
Debug info: Data too long for column 'lastremotehost' at row 1
Games cannot write to database
Number of replies: 3Re: Games cannot write to database
The field lastremovehost has size 50
What is the size in your database?
You have Moodle 1 or Moodle 2?
Games cannot write to database LastRemoteHost [Solved]
Did a clean install of Moodle 2.1 and am importing the "old" courses. It's tedious but many of those were done when I was just learning Moodle so it's a good time to do a complete site review.
I changed the field length in MySQL to 75 and that fixed the problem. I'm not a MySQL expert but I trust that won't cause another problem?
When I use the VPN, the hostname is quite long and that was causing the problem. Should've paid more attention to the error dump and realized this earlier, Sorry!
I guess I'm the only one getting this error so it's probably not worth "fixing".
Re: Games cannot write to database LastRemoteHost [Solved]
I changed the code so will use only the 50 first characters of hostname so the problem will never appear again.
I made the fix in both Moodle1 and Moodle2.