Templateshop - Eine große Auswahl an neuen und modernen Templates für die modified eCommerce Shopsoftware
Neuigkeiten
  • Die modified eCommerce Shopsoftware ist kostenlos, aber nicht umsonst.
    Spenden
  • Damit wir die modified eCommerce Shopsoftware auch zukünftig kostenlos anbieten können:
    Spenden
  • Thema: 1064 Syntax Fehler

    jenni

    • Fördermitglied
    • Beiträge: 102
    • Geschlecht:
    1064 Syntax Fehler
    am: 28. August 2015, 15:49:30
    Hallo zusammen,

    ich habe das google rss feed modul eingebaut. Funktionieren tut es schonmal.
    Nun kriege ich in "Konfigaration""Lieferstatus" folgenden Fehler angezeigt:

    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 'limit 0, 20' at line 1

    in der der Datei steht
    Code: PHP  [Auswählen]
    require('includes/application_top.php');
      /* BOF AGI GOOGLE-XML-EXPORT www.andreas-guder.de 1/6 */
      $google_status_options = array(
        array('id' => 'in stock', 'text' => GOOGLE_STATUS_IN_STOCK),
        //array('id' => 'available for order', 'text' => GOOGLE_STATUS_AVAILABLE_FOR_ORDER),
        array('id' => 'out of stock', 'text' => GOOGLE_STATUS_OUT_OF_STOCK),
        array('id' => 'preorder', 'text' => GOOGLE_STATUS_PREORDER)
      );
      /* EOF AGI GOOGLE-XML-EXPORT www.andreas-guder.de 1/6 */

      switch ($_GET['action']) {
        case 'insert':
        case 'save':
          $shipping_status_id = xtc_db_prepare_input($_GET['oID']);

          $languages = xtc_get_languages();
          for ($i = 0, $n = sizeof($languages); $i < $n; $i++) {
            $shipping_status_name_array = $_POST['shipping_status_name'];
            $language_id = $languages[$i]['id'];

            $sql_data_array = array('shipping_status_name' => xtc_db_prepare_input($shipping_status_name_array[$language_id]));

            if ($_GET['action'] == 'insert') {
              if (!xtc_not_null($shipping_status_id)) {
                $next_id_query = xtc_db_query("select max(shipping_status_id) as shipping_status_id from " . TABLE_SHIPPING_STATUS . "");
                $next_id = xtc_db_fetch_array($next_id_query);
                $shipping_status_id = $next_id['shipping_status_id'] + 1;
              }
     
    Kann kein Fehler entdecken...Hat jemand eine Idee? Hab meine Glaskugel verlegt..
    Achja ist der xamp dl mit aktueller Modi aus dem Downloadbereich

    LG Jenni :-)

    Linkback: https://www.modified-shop.org/forum/index.php?topic=33568.0

    mr.mc.mauser

    • Fördermitglied
    • Beiträge: 343
    • Geschlecht:
    Re: 1064 Syntax Fehler
    Antwort #1 am: 28. August 2015, 15:54:46
    also an dieser datei liegt es definitiv nicht.
    Man braucht die Datei die die Datenbankabfrage generiert.

    hast du mal den Link zu dem Modul, dann schaue ich mir das mal an

    jenni

    • Fördermitglied
    • Beiträge: 102
    • Geschlecht:
    Re: 1064 Syntax Fehler
    Antwort #2 am: 28. August 2015, 16:02:24
    Habs gefunden....
    Hier die gesamte Datei...
    Code: PHP  [Auswählen]
    <?php
    /* --------------------------------------------------------------
       $Id: shipping_status.php 1125 2005-07-28 09:59:44Z novalis $

       XT-Commerce - community made shopping
       http://www.(( Wir dulden keine kommerziellen Werbelinks - Bitte <a href="index.php?topic=3013.0">Forenregeln</a> beachten! ))

       Copyright (c) 2003 XT-Commerce
       --------------------------------------------------------------
       based on:
       (c) 2000-2001 The Exchange Project  (earlier name of osCommerce)
       (c) 2002-2003 osCommerce(orders_status.php,v 1.19 2003/02/06); www.oscommerce.com
       (c) 2003      nextcommerce (orders_status.php,v 1.9 2003/08/18); www.nextcommerce.org

       Released under the GNU General Public License
       --------------------------------------------------------------*/


      require('includes/application_top.php');
      /* BOF AGI GOOGLE-XML-EXPORT www.andreas-guder.de 1/6 */
      $google_status_options = array(
        array('id' => 'in stock', 'text' => GOOGLE_STATUS_IN_STOCK),
        //array('id' => 'available for order', 'text' => GOOGLE_STATUS_AVAILABLE_FOR_ORDER),
        array('id' => 'out of stock', 'text' => GOOGLE_STATUS_OUT_OF_STOCK),
        array('id' => 'preorder', 'text' => GOOGLE_STATUS_PREORDER)
      );
      /* EOF AGI GOOGLE-XML-EXPORT www.andreas-guder.de 1/6 */
     
      switch ($_GET['action']) {
        case 'insert':
        case 'save':
          $shipping_status_id = xtc_db_prepare_input($_GET['oID']);

          $languages = xtc_get_languages();
          for ($i = 0, $n = sizeof($languages); $i < $n; $i++) {
            $shipping_status_name_array = $_POST['shipping_status_name'];
            $language_id = $languages[$i]['id'];

            $sql_data_array = array('shipping_status_name' => xtc_db_prepare_input($shipping_status_name_array[$language_id]));

            if ($_GET['action'] == 'insert') {
              if (!xtc_not_null($shipping_status_id)) {
                $next_id_query = xtc_db_query("select max(shipping_status_id) as shipping_status_id from " . TABLE_SHIPPING_STATUS . "");
                $next_id = xtc_db_fetch_array($next_id_query);
                $shipping_status_id = $next_id['shipping_status_id'] + 1;
              }

              $insert_sql_data = array('shipping_status_id' => $shipping_status_id,
                                       'language_id' => $language_id);
              $sql_data_array = xtc_array_merge($sql_data_array, $insert_sql_data);
              xtc_db_perform(TABLE_SHIPPING_STATUS, $sql_data_array);
            } elseif ($_GET['action'] == 'save') {
                            //BOF - web28 - 2010-07-11 - BUGFIX no entry stored for previous deactivated languages
                            $shipping_status_query = xtc_db_query("select * from ".TABLE_SHIPPING_STATUS." where language_id = '".$language_id."' and shipping_status_id = '".xtc_db_input($shipping_status_id)."'");
                            if (xtc_db_num_rows($shipping_status_query) == 0) xtc_db_perform(TABLE_SHIPPING_STATUS, array ('shipping_status_id' => xtc_db_input($shipping_status_id), 'language_id' => $language_id));
                            //EOF - web28 - 2010-07-11 - BUGFIX no entry stored for previous deactivated languages
                            xtc_db_perform(TABLE_SHIPPING_STATUS, $sql_data_array, 'update', "shipping_status_id = '" . xtc_db_input($shipping_status_id) . "' and language_id = '" . $language_id . "'");
            }
          }

          if ($shipping_status_image = xtc_try_upload('shipping_status_image',DIR_WS_ICONS)) {
            xtc_db_query("update " . TABLE_SHIPPING_STATUS . " set shipping_status_image = '" . $shipping_status_image->filename . "' where shipping_status_id = '" . xtc_db_input($shipping_status_id) . "'");
          }
          /* BOF AGI GOOGLE-XML-EXPORT www.andreas-guder.de 2/6 */
          xtc_db_query("update " . TABLE_SHIPPING_STATUS . " set `google_status_name` = '" . xtc_db_prepare_input($_POST['google_status_name']) . "' where shipping_status_id = '" . xtc_db_input($shipping_status_id) . "'");
          /* EOF AGI GOOGLE-XML-EXPORT www.andreas-guder.de 2/6 */
          if ($_POST['default'] == 'on') {
            xtc_db_query("update " . TABLE_CONFIGURATION . " set configuration_value = '" . xtc_db_input($shipping_status_id) . "' where configuration_key = 'DEFAULT_SHIPPING_STATUS_ID'");
          }

          xtc_redirect(xtc_href_link(FILENAME_SHIPPING_STATUS, 'page=' . $_GET['page'] . '&oID=' . $shipping_status_id));
          break;

        case 'deleteconfirm':
          $oID = xtc_db_prepare_input($_GET['oID']);

          $shipping_status_query = xtc_db_query("select configuration_value from " . TABLE_CONFIGURATION . " where configuration_key = 'DEFAULT_SHIPPING_STATUS_ID'");
          $shipping_status = xtc_db_fetch_array($shipping_status_query);
          if ($shipping_status['configuration_value'] == $oID) {
            xtc_db_query("update " . TABLE_CONFIGURATION . " set configuration_value = '' where configuration_key = 'DEFAULT_SHIPPING_STATUS_ID'");
          }

          xtc_db_query("delete from " . TABLE_SHIPPING_STATUS . " where shipping_status_id = '" . xtc_db_input($oID) . "'");

          xtc_redirect(xtc_href_link(FILENAME_SHIPPING_STATUS, 'page=' . $_GET['page']));
          break;

        case 'delete':
          $oID = xtc_db_prepare_input($_GET['oID']);


          $remove_status = true;
          if ($oID == DEFAULT_SHIPPING_STATUS_ID) {
            $remove_status = false;
            $messageStack->add(ERROR_REMOVE_DEFAULT_SHIPPING_STATUS, 'error');
          } else {

          }
          break;
      }
      require (DIR_WS_INCLUDES.'head.php');
    ?>
    <script type="text/javascript" src="includes/general.js"></script>
    </head>
    <body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF" onload="SetFocus();">
    <!-- header //-->
    <?php require(DIR_WS_INCLUDES . 'header.php'); ?>
    <!-- header_eof //-->

    <!-- body //-->
    <table border="0" width="100%" cellspacing="2" cellpadding="2">
      <tr>
        <td class="columnLeft2" width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="1" cellpadding="1" class="columnLeft">
    <!-- left_navigation //-->
    <?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>
    <!-- left_navigation_eof //-->
        </table></td>
    <!-- body_text //-->
        <td class="boxCenter" width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2">
          <tr>
            <td><table border="0" width="100%" cellspacing="0" cellpadding="0">
      <tr>
        <td width="80" rowspan="2"><?php echo xtc_image(DIR_WS_ICONS.'heading_configuration.gif'); ?></td>
        <td class="pageHeading"><?php echo BOX_SHIPPING_STATUS; ?></td>
      </tr>
      <tr>
        <td class="main" valign="top">Configuration</td>
      </tr>
    </table></td>
          </tr>
          <tr>
            <td valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0">
              <tr>
                <td valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2">
                  <tr class="dataTableHeadingRow">
                  <td class="dataTableHeadingContent" width="1"><?php echo TABLE_HEADING_SHIPPING_STATUS; ?></td>
                    <td class="dataTableHeadingContent" width="100%">&nbsp;</td>
                    <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_ACTION; ?>&nbsp;</td>
                  </tr>
    <?php
      /* BOF AGI GOOGLE-XML-EXPORT www.andreas-guder.de 3/6 */
      //$shipping_status_query_raw = "select shipping_status_id, shipping_status_name,shipping_status_image from " . TABLE_SHIPPING_STATUS . " where language_id = '" . $_SESSION['languages_id'] . "' order by shipping_status_id";
      $shipping_status_query_raw = "select shipping_status_id, shipping_status_name,shipping_status_image,google_status_name from " . TABLE_SHIPPING_STATUS . " where language_id = '" . $_SESSION['languages_id'] . "' order by shipping_status_id";
      /* EOF AGI GOOGLE-XML-EXPORT www.andreas-guder.de 3/6 */
      $shipping_status_split = new splitPageResults($_GET['page'], '20', $shipping_status_query_raw, $shipping_status_query_numrows);
      $shipping_status_query = xtc_db_query($shipping_status_query_raw);
      while ($shipping_status = xtc_db_fetch_array($shipping_status_query)) {
        if (((!$_GET['oID']) || ($_GET['oID'] == $shipping_status['shipping_status_id'])) && (!$oInfo) && (substr($_GET['action'], 0, 3) != 'new')) {
          $oInfo = new objectInfo($shipping_status);
        }

        if ( (is_object($oInfo)) && ($shipping_status['shipping_status_id'] == $oInfo->shipping_status_id) ) {
          echo '                  <tr class="dataTableRowSelected" onmouseover="this.style.cursor=\'pointer\'" onclick="document.location.href=\'' . xtc_href_link(FILENAME_SHIPPING_STATUS, 'page=' . $_GET['page'] . '&oID=' . $oInfo->shipping_status_id . '&action=edit') . '\'">' . "\n";
        } else {
          echo '                  <tr class="dataTableRow" onmouseover="this.className=\'dataTableRowOver\';this.style.cursor=\'pointer\'" onmouseout="this.className=\'dataTableRow\'" onclick="document.location.href=\'' . xtc_href_link(FILENAME_SHIPPING_STATUS, 'page=' . $_GET['page'] . '&oID=' . $shipping_status['shipping_status_id']) . '\'">' . "\n";
        }

        if (DEFAULT_SHIPPING_STATUS_ID == $shipping_status['shipping_status_id']) {
            echo '<td class="dataTableContent" align="left">';
         if ($shipping_status['shipping_status_image'] != '') {
           echo xtc_image(DIR_WS_ICONS . $shipping_status['shipping_status_image'] , IMAGE_ICON_INFO);
         }
         echo '</td>';
          echo '                <td class="dataTableContent"><b>' . $shipping_status['shipping_status_name'] . ' (' . TEXT_DEFAULT . ')</b></td>' . "\n";
        } else {

                            echo '<td class="dataTableContent" align="left">';
                           if ($shipping_status['shipping_status_image'] != '') {
                               echo xtc_image(DIR_WS_ICONS . $shipping_status['shipping_status_image'] , IMAGE_ICON_INFO);
                               }
                               echo '</td>';
          echo '                <td class="dataTableContent">' . $shipping_status['shipping_status_name'] . '</td>' . "\n";
        }
    ?>
    <!-- BOF - Tomcraft - 2009-06-10 - added some missing alternative text on admin icons -->
    <!--
                    <td class="dataTableContent" align="right"><?php if ( (is_object($oInfo)) && ($shipping_status['shipping_status_id'] == $oInfo->shipping_status_id) ) { echo xtc_image(DIR_WS_IMAGES . 'icon_arrow_right.gif', ''); } else { echo '<a href="' . xtc_href_link(FILENAME_SHIPPING_STATUS, 'page=' . $_GET['page'] . '&oID=' . $shipping_status['shipping_status_id']) . '">' . xtc_image(DIR_WS_IMAGES . 'icon_info.gif', IMAGE_ICON_INFO) . '</a>'; } ?>&nbsp;</td>
    -->
                    <td class="dataTableContent" align="right"><?php if ( (is_object($oInfo)) && ($shipping_status['shipping_status_id'] == $oInfo->shipping_status_id) ) { echo xtc_image(DIR_WS_IMAGES . 'icon_arrow_right.gif', ICON_ARROW_RIGHT); } else { echo '<a href="' . xtc_href_link(FILENAME_SHIPPING_STATUS, 'page=' . $_GET['page'] . '&oID=' . $shipping_status['shipping_status_id']) . '">' . xtc_image(DIR_WS_IMAGES . 'icon_info.gif', IMAGE_ICON_INFO) . '</a>'; } ?>&nbsp;</td>
    <!-- EOF - Tomcraft - 2009-06-10 - added some missing alternative text on admin icons -->
                  </tr>
    <?php
      }
    ?>
                  <tr>
                    <td colspan="2"><table border="0" width="100%" cellspacing="0" cellpadding="2">
                      <tr>
                        <td class="smallText" valign="top"><?php echo $shipping_status_split->display_count($shipping_status_query_numrows, '20', $_GET['page'], TEXT_DISPLAY_NUMBER_OF_SHIPPING_STATUS); ?></td>
                        <td class="smallText" align="right"><?php echo $shipping_status_split->display_links($shipping_status_query_numrows, '20', MAX_DISPLAY_PAGE_LINKS, $_GET['page']); ?></td>
                      </tr>
    <?php
      if (substr($_GET['action'], 0, 3) != 'new') {
    ?>
                      <tr>
                        <td colspan="2" align="right"><?php echo '<a class="button" onclick="this.blur();" href="' . xtc_href_link(FILENAME_SHIPPING_STATUS, 'page=' . $_GET['page'] . '&action=new') . '">' . BUTTON_INSERT . '</a>'; ?></td>
                      </tr>
    <?php
      }
    ?>
                    </table></td>
                  </tr>
                </table></td>
    <?php
      $heading = array();
      $contents = array();
      switch ($_GET['action']) {
        case 'new':
          $heading[] = array('text' => '<b>' . TEXT_INFO_HEADING_NEW_SHIPPING_STATUS . '</b>');

          $contents = array('form' => xtc_draw_form('status', FILENAME_SHIPPING_STATUS, 'page=' . $_GET['page'] . '&action=insert', 'post', 'enctype="multipart/form-data"'));
          $contents[] = array('text' => TEXT_INFO_INSERT_INTRO);

          $shipping_status_inputs_string = '';
          $languages = xtc_get_languages();
          for ($i = 0, $n = sizeof($languages); $i < $n; $i++) {
            $shipping_status_inputs_string .= '<br />' . xtc_image(DIR_WS_LANGUAGES.$languages[$i]['directory'].'/admin/images/'.$languages[$i]['image']) . '&nbsp;' . xtc_draw_input_field('shipping_status_name[' . $languages[$i]['id'] . ']');
          }
          $contents[] = array('text' => '<br />' . TEXT_INFO_SHIPPING_STATUS_IMAGE . '<br />' . xtc_draw_file_field('shipping_status_image'));
          $contents[] = array('text' => '<br />' . TEXT_INFO_SHIPPING_STATUS_NAME . $shipping_status_inputs_string);
          /* BOF AGI GOOGLE-XML-EXPORT www.andreas-guder.de 4/6 */
          $contents[] = array('text' => '<br />' . TEXT_INFO_SHIPPING_STATUS_GOOGLE_STATUS . xtc_draw_pull_down_menu('google_status_name', $google_status_options, 'in stock'));
          /* EOF AGI GOOGLE-XML-EXPORT www.andreas-guder.de 4/6 */
          $contents[] = array('text' => '<br />' . xtc_draw_checkbox_field('default') . ' ' . TEXT_SET_DEFAULT);
          $contents[] = array('align' => 'center', 'text' => '<br /><input type="submit" class="button" onclick="this.blur();" value="' . BUTTON_INSERT . '"/> <a class="button" onclick="this.blur();" href="' . xtc_href_link(FILENAME_SHIPPING_STATUS, 'page=' . $_GET['page']) . '">' . BUTTON_CANCEL . '</a>');
          break;

        case 'edit':
          $heading[] = array('text' => '<b>' . TEXT_INFO_HEADING_EDIT_SHIPPING_STATUS . '</b>');

          $contents = array('form' => xtc_draw_form('status', FILENAME_SHIPPING_STATUS, 'page=' . $_GET['page'] . '&oID=' . $oInfo->shipping_status_id  . '&action=save', 'post', 'enctype="multipart/form-data"'));
          $contents[] = array('text' => TEXT_INFO_EDIT_INTRO);

          $shipping_status_inputs_string = '';
          $languages = xtc_get_languages();
          for ($i = 0, $n = sizeof($languages); $i < $n; $i++) {
            $shipping_status_inputs_string .= '<br />' . xtc_image(DIR_WS_LANGUAGES.$languages[$i]['directory'].'/admin/images/'.$languages[$i]['image']) . '&nbsp;' . xtc_draw_input_field('shipping_status_name[' . $languages[$i]['id'] . ']', xtc_get_shipping_status_name($oInfo->shipping_status_id, $languages[$i]['id']));
          }
          $contents[] = array('text' => '<br />' . TEXT_INFO_SHIPPING_STATUS_IMAGE . '<br />' . xtc_draw_file_field('shipping_status_image',$oInfo->shipping_status_image));
          $contents[] = array('text' => '<br />' . TEXT_INFO_SHIPPING_STATUS_NAME . $shipping_status_inputs_string);
          /* BOF AGI GOOGLE-XML-EXPORT www.andreas-guder.de 5/6 */
          $contents[] = array('text' => '<br />' . TEXT_INFO_SHIPPING_STATUS_GOOGLE_STATUS . xtc_draw_pull_down_menu('google_status_name', $google_status_options, $oInfo->google_status_name));
          /* EOF AGI GOOGLE-XML-EXPORT www.andreas-guder.de 5/6 */
          if (DEFAULT_SHIPPING_STATUS_ID != $oInfo->shipping_status_id) $contents[] = array('text' => '<br />' . xtc_draw_checkbox_field('default') . ' ' . TEXT_SET_DEFAULT);
          $contents[] = array('align' => 'center', 'text' => '<br /><input type="submit" class="button" onclick="this.blur();" value="' . BUTTON_UPDATE . '"/> <a class="button" onclick="this.blur();" href="' . xtc_href_link(FILENAME_SHIPPING_STATUS, 'page=' . $_GET['page'] . '&oID=' . $oInfo->shipping_status_id) . '">' . BUTTON_CANCEL . '</a>');
          break;

        case 'delete':
          $heading[] = array('text' => '<b>' . TEXT_INFO_HEADING_DELETE_SHIPPING_STATUS . '</b>');

          $contents = array('form' => xtc_draw_form('status', FILENAME_SHIPPING_STATUS, 'page=' . $_GET['page'] . '&oID=' . $oInfo->shipping_status_id  . '&action=deleteconfirm'));
          $contents[] = array('text' => TEXT_INFO_DELETE_INTRO);
          $contents[] = array('text' => '<br /><b>' . $oInfo->shipping_status_name . '</b>');
          if ($remove_status) $contents[] = array('align' => 'center', 'text' => '<br /><input type="submit" class="button" onclick="this.blur();" value="' . BUTTON_DELETE . '"/> <a class="button" onclick="this.blur();" href="' . xtc_href_link(FILENAME_SHIPPING_STATUS, 'page=' . $_GET['page'] . '&oID=' . $oInfo->shipping_status_id) . '">' . BUTTON_CANCEL . '</a>');
          break;

        default:
          if (is_object($oInfo)) {
            $heading[] = array('text' => '<b>' . $oInfo->shipping_status_name . '</b>');

            $contents[] = array('align' => 'center', 'text' => '<a class="button" onclick="this.blur();" href="' . xtc_href_link(FILENAME_SHIPPING_STATUS, 'page=' . $_GET['page'] . '&oID=' . $oInfo->shipping_status_id . '&action=edit') . '">' . BUTTON_EDIT . '</a> <a class="button" onclick="this.blur();" href="' . xtc_href_link(FILENAME_SHIPPING_STATUS, 'page=' . $_GET['page'] . '&oID=' . $oInfo->shipping_status_id . '&action=delete') . '">' . BUTTON_DELETE . '</a>');

            $shipping_status_inputs_string = '';
            $languages = xtc_get_languages();
            for ($i = 0, $n = sizeof($languages); $i < $n; $i++) {
              $shipping_status_inputs_string .= '<br />' . xtc_image(DIR_WS_LANGUAGES.$languages[$i]['directory'].'/admin/images/'.$languages[$i]['image']) . '&nbsp;' . xtc_get_shipping_status_name($oInfo->shipping_status_id, $languages[$i]['id']);
            }

            $contents[] = array('text' => $shipping_status_inputs_string);
            /* BOF AGI GOOGLE-XML-EXPORT www.andreas-guder.de 6/6 */
            $contents[] = array('text' => '<br />' . TEXT_INFO_SHIPPING_STATUS_GOOGLE_STATUS . $oInfo->google_status_name);
            /* EOF AGI GOOGLE-XML-EXPORT www.andreas-guder.de 6/6 */
          }
          break;
      }

      if ( (xtc_not_null($heading)) && (xtc_not_null($contents)) ) {
        echo '            <td width="25%" valign="top">' . "\n";

        $box = new box;
        echo $box->infoBox($heading, $contents);

        echo '            </td>' . "\n";
      }
    ?>
              </tr>
            </table></td>
          </tr>
        </table></td>
    <!-- body_text_eof //-->
      </tr>
    </table>
    <!-- body_eof //-->

    <!-- footer //-->
    <?php require(DIR_WS_INCLUDES . 'footer.php'); ?>
    <!-- footer_eof //-->
    <br />
    </body>
    </html>
    <?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

    Falls jemand das gleiche Problem hat. Trotzdem danke :-)

    LG Jenni

    jenni

    • Fördermitglied
    • Beiträge: 102
    • Geschlecht:
    Re: 1064 Syntax Fehler
    Antwort #3 am: 28. August 2015, 16:05:05
    Hey Mauser,

    hab gerade erst gesehen dass du geschrieben hast.

    Hier ist das Modul GOOGLE-XML-EXPORT www.andreas-guder.de

    LG

    Jenni

    mr.mc.mauser

    • Fördermitglied
    • Beiträge: 343
    • Geschlecht:
    Re: 1064 Syntax Fehler
    Antwort #4 am: 28. August 2015, 19:15:43
    editiere mal die /export/google_xml.php zeile 1675
    da steht:
    Code: PHP  [Auswählen]
     $general_query .= " LIMIT $lstart, $limit_amount";
    daraus machst du
    Code: PHP  [Auswählen]
     //$general_query .= " LIMIT $lstart, $limit_amount";

    Wenn der Fehler weg ist wissen wir schon mal woran es hängen könnte und es geht so weiter:
    Die änderung von eben rückgängig machen.
    2 Zeilen Tiefer nach dem } schreibst Du
    Code: PHP  [Auswählen]
    echo $general_query;
    die();
    damit bekommst du dann den query ausgegeben und man kann diesen auf Fehler prüfen.

    Diese Ausgabe postest du dann hier.
    Und wir sehen weiter

    jenni

    • Fördermitglied
    • Beiträge: 102
    • Geschlecht:
    Re: 1064 Syntax Fehler
    Antwort #5 am: 28. August 2015, 19:20:33
    wie gesagt bereits erl. s. POST