Witam.

Próbuję zrobić upgrade LMS z DB: 2015121100 do wersji aktualnej i sypie błędami sql.
mysql: 5.5.47-0+deb7u1-log

po tym upgrade brak komputerow,
w kliencie: rozjechane adresy (siedziba, korespondencja, lokalizacyjny)
w urzadzeniach pomimo adresacji teryt w edycji nie uzupelnia sie wojewodztwo

wiem ze wersja wiekowa ale w zasadzie powinno sie wykonac od najstarszej ;)

pozdrawiam

DB:2017013100
Zapytanie: INSERT INTO customer_addresses (customer_id, address_id, type) VALUES ('319','1116',3)
Błąd: Cannot add or update a child row: a foreign key constraint fails (`lmstest`.`customer_addresses`, CONSTRAINT `customer_addresses_customer_id_fk` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE)

DB:2017013101
Zapytanie: CREATE VIEW vnodes AS SELECT n.*, m.mac, a.city_id as location_city, a.street_id as location_street, a.house as location_house, a.flat as location_flat, ( trim(both ' ' from CASE WHEN a.city is not null AND char_length(city) > 0 THEN CASE WHEN a.street is not null AND char_length(street) > 0 THEN a.city || ', ' || a.street ELSE a.street END ELSE CASE WHEN a.street is not null AND char_length(street) > 0 THEN a.street ELSE '' END END || CASE WHEN a.house is not null THEN CASE WHEN a.flat is not null THEN ' ' || a.house || '/' || a.flat ELSE ' ' || a.house END ELSE CASE WHEN a.flat is not null THEN ' ' || a.flat ELSE '' END END )) AS location FROM nodes n LEFT JOIN vnodes_mac m ON (n.id = m.nodeid) LEFT JOIN addresses a ON n.address_id = a.id WHERE n.ipaddr <> 0 OR n.ipaddr_pub <> 0;
Błąd: View 'lmstest.vnodes_mac' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them

DB:2017022200
Zapytanie: CREATE VIEW vnodes AS SELECT n.*, m.mac, a.city_id as location_city, a.street_id as location_street, a.house as location_house, a.flat as location_flat, ( trim(both ' ' from CONCAT( CASE WHEN a.city is not null AND char_length(city) > 0 THEN CASE WHEN a.street is not null AND char_length(street) > 0 THEN CONCAT(a.city, ', ', a.street) ELSE a.street END ELSE CASE WHEN a.street is not null AND char_length(street) > 0 THEN a.street ELSE '' END END, CASE WHEN a.house is not null THEN CASE WHEN a.flat is not null THEN CONCAT(' ', a.house, '/', a.flat) ELSE CONCAT(' ', a.house) END ELSE CASE WHEN a.flat is not null THEN CONCAT(' ', a.flat) ELSE '' END END) )) AS location FROM nodes n LEFT JOIN vnodes_mac m ON (n.id = m.nodeid) LEFT JOIN addresses a ON n.address_id = a.id WHERE n.ipaddr <> 0 OR n.ipaddr_pub <> 0;
Błąd: View 'lmstest.vnodes_mac' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them

DB:2017030800
Zapytanie: CREATE VIEW vnodes AS SELECT n.*, m.mac, a.city_id as location_city, a.street_id as location_street, a.house as location_house, a.flat as location_flat, a.location FROM nodes n LEFT JOIN vnodes_mac m ON (n.id = m.nodeid) LEFT JOIN vaddresses a ON n.address_id = a.id WHERE n.ipaddr <> 0 OR n.ipaddr_pub <> 0;
Błąd: View 'lmstest.vnodes_mac' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them

DB:2017031000
Zapytanie: ALTER TABLE events ADD CONSTRAINT 'event_ticketid_rttickets_id_fk' FOREIGN KEY (ticketid) REFERENCES rttickets (id) ON DELETE SET NULL ON UPDATE CASCADE
Błąd: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''event_ticketid_rttickets_id_fk' FOREIGN KEY (ticketid) REFERENCES rttickets (id' at line 1

DB:2017031400
Zapytanie: CREATE VIEW vnodes AS SELECT n.*, m.mac, a.city_id as location_city, a.street_id as location_street, a.house as location_house, a.flat as location_flat, a.location FROM nodes n LEFT JOIN vnodes_mac m ON (n.id = m.nodeid) LEFT JOIN vaddresses a ON n.address_id = a.id WHERE n.ipaddr <> 0 OR n.ipaddr_pub <> 0;
Błąd: View 'lmstest.vnodes_mac' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them

DB:2017031500
Zapytanie: CREATE VIEW vnodes AS SELECT n.*, m.mac, a.city_id as location_city, a.street_id as location_street, a.house as location_house, a.flat as location_flat, a.location FROM nodes n LEFT JOIN vnodes_mac m ON (n.id = m.nodeid) LEFT JOIN vaddresses a ON n.address_id = a.id WHERE n.ipaddr <> 0 OR n.ipaddr_pub <> 0;
Błąd: View 'lmstest.vnodes_mac' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them

DB:2017031600
Zapytanie: DROP VIEW customerview, contractorview, customeraddressview, vmacs, vnetworks, vnodes, vaddresses
Błąd: Unknown table 'vnodes'
Zapytanie: CREATE VIEW vnodes AS SELECT n.*, m.mac, a.city_id as location_city, a.street_id as location_street, a.house as location_house, a.flat as location_flat, a.location FROM nodes n LEFT JOIN vnodes_mac m ON m.nodeid = n.id LEFT JOIN vaddresses a ON n.address_id = a.id WHERE n.ipaddr <> 0 OR n.ipaddr_pub <> 0
Błąd: View 'lmstest.vnodes_mac' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them

DB:2017032000
Zapytanie: DROP VIEW customerview, contractorview, customeraddressview, vmacs, vnetworks, vnodes, vaddresses, vdivisions
Błąd: Unknown table 'vnodes'
Zapytanie: CREATE VIEW vnodes AS SELECT n.*, m.mac, a.city_id as location_city, a.street_id as location_street, a.house as location_house, a.flat as location_flat, a.location FROM nodes n LEFT JOIN vnodes_mac m ON m.nodeid = n.id LEFT JOIN vaddresses a ON n.address_id = a.id WHERE n.ipaddr <> 0 OR n.ipaddr_pub <> 0
Błąd: View 'lmstest.vnodes_mac' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them

DB:2017041800(finalna)
Zapytanie: DROP VIEW customerview, contractorview, customeraddressview, vmacs, vnetworks, vnodes, vdivisions, vaddresses
Błąd: Unknown table 'vnodes'
Zapytanie: CREATE VIEW vnodes AS SELECT n.*, m.mac, a.city_id as location_city, a.street_id as location_street, a.house as location_house, a.flat as location_flat, a.location FROM nodes n LEFT JOIN vnodes_mac m ON m.nodeid = n.id LEFT JOIN vaddresses a ON n.address_id = a.id WHERE n.ipaddr <> 0 OR n.ipaddr_pub <> 0
Błąd: View 'lmstest.vnodes_mac' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them





-- 
Pozdrawiam
Michał Szmigielski
/ernesttar/