- lms - lists.lms.org.pl

Problem przy generowaniu raportu SIIS v3
by Jacek.J 23 Maj '13

23 Maj '13

Witam Jeszcze jeden problem .... Podczas generowania raportu - mam pusto w USLUGI_SZER.csv Po prostu plik ma rozmiar 0 Reszta generuje sie .... Wrzucilem najnowsza wersje LMS-GIT przed chwila i tez to samo... Mapa sieci generuje sie ok. Szkielet sieci polaczony ze soba, a klienci podpisani pod urzadzenia ... ( nie wszyscy.... bo np. ci ktorych juz nie ma - nie maja podlaczen z urzadzeniami... jesli to wazne .. ) Czy ktos pomoze ? cos podpowie ? Pozdrawiam -- Pozdrawiam... Jacek.J Tel. 509929262 GG: 5200746 www.mikrochip.pl

2 2

promocje - nie wstawia zobowiązania instalacji
by Marcin 22 Maj '13

22 Maj '13

Witam git z dzisiaj. zacząłem testować promocje. ogólnie ładnie się dodają. w promocji ustawiam aktywację, ale kwota ta nie dodaje się do zobowiązań. dodają się taryfy ze schematu promocji ale nie ma aktywacji :( w bazie do tabeli kwota ta ląduje #v+ > SELECT * FROM promotionassignments; +----+-------------------+----------+---------------+ | id | promotionschemaid | tariffid | data | +----+-------------------+----------+---------------+ | 7 | 3 | 158 | 199;25:3;49:3 | +----+-------------------+----------+---------------+ 1 row in set (0.00 sec) #v- -- Pozdrawiam Marcin / nicraM

2 2

Re: [lms] faktura z innym okresem
by Michał Bochniak 22 Maj '13

22 Maj '13

Witam Jak ustawić LMS-payments aby faktury dnia 22maja były wystawiane za okres od 01czerwca do 30czerwca a nie jak to ma aktualnie miejsce za miesiąc do przodu. .................. Ok znalazłem. Delikatna zmiana w LMS-payments (period): my $next_period = strftime("%d/%m/%Y", 0, 0, 12, 1, $month , $year - 1900)." - ".strftime("%d/%m/%Y", 0, 0, 12, 0, $month +1, $year - 1900);

1 0

Re: [lms] faktura z innym okresem
by Waldemar Dymkiewicz 22 Maj '13

22 Maj '13

W dniu 2013-05-22 15:51, Michał Bochniak pisze: > Witam > > Jak ustawić LMS-payments aby faktury dnia 22maja były wystawiane za > okres od 01czerwca do 30czerwca a nie jak to ma aktualnie miejsce za > miesiąc do przodu. Nijak, nie ma takiej możliwości, chyba ze ratuje Cię --fake-date -- Waldemar Dymkiewicz, administrator urządzeń sieciowych "Easy Com" Świątek Piotr, ul. Jodłowa 7, Góra tel. 65 544 18 82 wew. 4

1 0

faktura z innym okresem
by Michał Bochniak 22 Maj '13

22 Maj '13

Witam Jak ustawić LMS-payments aby faktury dnia 22maja były wystawiane za okres od 01czerwca do 30czerwca a nie jak to ma aktualnie miejsce za miesiąc do przodu. .................. pozdrawiam Bochniak Michał cid:image001.jpg@01CD1E7D.65413550 Zapnet Spółka Jawna ul. Leśna 1 63-430 Odolanów tel.: +48 62 597 70 83 fax: +48 62 597 70 93 kom.: +48 502 531 940 email: <mailto:michal.bochniak@zapnet.pl> michal.bochniak(a)zapnet.pl <http://www.zapnet.pl/> www.zapnet.pl

1 0

Brak polskiej czcionki na mapie sieci oraz w raporcie SIIS v3
by Jacek.J 22 Maj '13

22 Maj '13

Witam Nie moge doszukac sie, dlaczego mam brak pl czcionki i na wygenerowanym schemacie mapy sieci, i na wygenerowanym raporcie SIIS. Wszedzie indziej normalnie jest wlasciwa czcionka. Kiedys tam pamietam, ze mialem maly problem z czcionkami i zmienialem je w bazie recznie na utf_polish_ci. A teraz sprawdzilem tabele, bylo kilka w swedish, zmienilem je na utf_polish_ci, W samym LMS - pokazuje sie wszystko dobrze w zasadzie ... Tylko przy mapie i SIIS.... Czy ktos ma pomysl gdzie tu jeszcze zagladnac ? Wersja LMS: 1.11-git Wersja LMSDB: 1.11-git Wersja MySQL: 5.1.63-0+squeeze1 Wersja PHP: 5.3.3-7+squeeze15 Wersja Smarty: 3.1.11 -- Pozdrawiam... Jacek.J Tel. 509929262 GG: 5200746 www.mikrochip.pl

1 0

id klienta - zapytanie
by Łukasz Rostalski 21 Maj '13

21 Maj '13

Dzień Dobry. Potrzebuję na podstawie ip pobrać id klienta. Stworzyłem zapytanie: SELECT assignments.id FROM nodeassignments RIGHT JOIN assignments ON nodeassignments.assignmentid=assignments.id RIGHT JOIN nodes ON nodeassignments.nodeid=nodes.id WHERE ipaddr = 1521293115 Wynik zwraca poprawny, ale czy jest to zgodne ze sztuką, ewentualnie czy da się to zrobić prościej/efektywniej? -- Pozdrawiam Łukasz Rostalski

2 2

lms-cashimport.php - po aktualizacji autocommit przestał działać
by Sławomir Paszkiewicz 21 Maj '13

21 Maj '13

Witam, Wczoraj dokonałem aktualizacji do najnowszej wersji GIT i dziś zauważyłem, że przestał mi działać lms-cashimport.php a dokładniej to autocommit. Jak wyłącze w lms.ini autocommit = true (zmienie na false) to w LMS>Finanse>Import widzę wszystkie wpłaty i ręcznie jestem w stanie je zaimportować, natomiast jak mam włączone autocommit = true tak jak dotychczas to wpłaty pojawiają się w "Paczki" natomiast nie są rozliczane u klientów. Spotkał się ktoś z tym problemem? Polecam sprawdzenie czy aby na pewno wam saldo spada po wczytaniu paczek ;) Pozdrawiam, SP

3 4

Płatności z góry a przepisy VAT
by Dominik Chenczke 21 Maj '13

21 Maj '13

Otrzymałem i od kolegi ISP i potwierdziłem u księgowej iż: trzeba wyeliminować wpłaty z góry za rok, pół roku, nawet za 2 miesiące itp., bo wg przepisów VAT trzeba wtedy w ciągu 7 dni wystawić Fakturę VAT. Kontrola Vatowska przyczepi się do tej nieprawidłowości na pewno . Wszelkie wpłaty z góry to zaliczki na poczet wykonania usługi i trzeba w ciągu 7 dni wystawić fakturę na kwotę wpłaty. I teraz tak czy nie warto by było w jakiś mądry sposób przygotować LMS'a który wspomógłby działanie zgodnie z przepisami. Na początek pomyślałem nad odwrotnością Klienci- W tym zadłużonych lub klienci zadłużeni ponad 100% Jakieś pomysły ?? Pozdrawiam DeCha

6 5

squid 3 powiadomienia
by Arturz 20 Maj '13

20 Maj '13

Witam. W dokumentacji jest opis jak zrobić powiadomienia dla squida 2.5 i 2.6 Robił ktoś z Was na squid 3 ?? Na co muszę zwrócić uwagę??

11 17

Migracja na MariaDB
by Zbigniew Kujawski 20 Maj '13

20 Maj '13

Witam Czy ktoś z Panów migrował z mysql na mariadb ? Jeśli tak, to czy warto, dla bazy na ok.1000 klientów ? -- Pozdrawiam/Regards Z.Kujawski JUTRA Sp. z o.o. ul.5-go Marca 4 78-320 Połczyn-Zdrój tel.222-926-973 mob.695209244

2 1

migracja mysql to postres
by Marcin 19 Maj '13

19 Maj '13

