phpMyEdit - Viewing Bug Advanced Details			[ Go Back ]
ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
539	extension related	block	always	2008-07-01 08:35	2008-07-01 08:35
Reporter:	vstsjfh	Platform:
Assigned To:		OS:
Priority:	normal	Version:
Status:	new	Product Version:	5.7.1 (stable)
Product Build:		Resolution:	open
Projection:	none	Duplicate ID:
ETA:	none
Summary:	Reports not available
Description:	MySQL error 1064 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 '1' at line 1 Warning: array_keys(): The first argument should be an array in /usr/HTTPServer/httpd-sts/sts/phpMyEdit-5.7.1/extensions/phpMyEdit-report.class.php on line 147 phpMyEdit error: database fetch error
Steps To Reproduce:	When invoking phpMyedit-report.class.php
Additional Information / Solution:	Code: $opts['fdd']['function_id'] = array( 'name' => 'Function ID', 'input' => 'H', 'select' => 'T', 'options' => 'AVCPDR', // auto increment 'maxlen' => 6, 'default' => '0', 'sort' => true ); $dbfield = "spj"; $dbtable = "Subprojects"; $name = "Subproject"; $opts['fdd'][$dbfield.'_id'] = array( 'name' => $name, 'maxlen' => 6, 'select' => 'D', 'values' => array( 'table' => $dbtable, 'column' => $dbfield.'_id', // 'description'=> $dbfield.'_name', 'description' => array( 'columns' => array($dbfield.'_code', $dbfield.'_name'), 'divs' => array(' * '), ), 'orderby'=> $dbfield.'_code'), 'sort' => true ); // scenario_id $dbfield = "scenario"; $dbtable = "Scenarios"; $name = "Scenario"; $opts['fdd'][$dbfield.'_id'] = array( 'name' => $name, 'maxlen' => 6, 'select' => 'D', 'values' => array( 'table' => $dbtable, 'column' => $dbfield.'_id', 'description'=> $dbfield.'_name', 'orderby'=> $dbfield.'_name'), 'sort' => true ); // activity_id $dbfield = "activity"; $dbtable = "Activities"; $name = "Activity"; $opts['fdd'][$dbfield.'_id'] = array( 'name' => $name, 'select' => 'D', 'values' => array( 'table' => $dbtable, 'column' => $dbfield.'_id', 'description' => array( 'columns' => array($dbfield.'_name', $dbfield.'_desc', 'outcome'), 'divs' => array(' = ', '. <b>Outcome expected</b> = '), ), // 'filters' => $filter, 'orderby'=> $dbfield.'_name'), 'sort' => true ); $opts['fdd']['item_id'] = array( 'name' => 'Item', 'select' => 'D', 'values' => array( 'table' => 'Items', 'column' => 'item_id', 'description'=> 'item_desc', // 'filters' => $filter, 'orderby'=> 'item_desc'), 'sort' => true ); $opts['fdd']['outcome'] = array( 'name' => 'Outcome', 'select' => 'T', 'maxlen' => 200, 'required' => $required, 'sort' => true ); // Now important call to phpMyEdit require_once 'extensions/phpMyEdit-report.class.php'; new phpMyEdit_report($opts); ?>
Attached Files:

There are no notes attached to this bug.