{"id":277,"date":"2008-06-05T19:26:09","date_gmt":"2008-06-05T19:26:09","guid":{"rendered":"http:\/\/blog.cyberwizzard.nl\/?p=277"},"modified":"2016-03-17T21:24:20","modified_gmt":"2016-03-17T20:24:20","slug":"integrity-issues","status":"publish","type":"post","link":"https:\/\/blog.cyberwizzard.nl\/?p=277","title":{"rendered":"Integrity issues"},"content":{"rendered":"<p>That&#8217;s what I get for toying with stuff I should leave alone&#8230; I tried to merge the articles from my other Joomla installation back into my main site. After clicking around for a bit it seemed like the manual database merge worked out.<\/p>\n<p>Next I found a number of modules with version number 1.0.x &#8211; assuming these were remains of the original 1.0.x installation I selected them all and hit delete. On the page refresh I noticed something was off&#8230; The menu was gone! Most of the Joomla Administrator panel was working but without a menu, a lot of sections are unavailable&#8230;<\/p>\n<p>After installing a second installation over the existing one I managed to get the missing modules back (note to self: make sure to download the full package AND copy all the files&#8230;) by copying tables between the 2 installations. Finally I had a working installation again but now the other users (a.k.a not me) did not show up anymore&#8230;<\/p>\n<p>After Googling for weeks I finally found a thread in which somebody made a whole database schema for Joomla! 1.5. The schema can be <a target=\"_blank\" href=\"http:\/\/www.bedre.no\/joomla_tutorials\/for_utviklere\/joomla_1.5_database_schema.html\">found here<\/a>.<\/p>\n<p>Even though I had restored most of the key references within Joomla! I somehow missed the &#8216;jos_core_acl_groups_aro_maps&#8217; table &#8211; this only had one entry: for admin only. As soon as I realized my mistake, I manually added the missing rows and everything started working properly again.<\/p>\n<p>Note to self: stop breaking the site&#8230;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>That&#8217;s what I get for toying with stuff I should leave alone&#8230; I tried to merge the articles from my other Joomla installation back into my main site. After clicking around for a bit it seemed like the manual database merge worked out. Next I found a number of modules with version number 1.0.x &#8211; [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[45,207,185,206,209,204,205,460,459,54,210,208],"class_list":["post-277","post","type-post","status-publish","format-standard","hentry","category-general-blog-entries","tag-blog","tag-entries","tag-for","tag-general","tag-get","tag-integrity","tag-issues","tag-no_ok","tag-not_ok","tag-that","tag-toying","tag-what"],"views":1457,"_links":{"self":[{"href":"https:\/\/blog.cyberwizzard.nl\/index.php?rest_route=\/wp\/v2\/posts\/277","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.cyberwizzard.nl\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.cyberwizzard.nl\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.cyberwizzard.nl\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.cyberwizzard.nl\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=277"}],"version-history":[{"count":1,"href":"https:\/\/blog.cyberwizzard.nl\/index.php?rest_route=\/wp\/v2\/posts\/277\/revisions"}],"predecessor-version":[{"id":453,"href":"https:\/\/blog.cyberwizzard.nl\/index.php?rest_route=\/wp\/v2\/posts\/277\/revisions\/453"}],"wp:attachment":[{"href":"https:\/\/blog.cyberwizzard.nl\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=277"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.cyberwizzard.nl\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=277"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.cyberwizzard.nl\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=277"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}