Witam chcę sobie przetestować migrację z mysql do tak zachwalanego posgresa. do konwersji mysql -> posgres używam zalecanego https://github.com/philipsoutham/py-mysql2pgsql ale niestety mam problemy a to z konwersją albo ze wrzuceniem danych do bazy. Jak to powinienem prawidłowo zrobić by bez problemu zadziałało? czy dane przerzucić z mysql bezpośrednio do posgresa? - w tym przypadku też są problemy. oto scenariusz zrzucania tylko danych. Jako backum mam z Dira, to też na tej wersji robię migrację. 1. robię strukturę bazy #v+ postgres@pgsql:~$ psql -d lms -U lms -f /var/www/lms/doc/lms.pgsql psql:/var/www/lms/doc/lms.pgsql:6: ERROR: sequence "users_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:8: ERROR: table "users" does not exist psql:/var/www/lms/doc/lms.pgsql:27: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "users_pkey" for table "users" psql:/var/www/lms/doc/lms.pgsql:27: NOTICE: CREATE TABLE / UNIQUE will create implicit index "users_login_key" for table "users" CREATE TABLE psql:/var/www/lms/doc/lms.pgsql:32: ERROR: sequence "customers_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:34: ERROR: table "customers" does not exist psql:/var/www/lms/doc/lms.pgsql:74: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "customers_pkey" for table "customers" CREATE TABLE CREATE INDEX CREATE INDEX psql:/var/www/lms/doc/lms.pgsql:82: ERROR: sequence "numberplans_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:84: ERROR: table "numberplans" does not exist psql:/var/www/lms/doc/lms.pgsql:92: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "numberplans_pkey" for table "numberplans" CREATE TABLE psql:/var/www/lms/doc/lms.pgsql:97: ERROR: sequence "assignments_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:99: ERROR: table "assignments" does not exist psql:/var/www/lms/doc/lms.pgsql:118: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "assignments_pkey" for table "assignments" CREATE TABLE CREATE INDEX CREATE INDEX CREATE INDEX psql:/var/www/lms/doc/lms.pgsql:126: ERROR: sequence "cash_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:128: ERROR: table "cash" does not exist psql:/var/www/lms/doc/lms.pgsql:143: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "cash_pkey" for table "cash" CREATE TABLE CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX psql:/var/www/lms/doc/lms.pgsql:153: ERROR: sequence "networks_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:155: ERROR: table "networks" does not exist psql:/var/www/lms/doc/lms.pgsql:174: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "networks_pkey" for table "networks" psql:/var/www/lms/doc/lms.pgsql:174: NOTICE: CREATE TABLE / UNIQUE will create implicit index "networks_name_key" for table "networks" psql:/var/www/lms/doc/lms.pgsql:174: NOTICE: CREATE TABLE / UNIQUE will create implicit index "networks_address_key" for table "networks" CREATE TABLE psql:/var/www/lms/doc/lms.pgsql:179: ERROR: sequence "nodes_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:181: ERROR: table "nodes" does not exist psql:/var/www/lms/doc/lms.pgsql:209: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "nodes_pkey" for table "nodes" psql:/var/www/lms/doc/lms.pgsql:209: NOTICE: CREATE TABLE / UNIQUE will create implicit index "nodes_name_key" for table "nodes" psql:/var/www/lms/doc/lms.pgsql:209: NOTICE: CREATE TABLE / UNIQUE will create implicit index "nodes_ipaddr_key" for table "nodes" CREATE TABLE CREATE INDEX CREATE INDEX CREATE INDEX psql:/var/www/lms/doc/lms.pgsql:217: ERROR: sequence "macs_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:219: ERROR: table "macs" does not exist psql:/var/www/lms/doc/lms.pgsql:227: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "macs_pkey" for table "macs" psql:/var/www/lms/doc/lms.pgsql:227: NOTICE: CREATE TABLE / UNIQUE will create implicit index "macs_mac_key" for table "macs" CREATE TABLE psql:/var/www/lms/doc/lms.pgsql:232: ERROR: sequence "nodegroups_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:234: ERROR: table "nodegroups" does not exist psql:/var/www/lms/doc/lms.pgsql:242: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "nodegroups_pkey" for table "nodegroups" psql:/var/www/lms/doc/lms.pgsql:242: NOTICE: CREATE TABLE / UNIQUE will create implicit index "nodegroups_name_key" for table "nodegroups" CREATE TABLE psql:/var/www/lms/doc/lms.pgsql:247: ERROR: sequence "nodegroupassignments_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:249: ERROR: table "nodegroupassignments" does not exist psql:/var/www/lms/doc/lms.pgsql:256: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "nodegroupassignments_pkey" for table "nodegroupassignments" psql:/var/www/lms/doc/lms.pgsql:256: NOTICE: CREATE TABLE / UNIQUE will create implicit index "nodegroupassignments_nodeid_key" for table "nodegroupassignments" CREATE TABLE psql:/var/www/lms/doc/lms.pgsql:261: ERROR: sequence "nodeassignments_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:263: ERROR: table "nodeassignments" does not exist psql:/var/www/lms/doc/lms.pgsql:272: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "nodeassignments_pkey" for table "nodeassignments" psql:/var/www/lms/doc/lms.pgsql:272: NOTICE: CREATE TABLE / UNIQUE will create implicit index "nodeassignments_nodeid_key" for table "nodeassignments" CREATE TABLE CREATE INDEX psql:/var/www/lms/doc/lms.pgsql:279: ERROR: sequence "tariffs_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:281: ERROR: table "tariffs" does not exist psql:/var/www/lms/doc/lms.pgsql:318: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "tariffs_pkey" for table "tariffs" psql:/var/www/lms/doc/lms.pgsql:318: NOTICE: CREATE TABLE / UNIQUE will create implicit index "tariffs_name_key" for table "tariffs" CREATE TABLE CREATE INDEX psql:/var/www/lms/doc/lms.pgsql:324: ERROR: sequence "promotions_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:334: ERROR: syntax error at or near "CREATE" LINE 2: CREATE TABLE promotions ( ^ psql:/var/www/lms/doc/lms.pgsql:339: ERROR: sequence "promotionschemas_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:341: ERROR: table "promotionschemas" does not exist psql:/var/www/lms/doc/lms.pgsql:355: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "promotionschemas_pkey" for table "promotionschemas" psql:/var/www/lms/doc/lms.pgsql:355: NOTICE: CREATE TABLE / UNIQUE will create implicit index "promotionschemas_promotionid_key" for table "promotionschemas" psql:/var/www/lms/doc/lms.pgsql:355: ERROR: relation "promotions" does not exist psql:/var/www/lms/doc/lms.pgsql:356: ERROR: relation "promotionschemas" does not exist psql:/var/www/lms/doc/lms.pgsql:361: ERROR: sequence "promotionassignments_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:363: ERROR: table "promotionassignments" does not exist psql:/var/www/lms/doc/lms.pgsql:373: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "promotionassignments_pkey" for table "promotionassignments" psql:/var/www/lms/doc/lms.pgsql:373: NOTICE: CREATE TABLE / UNIQUE will create implicit index "promotionassignments_promotionschemaid_key" for table "promotionassignments" psql:/var/www/lms/doc/lms.pgsql:373: ERROR: relation "promotionschemas" does not exist psql:/var/www/lms/doc/lms.pgsql:374: ERROR: relation "promotionassignments" does not exist psql:/var/www/lms/doc/lms.pgsql:379: ERROR: sequence "liabilities_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:381: ERROR: table "liabilities" does not exist psql:/var/www/lms/doc/lms.pgsql:389: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "liabilities_pkey" for table "liabilities" CREATE TABLE psql:/var/www/lms/doc/lms.pgsql:394: ERROR: sequence "payments_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:396: ERROR: table "payments" does not exist psql:/var/www/lms/doc/lms.pgsql:406: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "payments_pkey" for table "payments" CREATE TABLE psql:/var/www/lms/doc/lms.pgsql:411: ERROR: sequence "taxes_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:413: ERROR: table "taxes" does not exist psql:/var/www/lms/doc/lms.pgsql:422: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "taxes_pkey" for table "taxes" CREATE TABLE psql:/var/www/lms/doc/lms.pgsql:427: ERROR: sequence "documents_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:429: ERROR: table "documents" does not exist psql:/var/www/lms/doc/lms.pgsql:454: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "documents_pkey" for table "documents" CREATE TABLE CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX psql:/var/www/lms/doc/lms.pgsql:463: ERROR: table "documentcontents" does not exist psql:/var/www/lms/doc/lms.pgsql:474: NOTICE: CREATE TABLE / UNIQUE will create implicit index "documentcontents_docid_key" for table "documentcontents" CREATE TABLE CREATE INDEX CREATE INDEX CREATE INDEX psql:/var/www/lms/doc/lms.pgsql:483: ERROR: table "receiptcontents" does not exist CREATE TABLE CREATE INDEX CREATE INDEX psql:/var/www/lms/doc/lms.pgsql:497: ERROR: table "invoicecontents" does not exist CREATE TABLE CREATE INDEX psql:/var/www/lms/doc/lms.pgsql:515: ERROR: table "debitnotecontents" does not exist psql:/var/www/lms/doc/lms.pgsql:516: ERROR: sequence "debitnotecontents_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:526: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "debitnotecontents_pkey" for table "debitnotecontents" psql:/var/www/lms/doc/lms.pgsql:526: NOTICE: CREATE TABLE / UNIQUE will create implicit index "debitnotecontents_docid_key" for table "debitnotecontents" CREATE TABLE psql:/var/www/lms/doc/lms.pgsql:530: ERROR: sequence "numberplanassignments_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:532: ERROR: table "numberplanassignments" does not exist psql:/var/www/lms/doc/lms.pgsql:539: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "numberplanassignments_pkey" for table "numberplanassignments" psql:/var/www/lms/doc/lms.pgsql:539: NOTICE: CREATE TABLE / UNIQUE will create implicit index "numberplanassignments_planid_key" for table "numberplanassignments" CREATE TABLE CREATE INDEX psql:/var/www/lms/doc/lms.pgsql:545: ERROR: sequence "customergroups_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:547: ERROR: table "customergroups" does not exist psql:/var/www/lms/doc/lms.pgsql:554: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "customergroups_pkey" for table "customergroups" psql:/var/www/lms/doc/lms.pgsql:554: NOTICE: CREATE TABLE / UNIQUE will create implicit index "customergroups_name_key" for table "customergroups" CREATE TABLE psql:/var/www/lms/doc/lms.pgsql:559: ERROR: sequence "customerassignments_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:561: ERROR: table "customerassignments" does not exist psql:/var/www/lms/doc/lms.pgsql:570: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "customerassignments_pkey" for table "customerassignments" psql:/var/www/lms/doc/lms.pgsql:570: NOTICE: CREATE TABLE / UNIQUE will create implicit index "customerassignments_customergroupid_key" for table "customerassignments" CREATE TABLE CREATE INDEX psql:/var/www/lms/doc/lms.pgsql:577: ERROR: table "stats" does not exist psql:/var/www/lms/doc/lms.pgsql:584: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "stats_pkey" for table "stats" CREATE TABLE CREATE INDEX psql:/var/www/lms/doc/lms.pgsql:590: ERROR: sequence "netlinks_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:592: ERROR: table "netlinks" does not exist psql:/var/www/lms/doc/lms.pgsql:602: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "netlinks_pkey" for table "netlinks" psql:/var/www/lms/doc/lms.pgsql:602: NOTICE: CREATE TABLE / UNIQUE will create implicit index "netlinks_src_key" for table "netlinks" CREATE TABLE CREATE FUNCTION CREATE FUNCTION CREATE FUNCTION CREATE FUNCTION psql:/var/www/lms/doc/lms.pgsql:639: ERROR: table "rtattachments" does not exist psql:/var/www/lms/doc/lms.pgsql:645: ERROR: relation "rtmessages" does not exist psql:/var/www/lms/doc/lms.pgsql:647: ERROR: relation "rtattachments" does not exist psql:/var/www/lms/doc/lms.pgsql:649: ERROR: sequence "rtqueues_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:651: ERROR: table "rtqueues" does not exist psql:/var/www/lms/doc/lms.pgsql:659: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "rtqueues_pkey" for table "rtqueues" psql:/var/www/lms/doc/lms.pgsql:659: NOTICE: CREATE TABLE / UNIQUE will create implicit index "rtqueues_name_key" for table "rtqueues" CREATE TABLE psql:/var/www/lms/doc/lms.pgsql:661: ERROR: sequence "rttickets_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:663: ERROR: table "rttickets" does not exist psql:/var/www/lms/doc/lms.pgsql:678: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "rttickets_pkey" for table "rttickets" CREATE TABLE CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX psql:/var/www/lms/doc/lms.pgsql:685: ERROR: sequence "rtmessages_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:687: ERROR: table "rtmessages" does not exist psql:/var/www/lms/doc/lms.pgsql:703: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "rtmessages_pkey" for table "rtmessages" CREATE TABLE CREATE INDEX psql:/var/www/lms/doc/lms.pgsql:707: ERROR: sequence "rtnotes_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:709: ERROR: table "rtnotes" does not exist psql:/var/www/lms/doc/lms.pgsql:719: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "rtnotes_pkey" for table "rtnotes" CREATE TABLE CREATE INDEX CREATE INDEX psql:/var/www/lms/doc/lms.pgsql:724: ERROR: sequence "rtrights_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:726: ERROR: table "rtrights" does not exist psql:/var/www/lms/doc/lms.pgsql:736: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "rtrights_pkey" for table "rtrights" psql:/var/www/lms/doc/lms.pgsql:736: NOTICE: CREATE TABLE / UNIQUE will create implicit index "rtrights_userid_key" for table "rtrights" CREATE TABLE psql:/var/www/lms/doc/lms.pgsql:741: ERROR: sequence "passwd_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:743: ERROR: table "passwd" does not exist psql:/var/www/lms/doc/lms.pgsql:767: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "passwd_pkey" for table "passwd" psql:/var/www/lms/doc/lms.pgsql:767: NOTICE: CREATE TABLE / UNIQUE will create implicit index "passwd_login_key" for table "passwd" CREATE TABLE CREATE INDEX psql:/var/www/lms/doc/lms.pgsql:773: ERROR: sequence "domains_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:775: ERROR: table "domains" does not exist psql:/var/www/lms/doc/lms.pgsql:788: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "domains_pkey" for table "domains" psql:/var/www/lms/doc/lms.pgsql:788: NOTICE: CREATE TABLE / UNIQUE will create implicit index "domains_name_key" for table "domains" CREATE TABLE CREATE INDEX psql:/var/www/lms/doc/lms.pgsql:794: ERROR: sequence "records_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:796: ERROR: table "records" does not exist psql:/var/www/lms/doc/lms.pgsql:808: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "records_pkey" for table "records" CREATE TABLE CREATE INDEX CREATE INDEX psql:/var/www/lms/doc/lms.pgsql:816: ERROR: sequence "supermasters_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:818: ERROR: table "supermasters" does not exist psql:/var/www/lms/doc/lms.pgsql:825: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "supermasters_pkey" for table "supermasters" CREATE TABLE psql:/var/www/lms/doc/lms.pgsql:830: ERROR: sequence "aliases_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:832: ERROR: table "aliases" does not exist psql:/var/www/lms/doc/lms.pgsql:839: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "aliases_pkey" for table "aliases" psql:/var/www/lms/doc/lms.pgsql:839: NOTICE: CREATE TABLE / UNIQUE will create implicit index "aliases_login_key" for table "aliases" CREATE TABLE psql:/var/www/lms/doc/lms.pgsql:844: ERROR: sequence "aliasassignments_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:846: ERROR: table "aliasassignments" does not exist psql:/var/www/lms/doc/lms.pgsql:854: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "aliasassignments_pkey" for table "aliasassignments" psql:/var/www/lms/doc/lms.pgsql:854: NOTICE: CREATE TABLE / UNIQUE will create implicit index "aliasassignments_aliasid_key" for table "aliasassignments" CREATE TABLE psql:/var/www/lms/doc/lms.pgsql:859: ERROR: sequence "uiconfig_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:861: ERROR: table "uiconfig" does not exist psql:/var/www/lms/doc/lms.pgsql:871: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "uiconfig_pkey" for table "uiconfig" psql:/var/www/lms/doc/lms.pgsql:871: NOTICE: CREATE TABLE / UNIQUE will create implicit index "uiconfig_section_key" for table "uiconfig" CREATE TABLE psql:/var/www/lms/doc/lms.pgsql:876: ERROR: sequence "events_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:878: ERROR: table "events" does not exist psql:/var/www/lms/doc/lms.pgsql:892: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "events_pkey" for table "events" CREATE TABLE CREATE INDEX psql:/var/www/lms/doc/lms.pgsql:898: ERROR: table "eventassignments" does not exist psql:/var/www/lms/doc/lms.pgsql:903: NOTICE: CREATE TABLE / UNIQUE will create implicit index "eventassignments_eventid_key" for table "eventassignments" CREATE TABLE psql:/var/www/lms/doc/lms.pgsql:908: ERROR: table "sessions" does not exist psql:/var/www/lms/doc/lms.pgsql:917: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "sessions_pkey" for table "sessions" CREATE TABLE psql:/var/www/lms/doc/lms.pgsql:922: ERROR: sequence "cashsources_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:924: ERROR: table "cashsources" does not exist psql:/var/www/lms/doc/lms.pgsql:931: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "cashsources_pkey" for table "cashsources" psql:/var/www/lms/doc/lms.pgsql:931: NOTICE: CREATE TABLE / UNIQUE will create implicit index "cashsources_name_key" for table "cashsources" CREATE TABLE psql:/var/www/lms/doc/lms.pgsql:936: ERROR: sequence "sourcefiles_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:938: ERROR: table "sourcefiles" does not exist psql:/var/www/lms/doc/lms.pgsql:947: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "sourcefiles_pkey" for table "sourcefiles" psql:/var/www/lms/doc/lms.pgsql:947: NOTICE: CREATE TABLE / UNIQUE will create implicit index "sourcefiles_idate_key" for table "sourcefiles" CREATE TABLE CREATE INDEX psql:/var/www/lms/doc/lms.pgsql:954: ERROR: sequence "cashimport_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:956: ERROR: table "cashimport" does not exist psql:/var/www/lms/doc/lms.pgsql:972: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "cashimport_pkey" for table "cashimport" CREATE TABLE CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX psql:/var/www/lms/doc/lms.pgsql:982: ERROR: sequence "hosts_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:984: ERROR: table "hosts" does not exist psql:/var/www/lms/doc/lms.pgsql:993: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "hosts_pkey" for table "hosts" psql:/var/www/lms/doc/lms.pgsql:993: NOTICE: CREATE TABLE / UNIQUE will create implicit index "hosts_name_key" for table "hosts" CREATE TABLE psql:/var/www/lms/doc/lms.pgsql:998: ERROR: sequence "daemoninstances_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:1000: ERROR: table "daemoninstances" does not exist psql:/var/www/lms/doc/lms.pgsql:1011: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "daemoninstances_pkey" for table "daemoninstances" CREATE TABLE psql:/var/www/lms/doc/lms.pgsql:1016: ERROR: sequence "daemonconfig_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:1018: ERROR: table "daemonconfig" does not exist psql:/var/www/lms/doc/lms.pgsql:1028: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "daemonconfig_pkey" for table "daemonconfig" psql:/var/www/lms/doc/lms.pgsql:1028: NOTICE: CREATE TABLE / UNIQUE will create implicit index "daemonconfig_instanceid_key" for table "daemonconfig" CREATE TABLE psql:/var/www/lms/doc/lms.pgsql:1033: ERROR: sequence "docrights_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:1035: ERROR: table "docrights" does not exist psql:/var/www/lms/doc/lms.pgsql:1043: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "docrights_pkey" for table "docrights" psql:/var/www/lms/doc/lms.pgsql:1043: NOTICE: CREATE TABLE / UNIQUE will create implicit index "docrights_userid_key" for table "docrights" CREATE TABLE psql:/var/www/lms/doc/lms.pgsql:1048: ERROR: sequence "cashrights_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:1050: ERROR: table "cashrights" does not exist psql:/var/www/lms/doc/lms.pgsql:1058: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "cashrights_pkey" for table "cashrights" psql:/var/www/lms/doc/lms.pgsql:1058: NOTICE: CREATE TABLE / UNIQUE will create implicit index "cashrights_userid_key" for table "cashrights" CREATE TABLE psql:/var/www/lms/doc/lms.pgsql:1063: ERROR: sequence "cashregs_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:1065: ERROR: table "cashregs" does not exist psql:/var/www/lms/doc/lms.pgsql:1075: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "cashregs_pkey" for table "cashregs" psql:/var/www/lms/doc/lms.pgsql:1075: NOTICE: CREATE TABLE / UNIQUE will create implicit index "cashregs_name_key" for table "cashregs" CREATE TABLE psql:/var/www/lms/doc/lms.pgsql:1080: ERROR: sequence "cashreglog_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:1082: ERROR: table "cashreglog" does not exist psql:/var/www/lms/doc/lms.pgsql:1093: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "cashreglog_pkey" for table "cashreglog" psql:/var/www/lms/doc/lms.pgsql:1093: NOTICE: CREATE TABLE / UNIQUE will create implicit index "cashreglog_regid_key" for table "cashreglog" CREATE TABLE psql:/var/www/lms/doc/lms.pgsql:1098: ERROR: sequence "ewx_pt_config_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:1100: ERROR: table "ewx_pt_config" does not exist psql:/var/www/lms/doc/lms.pgsql:1110: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "ewx_pt_config_pkey" for table "ewx_pt_config" psql:/var/www/lms/doc/lms.pgsql:1110: NOTICE: CREATE TABLE / UNIQUE will create implicit index "ewx_pt_config_nodeid_key" for table "ewx_pt_config" CREATE TABLE psql:/var/www/lms/doc/lms.pgsql:1115: ERROR: sequence "ewx_stm_nodes_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:1117: ERROR: table "ewx_stm_nodes" does not exist psql:/var/www/lms/doc/lms.pgsql:1131: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "ewx_stm_nodes_pkey" for table "ewx_stm_nodes" psql:/var/www/lms/doc/lms.pgsql:1131: NOTICE: CREATE TABLE / UNIQUE will create implicit index "ewx_stm_nodes_nodeid_key" for table "ewx_stm_nodes" CREATE TABLE psql:/var/www/lms/doc/lms.pgsql:1136: ERROR: sequence "ewx_stm_channels_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:1138: ERROR: table "ewx_stm_channels" does not exist psql:/var/www/lms/doc/lms.pgsql:1146: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "ewx_stm_channels_pkey" for table "ewx_stm_channels" psql:/var/www/lms/doc/lms.pgsql:1146: NOTICE: CREATE TABLE / UNIQUE will create implicit index "ewx_stm_channels_cid_key" for table "ewx_stm_channels" CREATE TABLE psql:/var/www/lms/doc/lms.pgsql:1151: ERROR: sequence "ewx_channels_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:1153: ERROR: table "ewx_channels" does not exist psql:/var/www/lms/doc/lms.pgsql:1163: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "ewx_channels_pkey" for table "ewx_channels" psql:/var/www/lms/doc/lms.pgsql:1163: NOTICE: CREATE TABLE / UNIQUE will create implicit index "ewx_channels_name_key" for table "ewx_channels" CREATE TABLE psql:/var/www/lms/doc/lms.pgsql:1168: ERROR: sequence "netdevices_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:1170: ERROR: table "netdevices" does not exist psql:/var/www/lms/doc/lms.pgsql:1190: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "netdevices_pkey" for table "netdevices" CREATE TABLE CREATE INDEX psql:/var/www/lms/doc/lms.pgsql:1197: ERROR: table "dbinfo" does not exist psql:/var/www/lms/doc/lms.pgsql:1202: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "dbinfo_pkey" for table "dbinfo" CREATE TABLE psql:/var/www/lms/doc/lms.pgsql:1207: ERROR: sequence "imessengers_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:1209: ERROR: table "imessengers" does not exist psql:/var/www/lms/doc/lms.pgsql:1217: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "imessengers_pkey" for table "imessengers" CREATE TABLE CREATE INDEX psql:/var/www/lms/doc/lms.pgsql:1223: ERROR: sequence "customercontacts_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:1225: ERROR: table "customercontacts" does not exist psql:/var/www/lms/doc/lms.pgsql:1234: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "customercontacts_pkey" for table "customercontacts" CREATE TABLE CREATE INDEX CREATE INDEX psql:/var/www/lms/doc/lms.pgsql:1241: ERROR: sequence "excludedgroups_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:1243: ERROR: table "excludedgroups" does not exist psql:/var/www/lms/doc/lms.pgsql:1251: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "excludedgroups_pkey" for table "excludedgroups" psql:/var/www/lms/doc/lms.pgsql:1251: NOTICE: CREATE TABLE / UNIQUE will create implicit index "excludedgroups_userid_key" for table "excludedgroups" CREATE TABLE CREATE INDEX psql:/var/www/lms/doc/lms.pgsql:1257: ERROR: sequence "states_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:1259: ERROR: table "states" does not exist psql:/var/www/lms/doc/lms.pgsql:1266: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "states_pkey" for table "states" psql:/var/www/lms/doc/lms.pgsql:1266: NOTICE: CREATE TABLE / UNIQUE will create implicit index "states_name_key" for table "states" CREATE TABLE psql:/var/www/lms/doc/lms.pgsql:1271: ERROR: sequence "countries_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:1273: ERROR: table "countries" does not exist psql:/var/www/lms/doc/lms.pgsql:1279: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "countries_pkey" for table "countries" psql:/var/www/lms/doc/lms.pgsql:1279: NOTICE: CREATE TABLE / UNIQUE will create implicit index "countries_name_key" for table "countries" CREATE TABLE psql:/var/www/lms/doc/lms.pgsql:1284: ERROR: sequence "zipcodes_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:1286: ERROR: table "zipcodes" does not exist psql:/var/www/lms/doc/lms.pgsql:1293: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "zipcodes_pkey" for table "zipcodes" psql:/var/www/lms/doc/lms.pgsql:1293: NOTICE: CREATE TABLE / UNIQUE will create implicit index "zipcodes_zip_key" for table "zipcodes" CREATE TABLE CREATE INDEX psql:/var/www/lms/doc/lms.pgsql:1299: ERROR: sequence "divisions_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:1301: ERROR: table "divisions" does not exist psql:/var/www/lms/doc/lms.pgsql:1323: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "divisions_pkey" for table "divisions" psql:/var/www/lms/doc/lms.pgsql:1323: NOTICE: CREATE TABLE / UNIQUE will create implicit index "divisions_shortname_key" for table "divisions" CREATE TABLE psql:/var/www/lms/doc/lms.pgsql:1328: ERROR: sequence "voipaccounts_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:1330: ERROR: table "voipaccounts" does not exist psql:/var/www/lms/doc/lms.pgsql:1342: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "voipaccounts_pkey" for table "voipaccounts" CREATE TABLE psql:/var/www/lms/doc/lms.pgsql:1347: ERROR: sequence "messages_id_seq" does not exist psql:/var/www/lms/doc/lms.pgsql:1348: ERROR: table "messages" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:1359: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "messages_pkey" for table "messages" CREATE TABLE CREATE INDEX CREATE INDEX psql:/var/www/lms/doc/lms.pgsql:1367: ERROR: sequence "messageitems_id_seq" does not exist psql:/var/www/lms/doc/lms.pgsql:1368: ERROR: table "messageitems" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:1379: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "messageitems_pkey" for table "messageitems" CREATE TABLE CREATE INDEX CREATE INDEX psql:/var/www/lms/doc/lms.pgsql:1387: ERROR: sequence "nastypes_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:1389: ERROR: table "nastypes" does not exist psql:/var/www/lms/doc/lms.pgsql:1395: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "nastypes_pkey" for table "nastypes" psql:/var/www/lms/doc/lms.pgsql:1395: NOTICE: CREATE TABLE / UNIQUE will create implicit index "nastypes_name_key" for table "nastypes" CREATE TABLE psql:/var/www/lms/doc/lms.pgsql:1400: ERROR: sequence "up_rights_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:1402: ERROR: table "up_rights" does not exist psql:/var/www/lms/doc/lms.pgsql:1410: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "up_rights_pkey" for table "up_rights" CREATE TABLE psql:/var/www/lms/doc/lms.pgsql:1415: ERROR: sequence "up_rights_assignments_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:1417: ERROR: table "up_rights_assignments" does not exist psql:/var/www/lms/doc/lms.pgsql:1424: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "up_rights_assignments_pkey" for table "up_rights_assignments" psql:/var/www/lms/doc/lms.pgsql:1424: NOTICE: CREATE TABLE / UNIQUE will create implicit index "up_rights_assignments_customerid_key" for table "up_rights_assignments" CREATE TABLE psql:/var/www/lms/doc/lms.pgsql:1429: ERROR: sequence "up_customers_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:1431: ERROR: table "up_customers" does not exist psql:/var/www/lms/doc/lms.pgsql:1441: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "up_customers_pkey" for table "up_customers" CREATE TABLE psql:/var/www/lms/doc/lms.pgsql:1446: ERROR: sequence "up_help_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:1448: ERROR: table "up_help" does not exist psql:/var/www/lms/doc/lms.pgsql:1455: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "up_help_pkey" for table "up_help" CREATE TABLE psql:/var/www/lms/doc/lms.pgsql:1460: ERROR: sequence "up_info_changes_id_seq" does not exist CREATE SEQUENCE psql:/var/www/lms/doc/lms.pgsql:1462: ERROR: table "up_info_changes" does not exist psql:/var/www/lms/doc/lms.pgsql:1469: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "up_info_changes_pkey" for table "up_info_changes" CREATE TABLE psql:/var/www/lms/doc/lms.pgsql:1474: ERROR: must be owner of function array_agg CREATE AGGREGATE CREATE FUNCTION CREATE VIEW CREATE FUNCTION CREATE VIEW CREATE VIEW CREATE VIEW INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 postgres@pgsql:~$ #v- 2. teraz przygotowywuje dane do migracji. pobieram z mysql. #v+ root@pgsql:~# cat mysql2pgsql.yml # if a socket is specified we will use that # if tcp is chosen you can use compression mysql: hostname: localhost port: 3306 socket: /var/run/mysqld/mysqld.sock username: root password: toor database: lms compress: false destination: # if file is given, output goes to file, else postgres file: back.sql postgres: hostname: port: 5432 username: lms password: database: lms # if tables is given, only the listed tables will be converted. leave empty to convert all tables. #only_tables: #- table1 #- table2 # if exclude_tables is given, exclude the listed tables from the conversion. #exclude_tables: #- table3 #- table4 # if supress_data is true, only the schema definition will be exported/migrated, and not the data supress_data: false # if supress_ddl is true, only the data will be exported/imported, and not the schema #supress_ddl: false supress_ddl: true # if force_truncate is true, forces a table truncate before table loading #force_truncate: false force_truncate: true # if timezone is true, forces to append/convert to UTC tzinfo mysql data timezone: false root@pgsql:~# root@pgsql:~# py-mysql2pgsql -v -f mysql2pgsql.yml >>>>>>>>>> STARTING <<<<<<<<<< START TRUNCATING TABLES START - TRUNCATING TABLE aliasassignments FINISH - TRUNCATING TABLE aliasassignments START - TRUNCATING TABLE aliases FINISH - TRUNCATING TABLE aliases START - TRUNCATING TABLE assignments FINISH - TRUNCATING TABLE assignments START - TRUNCATING TABLE cash FINISH - TRUNCATING TABLE cash START - TRUNCATING TABLE cashimport FINISH - TRUNCATING TABLE cashimport START - TRUNCATING TABLE cashreglog FINISH - TRUNCATING TABLE cashreglog START - TRUNCATING TABLE cashregs FINISH - TRUNCATING TABLE cashregs START - TRUNCATING TABLE cashrights FINISH - TRUNCATING TABLE cashrights START - TRUNCATING TABLE cashsources FINISH - TRUNCATING TABLE cashsources START - TRUNCATING TABLE countries FINISH - TRUNCATING TABLE countries START - TRUNCATING TABLE customerassignments FINISH - TRUNCATING TABLE customerassignments START - TRUNCATING TABLE customercontacts FINISH - TRUNCATING TABLE customercontacts START - TRUNCATING TABLE customergroups FINISH - TRUNCATING TABLE customergroups START - TRUNCATING TABLE customers FINISH - TRUNCATING TABLE customers START - TRUNCATING TABLE customersview FINISH - TRUNCATING TABLE customersview START - TRUNCATING TABLE daemonconfig FINISH - TRUNCATING TABLE daemonconfig START - TRUNCATING TABLE daemoninstances FINISH - TRUNCATING TABLE daemoninstances START - TRUNCATING TABLE dbinfo FINISH - TRUNCATING TABLE dbinfo START - TRUNCATING TABLE debitnotecontents FINISH - TRUNCATING TABLE debitnotecontents START - TRUNCATING TABLE divisions FINISH - TRUNCATING TABLE divisions START - TRUNCATING TABLE docrights FINISH - TRUNCATING TABLE docrights START - TRUNCATING TABLE documentcontents FINISH - TRUNCATING TABLE documentcontents START - TRUNCATING TABLE documents FINISH - TRUNCATING TABLE documents START - TRUNCATING TABLE domains FINISH - TRUNCATING TABLE domains START - TRUNCATING TABLE eventassignments FINISH - TRUNCATING TABLE eventassignments START - TRUNCATING TABLE events FINISH - TRUNCATING TABLE events START - TRUNCATING TABLE ewx_channels FINISH - TRUNCATING TABLE ewx_channels START - TRUNCATING TABLE ewx_pt_config FINISH - TRUNCATING TABLE ewx_pt_config START - TRUNCATING TABLE ewx_stm_channels FINISH - TRUNCATING TABLE ewx_stm_channels START - TRUNCATING TABLE ewx_stm_nodes FINISH - TRUNCATING TABLE ewx_stm_nodes START - TRUNCATING TABLE excludedgroups FINISH - TRUNCATING TABLE excludedgroups START - TRUNCATING TABLE hosts FINISH - TRUNCATING TABLE hosts START - TRUNCATING TABLE imessengers FINISH - TRUNCATING TABLE imessengers START - TRUNCATING TABLE invoicecontents FINISH - TRUNCATING TABLE invoicecontents START - TRUNCATING TABLE liabilities FINISH - TRUNCATING TABLE liabilities START - TRUNCATING TABLE macs FINISH - TRUNCATING TABLE macs START - TRUNCATING TABLE messageitems FINISH - TRUNCATING TABLE messageitems START - TRUNCATING TABLE messages FINISH - TRUNCATING TABLE messages START - TRUNCATING TABLE nastypes FINISH - TRUNCATING TABLE nastypes START - TRUNCATING TABLE netdevices FINISH - TRUNCATING TABLE netdevices START - TRUNCATING TABLE netlinks FINISH - TRUNCATING TABLE netlinks START - TRUNCATING TABLE networks FINISH - TRUNCATING TABLE networks START - TRUNCATING TABLE nodeassignments FINISH - TRUNCATING TABLE nodeassignments START - TRUNCATING TABLE nodegroupassignments FINISH - TRUNCATING TABLE nodegroupassignments START - TRUNCATING TABLE nodegroups FINISH - TRUNCATING TABLE nodegroups START - TRUNCATING TABLE nodes FINISH - TRUNCATING TABLE nodes START - TRUNCATING TABLE numberplanassignments FINISH - TRUNCATING TABLE numberplanassignments START - TRUNCATING TABLE numberplans FINISH - TRUNCATING TABLE numberplans START - TRUNCATING TABLE passwd FINISH - TRUNCATING TABLE passwd START - TRUNCATING TABLE payments FINISH - TRUNCATING TABLE payments START - TRUNCATING TABLE promotionassignments FINISH - TRUNCATING TABLE promotionassignments START - TRUNCATING TABLE promotions FINISH - TRUNCATING TABLE promotions START - TRUNCATING TABLE promotionschemas FINISH - TRUNCATING TABLE promotionschemas START - TRUNCATING TABLE receiptcontents FINISH - TRUNCATING TABLE receiptcontents START - TRUNCATING TABLE records FINISH - TRUNCATING TABLE records START - TRUNCATING TABLE rtattachments FINISH - TRUNCATING TABLE rtattachments START - TRUNCATING TABLE rtmessages FINISH - TRUNCATING TABLE rtmessages START - TRUNCATING TABLE rtnotes FINISH - TRUNCATING TABLE rtnotes START - TRUNCATING TABLE rtqueues FINISH - TRUNCATING TABLE rtqueues START - TRUNCATING TABLE rtrights FINISH - TRUNCATING TABLE rtrights START - TRUNCATING TABLE rttickets FINISH - TRUNCATING TABLE rttickets START - TRUNCATING TABLE sessions FINISH - TRUNCATING TABLE sessions START - TRUNCATING TABLE sourcefiles FINISH - TRUNCATING TABLE sourcefiles START - TRUNCATING TABLE states FINISH - TRUNCATING TABLE states START - TRUNCATING TABLE stats FINISH - TRUNCATING TABLE stats START - TRUNCATING TABLE supermasters FINISH - TRUNCATING TABLE supermasters START - TRUNCATING TABLE tariffs FINISH - TRUNCATING TABLE tariffs START - TRUNCATING TABLE taxes FINISH - TRUNCATING TABLE taxes START - TRUNCATING TABLE uiconfig FINISH - TRUNCATING TABLE uiconfig START - TRUNCATING TABLE up_customers FINISH - TRUNCATING TABLE up_customers START - TRUNCATING TABLE up_help FINISH - TRUNCATING TABLE up_help START - TRUNCATING TABLE up_info_changes FINISH - TRUNCATING TABLE up_info_changes START - TRUNCATING TABLE up_rights FINISH - TRUNCATING TABLE up_rights START - TRUNCATING TABLE up_rights_assignments FINISH - TRUNCATING TABLE up_rights_assignments START - TRUNCATING TABLE users FINISH - TRUNCATING TABLE users START - TRUNCATING TABLE vmacs FINISH - TRUNCATING TABLE vmacs START - TRUNCATING TABLE vnodes FINISH - TRUNCATING TABLE vnodes START - TRUNCATING TABLE vnodes_mac FINISH - TRUNCATING TABLE vnodes_mac START - TRUNCATING TABLE voipaccounts FINISH - TRUNCATING TABLE voipaccounts START - TRUNCATING TABLE zipcodes FINISH - TRUNCATING TABLE zipcodes DONE TRUNCATING TABLES START WRITING TABLE DATA START - WRITING DATA TO aliasassignments FINISH - WRITING DATA TO aliasassignments START - WRITING DATA TO aliases FINISH - WRITING DATA TO aliases START - WRITING DATA TO assignments FINISH - WRITING DATA TO assignments START - WRITING DATA TO cash 11608.32 rows/sec [180000] FINISH - WRITING DATA TO cash START - WRITING DATA TO cashimport FINISH - WRITING DATA TO cashimport START - WRITING DATA TO cashreglog FINISH - WRITING DATA TO cashreglog START - WRITING DATA TO cashregs FINISH - WRITING DATA TO cashregs START - WRITING DATA TO cashrights FINISH - WRITING DATA TO cashrights START - WRITING DATA TO cashsources FINISH - WRITING DATA TO cashsources START - WRITING DATA TO countries FINISH - WRITING DATA TO countries START - WRITING DATA TO customerassignments FINISH - WRITING DATA TO customerassignments START - WRITING DATA TO customercontacts FINISH - WRITING DATA TO customercontacts START - WRITING DATA TO customergroups FINISH - WRITING DATA TO customergroups START - WRITING DATA TO customers FINISH - WRITING DATA TO customers START - WRITING DATA TO customersview FINISH - WRITING DATA TO customersview START - WRITING DATA TO daemonconfig FINISH - WRITING DATA TO daemonconfig START - WRITING DATA TO daemoninstances FINISH - WRITING DATA TO daemoninstances START - WRITING DATA TO dbinfo FINISH - WRITING DATA TO dbinfo START - WRITING DATA TO debitnotecontents FINISH - WRITING DATA TO debitnotecontents START - WRITING DATA TO divisions FINISH - WRITING DATA TO divisions START - WRITING DATA TO docrights FINISH - WRITING DATA TO docrights START - WRITING DATA TO documentcontents FINISH - WRITING DATA TO documentcontents START - WRITING DATA TO documents 7051.36 rows/sec [120000] FINISH - WRITING DATA TO documents START - WRITING DATA TO domains FINISH - WRITING DATA TO domains START - WRITING DATA TO eventassignments FINISH - WRITING DATA TO eventassignments START - WRITING DATA TO events FINISH - WRITING DATA TO events START - WRITING DATA TO ewx_channels FINISH - WRITING DATA TO ewx_channels START - WRITING DATA TO ewx_pt_config FINISH - WRITING DATA TO ewx_pt_config START - WRITING DATA TO ewx_stm_channels FINISH - WRITING DATA TO ewx_stm_channels START - WRITING DATA TO ewx_stm_nodes FINISH - WRITING DATA TO ewx_stm_nodes START - WRITING DATA TO excludedgroups FINISH - WRITING DATA TO excludedgroups START - WRITING DATA TO hosts FINISH - WRITING DATA TO hosts START - WRITING DATA TO imessengers FINISH - WRITING DATA TO imessengers START - WRITING DATA TO invoicecontents 8598.63 rows/sec [100000] FINISH - WRITING DATA TO invoicecontents START - WRITING DATA TO liabilities FINISH - WRITING DATA TO liabilities START - WRITING DATA TO macs FINISH - WRITING DATA TO macs START - WRITING DATA TO messageitems FINISH - WRITING DATA TO messageitems START - WRITING DATA TO messages FINISH - WRITING DATA TO messages START - WRITING DATA TO nastypes FINISH - WRITING DATA TO nastypes START - WRITING DATA TO netdevices FINISH - WRITING DATA TO netdevices START - WRITING DATA TO netlinks FINISH - WRITING DATA TO netlinks START - WRITING DATA TO networks FINISH - WRITING DATA TO networks START - WRITING DATA TO nodeassignments FINISH - WRITING DATA TO nodeassignments START - WRITING DATA TO nodegroupassignments FINISH - WRITING DATA TO nodegroupassignments START - WRITING DATA TO nodegroups FINISH - WRITING DATA TO nodegroups START - WRITING DATA TO nodes FINISH - WRITING DATA TO nodes START - WRITING DATA TO numberplanassignments FINISH - WRITING DATA TO numberplanassignments START - WRITING DATA TO numberplans FINISH - WRITING DATA TO numberplans START - WRITING DATA TO passwd FINISH - WRITING DATA TO passwd START - WRITING DATA TO payments FINISH - WRITING DATA TO payments START - WRITING DATA TO promotionassignments FINISH - WRITING DATA TO promotionassignments START - WRITING DATA TO promotions FINISH - WRITING DATA TO promotions START - WRITING DATA TO promotionschemas FINISH - WRITING DATA TO promotionschemas START - WRITING DATA TO receiptcontents 15751.60 rows/sec [40000] FINISH - WRITING DATA TO receiptcontents START - WRITING DATA TO records FINISH - WRITING DATA TO records START - WRITING DATA TO rtattachments FINISH - WRITING DATA TO rtattachments START - WRITING DATA TO rtmessages FINISH - WRITING DATA TO rtmessages START - WRITING DATA TO rtnotes FINISH - WRITING DATA TO rtnotes START - WRITING DATA TO rtqueues FINISH - WRITING DATA TO rtqueues START - WRITING DATA TO rtrights FINISH - WRITING DATA TO rtrights START - WRITING DATA TO rttickets FINISH - WRITING DATA TO rttickets START - WRITING DATA TO sessions FINISH - WRITING DATA TO sessions START - WRITING DATA TO sourcefiles FINISH - WRITING DATA TO sourcefiles START - WRITING DATA TO states FINISH - WRITING DATA TO states START - WRITING DATA TO stats FINISH - WRITING DATA TO stats START - WRITING DATA TO supermasters FINISH - WRITING DATA TO supermasters START - WRITING DATA TO tariffs FINISH - WRITING DATA TO tariffs START - WRITING DATA TO taxes FINISH - WRITING DATA TO taxes START - WRITING DATA TO uiconfig FINISH - WRITING DATA TO uiconfig START - WRITING DATA TO up_customers FINISH - WRITING DATA TO up_customers START - WRITING DATA TO up_help FINISH - WRITING DATA TO up_help START - WRITING DATA TO up_info_changes FINISH - WRITING DATA TO up_info_changes START - WRITING DATA TO up_rights FINISH - WRITING DATA TO up_rights START - WRITING DATA TO up_rights_assignments FINISH - WRITING DATA TO up_rights_assignments START - WRITING DATA TO users FINISH - WRITING DATA TO users START - WRITING DATA TO vmacs FINISH - WRITING DATA TO vmacs START - WRITING DATA TO vnodes FINISH - WRITING DATA TO vnodes START - WRITING DATA TO vnodes_mac FINISH - WRITING DATA TO vnodes_mac START - WRITING DATA TO voipaccounts FINISH - WRITING DATA TO voipaccounts START - WRITING DATA TO zipcodes FINISH - WRITING DATA TO zipcodes DONE WRITING TABLE DATA >>>>>>>>>> FINISHED <<<<<<<<<< #v- 3. tak przygotowany plik sql wrzucam do postgresa ale niestety sa errory #v+ postgres@pgsql:~$ psql -d lms -U lms -f /root/back.sql SET SET SET SET TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) psql:/root/back.sql:80: ERROR: "customersview" is not a table TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) psql:/root/back.sql:250: ERROR: relation "promotionassignments" does not exist psql:/root/back.sql:252: ERROR: relation "promotionassignments" does not exist psql:/root/back.sql:255: ERROR: relation "promotions" does not exist psql:/root/back.sql:257: ERROR: relation "promotions" does not exist psql:/root/back.sql:260: ERROR: relation "promotionschemas" does not exist psql:/root/back.sql:262: ERROR: relation "promotionschemas" does not exist TRUNCATE TABLE TRUNCATE TABLE setval -------- (1 row) psql:/root/back.sql:273: ERROR: relation "rtattachments" does not exist TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) psql:/root/back.sql:367: ERROR: "vmacs" is not a table psql:/root/back.sql:370: ERROR: "vnodes" is not a table psql:/root/back.sql:373: ERROR: relation "vnodes_mac" does not exist TRUNCATE TABLE setval -------- (1 row) TRUNCATE TABLE setval -------- (1 row) psql:/root/back.sql:2847: ERROR: invalid input syntax for integer: "t" CONTEXT: COPY assignments, line 1, column invoice: "t" psql:/root/back.sql:199444: ERROR: invalid input syntax for integer: "f" CONTEXT: COPY cashregs, line 1, column disabled: "f" psql:/root/back.sql:201097: ERROR: insert or update on table "customerassignments" violates foreign key constraint "customerassignments_customergroupid_fkey" DETAIL: Key (customergroupid)=(1) is not present in table "customergroups". psql:/root/back.sql:203940: ERROR: insert or update on table "customercontacts" violates foreign key constraint "customercontacts_customerid_fkey" DETAIL: Key (customerid)=(888) is not present in table "customers". psql:/root/back.sql:206249: ERROR: invalid input syntax for integer: "f" CONTEXT: COPY customers, line 1, column deleted: "f" psql:/root/back.sql:208542: ERROR: cannot copy to view "customersview" psql:/root/back.sql:208609: ERROR: invalid input syntax for integer: "f" CONTEXT: COPY daemonconfig, line 1, column disabled: "f" psql:/root/back.sql:208641: ERROR: invalid input syntax for integer: "f" CONTEXT: COPY daemoninstances, line 1, column disabled: "f" psql:/root/back.sql:208782: ERROR: invalid input syntax for integer: "f" CONTEXT: COPY divisions, line 1, column status: "f" psql:/root/back.sql:347784: ERROR: invalid input syntax for integer: "t" CONTEXT: COPY documents, line 1, column closed: "t" psql:/root/back.sql:348188: ERROR: invalid input syntax for integer: "t" CONTEXT: COPY events, line 1, column private: "t" psql:/root/back.sql:348239: ERROR: invalid input syntax for integer: "f" CONTEXT: COPY hosts, line 1, column reload: "f" psql:/root/back.sql:348270: ERROR: invalid input syntax for integer: "f" CONTEXT: COPY imessengers, line 1, column type: "f" psql:/root/back.sql:452699: ERROR: insert or update on table "macs" violates foreign key constraint "macs_nodeid_fkey" DETAIL: Key (nodeid)=(1780) is not present in table "nodes". psql:/root/back.sql:456685: ERROR: invalid input syntax for integer: "f" CONTEXT: COPY netlinks, line 1, column type: "f" psql:/root/back.sql:456746: ERROR: invalid input syntax for integer: "f" CONTEXT: COPY networks, line 1, column disabled: "f" psql:/root/back.sql:459332: ERROR: insert or update on table "nodeassignments" violates foreign key constraint "nodeassignments_nodeid_fkey" DETAIL: Key (nodeid)=(2) is not present in table "nodes". psql:/root/back.sql:463324: ERROR: invalid input syntax for integer: "f" CONTEXT: COPY nodes, line 1, column linktype: "f" psql:/root/back.sql:463348: ERROR: invalid input syntax for integer: "t" CONTEXT: COPY numberplans, line 1, column isdefault: "t" psql:/root/back.sql:463373: ERROR: relation "promotionassignments" does not exist psql:/root/back.sql:463374: ERROR: syntax error at or near "1" LINE 1: 1 1 202 199; ^ psql:/root/back.sql:463374: ERROR: syntax error at or near "25" LINE 1: 25:3; ^ psql:/root/back.sql:463375: ERROR: syntax error at or near "49" LINE 1: 49:3 ^ psql:/root/back.sql:463375: ERROR: syntax error at or near "25" LINE 1: 25:3; ^ psql:/root/back.sql:463376: invalid command \. psql:/root/back.sql:463383: ERROR: syntax error at or near "49" LINE 1: 49:3 ^ psql:/root/back.sql:463384: invalid command \. psql:/root/back.sql:463391: ERROR: relation "promotionschemas" does not exist psql:/root/back.sql:463392: ERROR: syntax error at or near "1" LINE 1: 1 z aktywacją 12; ^ psql:/root/back.sql:463392: invalid command \N psql:/root/back.sql:463393: ERROR: syntax error at or near "24" LINE 1: 24 1 f ^ psql:/root/back.sql:463393: invalid command \N psql:/root/back.sql:463394: invalid command \. psql:/root/back.sql:463401: ERROR: syntax error at or near "24" LINE 1: 24 1 f ^ psql:/root/back.sql:484687: ERROR: syntax error at or near "3297" LINE 1: 3297 1 191.80 Faktura VAT Nr 642/2006 1 ^ psql:/root/back.sql:493540: ERROR: syntax error at or near ")" LINE 1: )))) 2 ^ psql:/root/back.sql:493969: ERROR: syntax error at or near ")" LINE 1: ) 2 ^ psql:/root/back.sql:498413: ERROR: syntax error at or near ")" LINE 1: ) 2 ^ psql:/root/back.sql:498432: ERROR: syntax error at or near ")" LINE 1: ) 2 ^ psql:/root/back.sql:498443: ERROR: syntax error at or near "wnanie" LINE 1: wnanie 2 ^ psql:/root/back.sql:498538: ERROR: syntax error at or near ")" LINE 1: ) 2 ^ psql:/root/back.sql:498678: ERROR: syntax error at or near ")" LINE 1: ) 2 ^ psql:/root/back.sql:498679: ERROR: syntax error at or near ")" LINE 1: ) 2 ^ psql:/root/back.sql:499232: ERROR: syntax error at or near ")" LINE 1: ) 2 ^ psql:/root/back.sql:500217: ERROR: syntax error at or near ")" LINE 1: ) 2 ^ psql:/root/back.sql:500450: ERROR: syntax error at or near ")" LINE 1: ) 2 ^ psql:/root/back.sql:500575: ERROR: syntax error at or near ")" LINE 1: ) 2 ^ psql:/root/back.sql:500576: ERROR: syntax error at or near ")" LINE 1: ) 2 ^ psql:/root/back.sql:501024: ERROR: syntax error at or near ")" LINE 1: ) 2 ^ psql:/root/back.sql:515732: invalid command \n> psql:/root/back.sql:515733: invalid command \nPowinno Query buffer reset (cleared). psql:/root/back.sql:515734: invalid command \nJakby Query buffer reset (cleared). psql:/root/back.sql:515735: invalid command \nod psql:/root/back.sql:515736: invalid command \n Query buffer reset (cleared). psql:/root/back.sql:515737: invalid command \n psql:/root/back.sql:515738: invalid command \nFrom: psql:/root/back.sql:515740: invalid command \nFrom: psql:/root/back.sql:515743: invalid command \n> Query buffer reset (cleared). psql:/root/back.sql:515745: invalid command \n psql:/root/back.sql:515746: invalid command \nWłączenie psql:/root/back.sql:515747: invalid command \n Query buffer reset (cleared). psql:/root/back.sql:515748: invalid command \n Query buffer reset (cleared). psql:/root/back.sql:515749: invalid command \n psql:/root/back.sql:515750: invalid command \nPrzetestowałem Query buffer reset (cleared). psql:/root/back.sql:515751: invalid command \n Query buffer reset (cleared). psql:/root/back.sql:515752: invalid command \nUprzejmie Query buffer reset (cleared). psql:/root/back.sql:515753: invalid command \nSerwer psql:/root/back.sql:515754: invalid command \nFrom: psql:/root/back.sql:515755: invalid command \nFrom: psql:/root/back.sql:515757: invalid command \nFrom: psql:/root/back.sql:515759: invalid command \nW Query buffer reset (cleared). psql:/root/back.sql:515760: invalid command \n psql:/root/back.sql:515762: invalid command \nFrom: psql:/root/back.sql:515765: invalid command \n> psql:/root/back.sql:515766: invalid command \nUmówiony Query buffer reset (cleared). psql:/root/back.sql:515767: invalid command \nCzy psql:/root/back.sql:515768: invalid command \n psql:/root/back.sql:515770: invalid command \nFrom: Query buffer reset (cleared). psql:/root/back.sql:515771: invalid command \nPłatności psql:/root/back.sql:515772: invalid command \nFrom: psql:/root/back.sql:515774: invalid command \nFrom: Query buffer reset (cleared). psql:/root/back.sql:515775: invalid command \nUsługa psql:/root/back.sql:515776: invalid command \nFrom: Query buffer reset (cleared). psql:/root/back.sql:515778: invalid command \nczy psql:/root/back.sql:515779: invalid command \n> psql:/root/back.sql:515781: invalid command \nFrom: psql:/root/back.sql:515782: invalid command \. psql:/root/back.sql:515789: ERROR: syntax error at or near "97" LINE 1: 97 53 1 0 Re: Router Edimax BR-6226n - konfiguracja [RT#000... ^ Query buffer reset (cleared). psql:/root/back.sql:515790: invalid command \nPaweł Query buffer reset (cleared). psql:/root/back.sql:515792: invalid command \nCo Query buffer reset (cleared). psql:/root/back.sql:515795: invalid command \nna Query buffer reset (cleared). psql:/root/back.sql:515796: invalid command \nPotwierdzone Query buffer reset (cleared). psql:/root/back.sql:515798: invalid command \nUmówić Query buffer reset (cleared). psql:/root/back.sql:515800: invalid command \nDane psql:/root/back.sql:515802: invalid command \. psql:/root/back.sql:515809: ERROR: syntax error at or near "16" LINE 1: 16 43 1 Wymiana MT 1356343553 ^ psql:/root/back.sql:515814: invalid command \. psql:/root/back.sql:515821: ERROR: syntax error at or near "1" LINE 1: 1 zgloszenia biuro(a)interdom.net.pl zgloszenia klientów ^ psql:/root/back.sql:515849: invalid command \. psql:/root/back.sql:515856: ERROR: syntax error at or near "53" LINE 1: 53 1 1 15 ^ psql:/root/back.sql:515862: ERROR: syntax error at or near "8" LINE 1: 8 1 Problem z zalogowaniem na http://biling.interdom.net.pl... ^ psql:/root/back.sql:515896: invalid command \. psql:/root/back.sql:515903: ERROR: syntax error at or near ")" LINE 1: )) 2 11 1965 1329297577 1329298273 2 11 ^ psql:/root/back.sql:515904: ERROR: syntax error at or near "78" LINE 1: 78dad9c4ff0dae1eddb4a96133acdf26051966eeb08786b0 1368813291 ... ^ psql:/root/back.sql:515904: ERROR: syntax error at or near "s" LINE 1: s:12:"193.59.33.10"; ^ psql:/root/back.sql:515904: ERROR: syntax error at or near "s" LINE 1: s:15:"HTTP_USER_AGENT"; ^ psql:/root/back.sql:515904: ERROR: syntax error at or near "s" LINE 1: s:101:"Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.31 (KHTM... ^ psql:/root/back.sql:515904: ERROR: syntax error at or near "s" LINE 1: s:11:"SERVER_NAME"; ^ psql:/root/back.sql:515904: ERROR: syntax error at or near "s" LINE 1: s:19:"lms.interdom.net.pl"; ^ psql:/root/back.sql:515904: ERROR: syntax error at or near "s" LINE 1: s:11:"SERVER_PORT"; ^ psql:/root/back.sql:515904: ERROR: syntax error at or near "s" LINE 1: s:2:"88"; ^ psql:/root/back.sql:515904: ERROR: syntax error at or near "}" LINE 1: } a:9:{s:10:"session_id"; ^ psql:/root/back.sql:515904: ERROR: syntax error at or near "s" LINE 1: s:1:"7"; ^ psql:/root/back.sql:515904: ERROR: syntax error at or near "s" LINE 1: s:13:"session_login"; ^ psql:/root/back.sql:515904: ERROR: syntax error at or near "s" LINE 1: s:4:"rych"; ^ psql:/root/back.sql:515904: ERROR: syntax error at or near "s" LINE 1: s:15:"session_logname"; ^ psql:/root/back.sql:515904: ERROR: syntax error at or near "s" LINE 1: s:14:"Ryszard Rauzer"; ^ psql:/root/back.sql:515904: ERROR: syntax error at or near "s" LINE 1: s:12:"session_last"; ^ psql:/root/back.sql:515904: ERROR: syntax error at or near "s" LINE 1: s:10:"1368727020"; ^ psql:/root/back.sql:515904: ERROR: syntax error at or near "s" LINE 1: s:14:"session_lastip"; ^ psql:/root/back.sql:515904: ERROR: syntax error at or near "s" LINE 1: s:12:"193.59.33.10"; ^ psql:/root/back.sql:515904: ERROR: syntax error at or near "s" LINE 1: s:10:"lastmodule"; ^ psql:/root/back.sql:515904: ERROR: syntax error at or near "s" LINE 1: s:10:"netdevinfo"; ^ psql:/root/back.sql:515904: ERROR: syntax error at or near "s" LINE 1: s:4:"ndlo"; ^ psql:/root/back.sql:515904: ERROR: syntax error at or near "N" LINE 1: N; ^ psql:/root/back.sql:515904: ERROR: syntax error at or near "s" LINE 1: s:4:"ndlp"; ^ psql:/root/back.sql:515904: ERROR: syntax error at or near "i" LINE 1: i:1; ^ psql:/root/back.sql:515904: ERROR: syntax error at or near "s" LINE 1: s:6:"backto"; ^ psql:/root/back.sql:515904: ERROR: syntax error at or near "s" LINE 1: s:28:"m=netdevinfo&id=1841&ip=4359"; ^ psql:/root/back.sql:515905: invalid command \. psql:/root/back.sql:515912: ERROR: syntax error at or near "}" LINE 1: } ^ psql:/root/back.sql:515913: invalid command \. psql:/root/back.sql:516302: ERROR: invalid input syntax for integer: "f" CONTEXT: COPY uiconfig, line 1, column disabled: "f" psql:/root/back.sql:516560: ERROR: invalid input syntax for integer: "t" CONTEXT: COPY up_rights, line 1, column setdefault: "t" psql:/root/back.sql:516592: ERROR: invalid input syntax for integer: "f" CONTEXT: COPY users, line 1, column deleted: "f" psql:/root/back.sql:520513: ERROR: cannot copy to view "vmacs" psql:/root/back.sql:524481: ERROR: cannot copy to view "vnodes" psql:/root/back.sql:524488: ERROR: relation "vnodes_mac" does not exist psql:/root/back.sql:528402: invalid command \. psql:/root/back.sql:528409: ERROR: syntax error at or near "2" LINE 1: 2 00:10:5A:3B:FC:A8 ^ psql:/root/back.sql:528526: invalid command \. psql:/root/back.sql:528533: ERROR: syntax error at or near "1" LINE 1: 1 3 468807001 ClD68qJ7jqF0ntA7BvD0 48468807001 1320406614 13... ^ psql:/root/back.sql:528652: invalid command \. psql:/root/back.sql:528653: ERROR: syntax error at or near "1" LINE 1: 1 0 ^ postgres@pgsql:~$ #v- niestety po tym zabiegu wiele danych nie ląduje do bazy :/ ma ktoś jakiś pomysł by to ruszyło? ============== Drugi scenariusz ======= dane brane z mysql wrzucane bezpośrednio do postgres. w posgtgresie czysta baza ze schamatami. próba zrzucenia samych danych: #v+ root@pgsql:~# cat mysql2pgsql.yml # if a socket is specified we will use that # if tcp is chosen you can use compression mysql: hostname: localhost port: 3306 socket: /var/run/mysqld/mysqld.sock username: root password: toor database: lms compress: false destination: # if file is given, output goes to file, else postgres file: postgres: hostname: localhost port: 5432 username: lms password: pass database: lms # if tables is given, only the listed tables will be converted. leave empty to convert all tables. #only_tables: #- table1 #- table2 # if exclude_tables is given, exclude the listed tables from the conversion. #exclude_tables: #- table3 #- table4 # if supress_data is true, only the schema definition will be exported/migrated, and not the data supress_data: false # if supress_ddl is true, only the data will be exported/imported, and not the schema #supress_ddl: false supress_ddl: true # if force_truncate is true, forces a table truncate before table loading force_truncate: false #force_truncate: true # if timezone is true, forces to append/convert to UTC tzinfo mysql data timezone: false root@pgsql:~# py-mysql2pgsql -v -f mysql2pgsql.yml >>>>>>>>>> STARTING <<<<<<<<<< START WRITING TABLE DATA START - WRITING DATA TO aliasassignments FINISH - WRITING DATA TO aliasassignments START - WRITING DATA TO aliases FINISH - WRITING DATA TO aliases START - WRITING DATA TO assignments Traceback (most recent call last): File "/usr/local/bin/py-mysql2pgsql", line 5, in <module> pkg_resources.run_script('py-mysql2pgsql==0.1.6', 'py-mysql2pgsql') File "/usr/lib/python2.7/dist-packages/pkg_resources.py", line 499, in run_script self.require(requires)[0].run_script(script_name, ns) File "/usr/lib/python2.7/dist-packages/pkg_resources.py", line 1235, in run_script execfile(script_filename, namespace, namespace) File "/usr/local/lib/python2.7/dist-packages/py_mysql2pgsql-0.1.6-py2.7.egg/EGG-INFO/scripts/py-mysql2pgsql", line 38, in <module> mysql2pgsql.Mysql2Pgsql(options).convert() File "/usr/local/lib/python2.7/dist-packages/py_mysql2pgsql-0.1.6-py2.7.egg/mysql2pgsql/mysql2pgsql.py", line 31, in convert Converter(reader, writer, self.file_options, self.run_options.verbose).convert() File "/usr/local/lib/python2.7/dist-packages/py_mysql2pgsql-0.1.6-py2.7.egg/mysql2pgsql/lib/converter.py", line 51, in convert self.writer.write_contents(table, self.reader) File "/usr/local/lib/python2.7/dist-packages/py_mysql2pgsql-0.1.6-py2.7.egg/mysql2pgsql/lib/__init__.py", line 86, in decorated_function ret = f(*args, **kwargs) File "/usr/local/lib/python2.7/dist-packages/py_mysql2pgsql-0.1.6-py2.7.egg/mysql2pgsql/lib/postgres_db_writer.py", line 193, in write_contents self.copy_from(f, '"%s"' % table.name, ['"%s"' % c['name'] for c in table.columns]) File "/usr/local/lib/python2.7/dist-packages/py_mysql2pgsql-0.1.6-py2.7.egg/mysql2pgsql/lib/postgres_db_writer.py", line 116, in copy_from columns=columns psycopg2.DataError: invalid input syntax for integer: "t" CONTEXT: COPY assignments, line 1, column invoice: "t" root@pgsql:~# #v- teraz zrzut całości z mysql do postgres: #v+ root@pgsql:~# cat mysql2pgsql.yml # if a socket is specified we will use that # if tcp is chosen you can use compression mysql: hostname: localhost port: 3306 socket: /var/run/mysqld/mysqld.sock username: root password: toor database: lms compress: false destination: # if file is given, output goes to file, else postgres file: postgres: hostname: localhost port: 5432 username: lms password: pass database: lms # if tables is given, only the listed tables will be converted. leave empty to convert all tables. #only_tables: #- table1 #- table2 # if exclude_tables is given, exclude the listed tables from the conversion. #exclude_tables: #- table3 #- table4 # if supress_data is true, only the schema definition will be exported/migrated, and not the data supress_data: false # if supress_ddl is true, only the data will be exported/imported, and not the schema supress_ddl: false #supress_ddl: true # if force_truncate is true, forces a table truncate before table loading force_truncate: false #force_truncate: true # if timezone is true, forces to append/convert to UTC tzinfo mysql data timezone: false root@pgsql:~# py-mysql2pgsql -v -f mysql2pgsql.yml >>>>>>>>>> STARTING <<<<<<<<<< START CREATING TABLES START - CREATING TABLE aliasassignments FINISH - CREATING TABLE aliasassignments START - CREATING TABLE aliases FINISH - CREATING TABLE aliases START - CREATING TABLE assignments FINISH - CREATING TABLE assignments START - CREATING TABLE cash FINISH - CREATING TABLE cash START - CREATING TABLE cashimport FINISH - CREATING TABLE cashimport START - CREATING TABLE cashreglog FINISH - CREATING TABLE cashreglog START - CREATING TABLE cashregs FINISH - CREATING TABLE cashregs START - CREATING TABLE cashrights FINISH - CREATING TABLE cashrights START - CREATING TABLE cashsources FINISH - CREATING TABLE cashsources START - CREATING TABLE countries FINISH - CREATING TABLE countries START - CREATING TABLE customerassignments FINISH - CREATING TABLE customerassignments START - CREATING TABLE customercontacts FINISH - CREATING TABLE customercontacts START - CREATING TABLE customergroups FINISH - CREATING TABLE customergroups START - CREATING TABLE customers FINISH - CREATING TABLE customers START - CREATING TABLE customersview FINISH - CREATING TABLE customersview START - CREATING TABLE daemonconfig FINISH - CREATING TABLE daemonconfig START - CREATING TABLE daemoninstances FINISH - CREATING TABLE daemoninstances START - CREATING TABLE dbinfo FINISH - CREATING TABLE dbinfo START - CREATING TABLE debitnotecontents FINISH - CREATING TABLE debitnotecontents START - CREATING TABLE divisions FINISH - CREATING TABLE divisions START - CREATING TABLE docrights FINISH - CREATING TABLE docrights START - CREATING TABLE documentcontents FINISH - CREATING TABLE documentcontents START - CREATING TABLE documents FINISH - CREATING TABLE documents START - CREATING TABLE domains FINISH - CREATING TABLE domains START - CREATING TABLE eventassignments FINISH - CREATING TABLE eventassignments START - CREATING TABLE events FINISH - CREATING TABLE events START - CREATING TABLE ewx_channels FINISH - CREATING TABLE ewx_channels START - CREATING TABLE ewx_pt_config FINISH - CREATING TABLE ewx_pt_config START - CREATING TABLE ewx_stm_channels FINISH - CREATING TABLE ewx_stm_channels START - CREATING TABLE ewx_stm_nodes FINISH - CREATING TABLE ewx_stm_nodes START - CREATING TABLE excludedgroups FINISH - CREATING TABLE excludedgroups START - CREATING TABLE hosts FINISH - CREATING TABLE hosts START - CREATING TABLE imessengers FINISH - CREATING TABLE imessengers START - CREATING TABLE invoicecontents FINISH - CREATING TABLE invoicecontents START - CREATING TABLE liabilities FINISH - CREATING TABLE liabilities START - CREATING TABLE macs FINISH - CREATING TABLE macs START - CREATING TABLE messageitems FINISH - CREATING TABLE messageitems START - CREATING TABLE messages FINISH - CREATING TABLE messages START - CREATING TABLE nastypes FINISH - CREATING TABLE nastypes START - CREATING TABLE netdevices FINISH - CREATING TABLE netdevices START - CREATING TABLE netlinks FINISH - CREATING TABLE netlinks START - CREATING TABLE networks FINISH - CREATING TABLE networks START - CREATING TABLE nodeassignments FINISH - CREATING TABLE nodeassignments START - CREATING TABLE nodegroupassignments FINISH - CREATING TABLE nodegroupassignments START - CREATING TABLE nodegroups FINISH - CREATING TABLE nodegroups START - CREATING TABLE nodes FINISH - CREATING TABLE nodes START - CREATING TABLE numberplanassignments FINISH - CREATING TABLE numberplanassignments START - CREATING TABLE numberplans FINISH - CREATING TABLE numberplans START - CREATING TABLE passwd FINISH - CREATING TABLE passwd START - CREATING TABLE payments FINISH - CREATING TABLE payments START - CREATING TABLE promotionassignments FINISH - CREATING TABLE promotionassignments START - CREATING TABLE promotions FINISH - CREATING TABLE promotions START - CREATING TABLE promotionschemas FINISH - CREATING TABLE promotionschemas START - CREATING TABLE receiptcontents FINISH - CREATING TABLE receiptcontents START - CREATING TABLE records FINISH - CREATING TABLE records START - CREATING TABLE rtattachments FINISH - CREATING TABLE rtattachments START - CREATING TABLE rtmessages FINISH - CREATING TABLE rtmessages START - CREATING TABLE rtnotes FINISH - CREATING TABLE rtnotes START - CREATING TABLE rtqueues FINISH - CREATING TABLE rtqueues START - CREATING TABLE rtrights FINISH - CREATING TABLE rtrights START - CREATING TABLE rttickets FINISH - CREATING TABLE rttickets START - CREATING TABLE sessions FINISH - CREATING TABLE sessions START - CREATING TABLE sourcefiles FINISH - CREATING TABLE sourcefiles START - CREATING TABLE states FINISH - CREATING TABLE states START - CREATING TABLE stats FINISH - CREATING TABLE stats START - CREATING TABLE supermasters FINISH - CREATING TABLE supermasters START - CREATING TABLE tariffs FINISH - CREATING TABLE tariffs START - CREATING TABLE taxes FINISH - CREATING TABLE taxes START - CREATING TABLE uiconfig FINISH - CREATING TABLE uiconfig START - CREATING TABLE up_customers FINISH - CREATING TABLE up_customers START - CREATING TABLE up_help FINISH - CREATING TABLE up_help START - CREATING TABLE up_info_changes FINISH - CREATING TABLE up_info_changes START - CREATING TABLE up_rights FINISH - CREATING TABLE up_rights START - CREATING TABLE up_rights_assignments FINISH - CREATING TABLE up_rights_assignments START - CREATING TABLE users FINISH - CREATING TABLE users START - CREATING TABLE vmacs FINISH - CREATING TABLE vmacs START - CREATING TABLE vnodes FINISH - CREATING TABLE vnodes START - CREATING TABLE vnodes_mac FINISH - CREATING TABLE vnodes_mac START - CREATING TABLE voipaccounts FINISH - CREATING TABLE voipaccounts START - CREATING TABLE zipcodes FINISH - CREATING TABLE zipcodes DONE CREATING TABLES START WRITING TABLE DATA START - WRITING DATA TO aliasassignments FINISH - WRITING DATA TO aliasassignments START - WRITING DATA TO aliases FINISH - WRITING DATA TO aliases START - WRITING DATA TO assignments FINISH - WRITING DATA TO assignments START - WRITING DATA TO cash 11045.66 rows/sec [180000] FINISH - WRITING DATA TO cash START - WRITING DATA TO cashimport FINISH - WRITING DATA TO cashimport START - WRITING DATA TO cashreglog FINISH - WRITING DATA TO cashreglog START - WRITING DATA TO cashregs FINISH - WRITING DATA TO cashregs START - WRITING DATA TO cashrights FINISH - WRITING DATA TO cashrights START - WRITING DATA TO cashsources FINISH - WRITING DATA TO cashsources START - WRITING DATA TO countries FINISH - WRITING DATA TO countries START - WRITING DATA TO customerassignments FINISH - WRITING DATA TO customerassignments START - WRITING DATA TO customercontacts FINISH - WRITING DATA TO customercontacts START - WRITING DATA TO customergroups FINISH - WRITING DATA TO customergroups START - WRITING DATA TO customers FINISH - WRITING DATA TO customers START - WRITING DATA TO customersview FINISH - WRITING DATA TO customersview START - WRITING DATA TO daemonconfig FINISH - WRITING DATA TO daemonconfig START - WRITING DATA TO daemoninstances FINISH - WRITING DATA TO daemoninstances START - WRITING DATA TO dbinfo FINISH - WRITING DATA TO dbinfo START - WRITING DATA TO debitnotecontents FINISH - WRITING DATA TO debitnotecontents START - WRITING DATA TO divisions FINISH - WRITING DATA TO divisions START - WRITING DATA TO docrights FINISH - WRITING DATA TO docrights START - WRITING DATA TO documentcontents FINISH - WRITING DATA TO documentcontents START - WRITING DATA TO documents 7084.47 rows/sec [120000] FINISH - WRITING DATA TO documents START - WRITING DATA TO domains FINISH - WRITING DATA TO domains START - WRITING DATA TO eventassignments FINISH - WRITING DATA TO eventassignments START - WRITING DATA TO events FINISH - WRITING DATA TO events START - WRITING DATA TO ewx_channels FINISH - WRITING DATA TO ewx_channels START - WRITING DATA TO ewx_pt_config FINISH - WRITING DATA TO ewx_pt_config START - WRITING DATA TO ewx_stm_channels FINISH - WRITING DATA TO ewx_stm_channels START - WRITING DATA TO ewx_stm_nodes FINISH - WRITING DATA TO ewx_stm_nodes START - WRITING DATA TO excludedgroups FINISH - WRITING DATA TO excludedgroups START - WRITING DATA TO hosts FINISH - WRITING DATA TO hosts START - WRITING DATA TO imessengers FINISH - WRITING DATA TO imessengers START - WRITING DATA TO invoicecontents 8713.26 rows/sec [100000] FINISH - WRITING DATA TO invoicecontents START - WRITING DATA TO liabilities FINISH - WRITING DATA TO liabilities START - WRITING DATA TO macs FINISH - WRITING DATA TO macs START - WRITING DATA TO messageitems FINISH - WRITING DATA TO messageitems START - WRITING DATA TO messages FINISH - WRITING DATA TO messages START - WRITING DATA TO nastypes FINISH - WRITING DATA TO nastypes START - WRITING DATA TO netdevices FINISH - WRITING DATA TO netdevices START - WRITING DATA TO netlinks FINISH - WRITING DATA TO netlinks START - WRITING DATA TO networks FINISH - WRITING DATA TO networks START - WRITING DATA TO nodeassignments FINISH - WRITING DATA TO nodeassignments START - WRITING DATA TO nodegroupassignments FINISH - WRITING DATA TO nodegroupassignments START - WRITING DATA TO nodegroups FINISH - WRITING DATA TO nodegroups START - WRITING DATA TO nodes FINISH - WRITING DATA TO nodes START - WRITING DATA TO numberplanassignments FINISH - WRITING DATA TO numberplanassignments START - WRITING DATA TO numberplans FINISH - WRITING DATA TO numberplans START - WRITING DATA TO passwd FINISH - WRITING DATA TO passwd START - WRITING DATA TO payments FINISH - WRITING DATA TO payments START - WRITING DATA TO promotionassignments FINISH - WRITING DATA TO promotionassignments START - WRITING DATA TO promotions FINISH - WRITING DATA TO promotions START - WRITING DATA TO promotionschemas FINISH - WRITING DATA TO promotionschemas START - WRITING DATA TO receiptcontents 16936.79 rows/sec [40000] FINISH - WRITING DATA TO receiptcontents START - WRITING DATA TO records FINISH - WRITING DATA TO records START - WRITING DATA TO rtattachments FINISH - WRITING DATA TO rtattachments START - WRITING DATA TO rtmessages FINISH - WRITING DATA TO rtmessages START - WRITING DATA TO rtnotes FINISH - WRITING DATA TO rtnotes START - WRITING DATA TO rtqueues FINISH - WRITING DATA TO rtqueues START - WRITING DATA TO rtrights FINISH - WRITING DATA TO rtrights START - WRITING DATA TO rttickets FINISH - WRITING DATA TO rttickets START - WRITING DATA TO sessions FINISH - WRITING DATA TO sessions START - WRITING DATA TO sourcefiles FINISH - WRITING DATA TO sourcefiles START - WRITING DATA TO states FINISH - WRITING DATA TO states START - WRITING DATA TO stats FINISH - WRITING DATA TO stats START - WRITING DATA TO supermasters FINISH - WRITING DATA TO supermasters START - WRITING DATA TO tariffs FINISH - WRITING DATA TO tariffs START - WRITING DATA TO taxes FINISH - WRITING DATA TO taxes START - WRITING DATA TO uiconfig FINISH - WRITING DATA TO uiconfig START - WRITING DATA TO up_customers FINISH - WRITING DATA TO up_customers START - WRITING DATA TO up_help FINISH - WRITING DATA TO up_help START - WRITING DATA TO up_info_changes FINISH - WRITING DATA TO up_info_changes START - WRITING DATA TO up_rights FINISH - WRITING DATA TO up_rights START - WRITING DATA TO up_rights_assignments FINISH - WRITING DATA TO up_rights_assignments START - WRITING DATA TO users FINISH - WRITING DATA TO users START - WRITING DATA TO vmacs FINISH - WRITING DATA TO vmacs START - WRITING DATA TO vnodes FINISH - WRITING DATA TO vnodes START - WRITING DATA TO vnodes_mac FINISH - WRITING DATA TO vnodes_mac START - WRITING DATA TO voipaccounts FINISH - WRITING DATA TO voipaccounts START - WRITING DATA TO zipcodes FINISH - WRITING DATA TO zipcodes DONE WRITING TABLE DATA START CREATING INDEXES AND CONSTRAINTS START - ADDING INDEXES TO aliasassignments FINISH - ADDING INDEXES TO aliasassignments START - ADDING INDEXES TO aliases FINISH - ADDING INDEXES TO aliases START - ADDING INDEXES TO assignments FINISH - ADDING INDEXES TO assignments START - ADDING INDEXES TO cash FINISH - ADDING INDEXES TO cash START - ADDING INDEXES TO cashimport FINISH - ADDING INDEXES TO cashimport START - ADDING INDEXES TO cashreglog FINISH - ADDING INDEXES TO cashreglog START - ADDING INDEXES TO cashregs FINISH - ADDING INDEXES TO cashregs START - ADDING INDEXES TO cashrights FINISH - ADDING INDEXES TO cashrights START - ADDING INDEXES TO cashsources FINISH - ADDING INDEXES TO cashsources START - ADDING INDEXES TO countries FINISH - ADDING INDEXES TO countries START - ADDING INDEXES TO customerassignments FINISH - ADDING INDEXES TO customerassignments START - ADDING INDEXES TO customercontacts FINISH - ADDING INDEXES TO customercontacts START - ADDING INDEXES TO customergroups FINISH - ADDING INDEXES TO customergroups START - ADDING INDEXES TO customers FINISH - ADDING INDEXES TO customers START - ADDING INDEXES TO customersview FINISH - ADDING INDEXES TO customersview START - ADDING INDEXES TO daemonconfig FINISH - ADDING INDEXES TO daemonconfig START - ADDING INDEXES TO daemoninstances FINISH - ADDING INDEXES TO daemoninstances START - ADDING INDEXES TO dbinfo FINISH - ADDING INDEXES TO dbinfo START - ADDING INDEXES TO debitnotecontents FINISH - ADDING INDEXES TO debitnotecontents START - ADDING INDEXES TO divisions FINISH - ADDING INDEXES TO divisions START - ADDING INDEXES TO docrights FINISH - ADDING INDEXES TO docrights START - ADDING INDEXES TO documentcontents FINISH - ADDING INDEXES TO documentcontents START - ADDING INDEXES TO documents FINISH - ADDING INDEXES TO documents START - ADDING INDEXES TO domains FINISH - ADDING INDEXES TO domains START - ADDING INDEXES TO eventassignments FINISH - ADDING INDEXES TO eventassignments START - ADDING INDEXES TO events FINISH - ADDING INDEXES TO events START - ADDING INDEXES TO ewx_channels FINISH - ADDING INDEXES TO ewx_channels START - ADDING INDEXES TO ewx_pt_config FINISH - ADDING INDEXES TO ewx_pt_config START - ADDING INDEXES TO ewx_stm_channels FINISH - ADDING INDEXES TO ewx_stm_channels START - ADDING INDEXES TO ewx_stm_nodes FINISH - ADDING INDEXES TO ewx_stm_nodes START - ADDING INDEXES TO excludedgroups FINISH - ADDING INDEXES TO excludedgroups START - ADDING INDEXES TO hosts FINISH - ADDING INDEXES TO hosts START - ADDING INDEXES TO imessengers FINISH - ADDING INDEXES TO imessengers START - ADDING INDEXES TO invoicecontents FINISH - ADDING INDEXES TO invoicecontents START - ADDING INDEXES TO liabilities FINISH - ADDING INDEXES TO liabilities START - ADDING INDEXES TO macs FINISH - ADDING INDEXES TO macs START - ADDING INDEXES TO messageitems FINISH - ADDING INDEXES TO messageitems START - ADDING INDEXES TO messages FINISH - ADDING INDEXES TO messages START - ADDING INDEXES TO nastypes FINISH - ADDING INDEXES TO nastypes START - ADDING INDEXES TO netdevices FINISH - ADDING INDEXES TO netdevices START - ADDING INDEXES TO netlinks FINISH - ADDING INDEXES TO netlinks START - ADDING INDEXES TO networks FINISH - ADDING INDEXES TO networks START - ADDING INDEXES TO nodeassignments FINISH - ADDING INDEXES TO nodeassignments START - ADDING INDEXES TO nodegroupassignments FINISH - ADDING INDEXES TO nodegroupassignments START - ADDING INDEXES TO nodegroups FINISH - ADDING INDEXES TO nodegroups START - ADDING INDEXES TO nodes FINISH - ADDING INDEXES TO nodes START - ADDING INDEXES TO numberplanassignments FINISH - ADDING INDEXES TO numberplanassignments START - ADDING INDEXES TO numberplans FINISH - ADDING INDEXES TO numberplans START - ADDING INDEXES TO passwd FINISH - ADDING INDEXES TO passwd START - ADDING INDEXES TO payments FINISH - ADDING INDEXES TO payments START - ADDING INDEXES TO promotionassignments FINISH - ADDING INDEXES TO promotionassignments START - ADDING INDEXES TO promotions FINISH - ADDING INDEXES TO promotions START - ADDING INDEXES TO promotionschemas FINISH - ADDING INDEXES TO promotionschemas START - ADDING INDEXES TO receiptcontents FINISH - ADDING INDEXES TO receiptcontents START - ADDING INDEXES TO records FINISH - ADDING INDEXES TO records START - ADDING INDEXES TO rtattachments FINISH - ADDING INDEXES TO rtattachments START - ADDING INDEXES TO rtmessages FINISH - ADDING INDEXES TO rtmessages START - ADDING INDEXES TO rtnotes FINISH - ADDING INDEXES TO rtnotes START - ADDING INDEXES TO rtqueues FINISH - ADDING INDEXES TO rtqueues START - ADDING INDEXES TO rtrights FINISH - ADDING INDEXES TO rtrights START - ADDING INDEXES TO rttickets FINISH - ADDING INDEXES TO rttickets START - ADDING INDEXES TO sessions FINISH - ADDING INDEXES TO sessions START - ADDING INDEXES TO sourcefiles FINISH - ADDING INDEXES TO sourcefiles START - ADDING INDEXES TO states FINISH - ADDING INDEXES TO states START - ADDING INDEXES TO stats FINISH - ADDING INDEXES TO stats START - ADDING INDEXES TO supermasters FINISH - ADDING INDEXES TO supermasters START - ADDING INDEXES TO tariffs FINISH - ADDING INDEXES TO tariffs START - ADDING INDEXES TO taxes FINISH - ADDING INDEXES TO taxes START - ADDING INDEXES TO uiconfig FINISH - ADDING INDEXES TO uiconfig START - ADDING INDEXES TO up_customers FINISH - ADDING INDEXES TO up_customers START - ADDING INDEXES TO up_help FINISH - ADDING INDEXES TO up_help START - ADDING INDEXES TO up_info_changes FINISH - ADDING INDEXES TO up_info_changes START - ADDING INDEXES TO up_rights FINISH - ADDING INDEXES TO up_rights START - ADDING INDEXES TO up_rights_assignments FINISH - ADDING INDEXES TO up_rights_assignments START - ADDING INDEXES TO users FINISH - ADDING INDEXES TO users START - ADDING INDEXES TO vmacs FINISH - ADDING INDEXES TO vmacs START - ADDING INDEXES TO vnodes FINISH - ADDING INDEXES TO vnodes START - ADDING INDEXES TO vnodes_mac FINISH - ADDING INDEXES TO vnodes_mac START - ADDING INDEXES TO voipaccounts FINISH - ADDING INDEXES TO voipaccounts START - ADDING INDEXES TO zipcodes FINISH - ADDING INDEXES TO zipcodes START - ADDING CONSTRAINTS ON aliasassignments FINISH - ADDING CONSTRAINTS ON aliasassignments START - ADDING CONSTRAINTS ON aliases FINISH - ADDING CONSTRAINTS ON aliases START - ADDING CONSTRAINTS ON assignments FINISH - ADDING CONSTRAINTS ON assignments START - ADDING CONSTRAINTS ON cash FINISH - ADDING CONSTRAINTS ON cash START - ADDING CONSTRAINTS ON cashimport FINISH - ADDING CONSTRAINTS ON cashimport START - ADDING CONSTRAINTS ON cashreglog FINISH - ADDING CONSTRAINTS ON cashreglog START - ADDING CONSTRAINTS ON cashregs FINISH - ADDING CONSTRAINTS ON cashregs START - ADDING CONSTRAINTS ON cashrights FINISH - ADDING CONSTRAINTS ON cashrights START - ADDING CONSTRAINTS ON cashsources FINISH - ADDING CONSTRAINTS ON cashsources START - ADDING CONSTRAINTS ON countries FINISH - ADDING CONSTRAINTS ON countries START - ADDING CONSTRAINTS ON customerassignments FINISH - ADDING CONSTRAINTS ON customerassignments START - ADDING CONSTRAINTS ON customercontacts FINISH - ADDING CONSTRAINTS ON customercontacts START - ADDING CONSTRAINTS ON customergroups FINISH - ADDING CONSTRAINTS ON customergroups START - ADDING CONSTRAINTS ON customers FINISH - ADDING CONSTRAINTS ON customers START - ADDING CONSTRAINTS ON customersview FINISH - ADDING CONSTRAINTS ON customersview START - ADDING CONSTRAINTS ON daemonconfig FINISH - ADDING CONSTRAINTS ON daemonconfig START - ADDING CONSTRAINTS ON daemoninstances FINISH - ADDING CONSTRAINTS ON daemoninstances START - ADDING CONSTRAINTS ON dbinfo FINISH - ADDING CONSTRAINTS ON dbinfo START - ADDING CONSTRAINTS ON debitnotecontents FINISH - ADDING CONSTRAINTS ON debitnotecontents START - ADDING CONSTRAINTS ON divisions FINISH - ADDING CONSTRAINTS ON divisions START - ADDING CONSTRAINTS ON docrights FINISH - ADDING CONSTRAINTS ON docrights START - ADDING CONSTRAINTS ON documentcontents FINISH - ADDING CONSTRAINTS ON documentcontents START - ADDING CONSTRAINTS ON documents FINISH - ADDING CONSTRAINTS ON documents START - ADDING CONSTRAINTS ON domains FINISH - ADDING CONSTRAINTS ON domains START - ADDING CONSTRAINTS ON eventassignments FINISH - ADDING CONSTRAINTS ON eventassignments START - ADDING CONSTRAINTS ON events FINISH - ADDING CONSTRAINTS ON events START - ADDING CONSTRAINTS ON ewx_channels FINISH - ADDING CONSTRAINTS ON ewx_channels START - ADDING CONSTRAINTS ON ewx_pt_config FINISH - ADDING CONSTRAINTS ON ewx_pt_config START - ADDING CONSTRAINTS ON ewx_stm_channels FINISH - ADDING CONSTRAINTS ON ewx_stm_channels START - ADDING CONSTRAINTS ON ewx_stm_nodes FINISH - ADDING CONSTRAINTS ON ewx_stm_nodes START - ADDING CONSTRAINTS ON excludedgroups FINISH - ADDING CONSTRAINTS ON excludedgroups START - ADDING CONSTRAINTS ON hosts FINISH - ADDING CONSTRAINTS ON hosts START - ADDING CONSTRAINTS ON imessengers FINISH - ADDING CONSTRAINTS ON imessengers START - ADDING CONSTRAINTS ON invoicecontents FINISH - ADDING CONSTRAINTS ON invoicecontents START - ADDING CONSTRAINTS ON liabilities FINISH - ADDING CONSTRAINTS ON liabilities START - ADDING CONSTRAINTS ON macs FINISH - ADDING CONSTRAINTS ON macs START - ADDING CONSTRAINTS ON messageitems FINISH - ADDING CONSTRAINTS ON messageitems START - ADDING CONSTRAINTS ON messages FINISH - ADDING CONSTRAINTS ON messages START - ADDING CONSTRAINTS ON nastypes FINISH - ADDING CONSTRAINTS ON nastypes START - ADDING CONSTRAINTS ON netdevices FINISH - ADDING CONSTRAINTS ON netdevices START - ADDING CONSTRAINTS ON netlinks FINISH - ADDING CONSTRAINTS ON netlinks START - ADDING CONSTRAINTS ON networks FINISH - ADDING CONSTRAINTS ON networks START - ADDING CONSTRAINTS ON nodeassignments FINISH - ADDING CONSTRAINTS ON nodeassignments START - ADDING CONSTRAINTS ON nodegroupassignments FINISH - ADDING CONSTRAINTS ON nodegroupassignments START - ADDING CONSTRAINTS ON nodegroups FINISH - ADDING CONSTRAINTS ON nodegroups START - ADDING CONSTRAINTS ON nodes FINISH - ADDING CONSTRAINTS ON nodes START - ADDING CONSTRAINTS ON numberplanassignments FINISH - ADDING CONSTRAINTS ON numberplanassignments START - ADDING CONSTRAINTS ON numberplans FINISH - ADDING CONSTRAINTS ON numberplans START - ADDING CONSTRAINTS ON passwd FINISH - ADDING CONSTRAINTS ON passwd START - ADDING CONSTRAINTS ON payments FINISH - ADDING CONSTRAINTS ON payments START - ADDING CONSTRAINTS ON promotionassignments FINISH - ADDING CONSTRAINTS ON promotionassignments START - ADDING CONSTRAINTS ON promotions FINISH - ADDING CONSTRAINTS ON promotions START - ADDING CONSTRAINTS ON promotionschemas FINISH - ADDING CONSTRAINTS ON promotionschemas START - ADDING CONSTRAINTS ON receiptcontents FINISH - ADDING CONSTRAINTS ON receiptcontents START - ADDING CONSTRAINTS ON records FINISH - ADDING CONSTRAINTS ON records START - ADDING CONSTRAINTS ON rtattachments FINISH - ADDING CONSTRAINTS ON rtattachments START - ADDING CONSTRAINTS ON rtmessages FINISH - ADDING CONSTRAINTS ON rtmessages START - ADDING CONSTRAINTS ON rtnotes FINISH - ADDING CONSTRAINTS ON rtnotes START - ADDING CONSTRAINTS ON rtqueues FINISH - ADDING CONSTRAINTS ON rtqueues START - ADDING CONSTRAINTS ON rtrights FINISH - ADDING CONSTRAINTS ON rtrights START - ADDING CONSTRAINTS ON rttickets FINISH - ADDING CONSTRAINTS ON rttickets START - ADDING CONSTRAINTS ON sessions FINISH - ADDING CONSTRAINTS ON sessions START - ADDING CONSTRAINTS ON sourcefiles FINISH - ADDING CONSTRAINTS ON sourcefiles START - ADDING CONSTRAINTS ON states FINISH - ADDING CONSTRAINTS ON states START - ADDING CONSTRAINTS ON stats FINISH - ADDING CONSTRAINTS ON stats START - ADDING CONSTRAINTS ON supermasters FINISH - ADDING CONSTRAINTS ON supermasters START - ADDING CONSTRAINTS ON tariffs FINISH - ADDING CONSTRAINTS ON tariffs START - ADDING CONSTRAINTS ON taxes FINISH - ADDING CONSTRAINTS ON taxes START - ADDING CONSTRAINTS ON uiconfig FINISH - ADDING CONSTRAINTS ON uiconfig START - ADDING CONSTRAINTS ON up_customers FINISH - ADDING CONSTRAINTS ON up_customers START - ADDING CONSTRAINTS ON up_help FINISH - ADDING CONSTRAINTS ON up_help START - ADDING CONSTRAINTS ON up_info_changes FINISH - ADDING CONSTRAINTS ON up_info_changes START - ADDING CONSTRAINTS ON up_rights FINISH - ADDING CONSTRAINTS ON up_rights START - ADDING CONSTRAINTS ON up_rights_assignments FINISH - ADDING CONSTRAINTS ON up_rights_assignments START - ADDING CONSTRAINTS ON users FINISH - ADDING CONSTRAINTS ON users START - ADDING CONSTRAINTS ON vmacs FINISH - ADDING CONSTRAINTS ON vmacs START - ADDING CONSTRAINTS ON vnodes FINISH - ADDING CONSTRAINTS ON vnodes START - ADDING CONSTRAINTS ON vnodes_mac FINISH - ADDING CONSTRAINTS ON vnodes_mac START - ADDING CONSTRAINTS ON voipaccounts FINISH - ADDING CONSTRAINTS ON voipaccounts START - ADDING CONSTRAINTS ON zipcodes FINISH - ADDING CONSTRAINTS ON zipcodes DONE CREATING INDEXES AND CONSTRAINTS >>>>>>>>>> FINISHED <<<<<<<<<< #v- Zadowolony, że nie było błędów odpalam przeglądarke z lms a tu na dole widzę błąd: #v+ Napotkano błędy w bazie danych! Zapytanie: SELECT section, var, value FROM uiconfig WHERE disabled=0 Błąd: ERROR: operator does not exist: boolean = integer LINE 1: SELECT section, var, value FROM uiconfig WHERE disabled=0 ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. #v- który powoduje, że nie mogę się nawet zalogować #v+ Napotkano błędy w bazie danych! Zapytanie: SELECT section, var, value FROM uiconfig WHERE disabled=0 Błąd: ERROR: operator does not exist: boolean = integer LINE 1: SELECT section, var, value FROM uiconfig WHERE disabled=0 ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. Zapytanie: SELECT id, name, passwd, hosts, lastlogindate, lastloginip FROM users WHERE login='marceli' AND deleted=0 Błąd: ERROR: operator does not exist: boolean = integer LINE 2: FROM users WHERE login='marceli' AND deleted=0 ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. #v- jak przeglądam bazę z phppgadmina (niestety jesze nie znam dobrze interfesju postgresa) to widzę, iż zniknęły widoki. może będzie ktoś tak dobry i podpowie step by step jak bezboleśnie przebrnąć przez migracje? -- Pozdrawiam Marcin / nicraM

