Форум PHP-MyAdmin.RU — 1064: You have an error in your SQL syntax

Re: 1064: You have an error in your SQL syntax

null@example.com (Hanut) — Mon, 17 Dec 2012 11:13:02 +0000

keytri сказал:

select manufacturers_name from manufacturers where manufacturers_id=

Как я понимаю, ошибка в этой строке:

$manufacturer_query = vam_db_query("select manufacturers_name from " . TABLE_MANUFACTURERS . " where manufacturers_id=" . $products['manufacturers_id']);

Проверьте значение переменной $products['manufacturers_id'] и где формируется массив $products.

Re: 1064: You have an error in your SQL syntax

null@example.com (keytri) — Mon, 17 Dec 2012 10:39:09 +0000

В админке магазина не появляются товары, получаю такой же ответ в логе ошибок, но не могу понять в чем причина

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 '' at line 1 | select manufacturers_name from manufacturers where manufacturers_id= | /admin/quick_updates.php

ниже код из файла quick_updates.php

 '0', 'text' => NO_TAX_TEXT));
    $tax_class_query = vam_db_query("select tax_class_id, tax_class_title from " . TABLE_TAX_CLASS . " order by tax_class_title");
    while ($tax_class = vam_db_fetch_array($tax_class_query)) {
      $tax_class_array[] = array('id' => $tax_class['tax_class_id'],
                                 'text' => $tax_class['tax_class_title']);
    }

////Info Row pour le champ fabriquant
    $manufacturers_array = array(array('id' => '0', 'text' => NO_MANUFACTURER));
    $manufacturers_query = vam_db_query("select manufacturers_id, manufacturers_name from " . TABLE_MANUFACTURERS . " order by manufacturers_name");
    while ($manufacturers = vam_db_fetch_array($manufacturers_query)) {
        $manufacturers_array[] = array('id' => $manufacturers['manufacturers_id'],
        'text' => $manufacturers['manufacturers_name']);
    }

// Display the list of the manufacturers
function manufacturers_list(){
    global $manufacturer;

    $manufacturers_query = vam_db_query("select m.manufacturers_id, m.manufacturers_name from " . TABLE_MANUFACTURERS . " m order by m.manufacturers_name ASC");
    $return_string = '';
    return $return_string;
}

