Mam nikłe pojecie o mysql, przy kopiowaniu bazy wywala mi błąd z którym nie wiem co mam zrobić. Proszę o pomoc.
Wersja LMS: 1.11.1 Talus (1.889/1.21) Wersja LMSDB: 1.11.1 Talus (1.43/1.49) Wersja MySQL: 5.0.24a-log Wersja PHP: 5.2.3 Wersja Smarty: 2.6.18
CREATE ALGORITHM = UNDEFINED DEFINER = `root`@ `localhost` SQL SECURITY DEFINER VIEW `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 `kopia`.`customers` `c`
WHERE NOT (
EXISTS (
SELECT 1 AS `1`
FROM (
`kopia`.`customerassignments` `a` JOIN `kopia`.`excludedgroups` `e` ON ( ( `a`.`customergroupid` = `e`.`customergroupid` ) ) ) WHERE ( ( `e`.`userid` = `kopia`.`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 `customersview` AS SELECT `c`.`id` AS `id` ' at line 1
_______________________________________________ lms mailing list lms@lists.lms.org.pl http://lists.lms.org.pl/mailman/listinfo/lms