3 5

coś co można uznać na nową wersję LMS-a numerowaną jako 1.11.14
by Tomasz Chiliński 17 Maj '13

17 Maj '13

Witam, Dziś oznaczyłem wersję z 24 kwietnia 2013 w github.com jako wersję 1.11.14: https://github.com/lmsgit/lms/tree/LMS_011114 Jako, że późniejsze zmiany w LMS są bardzo inwazyjne uznałem, że będzie najlepiej jak da się trochę odetchnąć użytkownikom LMS-a korzystając z tego w miarę stabilnej migawki. Jest to wyłącznie znacznik (tag) w repozytorium git, a bieżące poprawki będą nanoszone wyłącznie w bieżącej gałęzi master. Zapraszam to testów wersji bieżących z gałęzi master, a kto nie ma na to czasu, może pozostać przy wersji dzisiaj oznakowanej właśnie jako LMS_011114. -- Pozdrawiam Tomasz Chiliński, Chilan

10 25

Re: [lms] szablon faktury z druczkiem wpłaty
by Sławomir Paszkiewicz 17 Maj '13

17 Maj '13

W dniu 17.05.2013 14:48, Michał Bochniak pisze: > > Witam > > Poratuje ktoś działającym szablonem faktury z druczkiem wpłaty > pod dirę? > > Potrzebuję aby na fakturze wyświetlał się numer indywidualny > konta każdego klienta. > > No to wywalasz ze stopki/opisu numer konta i w szablonie masz > bankaccount > > Dokładniej, to w Konfiguracja>Firmy (Oddziały) > Firma > "Stopka > faktury" dodałem %bankaccount jako informację, ale same numery konta w > druczku pojawiają się automatycznie. > > Ok tylko przy standardowym szablonie nie mam ani druczka wpłaty a > dodając samo %bankaccount w stopce na fakturze mam %bankaccount > > > > _______________________________________________ > lms mailing list > lms(a)lists.lms.org.pl > http://lists.lms.org.pl/mailman/listinfo/lms Konfiguracja>Interfejs uzytkownika>template_file: FT-0100 i będzie ten druczek. Co do %bankaccount to musiałbyś sprawdzić czy to nie weszło w wersji GIT. Jeśli tak - upgraduj lub tylko tę zmianę przeportuj :)

