I tried to add a form this morning to my 2.04 Form Tools install. The form stalled at the last step with an error msg that boiled down to: 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 'TYPE=MyISAM DEFAULT CHARSET=utf8' at line 16"
The line of code the error referred to in /global/code/forms.php -
TYPE=MyISAM DEFAULT CHARSET=utf8";
A touble ticket to my host server confirmed, they had upgraded to MySQL 5.5 and said I would need to Search for TYPE=MyISAM Replace with ENGINE=MyISAM
I searched and found that in most places where TYPE=MyISAM appears, the next line is ENGINE=MyISAM. But not in the forms.php file.
So in that file, I changed TYPE=MyISAM to ENGINE=MyISAM and all was well, I completed setting up the new form.
My question is, should I search the entire install and change every instance of TYPE=MyISAM and replace it with ENGINE=MyISAM if that line is not already there? Is there any script I should not edit?
This might be a no-brainer for most of you, but I hate to tinker around in the code of a system that is supporting 45 live forms that really need to stay working.
Thanks,
Kathryn
The line of code the error referred to in /global/code/forms.php -
TYPE=MyISAM DEFAULT CHARSET=utf8";
A touble ticket to my host server confirmed, they had upgraded to MySQL 5.5 and said I would need to Search for TYPE=MyISAM Replace with ENGINE=MyISAM
I searched and found that in most places where TYPE=MyISAM appears, the next line is ENGINE=MyISAM. But not in the forms.php file.
So in that file, I changed TYPE=MyISAM to ENGINE=MyISAM and all was well, I completed setting up the new form.
My question is, should I search the entire install and change every instance of TYPE=MyISAM and replace it with ENGINE=MyISAM if that line is not already there? Is there any script I should not edit?
This might be a no-brainer for most of you, but I hate to tinker around in the code of a system that is supporting 45 live forms that really need to stay working.
Thanks,
Kathryn