Pular para o conteúdo
Menu
Esta pergunta foi sinalizada
1 Responder
794 Visualizações


Database blocked

The database was blocked by the system as it was unable to neutralize it. The error logs are accessible through the webshell or ssh and are located at ~/logs/neutralize.log. Once the scripts (or the database) are fixed, please rebuild.


More information might be available in the project's notification center.




======================================


Error while neutralizing the database:


======================================




ERROR: syntax error at or near "UPDATE"


LINE 4: UPDATE ir_ui_view


^


STATEMENT: UPDATE website


SET robots_txt = E'User-agent: *\nDisallow: /'




UPDATE ir_ui_view


SET active = true


WHERE key = 'web.neutralize_banner';



Can someone helps me please!


best regards,


Avatar
Cancelar
Autor Melhor resposta

content of neutralize.sql

-- delete domains on websites

UPDATE website

   SET domain = NULL;


-- activate neutralization watermarks

UPDATE ir_ui_view

   SET active = true

WHERE key = 'website.neutralize_ribbon';


-- disable cdn

UPDATE website

   SET cdn_activated = false;


-- Update robots.txt to disallow all crawling

UPDATE website

   SET robots_txt = E'User-agent: *\nDisallow: /'


Avatar
Cancelar