2 1

Re: [lms] szablon faktury z druczkiem wpłaty
by Sławomir Paszkiewicz 17 Maj '13

17 Maj '13

W dniu 17.05.2013 13:54, Michał Bochniak pisze: > > Witam > > Poratuje ktoś działającym szablonem faktury z druczkiem wpłaty pod dirę? > > Potrzebuję aby na fakturze wyświetlał się numer indywidualny konta > każdego klienta. > > .................. > pozdrawiam > Bochniak Michał > cid:image001.jpg@01CD1E7D.65413550 > *Zapnet Spółka Jawna* > ul. Leśna 1 > 63-430 Odolanów > tel.: +48 62 597 70 83 > fax: +48 62 597 70 93 > kom.: +48 502 531 940 > email: michal.bochniak(a)zapnet.pl <mailto:michal.bochniak@zapnet.pl> > www.zapnet.pl <http://www.zapnet.pl/> > > > > _______________________________________________ > lms mailing list > lms(a)lists.lms.org.pl > http://lists.lms.org.pl/mailman/listinfo/lms No to wywalasz ze stopki/opisu numer konta i w szablonie masz bankaccount

2 2

szablon faktury z druczkiem wpłaty
by Michał Bochniak 17 Maj '13

17 Maj '13

Witam Poratuje ktoś działającym szablonem faktury z druczkiem wpłaty pod dirę? Potrzebuję aby na fakturze wyświetlał się numer indywidualny konta każdego klienta. bochniak.malpa.onet.eu

