Wow! I bet you didn't expect to see this...

  Not Found

The database search failed due to an unexpected error.

This is the HTML code that was being processed:

<mgiSearchDatabase databasename="member_autorenew-db" searchstring="mar-next_payment<'2460219' AND mar-auto_renew='Yes'" >
    <mgiSet name="txid">&mgiDBFieldmar-txid;</mgiSet>
    <mgiSet name="first_name">&mgiDBFieldmar-first_name;</mgiSet>
    <mgiSet name="last_name">&mgiDBFieldmar-last_name;</mgiSet>
    <mgiSet name="email">&mgiDBFieldmar-email;</mgiSet>
    <mgiSet name="cc_zip">&mgiDBFieldmar-cc_zip;</mgiSet>
    <mgiSet name="amount">&mgiDBFieldmar-amount;</mgiSet>
    <mgiSet name="cc_exp">&mgiDBFieldmar-cc_exp;</mgiSet>
    <mgiSet name="cc_sec">&mgiDBFieldmar-cc_sec;</mgiSet>
    <mgiSet name="cc_num">&mgiDBFieldmar-cc_num;</mgiSet>
    <mgiSet name="cc_type">&mgiDBFieldmar-cc_type;</mgiSet>
    <mgiSet name="next_payment">&mgiDBFieldmar-next_payment;</mgiSet>
    <mgiSet name="cc_number"><mgiMath displayprecision="0">&mgiDBFieldmar-cc_number; - 123456789</mgiMath></mgiSet>
      
    <mgiSet name="description">Automatic Member Renewal for &mgiDBFieldmar-first_name; &mgiDBFieldmar-last_name;</mgiset>
    <mgiSet name="fee_number"><mgiCounter name="fee_number" mode="process" type="Text" length="6" display="Yes" increment="Yes"></mgiset>
    <mgiSet name="login_id">7xr3wzBE88Pr</mgiSet>
    <mgiSet name="transaction_key">7H8vMkY8V8b9a2kU</mgiSet>
  
    <mgiIf lhs={mgiGet name="email"} relationship="contains" rhs="tobsupport">
      <mgiSet name="amount">1.00</mgiSet>
    </mgiIf>
        
<mgiSet name="post_response">
<mgiPHP mgiBefore="True"><?php
$post_url = "https://wynnewoodgifts.com/ted/oeis.php";
$post_values = array(
"login_id" => "<mgiGet name="login_id">",
"transaction_key" => "<mgiGet name="transaction_key">",
"amount" => "<mgiGet name="amount">",
"first_name" => "<mgiGet name="first_name">",
"last_name" => "<mgiGet name="last_name">",
"email" => "<mgiGet name="email">",
"cc_number" => "<mgiGet name="cc_number">",
"exp_date" => "<mgiGet name="cc_exp">",
"cc_id" => "<mgiGet name="cc_id">",
"cc_zip" => "<mgiGet name="cc_zip">",
"description" => "<mgiGet name="description">",
"invoice" => "<mgiGet name="fee_number">",
"txid" => "<mgiGet name="txid">"
);

$post_string = "";
foreach( $post_values as $key => $value )
{ $post_string .= "$key=" . urlencode( $value ) . "&"; }
$post_string = rtrim( $post_string, "& " );