##// Uptade database
  switch ($_GET['action']) {
    case 'update' :
      $count_update=0;
      $item_updated = array();
          if($_POST['product_new_model']){
           foreach($_POST['product_new_model'] as $id => $new_model) {
             if (trim($_POST['product_new_model'][$id]) != trim($_POST['product_old_model'][$id])) {
               $count_update++;
               $item_updated[$id] = 'updated';
               mysql_query("UPDATE " . TABLE_PRODUCTS . " SET products_model='" . $new_model . "' WHERE products_id=$id");
             }
           }
        }
          if($_POST['product_new_name']){
           foreach($_POST['product_new_name'] as $id => $new_name) {
             if (trim($_POST['product_new_name'][$id]) != trim($_POST['product_old_name'][$id])) {
               $count_update++;
               $item_updated[$id] = 'updated';
               mysql_query("UPDATE " . TABLE_PRODUCTS_DESCRIPTION . " SET products_name='" . $new_name . "' WHERE products_id=$id and language_id=" . $_SESSION['languages_id']);
             }
           }
        }
        // prices
          if($_POST['product_new_price']){
           foreach($_POST['product_new_price'] as $id => $new_price) {
             if ($_POST['product_new_price'][$id] != $_POST['product_old_price'][$id] && $_POST['update_price'][$id] == 'yes') {
               $count_update++;
               $item_updated[$id] = 'updated';
               mysql_query("UPDATE " . TABLE_PRODUCTS . " SET products_price=$new_price WHERE products_id=$id");
             }
           }
        }
          
        if($_POST['product_new_price1']){
           foreach($_POST['product_new_price1'] as $id => $new_price1) {
//             if ($_POST['product_new_price1'][$id] != $_POST['product_old_price2'][$id] && $_POST['update_price'][$id] == 'yes') {
               $count_update++;
               $item_updated[$id] = 'updated';
               mysql_query("UPDATE `personal_offers_by_customers_status_1` SET `personal_offer` = '$new_price1' WHERE `products_id` = '$id'");
//             }
           }
        }
          
        if($_POST['product_new_price2']){
           foreach($_POST['product_new_price2'] as $id => $new_price2) {
//             if ($_POST['product_new_price2'][$id] != $_POST['product_old_price1'][$id] && $_POST['update_price'][$id] == 'yes') {
               $count_update++;
               $item_updated[$id] = 'updated';
               mysql_query("UPDATE `personal_offers_by_customers_status_2` SET `personal_offer` = '$new_price2' WHERE `products_id` = '$id'");
//             }
           }
        }
        
        if($_POST['product_new_price3']){
           foreach($_POST['product_new_price3'] as $id => $new_price3) {
//             if ($_POST['product_new_price3'][$id] != $_POST['product_old_price2'][$id] && $_POST['update_price'][$id] == 'yes') {
               $count_update++;
               $item_updated[$id] = 'updated';
               mysql_query("UPDATE `personal_offers_by_customers_status_3` SET `personal_offer` = '$new_price3' WHERE `products_id` = '$id'");
//             }
           }
        }
        // prices
        
        
        if($_POST['product_new_weight']){
           foreach($_POST['product_new_weight'] as $id => $new_weight) {
             if ($_POST['product_new_weight'][$id] != $_POST['product_old_weight'][$id]) {
               $count_update++;
               $item_updated[$id] = 'updated';
               mysql_query("UPDATE " . TABLE_PRODUCTS . " SET products_weight=$new_weight WHERE products_id=$id");
             }
           }
        }
        if($_POST['product_new_quantity']){
           foreach($_POST['product_new_quantity'] as $id => $new_quantity) {
             if ($_POST['product_new_quantity'][$id] != $_POST['product_old_quantity'][$id]) {
               $count_update++;
               $item_updated[$id] = 'updated';
               mysql_query("UPDATE " . TABLE_PRODUCTS . " SET products_quantity=$new_quantity WHERE products_id=$id");
             }
           }
        }
        if($_POST['product_new_to_xml']){
           foreach($_POST['product_new_to_xml'] as $id => $new_to_xml) {
             if ($_POST['product_new_to_xml'][$id] != $_POST['product_old_to_xml'][$id]) {
               $count_update++;
               $item_updated[$id] = 'updated';
               mysql_query("UPDATE " . TABLE_PRODUCTS . " SET products_to_xml=$new_to_xml WHERE products_id=$id");
             }
           }
        }
        if($_POST['product_new_startpage']){
           foreach($_POST['product_new_startpage'] as $id => $new_to_xml) {
             if ($_POST['product_new_startpage'][$id] != $_POST['product_old_startpage'][$id]) {
               $count_update++;
               $item_updated[$id] = 'updated';
               mysql_query("UPDATE " . TABLE_PRODUCTS . " SET products_startpage=$new_startpage WHERE products_id=$id");
             }
           }
        }
        if($_POST['product_new_sort']){
           foreach($_POST['product_new_sort'] as $id => $new_sort) {
             if ($_POST['product_new_sort'][$id] != $_POST['product_old_sort'][$id]) {
               $count_update++;
               $item_updated[$id] = 'updated';
               mysql_query("UPDATE " . TABLE_PRODUCTS . " SET products_sort=$new_sort WHERE products_id=$id");
             }
           }
        }
          if($_POST['product_new_image']){
           foreach($_POST['product_new_image'] as $id => $new_image) {
             if (trim($_POST['product_new_image'][$id]) != trim($_POST['product_old_image'][$id])) {
               $count_update++;
               $item_updated[$id] = 'updated';
               mysql_query("UPDATE " . TABLE_PRODUCTS_DESCRIPTION . " SET products_image='" . $new_image . "' WHERE products_id=$id");
             }
           }
        }
        if($_POST['product_new_manufacturer']){
           foreach($_POST['product_new_manufacturer'] as $id => $new_manufacturer) {
             if ($_POST['product_new_manufacturer'][$id] != $_POST['product_old_manufacturer'][$id]) {
               $count_update++;
               $item_updated[$id] = 'updated';
               mysql_query("UPDATE " . TABLE_PRODUCTS . " SET manufacturers_id=$new_manufacturer WHERE products_id=$id");
             }
           }
        }
           if($_POST['product_new_status']){
               foreach($_POST['product_new_status'] as $id => $new_status) {
                 if ($_POST['product_new_status'][$id] != $_POST['product_old_status'][$id]) {
                   $count_update++;
                   $item_updated[$id] = 'updated';
                   vam_set_product_status($id, $new_status);

                 }
               }
        }
           if($_POST['product_new_tax']){
               foreach($_POST['product_new_tax'] as $id => $new_tax_id) {
                 if ($_POST['product_new_tax'][$id] != $_POST['product_old_tax'][$id]) {
                   $count_update++;
                   $item_updated[$id] = 'updated';
                   mysql_query("UPDATE " . TABLE_PRODUCTS . " SET products_tax_class_id=$new_tax_id WHERE products_id=$id");
                 }
               }
        }
     $count_item = array_count_values($item_updated);
     if ($count_item['updated'] > 0) $messageStack->add($count_item['updated'].' '.TEXT_PRODUCTS_UPDATED . " $count_update " . TEXT_QTY_UPDATED, 'success');
     break;

     case 'calcul' :
      if ($_POST['spec_price']) $preview_global_price = 'true';
     break;
 }