1 0

szablon faktury z druczkiem wpłaty
by Michał Bochniak 17 Maj '13

17 Maj '13

Witam Poratuje ktoś działającym szablonem faktury z druczkiem wpłaty pod dirę? Potrzebuję aby na fakturze wyświetlał się numer indywidualny konta każdego klienta. .................. pozdrawiam Bochniak Michał cid:image001.jpg@01CD1E7D.65413550 Zapnet Spółka Jawna ul. Leśna 1 63-430 Odolanów tel.: +48 62 597 70 83 fax: +48 62 597 70 93 kom.: +48 502 531 940 email: <mailto:michal.bochniak@zapnet.pl> michal.bochniak(a)zapnet.pl <http://www.zapnet.pl/> www.zapnet.pl

1 0

Odp: Problem z bazą lms
by mis misiowy 16 Maj '13

16 Maj '13

7 9

Problem z bazą lms
by Sliw.net 14 Maj '13

14 Maj '13

Witam, mam prośbe, wczoraj w rannych godzinach wpolnik chciał dostać się standardowo do lmsa, a ten powitał go kominikatem o błedzie bazy danych ( niestety nie mam tego komunikatu ) natomiast teraz skrypt wpuszcza bez hasła i brak w nim danych . Czy możecie coś pomóc ?

