Co może być przyczyną takiego błędu ?
CREATE ALGORITHM = UNDEFINED DEFINER = `root`@ `localhost` SQL SECURITY DEFINER VIEW `lms1-kopia2`.`customersview` AS SELECT `c`.`id` AS `id` , `c`.`lastname` AS `lastname` , `c`.`name` AS `name` , `c`.`status` AS `status` , `c`.`email` AS `email` , `c`.`address` AS `address` , `c`.`zip` AS `zip` , `c`.`city` AS `city` , `c`.`ten` AS `ten` , `c`.`ssn` AS `ssn` , `c`.`regon` AS `regon` , `c`.`rbe` AS `rbe` , `c`.`icn` AS `icn` , `c`.`info` AS `info` , `c`.`notes` AS `notes` , `c`.`serviceaddr` AS `serviceaddr` , `c`.`creationdate` AS `creationdate` , `c`.`moddate` AS `moddate` , `c`.`creatorid` AS `creatorid` , `c`.`modid` AS `modid` , `c`.`deleted` AS `deleted` , `c`.`message` AS `message` , `c`.`pin` AS `pin`
FROM `lms1-kopia2`.`customers` `c`
WHERE NOT (
EXISTS (
SELECT 1 AS `1`
FROM (
`lms1-kopia2`.`customerassignments` `a` JOIN `lms1-kopia2`.`excludedgroups` `e` ON ( ( `a`.`customergroupid` = `e`.`customergroupid` ) ) ) WHERE ( ( `e`.`userid` = `lms1-kopia2`.`lms_current_user` ( ) ) AND ( `a`.`customerid` = `c`.`id` ) ) ) )
MySQL zwrócił komunikat: Dokumentacja #1064 - 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 'localhost` SQL SECURITY DEFINER VIEW `lms1-kopia2`.`customersview` AS select' at line 1
_______________________________________________ lms mailing list lms@lists.lms.org.pl http://lists.lms.org.pl/mailman/listinfo/lms