{"id":4269,"date":"2020-12-03T09:43:54","date_gmt":"2020-12-03T15:43:54","guid":{"rendered":"https:\/\/ugit.siua.ac.cr\/?p=4269"},"modified":"2020-12-03T10:39:11","modified_gmt":"2020-12-03T16:39:11","slug":"nextcloud-eliminar-error","status":"publish","type":"post","link":"https:\/\/sada.services\/?p=4269","title":{"rendered":"Nextcloud: eliminar errores"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">Error1<\/h2>\n\n\n\n<p>Some columns in the database are missing a conversion to big int. Due to the fact that changing column types on big tables could take some time they were not changed automatically. By running &#8216;occ db:convert-filecache-bigint&#8217; those pending changes could be applied manually. This operation needs to be made while the instance is offline. For further details read <a href=\"https:\/\/docs.nextcloud.com\/server\/18\/go.php?to=admin-bigint-conversion\">the documentation page about this<\/a>.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>mounts.storage_id<\/li><li>mounts.root_id<\/li><li>mounts.mount_id<\/li><\/ul>\n\n\n\n<ul class=\"wp-block-list\"><li>Creamos una conexi\u00f3n SSH y nos ubicamos en <\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>cd \/var\/www\/html\/SIUA<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>Nos logeamos como usuario ww-dat<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>su -s \/bin\/sh www-data<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>Ejecutamos<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>php occ db:convert-filecache-bigint --no-interaction<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>Resultado<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img fetchpriority=\"high\" decoding=\"async\" width=\"1024\" height=\"121\" src=\"\/wp-content\/uploads\/2020\/12\/Seleccion_160-1024x121.png\" alt=\"\" class=\"wp-image-4270\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2020\/12\/Seleccion_160-1024x121.png 1024w, https:\/\/sada.services\/wp-content\/uploads\/2020\/12\/Seleccion_160-300x36.png 300w, https:\/\/sada.services\/wp-content\/uploads\/2020\/12\/Seleccion_160-768x91.png 768w, https:\/\/sada.services\/wp-content\/uploads\/2020\/12\/Seleccion_160.png 1487w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Error2<\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li>Missing index \u00abproperties_path_index\u00bb in table \u00aboc_properties\u00bb.<\/li><li>Creamos una conexi\u00f3n SSH y nos ubicamos en<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code><code>cd \/var\/www\/html\/SIUA<\/code><\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>Nos logeamos como usuario ww-dat<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code><code>su -s \/bin\/sh www-data<\/code><\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>Ejecutamos<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>php occ db:add-missing-indices<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Error3<\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li>Missing optional column \u00abreference_id\u00bb in table \u00aboc_comments\u00bb.<\/li><li>Ejecutamos<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>php occ db:add-missing-columns<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Error1 Some columns in the database are missing a conversion to big int. Due to the fact that changing column types on big tables could take some time they were not changed automatically. By running &#8216;occ db:convert-filecache-bigint&#8217; those pending changes could be applied manually. This operation needs to be made while the instance is offline. [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[35],"tags":[97,36],"class_list":["post-4269","post","type-post","status-publish","format-standard","hentry","category-nextcloud","tag-error","tag-nextcloud"],"blocksy_meta":{"styles_descriptor":{"styles":{"desktop":"","tablet":"","mobile":""},"google_fonts":[],"version":6}},"_links":{"self":[{"href":"https:\/\/sada.services\/index.php?rest_route=\/wp\/v2\/posts\/4269","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sada.services\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sada.services\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sada.services\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/sada.services\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=4269"}],"version-history":[{"count":3,"href":"https:\/\/sada.services\/index.php?rest_route=\/wp\/v2\/posts\/4269\/revisions"}],"predecessor-version":[{"id":4276,"href":"https:\/\/sada.services\/index.php?rest_route=\/wp\/v2\/posts\/4269\/revisions\/4276"}],"wp:attachment":[{"href":"https:\/\/sada.services\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4269"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sada.services\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4269"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sada.services\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4269"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}