2 1

Usunięcie klienta-usuniete komputery i zobowiązania
by LoLe 13 Maj '13

13 Maj '13

Czy mógby ktoś uzasadnić dlaczego usunięcie klienta powoduje usunięcie również komputerów i zobowiązań? Przypuszczam że z komputerami to pewnei kwestia mac i ip, które były by zajęte, ale to można było by jakoś obsłużyć komunikatami.

5 7

integracja PNA z LMS (kontynuacja)
by Tomasz Chiliński 11 Maj '13

11 Maj '13

Witam, co Wy na to, żeby w końcu dalej to ruszyć? http://www.poczta-polska.pl/spis-pna/ W sumie za 122 zł rocznie można mieć ten spis w sensownej postaci txt i wtedy pewnie mój skrypt lms-pna.php lepiej z tym sobie poradzi. Są chętni na zrzutkę na roczny abonament PNA w PP? ;-) -- Pozdrawiam Tomasz Chiliński, Chilan

5 7

Re: [lms] brak przypisania promocji
by Marcin 09 Maj '13

09 Maj '13

W dniu 9 maja 2013 12:12 użytkownik Michał Bochniak <michal.bochniak(a)zapnet.pl> napisał: > Chciałem przypisać zobowiązanie promocyjne dla klienta, jednak jest problem. > Tworzę jakąś promocję, przy dodaniu zobowiązania dla klienta nic się nie > dopisuje. Czy to jest Bug czy coś pominąłem? Jak przeskoczyć ten problem? Którą wersje lmsa masz? w gicie to działa w Dira niestety nie -- Pozdrawiam Marcin / nicraM

