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