arus98
08-07-2013, 09:52
Witam, mam wielki problem z którym nie mogę sobie poradzić. A mianowicie robiłem stronę internetową w joomla 3x a chciałem robić w starszej 2.5 więc pobrałem joomla 2.5 na komputer i wgrałem ją w " instalacja" i wyskoczył błąd...
500 - Nieznana kolumna 'a.title_alias "w" Lista pól' = SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, SQL PRZYPADKU GDY badcats.id IS NULL THEN a.state ELSE 0 END AS stanie a.mask, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 to a.created ELSE a.modified END zmieniony , a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.parentid, a.ordering, a.metakey, . metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference, c.title AS category_title, c.alias AS category_alias, c.access AS category_access, u.name AS autora , contact.id jak ContactID, parent.title jak parent_title, parent.id jak parent_id, parent.path jako parent_route, parent.alias jak parent_alias, okrągłe (v.rating_sum / v.rating_count, 0) W rankingu, v.rating_count jako rating_count FROM jos_content AS LEFT JOIN jos_categories jako C na c.id = a.catid LEFT JOIN jos_users jak u na u.id = a.created_by LEFT JOIN (SELECT contact.user_id, MAX (contact.id) AS id, kontakt. język z jos_contact_details AS kontakt GDZIE contact.published = 1 GROUP BY contact.user_id, contact.language) jako kontakt na contact.user_id = a.created_by LEFT JOIN jos_categories jak rodzic ON parent.id = c.parent_id LEFT JOIN jos_content_rating AS V na a.id = v.content_id lewe sprzężenie zewnętrzne (SELECT cat.id jako identyfikator z jos_categories AS cat DOŁĄCZ jos_categories AS Parent cat.lft MIĘDZY parent.lft I parent.rgt gdzie "com_content" parent.extension = I parent.published < = 0 GROUP BY cat.id) AS badcats NA badcats.id = c.id WHERE a.id = 0 AND (a.publish_up = '0000-00-00 00:00:00 'OR a.publish_up <= '2013 -07-08 07:42:35 ') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down> = '2013-07-08 07:42:35 ')
Tu macie stronę z błędem: http://wojtkar.com.pl/index.php
BARDZO PROSZĘ O POMOC !!! Pozdrawiam .
500 - Nieznana kolumna 'a.title_alias "w" Lista pól' = SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, SQL PRZYPADKU GDY badcats.id IS NULL THEN a.state ELSE 0 END AS stanie a.mask, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 to a.created ELSE a.modified END zmieniony , a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.parentid, a.ordering, a.metakey, . metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference, c.title AS category_title, c.alias AS category_alias, c.access AS category_access, u.name AS autora , contact.id jak ContactID, parent.title jak parent_title, parent.id jak parent_id, parent.path jako parent_route, parent.alias jak parent_alias, okrągłe (v.rating_sum / v.rating_count, 0) W rankingu, v.rating_count jako rating_count FROM jos_content AS LEFT JOIN jos_categories jako C na c.id = a.catid LEFT JOIN jos_users jak u na u.id = a.created_by LEFT JOIN (SELECT contact.user_id, MAX (contact.id) AS id, kontakt. język z jos_contact_details AS kontakt GDZIE contact.published = 1 GROUP BY contact.user_id, contact.language) jako kontakt na contact.user_id = a.created_by LEFT JOIN jos_categories jak rodzic ON parent.id = c.parent_id LEFT JOIN jos_content_rating AS V na a.id = v.content_id lewe sprzężenie zewnętrzne (SELECT cat.id jako identyfikator z jos_categories AS cat DOŁĄCZ jos_categories AS Parent cat.lft MIĘDZY parent.lft I parent.rgt gdzie "com_content" parent.extension = I parent.published < = 0 GROUP BY cat.id) AS badcats NA badcats.id = c.id WHERE a.id = 0 AND (a.publish_up = '0000-00-00 00:00:00 'OR a.publish_up <= '2013 -07-08 07:42:35 ') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down> = '2013-07-08 07:42:35 ')
Tu macie stronę z błędem: http://wojtkar.com.pl/index.php
BARDZO PROSZĘ O POMOC !!! Pozdrawiam .