{"id":40,"date":"2013-07-24T08:43:52","date_gmt":"2013-07-24T06:43:52","guid":{"rendered":"https:\/\/profitarhely.hu\/blog\/?p=40"},"modified":"2023-02-14T15:17:53","modified_gmt":"2023-02-14T14:17:53","slug":"hiba-a-joomla-3-telepitese-soran","status":"publish","type":"post","link":"https:\/\/profitarhely.hu\/blog\/hiba-a-joomla-3-telepitese-soran\/","title":{"rendered":"Hiba a Joomla! 3 telep\u00edt\u00e9se sor\u00e1n"},"content":{"rendered":"<p>A Joomla! n\u00e9pszer\u0171, szeretj\u00fck, ahogy sokan m\u00e1sok is szeretik. Az \u00fcgyfeleink weboldalai k\u00f6z\u00f6tt is tal\u00e1lhat\u00f3 sz\u00e9p sz\u00e1mmal, ami ezzel a tartalomkezel\u0151 rendszerrel k\u00e9sz\u00fclt.<\/p>\n<p><!--more--><\/p>\n<p><strong><em>UPDATE: A hiba MySQL 5.1 verzi\u00f3 eset\u00e9n m\u00e1r nem jelentkezik, \u00edgy az al\u00e1bbi kis &#8222;hekkel\u00e9s&#8221; azoknak hasznos, akik 5.0-s adatb\u00e1zis kiszolg\u00e1l\u00f3t haszn\u00e1lnak!<\/em><\/strong><\/p>\n<p>Azonban a 3-as verzi\u00f3ban van egy ideges\u00edt\u0151 hiba. Telep\u00edt\u00e9skor, mikor a rendszer pr\u00f3b\u00e1ln\u00e1 fel\u00e9leszteni az adatb\u00e1zist, egy hib\u00e1t dob, miszerint hi\u00e1nyzik a &#8222;usergroups&#8221; t\u00e1bla, \u00e9s k\u00fcl\u00f6nben is syntax error van a MySQL parancsban. Egy Joomla!-val most ismerked\u0151 ezen a ponton ker\u00fcl infarktus k\u00f6zeli \u00e1llapotba, \u00e9s megy el a kedve az eg\u00e9szt\u0151l.<\/p>\n<p>De van megold\u00e1s.<\/p>\n<p>Keress\u00fck meg a k\u00f6vetkez\u0151 f\u00e1jlt:<\/p>\n<blockquote><p>\/installation\/sql\/mysql\/joomla.sql<\/p><\/blockquote>\n<p>Nyissuk meg egy szerkeszt\u0151 programmal, \u00e9s keress\u00fck meg azt a sort, amiben ez szerepel:<\/p>\n<blockquote><p>KEY &#8216;idx_usergroup_nested_set_lookup&#8217; (&#8216;lft&#8217;,&#8217;rgt&#8217;) USING BTREE<\/p><\/blockquote>\n<p>Majd cser\u00e9lj\u00fck le az al\u00e1bbi sorral:<\/p>\n<blockquote><p>KEY &#8216;idx_usergroup_nested_set_lookup&#8217; USING BTREE\u00a0(&#8216;lft&#8217;,&#8217;rgt&#8217;)<\/p><\/blockquote>\n<p>Nyissuk meg a weboldalunkat, \u00e9s fejezz\u00fck be a telep\u00edt\u00e9st \ud83d\ude42<\/p>\n<script type=\"text\/javascript\" src=\"https:\/\/mtc.profitarhely.hu\/form\/generate.js?id=2\"><\/script>\n","protected":false},"excerpt":{"rendered":"<p>A Joomla! n\u00e9pszer\u0171, szeretj\u00fck, ahogy sokan m\u00e1sok is szeretik. Az \u00fcgyfeleink weboldalai k\u00f6z\u00f6tt is tal\u00e1lhat\u00f3 sz\u00e9p sz\u00e1mmal, ami ezzel a tartalomkezel\u0151 rendszerrel k\u00e9sz\u00fclt.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_seopress_robots_primary_cat":"none","_seopress_titles_title":"","_seopress_titles_desc":"","_seopress_robots_index":"","footnotes":""},"categories":[35],"tags":[],"class_list":["post-40","post","type-post","status-publish","format-standard","hentry","category-technologia","generate-columns","tablet-grid-50","mobile-grid-100","grid-parent","grid-50","no-featured-image-padding"],"_links":{"self":[{"href":"https:\/\/profitarhely.hu\/blog\/wp-json\/wp\/v2\/posts\/40"}],"collection":[{"href":"https:\/\/profitarhely.hu\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/profitarhely.hu\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/profitarhely.hu\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/profitarhely.hu\/blog\/wp-json\/wp\/v2\/comments?post=40"}],"version-history":[{"count":6,"href":"https:\/\/profitarhely.hu\/blog\/wp-json\/wp\/v2\/posts\/40\/revisions"}],"predecessor-version":[{"id":1738,"href":"https:\/\/profitarhely.hu\/blog\/wp-json\/wp\/v2\/posts\/40\/revisions\/1738"}],"wp:attachment":[{"href":"https:\/\/profitarhely.hu\/blog\/wp-json\/wp\/v2\/media?parent=40"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/profitarhely.hu\/blog\/wp-json\/wp\/v2\/categories?post=40"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/profitarhely.hu\/blog\/wp-json\/wp\/v2\/tags?post=40"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}