8:00 – 5:30 VISIBILITY

• Working on the MySql packet issue: http://dev.mysql.com/doc/refman/5.5/en/packet-too-large.html
• This is where you put the option files for windows version of mySql: http://dev.mysql.com/doc/refman/5.0/en/option-files.html
  • It appears that for windows, the file is here: /Windows/my.ini
  • This didn’t work as I was starting and stopping mySql through the xammp control panel
• That didn’t work, possibly becayse of xampp? Added –max_allowed_packet=16M to the mysql_start.bat file
  • Didn’t work either
• Tried adding argument to /xampp/mysql – nope
• Ran the mysql_start.bat file from the command line. That worked, so there’s something that xampp is doing in the control panel.
• New error: 4484 [main] ERROR com.fgm.ScriptEngineServer.PublishSupportObject  – Data truncation: Data too long for column ‘content’ at row 1
  • Changing to table_publish.content to longblob fixed that. (alter table table_publish modify content longblob;)
  • Changed code to create content as a LONGBLOB
• Back to setting xampp service arguments. Trying /xampp/mysql/bin/my.ini And to be thourough, I’m going to bounce the box.
  • And that worked just fine. Whee!
  • Need to install changes on site and test. Done and working
  • Need to change code and settings on fgmdev. Done but not tested