//// explode string parameters from preview product
     if($info_back && $info_back!="-") {
       $infoback = explode('-',$info_back);
       $sort_by = $infoback[0];
       $page =  $infoback[1];
       $current_category_id = $infoback[2];
       $row_by_page = $infoback[3];
       $manufacturer = $infoback[4];
     }

//// define the sxtc for rollover lines per page
   $row_bypage_array = array(array());
   for ($i = 50; $i <= 500 ; $i=$i+50) {
      $row_bypage_array[] = array('id' => $i,
                                  'text' => $i);
   }

##// Let's start displaying page with forms
?>

>


<?php echo TITLE; ?>











  

    



    


    
    
    
    
    
  
        

                
';

                    echo vam_draw_form('search', FILENAME_QUICK_UPDATES, '', 'get');
                    echo HEADING_TITLE_SEARCH_MODEL . ' ' . vam_draw_input_field('search') . vam_draw_hidden_field('search_model_key','yes');
                    echo '';
                ?>
  
  
  

  



  
      
           
                
                    
                    
                        
                        
                        
                        
                        
                        
                    
                
                
                    
                        
                               method="post">
                                       ' . vam_draw_checkbox_field('marge','yes','','no') . ' ' . TEXT_MARGE_INFO;}?>
                                     
                               

                                            
                                             
                                           ';
                                         } else { echo ' ' . vam_image(DIR_WS_IMAGES . 'icons/buttons/cancel.png', '', '12', '12') . ' ' . BUTTON_CANCEL . ''; } ?>
                                          
                                     
                                           
                                            
                                           
                                     
                                
                            
                        
                    
                    
                
            
            

            ">
                        " . '' . "\n";
                        ?>

                        
                    
                        
 
                        
                    
            

