| Index
» Projects
» phpMyEdit
» Bug list
» Bug #540 |
 |
|
Viewing Bug Advanced Details |
[ Jump to Bugnotes ]
[ Bug History ]
[ Print ]
|
|
ID |
Category |
Severity |
Reproducibility |
Date Submitted |
Last Update |
|
0000540 |
extension related |
block |
always |
2008-07-01 08:36 |
2008-07-01 08:36 |
|
|
|
Reporter |
vstsjfh |
View Status |
public |
|
|
Assigned To |
|
|
Priority |
normal |
Resolution |
open |
Platform |
|
|
Status |
new |
Duplicate ID |
|
OS |
|
|
Projection |
none |
|
Version |
|
|
ETA |
none |
|
Product Version |
5.7.1 (stable) |
|
|
Product Build |
|
|
|
Votes |
1 |
|
|
|
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
);
$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. |
|
Bug History |
|
Date Modified |
Username |
Field |
Change |
|
2008-07-01 08:36 |
vstsjfh |
New Bug |
|
|
|
Login
Registration
Slovak
