Joomla: DB function failed with error number 1054
Posted by admin in joomla, tips
Spletni portal narejen s sistemom Joomla je bil prenešen s starega strežnika, ki je podpiral MySql 4.1.x na nov strežnik, ki pa podpira MySql 5.
Ko sem hotela urejati vsebino spletnega portala v administraciji Joomle sem naletela na sledeče opozorilo o napaki:
DB function failed with error number 1054
Unknown column ‘c.access’ in ‘on clause’ SQL=SELECT c.*, g.name AS groupname, cc.name, u.name AS editor, f.content_id AS frontpage, s.title AS section_name, v.name AS author FROM jos_content AS c, jos_categories AS cc, jos_sections AS s LEFT JOIN jos_groups AS g ON g.id = c.access LEFT JOIN jos_users AS u ON u.id = c.checked_out LEFT JOIN jos_users AS v ON v.id = c.created_by LEFT JOIN jos_content_frontpage AS f ON f.content_id = c.id WHERE c.state >= 0 AND c.catid = cc.id AND cc.section = s.id AND s.scope = ‘content’ ORDER BY s.title, c.catid, cc.ordering, cc.title, c.ordering LIMIT 0, 10
Ta napaka se lahko popravi s popravkom v datoteki: /administrator/components/com_content/admin.content.php
Najdi del kode:
$query = “SELECT c.*, g.name AS groupname, cc.name, u.name AS editor, f.content_id AS frontpage, s.title AS section_name, v.name AS author”
. “\n FROM #__content AS c, #__categories AS cc, #__sections AS s”
. “\n LEFT JOIN #__groups AS g ON g.id = c.access”
. “\n LEFT JOIN #__users AS u ON u.id = c.checked_out”
. “\n LEFT JOIN #__users AS v ON v.id = c.created_by”
. “\n LEFT JOIN #__content_frontpage AS f ON f.content_id = c.id”
. ( count( $where ) ? “\nWHERE ” . implode( ‘ AND ‘, $where ) : ” )
. $order
. “\n LIMIT $pageNav->limitstart,$pageNav->limit”
;
In ga zamenjaj z:
$query = “SELECT c.*, g.name AS groupname, cc.name, u.name AS editor, f.content_id AS frontpage, s.title AS section_name, v.name AS author”
. “\n FROM #__content AS c” //, #__categories AS cc, #__sections AS s”
. “\n LEFT JOIN #__groups AS g ON g.id = c.access”
. “\n LEFT JOIN #__users AS u ON u.id = c.checked_out”
. “\n LEFT JOIN #__users AS v ON v.id = c.created_by”
. “\n LEFT JOIN #__content_frontpage AS f ON f.content_id = c.id”
. “\n LEFT OUTER JOIN #__categories AS cc ON c.catid=cc.id”
. “\n LEFT OUTER JOIN #__sections AS s ON cc.section=s.id”
. ( count( $where ) ? “\nWHERE ” . implode( ‘ AND ‘, $where ) : ” )
. $order
. “\n LIMIT $pageNav->limitstart,$pageNav->limit”
;
Joomla! 1.5 Stable je na voljo
Posted by admin in joomla
Skupnost Joomla! je oznanila, da je Joomla! 1.5 Stable (stabilna verzija) na voljo za uporabo.
Oglejte si pregled Joomla! 1.5.
Prenesi Joomla1.5.0.
Potrebuješ pomoč pri inštalaciji Joomle? Tukaj je Inštalacijski priročnik za Joomlo.
JCE editor za Joomlo
Posted by admin in joomla
Pri postavljanju spletnih strani z Joomlo, sem vedno imela probleme z editorji. Eden podpira vstavljanje datotek, ne kreira pomanjšanih slikic ali pa ne omogoča nalaganja slik, povezave je potrebno ročno vstavljati itd. Kup težav z na prvi pogled nepomembno stvarjo glede spletne strani.
Pa vendar obstaja editor, ki je zaenkrat ustregel vsem mojim zahtevam. To je JCE editor. Na spodnji povezavi je poleg komponente in mambota, na voljo še en kup vtičnikov, ki vam olajšajo delo z urejanjem vsebin v Joomli. Priložen je tudi paket s slovenskim jezikom.
Prenesi JCE editor.
