[gelöst]csv-Export erstellt nicht die angegebenen Leerzeilen

function buschcsv_my_form_submit($form, &$form_state) {
$kw = $form_state['values']['kw'];
$stw = $form_state['values']['stichwort'];

$sql="SELECT busch_lgort.numkreis,kd_liefnr.kd_liefnr,tagesprotokolle.artikel,
kd_eigene_art.kd_art_nr,tagesprotokolle.mc1,'\r\n','\r\n',busch_lgort.lagerort,'\r\n',
tagesprotokolle.menge,tagesprotokolle.au,'|'
FROM tagesprotokolle
LEFT JOIN kd_eigene_art ON
tagesprotokolle.artikel = kd_eigene_art.artikel
AND tagesprotokolle.kdnr = kd_eigene_art.kunde
LEFT JOIN kd_liefnr ON
tagesprotokolle.kdnr = kd_liefnr.kdnr
LEFT JOIN busch_lgort ON
tagesprotokolle.stichwort = busch_lgort.lagerort
AND tagesprotokolle.kdnr = busch_lgort.kunde
WHERE tagesprotokolle.stichwort = '".$stw."' AND tagesprotokolle.kw ='".$kw."'";

$filecsv = 'busch_'.date("dmY_Hi").'.csv';
$filename = 'busch_kw'.$kw.'_'.$stw;
$result = db_query($sql);
$fp = fopen($filecsv, 'w');

while ($row = $result->fetchAssoc()) {
fputcsv($fp, $row,';')."\n";}
fclose($fp);

$node = new stdClass();
$node->type = 'download_busch';
node_object_prepare($node);
$node->title = $filename;
$node->language = LANGUAGE_NONE;
$filepath = drupal_realpath($filecsv);
// Create managed File object and associate with Image field.
$file = (object) array(
'uid' => 1,
'display' => 1,
'filename' => $filename,
'uri' => $filepath,
'filemime' => file_get_mimetype($filepath),
'status' => 1,
);

$file = file_move($file, 'public://');

$node->field_csvfile[LANGUAGE_NONE][0] = (array)$file;

$path = 'content/' . $filename;
$node->path = array('alias' => $path);
node_save($node);
drupal_set_message('Datei wurde erstellt');
drupal_goto('buscharchiv');

}

function buschcsv_views_api() {
return array('api' => 3.0,
'path' => drupal_get_path('module', 'buschcsv'),

);
}

function buschcsv_views_plugins_alter(&$plugins) {
$plugins['display']['embed'] = array_merge($plugins['display']['embed'], array(
'handler' => 'embed_views_plugin_display_embed',
'theme' => 'views_view',
));
}

PDOException: SQLSTATE[42000]: Syntax error or access violation: 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 'TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' L' at line 4: SELECT busch_lgort.numkreis,kd_liefnr.kd_liefnr,tagesprotokolle.artikel, kd_eigene_art.kd_art_nr,tagesprotokolle.mc1,' ',' ',busch_lgort.lagerort,' ', tagesprotokolle.menge,tagesprotokolle.au,'|' FROM tagesprotokolle FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY ' ' LEFT JOIN kd_eigene_art ON tagesprotokolle.artikel = kd_eigene_art.artikel AND tagesprotokolle.kdnr = kd_eigene_art.kunde LEFT JOIN kd_liefnr ON tagesprotokolle.kdnr = kd_liefnr.kdnr LEFT JOIN busch_lgort ON tagesprotokolle.stichwort = busch_lgort.lagerort AND tagesprotokolle.kdnr = busch_lgort.kunde WHERE tagesprotokolle.stichwort = 'gr5' AND tagesprotokolle.kw ='38'; Array ( ) in buschcsv_my_form_submit() (Zeile 66 von D:\drupal7\sites\all\modules\buschcsv\buschcsv.module).

If two or more columns of the result have the same field names, the last column will take precedence. To access the other column(s) of the same name, you either need to access the result with numeric indices by using mysqli_fetch_row() or add alias names.