Se rendre au contenu
Menu
Cette question a été signalée
1 Répondre
793 Vues


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
Ignorer
Auteur Meilleure réponse

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
Ignorer