3 3

brak przypisania promocji
by Michał Bochniak 09 Maj '13

09 Maj '13

Witam Chciałem przypisać zobowiązanie promocyjne dla klienta, jednak jest problem. Tworzę jakąś promocję, przy dodaniu zobowiązania dla klienta nic się nie dopisuje. Czy to jest Bug czy coś pominąłem? Jak przeskoczyć ten problem?

1 0

wysyłanie FV
by INTERCONNECT - Krzysztof Gambuś 07 Maj '13

07 Maj '13

Witam, spotkał się ktoś z problemem wysyłania FV przez gmaila, od pewnego czasu, jakieś 2 miesiące gdy wysyłam wszystkie fv z abonamentem to wyśle się około 114 FV reszta nie wysyła się. błąd:Couldn't send mail: 421 4.7.0 Temporary System Problem. Try again later (SF). q42sm10396055eem.14 - gsmtp at /sbin/lms-sendinvoices line 292 -- *Interconnect Sp.j.* R. Wróbel, K. Gambuś ul. 1 Maja 84 42-660 Kalety KRS 0000329294 tel. 507118259

3 3

dodawanie pozycji na fakturze a wylogowanie
by Marcin S. 05 Maj '13

05 Maj '13

Witam Mam taki przypadek kilkanaście dodanych zobowiązań dla klienta i gdy daję Nowa Faktura i potem na liście zaznaczam zobowiązania i daję dodaj lms mnie wylogowuje może ktoś mi podpowiedzieć gdzie szukać problemu? pozycji chcę dodać około 65... Z góry wielkie dzięki za pomoc -- Z poważaniem Marcin Sadowski Neptun Marianna Sadowska ul. Konarskiego 2/10 09-140 Raciąż 567-103-34-89 http://gdzienet.pl/preview/raciaz

3 4