CREATE FUNCTION lms_current_user() RETURNS int(11) NO SQL RETURN @lms_current_user;
From: Michał Bochniak Sent: Thursday, June 06, 2013 11:21 AM To: 'lista użytkowników LMS' Subject: [lms] Import bazy danych ze starej gałęzi LMS do iNETLMS
Witam
Próbuję zaimportować bazę przez phpmyadmin. Dostaję niestety poniższy komunikat, niestety nie bardzo wiem jak sobie z nim poradzić:
Zapytanie SQL:
CREATE ALGORITHM=UNDEFINED DEFINER=`lms`@`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`.`type` AS `type`,`c`.`email` AS `email`,`c`.`address` AS `address`,`c`.`zip` AS `zip`,`c`.`city` AS `city`,`c`.`countryid` AS `countryid`,`c`.`post_name` AS `post_name`,`c`.`post_address` AS `post_address`,`c`.`post_zip` AS `post_zip`,`c`.`post_city` AS `post_city`,`c`.`post_countryid` AS `post_countryid`,`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`.`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`,`c`.`cutoffstop` AS `cutoffstop`,`c`.`consentdate` AS `consentdate`,`c`.`einvoice` AS `einvoice`,`c`.`invoicenotice` AS `invoicenotice`,`c`.`mailingnotice` [...]
MySQL zwrócił komunikat:
#1305 - FUNCTION lms.lms_current_user does not exist
--------------------------------------------------------------------------------
_______________________________________________ lms mailing list lms@lists.lms.org.pl http://lists.lms.org.pl/mailman/listinfo/lms
