Hallo Zusammen,
Ich muß regelmäßig mein Apache dienst neu starten da bei Suchabfragen kein Ergebniss sondern Fehlermeldungen. Teileweise besagen die das der Speicher nicht ausreicht. Der Server hat 1GB RAM
Ich hab hier mal ein beispiel meiner Suchabfragen vielleicht ist ein Fehler drinn und deshalb Läuft der der Apache an die Wand.
HZML TEXT der Suche
<fieldset class="portalsuche-rahmen"><legend class="rot">Stücklisten Suche</legend>
<div id="suchabfrage">
<form id="suchabfrage_form" method="post" enctype="multipart/form-data" action="index.php?id=261">
<div id="WFQBE_NAME_1" class="wfqbe_odd">
<table >
<tr>
<td width="100">
<label for="FIELD_WFQBE_NAME">Nummer: </label></td>
<td>
<input id="FIELD_WFQBE_NAME" type="text" style="width: 200px" name="tx_wfqbe_pi1[NAME]" value="" /></td>
</tr>
<td width="100"> </td>
<td>
<input type="submit" name="tx_wfqbe_pi1[submit]" value="Suchen" /></td>
</table>
<!-- ###FIELD_BLOCK### -->
</div>
</form>
</div>
</fieldset>
Hier das Template
<?xml version="1.0" encoding="iso-8859-1" standalone="yes"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
"
http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html>
<head>
<!--<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link rel="stylesheet" href="stile.css" title=
"Stile Normale" type="text/css"/>-->
<title>WFQBE Default Template</title>
</head>
<body>
<!-- ###SEARCH_TEMPLATE### -->
<div id="###CONF_DIVID###">
<form id="###CONF_DIVID###_form" method="post" enctype="multipart/form-data" ###XAJAX_SUBMIT### action="###CONF_SEARCH###">
<!-- ###SEARCH_BLOCK### -->
<div id="###SEARCH_ID###" class="###WFQBE_CLASS###">
<!-- ###FIELD_BLOCK### -->
<label style="font-weight: bold;" for="###SEARCH_ID_FIELD###">###SEARCH_LABEL###</label>
###SEARCH_FIELD###
<!-- ###FIELD_BLOCK### -->
</div>
<!-- ###SEARCH_BLOCK### -->
<div class="wfqbe_block">
<input type="submit" name="tx_wfqbe_pi1[submit]" value="Search" />
</div>
</form>
</div>
<!-- ###SEARCH_TEMPLATE### -->
<!-- ###RESULT_TEMPLATE### -->
<div id="###CONF_DIVID###">
<table summary="###TABLE_SUMMARY###" class="wfqbe_table_results">
<caption><em>###TABLE_CAPTION###</em></caption>
<thead>
<tr class="wfqbe_table_header">
<th class="td-0" scope="col" id="col344-0">Nummer</th>
<th class="td-1" scope="col" id="col344-1">Index</th>
<th class="td-2" scope="col" id="col344-2">Blatt</th>
<th class="td-3" scope="col" id="col344-3">Von</th>
<th class="td-4" scope="col" id="col344-4">Erstellt</th>
<th class="td-last td-5" scope="col" id="col344-5">Land</th>
</tr>
</thead>
<tbody>
<!-- ###TABLE_DATA### -->
<tr class="###WFQBE_CLASS###">
<!-- ###TD_TAG### -->
<td>###COLUMN_DATA###</td>
<!-- ###TD_TAG### -->
</tr>
<!-- ###TABLE_DATA### -->
</tbody>
</table>
<!-- ###CSV_DOWNLOAD### -->
<br />
<a href="###CONF_CSV###">Export in CSV</a>
<!-- ###CSV_DOWNLOAD### -->
<br /><br />
<!-- ###BROWSE_TEMPLATE### -->
<div class="wfqbe_browser">
Page ###PAGE_ACTUAL### of ###PAGE_TOTAL###<br />
<a href="###PAGE_PREV###" ###PAGE_PREV_TITLE###><<</a> ###PAGE_LIST### <a href="###PAGE_NEXT###" ###PAGE_NEXT_TITLE###>>></a>
</div>
<!-- ###BROWSE_TEMPLATE### -->
</div>
<!-- ###RESULT_TEMPLATE### -->
<!-- ###EMPTY_RESULT_TEMPLATE### -->
<div id="###CONF_DIVID###">
###CONF_EMPTYTEXT###
<!-- ###WIZARD_TEMPLATE### -->
<form id="###CONF_DIVID###_form" method="post" enctype="multipart/form-data" ###XAJAX_SUBMIT### action="###CONF_INSERT###">
###INSERT_HIDDEN_FIELDS###
<div class="wfqbe_block">
<input type="submit" ###XAJAX_CLEAR### name="tx_wfqbe_pi1[wfqbe_select_wizard]" value="Cancel" />
</div>
</form>
<!-- ###WIZARD_TEMPLATE### -->
</div>
<!-- ###EMPTY_RESULT_TEMPLATE### -->
<!-- ###INSERT_TEMPLATE### -->
<div id="###CONF_DIVID###">
<form id="###CONF_DIVID###_form" method="post" enctype="multipart/form-data" ###XAJAX_SUBMIT### action="###CONF_INSERT###">
<div class="wfqbe_description">###INSERT_DESCRIPTION###</div>
<!-- ###INSERT_BLOCK### -->
<div id="###INSERT_ID###" class="wfqbe_block ###WFQBE_CLASS###">
<!-- ###FIELD_BLOCK### -->
<span class="label"><label style="font-weight: bold;" for="field_###INSERT_ID###">###INSERT_LABEL###</label>
(<a href="#" onclick="javascript
:wfqbe_manage_help('help_###INSERT_ID###')">?</a>)</span>
<div class="field">###INSERT_FIELD### ###INSERT_SELECT_WIZARD### ###INSERT_ADD_NEW###</div>
<div class="wfqbe_help" id="help_###INSERT_ID###">###INSERT_HELP###</div>
<!-- ###REQUIRED_TEMPLATE### -->
<div class="wfqbe_required_field" id="wfqbe_required_###INSERT_ID###">Please, complete this field</div>
<!-- ###REQUIRED_TEMPLATE### -->
<!-- ###CUSTOM_VALIDATION_TEMPLATE### -->
<div id="wfqbe_custom_validation_###INSERT_ID###">###CUSTOM_VALIDATION_TEXT###</div>
<!-- ###CUSTOM_VALIDATION_TEMPLATE### -->
<!-- ###FIELD_BLOCK### -->
</div>
<!-- ###INSERT_BLOCK### -->
<div class="wfqbe_block">
<!-- ###HIDDEN_BLOCK### -->
###INSERT_FIELD###
<!-- ###HIDDEN_BLOCK### -->
###INSERT_HIDDEN_FIELDS###
<!-- ###ADD_NEW_CANCEL### -->
<input type="submit" ###XAJAX_CLEAR### name="tx_wfqbe_pi1[wfqbe_add_new]" value="Cancel" />
<!-- ###ADD_NEW_CANCEL### -->
<input type="submit" ###XAJAX_CLEAR### name="tx_wfqbe_pi1[###CONF_SUBMIT###]" value="###CONF_SUBMIT_LABEL###" />
</div>
</form>
</div>
<!-- ###INSERT_TEMPLATE### -->
<!-- ###INSERT_CONFIRMATION_TEMPLATE### -->
<div id="###CONF_DIVID###">
<form id="###CONF_DIVID###_confirmation_form" method="post" enctype="multipart/form-data" ###XAJAX_SUBMIT### action="###CONF_INSERT###">
<!-- ###INSERT_BLOCK### -->
<div id="###INSERT_ID###" class="wfqbe_block">
<span style="font-weight: bold;">###INSERT_LABEL###</span>
###INSERT_VALUE###
###INSERT_FIELD###
</div>
<!-- ###INSERT_BLOCK### -->
###INSERT_HIDDEN_FIELDS###
<div class="wfqbe_block">
<!-- ###MODIFY_BUTTON### -->
<input id="###CONF_DIVID###_insert_modify" type="submit" ###XAJAX_CLEAR_MODIFY### name="tx_wfqbe_pi1[submit_modify]" value="Modify" />
<!-- ###MODIFY_BUTTON### -->
<input id="###CONF_DIVID###_insert_confirm" type="submit" ###XAJAX_CLEAR_CONFIRM### name="tx_wfqbe_pi1[submit_insert]" value="###CONF_SUBMIT_LABEL###" />
</div>
</form>
</div>
<!-- ###INSERT_CONFIRMATION_TEMPLATE### -->
<!-- ###INSERT_FINAL_TEMPLATE### -->
<form id="###CONF_DIVID###_confirmation_form" method="post" enctype="multipart/form-data" ###XAJAX_SUBMIT### action="###CONF_INSERT###">
<!-- ###INSERT_BLOCK### -->
<div id="###INSERT_ID###" class="wfqbe_block">
<span style="font-weight: bold;">###INSERT_LABEL###</span>
###INSERT_VALUE###
</div>
<!-- ###INSERT_BLOCK### -->
<div class="wfqbe_block">
<input type="submit" ###XAJAX_CLEAR### name="tx_wfqbe_pi1[new]" value="New record" />
</div>
</form>
<!-- ###INSERT_FINAL_TEMPLATE### -->
<!-- ###SELECT_WIZARD_TEMPLATE### -->
<div id="###CONF_DIVID###">
<form id="###CONF_DIVID###_form" method="post" enctype="multipart/form-data" ###XAJAX_SUBMIT### action="###CONF_INSERT###">
<div class="wfqbe_description">###WFQBE_DESCRIPTION###</div>
###INSERT_HIDDEN_FIELDS###
<table summary="###TABLE_SUMMARY###" class="wfqbe_table_results">
<caption><em>###TABLE_CAPTION###</em></caption>
<thead>
<tr class="wfqbe_table_header">
<!-- ###TH_TAG### -->
<th scope="col">###COLUMN_NAME###</th>
<!-- ###TH_TAG### -->
<th scope="col">Select</th>
</tr>
</thead>
<tbody>
<!-- ###TABLE_DATA### -->
<tr class="###WFQBE_CLASS###">
<!-- ###TD_TAG### -->
<td>###COLUMN_DATA###</td>
<!-- ###TD_TAG### -->
<td><input###WFQBE_SELECT_WIZARD_SELECTED### type="###WFQBE_SELECT_WIZARD_TYPE###" name="tx_wfqbe_pi1[###WFQBE_SELECT_WIZARD###][]" value="###INSERT_FIELD###" /></td>
</tr>
<!-- ###TABLE_DATA### -->
<!-- ###TABLE_NOVALUE### -->
<tr class="###WFQBE_CLASS###">
<td colspan="###COLUMN_COLSPAN###">No value</td>
<td><input type="radio" name="tx_wfqbe_pi1[###WFQBE_SELECT_WIZARD###]" value="" /></td>
</tr>
<!-- ###TABLE_NOVALUE### -->
</tbody>
</table>
<br />
<div class="wfqbe_block">
<input type="submit" ###XAJAX_CLEAR### name="tx_wfqbe_pi1[wfqbe_select_wizard]" value="Cancel" />
<input type="submit" ###XAJAX_CLEAR### name="tx_wfqbe_pi1[wfqbe_select_wizard]" value="Insert" />
</div>
</form>
</div>
<!-- ###SELECT_WIZARD_TEMPLATE### -->
</body>
</html>
Und hier die Quary
a:1:{s:12:\"contentwfqbe\";a:2:{s:5:\"wfqbe\";a:3:{s:11:\"setoperator\";a:1:{i:0;s:0:\ "\";}i:1;a:1:{s:5:\"table\";a:1:{i:0;s:0:\"\";}}i:0;a:17:{s:5:\"table\";a:2:{i:0;s:8:\ "Intranet\";i:1;s:0:\"\";}s:11:\"renametable\";a:1:{i:0;s:0:\"\";}s:4:\"join\";s:0:\"\ ";s:11:\"distinctall\";s:3:\"all\";s:14:\"selectedfields\";s:98:\"Intranet.Link, Intranet.USER02, Intranet.USER05, Intranet.USER06, Intranet.USER10, Intranet.USER09\";s:11:\"changevalue\";s:0:\"\";s:19:\"aggregationfunction\";s:0:\"\"; s:6:\"rename\";s:0:\"\";s:13:\"parentesiopen\";a:1:{i:0;s:0:\"\";}s:5:\"where\";a:1:{i :0;s:13:\"Intranet.Link\";}s:2:\"op\";a:1:{i:0;s:4:\"LIKE\";}s:6:\"insert\";a:1:{i:0;s :20:\"\'%###WFQBE_NAME###%\'\";}s:11:\"insertfield\";a:1:{i:0;s:0:\"\";}s:2:\"ao\";a:1 :{i:0;s:0:\"\";}s:7:\"groupby\";a:1:{i:0;s:0:\"\";}s:7:\"orderby\";a:2:{i:0;s:15:\"Int ranet.USER05\";i:1;s:0:\"\";}s:2:\"ad\";a:1:{i:0;s:3:\"ASC\";}}}s:8:\"function\";s:3:\ "QBE\";}}
Das ganze greift auf eine Access Datenbank zu
Für Hilfe wäre ich dankbar