'; }else{ echo '';}
        if(DISPLAY_MODEL == 'true'){if(MODIFY_MODEL == 'true')echo "\n";else echo "\n";}else{ echo "\n";else echo "\n";
//// Product status radio button
        if(DISPLAY_STATUT == 'true'){
            if ($products['products_status'] == '1') {
             echo "\n";
            } else {
             echo "\n";
            }
        }else{
            echo "";
        }
        if(DISPLAY_WEIGHT == 'true')echo "\n";else echo "";
        if(DISPLAY_QUANTITY == 'true')echo "\n";else echo "";
        if(DISPLAY_XML == 'true')echo "\n";else echo "";
        if(DISPLAY_START_PAGE == 'true')echo "\n";else echo "";
        if(DISPLAY_SORT == 'true')echo "\n";else echo "";
        if(DISPLAY_IMAGE == 'true')echo "\n";else echo "";
        if(DISPLAY_MANUFACTURER == 'true'){if(MODIFY_MANUFACTURER == 'true')echo "\n";else echo "";}else{ echo "";}
//// check specials
        if ( in_array($products['products_id'],$specials_array)) {
            echo "\n";
        } else {
            if ($flag_spec == 'true') {
                   echo "\n";
            } else { echo "\n";}
        }
       
        //
        $xquery = "SELECT `personal_offer` FROM `personal_offers_by_customers_status_1` WHERE `products_id` = '" . $products['products_id'] . "'";
        $xres = mysql_query($xquery);
        $xobj = mysql_fetch_object($xres);
        $xprice1 = $xobj->personal_offer;

    if ($_POST['spec_price']){
    // dopisac aby dzialalo
      $spec_price = $_POST['spec_price'];
      $flag_spec = 'true' ;

      if (substr($_POST['spec_price'],-1) == '%') {
          if($_POST['marge'] && substr($_POST['spec_price'],0,1) != '-'){
            $valeur = (1 - (preg_replace("/%/", "", $_POST['spec_price']) / 100));
            $xprice1 = sprintf("%01.2f", round($xobj->personal_offer / $valeur,2));
        }else{
            $xprice1 = sprintf("%01.2f", round($xobj->personal_offer + (($spec_price / 100) * $xobj->personal_offer),2));
          }
      } else $xprice1 = sprintf("%01.2f", round($xobj->personal_offer + $spec_price,2));
    } else $xprice1 = $xobj->personal_offer ;


        if ( in_array($products['products_id'],$specials_array)) {
            echo "\n";
        } else {
            if ($flag_spec == 'true') {
                   echo "\n";
            } else { echo "\n";
            }
               echo vam_draw_hidden_field('product_old_price1['.$products['products_id'].']', $xprice1);
        }

        //
        $xquery2 = "SELECT `personal_offer` FROM `personal_offers_by_customers_status_2` WHERE `products_id` = '" . $products['products_id'] . "'";
        $xres2 = mysql_query($xquery2);
        $xobj2 = mysql_fetch_object($xres2);
        $xprice2 = $xobj->personal_offer;
        
    if ($_POST['spec_price']){
    // dopisac aby dzialalo
      $spec_price = $_POST['spec_price'];
      $flag_spec = 'true' ;

      if (substr($_POST['spec_price'],-1) == '%') {
          if($_POST['marge'] && substr($_POST['spec_price'],0,1) != '-'){
            $valeur = (1 - (preg_replace("/%/", "", $_POST['spec_price']) / 100));
            $xprice2 = sprintf("%01.2f", round($xobj2->personal_offer / $valeur,2));
        }else{
            $xprice2 = sprintf("%01.2f", round($xobj2->personal_offer + (($spec_price / 100) * $xobj2->personal_offer),2));
          }
      } else $xprice2 = sprintf("%01.2f", round($xobj2->personal_offer + $spec_price,2));
    } else $xprice2 = $xobj2->personal_offer ;
        
        if ( in_array($products['products_id'],$specials_array)) {
            echo "\n";
        } else {
            if ($flag_spec == 'true') {
                   echo "\n";
            } else { echo "\n";
            }
               echo vam_draw_hidden_field('product_old_price2['.$products['products_id'].']', $xprice2);
        }

        //
        $xquery3 = "SELECT `personal_offer` FROM `personal_offers_by_customers_status_3` WHERE `products_id` = '" . $products['products_id'] . "'";
        $xres3 = mysql_query($xquery3);
        $xobj3 = mysql_fetch_object($xres3);
        $xprice3 = $xobj3->personal_offer;
        
    if ($_POST['spec_price']){
    // dopisac aby dzialalo
      $spec_price = $_POST['spec_price'];
      $flag_spec = 'true' ;

      if (substr($_POST['spec_price'],-1) == '%') {
          if($_POST['marge'] && substr($_POST['spec_price'],0,1) != '-'){
            $valeur = (1 - (preg_replace("/%/", "", $_POST['spec_price']) / 100));
            $xprice3 = sprintf("%01.2f", round($xobj3->personal_offer / $valeur,2));
        }else{
            $xprice3 = sprintf("%01.2f", round($xobj3->personal_offer + (($spec_price / 100) * $xobj3->personal_offer),2));
          }
      } else $xprice3 = sprintf("%01.2f", round($xobj3->personal_offer + $spec_price,2));
    } else $xprice3 = $xobj3->personal_offer ;
        
        if ( in_array($products['products_id'],$specials_array)) {
            echo "\n";
        } else {
            if ($flag_spec == 'true') {
                   echo "\n";
            } else { echo "\n";
            }
               echo vam_draw_hidden_field('product_old_price3['.$products['products_id'].']', $xprice3);
        }
        
        if(DISPLAY_TAX == 'true'){if(MODIFY_TAX == 'true')echo "\n";else echo "";}else{ echo "";}
        
//// links to preview or full edit
        if(DISPLAY_PREVIEW == 'true')echo "";else{ echo "";}"\n";
        if(DISPLAY_EDIT == 'true')echo "";else{ echo "";}"\n";

//// Hidden parameters for cache old values
        if(MODIFY_NAME == 'true') echo vam_draw_hidden_field('product_old_name['.$products['products_id'].'] ',$products['products_name']);
        if(MODIFY_MODEL == 'true') echo vam_draw_hidden_field('product_old_model['.$products['products_id'].'] ',$products['products_model']);
        echo vam_draw_hidden_field('product_old_status['.$products['products_id'].']',$products['products_status']);
        echo vam_draw_hidden_field('product_old_quantity['.$products['products_id'].']',$products['products_quantity']);
        echo vam_draw_hidden_field('product_old_to_xml['.$products['products_id'].']',$products['products_to_xml']);
        echo vam_draw_hidden_field('product_old_startpage['.$products['products_id'].']',$products['products_startpage']);
        echo vam_draw_hidden_field('product_old_sort['.$products['products_id'].']',$products['products_sort']);
        echo vam_draw_hidden_field('product_old_image['.$products['products_id'].']',$products['products_image']);
        if(MODIFY_MANUFACTURER == 'true')echo vam_draw_hidden_field('product_old_manufacturer['.$products['products_id'].']',$products['manufacturers_id']);
        echo vam_draw_hidden_field('product_old_weight['.$products['products_id'].']',$products['products_weight']);
        echo vam_draw_hidden_field('product_old_price['.$products['products_id'].']',$products['products_price']);
        if(MODIFY_TAX == 'true')echo vam_draw_hidden_field('product_old_tax['.$products['products_id'].']',$products['products_tax_class_id']);
//// hidden display parameters
        echo vam_draw_hidden_field( 'row_by_page', $row_by_page);
        echo vam_draw_hidden_field( 'sort_by', $sort_by);
        echo vam_draw_hidden_field( 'page', $split_page);
     }
