i cannot access the admin panel anymore (i get the page not found, and seems there is no other solution than changing the host, as recomennded also in the forum) but i have whole lot of views, how can i export them from the database?

Comments

hannesh’s picture

When i try to do it through the database by just exporting i get the following errors:

* user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '; SECOND), '%Y%m%d%H%i') AS node_created_minute FROM node node INNER JOIN ter' at line 3 query: SELECT node.nid AS nid, node.title AS node_title, DATE_FORMAT((FROM_UNIXTIME(node.created) + INTERVAL 7200; SECOND), '%Y%m%d%H%i') AS node_created_minute FROM node node INNER JOIN term_node term_node_value_0 ON node.vid = term_node_value_0.vid AND term_node_value_0.tid = 143 WHERE (term_node_value_0.tid = 143) AND (node.status <> 0) ORDER BY node_created_minute DESC LIMIT 0, 10 in /www/apache/domains/htdocs/modules/views/includes/view.inc on line 731.
* user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '; SECOND), '%Y%m%d%H%i') AS node_created_minute FROM node node LEFT JOIN term' at line 3 query: SELECT node.nid AS nid, node.title AS node_title, DATE_FORMAT((FROM_UNIXTIME(node.created) + INTERVAL 7200; SECOND), '%Y%m%d%H%i') AS node_created_minute FROM node node LEFT JOIN term_node term_node_value_0 ON node.vid = term_node_value_0.vid AND term_node_value_0.tid = 116 LEFT JOIN term_node term_node_value_1 ON node.vid = term_node_value_1.vid AND term_node_value_1.tid = 117 WHERE (node.status <> 0) AND (term_node_value_0.tid = 116 OR term_node_value_1.tid = 117) ORDER BY node_created_minute DESC LIMIT 0, 10 in /www/apache/domains/htdocs/modules/views/includes/view.inc on line 731.

hannesh’s picture

Status: Active » Fixed

it worked, but i neede to change some setting in many views and change them back again, to lose the error messages and get them to work.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.