$request = curl_init($post_url); // initiate curl object
curl_setopt($request, CURLOPT_HEADER, 0); // set to 0 to eliminate header info from response
curl_setopt($request, CURLOPT_RETURNTRANSFER, 1); // Returns response data instead of TRUE(1)
curl_setopt($request, CURLOPT_POSTFIELDS, $post_string);
curl_setopt($request, CURLOPT_SSL_VERIFYPEER, FALSE);
$post_response = curl_exec($request);
curl_close ($request);
echo $post_response;
?></mgiPHP>
</mgiSet>

    <mgiSet name="response code"><mgiString mode="split" delimiter="|" index="1"><mgiGet name="post_response"></mgiString></mgiSet>
    <mgiSet name="response reason"><mgiString mode="split" delimiter="|" index="3"><mgiGet name="post_response"></mgiString></mgiSet>
    <mgiSet name="response text"><mgiString mode="split" delimiter="|" index="4"><mgiGet name="post_response"></mgiString></mgiSet>
    <mgiSet name="auth code"><mgiString mode="split" delimiter="|" index="5"><mgiGet name="post_response"></mgiString></mgiSet>
    <mgiSet name="auth trans_id"><mgiString mode="split" delimiter="|" index="7"><mgiGet name="post_response"></mgiString></mgiSet>
    <mgiSet name="invoice"><mgiString mode="split" delimiter="|" index="8"><mgiGet name="post_response"></mgiString></mgiSet>
    <mgiSet name="description"><mgiString mode="split" delimiter="|" index="9"><mgiGet name="post_response"></mgiString></mgiSet>
    <mgiSet name="card type"><mgiString mode="split" delimiter="|" index="52"><mgiGet name="post_response"></mgiString></mgiSet>
    <mgiSet name="txid"><mgiString mode="split" delimiter="|" index="69"><mgiGet name="post_response"></mgiString></mgiSet>
    
    <mgiSet name="response"><mgiGet name="response text"> <mgiGet name="response code">-<mgiGet name="response reason"></mgiSet>
    <mgiIf lhs={mgiGet name="response code"} relationship="=" rhs="1">
      <mgiSet name="payments">&mgiDBFieldmar-payments; - <mgiDate format="paddednumericmonth" text="/" format="paddedday" text="/" format="shortyear">-$<mgiGet name="amount"></mgiSet>
      <mgiIncrement variablename="next_payment" value="365">

      <mgiModifyDatabase databasename="member_autorenew-db" mode="updaterecord"
      keyfieldname="mar-txid" fieldvalue={mgiGet name="txid"}
      fieldname="mar-payments" fieldvalue={mgiGet name="payments"}
      fieldname="mar-next_payment" pagevariablename="next_payment"
      fieldname="mar-last_payment_date" fieldvalue={mgiDate format="paddednumericmonth" text="/" format="paddedday" text="/" format="shortyear"}
      fieldname="mar-last_payment_jdate" fieldvalue={mgiJulianDay}
      fieldname="mar-last_payment" fieldvalue="No">


      <mgiSet name="new_txid"><mgiString mode="substring"  beginningIndex="1" length="19"><mgiString mode="replace" stringToReplace="." replacementString=""><mgiRandomNumber lowerbound="1111" upperbound="9999"><mgiJulianDay>000000000000</mgiString></mgiString></mgiSet> 
           
      <mgiModifyDatabase databasename="member_autorenew_pay-db" mode="addrecord"
      fieldname="marp-txid" fieldvalue={mgiGet name="new_txid"}
      fieldname="marp-mar_txid" fieldvalue={mgiGet name="txid"}
      fieldname="marp-date" fieldvalue={mgiDate format="paddednumericmonth" text="/" format="paddedday" text="/" format="shortyear"}
      fieldname="marp-jdate" fieldvalue={mgiJulianDay dateonly="yes"}
      fieldname="marp-first_name" fieldvalue={mgiGet name="first_name"}
      fieldname="marp-last_name" fieldvalue={mgiGet name="last_name"}
      fieldname="marp-email" fieldvalue={mgiGet name="email"}
      fieldname="marp-cc_exp" fieldvalue={mgiGet name="cc_exp"}
      fieldname="marp-cc_sec" fieldvalue={mgiGet name="cc_sec"}
      fieldname="marp-cc_num" fieldvalue={mgiGet name="cc_num"}
      fieldname="marp-cc_type" fieldvalue={mgiGet name="cc_type"}
      fieldname="marp-amount" fieldvalue={mgiGet name="amount"}
      fieldname="marp-fee_number" fieldvalue={mgiGet name="invoice"}
      fieldname="marp-anet_trans_id" fieldvalue={mgiGet name="auth trans_id"}
      fieldname="marp-anet_auth_code" fieldvalue={mgiGet name="auth code"}
      fieldname="marp-anet_response" pagevariablename="response"
      fieldname="marp-payment" fieldvalue="Yes">
  
      <mgiComment> Send an email to office </mgiComment>
  
      <mgiSendmail to={mgiGet name="CAR_contact" scope="site"} cc="KGonzalez@association-resources.com" bcc="ted@tobsupport.com" replyto={mgiGet name="CAR_contact" scope="site"} fromname="OEISociety" from="info@oeisociety.com" mailserver="mail.oeisociety.com" subject="OEIS Member Auto Renewal Payment">
OEIS Member Auto Renewal Payment
Name: <mgiGet name="first_name"> <mgiGet name="last_name">
Email: <mgiGet name="email">
Amount: $<mgiGet name="amount">
      </mgiSendmail>
      
      <mgiComment> Send an email to member </mgiComment>
      <mgiSendmail to={mgiGet name="email"} cc={mgiGet name="CAR_contact" scope="site"} cc="KGonzalez@association-resources.com" replyto="DBhatt@association-resources.com" fromname="OEISociety" from="info@oeisociety.com" mailserver="mail.oeisociety.com" subject="OEIS Member Auto Renewal Payment">
OEIS Member Auto Renewal Payment
Remember that this is an annual fee, your credit card will be charged each year.
  
Name: <mgiGet name="first_name"> <mgiGet name="last_name">
Email: <mgiGet name="email">
Amount: $<mgiGet name="amount">
Your <mgiGet name="cc_type"> <mgiGet name="cc_num"> credit card has been charged.
      </mgiSendmail>
    <mgiElse>
      <mgiModifyDatabase databasename="member_autorenew-db" mode="updaterecord"
      keyfieldname="mar-txid" fieldvalue={mgiGet name="txid"}
      fieldname="mar-last_payment" fieldvalue="No">
      
      <mgiSet name="new_txid"><mgiString mode="substring"  beginningIndex="1" length="19"><mgiString mode="replace" stringToReplace="." replacementString=""><mgiRandomNumber lowerbound="1111" upperbound="9999"><mgiJulianDay>000000000000</mgiString></mgiString></mgiSet> 
           
      
      <mgiSendmail to={mgiGet name="CAR_contact" scope="site"} to="KGonzalez@association-resources.com" bcc="ted@tobsupport.com" replyto={mgiGet name="CAR_contact" scope="site"} fromname="OEISociety" from="info@oeisociety.com" mailserver="mail.oeisociety.com" subject="OEIS Member Auto Renewal Payment FAILURE">
OEIS Member Auto Renewal Payment Failure
Reason: <mgiGet name="response">
Name: <mgiGet name="first_name"> <mgiGet name="last_name">
Email: <mgiGet name="email">
Amount: $<mgiGet name="amount">
      </mgiSendmail>
    </mgiIf>
    
  </mgiSearchDatabase>

  Try this...

Check the syntax of your search criteria and try the search again.