11 maj 2016 12:19 PM "tdabek@go2.pl" tdabek@go2.pl napisał(a):
Dnia 11 maja 2016 11:05 Marcin marcin@nicram.net napisał(a):
podejrzewam bardziej to, czyli prawa dostępu http://anothermysqldba.blogspot.com/2013/12/error-1356-hy000.html
Wg tego otrzymuje:
mysql> select * from customermailsview; ERROR 1356 (HY000): View 'lms.customermailsview' references invalid
table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
mysql>
mysql> show create view lms.customermailsview \G ERROR 1356 (HY000): View 'lms.customermailsview' references invalid
table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
mysql>
mysql> show grants for 'root'@'localhost';
+----------------------------------------------------------------------------------------------------------------------------------------+
| Grants for root@localhost
|
+----------------------------------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY
PASSWORD '***465FF1427CFDE787DFCD127C494370D51BF00*' WITH GRANT OPTION |
+----------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.04 sec)
mysql>
Zamiast localhost wpisz 127.0.0.1 Co pokazuje?
spróbuj użyć "-f"
https://mysqltech.wordpress.com/2011/11/18/invalid-views-can-break-backups/
Idac tym przykladem mam to:
mysql> select VIEW_DEFINITION from information_schema.VIEWS where
table_name = 'customermailsview';
+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| VIEW_DEFINITION
|
+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| select `lms`.`customercontacts`.`customerid` AS
`customerid`,group_concat(`lms`.`customercontacts`.`contact` separator ',') AS `email` from `lms`.`customercontacts` where ((`lms`.`customercontacts`.`type` = 8) and (`lms`.`customercontacts`.`contact` <> '')) group by `lms`.`customercontacts`.`customerid` |
+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set, 1 warning (0.01 sec)
mysql>
I teraz czy powyzsze cos wiecej mowia? Moze to nakieruje na rozwiazanie problemu. Narazie jeszcze "-f' nie zrobilem a chcialem pokazac te wyniki.
Moze ktos odplatnie mi to naprawi? :)
Osobiscie boje sie kombinowac zeby nie zepsuc bazy, ostatnia kopie sprawna mam z grudnia wiec za duzy bylby mlyn gdyby ta obecna baza padla calkiem.
pozdrawiam TD _______________________________________________ lms mailing list lms@lists.lms.org.pl http://lists.lms.org.pl/mailman/listinfo/lms