Проблема При переносе на хостинг ошибка

Discussion in 'Перенос Joomla на хостинг и проблемы с хостингом' started by anonymn1ck, May 16, 2015.

  1. anonymn1ck
    Offline

    anonymn1ck Недавно здесь

    Joined:
    May 16, 2015
    Messages:
    6
    Likes Received:
    0
    Gender:
    Female
    Joomla 3.3.6 Сделал бекапы, залил все. В админку заходит, а при заходе на сайта выдает следующее:

    Unknown column 'prod.name_' in 'field list' SQL=SELECT prod.product_id, pr_cat.category_id, prod.`name_` as name, prod.`short_description_` as short_description, prod.product_ean, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices, prod.unlimited FROM `mtgqh_jshopping_products` AS prod INNER JOIN `mtgqh_jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id LEFT JOIN `mtgqh_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish = '1' AND cat.category_publish='1' AND prod.access IN (1,1,5) AND cat.access IN (1,1,5) AND prod.product_price >= '0' AND prod.product_price <= '999999' GROUP BY prod.product_id ORDER BY prod.product_id DESC LIMIT 5

    помогите решить проблему, готов оплатить помощь. Спасибо.
     
    anonymn1ck, May 16, 2015
    #1

  2. Ads Master

     
  3. woojin
    Offline

    woojin Местный Staff Member => Cпециалист <=

    Joined:
    May 31, 2009
    Messages:
    3,204
    Likes Received:
    334
    Gender:
    Male
    надо смотреть на сами файлы, т.к. по ошибке ясно только одно, что неправильно заполняется какое то поле компонента Jshopping
    а заказы платных услуг в другой теме!
     
    woojin, May 16, 2015
    #2
  4. OlegK
    Offline

    OlegK Russian Joomla! Team Staff Member ⇒ Профи ⇐

    Joined:
    Jan 17, 2011
    Messages:
    7,812
    Likes Received:
    771
    Gender:
    Male
    Код (PHP):
    1. Unknown column 'prod.name_' in 'field list' SQL=SELECT prod.product_id, pr_cat.category_id, prod.`name_ru-RU` as name, prod.`short_description_ru-RU` as short_description, prod.product_ean, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices, prod.unlimited FROM `mtgqh_jshopping_products` AS prod INNER JOIN `mtgqh_jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id LEFT JOIN `mtgqh_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish = '1' AND cat.category_publish='1' AND prod.access IN (1,1,5) AND cat.access IN (1,1,5) AND prod.product_price >= '0' AND prod.product_price <= '999999' GROUP BY prod.product_id ORDER BY prod.product_id DESC LIMIT 5

    phpmyadmin -> SQL и пробуй выполнить запрос
     
    OlegK, May 16, 2015
    #3
  5. anonymn1ck
    Offline

    anonymn1ck Недавно здесь

    Joined:
    May 16, 2015
    Messages:
    6
    Likes Received:
    0
    Gender:
    Female
    выполнил, выдает следующее:

    #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 'Unknown column 'prod.name_' in 'field list' SQL=SELECT prod.product_id, pr_cat.c' at line 1
     
    anonymn1ck, May 16, 2015
    #4
  6. OlegK
    Offline

    OlegK Russian Joomla! Team Staff Member ⇒ Профи ⇐

    Joined:
    Jan 17, 2011
    Messages:
    7,812
    Likes Received:
    771
    Gender:
    Male
    А стоп, ты скопировал весь код.Пробуй так
    Код (PHP):
    1. SELECT prod.product_id, pr_cat.category_id, prod.`name_ru-RU` as name, prod.`short_description_ru-RU` as short_description, prod.product_ean, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices, prod.unlimited FROM `mtgqh_jshopping_products` AS prod INNER JOIN `mtgqh_jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id LEFT JOIN `mtgqh_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish = '1' AND cat.category_publish='1' AND prod.access IN (1,1,5) AND cat.access IN (1,1,5) AND prod.product_price >= '0' AND prod.product_price <= '999999' GROUP BY prod.product_id ORDER BY prod.product_id DESC LIMIT 5
     
    OlegK, May 16, 2015
    #5
  7. anonymn1ck
    Offline

    anonymn1ck Недавно здесь

    Joined:
    May 16, 2015
    Messages:
    6
    Likes Received:
    0
    Gender:
    Female
    сделал, пишет

    #1046 - No database selected
    Данное выделение не содержит уникального столбца. Изменение сетки, выставление галочки, редактирование, копирование и удаление невозможно.
    dot.gif Отображение строк 0 - 4 (5 всего, Запрос занял 0.0006 сек.) [product_id: 2911 - 2907]
     

    Attached Files:

    • dot.gif
      dot.gif
      File size:
      43 bytes
      Views:
      2
    anonymn1ck, May 16, 2015
    #6
  8. OlegK
    Offline

    OlegK Russian Joomla! Team Staff Member ⇒ Профи ⇐

    Joined:
    Jan 17, 2011
    Messages:
    7,812
    Likes Received:
    771
    Gender:
    Male
    А выбрать базу данных,к которой делаешь запрос, пробовал ?
     
    OlegK, May 16, 2015
    #7
  9. anonymn1ck
    Offline

    anonymn1ck Недавно здесь

    Joined:
    May 16, 2015
    Messages:
    6
    Likes Received:
    0
    Gender:
    Female
    я выбрал все ок, на сайте теперь следующее отображется

    Unknown column 'prod.name_' in 'field list' SQL=SELECT prod.product_id, pr_cat.category_id, prod.`name_` as name, prod.`short_description_` as short_description, prod.product_ean, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices, prod.unlimited FROM `mtgqh_jshopping_products` AS prod INNER JOIN `mtgqh_jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id LEFT JOIN `mtgqh_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish = '1' AND cat.category_publish='1' AND prod.access IN (1,1,5) AND cat.access IN (1,1,5) AND prod.product_price >= '0' AND prod.product_price <= '999999' GROUP BY prod.product_id ORDER BY prod.product_id DESC LIMIT 5
     
    anonymn1ck, May 16, 2015
    #8
< При включении SSL перестал пускать в административный раздел | Где указать путь к картинкам >

Share This Page

Loading...