Bugs in MFG

02 August 2010

Under Windows OS, if only garbage is output to the display when creating forms AND writing them to disk, locate in generator.inc.php a line reading "flush($filehandle);" and comment out that line.

22 August 2008 - mfg571-alt.zip project (NOT mfg571.zip)

// generator.inc.php approximately line 21, methods employed
// to check $schema_text for a DATE field need improvement.
$schema_text = mysql_tb_schema($tb) or die(mysql_error());
// Determine if a date picker is required for this table
// The following by itself may be inadequate
$pos = strpos($schema_text, ' date ');
// check again
if(empty($pos)){
$pos = strpos($schema_text, ' date,');
}

10 June 2008 - An errant "continue;" statement crept into the download at SWREG.ORG, producing the following error in forms that contain BLOB/TEXT fields: Parse error : syntax error, unexpected ';', expecting ')' in /home/editor01/public_html/admin/mfg571/output/my_form.php on line XXX. In this event, check the file at /mfg571/inc/generator.inc.php around line 458. If you find the following, remove the "continue;" statement.

BEFORE:

if($fd_type == 'blob'){

   continue; // omit 'maxlen' option for BLOB fields

}

AFTER:

if($fd_type == 'blob'){

   // omit 'maxlen' option for BLOB fields

}

Also, you may want to add an "@" sign in two places, by a couple mysql_fetch_array() statements to suppress possible errors.

line 131: $row = @mysql_fetch_array($tb_desc);

line 198: $row = @mysql_fetch_array($tb_desc, MYSQL_BOTH);

01 June 2008 - MS Internet Explorer 8 will be rolling out later this year. Placement of the following META tag within the HEAD section of the supplied headers is recommended. Web developers around the world will be cussing the new MS standards (either redesigning every page on the Internet, or adding the following tag). The Beta version of IE 8 doesn't handle TEXTAREA's very well (runs slow and stupid).

<meta http-equiv="X-UA-Compatible" content="IE=7">

04 May 2008 - The label used in the page header (View, Change, Copy, Delete) is currently displayed in English, using the value of $operation as defined in header2.php. In order to translate the header label to Spanish (for example) make a backup copy of header2.php and replace the code in header2.php with the code in header2.txt.

27 April 2008 - not a bug, but an improvement: implement a Javascript calendar date picker by following instructions posted in this Forum thread.

10 April 2008 - see corrections for typo's in the class file, posted in the forum

16 Nov 2007 - Near line 456 of generator.inc.php, omit 'maxlen' settings for BLOB fields.

Existing line:
if($fd_type == 'int' && $k > 0){ // to skip column 0 add: && $k > 0

Recommended change:
if($fd_type == 'blob'){
   // omit 'maxlen' option for BLOB fields
}elseif($fd_type == 'int' && $k > 0){ // to skip column 0 add: && $k > 0

MFG was updated 01 October 2007 primarily to fix problems with UTF-8 character set support.

Bugs listed below apply primarily to MFG purchases made prior to 01 October 2007. See MySQL™ Connection Character Sets and Collations for further information (affects MySQL™ versions 4-5).

# number_format and field length for HTML INPUT elements

if($fd_type == 'int'){

   echo_buffer("  'number_format|VLF' => array(0, '.', ','),");

}elseif($fd_type == 'real'){

...

12 April 2007 - If using MySQL version 4.1+, the maximum length ('maxlen') and 'size' settings in the field arrays are incorrectly determined when the table CHARSET=utf8 and collation is utf8. I have no idea why this is. It may be a bug with PHP.

// PHP's mysql_field_len() function appears to have a bug and returns a value 3 times the true value.
// $fd_len = mysql_field_len($fds, $k); // Default help - Limit $fd_len characters.

$fd_type = mysql_field_type($fds, $k);

// Work-around for mysql_field_len() bug:

if(stristr($fd_type, 'string')){
	$fd_len = mysql_field_len($fds, $k) / 3; // Default help - Limit $fd_len characters.
}else{
	$fd_len = mysql_field_len($fds, $k); // Default help - Limit $fd_len characters.
}

12 Jan 2007 - Around Line 124 in help_data.php an incomplete list of field names appears in the INSERT statement. It should (instead) read as follows:

$buffer .= "\r\n".'INSERT INTO `'.$help_table.'` (
`hid`, `tb_name`, `fd_num`, `fd_name`, `fd_name2`, `help_text`, `example`, `language`, `lang_code`, `char_set`, `dir`, `deleted`, `updated`
) VALUES
'."\r\n";

Language file labels and the UTF-8 character set

Problems with the display of language file labels under the UTF-8 character set definition can be overcome by opening the language files and applying utf8_encode() to words such as which contain non-English / accented characters. See also this forum post.

PHP Form Generator Home | PHP Form Generator Demo