?>

              
                
                  ↓" .
                     TABLE_HEADING_MODEL ."
                
                
                  
                
                
                  
                
                
                  ↓" .
                     TABLE_HEADING_TAX . " 1) $rows = $split_page * MAX_DISPLAY_ROW_BY_PAGE - MAX_DISPLAY_ROW_BY_PAGE;


////  select categories

//
    if (isset($_GET['search']) && strlen(trim($_GET['search']))>0 ){ 
     if ($_GET['search_model_key'] == 'no'){
        $products_query_raw = "select p.products_id, p.products_image, p.products_model, pd.products_name, p.products_status, p.products_sort, p.products_to_xml, p.products_startpage, p.products_weight, p.products_quantity, p.manufacturers_id, p.products_price, p.products_tax_class_id from  " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION .  " pd where p.products_id = pd.products_id and pd.language_id = '" . $_SESSION['languages_id'] . "' and pd.products_name like '%" . $_GET['search'] . "%' $sort_by ";
        }else{
        $products_query_raw = "select p.products_id, p.products_image, p.products_model, pd.products_name, p.products_status, p.products_sort, p.products_to_xml, p.products_startpage, p.products_weight, p.products_quantity, p.manufacturers_id, p.products_price, p.products_tax_class_id from  " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION .  " pd where p.products_id = pd.products_id and pd.language_id = '" . $_SESSION['languages_id'] . "' and p.products_model like '%" . $_GET['search'] . "%' $sort_by ";
        }
    }else{

////
  if ($current_category_id == 0){
      if($manufacturer){
        $products_query_raw = "select p.products_id, p.products_image, p.products_model, pd.products_name, p.products_status, p.products_sort, p.products_to_xml, p.products_startpage, p.products_weight, p.products_quantity, p.manufacturers_id, p.products_price, p.products_tax_class_id from  " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION .  " pd where p.products_id = pd.products_id and pd.language_id = '" . $_SESSION['languages_id'] . "' and p.manufacturers_id = " . $manufacturer . " $sort_by ";
      }else{
        $products_query_raw = "select p.products_id, p.products_image, p.products_model, pd.products_name, p.products_status, p.products_sort, p.products_to_xml, p.products_startpage, p.products_weight, p.products_quantity, p.manufacturers_id, p.products_price, p.products_tax_class_id from  " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION .  " pd where p.products_id = pd.products_id and pd.language_id = '" . $_SESSION['languages_id'] . "' $sort_by ";
    }
  } else {
     if($manufacturer){
         $products_query_raw = "select p.products_id, p.products_image, p.products_model, pd.products_name, p.products_status, p.products_sort, p.products_to_xml, p.products_startpage, p.products_weight, p.products_quantity, p.manufacturers_id, p.products_price, p.products_tax_class_id from  " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION .  " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " pc where p.products_id = pd.products_id and pd.language_id = '" . $_SESSION['languages_id'] . "' and p.products_id = pc.products_id and pc.categories_id = '" . $current_category_id . "' and p.manufacturers_id = " . $manufacturer . " $sort_by ";
      }else{
        $products_query_raw = "select p.products_id, p.products_image, p.products_model, pd.products_name, p.products_status, p.products_sort, p.products_to_xml, p.products_startpage, p.products_weight, p.products_quantity, p.manufacturers_id, p.products_price, p.products_tax_class_id from  " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION .  " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " pc where p.products_id = pd.products_id and pd.language_id = '" . $_SESSION['languages_id'] . "' and p.products_id = pc.products_id and pc.categories_id = '" . $current_category_id . "' $sort_by ";
    }
  }
}
//// page splitter and display each products info
  $products_split = new splitPageResults($split_page, MAX_DISPLAY_ROW_BY_PAGE, $products_query_raw, $products_query_numrows);
  $products_query = vam_db_query($products_query_raw);
  while ($products = vam_db_fetch_array($products_query)) {
    $rows++;
    if (strlen($rows) < 2) {
      $rows = '0' . $rows;
    }
//// check for global add value or rates, calcul and round values rates
    if ($_POST['spec_price']){
    // dopisac aby dzialalo
      $spec_price = $_POST['spec_price'];
      $flag_spec = 'true' ;

      if (substr($_POST['spec_price'],-1) == '%') {
          if($_POST['marge'] && substr($_POST['spec_price'],0,1) != '-'){
            $valeur = (1 - (preg_replace("/%/", "", $_POST['spec_price']) / 100));
            $price = sprintf("%01.2f", round($products['products_price'] / $valeur,2));
        }else{
            $price = sprintf("%01.2f", round($products['products_price'] + (($spec_price / 100) * $products['products_price']),2));
          }
      } else $price = sprintf("%01.2f", round($products['products_price'] + $spec_price,2));
    } else $price = $products['products_price'] ;

//// Check Tax_rate for displaying TTC
    $tax_query = vam_db_query("select r.tax_rate, c.tax_class_title from " . TABLE_TAX_RATES . " r, " . TABLE_TAX_CLASS . " c where r.tax_class_id=" . $products['products_tax_class_id'] . " and c.tax_class_id=" . $products['products_tax_class_id']);
    $tax_rate = vam_db_fetch_array($tax_query);
    if($tax_rate['tax_rate'] == '')$tax_rate['tax_rate'] = 0;

    if(MODIFY_MANUFACTURER == 'false'){
        $manufacturer_query = vam_db_query("select manufacturers_name from " . TABLE_MANUFACTURERS . " where manufacturers_id=" . $products['manufacturers_id']);
        $manufacturer = vam_db_fetch_array($manufacturer_query);
    }
//// display infos per row
        if($flag_spec){echo '
 " . $products['products_model'] . " ";}
        if(MODIFY_NAME == 'true')echo " " . vam_draw_input_field('product_new_name['.$products['products_id'].'] ',$products['products_name']) ." ".$products['products_name']."               ".vam_draw_pull_down_menu("product_new_manufacturer[".$products['products_id']."]\"", $manufacturers_array, $products['manufacturers_id'])." " . $manufacturer['manufacturers_name'] . "     ". vam_image(DIR_WS_IMAGES . 'icon_info.gif', TEXT_SPECIALS_PRODUCTS) ."  ".vam_draw_checkbox_field('update_price['.$products['products_id'].']','yes','checked','no')."  ".vam_draw_hidden_field('update_price['.$products['products_id'].']','yes'). "   ". vam_image(DIR_WS_IMAGES . 'icon_info.gif', TEXT_SPECIALS_PRODUCTS) ."       ". vam_image(DIR_WS_IMAGES . 'icon_info.gif', TEXT_SPECIALS_PRODUCTS) ."       ". vam_image(DIR_WS_IMAGES . 'icon_info.gif', TEXT_SPECIALS_PRODUCTS) ."     ".vam_draw_pull_down_menu("product_new_tax[".$products['products_id']."]\"", $tax_class_array, $products['products_tax_class_id'])." " . $tax_rate['tax_class_title'] . "    ". vam_image(DIR_WS_IMAGES . 'icon_info.gif', TEXT_IMAGE_PREVIEW) ."    ". vam_image(DIR_WS_IMAGES . 'icon_arrow_right.gif', TEXT_IMAGE_SWITCH_EDIT) ."  


' . vam_image(DIR_WS_IMAGES . 'icons/buttons/cancel.png', '', '12', '12') . ' ' . BUTTON_CANCEL . ' ';
?>






    


        
      
            
                
                    display_count($products_query_numrows, MAX_DISPLAY_ROW_BY_PAGE, $split_page, TEXT_DISPLAY_NUMBER_OF_PRODUCTS);  ?>
                    display_links($products_query_numrows, MAX_DISPLAY_ROW_BY_PAGE, MAX_DISPLAY_PAGE_LINKS, $split_page, '&cPath='. $current_category_id . '&manufacturer='. $manufacturer .'&sort_by='.$sort_by . '&row_by_page=' . $row_by_page . '&search=' . $search . '&search_model_key=' . $search_model_key); ?>

Re: 1064: You have an error in your SQL syntax

null@example.com (Hanut) — Fri, 07 Dec 2012 12:47:35 +0000

При экспорте выставьте режим совместимости MSQL323, тогда импорт должен пройти успешно. Хотя я рекомендую установить локально MySQL4, чтобы избежать подобных ошибок.

Re: 1064: You have an error in your SQL syntax

null@example.com (Неопытная) — Fri, 07 Dec 2012 12:15:55 +0000

Напишите, пожалуйста пошагово, что я должна сделать?

Re: 1064: You have an error in your SQL syntax

null@example.com (Неопытная) — Fri, 07 Dec 2012 11:55:18 +0000

В какое время с вами удобнее переписываться?

Re: 1064: You have an error in your SQL syntax

null@example.com (Неопытная) — Fri, 07 Dec 2012 11:53:40 +0000

это какие именно не подскажете? Потому что я делала: gzip, ставила галочку Drop Table... ( не помню точно там через слеш), кодировку указывала 1251, максимальную совместимость с MSQL323

Re: 1064: You have an error in your SQL syntax

null@example.com (Hanut) — Fri, 07 Dec 2012 11:08:53 +0000

Чтобы импортировать дамп с MySQL 4 на MySQL 3, необходимо задать соответствующий режим совместимости в phpMyAdmin на странице экспорта.

Re: 1064: You have an error in your SQL syntax

null@example.com (Неопытная) — Fri, 07 Dec 2012 09:54:42 +0000

Вот открыла в вашей програмке, которой Вы поделились, могу прикрепить скриншот, но незнаю как.

Hanut сказал:

Посмотрите какой версии MySQL на сервере, куда дамп импортируется.
Пожалуйста: http://notepad-plus-plus.org/download/v6.2.2.html

Re: 1064: You have an error in your SQL syntax

null@example.com (Неопытная) — Fri, 07 Dec 2012 09:47:48 +0000

Спасибо. Пробовала скачивать новую версию пхп ( вообще переустанавливала джентельментский набор), при этом дамп импортировался но аероглифами. Потом я переустановила на старую версию, в которой и раньше работала (раньше проблем не возникало) : Дамп импортируется ко мне phpMyAdmin 2.5.6

MySQL 3.23.53-max. Информация с сервера: Сервер: Localhost via UNIX socket
Версия сервера: 5.1.56-log
Версия протокола: 10
Пользователь: sexkur@localhost
MySQL-кодировка: UTF-8 Unicode (utf8)
Веб-сервер

cpsrvd 11.34.0.11
Версия MySQL-клиента: 4.1.22
PHP расширение: mysql
phpMyAdmin

Информация о версии: 3.4.11.1

Hanut сказал:

Посмотрите какой версии MySQL на сервере, куда дамп импортируется.
Пожалуйста: http://notepad-plus-plus.org/download/v6.2.2.html

Re: 1064: You have an error in your SQL syntax

null@example.com (Hanut) — Fri, 07 Dec 2012 05:33:20 +0000

Посмотрите какой версии MySQL на сервере, куда дамп импортируется.

Пожалуйста: http://notepad-plus-plus.org/download/v6.2.2.html

Re: 1064: You have an error in your SQL syntax

null@example.com (Неопытная) — Thu, 06 Dec 2012 21:34:30 +0000

Hanut сказал:

Неопытная сказал:
SET time_zone =
Попробуйте убрать эту строку из дампа. Открыть дамп можно в редакторе Notepad++.

Подкинте, пожалуйста ссылку для скачивания этого редактора. И почему-то не всё сообщение я отправила Вам.. Вот полный текст ошибки: SQL-запрос :

--
SET time_zone = "+00:00"

Ответ MySQL:
#1064 - You have an error in your SQL syntax near 'time_zone = "+00:00"' at line 2

Re: 1064: You have an error in your SQL syntax

null@example.com (Hanut) — Wed, 05 Dec 2012 07:25:49 +0000

Неопытная сказал:

SET time_zone =

Попробуйте убрать эту строку из дампа. Открыть дамп можно в редакторе Notepad++.

Re: 1064: You have an error in your SQL syntax

null@example.com (Неопытная) — Wed, 05 Dec 2012 06:38:39 +0000

Я впервые на этом форуме. Ответ ищу очень давно... Скачиваю дамп и импортирую к себе в пхпмайадмин, но он стал выдавать ошибку: Ошибка

SQL-запрос :
--
SET time_zone =

Re: 1064: You have an error in your SQL syntax

null@example.com (psiisyapk) — Fri, 22 Oct 2010 15:01:02 +0000

все, сам нашел свою ошибку, заработало)

Re: 1064: You have an error in your SQL syntax

null@example.com (psiisyapk) — Fri, 22 Oct 2010 14:43:42 +0000

возник тут ещё вопрос по той же теме))
при изменении в форме значения поля таблицы файл обработчик пишет что изменения внесены, но при этом ещё - Undefined variable на строке 44

if (isset($nameles) && isset($meta_d) && isset($meta_k) && isset($desc) && isset($date) && isset($text) && isset($author))

{ /*можем заносить данные в базу */

строка 44 ----- $result = mysql_query("UPDATE lessons SET
nameles='$nameles',meta_d='$meta_d',meta_k='$meta_k',date='$date','desc'='$desc',`text`='$text',author='$author' WHERE id='$id'");

if ($result==true) {echo "

Изменения внесены в базу!

";}
else {echo "Изменения НЕ внесены в базу!" . mysql_error();}

}
else { echo "

Вы не заполнили все поля.

";}
?>

я подозреваю что это может быть из-за desc но косые кавычки не помогают